please help with dupont analysis and ratio analysis thanks

SO 1996 $1,500 $1.000 $500 1997 $1,550 S1.030 $520 1998 $1,700 $1.040 $660 SO SO =IF($B$84,F13-F14," ") 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 $155 $275 $2 $12 INCOME STATEMENT Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense General / Admin. Exp. Lease Expense Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Net Profits Before Taxes Less: Taxes Net Profit After Taxes Less: Pref. Stock Divds. Earnings Available for Common Stockholders SO SO SO SO $140 $260 $5 slo $415 $85 $23 $62 $10 $52 si $150 $270 SO sul $431 $89 $29 $60 $12 $48 SO SO $0 $0 SO STE(SB$84,SUM(F17:F20),"") =IF($B$84,F15-F21," ") $216 $30 $186 $15 $171 SO =IF($B$8>4,F22-F23,"") =IF($B$84,F24-F25,"") SO $51 $48 $171 IF($B$8>4,F26-F27," "') 28 29 A B C D E TI G H 1 $31 $82 $104 $145 $362 $12 $66 $152 $191 $18 $68 $160 $200 $446 SO SO SO SO =IF(SB$84,SUM(F33:F36)," BALANCE SHEET Current Assets: Cash Marketable Securities Accounts Receivable Inventories Total Current Assets Gross Fixed Assets (at cost): Land & Buildings Machinery and Equipment Furniture & Fixtures Vehicles Other (Inc. Fin. Leases) Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Other Assets Total Assets $200 SO SO $180 SO SO SO SO $180 $52 $128 SO $ 190 $195 $0 SO SO SO $195 SO SO SO SO se $200 so $132 SO $553 $135 SO $581 =IF($B$84,SUM(F39:F43)," =IF($B$8-4,544-F45,"") =IF($B$8-4,F37+F46,"") 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 = IF($B$84,F37+F46,"") 1998 $150 $140 $28 $0 $0 SO SO SO SO SO SO SO SO $318 $13 =IF($B$84,SUM(FS SO Current Liabilities: Accounts Payable Notes Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities L/ Debt (Inc. Financial Leases) Total Liabilities Preferred Stock Common Stock Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity Reconciliation TA & TL/SE Number of Common Shares End-of-Year Stock Price 1996 $126 $190 $25 SO SO $341 $40 $381 SO $20 $30 $59 $109 $490 SO 500 $3.00 1997 $136 $200 $27 SO SO $363 $38 $4.01 SO $20 $30 $102 $152 $553 SO 500 $5.00 ETE($B$8_4,F56+F57 18%%% SO SO SO SO $20 $30 $200 $250 $581 SO 500 $5.50 TE(SBS84,SUM(F59:F62)," =IF($B$84,F58+F63,"") =IF(SB$8 0 $0.00 0 $0.00 A 00 D E F G H RATIO ANALYSIS Current Ratio Quick Ratio =IF($B$8-4,F37/F56," ") =IF($B$8-4,(F37-F36)/F56," ") Inventory Turnover Average Collection Period Fixed Asset Turnover Total Asset Turnover =IF($B$8-4,F14/F36," ") =IF($B$8-4,F35/(F13/360)," ") =IF($B$84,F13/F46,"") =IF (SB$84,F13/F 48,"") Debt Ratio Debt-to-Equity Times Interest Earned =IF($B$84,F58/F48,"") =IF($B$8-4,F57/F63,"") =IF($B$84,F22/F23,"") Gross Profit Margin Operating Profit Margin Profit Marein =IF($B$84,F15/F13,"") =IF($B$84,F22/F13,"") =IF($B$84,F26/F13,"") 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 Return on Total Assets (ROA) Return on Equity (ROE) EO =IF($B$84,F26/F48,"") =IF($B$84,F26/F63,"") Earnings Per Share =IF($B$84,F28/F66,"") Price/Earnings Ratio =IF(AND(F67>0,F89-0),F67/F89 DUPONT ANALYSIS Net Profit AT/Sales Sales/Total Assets ROA Net Profit AT/Total Assets Total Assets/Stockhldrs. Equity ROE -IF($B$8-4,F26/F13,"") -IF($B$84,F13/F48,"") -IF($B$84,F94F95,"") -IF($B$84,F26/F48,"") -IF(SB$84,F48/F63,"") IF($B$8-4,F976F98," ) 104 1996 1997 1998 105 106 107 108 109 110 111 112 113 114 115 116 s11 (548) (546) SO $10 $2 SO $171 $12 (58) (59) SO $14 $1 SO se $181 STATEMENT OF CASH FLOWS CASH FLOW FROM OPERATING ACTIVITIES Net Profit After Taxes Depreciation Decrease in Accts. Receiv. Decrease in Inventories Decrease in Other Assets Increase in Accounts Pay. Increase in Accruals Increase in Taxes Payable Increase in Other Cur. Lia. Cash Flow from Oper. Act. CASH FLOW FROM INVESTMENT ACTIVITIES Increase in Gross Fixed Assets Cash Flow from Investments CASH FLOW FROM FINANCING ACTIVITIES Increase in Notes Payable Increase in Long-Term Debt Changes in Stockholders' Equity Preferred Dividends Paid Common Dividends Paid Activities 117 118 119 120 (815 ($15) (55) $10 (560) (82) SO SO ($25) SO SO 121 122 123 124 125 126 127 128 129 130 131 1885 Net Iner. in Cash /Mark. Securities (535) $91 SO 1996 $1,500 $1.000 $500 1997 $1,550 S1.030 $520 1998 $1,700 $1.040 $660 SO SO =IF($B$84,F13-F14," ") 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 $155 $275 $2 $12 INCOME STATEMENT Sales Revenue Less: Cost of Goods Sold Gross Profits Less: Operating Expenses: Selling Expense General / Admin. Exp. Lease Expense Depreciation Expense Total Operating Expenses Operating Profits Less: Interest Expense Net Profits Before Taxes Less: Taxes Net Profit After Taxes Less: Pref. Stock Divds. Earnings Available for Common Stockholders SO SO SO SO $140 $260 $5 slo $415 $85 $23 $62 $10 $52 si $150 $270 SO sul $431 $89 $29 $60 $12 $48 SO SO $0 $0 SO STE(SB$84,SUM(F17:F20),"") =IF($B$84,F15-F21," ") $216 $30 $186 $15 $171 SO =IF($B$8>4,F22-F23,"") =IF($B$84,F24-F25,"") SO $51 $48 $171 IF($B$8>4,F26-F27," "') 28 29 A B C D E TI G H 1 $31 $82 $104 $145 $362 $12 $66 $152 $191 $18 $68 $160 $200 $446 SO SO SO SO =IF(SB$84,SUM(F33:F36)," BALANCE SHEET Current Assets: Cash Marketable Securities Accounts Receivable Inventories Total Current Assets Gross Fixed Assets (at cost): Land & Buildings Machinery and Equipment Furniture & Fixtures Vehicles Other (Inc. Fin. Leases) Total Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets Other Assets Total Assets $200 SO SO $180 SO SO SO SO $180 $52 $128 SO $ 190 $195 $0 SO SO SO $195 SO SO SO SO se $200 so $132 SO $553 $135 SO $581 =IF($B$84,SUM(F39:F43)," =IF($B$8-4,544-F45,"") =IF($B$8-4,F37+F46,"") 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 = IF($B$84,F37+F46,"") 1998 $150 $140 $28 $0 $0 SO SO SO SO SO SO SO SO $318 $13 =IF($B$84,SUM(FS SO Current Liabilities: Accounts Payable Notes Payable Accruals Taxes Payable Other Current Liabilities Total Current Liabilities L/ Debt (Inc. Financial Leases) Total Liabilities Preferred Stock Common Stock Paid-In Capital In Excess of Par Retained Earnings Total Stockholders' Equity Total Liabs. & Stockhldrs' Equity Reconciliation TA & TL/SE Number of Common Shares End-of-Year Stock Price 1996 $126 $190 $25 SO SO $341 $40 $381 SO $20 $30 $59 $109 $490 SO 500 $3.00 1997 $136 $200 $27 SO SO $363 $38 $4.01 SO $20 $30 $102 $152 $553 SO 500 $5.00 ETE($B$8_4,F56+F57 18%%% SO SO SO SO $20 $30 $200 $250 $581 SO 500 $5.50 TE(SBS84,SUM(F59:F62)," =IF($B$84,F58+F63,"") =IF(SB$8 0 $0.00 0 $0.00 A 00 D E F G H RATIO ANALYSIS Current Ratio Quick Ratio =IF($B$8-4,F37/F56," ") =IF($B$8-4,(F37-F36)/F56," ") Inventory Turnover Average Collection Period Fixed Asset Turnover Total Asset Turnover =IF($B$8-4,F14/F36," ") =IF($B$8-4,F35/(F13/360)," ") =IF($B$84,F13/F46,"") =IF (SB$84,F13/F 48,"") Debt Ratio Debt-to-Equity Times Interest Earned =IF($B$84,F58/F48,"") =IF($B$8-4,F57/F63,"") =IF($B$84,F22/F23,"") Gross Profit Margin Operating Profit Margin Profit Marein =IF($B$84,F15/F13,"") =IF($B$84,F22/F13,"") =IF($B$84,F26/F13,"") 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 Return on Total Assets (ROA) Return on Equity (ROE) EO =IF($B$84,F26/F48,"") =IF($B$84,F26/F63,"") Earnings Per Share =IF($B$84,F28/F66,"") Price/Earnings Ratio =IF(AND(F67>0,F89-0),F67/F89 DUPONT ANALYSIS Net Profit AT/Sales Sales/Total Assets ROA Net Profit AT/Total Assets Total Assets/Stockhldrs. Equity ROE -IF($B$8-4,F26/F13,"") -IF($B$84,F13/F48,"") -IF($B$84,F94F95,"") -IF($B$84,F26/F48,"") -IF(SB$84,F48/F63,"") IF($B$8-4,F976F98," ) 104 1996 1997 1998 105 106 107 108 109 110 111 112 113 114 115 116 s11 (548) (546) SO $10 $2 SO $171 $12 (58) (59) SO $14 $1 SO se $181 STATEMENT OF CASH FLOWS CASH FLOW FROM OPERATING ACTIVITIES Net Profit After Taxes Depreciation Decrease in Accts. Receiv. Decrease in Inventories Decrease in Other Assets Increase in Accounts Pay. Increase in Accruals Increase in Taxes Payable Increase in Other Cur. Lia. Cash Flow from Oper. Act. CASH FLOW FROM INVESTMENT ACTIVITIES Increase in Gross Fixed Assets Cash Flow from Investments CASH FLOW FROM FINANCING ACTIVITIES Increase in Notes Payable Increase in Long-Term Debt Changes in Stockholders' Equity Preferred Dividends Paid Common Dividends Paid Activities 117 118 119 120 (815 ($15) (55) $10 (560) (82) SO SO ($25) SO SO 121 122 123 124 125 126 127 128 129 130 131 1885 Net Iner. in Cash /Mark. Securities (535) $91