Excel Activity: Calculating the WACC Here is the condensed 2021 balance sheet for Skye Computer Company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excel Activity: Calculating the WACC Here is the condensed 2021 balance sheet for Skye Computer Company (in thousands of dollars): Current assets Net fixed assets Total assets Accounts payable and accruals Short-term debt Long-term debt Preferred stock (15,000 shares) Common stock (50,000 shares) Retained earnings Total common equity Total liabilities and equity 2021 $1,750 3,250 $5,000 $ 700 200 725 475 1,425 1,475 $2,900 $5,000 Skye's earnings per share last year were $3.75. The common stock sells for $60.00, last year's dividend (Do) was $2.65, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 10%. Skye's preferred stock pays a dividend of $3.85 per share, and its preferred stock sells for $35.00 per share. The firm's before-tax cost of debt is 12%, and its marginal tax rate is 25%. The firm's currently outstanding 12% annual coupon rate, long-term debt sells at par value. The market risk premium is 5%, the risk-free rate is 6%, and Skye's beta is 1.314. The firm's total debt, which is the sum of the company's short-term debt and long-term debt, equals $0.925 million. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to two decimal places. a. Calculate the cost of each capital component, that is, the after-tax cost of debt, the cost of preferred stock, the cost of equity from retained earnings, and the cost of newly issued common stock. Use the DCF method to find the cost of common equity. After-tax cost of debt: Cost of preferred stock: Cost of retained earnings: Cost of new common stock: % % % b. Now calculate the cost of common equity from retained earnings, using the CAPM method. % % % c. What is the cost of new common stock based on the CAPM? (Hint: Find the difference between re and rs as determined by the DCF method, and add that differential to the CAPM value for rs.) % % d. If Skye continues to use the same market-value capital structure, what is the firm's WACC assuming that (1) it uses only retained earnings for equity and (2) if it expands so rapidly that it must issue new common stock? (Hint: Use the market value capital structure excluding current liabilities to determine the weights. Also, use the simple average of the required values obtained under the two methods in calculating WACC.) WACC₁: WACC₂: Excel Activity: Calculating the WACC Here is the condensed 2021 balance sheet for Skye Computer Company (in thousands of dollars): Current assets Net fixed assets Total assets Accounts payable and accruals Short-term debt Long-term debt Preferred stock (15,000 shares) Common stock (50,000 shares) Retained earnings Total common equity Total liabilities and equity 2021 $1,750 3,250 $5,000 $ 700 200 725 475 1,425 1,475 $2,900 $5,000 Skye's earnings per share last year were $3.75. The common stock sells for $60.00, last year's dividend (Do) was $2.65, and a flotation cost of 10% would be required to sell new common stock. Security analysts are projecting that the common dividend will grow at an annual rate of 10%. Skye's preferred stock pays a dividend of $3.85 per share, and its preferred stock sells for $35.00 per share. The firm's before-tax cost of debt is 12%, and its marginal tax rate is 25%. The firm's currently outstanding 12% annual coupon rate, long-term debt sells at par value. The market risk premium is 5%, the risk-free rate is 6%, and Skye's beta is 1.314. The firm's total debt, which is the sum of the company's short-term debt and long-term debt, equals $0.925 million. The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Round your answers to two decimal places. a. Calculate the cost of each capital component, that is, the after-tax cost of debt, the cost of preferred stock, the cost of equity from retained earnings, and the cost of newly issued common stock. Use the DCF method to find the cost of common equity. After-tax cost of debt: Cost of preferred stock: Cost of retained earnings: Cost of new common stock: % % % b. Now calculate the cost of common equity from retained earnings, using the CAPM method. % % % c. What is the cost of new common stock based on the CAPM? (Hint: Find the difference between re and rs as determined by the DCF method, and add that differential to the CAPM value for rs.) % % d. If Skye continues to use the same market-value capital structure, what is the firm's WACC assuming that (1) it uses only retained earnings for equity and (2) if it expands so rapidly that it must issue new common stock? (Hint: Use the market value capital structure excluding current liabilities to determine the weights. Also, use the simple average of the required values obtained under the two methods in calculating WACC.) WACC₁: WACC₂:
Expert 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
-
Here is the condensed 2015 balance sheet for Skye Computer Company (in thousands of dollars): 2015 Current assets .....................................................$2,000 Net fixed...
-
Here is the condensed 2008 balance sheet for Skye Computer Company (in thousands of dollars): 2008 Current assets $ 2,000 Net fixed assets 3,000 Total assets $ 5,000 Current liabilities $ 900...
-
Here is the condensed 2018 balance sheet for Skye Computer Company (in thousands of dollars): Current assets ......$2,000 Net fixed assets...... 3,000 Total assets .....$5,000 Accounts payable and...
-
In your opinion, was Saks' zero tolerance policy for employee theft reasonable? Was the policy likely cost-effective? Defend your answers.
-
Use the following accounts and balances to prepare a balance sheet with the accounts in proper order for Manteno Company at June 30, 2014, using Exhibit 8 as amodel: Accounts Receivable Wages Payable...
-
Chock, a U.S. corporation, purchases inventory for resale from distributors within the United States and resells this inventory at a $1 million profit to customers outside the United States. Title to...
-
It Wires aren't really ideal. The voltage drop across a currentcarrying wire can be significant unless the resistance of the wire is quite low. Suppose a \(50 \mathrm{ft}\) extension cord is being...
-
Parry Corporation acquired a 100% interest in Sent Company on January 1, 2009, paying $140,000. Financial statement data for the two companies for the year ended December 31, 2009 follow: Required:...
-
What options would you have when you communicate with the other nearby villages so that your estimate of per-mile costs will be consistent and comparable for your manager? Explain
-
Simplifying the ABC System: TDABC Golding Bank provided the following data about its two checking account products and their associated resources and activities: Resources Activities $60,000...
-
A saturable absorber is an absorbing medium that can only absorb so much light and becomes transparent at high intensities. The change in its absorption coefficient, Aa, depends on the irradiance,...
-
Over each of the next 4 years, McDougall Corp. expects to sell 56,400 units of its product at a price of $6.00 per unit. Annual fixed costs are expected to be $18,100 and variable costs are estimated...
-
A corporation is 100% owned by an individual. In 2023, it reports business gross receipts of 100,000, interest income of 200,000, and capital gain of 300,000. Assume it has no expenses. WHAT IS THE...
-
The approval authority for O&M construction projects in excess of $750,000, but less than $2,000,000: a. Under Secretary of Defense or designee b. Assistant Secretary of the Army for Acquisition,...
-
2. How does the ITAA define 'trading stock'? Give examples of assets that could constitute 'trading stock' of a business. 2.1Under Division 70 ITAA 1997, concisely outline how a taxpayer must go...
-
Analyze the quarterly earnings per share (EPS) announcement on 3 May 2018 for ESS-US (FactSet identifier). Was this a positive, neutral, or negative earnings surprise? Positive Neutral Negative Mark...
-
Discuss the importance of research design in marketing research, and evaluate different research design options for a hypothetical marketing research study. What factors should be considered when...
-
Is times interest earned meaningful for utilities? Why or why not?
-
Briefly describe each of the following financial institutions: commercial banks, investment banks, mutual funds, hedge funds, and private equity companies.
-
If a company`s board of directors wants management to maximize shareholder wealth, should the CEO`s compensation be set as a fixed dollar amount, or should the compensation depend on how well the...
-
If the company decides to invest enough right now to produce the future $100,000, how much must it put up?
-
Which of the following function(s) is/are carried out by piRITS or piRISC? a. Inhibits transcription of TEs b. Causes the degradation of TE RNA c. Causes chromosome breakage d. Both a and b are...
-
Scientists propose that the first macromolecules in protobionts were a. DNA molecules. b. RNA molecules. c. proteins. d. all of the above.
-
In the CRISPR-Cas system, what does tracrRNA bind to? a. crRNA and Cas1 protein b. crRNA and Cas2 protein c. crRNA and Cas9 protein d. Cas1 and Cas2 proteins
Study smarter with the SolutionInn App