LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 418
Default Excel NPV initial cost in value1 and first year return in valu

Johanna wrote:
The help screen gives the impression that the first two values
would both be discounted for one year, with the third value then discounted
for two years. This is not what it does, though.


And that is not what the Help page says, as I read it.

What in the Help page "gives the impression" (to you) that the first
two values are discounted over the same amount time, namely one year?

According to the Help page, the NPV() cash flows are labeled value1,
value2, etc. And the Help page shows how NPV is computed, which I will
write stylistically as: SUM(value[i]/(1+rate)^i, i=1,n). That expands
to:

value[1]/(1+rate)^1 + value[2]/(1+rate)^2 + value[3]/(1+rate)^3 +....

Clearly, value1 is discounted for one period and value2 is discounted
for two periods, not for the same period of one year.

As an aside, I also want to note (primarily to others) that the Help
page also clearly states: "If your first cash flow occurs at the
beginning of the first period, the first value must be added to the NPV
result, not included in the values arguments". I explained that
previously, but I did not realize that the Help page also explains it.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"