Modelling Recurring and Project-Specific Cash Flows

This video covers the following learning objectives:

1. Define and distinguish between ordinary annuities, annuities due, and perpetuities.
2. Apply Excel’s PV() and FV() functions to model annuity cash flows.
3. Calculate the present value of both standard and growing perpetuities using Excel.
4. Build flexible cash flow tables for irregular, project-specific scenarios.
5. Apply NPV() in Excel to value uneven project cash flows with an initial investment.
6. Integrate driver-based logic (e.g., units × price) into cash flow projections.
7. Apply best practices in structuring capital project models in Excel.
8. Identify common use cases for annuity and project-specific cash flow modelling.