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.

Financial Modeling with Excel NPV

Financial Modeling with Excel NPV
This course is part of DCF, Comps, and Scenarios: Financial Modeling and Valuation Specialization

Instructor: LearningMate
Access provided by University of the Philippines, OIL
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.
Skills you'll gain
Tools you'll learn
Details to know

Shareable certificate
Add to your LinkedIn profile
Taught in English
Recently updated!
March 2026
See how employees at top companies are mastering in-demand skills

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
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

274 Courses17,943 learners
Offered by
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."
Explore more from Business
¹ Some assignments in this course are AI-graded. For these assignments, your data will be used in accordance with Coursera's Privacy Notice.




