Ratio Analysis to solve Reed’s Clothiers Cash Flow Problem

Calculate a few ratios and compare Reed’s results with industry averages. (Some industry averages are shown in Exhibit 16.4.) What do these ratios indicate?

Exhibit 16.4.
Reed’s Clothiers Selected Ratios*
Liquidity Ratios Industry
Current ratio 2.7
Quick ratio 1.6
Receivables turnover 7.7
Average collection period 47.4

Efficiency Ratios
Total asset turnover 1.9
Inventory turnover 7.0
Payable turnover 15.1
Profitability Ratios
Gross profit margin 33.0
Net profit margin 7.8
Return on common equity 25.9
*Since many ratios may have different meanings the following definitions were used in the above calculations: Receivable turnover = sales/accounts receivable Average collection period = 365/receivable turnover Total asset tumover = cost of sales/total assets Inventory turnover = cost of sales/inventories Payable turnover = cost of sales/accounts payable.

B.) Why does Holmes want Reed’s to have an inventory reduction sale, and what does he think will be accomplished by it?

C.) Jim Reed had adopted a very loose working capital policy with higher current assets than industry averages. If he merely tightens his working capital policy to the averages, should this affect his sales?

D.) Assuming that Reed’s can improve its operations to be in line with the industry averages, construct a 1995 pro forma income statement. Assume that net sales will be reduced 5 percent to $1,938,000 but that depreciation and amortization will not change but remain at $32,000.

E.) What type of inventory control system would you suggest to Jim Reed?

F.) What type of accounts receivable control would you suggest to Jim Reed?

G.) Is the increase in sales related to the increase in inventory? (See Exhibit 16.5.)

Exhibit 16.5.
Reed’s Clothiers
Year Inventories Net Sales
1991 $378 1,812
1992 411 1,886
1993 452 1,954
1994 491 2,035

H.) What is Reed’s cost of not taking the suppliers’ discounts?