Coursera

Financial Modeling with Excel NPV

Coursera

Financial Modeling with Excel NPV

LearningMate

Instructor: LearningMate

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

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

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

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

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

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

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

LearningMate
246 Courses 16,579 learners

Offered by

Coursera

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."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions

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