Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 12 ~ Ak A = General E Insert 27-O YO Delete v TV Paste 1 DI Y Y oy A = = = + Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select Format v Analyze DAIA Sensitivity Y E7 A B C C D E F G H K L L M N discount rate Operating cash flow 15,478,580.00) 1.098.431.00 1,275,431.00 1,974.521.00 2,398,010.00 2.298.571.00 2,498,313.00 2.09R.153.00 3,423.190.00 3.864.127.00 3,987.XI8 7 1 2 You are given the following opportunity and you are asked to evaluate 3 4 Time 5 0 0 6 1 7 2 8 3 9 + 10 5 11 6 12 13 8 14 9 15 10 16 17 18 Calculate the following: 19 Payback period 20 Discounted payback period 21 NPV 22 IRR 23 24 is the project a good investment oportunity? Why? 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Sheet1 Ready + 100%