Question

In: Finance

Merton Analytics is considering changes in its working capital policies to improve its cash flow cycle....

Merton Analytics is considering changes in its working capital policies to improve its cash flow cycle. Merton’s sales last year were $4,250,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 7.5 times during the year, and its DSO was 41 days. Its annual cost of goods sold was $2,200,000. The firm had fixed assets totaling $585,000. Merton’s payables deferral period is 42 days.

a.         Calculate Merton’s cash conversion cycle.

b.         Assuming Merton holds negligible amounts of cash and marketable securities,

calculate its total assets turnover and ROA.

c.         Suppose Merton’s managers believe the annual inventory turnover can be raised to 9.5 times without affecting sales. What would Merton’s cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 9.5 for the year?

Solutions

Expert Solution

a). ICP = 365 / Inventory Turnover Ratio = 365 / 7.5 = 48.67 days

CCC = DSO + ICP - PDP = 41 + 48.67 - 42 = 47.67 days

b). Inventory = Sales / Inventory Turnover Ratio = $4,250,000 / 7.5 = $566,666.67

DSO = 365 / [Sales / Accounts Receivable]

41 = 365 / [$4,250,000 / Accounts Receivable]

$4,250,000 / Accounts Receivable = 365 / 41

Accounts Receivable = $4,250,000 / 8.90 = $477,397.26

Total Assets = Fixed Assets + Accounts Receivable + Inventory + Cash

= $585,000 + $477,397.26 + $566,666.67 = $1,629,063.93

Total Assets Turnover = Sales / Total Assets = $4,250,000 / $1,629,063.93 = 2.61 times

ROA = Net Profit Margin * Total Assets Turnover = 7% * 2.61 = 18.26%

c). ICP = 365 / Inventory Turnover Ratio = 365 / 9.5 = 38.42 days

CCC = DSO + ICP - PDP = 41 + 38.42 - 42 = 37.42 days

b). Inventory = Sales / Inventory Turnover Ratio = $4,250,000 / 9.5 = $447,368.42

Total Assets = Fixed Assets + Accounts Receivable + Inventory + Cash

= $585,000 + $477,397.26 + $447,368.42 = $1,509,765.68

Total Assets Turnover = Sales / Total Assets = $4,250,000 / $1,509,765.68 = 2.82 times

ROA = Net Profit Margin * Total Assets Turnover = 7% * 2.82 = 19.71%


Related Solutions

Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,860,000 (all on credit), and its net profit margin was 8%. Its inventory turnover was 5.0 times during the year, and its DSO was 32 days. Its annual cost of goods sold was $1,500,000. The firm had fixed assets totaling $455,000. Strickler's payables deferral period is 35 days. Assume a 365-day year. Do not round intermediate calculations. Calculate Strickler's...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $3,440,000 (all on credit), and its net profit margin was 4%. Its inventory turnover was 6.0 times during the year, and its DSO was 42 days. Its annual cost of goods sold was $1,800,000. The firm had fixed assets totaling $540,000. Strickler's payables deferral period is 46 days. Assume a 365-day year. Do not round intermediate calculations. Calculate Strickler's...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,555,000 (all on credit), and its net profit margin was 8%. Its inventory turnover was 4.5 times during the year, and its DSO was 44 days. Its annual cost of goods sold was $1,350,000. The firm had fixed assets totaling $420,000. Strickler's payables deferral period is 50 days. Assume 365 days in year for your calculations. Do not round...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $3,410,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 6 times during the year, and its DSO was 31 days. Its annual cost of goods sold was $1,800,000. The firm had fixed assets totaling $530,000. Strickler's payables deferral period is 34 days. Assume 365 days in year for your calculations. Do not round...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $4,165,000 (all on credit), and its net profit margin was 8%. Its inventory turnover was 7 times during the year, and its DSO was 33 days. Its annual cost of goods sold was $2,450,000. The firm had fixed assets totaling $715,000. Strickler's payables deferral period is 39 days. Assume 365 days in year for your calculations. Do not round...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,105,000 (all on credit), and its net profit margin was 4%. Its inventory turnover was 5 times during the year, and its DSO was 37 days. Its annual cost of goods sold was $1,250,000. The firm had fixed assets totaling $365,000. Strickler's payables deferral period is 39 days. Assume a 365-day year. Do not round intermediate calculations. A. Calculate...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $3,130,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 5.0 times during the year, and its DSO was 39 days. Its annual cost of goods sold was $1,750,000. The firm had fixed assets totaling $505,000. Strickler's payables deferral period is 41 days. Assume a 365-day year. Do not round intermediate calculations. Calculate Strickler's...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,180,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 6.0 times during the year, and its DSO was 37 days. Its annual cost of goods sold was $1,200,000. The firm had fixed assets totaling $355,000. Strickler's payables deferral period is 43 days. Assume a 365-day year. Do not round intermediate calculations. Calculate Strickler's...
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle....
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $2,955,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 5 times during the year, and its DSO was 36 days. Its annual cost of goods sold was $1,750,000. The firm had fixed assets totaling $540,000. Strickler's payables deferral period is 41 days. Assume a 365-day year. Do not round intermediate calculations. Calculate Strickler's...
Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to...
Working Capital Cash Flow Cycle Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $1,700,000 (all on credit), and its net profit margin was 5%. Its inventory turnover was 4.5 times during the year, and its DSO was 45 days. Its annual cost of goods sold was $900,000. The firm had fixed assets totaling $265,000. Strickler's payables deferral period is 51 days. Assume a 365-day year. Do not...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT