Watch
- CAGR explained — The Finance Storyteller, 7:44. Watch 6:13–7:11 for calculating CAGR in Excel.
Read / use
- OpenStax Principles of Finance 16.6 — Using Excel to Make Company Investment Decisions — free textbook section on NPV and IRR in Excel (CC BY-NC-SA 4.0).
- OpenStax Principles of Finance 9.2 — Unequal Payments Using a Financial Calculator or Excel — NPV of uneven cash flows with a financial calculator and Excel's NPV function (CC BY-NC-SA 4.0).
- SEC — EDGAR APIs — where the XBRL data in this lesson comes from. Technical; for later.
- Damodaran — Spreadsheets — a professor's free valuation spreadsheets. Advanced; come back after the valuation modules.