Cash Flow Timeline and Cash Conversion Cycle

1. Why This Topic Matters

The cash flow timeline and the cash conversion cycle (CCC) sit at the very heart of corporate liquidity management, which is why the AFP CTP exam tests them heavily. Treasury professionals exist to make sure the company has the right amount of cash, in the right place, at the right time. The cash flow timeline is the map of where cash is tied up as it moves through the business, and the CCC is the single number that summarizes how long that trip takes.

Why should you care? Every day that cash sits in inventory or in uncollected receivables is a day the company must finance that cash with borrowed funds, idle equity, or forgone investment income. A company with a 90-day CCC and $10 million of daily cost of sales has roughly $900 million of working capital permanently tied up. Shaving just five days off that cycle frees $50 million. That is real money, and treasury is the department expected to find it. On the exam, this topic connects to float, collections, disbursements, working capital metrics, short-term borrowing, and trade credit terms, so understanding it well pays off across multiple domains.

2. What the Cash Flow Timeline Is

The cash flow timeline is a conceptual chart that tracks the sequence of events from the moment a firm commits to buying inputs until it finally collects cash from customers. The key events, in order, are:

1. Purchase of raw materials or merchandise (inventory arrives, accounts payable is created).
2. Payment to the supplier (cash flows out; this ends the payables period).
3. Sale of finished goods (inventory leaves, accounts receivable is created).
4. Collection from the customer (cash flows in; this ends the receivables period).

Between these events sit three measurable intervals:

- Days Inventory Outstanding (DIO): from purchase of inventory to sale of the product. Also called inventory conversion period or days inventory held.
- Days Sales Outstanding (DSO): from sale (invoice) to collection of cash. Also called receivables conversion period or average collection period.
- Days Payables Outstanding (DPO): from purchase of inventory to payment of the supplier. Also called payables deferral period.

The operating cycle is the total time from acquiring inventory to collecting cash from customers: Operating Cycle = DIO + DSO. It describes how long the firm's resources are tied up in operations.

The cash conversion cycle recognizes that the supplier is financing part of that period. The firm does not actually pay cash out at the moment inventory arrives; it pays later. So the firm's own cash is only tied up for the operating cycle minus the time the supplier is carrying the firm:

CCC = DIO + DSO - DPO
or equivalently
CCC = Operating Cycle - DPO

The CCC therefore measures the number of days between when the firm pays cash for inputs and when it receives cash from customers. It is the length of time the firm must finance its operations from its own or borrowed funds.

3. How the Components Are Calculated

Memorize these formulas exactly, including which income-statement figure goes in the denominator:

DIO = Inventory / (Cost of Goods Sold / 365)
Inventory is carried at cost, so it is compared to COGS, not sales.

DSO = Accounts Receivable / (Credit Sales / 365)
Receivables are recorded at selling price, so they are compared to sales (ideally credit sales). If the exam gives only total sales, use that.

DPO = Accounts Payable / (COGS / 365) or Accounts Payable / (Purchases / 365)
Payables arise from purchases of inventory. Purchases is technically more precise; COGS is commonly used when purchases are not given. Purchases = COGS + Ending Inventory - Beginning Inventory.

Some exam questions use 360 days instead of 365, or use average balances (beginning plus ending divided by two) instead of ending balances. Always read the question for the convention required, and default to 365 and the balances provided if nothing is stated.

Worked Example

A company reports: Inventory $2,000,000; Accounts Receivable $3,000,000; Accounts Payable $1,500,000; Annual Sales $20,000,000; Annual COGS $12,000,000.

Daily COGS = $12,000,000 / 365 = $32,877
Daily Sales = $20,000,000 / 365 = $54,795

DIO = $2,000,000 / $32,877 = 60.8 days
DSO = $3,000,000 / $54,795 = 54.8 days
DPO = $1,500,000 / $32,877 = 45.6 days

Operating Cycle = 60.8 + 54.8 = 115.6 days
CCC = 115.6 - 45.6 = 70.0 days

Interpretation: on average, the company pays its suppliers about 70 days before it collects from its customers. It must fund roughly 70 days of operating costs from cash reserves or borrowings.

4. Interpreting the CCC

Shorter is generally better. A shorter CCC means less capital tied up, lower financing costs, higher return on assets, and greater liquidity flexibility.

A negative CCC is possible and desirable. If DPO exceeds DIO plus DSO, the firm collects from customers before it pays suppliers. Large retailers and subscription or online businesses often achieve this: they sell quickly for cash or card payment while negotiating long supplier terms. A negative CCC means suppliers are effectively financing the firm's growth.

Context matters. A heavy manufacturer or aerospace firm will naturally have a long CCC because of long production times. Compare a firm to its own history and to industry peers, not to an absolute standard.

Too short can be a warning. An aggressively low DIO may signal stockouts and lost sales. A very low DSO may indicate credit terms so tight that customers go elsewhere. A very high DPO may mean the firm is stretching payables, damaging supplier relationships, losing early-payment discounts, or signaling distress.

5. Levers Treasury Can Pull to Shorten the CCC

Reduce DIO: just-in-time inventory, better demand forecasting, supply chain coordination, reducing obsolete stock, vendor-managed inventory.

Reduce DSO: tighter credit policies, invoicing faster and accurately, offering early-payment discounts, electronic invoicing and payment (ACH, card, wire), lockbox services to cut mail and processing float, proactive collections, factoring or receivables financing (which converts receivables to cash but at a cost).

Increase DPO: negotiate longer payment terms, pay on the due date rather than early, use purchasing cards (which extend the effective payment date), use controlled disbursement accounts, participate in supply chain finance programs where a bank pays the supplier early while the buyer pays the bank later. The caution is that stretching payables beyond agreed terms is unethical, damages relationships, and may forfeit discounts whose implied annual cost can exceed 30 to 40 percent.

Cost of a Forgone Discount (frequently tested alongside DPO decisions):
Annualized Cost = [D / (1 - D)] x [365 / (Net Period - Discount Period)]
For terms 2/10 net 30: (0.02 / 0.98) x (365 / 20) = 0.0204 x 18.25 = 37.2 percent. Paying on day 30 instead of day 10 extends DPO by 20 days but costs the equivalent of borrowing at 37 percent, so a firm that can borrow more cheaply should take the discount.

6. The Cash Flow Timeline and Float

The CTP exam frequently links the cash flow timeline to the concept of float, because float determines where on the timeline cash actually becomes usable.

Collection float (the delay between a customer sending payment and the firm having usable funds) has three parts: mail float (time in the postal system), processing float (time for the firm to process and deposit), and availability or clearing float (time for the bank to grant available funds). Reducing collection float shortens DSO in practical terms.

Disbursement float is the mirror image: the time between the firm issuing a payment and funds actually leaving its account. Historically firms exploited disbursement float to extend effective DPO. With electronic payments and Check 21 this float has shrunk dramatically, and exam answers that rely on remote disbursement to deliberately delay check clearing are usually treated as outdated or unethical.

7. Quantifying the Value of CCC Improvements

Exam questions often ask you to translate a change in days into dollars.

Cash Freed = Change in Days x Daily COGS (or Daily Sales)
Annual Savings = Cash Freed x Opportunity Cost or Borrowing Rate

Example: If a lockbox reduces DSO by 3 days, daily credit sales are $54,795, and the firm's short-term borrowing rate is 6 percent, then cash freed = 3 x $54,795 = $164,385 and annual interest saved = $164,385 x 0.06 = $9,863. If the lockbox costs $8,000 per year, it is worthwhile.

Be careful about which daily figure to use: changes in receivables use daily sales; changes in inventory or payables use daily COGS or purchases.

8. Related Metrics You Should Recognize

- Inventory Turnover = COGS / Inventory; DIO = 365 / Inventory Turnover.
- Receivables Turnover = Credit Sales / AR; DSO = 365 / Receivables Turnover.
- Payables Turnover = COGS (or Purchases) / AP; DPO = 365 / Payables Turnover.
- Working Capital = Current Assets - Current Liabilities; the CCC explains the operational drivers behind working capital levels.
- Current Ratio and Quick Ratio measure static liquidity; the CCC measures dynamic liquidity (speed of conversion).

9. Exam Tips: Answering Questions on Cash Flow Timeline and Cash Conversion Cycle

Tip 1: Lock the formula into memory with a story. Inventory sits (DIO), then customers owe you (DSO), but suppliers let you wait (DPO). Add the first two, subtract the third. If you ever subtract DSO or add DPO, you have reversed the logic; stop and rethink.

Tip 2: Match numerators to the correct denominators. Receivables go with Sales. Inventory and Payables go with COGS or Purchases. A common distractor answer uses Sales for DIO, producing a smaller, wrong number. Checking the denominator eliminates many wrong choices instantly.

Tip 3: Check the day count convention. Read whether the question says 365 or 360 days. Also check whether it gives average balances or ending balances. Using the wrong one typically produces one of the distractor answers, which is exactly why the exam writers include them.

Tip 4: Know the difference between operating cycle and cash conversion cycle. Operating cycle = DIO + DSO. CCC = Operating cycle - DPO. Questions sometimes ask for one and offer the other as a distractor.

Tip 5: Think in terms of direction when the question is conceptual. Ask: does this action make inventory move faster, receivables collect faster, or payables pay slower? Faster inventory and faster collections reduce CCC; slower payments reduce CCC. Anything that does the opposite lengthens it. For example, loosening credit terms to boost sales raises DSO and lengthens CCC; switching customers from check to ACH shortens DSO; a lockbox shortens DSO; purchasing cards lengthen DPO.

Tip 6: Recognize that negative CCC is a valid, often ideal, result. Do not assume a calculation error if your answer is negative. The question may be illustrating a firm whose suppliers finance its operations.

Tip 7: Watch for best-practice versus unethical answers. If an answer choice suggests paying suppliers late, intentionally slowing checks, or deliberately exploiting disbursement float, it is rarely the correct answer on a modern CTP exam. The preferred answers involve negotiating terms, using supply chain finance, electronic payments, and paying on the due date rather than early.

Tip 8: For dollar-impact questions, follow a two-step path. Step one: convert days to dollars using the appropriate daily figure. Step two: multiply the dollars freed by the interest or opportunity rate to get annual savings, then compare to the cost of the initiative. Lockbox, factoring, and discount questions all follow this pattern.

Tip 9: Use the discount cost formula to judge DPO decisions. If the annualized cost of forgoing a discount exceeds the firm's borrowing cost, take the discount even though it shortens DPO. The exam rewards recognizing that a shorter CCC is not worth paying 37 percent implied interest.

Tip 10: Interpret, do not just compute. After calculating, ask what the number means. A CCC increasing year over year signals deteriorating liquidity management; falling DIO with rising stockout complaints signals inventory is too lean; rising DPO with supplier complaints signals stretched payables. Questions framed as scenarios test whether you can diagnose the cause from the components.

Tip 11: Manage your time. CCC calculations are straightforward but have several steps. Write down the three daily figures first, compute each component, then combine. Rounding differences of a day or less are normal; pick the closest answer.

10. Quick Reference Summary

DIO = Inventory / (COGS / 365)
DSO = AR / (Credit Sales / 365)
DPO = AP / (COGS or Purchases / 365)
Operating Cycle = DIO + DSO
CCC = DIO + DSO - DPO
Cash Freed = Days Saved x Daily COGS or Daily Sales
Cost of Forgone Discount = [D / (1 - D)] x [365 / (Net Days - Discount Days)]

Shorter CCC means less financing needed, more liquidity, and higher returns, provided it is achieved through efficiency and negotiation rather than stockouts, lost customers, or strained supplier relationships. Master the timeline, memorize the formulas, and always connect the arithmetic back to what treasury is trying to accomplish: having cash available when it is needed at the lowest possible cost.