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.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.
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.