Excel template - Sawed - Sewch (0pton +9 " Frian 8 aseor =1Bsheet A company has a 12% WACC and is considering two mutually exchusive investments (that cannot be repested) with the folowing cath flowst The data has been collected in the Microsoft Excel brifine file below. Cpen the spreadsheet and perfom the required analyals to answer the questions below. 9. What is each project's Rop? Resnd your answer to the pearest cent, Do not round your intermedate cakulations. Project A: 1 Project B: 3 b. What is each project's 1at? Raund your answer in two decimal nlaces. Project A Project B: intermediate calculationt. Project h : Proyect 9. From your answen to parts a c. which project aould be seiected? d. From your answers to parte a-c, which profect would be selected? If the WACC was 18%, which project would be selected? e. Construct NPN profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calicilations, Negative value should be indicated ty a minus sign. 4. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intertmediate caleulations. Project A: Project 8