Hi. You may use excel if you want. Thank you! :)
Extracted text: LG6 2-20 Financial statement analysis The financial statements of Zach Industries for the year ended December 31, 2003, follow. Zach Industries Income Statement for the Year Ended December 31, 2003 Zach Industries Balance Sheet December 31, 2003 Sales revenue $160,000 Assets Less: Cost of goods sold 106,000 Cash 500 Gross profits $ 54,000 Marketable securities 1,000 Less: Operating expenses Accounts receivable 25,000 $ 16,000 Selling expense General and administrative expenses 45,500 $ 72,000 $ 26,000 Inventories 10,000 Total current assets Lease expense 1,000 Land Depreciation expense 10,000 $ 37,000 $ 17,000 Buildings and equipment Less: Accumulated depreciation 90,000 Total operating expense Operating profits 38,000 Net fixed assets $ 78,000 Less: Interest expense 6,100 Total assets $150,000 Net profits before taxes $ 10,900 Less: Taxes 4,360 Liabilities and Stockholders' Equity Net profits after taxes $ 6,540 $ 22,000 47,000 $ 69,000 $ 22,950 $ 31,500 $ 26,550 $150,000 Accounts payable Notes payable Total current liabilities Long-term debt Common stock Retained earnings Total liabilities and stockholders' equity "The firm's 3,000 outstanding shares of common stock closed 2003 at a price of $25 per share.
Extracted text: a. Use the preceding financial statements to complete the following table. Assume that the industry averages given in the table are applicable for both 2002 and 2003. Industry Ratio average Actual 2002 Actual 2003 Current ratio 1.80 1.84 Quick ratio Inventory turnoverª Average collection period“ 0.70 0.78 2.50 2.59 37 days 36 days Debt ratio 65% 67% Times interest earned ratio 3.8 4.0 Gross profit margin Net profit margin 38% 40% 3.5% 3.6% Return on total assets 4.0% 4.0% Return on common equity 9.5% 8.0% Market/book ratio 1.1 1.2 "Based on a 360-day year and on end-of-year figures.