Download NPV Models

These NPV Models are referenced by the book Net Present Value and Risk Modelling for Projects and built using Excel 2010.

Model 2.2 - A simple model illustrating the NPV method of calculation

Model 4.1 - A worked example of a draft model built for a project owned by a company in the space industry. This is the same model as the worked example detailed here

Model 4.2 - A variant of Model 4.1 that includes inflation in costs and benefits and takes a different approach to the modelling of taxation.

Model 4.3 - a variation of Model 4.2 that simulates the option of the space company using one of its environmental test chambers for hiring to customers rather than the support of a project such as that represented by Models 4.1 and 4.2.

Notes

The models use the following colour/font coding:

  • inputs - black / bold
  • calculations - black
  • output (Project NPV) - purple/ larger font / bold

The assumptions identified at the top of Models 4.1, 4.2 and 4.3 are implicit, but should be recognised as being an important part of the modelling process.

Please also read the notes at the bottom of the sheet in each model.