Problem Set - Fill in each of the missing cells for all the firms listed below. ROS ROA ROE Leverage Current Ratio Quick Ratio SG&A % Contrib. Margin % Break-even 0.00% 0.00% 0.00% 0.00 0.00 0.00 0.00% 0.00% SO 0.00% 0.00% 0.00% 0.00 0.00 0.00 0.00% 0.00% SO 0.00% 0.00% 0.00% 0.00 0.00 0.00 0.00% 0.0096 $0 0.00% 0.00% 0.00% 0.00 0.00 0.00 0.00% 0.00% SO 0.00% 0.00% 0.00% 0.00 0.00 0.00 0.00% 0.0096 SO B A D E Balance Sheet Survey (000) Cash Accounts Receivable Inventory Total Current Assets $13,283 $34,178 $25,532 $72,992 $21,087 $6,510 $12,330 $39,927 $14,914 $19,029 $122,374 $156,318 $0 $15,420 $16,340 $31,760 $82,227 $31,037 $33,270 $146,533 Plant and equipment Accumulated Depreciation Total Fixed Assets $368,900 ($ 182.593) $186,307 $108,600 (S68.053) $40,547 $265.620 $ 156,531) $109,089 $67,800 (552.520) $15.280 $422,600 $165 900) 5256,700 Balance Sheet Survey (000) A D B E F D G E Cash Accounts Receivable Inventory Total Current Assets $13,283 $34,178 $25,532 $72,992 $21,087 $6,510 $12,330 $39,927 $14,914 $19,029 $122,374 $156,318 SO $15,420 $16,340 $31,760 $82,227 $31,037 $33,270 $146,533 Plant and equipment Accumulated Depreciation Total Fixed Assets $368,900 ($182,593) $186,307 $108,600 ($68,053) $40,547 $265,620 ($156,531) $109,089 $67,800 ($52,520) $15,280 $422,600 ($ 165,900) $256,700 Total Assets $259,299 $80,474 $265,407 $47,040 $403,233 Accounts Payable Current Debt Long Term Debt Total Liabilities $6,950 SO $70,539 $77,489 $3,845 SO SO $14,363 $0 $59,486 $5,191 $14,033 $9,600 $18,625 $49,337 $121,165 $189,127 $3,845 $73,849 $28,824 Common Stock Retained Earnings Total Equity $90,120 $91,690 $181,810 $44,951 $169,155 $23,360 $53,269 $76,629 $48,360 $143,199 $191,558 $32,048 ($13.833) $18,215 $214,106 $ 259,299 $80,474 $265,407 $47.040 $403,233 Total Liabilities & Owners' Equity E H Common Stock Retained Earnings Total Equity $90,120 $91,690 $181,810 D $23,360 $53,269 $76,629 $48,360 $143,199 $191,558 F $32,048 ($13,833) $18,215 G $44,951 $169,155 $ 214,106 Total Liabilities & Owners' Equity $259,299 $80,474 $265,407 $47,040 $403,233 Income Statement Survey (000) A B C D E Sales Variable costs (Labor, Material, Carry Depreciation SGA (R&D, Promo, Sales, Admin) Other (Fees, Writeoffs, TOM, Bonuses EBIT Interest (Short term, Long term) Taxes Profit Sharing Net Profit $204,507 $98,929 $24,593 $23,152 ($2,412) $60,245 $9,292 $17,833 $662 $32,457 $79,202 $39,511 $7,240 $12,555 $12,000 $7,897 $o $2,764 $103 $5,030 $231,525 $161,995 $17,708 $23,381 $0 $28,441 $7,217 $7,429 $276 $13,520 $93,804 $69,970 $4,520 $19,533 $1,504 ($1,724) $3,480 ($1.822) $0 ($3,383) $377,615 $197,325 $28,173 $17,262 $2,547 $132,308 $23,143 $38,208 $1,419 $69,538 Part B. 25 points Write a one page paper explaining which firm is the best firm from a financial analysis perspective
