Avery Products

This case is dealing with company called Avery Products which is producing its products in jewelry manufacturing industry. This company has a loan in the First National Bank of Cincinnati. Moreover, it creates special holiday merchandise for the Christmas season which is funded primarily from the bank’s loan. According to bank’s criteria, each company which is considered to be major loan customer has to provide balance sheets and income statements. This has to be done to compare ratios with the industry average. Furthermore, the last analysis has shown that the Avery Product ratios have shown downward trend in the last decade. The current ratio was below 2.0 what means that the bank could force Avery Products into bankruptcy. To deal with this problem it has decided that the Avery Products should create a program which will improve its financial situation otherwise it will insist on immediate repayment of the loan. Therefore, Avery Products has decided to increase the loan from $300 000,-- into $400 000,--. The question is if the bang will allow this type of the loan what will be calculated in this case.

1. Ratios for year 1975 and 1976

Quick ratio = (current assets – inventory) / current liabilities

1975

(816 000 – 510 000) / 314 000 = 0.97

1976

(1 234 600 – 826 200) / 669 500 = 0.61

Current ratio = current assets / current liabilities

1975

816 000 / 314 000 = 2.60

1976

1 234 600 / 669 500 = 1.84

Inventory turnover = sales / inventories

1975

2 754 000 / 510 000 = 5.4

1976

2 856 000 / 826 200 = 3.46 = 3.5

Average collection period (days) = accounts receivable / average daily credit sales

1975

277 400 / 7 650 = 36.3

1976

388 000 / 793.3 = 48.9

Fixed assets turnover = sales / fixed assets

1975

2 754 000 / 257 100 = 10.7

1976

2 856 000 / 230 500 = 12.4

Total assets turnover = sales / total assets

1975

2 754 000 / 1 073 100 = 2.57

1976

2 856 000 / 1 465 100 = 1.95

Return on total assets (%) = net income / total assets

1975

90 155 / 1 073 100 = 0.084

1976

53 040 / 1 465 100 = 0.036

Debt (%) = total debt / total assets

1975

314 000 + 40 800 / 1 073 100 = 0.33

1976

669 500 + 36 700 / 1 465 100 = 0.48

Profit margin on sales = net income / sales

1975

90 155 / 2 754 000 = 0.032

1976

53 040 / 2 856 000 = 0.018

Return on Equity = Return on Asset / (1 – Debt/Assets)

1975

8.4 / 1 - 314 000 / 1 073 100 = 0.12

1976

3.62 / 1 - 669 500 / 1 465 100 = 0.7

Year/Period 1975 1976 1976*

Quick ratio 0.97 0.61 1.0

Current ratio 2.60 1.84 2.7

Inventory turnover 5.4X 3.5X 7X

Average collection period 36.3 48.9 32

Fixed-asset turnover 10.7X 12.4X 13.0X

Total asset turnover 2.57X 1.95X 2.6X

Return on total assets 8.4 % 3.6 % 11.7 %

Return equity 12 % 7 % 23.4 %

Debt