Integrativelong dashOptimal capital structure The board of directors of Morales Publishing, Inc., has commissioned a capital structure study. The company has total assets of $40,800,000 . It has earnings before interest and taxes of $7,910,000 and is taxed at a rate of 27% .
a. Create a spreadsheet showing values of debt and equity as well as the total number of shares, assuming a book value of $25 per share.
b. Given the before-tax cost of debt at various levels of indebtedness, calculate the yearly interest expenses.
c. Using EBIT of $7,910,000 , a 27% tax rate, and the information developed in parts (a) and (b), calculate the most likely earnings per share for the firm at various levels of indebtedness. Mark the level of indebtedness that maximizes EPS.
d. Using the EPS developed in part (c), the estimates of required return, r Subscript s and the equation Upper P0=EPS/ rs , estimate the value per share at various levels of indebtedness. Mark the level of indebtedness in the following table that results in the maximum price per share, P0 .
e. Prepare a recommendation to the board of directors of Morales Publishing that specifies the degree of indebtedness that will accomplish the firm's goal of optimizing shareholder wealth. Use your findings in parts (a) through (d) to justify your recommendation. a. Create a spreadsheet showing values of debt and equity as well as the total number of shares, assuming a book value of $ 25 per share.
Solution | |||||||||
a) | Book Value/Share $25 | ||||||||
A | B | C | D | E | |||||
C=A*B | D=B-C | E=D/25 | |||||||
Debt | Total Assets | Debt | Equity | No of Shares | |||||
0% | 40800000 | 0 | 40800000 | 1632000 | |||||
10% | 40800000 | 4080000 | 36720000 | 1468800 | |||||
20% | 40800000 | 8160000 | 32640000 | 1305600 | |||||
30% | 40800000 | 12240000 | 28560000 | 1142400 | |||||
40% | 40800000 | 16320000 | 24480000 | 979200 | |||||
50% | 40800000 | 20400000 | 20400000 | 816000 | |||||
60% | 40800000 | 24480000 | 16320000 | 652800 | |||||
70% | 40800000 | 28560000 | 12240000 | 489600 | |||||
80% | 40800000 | 32640000 | 8160000 | 326400 | |||||
90% | 40800000 | 36720000 | 4080000 | 163200 | |||||
b) | Interest on debt is assumed as 10% | ||||||||
EBIT=7910000 | |||||||||
A | B | C | D | ||||||
C=A*B | D=C*10% | ||||||||
Debt | Total Assets | Debt | Interest Expense | ||||||
0% | 40800000 | 0 | 0 | ||||||
10% | 40800000 | 4080000 | 408000 | ||||||
20% | 40800000 | 8160000 | 816000 | ||||||
30% | 40800000 | 12240000 | 1224000 | ||||||
40% | 40800000 | 16320000 | 1632000 | ||||||
50% | 40800000 | 20400000 | 2040000 | ||||||
60% | 40800000 | 24480000 | 2448000 | ||||||
70% | 40800000 | 28560000 | 2856000 | ||||||
80% | 40800000 | 32640000 | 3264000 | ||||||
90% | 40800000 | 36720000 | 3672000 | ||||||
c) | EBIT=7910000 | ||||||||
A | B | C | D | E | F | G | H | I | |
C=A*B | D=C*10% | E=EBIT-D | =E*27% | G=E-F | I=G/H | ||||
Debt | Total Assets | Debt | Interest Expense | EBT | Tax@27% | EAT | No of shares | EPS | |
0% | 40800000 | 0 | 0 | 7910000 | 2135700 | 5774300 | 1632000 | 3.54 | |
10% | 40800000 | 4080000 | 408000 | 3830000 | 1034100 | 2795900 | 1468800 | 3.73 | |
20% | 40800000 | 8160000 | 816000 | -250000 | -67500 | -182500 | 1305600 | 3.97 | |
30% | 40800000 | 12240000 | 1224000 | -4330000 | -1169100 | -3160900 | 1142400 | 4.27 | |
40% | 40800000 | 16320000 | 1632000 | -8410000 | -2270700 | -6139300 | 979200 | 4.68 | |
50% | 40800000 | 20400000 | 2040000 | -12490000 | -3372300 | -9117700 | 816000 | 5.25 | |
60% | 40800000 | 24480000 | 2448000 | -16570000 | -4473900 | -1.2E+07 | 652800 | 6.11 | |
70% | 40800000 | 28560000 | 2856000 | -20650000 | -5575500 | -1.5E+07 | 652800 | 5.65 | |
80% | 40800000 | 32640000 | 3264000 | -24730000 | -6677100 | -1.8E+07 | 652800 | 5.20 | |
90% | 40800000 | 36720000 | 3672000 | -28810000 | -7778700 | -2.1E+07 | 652800 | 4.74 | |
EBIT =Earnings Before Interest and Tax | |||||||||
EBT=Earnings After Interest Before Tax | |||||||||
EAT=Earnings After Tax | |||||||||
d) | Estimated Required return assumed as 15% | ||||||||
A | B | C | D | E | F | ||||
F=E/15% | |||||||||
Debt | Total Assets | Debt | No of shares | EPS | Po | ||||
0% | 40800000 | 0 | 1632000 | 3.54 | 35.38 | ||||
10% | 40800000 | 4080000 | 1468800 | 3.73 | 37.29 | ||||
20% | 40800000 | 8160000 | 1305600 | 3.97 | 39.66 | ||||
30% | 40800000 | 12240000 | 1142400 | 4.27 | 42.72 | ||||
40% | 40800000 | 16320000 | 979200 | 4.68 | 46.80 | ||||
50% | 40800000 | 20400000 | 816000 | 5.25 | 52.51 | ||||
60% | 40800000 | 24480000 | 652800 | 6.11 | 61.08 | ||||
70% | 40800000 | 28560000 | 652800 | 5.65 | 56.52 | ||||
80% | 40800000 | 32640000 | 652800 | 5.20 | 51.95 | ||||
90% | 40800000 | 36720000 | 652800 | 4.74 | 47.39 |
Integrativelong dashOptimal capital structure The board of directors of Morales Publishing, Inc., has commissioned a capital...
Integrative-Optimal capital structure Medallion Cooling Systems, Inc., has total assets of $9,000,000, EBIT of $2,050,000, and preferred dividends of $200,000 and is taxed at a rate of 40%. In an effort to determine the optimal capital structure, the firm has assembled data on the cost of debt, the number of shares of common stock for various levels of indebtedness, and the overall required return on investment: Capital structure debt ratio Cost of debt, rd 0% 0% 15 Number of common...
Integrative-Optimal capital structure Medallion Cooling Systems, has total assets of $9,400,000, EBIT of $1,960,000, and preferred dividends of $196,000 and is taxed at a rate of 40%. In an effort to determine the optimal capital structure, the firm has assembled data on the cost of debt, the number of shares of common stock for various levels of indebtedness, and the overall required return on investment: Capital structure debt ratio 0% Cost of debt, rd 0% 15 7.9 Number of common...
Integrative—Optimal capital structure Medallion Cooling Systems, has total assets of $10,500,000, EBIT of $2,010,000, and preferred dividends of $199,000 and is taxed at a rate of 40%. In an effort to determine the optimal capital structure, the firm has assembled data on the cost of debt, the number of shares of common stock for various levels of indebtedness, and the overall required return on investment: Capital structure debt ratio 0% Cost of debt, rd. 0% 7.9 Number of common stock...
Larissa has been talking with the company’s directors about the future of East Coast Yachts. To this point, the company has used outside suppliers for various key components of the company’s yachts, including engines. Larissa has decided that East Coast Yachts should consider the purchase of an engine manufacturer to allow East Coast Yachts to better integrate its supply chain and get more control over engine features. After investigating several possible companies, Larissa feels that the purchase of Ragan Engines,...
Analyse the managerial challenges that Unilever CEO Paul Polman has encountered in the development and implementation of the Unilever Sustainable Living Plan (USLP) Strategy: PART A - Identify the Planning and Controlling issue There are essentially three topics (and consequently three problems) that will be covered in this assignment: planning and controlling (together) leading organising Article Below: Unilever’s New Global Strategy: Competing through Sustainability In January 2015, CEO Paul Polman announced Unilever’s financial results for 2014. (See Exhibit 1.) It...
Read the case: Netflix Inc.: The Second Act - Moving into Streaming and complete your case analysis. Discuss the following: 1) briefly summarize the key marketing strategy issues in the case that are still relevant TODAY in addition to contemporary issues you find via research; 2) make thorough recommendations on how the issues should be handled; 3) provide a justification for the recommendations. Case write-ups should be 3-5 pages, double spaced, 12 font size in Times New Roman. The case...
I need Summary of this Paper i dont need long summary i need What methodology they used , what is the purpose of this paper and some conclusions and contributes of this paper. I need this for my Finishing Project so i need this ASAP please ( IN 1-2-3 HOURS PLEASE !!!) Budgetary Policy and Economic Growth Errol D'Souza The share of capital expenditures in government expenditures has been slipping and the tax reforms have not yet improved the income...
I have this case study to solve. i want to ask which type of case study in this like problem, evaluation or decision? if its decision then what are the criterias and all? Stardust Petroleum Sendirian Berhad: how to inculcate the pro-active safety culture? Farzana Quoquab, Nomahaza Mahadi, Taram Satiraksa Wan Abdullah and Jihad Mohammad Coming together is a beginning; keeping together is progress; working together is success. - Henry Ford The beginning Stardust was established in 2013 as a...
How can we assess whether a project is a success or a failure? This case presents two phases of a large business transformation project involving the implementation of an ERP system with the aim of creating an integrated company. The case illustrates some of the challenges associated with integration. It also presents the obstacles facing companies that undertake projects involving large information technology projects. Bombardier and Its Environment Joseph-Armand Bombardier was 15 years old when he built his first snowmobile...