In: Finance
Using NPV in Excel how do I solve for: An investment offers the following annual cash flows: End of years 1 thru 10, $5000, years 11 thru 20, $7500. If your required return on this investment is 6% what is it worth today?
Ans $ 67624.19
We can also use the formula:
=NPV(6%,value1,value2,value3.......)
or
=NPV(6%,Cell references of cash inflows)