Please make sure to calculate the EFN, pro forma income statement and balance sheet. Please show work. Thank you!

Calculate the sustainable growth rate, EFN, pro forma income statements and balance sheet. Please show work.

S 44,462,550 6,125,200 $ 50,587,750 2017 Income Statement Sales 5611,482,000 Cost of Goods Sold 431,000,000 Selling general & admin expense 73,095,600 Depreciation 19.95B 500 ERIT $ 87,427,900 Interest expense 11,003,000 $ 76,424,900 Taxes 30.569.960 Nincome $45.854,940 Dividends $ 16,009,229 Retained Earnings $ 29,805,711 $ 169,260.000 $169,260,000 2017 Balance Shee Current Assets Current liabilities Cash and equivalents $ 11,120,700 Accounts payable Accounts recevable 18.681,500 Accrued expenses Inventory 20,150,650 Total current liabilities Other 1.174.200 Total current assets $ 51,127,050 Fixed assets Long-term debt Property, plant and equipment $ 457,510,500 Total long-term liabilities Less accumulated depreciation (113.845.900) Net property, plant and equipment $343,664,700 Intangible assets and others 6,775,000 Stockholders' equity Total fled assets $ 350.409,700 Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity Total assets S 401.566.750 Total abilities and shareholders equity Calculate the sustainable growth rate for Pacific Coast Sailing Calculate the 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? $ 1,970,000 37,585,700 28,116,300 161,567,000 (47 520,000 $ 181,719.000 S401,566,750 2017 Balance Sheet Current liabilities Accounts payable Accrued expenses Total current liabilities Sales COGS Other expenses Depreciation ENT Interest Taxable income Taxes (40%) Net income Current Assets Cash and equivalents Accounts receivable inventory Other Total current assets Long-term debt Total long-term liabilities Fixed assets Dividends Add to RE Stockholders' equity Preferred stock Common stock Capital surplus Accumulated retained earings Less treasury stock Total equity talabilities and shareholders' equity Total assets 3. Calculate the sustainable growth rate for Pacific Coast Sailing Calculate the EFN and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Calculate the ratios on the right side. To calculate the sustainable growth rate, we first need to find the ROE and the retention ratios The sustainable growth rate is the growth rate the company can achieve with no external financing while maintaining a constant debt-equity ratio At the sustainable growth rate the proforma statements next year will be COGS Other expenses Current Assets Cash and equivalents Accounts receivable Inventory Pacific Coastal 2017 Balance Sheet Current Accounts payable Accrued expenses Total current liabilities Interest Other Total current assets Taxes (ON) Long-term debe Total long-term abilities Fixed assets Dividends Add to RE 25 Stockholm Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity Total abilities and shareholders equity S 44,462,550 6,125,200 $ 50,587,750 2017 Income Statement Sales 5611,482,000 Cost of Goods Sold 431,000,000 Selling general & admin expense 73,095,600 Depreciation 19.95B 500 ERIT $ 87,427,900 Interest expense 11,003,000 $ 76,424,900 Taxes 30.569.960 Nincome $45.854,940 Dividends $ 16,009,229 Retained Earnings $ 29,805,711 $ 169,260.000 $169,260,000 2017 Balance Shee Current Assets Current liabilities Cash and equivalents $ 11,120,700 Accounts payable Accounts recevable 18.681,500 Accrued expenses Inventory 20,150,650 Total current liabilities Other 1.174.200 Total current assets $ 51,127,050 Fixed assets Long-term debt Property, plant and equipment $ 457,510,500 Total long-term liabilities Less accumulated depreciation (113.845.900) Net property, plant and equipment $343,664,700 Intangible assets and others 6,775,000 Stockholders' equity Total fled assets $ 350.409,700 Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity Total assets S 401.566.750 Total abilities and shareholders equity Calculate the sustainable growth rate for Pacific Coast Sailing Calculate the 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? $ 1,970,000 37,585,700 28,116,300 161,567,000 (47 520,000 $ 181,719.000 S401,566,750 2017 Balance Sheet Current liabilities Accounts payable Accrued expenses Total current liabilities Sales COGS Other expenses Depreciation ENT Interest Taxable income Taxes (40%) Net income Current Assets Cash and equivalents Accounts receivable inventory Other Total current assets Long-term debt Total long-term liabilities Fixed assets Dividends Add to RE Stockholders' equity Preferred stock Common stock Capital surplus Accumulated retained earings Less treasury stock Total equity talabilities and shareholders' equity Total assets 3. Calculate the sustainable growth rate for Pacific Coast Sailing Calculate the EFN and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Calculate the ratios on the right side. To calculate the sustainable growth rate, we first need to find the ROE and the retention ratios The sustainable growth rate is the growth rate the company can achieve with no external financing while maintaining a constant debt-equity ratio At the sustainable growth rate the proforma statements next year will be COGS Other expenses Current Assets Cash and equivalents Accounts receivable Inventory Pacific Coastal 2017 Balance Sheet Current Accounts payable Accrued expenses Total current liabilities Interest Other Total current assets Taxes (ON) Long-term debe Total long-term abilities Fixed assets Dividends Add to RE 25 Stockholm Preferred stock Common stock Capital surplus Accumulated retained earnings Less treasury stock Total equity Total abilities and shareholders equity