Coursera Plus Annual is 40% Off — Ends July 6.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Coursera

Financial Modeling with NPV and IRR

EDUCBA via Coursera

Go to class Write review

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
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.

Syllabus

  • Foundations of Financial Growth in Excel
    • 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.
  • Cash Flow Analysis & Valuation Techniques
    • Analyze multiple cash flows and perform investment evaluation using DCF, NPV, and IRR to make data-driven financial decisions.
  • Advanced Investment Evaluation Tools
    • Apply advanced Excel functions like XNPV, XIRR, PMT, PPMT, and IPMT to evaluate irregular cash flows and structure loan repayment models.
  • Fixed Income & Loan Analytics
    • Understand bond pricing, yield calculations, and duration to evaluate fixed-income investments and interest rate risk.

Taught by

EDUCBA

Reviews

Start your review of Financial Modeling with NPV and IRR

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.