How would I get present Value of a liftime income

M

M Wilson

How would I get present Value of a liftime income IE
Assuming 51years, 2% Inflation, 5% Assumed rate

Known=93,800 present cash flo
Known=2% on cash flow increase per yea
Known=5% anual Rate of return on investmen
Answer=2,534,442 would be the investment
Looking for the Excel Formula
 
V

Vasant Nanavati

If I understand your problem correctly:

=NPV(0.05,93800*(1.02^(ROW(1:51))))

entered as an array formula with <Ctrl> <Shift> <Enter>.

However, this yields $2,462,029 as the answer.
 
M

m wilson

First thenks for your repl
I tryed this by copying and pasting but I get an answer of 91,120.0
 
V

Vasant Nanavati

Enter it as an array formula with <Ctrl> <Shift> <Enter> instead of just
<Enter>. To get your desired answer, change the formula as follows:

=93800+NPV(0.05,93800*(1.02^(ROW(1:50))))

since your problem assumes the first cash flow installment to be at the
beginning of the period.
 
N

Norman Harker

Hi!

As an alternative to the NPV array formula approach:

=((1-((1+2%)/(1+5%))^51)/(1-(1+2%)/(1+5%)))*93800
Returns: 2534442.1139319


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
Top