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

Project Management
Business Analyst

Photocare of K8 and

Creative Commons at Flickr