rincipal payments are $800,000. PO-19 Common-size statement analysis A common-size income statement for Creek Enterprises' 2011 operations follows. Using the firm's 2012 income statement pre- sented in Problem 3-18, develop the 2012 common-size income statement and com- pare it to the 2011 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2011 100.0% 65.9 34.1% 12.7% 6.3 0.6 Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate -40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders 23.2 10.9% 1.5 9.4% 3.8 5.6% 0.1 5.5% 2.0 6.0 Current al Quick ratio Inventory turnover Average collection period Average payment period 73 days 31 days 10.4 52 days 40 days a. What recommendations relative to the amount and the handling of inventor could you make to the new owners? b. What recommendations relative to the amount and the handling of accounts receivable could you make to the new owners? c. What recommendations relative to the amount and the handling of accounts payable could you make to the new owners? d. What results, overall, would you hope your recommendations would achieve? Why might your recommendations not be effective? P3-18 Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to assess the firm's financial leverage and financial risk. On the basis of the debt ratios for Creek, along with the industry averages (see top of page 97) and Creek's recent financial statements (following), evaluate and rec. ommend appropriate action on the loan request. Creek Enterprises Income Statement for the Year Ended December 31, 2012 $30,000,000 21,000,000 $ 9,000,000 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders $ 3,000,000 1,800,000 200,000 1,000,000 $ 6,000,000 $ 3,000,000 1,000,000 $ 2,000,000 800,000 $ 1,200,000 100,000 $ 1,100,000 CHAPTER 3 Financial Statements and Ratio Analysis Creek Enterprises Balance Sheet December 31, 2012 Industry averages Debt ratio 0.51 Times interest earned ratio 7.30 Fixed-payment coverage ratio 1.85 Assets Liabilities and Stockholders' Equity Cash $ 1,000,000 Accounts payable $ 8,000,000 Marketable securities 3,000,000 Notes payable 8,000,000 Accounts receivable 12,000,000 Accruals 500,000 Inventories 7,500,000 Total current liabilities $16,500,000 Total current assets $23,500,000 Long-term debt (includes Land and buildings $11,000,000 financial leases) $20,000,000 Machinery and equipment 20,500,000 Preferred stock (25,000 Furniture and fixtures 8,000,000 shares, 54 dividend) $ 2,500,000 Gross fixed assets (at cost $39,500,000 Common stock (1 million Less: Accumulated depreciation 13,000,000 shares at $5 par) 5,000,000 Net fixed assets $26,500,000 Paid-in capital in excess of Total assets $50,000,000 par value 4,000,000 Retained earnings 2,000,000 Total stockholders' equity $13,500,000 Total liabilities and stockholders' equity $50,000,000 "The firm has a 4-year financial lease requiring annual beginning-of-year payments of $200,000. Three years of the lease have yet to run. "Required annual principal payments are $800,000. rincipal payments are $800,000. PO-19 Common-size statement analysis A common-size income statement for Creek Enterprises' 2011 operations follows. Using the firm's 2012 income statement pre- sented in Problem 3-18, develop the 2012 common-size income statement and com- pare it to the 2011 statement. Which areas require further analysis and investigation? Creek Enterprises Common-Size Income Statement for the Year Ended December 31, 2011 100.0% 65.9 34.1% 12.7% 6.3 0.6 Sales revenue ($35,000,000) Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate -40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders 23.2 10.9% 1.5 9.4% 3.8 5.6% 0.1 5.5% 2.0 6.0 Current al Quick ratio Inventory turnover Average collection period Average payment period 73 days 31 days 10.4 52 days 40 days a. What recommendations relative to the amount and the handling of inventor could you make to the new owners? b. What recommendations relative to the amount and the handling of accounts receivable could you make to the new owners? c. What recommendations relative to the amount and the handling of accounts payable could you make to the new owners? d. What results, overall, would you hope your recommendations would achieve? Why might your recommendations not be effective? P3-18 Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,000,000 loan, to assess the firm's financial leverage and financial risk. On the basis of the debt ratios for Creek, along with the industry averages (see top of page 97) and Creek's recent financial statements (following), evaluate and rec. ommend appropriate action on the loan request. Creek Enterprises Income Statement for the Year Ended December 31, 2012 $30,000,000 21,000,000 $ 9,000,000 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Lease expense Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Preferred stock dividends Earnings available for common stockholders $ 3,000,000 1,800,000 200,000 1,000,000 $ 6,000,000 $ 3,000,000 1,000,000 $ 2,000,000 800,000 $ 1,200,000 100,000 $ 1,100,000 CHAPTER 3 Financial Statements and Ratio Analysis Creek Enterprises Balance Sheet December 31, 2012 Industry averages Debt ratio 0.51 Times interest earned ratio 7.30 Fixed-payment coverage ratio 1.85 Assets Liabilities and Stockholders' Equity Cash $ 1,000,000 Accounts payable $ 8,000,000 Marketable securities 3,000,000 Notes payable 8,000,000 Accounts receivable 12,000,000 Accruals 500,000 Inventories 7,500,000 Total current liabilities $16,500,000 Total current assets $23,500,000 Long-term debt (includes Land and buildings $11,000,000 financial leases) $20,000,000 Machinery and equipment 20,500,000 Preferred stock (25,000 Furniture and fixtures 8,000,000 shares, 54 dividend) $ 2,500,000 Gross fixed assets (at cost $39,500,000 Common stock (1 million Less: Accumulated depreciation 13,000,000 shares at $5 par) 5,000,000 Net fixed assets $26,500,000 Paid-in capital in excess of Total assets $50,000,000 par value 4,000,000 Retained earnings 2,000,000 Total stockholders' equity $13,500,000 Total liabilities and stockholders' equity $50,000,000 "The firm has a 4-year financial lease requiring annual beginning-of-year payments of $200,000. Three years of the lease have yet to run. "Required annual principal payments are $800,000