Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need help answering these questions RATIOS AND FINANCIAL PLANNING AT EAST COAST YACHTS Dan Ervin was recently hired by East Coast Yachts to assist

image text in transcribed

image text in transcribed

image text in transcribed

i need help answering these questions

RATIOS AND FINANCIAL PLANNING AT EAST COAST YACHTS Dan Ervin was recently hired by East Coast Yachts to assist the company with its short-term financial planning and also to evaluate the company's financial performance. Dan graduated from college five years ago with a finance degree, and he has been employed in the treasury department of a Fortune 500 company since then. East Coast Yachts was founded 10 years ago by Larissa Warren. The company's operations are located near Hilton Head Island, South Carolina, and the company is structured as an LLC. The company has manufactured custom midsize, high-performance yachts for clients over this period, and its products have received high reviews for safety and reliability. The company's yachts also have recently received the highest award for customer satisfaction. The yachts are primarily purchased by wealthy individuals for pleasure use. Occasionally, a yacht is manufactured for purchase by a company for business purposes. The custom yacht industry is fragmented with a number of manufacturers. As with any industry, there are market leaders, but the diverse nature of the industry ensures that no manu- facturer dominates the market. The competition in the market, as well as the product cost, CHAPTER 3 Financial Statements Analysis and Financial Models EAST COAST YACHTS 2019 Income Statement Sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest Taxable income Taxes (21%) Net income Dividends Additions to retained earnings $231,900,000 170.157.000 27.711,200 7.566.900 $ 26,464,900 4,170,100 $ 22,294,800 4,681,908 $ 17,612,892 $7.925,000 $9,687,892 EAST COAST YACHTS Balance Sheet as of December 31, 2019 Assets Liabilities & Equity Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment $ 3,614,200 6,501,900 7,290.100 $ 17,406,200 Current liabilities Accounts payable Notes payable Total $ 6.977.700 15.776.900 $ 22.754.600 Long-term debt $ 40,100.000 $111,629,300 Shareholders' equity Common stock Retained earnings Total equity Total liabilities and equity $ 6,140,000 60.040,900 $ 66.180.900 $129.035,500 Total assets $129,035,500 Yacht Industry Ratios Lower Quartile Median Upper Quartile 1.89 .62 1.38 16.13 21.45 Current ratio Quick ratio Total asset turnover Inventory turnover Receivables turnover Debt ratio Debt-equity ratio Equity multiplier Interest coverage Profit margin Return on assets Return on equity .50 .21 .68 6.85 6.27 .44 .79 1.79 5.18 4.05% 6.05% 9.93% 1.43 .38 .85 9.15 11.81 .52 1.08 2.08 8.06 6.98% 10.53% 16.54% .61 1.56 2.56 9.83 9.87% 15.83% 28.14% ensures that attention to detail is a necessity. For example, East Coast Yachts will spend 80 to 100 hours on hand-buffing the stainless steel stem-iron, which is the metal cap on the yacht's bow that conceivably could collide with a dock or another boat. To get Dan started with his analyses, Larissa has provided the financial statements. Dan has gathered the industry ratios for the yacht manufacturing industry. 1. Calculate all of the ratios listed in the industry table for East Coast Yachts. 2. Compare the performance of East Coast Yachts to the industry as a whole. For each ratio, comment on why it might be viewed as positive or negative relative to the industry. Sup- pose you create an inventory ratio calculated as inventory divided by current liabilities. How do you interpret this ratio? How does East Coast Yachts compare to the industry average? 3. Calculate the sustainable growth rate of East Coast Yachts. Calculate EFN and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Recalculate the ratios in the previous question. What do you observe? 4. East Coast Yachts is unlikely to be willing to raise external equity capital, in part because the owners don't want to dilute their existing ownership and control positions. However, East Coast Yachts is planning for a growth rate of 20 percent next year. What are your conclusions and recommendations about the feasibility of East Coast's expansion plans? 5. Most assets can be increased as a percentage of sales. For example, cash can be increased by any amount. However, fixed assets often must be increased in specific amounts because it is impossible to buy part of a new plant or machine. In this case, a company has a "staircase" or "lumpy" fixed cost structure. Assume that East Coast Yachts is currently producing at 100 percent of capacity. As a result, to expand production, the company must set up an entirely new line at a cost of $30 million. Calculate the new EFN with this assumption. What does this imply about capacity utilization for East Coast Yachts next year? RATIOS AND FINANCIAL PLANNING AT EAST COAST YACHTS Dan Ervin was recently hired by East Coast Yachts to assist the company with its short-term financial planning and also to evaluate the company's financial performance. Dan graduated from college five years ago with a finance degree, and he has been employed in the treasury department of a Fortune 500 company since then. East Coast Yachts was founded 10 years ago by Larissa Warren. The company's operations are located near Hilton Head Island, South Carolina, and the company is structured as an LLC. The company has manufactured custom midsize, high-performance yachts for clients over this period, and its products have received high reviews for safety and reliability. The company's yachts also have recently received the highest award for customer satisfaction. The yachts are primarily purchased by wealthy individuals for pleasure use. Occasionally, a yacht is manufactured for purchase by a company for business purposes. The custom yacht industry is fragmented with a number of manufacturers. As with any industry, there are market leaders, but the diverse nature of the industry ensures that no manu- facturer dominates the market. The competition in the market, as well as the product cost, CHAPTER 3 Financial Statements Analysis and Financial Models EAST COAST YACHTS 2019 Income Statement Sales Cost of goods sold Other expenses Depreciation Earnings before interest and taxes (EBIT) Interest Taxable income Taxes (21%) Net income Dividends Additions to retained earnings $231,900,000 170.157.000 27.711,200 7.566.900 $ 26,464,900 4,170,100 $ 22,294,800 4,681,908 $ 17,612,892 $7.925,000 $9,687,892 EAST COAST YACHTS Balance Sheet as of December 31, 2019 Assets Liabilities & Equity Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment $ 3,614,200 6,501,900 7,290.100 $ 17,406,200 Current liabilities Accounts payable Notes payable Total $ 6.977.700 15.776.900 $ 22.754.600 Long-term debt $ 40,100.000 $111,629,300 Shareholders' equity Common stock Retained earnings Total equity Total liabilities and equity $ 6,140,000 60.040,900 $ 66.180.900 $129.035,500 Total assets $129,035,500 Yacht Industry Ratios Lower Quartile Median Upper Quartile 1.89 .62 1.38 16.13 21.45 Current ratio Quick ratio Total asset turnover Inventory turnover Receivables turnover Debt ratio Debt-equity ratio Equity multiplier Interest coverage Profit margin Return on assets Return on equity .50 .21 .68 6.85 6.27 .44 .79 1.79 5.18 4.05% 6.05% 9.93% 1.43 .38 .85 9.15 11.81 .52 1.08 2.08 8.06 6.98% 10.53% 16.54% .61 1.56 2.56 9.83 9.87% 15.83% 28.14% ensures that attention to detail is a necessity. For example, East Coast Yachts will spend 80 to 100 hours on hand-buffing the stainless steel stem-iron, which is the metal cap on the yacht's bow that conceivably could collide with a dock or another boat. To get Dan started with his analyses, Larissa has provided the financial statements. Dan has gathered the industry ratios for the yacht manufacturing industry. 1. Calculate all of the ratios listed in the industry table for East Coast Yachts. 2. Compare the performance of East Coast Yachts to the industry as a whole. For each ratio, comment on why it might be viewed as positive or negative relative to the industry. Sup- pose you create an inventory ratio calculated as inventory divided by current liabilities. How do you interpret this ratio? How does East Coast Yachts compare to the industry average? 3. Calculate the sustainable growth rate of East Coast Yachts. Calculate EFN and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Recalculate the ratios in the previous question. What do you observe? 4. East Coast Yachts is unlikely to be willing to raise external equity capital, in part because the owners don't want to dilute their existing ownership and control positions. However, East Coast Yachts is planning for a growth rate of 20 percent next year. What are your conclusions and recommendations about the feasibility of East Coast's expansion plans? 5. Most assets can be increased as a percentage of sales. For example, cash can be increased by any amount. However, fixed assets often must be increased in specific amounts because it is impossible to buy part of a new plant or machine. In this case, a company has a "staircase" or "lumpy" fixed cost structure. Assume that East Coast Yachts is currently producing at 100 percent of capacity. As a result, to expand production, the company must set up an entirely new line at a cost of $30 million. Calculate the new EFN with this assumption. What does this imply about capacity utilization for East Coast Yachts next year

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

Forecasting And Predictive Analytics With Forecast X

Authors: Barry Keating, J. Holton Wilson, John Solutions Inc.

7th International Edition

1260085236, 9781260085235

More Books

Students also viewed these Finance questions

Question

98. For a compound random variable S = N i=1 Xi , find Cov(N, S).

Answered: 1 week ago