Determine what the optimum capital structure is for Delta Airlines. You will use Hamada's Equation to recalculate
Fantastic news! We've Found the answer you've been seeking!
Question:
Determine what the optimum capital structure is for Delta Airlines.
You will use Hamada's Equation to recalculate the levered betas based on the weights that you choose.
Where can I find or how do I calculate the "RED" inputs in the following excel image?
I have to calculate the following:
Other possibly relevant info:
Transcribed Image Text:
The optimal capital structure is the one that maximizes the value of the company. Also, that same capital structure minimizes the WACC. We begin by estimating how capital structure affects the costs of debt and equity. The effects on debt are usually estimated by talking with bankers and investment bankers. Discussions with its bankers indicate that Strasburg can borrow different amounts, but the more it borrows, the higher the cost of its debt. Note: the percentages are based on market values. Estimating Optimal Capital Structure (Millions of Dollars) 1. Ws 2. d 3. b 4. Ts 5. (1-T) 6. WACC Notes: 10% 90.00% 3.64% 0.65 6.55% 2.56% 6.15% 15% 85.00% 3.00% 0.67 6.71% 2.11% 6.02% Percent of Firm Financed with Debt (wa) 20% 25% 80.00% 3.26% 0.71 6.90% 5. The after-tax cost of debt is ra (1-T), where T = 39%. 6. The weighted average cost of capital is calculated as: WACC = Ws fs + Ward (1-T). 2.30% 5.98% 1. The percent financed with equity is: W = 1 - Wa 2. The interest rate on debt, rd, is obtained from investment bankers. 3. The levered beta is estimated using Hamada's formula, and unlevered beta of by = x and a tax rate of 39% : b = bu [1 + (1-T) (W/W)]- 4. The cost of equity is estimated using the CAPM formula with a risk-free rate of 2.87% and a market risk premium of 6.54%: rs = TRF + (RPM)b. 75.00% 3.50% 0.74 7.11% 2.46% 5.95% 30% 70.00% 4.00% 0.78 7.35% 2.82% 5.99% 35% 65.00% 5.00% 0.83 7.63% 3.52% 6.19% 40% 60.00% 3.08% 0.88 7.96% 2.17% 5.64% The optimal capital structure is the one that maximizes the value of the company. Also, that same capital structure minimizes the WACC. We begin by estimating how capital structure affects the costs of debt and equity. The effects on debt are usually estimated by talking with bankers and investment bankers. Discussions with its bankers indicate that Strasburg can borrow different amounts, but the more it borrows, the higher the cost of its debt. Note: the percentages are based on market values. Estimating Optimal Capital Structure (Millions of Dollars) 1. Ws 2. d 3. b 4. Ts 5. (1-T) 6. WACC Notes: 10% 90.00% 3.64% 0.65 6.55% 2.56% 6.15% 15% 85.00% 3.00% 0.67 6.71% 2.11% 6.02% Percent of Firm Financed with Debt (wa) 20% 25% 80.00% 3.26% 0.71 6.90% 5. The after-tax cost of debt is ra (1-T), where T = 39%. 6. The weighted average cost of capital is calculated as: WACC = Ws fs + Ward (1-T). 2.30% 5.98% 1. The percent financed with equity is: W = 1 - Wa 2. The interest rate on debt, rd, is obtained from investment bankers. 3. The levered beta is estimated using Hamada's formula, and unlevered beta of by = x and a tax rate of 39% : b = bu [1 + (1-T) (W/W)]- 4. The cost of equity is estimated using the CAPM formula with a risk-free rate of 2.87% and a market risk premium of 6.54%: rs = TRF + (RPM)b. 75.00% 3.50% 0.74 7.11% 2.46% 5.95% 30% 70.00% 4.00% 0.78 7.35% 2.82% 5.99% 35% 65.00% 5.00% 0.83 7.63% 3.52% 6.19% 40% 60.00% 3.08% 0.88 7.96% 2.17% 5.64%
Expert Answer:
Answer rating: 100% (QA)
Without the specific data provided in the Excel image its challenging to determine the RED inputs required for Hamadas Equation to calculate the levered betas for Delta Airlines However I can guide yo... View the full answer
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The focal length of a thin biconvex lens is 20 cm. When an object is moved from a distance of 25 cm in m25 front of it to 50 cm, the magnification of its image changes from ms to m50. The ratio is m50
-
The Association of American Universities published a report titled "Looking More Closely at Student Debt." This report explores the issue about the cost of a college education and its impact on...
-
Kelle Carpet and Trim installs carpet in commercial offices. Peter Kelle has been very concerned with the amount of time it took to complete several recent jobs. Some of his workers are very...
-
( Appendix 7A) When a perpetual inventory system is used, unit costs of the items sold are known at the date of each sale. In contrast, when a periodic inventory system is used, unit costs are known...
-
1. Would you describe Starbucks production/operations technology in its retail stores as unit, mass, or process? Explain your choice. How does its production/operations technology approach affect the...
-
Acting as the CEO of a small company, you will apply the principles of capital budgeting to invest in growth and cash flow improvement opportunities in three phases over 10 simulated years. Each...
-
Paul and Wayne equally own the PW Partnership. Paul's basis was $30,000 and Wayne's basis was $22,000 at the beginning of the year. PW Partnership had the following income and expense items:...
-
Sunland Inc. is contemplating a capital project with a cost of $141000. The project will generate net cash flows of $41000 for year 1, $60000 for year 2 and $57000 for year 3. The asset has a salvage...
-
Game 1: You are playing a game where you get n turns. Each of your turns involves flipping a coin a number of times. On the first turn, you have 1 flip, on the second turn you have two flips, and so...
-
Balance Sheet Netting: Cooper Motors has an account receivable from a customer, Rusty Services. Cooper also has an account payable balance due to Rusty Services. Cooper is asserting that it is...
-
An astronomer is looking at the spectrum of a galaxy and finds that it has an oxygen spectral line of 525 nm, while the laboratory value is measured at 513 nm. Calculate how fast the galaxy would be...
-
The new software analyzes sales conversion per sales in a way intended to increase sales success. What is the first thing you must do before evaluating the new software? Select an answer: Define what...
-
Design a lead high pass filter with = show its transfer function , magnitude and phase response. C = 0 and R
-
Statistical quality control: how can this topic be difficult or hard to understand? Research this topic and present your findings.
-
Independent random samples of sizes n1 = 30 and n2 = 50 are taken from two normal populations having the means 1 = 78 and 2 = 75 and the variances 21 = 150 and 22 = 200. Use the results of Exercise...
-
Given the information below, construct a value-weighted portfolio of the four stocks if you have $500,000 to invest. That is, how much of your $500,000 would you invest in each stock? Stock OGG HNL...
-
You are looking to buy a car and you have been offered a loan with an APR of 6%, compounded monthly. a. What is the true monthly rate of interest? b. What is the EAR?
-
DFB, Inc., expects earnings at the end of this year of $5 per share, and it plans to pay a $3 dividend to shareholders (assume that is one year from now). DFB will retain $2 per share of its earnings...
-
Determine whether \(G\) raph \(Q_{2}\) is a spanning tree of Graph \(Q\). If not, explain how you know. J k [m
-
Determine whether Graph \(Q_{1}\) is a spanning tree of Graph \(Q\). If not, explain how you know. m n
-
List three unused (solid) edges from Graph \(O\) that cannot be used to complete the spanning tree. A student has been asked to construct a spanning tree for Graph \(O\), as shown in the figure. The...
Study smarter with the SolutionInn App