60.1K

Verified Solution

Link Copied!

I'm looking for fixed-payment coverage ratio. Please solve using Excel

Creek Enterprises Income Statement for the Year Ended December 31, 2019 Sales revenue $30,013,000 Less: Cost of goods sold 20,979,000 Gross profits $9,034,000 Less: Operating expenses Selling expense $3,047,000 General and administrative expenses 1,840,000 Lease expense 199,000 Depreciation expense 974,000 Total operating expense 6,060,000 Operating profits $2,974,000 Less: Interest expense 1,033,000 Net profits before taxes $1,941,000 Less: Taxes (rate=21%) 407,610 Net profits after taxes $1,533,390 Less: Preferred stock dividends 93,750 Earnings available for common stockholders $1,439,640

Creek Enterprises Balance Sheet December 31, 2019 Assets Liabilities and Stockholders' Equity Current assets Current liabilities Cash $983,000 Accounts payable $7,992,000 Marketable securities 3,023,000 Notes payable 7,954,000 Accounts receivable 12,018,000 Accruals 472,000 Inventories 7,542,000 Total current liabilities $16,418,000 Total current assets $23,566,000 Long-term debt (includes financial leases)** $19,249,000 Gross fixed assets (at cost)* Stockholders' equity Land and buildings $10,987,000 Preferred stock (25,000 shares, $3.75 dividend) $2,463,000 Machinery and equipment 20,483,000 Common stock (1.18 million Furniture and fixtures 8,049,000 shares at $5.00 par) 5,900,000 Gross fixed assets $39,519,000 Paid-in capital in excess of par value 3,974,000 Less: Accumulated depreciation 13,038,000 Retained earnings 2,043,000 Net fixed assets $26,481,000 Total stockholders' equity $14,380,000 Total liabilities and Total assets 50,047,000 stockholders' equity $50,047,000 *The firm has a 4-year financial lease requiring annual beginning-of-year payments of $199,000. Three years of the lease have yet to run. **Required annual principal payments are $842,000.

Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $3,910,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 Industry averages Creek Enterprises Income Statement: Debt ratio 0.49 Times interest earned ratio 7.24 Creek Enterprises Balance Sheet: Fixed-payment coverage ratio 1.92 Creek Enterprises's debt ratio is 70. (Round to two decimal places.) Creek Enterprises's times interest earned ratio is 2.88. (Round to two decimal places.) Creek Enterprises's fixed-payment coverage ratio is (Round to two decimal places.)

Answer & Explanation Solved by verified expert

See Answer