AutoSave M4 Set1 - PV IRR Payback Period - Read-Only - Excel Search Easton E File Home Insert Page Layout Formulas Data Review View Help Power Pivot Share Comments Insert - A Times New Roman 10 == Percentage 47 0 5 a Wrap Text 3 Merge & Center 9X Delete Paste BIU Av Ideas $ %) Sensitivity Conditional Format as Cell Formatting Table Styles Styles Format Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity B16 X for A B D E F G H 1 J K L M 1 0 1 2 4 2 An investment of $500 today is expected to bring the future cash flows shown below. 3 Find the NPV, IRR, & payback period of the investment. 4 5 Inputs 6 Discount rate 11.0% 7 Long term growth rate 3.0% 8 9 Period 3 10 Cash flows ($500.00) $125.00 $80.00 $200.00 $210.00 11 12 Net Present Value 13 Use the NPV function Answer #1 14 15 Internal Rate of Return 16 Use the IRR function Answer #2 17 18 Payback Period 19 Calculate manually Answer #3 20 Problem 1 Problem 2 Problem 3 + Ready @ 130% Type here to search i 2 a 11:38 AM 11/4/2020