Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Midwest Inc. is a medium-size company that has been in business for 20 years. The industry has become very competitive in the last few years,

Midwest Inc. is a medium-size company that has been in business for 20 years. The industry has become very competitive in the last few years, and Midwest has decided that it must grow if it is going to survive. It has approached the bank for a sizable five-year loan, and the bank has requested Midwests most recent financial statements as part of the loan package.

The industry in which Midwest operates of approximately 20 companies relatively equal in size. The trade association to which all the competitors belong publishes an annual survey of the industry, including industry averages for selected ratios for the competitors. All companies voluntarily submit their statements to the association for this purpose.

Midwests controller is aware that the bank has access to this survey and is very concerned about how the company fared this past year compared with the rest of the industry. The ratios included in the publication and the averages for the past year are as follows:

Ratio

Industry Average

Current ratio

1.20

Acid-test (quick) ratio

0.50

Debt-to-equity ratio

0.50

Times Interest earned

25 times

Returns on sales

3%

Asset Turnover

3.50 times

Inventory Turnover

35 times

Return on common stockholders equity

20%

Midwest Inc.

Comparative Statements of Financial Position

(thousands omitted)

December 31, 2017

December 31, 2016

Assets

Current Assets:

Cash

$1,790

$2,600

Marketable Securities

1,200

1,700

Accounts Receivable, net of allowances

400

600

Inventories

8,700

7,400

Prepaid items

350

400

Total Current assets

$12,440

$12,700

December 31, 2017

December 31, 2016

Long-term investments

$560

$400

Property, plant, and equipment:

Land

$12,000

$12,000

Buildings and equipment, net of accumulated depreciation

87,000

82,900

Total property, plant, and equipment

$99,000

$94,900

Total assets

$112,000

$108,000

Liabilities and Stockholders Equity

Current Liabilities:

Short-term notes

$800

$600

Accounts payable

6,040

6,775

Salaries and wages payable

1,500

1,200

Income taxes payable

1,560

1,025

Total current liabilities

$9,900

$9,600

Long-term bonds payable

$36,000

$36,000

Stockholders equity:

Common stock, no par

$50,000

$50,000

Retained earnings

16,100

12,400

Total stockholders equity

$66,100

$62,400

Total liabilities and stockholders equity

$112,000

108,000

Midwest Inc.

Statement of Income and Retained Earnings

For the Year Ended December 31, 2017

(thousands omitted)

Sales revenue

$420,500

Cost of Goods sold

(300,000)

Gross profit

$120,500

Selling, general, and administrative expenses

(85,000)

Income before interest and taxes

$35,500

Interest expense

(8,600)

Income before taxes

$26,900

Income tax expense

(12,000)

Net Income

$14,900

Retained earnings, January 1, 2017

12,400

$27,300

Dividends paid on common stock

(11,200)

Retained earnings, December 31, 2017

$16,100

Required

Prepare a columnar report for the controller of Midwest Inc. comparing the industry averages for the ratios published by the trade association with the comparable ratios for Midwest. For Midwest, compute the ratios as of December 31, 2017, or for the year ending December 31, 2017, whichever is appropriate.

Briefly evaluate Midwests ratios relative to the industry averages.

Do you think that the bank will approve the loan? Explain your answer.

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_2

Step: 3

blur-text-image_3

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

Accounting A Smart Approach

Authors: Mary Carey, Jane Towers-Clark, Cathy Knowles

2nd Edition

0199674914, 978-0199674916

More Books

Students also viewed these Accounting questions

Question

Does this value make me feel good about myself?

Answered: 1 week ago

Question

Identify possible reasons for ineffective performance.

Answered: 1 week ago

Question

Describe the components of a needs assessment.

Answered: 1 week ago

Question

Describe the benefits of employee orientation.

Answered: 1 week ago