Search This Blog

Loading...

3 June 2008

Net Present Value in Excel

If you are like me, doing financial calculations is one of the less fun parts of the job. NPV often trips me up, even though I know what it is and how to calculate it.

Luckily I usually have a finance person double check my spreadsheets before I do anything silly with them (and they always find errors.)

Possibly it isn't me; it's Microsoft who are the culprits.

See this article on NPV calculations in Excel for a breakdown of the way to do it right.

(More on NPV soon.)
Photocare of K8 and