Chrome File Edit View History Bookmarks Profiles Tab Window Help US U.S. B O Q Sun Jun 15 11:37 PM Course Hero X Question 29 - HW8 - Connec X + Book7 Q ~ Search Sheet Formulas Data Review View o+ Share G go ezto.mheducation.com/ext/map/index.html?_... Finish update : Trace Precedents 15/fic Trace Dependents Defined Show Error Calculation HW8 i Saved Help Save & Exit Submit Names Remove Arrows Formulas Checking Options updates, fixes, and improvements, choose C... Check for Updates Check my work D18 29 G . .. D E F G Year Cash Flow (A) Cash Flow (B) 731191381 16890.52091 0 -$ 420, 000 -$ 37,500 658730974 13108.74639 46, 500 19, 900 103752.5747 3.33 59,500 13, 800 26% 1.331518532 points 76, 500 16, 100 535, 000 12, 900 ash Flow PVIF @ 12% Present Value eBook The required return on these investments is 10 percent. C = 1/(1+0.12)^A D=B*C -148000 1 -148000 References a. What is the payback period for each project? Note: Do not round intermediate calculations and round your answers to 64000 0.892857 57142.9 2 decimal places, e.g., 32.16. 75000 0.797194 59789.5 b. What is the NPV for each project? 59000 0.71178 41995 Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. 10927.4 c. What is the IRR for each project? Note: Do not round intermediate calculations and enter your answers as -28100 a percent rounded to 2 decimal places, e.g., 32.16. 15600 $1.05 d. What is the profitability index for each project? 13300 Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. 9700 e. Based on your answers in (a) through (d), which project will you finally 19% chonse? Mc Graw Hill + 117% 776 JUN 15 stv Q J Q W