please answer the questions in an excel doc and i will provide a thumbs up in return thank you
AD2F%2Fxdata-ud-ccb4c294 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 manufacturer dominates the market. The competition in the market, as well as the product cost, 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. Pape 84 EAST COAST YACHTS 2019 Income Statement Sales $231,900,000 Cossed MacBook Pro CHI % & 7 4 6 8 0 5 2 3 9 0 P Q U W E R T S D F. G . J A H. V C . N B N DO EAST COAST YACHTS 2019 Income Statement Sales $231,900,000 Cost of goods sold 170,157,000 Other expenses 27,711,200 Depreciation 7,566,900 Earnings before interest and taxes (EBIT) $ 26,464,900 Interest 4,170,100 Taxable income $ 22,294,800 Taxes (21%) Net income 4,681,908 $ 17,612.892 Dividends $7,925,000 Additions to retained earnings $9,687,892 EAST COAST YACHTS Balance Sheet as of December 31, 2019 MacBook Pro 20 F F5 Fo FT & 3 4 5 7 8 9 0 EAST COAST YACHTS Balance Sheet as of December 31, 2019 Assets Liabilities & Equity Current liabilities Current assets Cash $ 3,614,200 Accounts payable $ 6,977,700 Accounts receivable 6,501,900 Notes payable 15,776,900 Inventory 7,290,100 Total $ 22.754,600 Total $ 17,406,200 Fixed assets Long-term debt $ 40,100,000 Net plant and equipment $111,629,300 Shareholders' equity Common stock $ 6,140,000 Retained earnings 60,040,900 Total equity $ 66,180.900 Total assets $ 129,035,500 Total liabilities and equity $129,035,500 MacBook Pro 80 000 DI DD 55 $ 03 N 3 4 5 6 7 8 9 0 C Yacht Industry Ratios Lower Quartile Median Upper Quartile Current ratio .50 1.43 1.89 Quick ratio .21 .38 .62 Total asset turnover .68 .85 1.38 Inventory turnover 6.85 9.15 16.13 Receivables turnover 6.27 11.81 21.45 Debt ratio .44 -52 .61 Debt-equity ratio .79 1.08 1.56 Equity multiplier 1.79 2.08 2.56 Interest coverage 5.18 8.06 9.83 Profit margin 4.05% 6.98% 9.87% Return on assets 6.05% 10.53% 15.83% Return on equity 9.93% 16.54% 28.14% ced with his analyses, Larissa has provided the financial statements. Dan has gathered the industry MacBook Pro F3 F4 F5 57 FB Debt ratio 44 .52 .61 Debt-equity ratio .79 1.08 1.56 Equity multiplier 1.79 2.08 2.56 5.18 8.06 9.83 4.05% 6.98% 9.87% Interest coverage Profit margin Return on assets Return on equity 6.05% 10.53% 15.83% 9.93% 16.54% 28.14% 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. Suppose 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? MacBook Pro 80 868 2 $ 4 3 % 5 6 & 7 00 9 0 W E R T Y U 0 S D F G H. J K C V B N . command command AD2F%2Fxdata-ud-ccb4c294 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 manufacturer dominates the market. The competition in the market, as well as the product cost, 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. Pape 84 EAST COAST YACHTS 2019 Income Statement Sales $231,900,000 Cossed MacBook Pro CHI % & 7 4 6 8 0 5 2 3 9 0 P Q U W E R T S D F. G . J A H. V C . N B N DO EAST COAST YACHTS 2019 Income Statement Sales $231,900,000 Cost of goods sold 170,157,000 Other expenses 27,711,200 Depreciation 7,566,900 Earnings before interest and taxes (EBIT) $ 26,464,900 Interest 4,170,100 Taxable income $ 22,294,800 Taxes (21%) Net income 4,681,908 $ 17,612.892 Dividends $7,925,000 Additions to retained earnings $9,687,892 EAST COAST YACHTS Balance Sheet as of December 31, 2019 MacBook Pro 20 F F5 Fo FT & 3 4 5 7 8 9 0 EAST COAST YACHTS Balance Sheet as of December 31, 2019 Assets Liabilities & Equity Current liabilities Current assets Cash $ 3,614,200 Accounts payable $ 6,977,700 Accounts receivable 6,501,900 Notes payable 15,776,900 Inventory 7,290,100 Total $ 22.754,600 Total $ 17,406,200 Fixed assets Long-term debt $ 40,100,000 Net plant and equipment $111,629,300 Shareholders' equity Common stock $ 6,140,000 Retained earnings 60,040,900 Total equity $ 66,180.900 Total assets $ 129,035,500 Total liabilities and equity $129,035,500 MacBook Pro 80 000 DI DD 55 $ 03 N 3 4 5 6 7 8 9 0 C Yacht Industry Ratios Lower Quartile Median Upper Quartile Current ratio .50 1.43 1.89 Quick ratio .21 .38 .62 Total asset turnover .68 .85 1.38 Inventory turnover 6.85 9.15 16.13 Receivables turnover 6.27 11.81 21.45 Debt ratio .44 -52 .61 Debt-equity ratio .79 1.08 1.56 Equity multiplier 1.79 2.08 2.56 Interest coverage 5.18 8.06 9.83 Profit margin 4.05% 6.98% 9.87% Return on assets 6.05% 10.53% 15.83% Return on equity 9.93% 16.54% 28.14% ced with his analyses, Larissa has provided the financial statements. Dan has gathered the industry MacBook Pro F3 F4 F5 57 FB Debt ratio 44 .52 .61 Debt-equity ratio .79 1.08 1.56 Equity multiplier 1.79 2.08 2.56 5.18 8.06 9.83 4.05% 6.98% 9.87% Interest coverage Profit margin Return on assets Return on equity 6.05% 10.53% 15.83% 9.93% 16.54% 28.14% 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. Suppose 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? MacBook Pro 80 868 2 $ 4 3 % 5 6 & 7 00 9 0 W E R T Y U 0 S D F G H. J K C V B N . command command
