Answered step by step
Verified Expert Solution
Question
1 Approved Answer
yes please expressed in an excel chart but can you show formulas of how you to the answer A company has a 11% WACC and
yes please expressed in an excel chart but can you show formulas of how you to the answer
A company has a 11% WACC and is considering two mutually exclusive investments that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 -$180 Project A Project B - $300 -$400 -$387 $135 -$193 $135 -$100 $135 $600 $135 $600 $135 $850 $135 $0 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. x Open spreadsheet a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. Project A: $ Project B: $ b. What is each project's IRR? Round your answer to two decimal places. Project A: % Project B: % c. What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations. Project A: % Project B: % d. From your answers to parts a-c, which project would be selected? If the WACC was 18%, which project would be selected? e. Construct NPV profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calculations. Negative value should be indicated by a minus sign. Discount Rate NPV Project A NPV Project B 0% $ 5 $ $ 10 $ $ 12 $ $ 15 $ $ 18.1 $ $ 24.83 $ $ f. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. Do not round your intermediate calculations. % g. What is each project's MIRR at a WACC of 18%? Round your answer to two decimal places. Do not round your intermediate calculations. Project A: % Project B: % A B D E F G . J K 11.00% 1 0 -$300 2 -$193 3 -$100 4 $600 5 $600 -$387 6 $850 7 -$180 -$400 $135 $135 $135 $135 $135 $135 $0 Formulas #N/A 1 Capital budgeting criteria 2 3 WACC 4 5 6 Project A 7 8 Project B 9 10 11 Project NPV Calculations: 12 NPVA 13 14 NPVE 15 16 Project IRR Calculations: 17 IRRA 18 19 IRRE 20 21 Project MIRR Calculations: 22 MIRRA 23 24 Alternatively, MIRRA can be calculated as: 25 26 Project A #N/A #N/A #N/A #N/A 1 0 -$300 2 -$193 3 -$100 4 $600 5 $600 6 $850 7 -$180 -$387 8 PV of Year 1 Outflow 9 PV of Year 2 Outflow O PV of Year 3 Outflow 1 PV of Year 7 Outflow #N/A #N/A #N/A #N/A 2 Formulas #N/A #N/A #N/A 3 4 5 6 Sum of Outflow PVs #N/A #N/A Formulas 8 N 9 PV 0 PMT 1 FV 2 I/YR = MIRRA $0.00 0 $0.00 #N/A 3 #N/A 4. MIRRE 5 6 Alternatively, MIRRg can be calculated as: 0 -$400 1 $135 2 $135 3 $135 3 Project B 4 $135 5 $135 6 $135 7 $0 0 1 2 Formulas #N/A #N/A #N/A #N/A #N/A #N/A 3 4 E #N/A #N/A Formulas 7 $0.00 0 $0.00 #N/A 11.00% #N/A 57 58 Sum of Outflow PVs 59 60 N 61 PV 62 PMT 63 FV 64 I/YR = MIRRB 65 66 Project Acceptance: 67 WACC 68 Accept 69 70 WACC 71 NPVA 72 NPV: 73 Accept 74 75 NPV Profiles: 76 Discount Rates 77 78 79 80 81 82 83 84 18.00% $2.66 $72.18 #N/A NPVA NPVE $72.18 Discount Rates NPVA NPVE $2.66 $2.66 $72.18 0% 5.00% 10.00% 12.00% 15.00% 18.10% 24.83% 0% 5.00% 10.00% 12.00% 15.00% 18.10% 24.83% #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Calculation of Crossover Rate: 3 0 -$300 2 -$193 4 $600 5 $600 6 $850 Project A -$387 -$100 -$180 Project B -$400 $135 $135 $135 $135 $135 $135 $0 Project Delta #N/A #NA #N/A #N/A #N/A #N/A #N/A #N/A Crossover Rate = IRRA #N/A Project MIRR Calculations at WACC = 18% WACC 18.00% MIRRA MIRRg #N/A #N/A Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started