Capital budgeting criteria 1 Video Excel Online Structured Activity: Capital budgeting criteria A company has a 12% WACC and is considering two mutually exclusive investments that cannot be repeated) with the following cash flows: 2 3 5 6 7 $300 Project A Project $387 $135 -$193 $135 $100 $135 $600 $135 $600 $135 $850 $135 $180 SO 5405 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is each project's NPV Round your answer to the nearest cent. Do not round your intermediate calculations Project : $ Project : $ b. What is sach project's IRR7 Round your answer to two decimal places, Project % V Project What in each project's MIRRY (ant: Consider Period as the end of project in ) Round your answer to two decimal placet. Do not round your intermediate calculations, Prog: Project d. from your answers to parts ac, which project would be selected? I. WACC Wow, which provt would be vected Capital budgeting criteria CIUN c. What is each project's MRR2 Hint: Consider Period as the end of Proped Round your answer to two deo places. Do not round your intermediate calculations ProA 46 Project d. From your answers to parts which project would be selected If the WACC was 18%, which project would be selected? e Construct NP profiles for Projects A and B. Round your answer to the nearest one. Do not found your intermediate ca Negative value should be indicated by a minus on NPV Proiecte Discount Bate 09 NPY. ROLA $ 3 5 $ 5 10 $ 12 ES + 15 $ 18.1 20.20 S s Lcolate the core where the two projects are cual. Round your answer to two decal places. Do not round your mediate costi What each projects MIRRWACC 1847 Round your answer to two decat cen Oo not round your itemidate calcucine Project A Project CHEW WORK Resepte TUTE param Plant Aless Tracey Kelly Roger Guyton 20-21 William (B)