Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please list examples in Excel with formulas. Stephenson Real Estate Company was founded 25 years ago by the current CEO, Robert Stephenson. The company purchases

Please list examples in Excel with formulas.

Stephenson Real Estate Company was founded 25 years ago by the current CEO, Robert Stephenson. The company purchases real estate, including land and buildings, and rents the property to tenants. The company has shown a profit every year for the past 18 years, and the shareholders are satisfied with the companys management. Prior to founding Stephenson Real Estate, Robert was the founder and CEO of a failed alpaca farming operation. The resulting bankruptcy made him extremely averse to debt financing. As a result, the company is entirely equity financed, with 8.7 million shares of common stock outstanding. The stock currently trades at $46.50 per share.

Stephenson is evaluating a plan to purchase a huge tract of land in the southeastern United States for $65 million. The land will subsequently be leased to tenant farmers. This purchase is expected to increase Stephensons annual pretax earnings by $14 million in perpetuity. Kim Weyand, the companys new CFO, has been put in charge of the project. Kim has determined that the companys current cost of capital is 12.5 percent. She feels that the company would be more valuable if it included debt in its capital structure, so she is evaluating whether the company should issue debt to entirely finance the project. Based on some conversations with investment banks, she thinks that the company can issue bonds at par value with a coupon rate of 8 percent. From her analysis, she also believes that a capital structure in the range of 70 percent equity/30 percent debt would be optimal. If the company goes beyond 30 percent debt, its bonds would carry a lower rating and a much higher coupon because the possibility of financial distress and the associated costs would rise sharply. Stephenson has a 21 percent corporate tax rate (state and federal).

image text in transcribedimage text in transcribedimage text in transcribed Input area: \begin{tabular}{|c|c|c|} \hline Shares outstanding & & 8,700,000 \\ \hline Share price & $ & 46.50 \\ \hline Purchase price of land & $ & 65,000,000 \\ \hline Perpetual earnings increase & $ & 14,000,000 \\ \hline Current cost of capital & & 12.50% \\ \hline Cost of new debt & & 8% \\ \hline Optimal equity weight & & 70% \\ \hline Optimal debt weight & & 30% \\ \hline Tax rate & & 21% \\ \hline \end{tabular} If Stephenson wishes to maximize its total market value, would you recommend that it issue debt or d) PV of earnings increase Old assets PV of project Total assets 4) a) Value of levered company b) Value unlevered Tax shield value Total assets Stock share price ? \begin{tabular}{|c|c|c|c|} \hline & Balance Sheet & & \\ \hline$ & 404,550,000 & & \\ \hline ? & & Equity & ? \\ \hline ? & & Debt \& Equity & ? \\ \hline \end{tabular} Balance Sheet Debt Equity Debt \& Equity \begin{tabular}{l} ? \\ ? \\ \hline? \end{tabular} 5) Which method of financing maximizes the per share stock price of Stephenson's equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Financial Modelling Model Design And Best Practices Using Excel And VBA

Authors: Michael Rees

1st Edition

111890401X, 978-1118904015

More Books

Students also viewed these Finance questions

Question

What obstacles interfere with eff ective listening?

Answered: 1 week ago