AutoSave C M4 Set BIRR Portack Peso - Ekel File Home Insert Page Layout Formulas Data Review View Developer Help Search C17 A 3 D E F G H K today is expected to bring the future cash flows for years 1 to 4 shown below. After An investment of S500 the 4th year cash flows are expected to grow at the given long term growth rate 2 for an additional 9 years. 3 Find the NPV, IRR. & payback period of the investment 4 5 Inputs 6 Discount rate 11.04 Long term growth rate 30% 8 9 Period 0 2 10 Cash flows (5.500.00 $125 00 $80.00 $200 005210,00 11 12 Net Present Value 13 Use the NPV function Answer #6 14 15 Internal Rate of Return 16 Use the IRR function Answer 7 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31