As a follow-on to last week’s post on NPV, we note here that there is also a fundamental difference between solving for the IRR when cash flows are measured in annual increments vs. in monthly or other non-annual increments.

As the example spreadsheet embedded below shows, the IRR is by its nature an annual calculation, producing an annual discount rate as its result. Thus, when measuring non-annual cash flows, to be sure that the result it returns to us is meaningful, we must adjust for the different time period increment in the following way:

=(IRR(range of time zero and projected values)+1)^non-annual increment-1

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 something less than 12 months. 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.

{ 0 comments }

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.

{ 0 comments }

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.

http://hbr.org/product/structuring-real-estate-deals-an-investor-s-perspective/an/208066-PDF-ENG

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.

{ 0 comments }