Question

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 round intermediate calculations. PART 1 Calculate Strickler's cash conversion cycle. Do not round intermediate calculations. Round your answer to two decimal places. ______ days PART 2 Assuming Strickler holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Do not round intermediate calculations. Round your answers to two decimal places. Total assets turnover: ____ × ROA: ____% PART 3 Suppose Strickler's managers believe the annual inventory turnover can be raised to 9 times without affecting sale or profit margins. What would Strickler's cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 9 for the year? Do not round intermediate calculations. Round your answers to two decimal places. Cash conversion cycle: _____ days Total assets turnover: ______ × ROA: _____ %

Answer 1

Answer a.

Days Inventory Outstanding = 365/ Inventory Turnover
Days Inventory Outstanding = 365 / 4.50
Days Inventory Outstanding = 81.11 days

Days Sales Outstanding = 45.00 days
Days Payable Outstanding = 51.00 days

Cash Conversion Cycle = Days Inventory Outstanding + Days Sales Outstanding – Days Payable Outstanding
Cash Conversion Cycle = 81.11 + 45.00 - 51.00
Cash Conversion Cycle = 75.11 days

Answer b.

Days Sales Outstanding = 365 * Accounts Receivable / Annual Sales
45.00 = 365 * Accounts Receivable / $1,700,000
Accounts Receivable = $209,589.04

Inventory Turnover = Cost of Goods Sold / Inventories
4.50 = $900,000 / Inventories
Inventories = $200,000.00

Total Assets = Accounts Receivable + Inventories + Fixed Assets
Total Assets = $209,589.04 + $200,000.00 + $265,000.00
Total Assets = $674,589.04

Net Income = Annual Sales * Profit Margin
Net Income = $1,700,000 * 5.00%
Net Income = $85,000

Total Assets Turnover = Annual Sales / Total Assets
Total Assets Turnover = $1,700,000 / $674,589.04
Total Assets Turnover = 2.52

Return on Assets = Net Income / Total Assets
Return on Assets = $85,000 / $674,589.04
Return on Assets = 0.1260 or 12.60%

Answer c.

Days Inventory Outstanding = 365/ Inventory Turnover
Days Inventory Outstanding = 365 / 9
Days Inventory Outstanding = 40.56 days

Cash Conversion Cycle = Days Inventory Outstanding + Days Sales Outstanding – Days Payable Outstanding
Cash Conversion Cycle = 40.56 + 45.00 - 51.00
Cash Conversion Cycle = 34.56 days

Inventory Turnover = Cost of Goods Sold / Inventories
9 = $900,000 / Inventories
Inventories = $100,000.00

Total Assets = Accounts Receivable + Inventories + Fixed Assets
Total Assets = $209,589.04 + $100,000.00 + $265,000.00
Total Assets = $574,589.04

Total Assets Turnover = Annual Sales / Total Assets
Total Assets Turnover = $1,700,000 / $574,589.04
Total Assets Turnover = 2.96

Return on Assets = Net Income / Total Assets
Return on Assets = $85,000 / $574,589.04
Return on Assets = 0.1479 or 14.79%