A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 Open spreadsheet Project A: 3 5 + + Project A -$300 -$387 -$193 $600 $600 $850 -$100 $133 $133 $133 $133 $133 Project B -$400 $133 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. 1 Discount Rate 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. 0% 5 10 % 12 15 18.1 24.18 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? 2 % 4 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. % 6 NPV Project A $ % 7 $ $ $ $ $ $ -$180 $0 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: Capital budgeting criteria WACC Project A Project B Project NPV Calculations: NPVA NPVB Project IRR Calculations: IRRA IRRB Project MIRR Calculations: MIRRA Alternatively, MIRRA can be calculated as: Project A PV of Year 1 Outflow PV of Year 2 Outflow PV of Year 3 Outflow PV of Year 7 Outflow Sum of Outflow PVs N PV PMT FV I/YR = MIRRA MIRRB 11.00% Formulas #N/A #N/A #N/A #N/A #N/A 7 $0.00 0 $0.00 0 -$300 -$400 #N/A #N/A #N/A #N/A #N/A 0 -$300 #N/A 1 -$387 $133 Formulas 1 -$387 Formulas #N/A 2 -$193 $133 2 -$193 3 -$100 $133 3 -$100 4 $600 $133 4 $600 5 $600 $133 5 $600 6 $850 $133 6 $850 7 -$180 $0 7 -$180 Formulas #N/A #N/A #N/A #N/A FV of Year 6 Inflow at Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 Sum of Inflow FVs Alternatively, MIRRB can be calculated as: Project B Sum of Outflow PVs N PV PMT FV I/YR = MIRRB Project Acceptance: WACC Accept WACC NPVA NPVB Accept NPV Profiles: Discount Rates 0% 5.00% 10.00% 12.00% 15.00% 18.10% #N/A NPVA 7 $0.00 0 $0.00 11.00% 18.00% $2.66 $65.18 $2.66 0 -$400 Formulas #N/A #N/A #N/A NPVB 1 $133 $65.18 2 $133 3 $133 Discount Rates 0% 5.00% 10.00% 12.00% 15.00% 18.10% 4 $133 NPVA #N/A #N/A #N/A #N/A #N/A #N/A $2.66 5 $133 NPVB #N/A #N/A #N/A #N/A #N/A #N/A $65.18 6 $133 7 $0 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A 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 $1.20 $1.00 $0.80 $0.60 $0.40 $0.20 $0.00 0% Calculation of Crossover Rate: Project A Project B Project Delta Crossover Rate = IRRA 5.00% Project MIRR Calculations at WACC = 18% WACC MIRRA MIRR 10.00% 18.00% NPV Profiles 0 -$300 -$400 #N/A #N/A #N/A #N/A 12.00% 1 -$387 $133 #N/A 2 -$193 $133 #N/A 15.00% 3 -$100 $133 #N/A 18.10% 4 $600 $133 #N/A 24.18% 5 $600 $133 #N/A 6 $850 $133 #N/A 7 -$180 $0 #N/A A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 Open spreadsheet Project A: 3 5 + + Project A -$300 -$387 -$193 $600 $600 $850 -$100 $133 $133 $133 $133 $133 Project B -$400 $133 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. 1 Discount Rate 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. 0% 5 10 % 12 15 18.1 24.18 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? 2 % 4 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. % 6 NPV Project A $ % 7 $ $ $ $ $ $ -$180 $0 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: Capital budgeting criteria WACC Project A Project B Project NPV Calculations: NPVA NPVB Project IRR Calculations: IRRA IRRB Project MIRR Calculations: MIRRA Alternatively, MIRRA can be calculated as: Project A PV of Year 1 Outflow PV of Year 2 Outflow PV of Year 3 Outflow PV of Year 7 Outflow Sum of Outflow PVs N PV PMT FV I/YR = MIRRA MIRRB 11.00% Formulas #N/A #N/A #N/A #N/A #N/A 7 $0.00 0 $0.00 0 -$300 -$400 #N/A #N/A #N/A #N/A #N/A 0 -$300 #N/A 1 -$387 $133 Formulas 1 -$387 Formulas #N/A 2 -$193 $133 2 -$193 3 -$100 $133 3 -$100 4 $600 $133 4 $600 5 $600 $133 5 $600 6 $850 $133 6 $850 7 -$180 $0 7 -$180 Formulas #N/A #N/A #N/A #N/A FV of Year 6 Inflow at Year 7 FV of Year 5 Inflow at Year 7 FV of Year 4 Inflow at Year 7 Sum of Inflow FVs Alternatively, MIRRB can be calculated as: Project B Sum of Outflow PVs N PV PMT FV I/YR = MIRRB Project Acceptance: WACC Accept WACC NPVA NPVB Accept NPV Profiles: Discount Rates 0% 5.00% 10.00% 12.00% 15.00% 18.10% #N/A NPVA 7 $0.00 0 $0.00 11.00% 18.00% $2.66 $65.18 $2.66 0 -$400 Formulas #N/A #N/A #N/A NPVB 1 $133 $65.18 2 $133 3 $133 Discount Rates 0% 5.00% 10.00% 12.00% 15.00% 18.10% 4 $133 NPVA #N/A #N/A #N/A #N/A #N/A #N/A $2.66 5 $133 NPVB #N/A #N/A #N/A #N/A #N/A #N/A $65.18 6 $133 7 $0 Formulas #N/A #N/A #N/A #N/A #N/A #N/A #N/A 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 $1.20 $1.00 $0.80 $0.60 $0.40 $0.20 $0.00 0% Calculation of Crossover Rate: Project A Project B Project Delta Crossover Rate = IRRA 5.00% Project MIRR Calculations at WACC = 18% WACC MIRRA MIRR 10.00% 18.00% NPV Profiles 0 -$300 -$400 #N/A #N/A #N/A #N/A 12.00% 1 -$387 $133 #N/A 2 -$193 $133 #N/A 15.00% 3 -$100 $133 #N/A 18.10% 4 $600 $133 #N/A 24.18% 5 $600 $133 #N/A 6 $850 $133 #N/A 7 -$180 $0 #N/A
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations with workings shown stepbystep a Project A NPV 10922 Project B NPV 4192... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-1285867977
14th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
On December 1 , 2 0 1 5 , your company pays $ 2 4 , 0 0 0 for rent on your store that covers the next 6 months. When you paid the cash, you debited Prepaid Rent.. The adjusting journal entry on...
-
1) Suppose that f is a polynomial function and c is a number. If you divide f ( x ) by x c , then what will the remainder be? 2) Suppose that f is a polynomial function with rational coefficients...
-
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: a. What is each project's NPV? b. What is each project's IRR?...
-
Give the numerical coefficient and the degree of each term. 2
-
A men's world record for the shot put, 23.12 m, was set by Randy Barnes of the United States on May 20, 1990. If the shot was launched from 6.00 ft above the ground at an initial angle of 42.0, what...
-
Yang Corp. is growing quickly. Dividends are expected to grow at a rate of 25 percent for the next three years, with the growth rate falling off to a constant 6 percent thereafter. If the required...
-
Plavix Corporations bonds payable carry a stated interest rate of 7%, and the market rate of interest at the time of issuance is 8%. Plavix Corporations bonds will be sold at a. a premium. b. a...
-
Describe how you would go about analyzing the data storage needs of the Marc Schnieder Janitorial Supply Company. Would you trash the old system or just polish it up a bit? Discuss the implications...
-
An epicyclic, gear train, as shown in Fig.15.26 is composed of a fixed annular wheel A having 150teeth. The wheel A is meshing with wheel B which drives wheel D through an idle wheel C, D...
-
Lunatics, an e-commerce sports company wants to buy Rowdy Trading Cards at a cost of $504 million. Rowdy will operate for 20 years. They expect annual cash flows from operations to be $70.1 million...
-
Physics help? In outer space a rock with mass 4 kg, and velocity < 4000, -3200, 2800 > m/s, struck a rock with mass 17 kg and velocity < 240, -310, 180 > m/s. After the collision, the 4 kg rock's...
-
How can finite element analysis (FEA) be utilized to predict and mitigate structural failure in complex civil engineering projects, especially when considering non-linear behaviors and multi-material...
-
4 ) Prepare a journal entry for the following sales transaction: a . Dec. 3 , Hardy Hardware sold $ 5 0 , 0 0 0 of shovels on account, credit terms are 3 / 1 5 , n / EOM , to John s Construction, Co...
-
How can civil engineers balance the demands of economic growth with the necessity of sustainable practices and social responsibility ?
-
Sample Rhetorical Analysis: "From Compton to Harvard: Teen Snags Opportunity of a Lifetime" (CNN Article) 1616 unread replies.1616 replies. In the article attached, the author tries to celebrate the...
-
For Kroger deposits in transit: What is the account titled Store deposits in - transit ( refer to footnote 1 ) ? This is not an account you will find on the majority of company financial statements....
-
If the contribution margin ratio is 25% and the fixed costs are $40,000, what will be the break even point in units? You can assume that the unit price is $10.
-
Michelles trust is subject to 3.8% surtax on the lesser of the trusts net investment income or the excess of the trusts adjusted gross income over the $12,400 threshold (the highest trust tax rate)....
-
Ebersoll Mining has $6 million in sales, its ROE is 12%, and its total assets turnover is 3.2. Common equity on the firm's balance sheet is 50% of its total assets. What is its net income?
-
Christie Corporation is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash conversion cycle . Christie's 2015 sales (all on credit) were...
-
How are management's actions incorporated in EVA and MVA? How are EVA and MVA interconnected?
-
A study of past computer frauds indicates that some of the most common means of manipulating transactions are to: 1. Add unauthorized transactions such as phony purchase orders. 2. Alter transactions...
-
You are auditing petty cash and discover that a friend of yours, who is in charge of the petty cash funds, has forged some petty cash vouchers amounting to $100 over the last five months. He...
-
Due to particularly poor operating performance, managers have increased incentives to present financial statements in a more favorable light than is appropriate. As an internal auditor, you believe...
What Rich People Know And Desperately Want To Keep Secret 1st Edition - ISBN: 0761535403 - Free Book
Study smarter with the SolutionInn App