An investment of $500 today is expected to bring the future cash flows for years 1 to
Fantastic news! We've Found the answer you've been seeking!
Question:
An investment of $500 today is expected to bring the future cash flows for years 1 to 4 shown below. After the 4th year cash flows are expected to grow at the given long term growth rate forever.
Find the NPV and IRR of the investment.
Inputs | |||||
Discount rate | 25.0% | ||||
Long Term growth rate | 5.0% | ||||
Period | |||||
Cash Flows | (500.00) | 200.00 | 210.00 | 240.00 | 260.00 |
Net Present Value | |||||
*Formula: = NPV(B5, C9:F9)x(1+0.05)+B9 | 49.96 | ||||
Internal Rate of Return | |||||
*Formula =IRR(B9:F9) | 27.52 | ||||
required :
What would be the method to calculate the 5 - infinity cash flows using the long term growth rate?
My formulas for NPV and IRR are incorrect. I am simply showing what work I have performed so far. If IRR is NA, just answer NA.
The correct answers are NPV = 582.88 and IRR = NA
What are the formulas that will give me this output?
Related Book For
Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics
ISBN: 978-1285418681
7th edition
Authors: Cliff Ragsdale
Posted Date: