Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Seal-best is a company that handles a full line of dairy products in central and southern Ohio. It produces both fresh dairy products and such

Seal-best is a company that handles a full line of dairy products in central and southern Ohio. It produces both fresh dairy products and such storable products as powdered milk and cheese. Seasonal working capital needs have been financed primarily by loans from the Cincinnati Bank, and the current line of credit permits the dairy to borrow up to $240,000. In accordance with standard banking practices, however, the loan agreement requires that the bank loan be repaid in full at some time during the year, in this case by February 2019. A limitation on dairy products prices, coupled with higher costs, caused a decline in Seal-best's profit margin and net income during the last half of 2017 as well as during most of 2018. Sales increased during both of these years, however, due to the dairy's aggressive marketing program. When Swenson received a copy of Elliot's latest computer analysis and the blunt statement that the bank would insist on immediate repayment of the entire loan unless the firm presented a program showing how the poor current financial picture could be improved, he began trying to determine what could be done. He rapidly concluded that the present level of sales could not be continued without an increase in the bank loan from $240,000 to $340,000, since payments of $100,000 for construction of a plant addition would have to be made in February 2019. Even though the dairy has been a good customer of the Cincinnati Bank for over 50 years, Swenson began to question whether the bank would continue to supply the present line of credit, let alone increase the loan outstanding. Swenson was especially troubled by the fact that the Federal Reserve recently tightened bank credit, forcing the Cincinnati Bank to ration credit even to its best customers.

Dairy Products Industry Ratios (2018) (a)

Quick Ratio

1.0

Current Ratio

2.7

Inventory Turnover

7 times

Average Collection Period

32 days

Fixed Asset Turnover (b)

13.0 times

Total Asset Turnover (b)

2.6 times

Return on Total Assets

9%

Return on Equity

18%

Debt (Total) Ratio

50%

Profit Margin on Sales

3.5%

(a) Industry average ratios have been constant for the past three years.

(b) Based on year-end balance sheet figures.

1. What amount of internally-generated funds would be available for the retirement of the loan? If the bank were to grant the additional credit and extend the increased loan from a due date of February 1 to June 30, would the company be able to retire the loan on June 30? (Hint: To answer this question, consider profits and depreciation as well as the amount of inventories and receivables that would be carried if Seal-best's inventory turnover and average collection period (Days Sales Outstanding) were at industry average levels, that is, generating funds by reducing inventories and receivables to industry averages.

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

Students also viewed these Accounting questions