Time Value of Money0:18:00
| 1.01 | Time Value of Money: Formula and NPV, IRR | 0:09:03 | ||
| 1.02 | Solutions - Time Value of Money: Formula and NPV, IRR | 0:04:23 | ||
| 2.01 | Time Value of Money: XIRR, XNPV | 0:02:52 | ||
| 2.02 | Solutions - Time Value of Money: XIRR, XNPV | 0:01:42 |
What-if Analysis0:14:09
| 3.01 | The PMT Function and What-if-Analysis | 0:10:18 | ||
| 3.02 | Solutions - The PMT Function and What-if-Analysis | 0:03:51 |
Future Value0:05:42
| 4.01 | Future Value and the Number of Periods, FV and NPER | 0:03:30 | ||
| 4.02 | Solutions - Future Value and the Number of Periods, FV and NPER | 0:02:12 |
Amortization0:09:21
| 5.01 | Creating an Amortization Table: PMT, PPMT, IPMT | 0:06:10 | ||
| 5.02 | Solutions - Creating an Amortization Table: PMT, PPMT, IPMT | 0:03:11 |
Depreciation0:05:28
| 6.01 | Depreciation Functions SLN, SYD, DB | 0:03:16 | ||
| 6.02 | Solutions - Depreciation Functions SLN, SYD, DB | 0:02:12 |
Case Study0:11:48
| 7.01 | Fitting Curves | 0:03:08 | ||
| 7.02 | Introducing the Solver | 0:04:01 | ||
| 7.03 | Case Study Solution | 0:04:39 |