Number 3. Calculate the NPV and IRR using the data from Table 2. Should the project be accepted?

X H 7 . 0 . File Home Insert Page Layout Formulas Data Review View * Cut Calibri - 11 A Wrap Text General Copy . Paste Format Painter Merge & Center . $ Clipboard Font Alignment Number 042 A B C D E F G H 61 62 2 Table 2 63 A B C D E F Tax in After tax Cash from Cash outflow, Depreciat Taxable $Millions Cash Revenue in expenses in ion in Income in 27.5% Flow In 64 Year $Millions $Millions $Millions $ Millions rate $Millions 65 O $ 66 1 $ 1,800.00 $ 1,728.00 $ 50.02 $ 21.99 $ 6.05 $ 65.95 67 2 $ 1,900.00 $ 1,824.00 $ 85.72 $ (9.72) $ (2.67) $ 78.67 68 3 $ 2,000.00 1,920.00 $ 61.22 $ 18.79 $ 5.17 $ 74.83 69 4 $ 2,100.00 2,016.00 $ 43.72 $ 40.29 $ 11.08 $ 72.92 70 5 $ 2,200.00 2,112.00 $ 31.26 $ 56.75 $ 15.60 $ 72.40 71 6 $ 2,300.00 $ 2,208.00 $ 31.22 $ 60.78 $ 16.71 $ 75.29 72 7 $ 2,400.00 $ 2,304.00 $ 31.26 $ 64.75 $ 17.80 $ 78.20 73 8 $ 2,500.00 $ 2,400.00 $ 15.61 $ 84.39 $ 23.21 $ 76.79 74 9 $ 2,600.00 $ 2,496.00 $ $ 104.00 $ 28.60 $ 75.40 75 10 $ 2,700.00 $ 2,592.00 $ $ 108.00 $ 29.70 $ 78.30 76 11 $ 2,600.00 S 2,496.00 $ $ 104.00 $ 28.60 $ 75.40 77 12 $ 2,500.00 $ 2,400.00 $ $ 100.00 $ 27.50 $ 72.50 78 13 $ 2,400.00 $ 2,304.00 $ $ 96.00 $ 26.40 $ 69.60 79 14 $ 2,200.00 $ 2,112.00 $ $ 88.00 $ 24.20 $ 63.80 80 15 $ 2,000.00 $ 1,920.00 $ 80.00 $ 22.00 $ 58.00 81 16 $ 1,800.00 $ 1,728.00 $ $ 72.00 $ 19.80 $ 52.20 82 17 $ 1,500.00 1,440.00 $ $ 60.00 $ 16.50 $ 43.50 83 18 $ 1,200.00 $ 1,152.00 $ $ 48.00 $ 13.20 $ 34.80 84 19 $ 800.00 S 768.00 S $ 32.00 $ 8.80 $ 23.20 85 20 $ 400.00 384.00 $ $ 16.00 $ 4.40 $ 11.60 86 21 87 88 3 NPV 89 IRR 90 |Instructions Cost of Capital Capital Budgeting Ready O Type here to search Eli Oe M W