Joshua Kahr – Time Value of Money
Learn the core concepts of time value of money and how to apply them in Excel.
The fundamental building block of all of finance is “time value”. Unfortunately, it’s poorly taught at most universities.
In this course, I walk you through how to build time value of money problems in Excel, and I do all of it without using a single Powerpoint slide.
We’ll cover the essentials (PV, FV, etc.), IRR, NPV and by the end we’ll discuss some of Excel’s particular creations including XIRR and XNPV.
Best of all, you’ll have Excel worksheets for all of it so if you get stuck, you’ll be able to follow along on the worksheet.
Even if you tried to learn this before or you forgot what you learned years ago, I think you’ll like my Excel based approach.
What You’ll Learn In Time Value of Money
- Welcome to the course!
- Future Value
- Present Value
- Future Value of an Annuity
- Present Value of an Annuity
- Internal Rate of Return
- Net Present Value
- Other Examples of IRR and NPV
- The Five Functions of a Dollar
- Extra: How Does PMT Work?
- Extra: Annual Vs. Monthly Vs. Daily Compounding
- XIRR and XNPV
- MIRR (Modified Internal Rate of Return)
Sale Page: Joshua Kahr – Time Value of Money