VOOZH about

URL: https://www.coursera.org/learn/financial-modeling-with-excel-npv

⇱ Financial Modeling with Excel NPV | Coursera

Financial Modeling with Excel NPV

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

Financial Modeling with Excel NPV

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 hours to complete
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

2 hours to complete
Flexible schedule
Learn at your own pace

What you'll learn

  • Value periodic and irregular cash flows in MS Excel using NPV and XNPV functions and analyze the results to make sound financial decisions.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

March 2026

Assessments

5 assignments¹

AI Graded see disclaimer
Taught in English

Build your subject-matter expertise

This course is part of the DCF, Comps, and Scenarios: Financial Modeling and Valuation Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 2 modules in this course

Master the art of investment valuation in this hands-on course on Financial Modeling with Excel. Designed for aspiring financial analysts and professionals, this course moves beyond theory to provide practical skills in valuing cash flows using Excel's powerful NPV and XNPV functions. You will learn to differentiate between periodic and irregular cash flows, understand the critical role of the discount rate, and apply the correct function for precise, real-world financial analysis. By the end of this course, you will be able to build robust capital budgeting models, compare investment opportunities, and make data-driven financial decisions with confidence. This course is essential for anyone involved in financial analysis, project appraisal, or capital budgeting who needs to create defensible valuation models.

This module introduces foundational financial concepts related to the time value of money and the NPV function. Learners will explore the core principles that underpin financial valuation and gain the ability to articulate the syntax, inputs, and underlying financial logic of the NPV function.

What's included

2 videos1 reading2 assignments

2 videos•Total 16 minutes
  • The Real Cost of Ignoring Cash Flow Timing•8 minutes
  • Building Your First Valuation Model with NPV•8 minutes
1 reading•Total 9 minutes
  • The Language of Value: Deconstructing the NPV Formula•9 minutes
2 assignments•Total 25 minutes
  • Hands-On Learning: Recall and Apply NPV Fundamentals•20 minutes
  • NPV Fundamentals Quiz•5 minutes

This module delves into the complexities of irregular cash flows and the use of the XNPV function. Learners will analyze the differences between NPV and XNPV outputs and understand when to apply each function for precise valuation.

What's included

2 videos1 reading3 assignments

2 videos•Total 14 minutes
  • Understanding XNPV: Key Concepts•7 minutes
  • Modeling Irregular Cash Flows with XNPV•8 minutes
1 reading•Total 9 minutes
  • When Regular Payments Aren't Reality: Introducing XNPV•9 minutes
3 assignments•Total 55 minutes
  • Final Project: The "Efficiency vs. Expansion" Capital Budgeting Decision•30 minutes
  • Hands-On Learning: Proficiency in Present Value Calculations•20 minutes
  • Advanced Valuation with XNPV and Comparative Analysis Quiz•5 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

276 Courses•32,516 learners

Why people choose Coursera for their career

👁 Image

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."
👁 Image

Jennifer J.

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

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."
👁 Image

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 enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. 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.

Financial aid available,

¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.