NPV Calculator

For all those looking for some easy peasy NPV calculations I put together a spreadsheet. Please note, I am always open to improvement so if you see something that can make it better please let me know.

Just fill in the yellow boxes (I have locked down discount rate at 10% and inflation at 3%, if you know enough to want to play with that let me know and I will give you the unlock password).  Select 10 or 15 year project life, and the spreadsheet will auto manipulate. This is focused around energy savings projects but you can use anything with a cash flow that will accelerate with inflation.

NPV calculator simplified

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s