help fill in the financial ratios sheet given the income statement and balance sheet. (with excel formulas)

. B B C C D E F G H m 1 Years 1989 1990 1991 1992 1993 2 3 4 5 ? ? ? ?? ? ? 6 ? ? ... Turnover Ratios Total Assets Fixed Assets Current Assets Receivables Inventory ? . . . . .... 7 ? ? ? 8 ? ? ? ? ? ? ? 9 ? ? ? ? 10 11 12 ? ? ? ? 13 ? Turnover Ratios / Days Total Assets Fixed Assets Current Assets Receivables Inventory 14 ? ? ? ? ? ? ? ? ? ? ? ? ? ? no no no no no no no no no no 15 16 ? ? 17 18 19 ? ? ? ? ? Leverage Liability/Assets Liability/Equity LT Debt/Equity 20 ? ? ? ? ? ? ? 21 ? ? ? 22 23 24 ? ? ? ? Liquidity Working Capital Current Ratio Quick Ratio n.. ? ? 25 ? ? ... ? ? 26 ? ? ? ? ? 27 28 Coverage Interest 29 ? ? ? ? ? 30 31 32 .. 33 Profitability Ratios Gross Margin Operating Income Income Before Tax Net Profit Operating Income/Assets Net Profit/Assets Net Profit/Equity ? ? ? ? ? ? ? ? ? 34 ? ? ? ? ? ? ? ? ? ? ? ? ? 35 36 ? ? ? 37 ? ? ? ? ? ? ? ? ? ? 38 39 40 4 A B C D E F 1 Years 1989 1990 1991 1992 1993 2 3 Revenues Cost of Sales 33,000 22,841 35,893 24,407 42,555 29,972 52,108 38,412 62,319 47,719 4 5 6 GROSS MARGIN 10,159 11,486 12,583 13,696 14,600 7 8 9 Selling Expenses Administrative Expenses Other 3,214 2,500 640 3,975 2,734 530 4,113 3,041 785 4,675 3,455 905 4,896 3,815 1,054 10 11 12 TOTAL EXPENSES 6,354 7,239 7,939 9,035 9,765 13 14 OPERATING INCOME 3,805 4,247 4,644 4,661 4,835 15 16 Interest Expense 482 505 453 466 691 17 PRE-TAX INCOME 3,323 3,742 4,191 4,195 4,144 18 19 20 Income Taxes (35%) 1,163 1,310 1,467 1,468 1,450 21 22 23 NET PROFIT 2,160 2,432 2,724 2,727 2,694 24 Earnings per Share (EPS) (Dividend / share) 0.07 0.029 0.033 0.033 0.033 25 26 2 B D E F G H 1 J K Years 1989 1990 1991 1992 1993 1 2 ASSETS 3 4 5 6 7 Current Assets: Cash Accounts Receivable Inventories Other Current Assets 422 3,626 5,162 725 1,481 3,702 4,460 877 1,281 4,783 4,872 910 1,247 6,377 5,983 988 1,532 7,476 6,913 1,031 Total Current Assets 9935 10520 11846 14595 16952 8 9 10 11 12 13 14 15 Fixed Assets: Plant & Equipment Accumulated Depreciation: Net Plant Other 5,995 5,995 7,545 6,100 6,100 8,170 7,900 7,900 9,834 10,100 10,100 12,034 13,421 13,421 15,555 Total Fixed Assets 7,545 8,170 9,834 12,034 15,555 TOTAL ASSETS 17,480 18,690 21,680 26,629 32,507 L & O/E 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Current Liabilities: Accounts Payable Accrued Liabilities Notes Payable Short-term Debt 3,187 1,234 3,654 1,020 560 880 2,890 842 640 1,031 4,671 1,538 600 378 6,200 1,844 600 212 0 1,500 Total Current Liabilities 6,114 5,403 5,921 7,187 8,856 0 0 Long-term Debt: Notes Payable Bonds Bank Debt 640 2,000 0 600 4000 2,500 0 1,200 2,500 0 2,500 0 800 30 31 32 33 34 35 36 37 38 Total Long-term Debt 2640 2500 2500 3700 5400 Other Liabilities: Deferred Income Tax 250 150 243 231 307 39 40 TOTAL LIABILITIES 9,004 8,053 8,664 11,118 14,563 Equity: Common Stock Capital Surplus Retained Earnings 1,200 2,150 5,126 41 42 43 44 45 46 47 48 49 1,200 2,150 7,287 1,200 2,150 1,200 2,150 1,200 2,150 Total Equity 8,476 10,637 3,350 3,350 3,350 TOTAL LIABILITIES & OWNERS' EQUITY 17,480 18,690 12,014 14,468 17,913 50 51 52 53 ra