A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. 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. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Plan A: $ ww Plan B: $ Plan A: Calculate each project's IRR. Round your answer to two decimal places. Plan B: % % million % % million b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. c. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. d. Why is NPV better than IRR for making capital budgeting decisions that add to shareholder value? The input in the box below will not be graded, but may be reviewed and considered by your instructor. 1 2 3 WACC 4 5 (Dollars in Millions) 6 Plan A 7 8 Plan B 9 0 Project NPV Calculati NPVA 11 12 NPVB 13 14 Project IRR Calculations: 15 IRRA 16 IRR 17 8 NPV Profiles: 19 Discount Rates 24 NPV profiles Formulas #N/A #N/A #N/A #N/A 775 NPVA NPVE $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 26 27 28 29 10 11 12 13 14 15 16 37 18 19 10 #1 12 13. $1.00 T $0.90 3 50.80 $0.70 50.60 $0.50 50.30 $0.20 $0.10 + 50.00 096 1 Project Delta 12 0% 5% 10% 15% 20% 22% 25% 11.00% 14 15 Calculation of Crossover Rate: 36 17 Plan A 18 39 Plan B 50 64 5 Crossover Rate IRR 56 67 $0.00 $0.00 59 0 -$40.00 Formulas -$11.00 10% D -$40.00 1 3 2 $6.39 56.39 $6.39 52 47 #N/A $2.47 $2 47 Formula #N/A 1 2 $6.39 56.39 -$11.00 $2.47 52.47 NPV Profiles 15% 3 $6.39 $2.47 4 56.39 20% 52 47 5 6 $6.39 $6.39 52.47 $2.47 $2.47 $2.47 $2.47 22% 4 5 6 56.39 $6.39 $6.39 52.47 $2.47 7 8 $6.39 $6.39 25% 7 $6.39 $2.47 9 $6.39 $247 8 9 $6.39 36.39 $2.47 $2.47 P 10 $6.39 $2.47 10 $6.39 $2.47 Y 7 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 11 $6.39 $2.47 $2.47 12 $6.39 11 12 $6.39 $6.39 $2.47 #N/A 13 14 $6.39 $6.39 52.47 $2.47 $2.47 $2.47 $2.47 $2.47 #N/A 13 14 $6.39 $6.39 $2.47 52.47 7 15 16 17 $6.39 $6.39 $6.39 T 15 $6.39 $2 47 18 19 $6.39 $6.39 $2.47 52.47 20 $6.39 $2.47 15 17 18 19 20 $6.39 36.39 $6.39 $6.39 $6.39 $2.47 $2.47 $2.47 $2.47 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A $2.47 A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.39 million per year for 20 years. Plan B requires a $11 million expenditure to build a somewhat less efficient, more labor-intensive plant with an expected cash flow of $2.47 million per year for 20 years. The firm's WACC is 11%. 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. Calculate each project's NPV. Round your answers to two decimal places. Do not round your intermediate calculations. Enter your answers in millions. For example, an answer of $10,550,000 should be entered as 10.55. Plan A: $ ww Plan B: $ Plan A: Calculate each project's IRR. Round your answer to two decimal places. Plan B: % % million % % million b. By graphing the NPV profiles for Plan A and Plan B, approximate the crossover rate to the nearest percent. c. Calculate the crossover rate where the two projects' NPVs are equal. Round your answer to two decimal places. d. Why is NPV better than IRR for making capital budgeting decisions that add to shareholder value? The input in the box below will not be graded, but may be reviewed and considered by your instructor. 1 2 3 WACC 4 5 (Dollars in Millions) 6 Plan A 7 8 Plan B 9 0 Project NPV Calculati NPVA 11 12 NPVB 13 14 Project IRR Calculations: 15 IRRA 16 IRR 17 8 NPV Profiles: 19 Discount Rates 24 NPV profiles Formulas #N/A #N/A #N/A #N/A 775 NPVA NPVE $0.00 50.00 $0.00 $0.00 $0.00 50.00 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 26 27 28 29 10 11 12 13 14 15 16 37 18 19 10 #1 12 13. $1.00 T $0.90 3 50.80 $0.70 50.60 $0.50 50.30 $0.20 $0.10 + 50.00 096 1 Project Delta 12 0% 5% 10% 15% 20% 22% 25% 11.00% 14 15 Calculation of Crossover Rate: 36 17 Plan A 18 39 Plan B 50 64 5 Crossover Rate IRR 56 67 $0.00 $0.00 59 0 -$40.00 Formulas -$11.00 10% D -$40.00 1 3 2 $6.39 56.39 $6.39 52 47 #N/A $2.47 $2 47 Formula #N/A 1 2 $6.39 56.39 -$11.00 $2.47 52.47 NPV Profiles 15% 3 $6.39 $2.47 4 56.39 20% 52 47 5 6 $6.39 $6.39 52.47 $2.47 $2.47 $2.47 $2.47 22% 4 5 6 56.39 $6.39 $6.39 52.47 $2.47 7 8 $6.39 $6.39 25% 7 $6.39 $2.47 9 $6.39 $247 8 9 $6.39 36.39 $2.47 $2.47 P 10 $6.39 $2.47 10 $6.39 $2.47 Y 7 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 11 $6.39 $2.47 $2.47 12 $6.39 11 12 $6.39 $6.39 $2.47 #N/A 13 14 $6.39 $6.39 52.47 $2.47 $2.47 $2.47 $2.47 $2.47 #N/A 13 14 $6.39 $6.39 $2.47 52.47 7 15 16 17 $6.39 $6.39 $6.39 T 15 $6.39 $2 47 18 19 $6.39 $6.39 $2.47 52.47 20 $6.39 $2.47 15 17 18 19 20 $6.39 36.39 $6.39 $6.39 $6.39 $2.47 $2.47 $2.47 $2.47 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A $2.47
Expert Answer:
Answer rating: 100% (QA)
Plan A Capital expenditure 40 million Annual cash inflows 639 million Project life 20 ... View the full answer
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324664553
Concise 6th Edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
A company is considering two mutually exclusive expansion plans. Plan A requires a $40 million expenditure on a large-scale integrated plant that would provide expected cash flows of $6.4 million per...
-
Aim:- Write a PROLOG Program to generate query based on family relationship.
-
The Pinkerton Publishing Company is considering two mutually exclusive expansion plans. Plan A calls for the expenditure of $50 million on a large-scale, integrated plant which will provide an...
-
Mr. Yap bought a bond having a face value of Php 1,000.00 for Php 970.00. The bond rate was 14% nominal and dividends were made to him semiannually for a total of 7 years. At the end of the seventh...
-
Consider the following binary sequence it 10 1001100010110 100 Use the LempelZiv algorithm to encode this sequence. Assume that the binary symbols 0 and 1 are already in the codebook.
-
Repeat Problem 12.12 except first double the \(\mathrm{H}\) value for each of the machines. This can be most easily accomplished by selecting Stability Case Info, Transient Stability Case Summary to...
-
Regulation can no longer be viewed simply in terms of command and control over companies. Discuss two alternatives to direct regulation and explain, by using the notion of an enforcement pyramid,...
-
Major League Bat Company manufactures baseball bats. In addition to its goods in process inventories, the company maintains inventories of raw materials and finished goods. It uses raw materials as...
-
A creamery purchases three different types of cheese: panela cheese at $3.75 per pound, goat cheese at $7.10 per pound, and Oaxaca cheese at $4.50 per pound. The daily demand for each cheese is 45,...
-
Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of Best Buy Co., Inc. Income Statement, Feb. 26, 2011 Feb. 27,...
-
Journalize the following selected transactions for the month of Jan. 2013. Jan. 5 Jan. 8 Jan. 10 Jan 12 Jan. 13 Jan. 15 Jan. 17 Jan. 20 Jan. 22 Jan. 30 Jan. 30 Jan. 30 Jan. 30 Jan. 31 Jan. 31 Sold...
-
Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 31 Sales (11,100 units at $375 each) Variable...
-
How should an organization decide on how "cutting edge" it should be in its IT acquisition strategy? Acquiring cutting edge IT might give it a competitive advantage, but at greater risk because the...
-
Heidt Cleaning Services (HCS) is a local custodial service company serving both the residential and commercial markets. The owner is considering dropping the commercial clients because that business...
-
Wolfgand is a 63-year old widower who is an engineer by profession. He earns a salary of $110,000 whichi s more than sufficient for him to meet his lifestyle expenditures and to set aside money for...
-
Why is network traffic normalization a recommended practice? Why is it important to perform a network traffic baseline definition analysis?
-
Video and Image data With the ubiquity of video and image capture devices, visual data are more prevalent than ever. The use of these data to augment accounting records is quickly becoming a reality...
-
Using thermodynamic data from Appendix 4, calculate G at 258C for the process: 2SO 2 (g) + O 2 (g) 88n 2SO 3 (g) where all gases are at 1.00 atm pressure. Also calculate DG8 at 258C for this same...
-
Assume that you have just been hired as business manager of Campus Deli (CD), which is located adjacent to the campus. Sales were $1,100,000 last year, variable costs were 60% of sales, and fixed...
-
Suppose Bon Temps is expected to experience zero growth during the first 3 years and then resume its steady-state growth of 6% in the fourth year. What would be its value then? What would be its...
-
Harrison Clothiers stock currently sells for $20.00 a share. It just paid a dividend of $1.00 a share (that is, D0 = $1.00). The dividend is expected to grow at a constant rate of 6% a year. What...
-
What are property, plant and equipment (PPE) assets? What are the major classes of PPE assets? At what value should PPE assets be recorded?
-
What are capital expenditures?
-
What are the two main types of leases?
Study smarter with the SolutionInn App