This is an answer that Bartleby already answered.  Can I get the calculations in Excel?   Minicase In March 2020, the management team of Londonderry Air (LA) met to discuss a proposal to purchase five shorthaul aircraft at a total cost of $25 million. There was general enthusiasm for the investment and the new aircraft were expected to generate an annual cash flow of $4 million for 20 years.  The focus of the meeting was on how to finance the purchase. LA had $20 million in cash and marketable securities (see table), but Ed Johnson the chief financial officer pointed out that the company needed at least $10 million in cash to meet normal outflow and as a contingency reserve. This meant that there would be a cash defficiency of $15 million, which the firm would need to cover either by the sale of common stock or by additional borrowing. while admitting that the arguments were finely balanced, mR. Johnson recommended an issue of stock. He pointed out that the airline industry was subject to wide swings in profits and the firm should be careful to avoid the risk of excessive borrowing. He estimated that in market value terms, the long-term debt ratio was about 59% and that a further debt issue would raise the ratio to 62%. Mr. Johnson's only doubt about making a stock issue was that investors might jump to the conclusion that management believed the stock was overpriced, in which case the announcement might prompt an unjustified selloff by investors. He stressed therefore, that the company needed to explain carefully the reason for the issue. Also he suggested that demand for the issue would be enhanced if at the same time LA increased its dividend payment. This would provide a tangible indication of management's confidence in the future.  These arguments cut little ice with with LA's chief executive. "Ed," she said, "I know that you're the expert on all this, but everything you say flies in the face of common sense. Why should we want to sell more equity when our stock has fallen over the past year by nearly a fifth? Our stock is currently offering a dividend yield of 6.5%, which makes equity an expensive source of capital. Increasing the dividend would simply make it more expensive. Whats more, I don't see the point of paying out more money to the stockholders at the same time we are asking them for cash. If we hike the dividend, we will need to increase the amount of the stock issue; so we will just be paying the higher dividend out of the shareholders' own pockets. You're also ignoring the question of dilution. Our equity currently has a book value of $12 a share; its not playing fair by our existing shareholders if we now issue stock for around $10 a share.  "Look at the alternative. We can borrow today at 6%. We get a tax break on the interest, so with a 21% tax rate, the after-tax cost of borrowing is (1-.21) x 6% =4.74%. Thats less than the cost of equity. We expect to earn a return of 15% on these new aircfraft. If we can raise money at 4.74% and invest it at 15%, thats a good deal in my book.  'You finance guys are always talking about risk, but as long as we don't go bankrupt, borrowing doesn't add any risk at all.  "Ed, I don't want to push my views on this- after all you're the expert. We don't need to make a firm recommendation to the board until next month. In the meantime, why don't you get one of your new business graduates to look at the whole issue of how we should finance the deal and what return we need to earn on these planes?"  Use the most recently available financial data from 2019 to help evaluate Mr. Johnson's arguments about the stock issue and dividend payment as well as the reply of LA's chief executive. who is correct? what is the required rate of return on the new planes? Summary financial statements for Londonderry Air, 2019 (Figures are book values, in millions of dollars) Balance Sheet Bank debt                        $50                  Cash                                  $20 Other current liabilities     20                  Other current assets            20 10% bond, due 2034*     100                   Fixed assets                       250 Stockholders equity         120                    Total liabilities                   $290              Total assets                         $290   INCOME STATEMENT Gross profit        $57.5 Depreciation       20.0 Interest                7.5 Pretax profit        30.0 Tax                         10.5 Net profit               19.5 Dividend                  6.5   *The yield to maturity on LA debt currently is 6% *LA has 10 million shares outstanding with a market price of $10 a share. LA's equity beta is estimated at 1.25, the market risk premium is 8%, and the treasury bill rate is 3%.

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter11: Cash Flow Estimation And Risk Analysis
Section: Chapter Questions
Problem 1gM
icon
Related questions
Question

This is an answer that Bartleby already answered.  Can I get the calculations in Excel?

 

Minicase

In March 2020, the management team of Londonderry Air (LA) met to discuss a proposal to purchase five shorthaul aircraft at a total cost of $25 million. There was general enthusiasm for the investment and the new aircraft were expected to generate an annual cash flow of $4 million for 20 years. 

The focus of the meeting was on how to finance the purchase. LA had $20 million in cash and marketable securities (see table), but Ed Johnson the chief financial officer pointed out that the company needed at least $10 million in cash to meet normal outflow and as a contingency reserve. This meant that there would be a cash defficiency of $15 million, which the firm would need to cover either by the sale of common stock or by additional borrowing. while admitting that the arguments were finely balanced, mR. Johnson recommended an issue of stock. He pointed out that the airline industry was subject to wide swings in profits and the firm should be careful to avoid the risk of excessive borrowing. He estimated that in market value terms, the long-term debt ratio was about 59% and that a further debt issue would raise the ratio to 62%.

Mr. Johnson's only doubt about making a stock issue was that investors might jump to the conclusion that management believed the stock was overpriced, in which case the announcement might prompt an unjustified selloff by investors. He stressed therefore, that the company needed to explain carefully the reason for the issue. Also he suggested that demand for the issue would be enhanced if at the same time LA increased its dividend payment. This would provide a tangible indication of management's confidence in the future. 

These arguments cut little ice with with LA's chief executive. "Ed," she said, "I know that you're the expert on all this, but everything you say flies in the face of common sense. Why should we want to sell more equity when our stock has fallen over the past year by nearly a fifth? Our stock is currently offering a dividend yield of 6.5%, which makes equity an expensive source of capital. Increasing the dividend would simply make it more expensive. Whats more, I don't see the point of paying out more money to the stockholders at the same time we are asking them for cash. If we hike the dividend, we will need to increase the amount of the stock issue; so we will just be paying the higher dividend out of the shareholders' own pockets. You're also ignoring the question of dilution. Our equity currently has a book value of $12 a share; its not playing fair by our existing shareholders if we now issue stock for around $10 a share. 

"Look at the alternative. We can borrow today at 6%. We get a tax break on the interest, so with a 21% tax rate, the after-tax cost of borrowing is (1-.21) x 6% =4.74%. Thats less than the cost of equity. We expect to earn a return of 15% on these new aircfraft. If we can raise money at 4.74% and invest it at 15%, thats a good deal in my book. 

'You finance guys are always talking about risk, but as long as we don't go bankrupt, borrowing doesn't add any risk at all. 

"Ed, I don't want to push my views on this- after all you're the expert. We don't need to make a firm recommendation to the board until next month. In the meantime, why don't you get one of your new business graduates to look at the whole issue of how we should finance the deal and what return we need to earn on these planes?" 

Use the most recently available financial data from 2019 to help evaluate Mr. Johnson's arguments about the stock issue and dividend payment as well as the reply of LA's chief executive. who is correct? what is the required rate of return on the new planes?

Summary financial statements for Londonderry Air, 2019 (Figures are book values, in millions of dollars)

Balance Sheet

Bank debt                        $50                  Cash                                  $20

Other current liabilities     20                  Other current assets            20

10% bond, due 2034*     100                   Fixed assets                       250

Stockholders equity         120                   

Total liabilities                   $290              Total assets                         $290

 

INCOME STATEMENT

Gross profit        $57.5

Depreciation       20.0

Interest                7.5

Pretax profit        30.0

Tax                         10.5

Net profit               19.5

Dividend                  6.5

 

*The yield to maturity on LA debt currently is 6%

*LA has 10 million shares outstanding with a market price of $10 a share. LA's equity beta is estimated at 1.25, the market risk premium is 8%, and the treasury bill rate is 3%.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College