60-Second Skills: Annual vs. Monthly NPV Formulas

by Bruce Kirsch on August 24, 2014

There is a fundamental difference between solving for the NPV when cash flows are measured in annual increments vs. in monthly increments.

As the example spreadsheet embedded below shows, the NPV is by its nature an annual calculation, using an annual discount rate. Thus, when measuring monthly, to be sure that the result it returns to us is meaningful, we must adjust for the different increment in the following way:

=NPV((1+Rate)^(1/12)-1,range of projected values)+Time 0 investment amount

If we don’t do this, then the cash flows will be discounted far too aggressively because Excel will think that each column represents 12 months, not 1 month. To get the cells to light up in the example below, you’ll need to download the embedded file below by clicking on the Excel icon in the bottom of the embed border.


Buy this document and study it closely. It could save or make you tens of thousands of dollars, or more, or keep you out of some serious trouble.


Harvard Business School’s Professor Segel is a very, very wise man who has a lot of transaction experience.

I don’t sensationalize… ignore this real estate joint venture primer at your own risk.


Development Pipeline Tracking With Devmap.io

by Bruce Kirsch on August 6, 2014

This site Devmap.io is really cool; several US cities already nicely populated

It’s crowd-sourced, so put your projects up!

Click on the Add development button to add your project