A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the follow

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the follow

Post by answerhappygod »

A company has a 11% WACC and is considering two mutuallyexclusive investments (that cannot be repeated) with the followingcash flows:
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 1
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 1 (25.09 KiB) Viewed 45 times
The data has been collected in the spreadsheet below.Reference the spreadsheet and perform the required analysis toanswer all parts of the question below.
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 2
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 2 (232.56 KiB) Viewed 45 times
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 3
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 3 (205.2 KiB) Viewed 45 times
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 4
A Company Has A 11 Wacc And Is Considering Two Mutually Exclusive Investments That Cannot Be Repeated With The Follow 4 (64.26 KiB) Viewed 45 times
Project A Project B O 1 2 -$300 -$387 -$193 -$405 $133 $133 3 - $100 $133 4 $600 $133 5 $600 $133 6 $850 $133 7 H - $180 $0

1 Capital budgeting criteria WACC Project A 8 Project B 10 11 Project NPV Calculations: 12 NPVA 13 14 NPVB 15 16 Project IRR Calculations 17 IRRA 18 19 IRR 20 21 Project MIRR Calculations 22 MIRR₂ 23 24 Allematively, MIRR, can be calculated as: 25 26 Project A 27 28 PV of Year 1 Outflow PV of Year 2 Outflow PV of Year 3 Outflow PV of Year 7 Outflow 30 31 33 34 35 36 Sum of Outflow PVs 知公公合成图出出出击六六大站出站 38 N 39 PV 40 PMT FV 42 I/YR MIRRA 44 MIRR 48 Project B 53 54 55 56 AMÄASENDISS638RANAZK 57 58 59 60 N 61 PV 62 PMT 63 FV 65 64 I/YR MIRR Allematively, MIRR can be calculated as: 69 66 Project Acceptance 67 WACC Accept Sum of Outflow PVs 70 WACC 71 NPVA 72 NPVB 73 Accept 75 NPV Profiles 79 80 81 82 76 Discount Rates 77 83 84 85 87 88 90 94 97 98 og 50.80 $0.60 $0.40 50.20 100 101 102 103 104 Calculation of Crossover Rate: 105 106 Project A 107 $0.00 5.00% 0% 5.00% 10.00% 12.00% 15.00% 18.10% 23.65% 108 Project B 109 110 Project Delta 111 112 113 Crossover Rate = IRR₂ 114 115 Project MIRR Calculations at WACC = 18% 116 WACC 117 118 MIRRA 119 MIRR Formulas #N/A #N/A #N/A #N/A #N/A #N/A NPV, 11.00% 10.00% 7 $0.00 $0.00 $0.00 $0.00 11.00% 18.00% $2.66 $60.18 $2.66 18.00% 0 -$300 -$405 #N/A #N/A #N/A #N/A #N/A 0 -$300 #N/A с $405 #N/A Formulas ▼ #N/A ▼ #N/A -$300 -$405 #N/A Formulas #N/A #N/A NPVB $60.18 1 -$387 $133 Formulas $387 #N/A D NPV Profiles $133 12.00% -$387 $133 #N/A -$193 $133 E $193 $133 N/A -$100 $133 -$100 $133 15.00% $193 -$100 $133 $133 F Discount Rates 0% 5.00% 10.00% 12.00% #N/A $600 $133 18.10% 23.65% $600 $133 18.10% 4 $600 $133 #N/A G NPVA #N/A #N/A #N/A #N/A #N/A #N/A #N/A $2.66 $600 $133 $600 $133 ▼ ✓ ▼ ▼ ▼ 23.65% 5 $600 $133 N/A H NPV₂ #N/A #N/A #N/A #N/A #N/A #N/A #N/A $60.18 I 6 $850 -$180 $133 so 6 $850 -$180 $133 $850 -$180 $133 So #N/A #N/A V Formulas #N/A #N/A #N/A #N/A Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A FV of Year 6 Inflow at Year 2 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 Sum of Inflow FVs FV of Year 6 Inflow at Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 FV of Year 3 Inflow at Year 7 FV of Year 2 Inflow at Year 7 FV of Year 1 Inflow at Year 7 Sum of Inflow FVs

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? Discount Rate % 0% If the WACC was 18%, which project would be selected? 5 10 12 15 % 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. 18.1 % % NPV Project A NPV Project B $

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: % %
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply