Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want to know the fixed payment coverege ratio and how culclate it Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a

image text in transcribed

image text in transcribed

image text in transcribed

I want to know the fixed payment coverege ratio and how culclate it

Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $3,580,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.45 Creek Enterprises Balance Sheet: 5 Fixed-payment coverage ratio 2.03 Creek Enterprises's debt ratio is 0.72. (Round to two decimal places.) Creek Enterprises's times interest earned ratio is 3.1. (Round to two decimal places.) Creek Enterprises's fixed-payment coverage ratio is I. (Round to two decimal places.) Creek Enterprises Income Statement for the Year Ended December 31, 2022 Sales revenue $30,003,000 Less: Cost of goods sold 20,995,000 Gross profits $9,008,000 Less: Operating expenses Selling expense $2,975,000 General and administrative expenses 1,781,000 Lease expense 227,000 Depreciation expense 1,005,000 Total operating expense 5,988,000 Operating profits $3,020,000 Less: Interest expense 973,000 Net profits before taxes $2,047,000 Less: Taxes (rate = 21%) 429,870 Net profits after taxes $1,617,130 Less: Preferred stock dividends 89,600 Earnings available for common stockholders $1,527,530 (Click the icon here 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 $1,015,000 Accounts payable $7,996,000 Marketable securities 2,956,000 Notes payable 7.967,000 Accounts receivable 12,037,000 Accruals 525,000 Inventories 7,492,000 Total current liabilities $16,488,000 Total current assets $23,500,000 Long-term debt (includes financial leases)** $19,578,000 Gross fixed assets at cost)* Stockholders' equity Land and buildings $11,006,000 Preferred stock (25,600 shares, $3.50 dividend) $2,453,000 Machinery and equipment 20,478,000 Common stock (1.07 million Furniture and fixtures 7,951,000 shares at $5.00 par) 5,350,000 Gross fixed assets $39,435,000 Paid-in capital in excess of par value 4,045,000 Less: Accumulated depreciation 13,017,000 Retained earnings 2,004,000 Net fixed assets $26,418,000 Total stockholders' equity $13,852,000 Total liabilities and Total assets $49,918,000 stockholders' equity $49,918,000 *The firm has a 4-year lease requiring annual beginning-of-year payments of $227,000. Three years of the lease have yet to run. **Required annual principal payments are $812,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance

Authors: Harvey S Rosen, Ted Gayer

9th International Edition

0071267883, 9780071267885

More Books

Students also viewed these Finance questions

Question

Outline the contributions of Socrates to psychology.

Answered: 1 week ago