top of page

Excel 101

All the essentials you need to know about navigating and building financial models using Microsoft Excel.

Back calculate for an exit value

Use this methodology to find the exit value of any investment

Using the NPV function

Simple example of how NPV in Excel works

Using SUM OFFSET to model depreciation

Construct a one-liner for modelling simple straight line depreciation

Scenario analysis using INDEX MATCH

Using the INDEX() and MATCH() function to run scenario analysis

bottom of page