I need this excel document completed. Due to time constraints I have other projects I have to do but the answers to this question are on Google if that saves you anytime. I do not have that much money so please help me.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 A 11problem B C D E F G H I 12/2/2015 15:10 Chapter 11. Solution to End-of-Chapter Comprehensive/Spreadsheet Problem Problem 11-23 Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Time 0 1 2 3 4 Expected Cash Flows Project A Project B ($30) ($30) $5 $20 $10 $10 $15 $8 $20 $6 a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. WACC = 10% Use Excel's NPV function as explained in NPVA = 11model.xlsx. Note that the range does not include NPVB = the initial costs, which are added separately. We find the internal rate of return with Excel's IRR function: IRRA = IRRB = We find the modified internal rate of return with Excel's MIRR function using the 10% WACC: MIRRA = MIRRB = Project A Time period: Cash flow: Cumulative cash flow: Logical test: 0 (30) (30) 0 0.00 1 5 (25) 0 0.00 2 10 (15) 0 0.00 3 15 0 1 3.00 4 20 20 0 0.00 Max Row 35=PaybackA: PaybackA: Alternative calculation using nested IF statements. Project B Time period: Cash flow: Cumulative cash flow: Logical test: 0 (30) (30) 0 0.00 1 20 (10) 0 0.00 2 10 0 1 2.00 3 8 8 0 0.00 4 6 14 0 0.00 Max Row 45=PaybackB: PaybackB: Alternative calculation using nested IF statements. J 10/15/2013 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 A Project A B Time period: Cash flow: Disc. cash flow: Disc. cum. cash flow: C D E F G 0 (30) (30.00) (30.00) 1 5 4.55 (25.45) 2 10 8.26 (17.19) 3 15 11.27 (5.92) 4 20 13.66 7.74 0 (30) (30.00) (30.00) 1 20 18.18 (11.82) 2 10 8.26 (3.55) 3 8 6.01 2.46 H I 4 6 4.10 6.55 Discounted PaybackA: Project B Time period: Cash flow: Disc. cash flow: Disc. cum. cash flow: Discounted PaybackB: b. If the two projects are independent, which project(s) should be chosen? c. If the two projects are mutually exclusive and the WACC is 10%, which project(s) should be chosen? d. Plot NPV profiles for the two projects. Identify the projects' IRRs on the graph. Before we can graph the NPV profiles for these projects, we must create a data table of project NPV relative to differing costs of capital. Project A 0.00% 2.00% 4.00% 6.00% 8.00% 10.00% 12.00% 14.00% 16.00% 18.00% 19.19% 20.00% 22.00% 22.52% 24.00% Project B J 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 A B C D E F G H I e. If the WACC was 5%, would this change your recommendation if the projects were mutually exclusive? If the WACC was 15%, would this change your recommendation? Explain your answers. f. The "crossover rate" is 13.5252%. Explain what this rate is and how it affects the choice between mutually exclusive projects. g. Is it possible for conflicts to exist between the NPV and the IRR when independent projects are being evaluated? Explain your answer. h. Now, look at the regular and discounted paybacks. Which project looks better when judged by the paybacks? J