Lesson 6 of 6

The analyst's spreadsheet

Module 02 · Money math you actually need

The analyst's spreadsheet

Set up a sheet the analyst way (years across, items down, inputs one colour, formulas another) and use growth, CAGR, NPV and IRR formulas.

9 min6 short steps

Step 1 of 6

Why this matters

Everything in this module (compounding, present value, returns, scenarios) is quick in a spreadsheet and slow on paper. Every analyst lives in one.

But messy sheets hide mistakes: a number typed inside a formula, or growth counted over the wrong number of years. A few habits stop that.