Financial Modeling with Excel NPV

Grow your skills with Coursera Plus for $239/year (usually $399). Save now.

Financial Modeling with Excel NPV

Instructor: LearningMate

2 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 hours to complete

Flexible schedule

Learn at your own pace

2 modules

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

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

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

Hands-On Learning: Proficiency in Present Value Calculations 20 minutes
Advanced Valuation with XNPV and Comparative Analysis Quiz 5 minutes
Final Project: The "Efficiency vs. Expansion" Capital Budgeting Decision 30 minutes

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

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

Learn more

Advance your career with an online degree

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

Explore degrees

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

Upskill your employees to excel in the digital economy

Learn more

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.