Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,430,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 and Creek's recent financial statements, evaluate and recommend appropriate action on the loan request. Creek Enterprises Income Statement: Industry averages Debt ratio Times interest earned ratio Fixed-payment coverage ratio 0.45 7.44 2.10 Creek Enterprises Balance Sheet: Data Table Data Table - X (Click the icon here e in order to copy the contents of the data table below into a spreadsheet.) Creek Enterprises Balance Sheet December 31, 2022 Assets Liabilities and Stockholders' Equity Current assets Current liabilities Cash $989,000 Accounts payable $7,984,000 Marketable securities 3,002,000 Notes payable 7,958,000 Accounts receivable 12,006,000 Accruals 535,000 Inventories 7,530,000 Total current liabilities $16,477,000 Total current assets $23,527,000 Long-term debt (includes financial leases)** $19,103,500 Gross fixed assets (at cost)* Stockholders' equity Land and buildings $11,016,000 Preferred stock (24,700 shares, $3.75 dividend) $2,459,000 Machinery and equipment 20,458,000 Common stock (1.13 million Furniture and fixtures 7,996.000 shares at $5.25 par) 5,932,500 Gross fixed assets $39,470,000 Paid-in capital in excess of par value 3,970,000 Less: Accumulated depreciation 13,030,000 Retained earnings 2,025,000 Net fixed assets $26.440,000 Total stockholders' equity $14,386,500 Total liabilities and Total assets $49.967,000 stockholders' equity $49,967,000 *The firm has a 4-year lease requiring annual beginning-of-year payments of $219,000. Three years of the lease have yet to run. **Required annual principal payments are $814,000. (Click the icon here e in order to copy the contents of the data table below into a spreadsheet.) Creek Enterprises Income Statement for the Year Ended December 31, 2022 Sales revenue $30,044,000 Less: Cost of goods sold 20,993,000 Gross profits $9,051,000 Less: Operating expenses Selling expense $2,964,000 General and administrative expenses 1,795,000 Lease expense 219,000 Depreciation expense 950,000 Total operating expense 5,928,000 Operating profits $3,123,000 Less: Interest expense 977,000 Net profits before taxes $2,146,000 Less: Taxes (rate = 21%) 450,660 Net profits after taxes $1,695,340 Less: Preferred stock dividends 92,625 Earnings available for common stockholders $1,602.715 Print Done Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,430,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 and Creek's recent financial statements, evaluate and recommend appropriate action on the loan request. Creek Enterprises Income Statement: Industry averages Debt ratio Times interest earned ratio Fixed-payment coverage ratio 0.45 7.44 2.10 Creek Enterprises Balance Sheet: Data Table Data Table - X (Click the icon here e in order to copy the contents of the data table below into a spreadsheet.) Creek Enterprises Balance Sheet December 31, 2022 Assets Liabilities and Stockholders' Equity Current assets Current liabilities Cash $989,000 Accounts payable $7,984,000 Marketable securities 3,002,000 Notes payable 7,958,000 Accounts receivable 12,006,000 Accruals 535,000 Inventories 7,530,000 Total current liabilities $16,477,000 Total current assets $23,527,000 Long-term debt (includes financial leases)** $19,103,500 Gross fixed assets (at cost)* Stockholders' equity Land and buildings $11,016,000 Preferred stock (24,700 shares, $3.75 dividend) $2,459,000 Machinery and equipment 20,458,000 Common stock (1.13 million Furniture and fixtures 7,996.000 shares at $5.25 par) 5,932,500 Gross fixed assets $39,470,000 Paid-in capital in excess of par value 3,970,000 Less: Accumulated depreciation 13,030,000 Retained earnings 2,025,000 Net fixed assets $26.440,000 Total stockholders' equity $14,386,500 Total liabilities and Total assets $49.967,000 stockholders' equity $49,967,000 *The firm has a 4-year lease requiring annual beginning-of-year payments of $219,000. Three years of the lease have yet to run. **Required annual principal payments are $814,000. (Click the icon here e in order to copy the contents of the data table below into a spreadsheet.) Creek Enterprises Income Statement for the Year Ended December 31, 2022 Sales revenue $30,044,000 Less: Cost of goods sold 20,993,000 Gross profits $9,051,000 Less: Operating expenses Selling expense $2,964,000 General and administrative expenses 1,795,000 Lease expense 219,000 Depreciation expense 950,000 Total operating expense 5,928,000 Operating profits $3,123,000 Less: Interest expense 977,000 Net profits before taxes $2,146,000 Less: Taxes (rate = 21%) 450,660 Net profits after taxes $1,695,340 Less: Preferred stock dividends 92,625 Earnings available for common stockholders $1,602.715 Print Done