Worked example
A wholesale bakery sells to grocery stores on credit. For the year: sales 6,000,000; cost of goods sold 3,900,000; operating expenses 1,500,000; interest 80,000; income tax 130,000; net income 390,000. Average total assets were 3,900,000 and average equity (all common) 2,600,000. At year end: cash 150,000, receivables 240,000 (260,000 a year earlier), inventory 210,000 (180,000), prepaid items 30,000 and current liabilities 500,000. Accounts payable went from 300,000 to 340,000.
- Return on assets 390,000 / 3,900,000 = 10%; return on equity 390,000 / 2,600,000 = 15%.
- Net margin 390,000 / 6,000,000 = 6.5%; operating margin 600,000 / 6,000,000 = 10%; gross margin 2,100,000 / 6,000,000 = 35%.
- Inventory turnover 3,900,000 / 195,000 = 20, or 18.25 days.
- Receivables turnover 6,000,000 / 250,000 = 24, about 15.21 days.
- Days payable 320,000 / 3,900,000 x 365 = about 29.95 days.
- Current ratio 630,000 / 500,000 = 1.26; quick ratio 390,000 / 500,000 = 0.78.
The cash conversion cycle is about 18.25 + 15.21 - 29.95 = 3.51 days, or about 3.5: suppliers finance almost the whole cycle.