4 and 5

estuur way UNCLE GUY PIONS UI Urscrepancies that may exist! 4. On the "Common-Sized" worksheet.create a set of common-sized financial statements. 5. On the "Growth Rates worksheet, calculate growth rates for each of the Income Statement and Balance Sheet entries. 6. On the "AFN worksheet calculate the additional financinded A B D E F G H 2020 2021 1 Sea Thru Surfboards 2 Common-Size Income Statement 3 (% Sales) 4 Sales 5 Cost of goods sold 6 Depreciation 7 Eamings before interest and taxes 8 Interest paid 9 Taxable income 10 Taxes (34%) 11 Net Income 12 13 Dividends 14 Addition to retained camings 15 16 17 Sea Thru Surfboards 18 Common-Size Balance Sheets 19 (% Assets) 20 21 Assets 22 Current Assets 23 Cash 24 Accounts receivable 25 Inventory 26 Total Current Assets 27 28 Fixed Assets 29 Not plant and 30 equipment 31 32 33 34 35 36 Total assets 37 38 39 4 Financial Statements 2020 2021 2020 2021 Current Llabilities Accounts payable Accruals Notes Payable Total Current Liabilities Long-term debt Owner's Equity Common stock and paid in surplus Retained Eamings Total Equity Total Debt and Equity Cash Flow Ratio Analysis Common-sized Growth Rates B c D E F G H 2021 2020 NA NA NA N/A N/A NA NA N/A 1 Sea Thru Surfboards 2 Growth Rates 3 4 Sales 5 Cost of goods sold 6 Depreciation 7 Eamings before interest and taxes 8 Interest paid 9 Taxable income 10 Taxes (34%) 11 Net Income 12 13 Dividends 14 Addition to retained eamings 15 16 17 Sea Thru Surfboards 18 Common Size Balance Sheets 19 20 21 Assets 22 Current Assets 23 Cash 24 Accounts receivable 25 Inventory 26 Total Current Assets 27 28 Fixed Assets 29 Net plant and 30 equipment 31 32 33 34 35 36 Total assets 37 38 39 20 2020 2020 2021 NA NA NA Current Liabilities Accounts payable Notes payable Other Total Current Liabilities N/A NA NIA NA Long-term debt NA NA Owner's Equity Common stock and pald-in surplus Retained Eamingo Total Equity NA NIA NA N/A Total Debt and Equity N/A B D G H 2020 2021 2020 2021 1,040 2,904 6,218 10.162 644 3,812 5.910 10.366 Current Liabilities Accounts payable Accruals Notes payable Total Current Liabilities 1,704 60 826 2590 1,872 418 858 3148 Long-term debt 6.234 5,000 19,088 20,066 Owner's Equity Common stock and paldin surplus Retained Esmings Total Equity 20,000 426 20,426 20,000 2284 22,284 29 250 30,432 1 Sea Thru Surfboards 2 Balance Sheets as of December 31 3 4 5 Assets 6 Current Assets 7 Cash 8 Accounts recevable 0 Inventory 10 Total Current Assets 11 12 Fixed Assets 13 Net plant and 14 equipment 16 16 17 18 19 20 Total assets 21 22 23 SeaThru Surfboards, Inc. 24 Income Statement 25 26 Sales 27 Cost of goods sold 28 Depreciation 29 Eamings before interest and taxes 30 Interest paid 31 Taxable income 32 Taxes (34%) 33 Net Income 34 35 Dividends 36 Addition to retained oamingo 37 38 30 Shares outstanding 40 Price persham 41 Allan Cost of capital Financial Statements Total Debt and Equity 29.250 30,432 2,020 20,160 7,020 1.170 11,970 1000 10,970 3.730 7.240 2,021 22.400 7,800 1,300 13,300 1.170 12.130 4 124 8.000 6,148 1,092 6,148 1.858 10,000 $12 10.000 $14 ON Cash Flow Ratio Analysis Common-sized Growth Rates AFN