answer with excel formulas

4 A B D E F G H 1 Years 1989 1990 1991 1992 1993 2 3 ASSETS 4 5 Current Assets: Cash Accounts Receivable Inventories 6 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 7 8 Other Current Assets 9 Total Current Assets ? ? ? ? ? 10 11 12 13 14 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 15 16 17 Total Fixed Assets ? ? ? ? ? TOTAL ASSETS ? ? ? ? ? L&O/E Current Liabilities: Accounts Payable Accrued Liabilities Notes Payable Short-term Debt 2,890 842 3,654 1,020 560 880 3,187 1,234 0 1,500 4,671 1,538 600 378 6,200 1,844 600 212 640 1,031 Total Current Liabilities ? ? ? ? ? 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 0 0 Long-term Debt: Notes Payable Bonds Bank Debt 640 2,000 0 2,500 0 2,500 0 1,200 2,500 0 600 4000 800 Total Long-term Debt ? ? ? ? Other Liabilities: Deferred Income Tax 250 150 243 231 307 TOTAL LIABILITIES ? ? ? ? ? 42 43 44 Equity: Common Stock Capital Surplus Retained Earnings 1,200 2,150 5,126 1,200 2,150 7,287 1,200 2,150 1,200 2,150 1,200 2,150 45 46 47 Total Equity ? ? ? ? ? 48 49 50 TOTAL LIABILITIES & OWNERS' EQUITY ? ? ? ? ? 51 52