Financial Modeling with NPV and IRR

About this course

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.