Graph the results of the changing wacc

Reference no: EM131099323

Complete the following problem sets in Financial Management using Microsoft Excel:

1. Changing WACC and optimal choice. Austin Enterprises is currently an all-equity firm. The firm is considering selling debt (bonds) and retiring some of the equity. However, at each level of debt, debt becomes more expensive (cost of debt is rising), and the riskiness of the equity also rises with more and more debt. Using a spreadsheet, determine the best combination of debt and equity for Austin Enterprises if

• The current beta of Austin Enterprises is 0.85.
• The current market return is 12%.
• The current risk-free rate is 3%.
• The total equity is 20,000,000 shares at $25 per share.
• Debt is sold in units of $2,000,000.
• The first unit of debt has a cost of 7.5%.
• The tax rate of Austin Enterprises is 40%.
• For each additional unit of debt (each additional $2,000,000), the cost of debt rises by 0.85%, and the beta of Austin Enterprises rises by 0.025.

Where is the WACC the lowest? Graph the results of the changing WACC.

Reference no: EM131099323

Questions Cloud

What is the minimum value of the laser pulse energy : What is the minimum value of the laser pulse energy for which SBS can be excited? (In fact, transverse SBS has been observed under such conditions similar to those assumed in this problem; see, for example, Murray et al., 1989.)

Discuss the results of your treatment or goal service plan : Discuss the results of your Treatment or Goal Service Plan. Complete a Treatment or Goal Service plan as a team after discussing the results of the individual plans.

What would be the appropriate hypotheses statements : What examples (professional, personal, social) can you provide on when we might use each type? What would be the appropriate hypotheses statements for each example?

Analyze how the film treats this moral issue : For this assignment, you will select a film that deals with a moral concern. You will briefly summarize this film (250 words). Then, you will analyze how the film treats this moral issue. Use the text to support your analysis (about 500 words). Th..

Graph the results of the changing wacc : Changing WACC and optimal choice. Austin Enterprises is currently an all-equity firm. The firm is considering selling debt (bonds) and retiring some of the equity. Where is the WACC the lowest? Graph the results of the changing WACC.

Test the overall significance of the model : Discuss your summary report in terms of significance of the coefficients, R2 and overall significance of the model based on the F-statistic - Is there evidence to suggest that smoking causes a low birth weight?

Television audiences of newscasts tend to be older : Because television audiences of newscasts tend to be older (and because older people suffer from a variety of medical ailments) pharmaceutical companies' advertising often appears on national news in the three networks (ABC, CBS, and NBC). The ads..

Determine the necessary throttle-cable tension t : The throttle-control sector pivots freely at O. If an internal torsional spring exerts a return moment M = 1.8 N · m on the sector when in the position shown, for design purposes determine the necessary throttle-cable tension T so that the net mom..

A standard normal random variable : I. The following numbers represent a random sample from a normal distribution with variance of 16 and unknown mean p:o 7.64 6.38 6.06 5.59 2.03 1.17 8.42 -6.83 2.25 5.78 7.56 4.33'

User Account

All Pages