please solve using excel. only need answers for B,C,E and H.

11-23 CAPITAL BUDGETING CRITERIA 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: o 1 2 3 4 H + + + Project A - $30 $5 $10 $15 $20 Project B - $30 $20 $10 $8 $6 a. Calculate the projects' NPVS, IRRS, MIRRs, regular paybacks, and discounted paybacks. 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. 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? i. If the payback was the only method a firm used to accept or reject projects, what payback should it choose as the cutoff point, that is, reject projects if their paybacks are not below the chosen cutoff? Is your selected cutoff based on some economic criteria, or is it more or less arbitrary? Are the cutoff criteria equally arbitrary when firms use the NPV and/or the IRR as the criteria? Explain. j. Define the MIRR. What's the difference between the IRR and the MIRR, and which generally gives a better idea of the rate of return on the investment in a project? Explain. k. Why do most academics and financial executives regard the NPV as being the single best criterion and better than the IRR? Why do companies still calculate IRRs