Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

1 of 5 (4 complete) %) P3-18 (similar to) Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,360,000 loan, to assess

image text in transcribed
image text in transcribed
image text in transcribed
1 of 5 (4 complete) %) P3-18 (similar to) Debt analysis Springfield Bank is evaluating Creek Enterprises, which has requested a $4,360,000 loan, to assess the firm's financial leverage and finance Creek's recent financial statements, evaluate and recommend appropriate action on the loan request. Industry averages Debt ratio 0.44 Creek Enterprises Income Statement ! Times interest earned ratio 7.49 Fixed-payment coverage ratio 1.87 Creek Enterprises Balance Sheet: Creek Enterprises's debt ratio is 0.70 . (Round to two decimal places.) Creek Enterprises's times interest earned ratio is 3.14. (Round to two decimal places.) Creek Enterprises's fixed-payment coverage ratio is 1.24. (Round to two decimal places.) Complete the following summary of ratios and compare Creek Enterprises's ratios vs. the industry average: (Round to two decimal places.) Creek Industry Debt ratio 0.44 Times interest earned ratio 7.49 1.87 Fixed-payment coverage ratio Enter your answer in the edit fields and then click Check Answer. Data Table 7.49 1.87 und to two decimal pla (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) do is 3.14. (Round to ratio is 1.24. (Roun compare Creek Ent Creek In Creek Enterprises Income Statement for the Year Ended December 31, 2015 Sales revenue $30,048,000 Less: Cost of goods sold 21.010,000 Gross profits $9,038,000 Less: Operating expenses Selling expense $3,046,000 General and administrative expenses 1,807,000 Lease expense 152,000 Depreciation expense 972,000 Total operating expense 5,977,000 Operating profits $3,061,000 Less: Interest expense 974,000 $2,087,000 Net profits before taxes 834,800 Less: Taxes (rate = 40%) $1,252,200 Net profits after taxes 86,800 Less: Preferred stock dividends $1,165,400 Earnings available for common stockholders Print Done click Check Answer. Clear All - Hos for Cred 0.44 7.49 1.87 to two 3 3.14 o is 1. ompare Creek (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Creek Enterprises Balance Sheet December 31, 2015 Assets Liabilities and Stockholders' Equity Current assets Current liabilities Cash $992,000 Accounts payable Marketable securities $7.997.000 2,982,000 Notes payable Accounts receivable 7.967,000 11,983,000 Accruals 457.000 Inventories 7,464,000 Total current liabilities $16,421,000 Total current assets $23,421,000 Long-term debt (includes financial leases)" $18,777,000 Gross fixed assets (at cost)" Stockholders' equity Land and buildings $11,000,000 Preferred stock (24,800 shares, $3.50 dividend) $2,476,000 Machinery and equipment 20,529,000 Common stock (1.13 million Furniture and fixtures 7,960,000 shares at $5.50 par) 6,215,000 Gross fixed assets $39,489,000 Paid-in capital in excess of 4,027.000 Retained earnings 2,018,000 Less: Accumulated depreciation 12,976,000 $26,513,000 Total stockholders' equity Net fixed assets $14.736,000 Total liabilities and $49,934,000 $49,934,000 stockholders' equity Total assets *The firm has a 4-year financial lease requiring annual beginning-of-year payments of $152,000. Three years of the lease have yet to run. **Required annual principal payments are $797,000. par value ck CI Print Done Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial and Managerial Accounting Using Excel for Success

Authors: James Reeve, Carl S. Warren, Jonathan Duchac

1st edition

978-1111993979

Students also viewed these Finance questions