Financial Modeling with NPV and IRR

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Financial Modeling with NPV and IRR

Instructor: EDUCBA

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

8 hours to complete

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

8 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Apply hedging strategies using futures, forwards, options, and swaps to manage financial risk.
Analyze fair value, cash flow, and foreign currency hedges in real-world business scenarios.
Interpret hedge accounting treatments and evaluate their impact on financial statements.

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 4 modules in this course

Master financial functions in Excel and unlock real-world finance skills. Learn NPV, IRR, DCF, and bond analysis step by step.

This course is designed to help you confidently apply financial concepts using Excel, even if you are a beginner. You will learn how to calculate future and present values, analyze cash flows, evaluate investments, and build loan and bond models. Starting with the fundamentals of time value of money, the course progresses into advanced topics like DCF valuation, NPV, IRR, XNPV, and XIRR. You will also learn how to structure loan payments using PMT functions and analyze fixed-income instruments like bonds, including pricing, yield, and duration. By the end of this course, you will be able to make informed financial decisions, evaluate investments, and apply Excel-based financial modeling techniques used in real-world finance roles.

Learn the fundamentals of time value of money and apply Excel financial functions like FV, PV, NPER, and RATE to evaluate investment growth and present value.

What's included

7 videos4 assignments

7 videosTotal 46 minutes

Introduction2 minutes
Understanding Future Value12 minutes
Future Value Continues4 minutes
Calculating Simple And Compound Interest10 minutes
Si And Ci Continues3 minutes
Understanding Pv9 minutes
Calculate Nper And Rate6 minutes

4 assignmentsTotal 60 minutes

Foundations of Financial Growth in Excel30 minutes
Getting Started with Financial Concepts10 minutes
Mastering Future Value CalculationsUntitled10 minutes
Present Value Essentials10 minutes

Analyze multiple cash flows and perform investment evaluation using DCF, NPV, and IRR to make data-driven financial decisions.

What's included

6 videos4 assignments

6 videosTotal 46 minutes

Lender And Borrower Fv4 minutes
Multiple Cash Flows9 minutes
Multiple Cash Flows Continues8 minutes
Asset Valuation Using Dcf Analysis7 minutes
Understanding Npv And Irr8 minutes
Understanding Npv And Irr And Graph8 minutes

4 assignmentsTotal 60 minutes

Cash Flow Analysis & Valuation Techniques30 minutes
Future Value from Different Perspectives10 minutes
Handling Complex Cash Flows10 minutes
Investment Decision Metrics10 minutes

Apply advanced Excel functions like XNPV, XIRR, PMT, PPMT, and IPMT to evaluate irregular cash flows and structure loan repayment models.

What's included

6 videos4 assignments

6 videosTotal 37 minutes

Understanding Npv And Irr Continues8 minutes
Understanding Xnpv3 minutes
Understanding Xirr3 minutes
Understanding The Pmt Functions11 minutes
Pmt Functions Continues6 minutes
Understanding Ppmt And Ipmt7 minutes

4 assignmentsTotal 60 minutes

Advanced Investment Evaluation Tools30 minutes
Deep Dive into NPV & IRR10 minutes
Advanced IRR Techniques10 minutes
Loan Payment Structures10 minutes

Understand bond pricing, yield calculations, and duration to evaluate fixed-income investments and interest rate risk.

What's included

4 videos3 assignments

Instructor

EDUCBA

1,618 Courses334,775 learners

Offered by

EDUCBA

Explore more from Finance

Status: Free Trial
Coursera
Financial Modeling with Excel NPV
Course
Packt
Project Finance & Excel: Build Financial Models from Scratch
Course
Status: Free Trial
EDUCBA
Project Finance Modeling and Investment Analysis
Course
Status: Free Trial
Coursera
Financial Valuation and Deal Modeling with Excel
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.