please answer first and the second in excel and the third pic is the ready balance sheet !!

i hope this clear bec there is more clear pic , it clue from chegg!!

Income Statement (5000) Years 1989 1990 1991 1992 1993 Revenues Cost of Sales 33.000 22,841 35.893 24,407 42,555 29.972 52,108 38,412 62,319 47.719 GROSS MARGIN ? ? ? 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 TOTAL EXPENSES ? ? 7 2 OPERATING INCOME ? ? 2 2 ? Interest Expense 482 505 453 466 691 PRE TAX INCOME ? 2 ? 2 2 Income Taxes (35%) 2 ? 2 7 NET PROFIT 2 2 Earnings per Share (EPS) (Dividend / share) Note: Number of outstanding shares is 33,000 40% of Net Profit will be distributed to shareholders HAPPY DAZE CORPORATION Financial Ratios YEARS 1989 1990 1991 1992 1993 Average Turnover Ratios Total Assets Fixed Assets Current Assets Receivables Inventory Payables Turnover /Days Total Assets Fixed Assets Current Assets Receivables Inventory Payables Leverage Liability Assets Liability Equity LT DebuEquity Liquidity Working Capital Current Ratio Quick Ratio Coverage Interest Profitability Gross Profit Margin Net Operating Income Profit Margin on Sales ROA ROE 13:07 Done Answer 1 of 1 Formulas are as follows: For total in excelsum(Column1,Colum2) 4:10 PM Sheet1 4595 6100 HAPPY DAZE CORPORATIONS lance Sheet (5000 1999 1999 1991 1992 ASSETS Current at Ch 1401 Aceable 126 2702 47 637 orventories 51624460 4872 10 Other Current 725 877 910 90 11 Total Current Assets wa 10520 12 15 Red Assets 54 Port and Equipment 5995 79001010010 15 Accumulated deprecio $995 5700 79001010013423 1 18 7545 101412054 1955 10 20 Total Food Assets 7545 8170 383412034 21 22 Total 17400 2200 2002 23 LILOVE 23 Current Liabiti 26 secourt Payable 3654 2000 2167 27 And Les 1000 1334 1530 Notes Patie 56040 600 00 20 Short Term Debt 8801081 1500 32 30 Total Current bites 6134 5403 521 7182 11 32 Long Term Debt 33 Notes Payable 600 0 0 1200 600 34 Bonds 2500 1000 35 Banke 0 0 36 Total Long Term Debt 2640 2500 3700 5400 37 3 Other Libes 39 Deferred met 250 150 30 4 Towe 9004 BOSS 64 11118 2 4 EUR 4 Common Stock 1200 1200 12001200 43 Capitw Suple 2150 2150 2150 2150 45 Pared Earns 5126 720 12101 41 Total Equity 5476 1037 1301615511174 # Total Equity and Labin 17480 6902158026620 22507 51 2000 50 57 Answer 1 of 1 Done 4:10 PM M ES Sheet1 G H 1992 1993 1247 6377 5983 1532 7476 6913 1031 16952 14595 10100 13421 5095 10100 12034 15555 12034 15555 26629 32507 4677 1538 600 378 7182 6200 1844 600 HAPPY DAZE CORPORATIONS Balance Sheet (5000) 4 Year 1989 1999 1991 ASSETS 6 Current Assets 7 Cash 422 1481 1281 & Accounts Receivable 3626 3702 4783 9 Inventories 5162 4460 4872 10 Other Current Assets 725 877 910 11 Total Current Assets 9935 10520 11846 12 13 Fixed Assets 14 Plant and Equipment 5995 6100 7900 15 Accumulated deprecia 6100 7900 16 17 18 Others 7545 8170 9834 19 20 Total Faed Assets 7545 8170 9834 21 22 Total Assets 17480 1869 2160p 23 LROSE 24 25 Current Liabilities 26 Account Payable 3654 2890 3187 27 Accrued Liabilities 1020 842 1234 21 Notes Payable 560 640 0 29 Short Term Debt 880 1031 1500 30 Total Current liabilities 6114 5403 5921 31 32 Long Term Debt 33 Notes Payable 640 0 0 34 Bonds 2000 2500 2500 35 Bank Debt 0 0 0 36 Total Long Term Debt 2640 2500 2500 37 3 Other Liabilities 39 Deferred Income tax 150 40 41 Total Liabilities 9004 8053 3664 42 43 Equity 44 Common Stock 1200 1200 1200 45 Capital Surplus 2150 2150 2150 46 Retained Earnings 7287 9666 47 Total Equity 8476 10637 13016 48 49 Total Equity and Liabi 17480 18690 21680 50 51 52 5a 54 55 50 57 212 8856 1200 2500 0 3700 600 4000 800 5400 250 243 231 307 11118 14563 1200 2150 5126 12161 15511 1200 2150 14594 17944 26629 32507 Sheet1 .. 1992 1993 1247 6377 5983 988 14595 1532 7476 6913 1031 16952 10100 10100 13421 13421 12034 15555 12034 15555 26629 32507 1 2 HAPPY DAZE CORPORATIONS a Balance Sheet (5000) 4 Year 1989 1999 1991 5 ASSETS 6 Current Assets 7 Cash 422 1481 1281 8 Accounts Receivable 3626 3702 4783 9 Inventories $162 4460 4872 10 Other Current Assets 725 877 910 11 Total Current Assets 9935 10520 11846 12 13 Fixed Assets 14 Plant and Equipment 5995 6100 7900 15 Accumulated deprecia 5995 6100 7900 16 17 18 Others 7545 8170 9834 19 20 Total Fixed Assets 7545 8170 9834 25 22 Total Assets 17480 1860 2168 23 LEO/E 24 25 Current Liabilities 26 Account Payable 3654 2890 3187 27 Accrued Liabilities 1020 842 1234 28 Notes Payable 560 640 0 29 Short Term Debt 880 1031 1500 30 Total Current liabilities 6114 5921 31 32 Long Term Debt 33 Notes Payable 640 0 0 34 Bonds 2000 2500 2500 35 Bank Debt 0 0 0 36 Total Long Term Debt 2640 2500 2500 27 38 Other Liabilities 39 Deferred Income tax 250 150 243 40 41 Total Liabilities 9004 8053 8664 42 43 Equity 44 Common Stock 1200 1200 1200 45 Capital Surplus 2150 2150 2150 46 Retained Earnings 5126 7287 9666 47 Total Equity 8476 10637 13016 48 49 Total Equity and Liabilir 17480 18690 21680 50 51 52 53 54 55 56 57 58 4671 1538 600 378 7187 6200 1844 600 212 8856 5403 1200 2500 0 3700 600 4000 800 5400 231 307 11118 14563 1200 2150 12161 15511 1200 2150 14594 179:44 26629 32507