Working Capital Ratios: DSO, DIO and DPO
5 minutes
5 Questions
Working capital ratios are core metrics in the Certified Treasury Professional (CTP) body of knowledge because they measure how efficiently a company converts its operating activities into cash, directly affecting corporate liquidity. The three primary ratios are Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO), and Days Payables Outstanding (DPO). Together they form the Cash Conversion Cycle (CCC = DIO + DSO − DPO), which tells treasury how many days cash is tied up in operations before it returns to the company. Days Sales Outstanding (DSO) measures the average number of days it takes to collect cash after a credit sale. It is calculated as Accounts Receivable divided by Credit Sales, multiplied by the number of days in the period (typically 365). A lower DSO means faster collections and stronger liquidity; a rising DSO may signal loose credit policies, collection problems, or deteriorating customer quality. Days Inventory Outstanding (DIO) measures how long, on average, inventory sits before being sold. It is calculated as Inventory divided by Cost of Goods Sold, multiplied by days in the period. A lower DIO indicates efficient inventory management and less cash locked in stock, though excessively low levels may risk stockouts. Days Payables Outstanding (DPO) measures the average number of days a company takes to pay its suppliers. It is calculated as Accounts Payable divided by Cost of Goods Sold (or Purchases), multiplied by days in the period. A higher DPO means the company retains cash longer, effectively using supplier credit as a financing source. However, stretching payables too far can damage supplier relationships or forfeit early-payment discounts. For treasury professionals, the goal is to shorten DSO and DIO while prudently lengthening DPO, thereby reducing the CCC, lowering reliance on external borrowing, and freeing cash for investment or debt reduction. These ratios should be benchmarked against industry peers and tracked over time, since trends often reveal operational or liquidity issues before they appear in headline financial results.
Working Capital Ratios: DSO, DIO and DPO – A Complete CTP Study Guide
1. Why This Topic Matters for the CTP Exam
Working capital management sits at the heart of corporate liquidity management, which is one of the most heavily weighted domains on the AFP Certified Treasury Professional (CTP) exam. Treasury professionals are judged on how efficiently a company converts its operating activities into cash, and the three activity ratios covered here – Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO) and Days Payables Outstanding (DPO) – are the standard tools for measuring that efficiency. Together they form the Cash Conversion Cycle (CCC), a metric that appears repeatedly in the Essentials of Treasury Management text and on the exam itself.
Expect to see these ratios tested in three ways: (1) straightforward formula calculations, (2) interpretation of whether a change is favorable or unfavorable, and (3) scenario questions asking which treasury action would shorten the cash conversion cycle or free up cash. Mastering the formulas and, more importantly, the direction in which each ratio should move is essential for scoring well.
2. What the Ratios Are
Each ratio converts a balance sheet account (receivables, inventory, payables) into a number of days, which makes the results intuitive and comparable across companies and time periods.
Days Sales Outstanding (DSO)
DSO measures the average number of days it takes a company to collect cash after making a credit sale. It reflects the effectiveness of credit policy, invoicing, and collections.
DSO = Accounts Receivable ÷ (Annual Credit Sales ÷ 365)
or equivalently
DSO = (Accounts Receivable ÷ Credit Sales) × 365
Days Inventory Outstanding (DIO)
DIO (also called Days Inventory Held or Inventory Conversion Period) measures the average number of days inventory sits before being sold. It reflects purchasing, production and sales efficiency.
DIO = Inventory ÷ (Annual Cost of Goods Sold ÷ 365)
or equivalently
DIO = (Inventory ÷ COGS) × 365
Note that COGS, not sales, is used in the denominator because inventory is carried at cost.
Days Payables Outstanding (DPO)
DPO measures the average number of days a company takes to pay its suppliers. It reflects how much of the operating cycle is financed by trade credit.
DPO = Accounts Payable ÷ (Annual Cost of Goods Sold ÷ 365)
or equivalently
DPO = (Accounts Payable ÷ COGS) × 365
Some texts use annual purchases instead of COGS in the denominator. On the CTP exam, use whatever the question supplies; if both are given, purchases is technically more precise, but COGS is the standard default.
3. How the Ratios Fit Together: The Cash Conversion Cycle
The three ratios combine into two key timeline measures:
Operating Cycle = DIO + DSO
This is the time from acquiring inventory until cash is collected from customers.
Cash Conversion Cycle (CCC) = DIO + DSO − DPO
This is the number of days the company's own cash is tied up in operations – the gap between paying suppliers and collecting from customers. A shorter CCC is generally better because less working capital must be financed. A negative CCC (possible for retailers and firms collecting cash before paying suppliers) means suppliers are effectively financing the business.
Worked Example
A company reports: Credit sales $7,300,000; COGS $5,475,000; Accounts Receivable $800,000; Inventory $600,000; Accounts Payable $450,000.
DSO = 800,000 ÷ (7,300,000 ÷ 365) = 800,000 ÷ 20,000 = 40 days
DIO = 600,000 ÷ (5,475,000 ÷ 365) = 600,000 ÷ 15,000 = 40 days
DPO = 450,000 ÷ (5,475,000 ÷ 365) = 450,000 ÷ 15,000 = 30 days
Operating Cycle = 40 + 40 = 80 days
CCC = 40 + 40 − 30 = 50 days
Interpretation: the firm must finance 50 days of operations with its own cash or borrowings. If it could reduce DSO to 35 days, CCC would fall to 45 days and free up roughly 5 × $20,000 = $100,000 of cash.
4. How Treasury Uses These Ratios
Reducing DSO (good): tighten credit terms, offer early-payment discounts, speed up invoicing, use lockboxes and electronic collections, improve dispute resolution.
Reducing DIO (good): just-in-time inventory, better demand forecasting, eliminating obsolete stock, supply chain coordination.
Increasing DPO (good, with limits): negotiate longer terms, pay on the last day allowed, use purchasing cards or supply chain finance programs. Be careful – stretching payables beyond terms can damage supplier relationships, forfeit cash discounts and signal distress.
Cash impact of a one-day change: Each day of DSO equals one day of credit sales (Credit Sales ÷ 365). Each day of DIO or DPO equals one day of COGS (COGS ÷ 365). This shortcut is heavily tested.
5. Important Nuances and Limitations
• Average vs. ending balances: Questions may give beginning and ending balances; use the average unless told otherwise. If only one balance is given, use it.
• 365 vs. 360 days: The CTP exam normally uses 365 days. Read the question – if it specifies 360, use 360.
• Credit sales vs. total sales: DSO should use credit sales. If only total sales is given, use it, but recognize that including cash sales understates true DSO.
• Seasonality: DSO can be distorted by seasonal sales patterns; aging schedules and the Collection Effectiveness Index are complementary tools.
• Turnover equivalents: Receivables turnover = 365 ÷ DSO; inventory turnover = 365 ÷ DIO; payables turnover = 365 ÷ DPO. Be ready to convert in either direction.
• Industry context: A 60-day DSO is poor for a retailer but normal for a capital equipment manufacturer. Interpret ratios relative to terms offered and peers.
6. Exam Tips: Answering Questions on Working Capital Ratios: DSO, DIO and DPO
Tip 1 – Memorize the formulas as 'balance divided by daily flow.' Every ratio is a balance sheet account divided by an average daily income statement figure. Receivables pair with sales; inventory and payables pair with COGS. This pattern prevents denominator mix-ups.
Tip 2 – Know the direction of 'good.' Lower DSO = good. Lower DIO = good. Higher DPO = good (to a point). Lower CCC = good. Many exam questions simply ask which change improves liquidity – answer by direction without even calculating.
Tip 3 – Write out the CCC equation every time. CCC = DIO + DSO − DPO. The most common error is adding DPO instead of subtracting it. A quick sanity check: paying suppliers later should shorten the cycle, so DPO must be subtracted.
Tip 4 – Watch for 'solve for the missing variable' questions. The exam may give DSO and sales and ask for receivables (AR = DSO × Sales ÷ 365), or give CCC and two components and ask for the third. Rearrange the formula before plugging in numbers.
Tip 5 – Use the one-day-equals-one-day-of-flow shortcut. If asked how much cash is released by reducing DSO by 3 days, multiply 3 by daily credit sales. For DIO or DPO changes, multiply by daily COGS. Then multiply by the opportunity cost rate if the question asks for annual savings.
Tip 6 – Read units carefully. Confirm whether figures are annual, quarterly or monthly, and whether the question says 365 or 360 days. Quarterly sales require dividing by roughly 91 days, not 365.
Tip 7 – Do not confuse DSO with the AR aging schedule or the Collection Effectiveness Index. DSO is a single average; aging schedules show distribution by age bucket; CEI measures collections relative to what was collectible. Scenario questions may ask which tool best detects a specific problem.
Tip 8 – For interpretive questions, think about causes and trade-offs. A rising DSO might indicate loose credit, poor collections or a one-time large sale late in the period. A rising DPO might indicate negotiated terms (good) or an inability to pay (bad). Choose the answer that reflects balanced treasury judgment.
Tip 9 – Eliminate answer choices that move the wrong way. If a question asks how to shorten the CCC, immediately discard any option that lengthens DSO or DIO or shortens DPO.
Tip 10 – Manage your time. These calculations are quick once memorized. Do the arithmetic once, carefully, and move on – do not second-guess a clean result.
7. Quick Practice Questions
Q1. A firm has DIO of 55 days, DSO of 42 days and DPO of 38 days. What is its cash conversion cycle?
Answer: 55 + 42 − 38 = 59 days.
Q2. Credit sales are $18,250,000 and DSO is 48 days. What is the accounts receivable balance?
Answer: Daily sales = 18,250,000 ÷ 365 = $50,000; AR = 48 × 50,000 = $2,400,000.
Q3. Which action would most likely shorten the cash conversion cycle? (a) Extending customer credit terms from 30 to 45 days; (b) Increasing safety stock; (c) Negotiating supplier terms from net 30 to net 45; (d) Paying suppliers early to capture discounts.
Answer: (c) – increases DPO, which reduces CCC. Options (a) and (b) lengthen DSO and DIO; option (d) reduces DPO.
Q4. COGS is $10,950,000. The company reduces DIO from 50 to 44 days. How much cash is freed up?
Answer: Daily COGS = 10,950,000 ÷ 365 = $30,000; 6 days × $30,000 = $180,000.
Q5. Inventory turnover is 7.3 times per year. What is DIO?
Answer: 365 ÷ 7.3 = 50 days.
8. Key Takeaways
• DSO, DIO and DPO translate balance sheet accounts into days using daily sales or daily COGS.
• CCC = DIO + DSO − DPO; Operating Cycle = DIO + DSO.
• Shorter DSO and DIO and longer DPO reduce the cash tied up in working capital.
• One day of DSO equals one day of credit sales; one day of DIO or DPO equals one day of COGS.
• On the exam, always confirm the day-count basis, the denominator (sales vs. COGS), and the sign on DPO before finalizing an answer.
With the formulas memorized and the directional logic internalized, working capital ratio questions become some of the most reliable points available on the CTP exam.
Working capital management sits at the heart of corporate liquidity management, which is one of the most heavily weighted domains on the AFP Certified Treasury Professional (CTP) exam. Treasury professionals are judged on how efficiently a company converts its operating activities into cash, and the three activity ratios covered here – Days Sales Outstanding (DSO), Days Inventory Outstanding (DIO) and Days Payables Outstanding (DPO) – are the standard tools for measuring that efficiency. Together they form the Cash Conversion Cycle (CCC), a metric that appears repeatedly in the Essentials of Treasury Management text and on the exam itself.
Expect to see these ratios tested in three ways: (1) straightforward formula calculations, (2) interpretation of whether a change is favorable or unfavorable, and (3) scenario questions asking which treasury action would shorten the cash conversion cycle or free up cash. Mastering the formulas and, more importantly, the direction in which each ratio should move is essential for scoring well.
2. What the Ratios Are
Each ratio converts a balance sheet account (receivables, inventory, payables) into a number of days, which makes the results intuitive and comparable across companies and time periods.
Days Sales Outstanding (DSO)
DSO measures the average number of days it takes a company to collect cash after making a credit sale. It reflects the effectiveness of credit policy, invoicing, and collections.
DSO = Accounts Receivable ÷ (Annual Credit Sales ÷ 365)
or equivalently
DSO = (Accounts Receivable ÷ Credit Sales) × 365
Days Inventory Outstanding (DIO)
DIO (also called Days Inventory Held or Inventory Conversion Period) measures the average number of days inventory sits before being sold. It reflects purchasing, production and sales efficiency.
DIO = Inventory ÷ (Annual Cost of Goods Sold ÷ 365)
or equivalently
DIO = (Inventory ÷ COGS) × 365
Note that COGS, not sales, is used in the denominator because inventory is carried at cost.
Days Payables Outstanding (DPO)
DPO measures the average number of days a company takes to pay its suppliers. It reflects how much of the operating cycle is financed by trade credit.
DPO = Accounts Payable ÷ (Annual Cost of Goods Sold ÷ 365)
or equivalently
DPO = (Accounts Payable ÷ COGS) × 365
Some texts use annual purchases instead of COGS in the denominator. On the CTP exam, use whatever the question supplies; if both are given, purchases is technically more precise, but COGS is the standard default.
3. How the Ratios Fit Together: The Cash Conversion Cycle
The three ratios combine into two key timeline measures:
Operating Cycle = DIO + DSO
This is the time from acquiring inventory until cash is collected from customers.
Cash Conversion Cycle (CCC) = DIO + DSO − DPO
This is the number of days the company's own cash is tied up in operations – the gap between paying suppliers and collecting from customers. A shorter CCC is generally better because less working capital must be financed. A negative CCC (possible for retailers and firms collecting cash before paying suppliers) means suppliers are effectively financing the business.
Worked Example
A company reports: Credit sales $7,300,000; COGS $5,475,000; Accounts Receivable $800,000; Inventory $600,000; Accounts Payable $450,000.
DSO = 800,000 ÷ (7,300,000 ÷ 365) = 800,000 ÷ 20,000 = 40 days
DIO = 600,000 ÷ (5,475,000 ÷ 365) = 600,000 ÷ 15,000 = 40 days
DPO = 450,000 ÷ (5,475,000 ÷ 365) = 450,000 ÷ 15,000 = 30 days
Operating Cycle = 40 + 40 = 80 days
CCC = 40 + 40 − 30 = 50 days
Interpretation: the firm must finance 50 days of operations with its own cash or borrowings. If it could reduce DSO to 35 days, CCC would fall to 45 days and free up roughly 5 × $20,000 = $100,000 of cash.
4. How Treasury Uses These Ratios
Reducing DSO (good): tighten credit terms, offer early-payment discounts, speed up invoicing, use lockboxes and electronic collections, improve dispute resolution.
Reducing DIO (good): just-in-time inventory, better demand forecasting, eliminating obsolete stock, supply chain coordination.
Increasing DPO (good, with limits): negotiate longer terms, pay on the last day allowed, use purchasing cards or supply chain finance programs. Be careful – stretching payables beyond terms can damage supplier relationships, forfeit cash discounts and signal distress.
Cash impact of a one-day change: Each day of DSO equals one day of credit sales (Credit Sales ÷ 365). Each day of DIO or DPO equals one day of COGS (COGS ÷ 365). This shortcut is heavily tested.
5. Important Nuances and Limitations
• Average vs. ending balances: Questions may give beginning and ending balances; use the average unless told otherwise. If only one balance is given, use it.
• 365 vs. 360 days: The CTP exam normally uses 365 days. Read the question – if it specifies 360, use 360.
• Credit sales vs. total sales: DSO should use credit sales. If only total sales is given, use it, but recognize that including cash sales understates true DSO.
• Seasonality: DSO can be distorted by seasonal sales patterns; aging schedules and the Collection Effectiveness Index are complementary tools.
• Turnover equivalents: Receivables turnover = 365 ÷ DSO; inventory turnover = 365 ÷ DIO; payables turnover = 365 ÷ DPO. Be ready to convert in either direction.
• Industry context: A 60-day DSO is poor for a retailer but normal for a capital equipment manufacturer. Interpret ratios relative to terms offered and peers.
6. Exam Tips: Answering Questions on Working Capital Ratios: DSO, DIO and DPO
Tip 1 – Memorize the formulas as 'balance divided by daily flow.' Every ratio is a balance sheet account divided by an average daily income statement figure. Receivables pair with sales; inventory and payables pair with COGS. This pattern prevents denominator mix-ups.
Tip 2 – Know the direction of 'good.' Lower DSO = good. Lower DIO = good. Higher DPO = good (to a point). Lower CCC = good. Many exam questions simply ask which change improves liquidity – answer by direction without even calculating.
Tip 3 – Write out the CCC equation every time. CCC = DIO + DSO − DPO. The most common error is adding DPO instead of subtracting it. A quick sanity check: paying suppliers later should shorten the cycle, so DPO must be subtracted.
Tip 4 – Watch for 'solve for the missing variable' questions. The exam may give DSO and sales and ask for receivables (AR = DSO × Sales ÷ 365), or give CCC and two components and ask for the third. Rearrange the formula before plugging in numbers.
Tip 5 – Use the one-day-equals-one-day-of-flow shortcut. If asked how much cash is released by reducing DSO by 3 days, multiply 3 by daily credit sales. For DIO or DPO changes, multiply by daily COGS. Then multiply by the opportunity cost rate if the question asks for annual savings.
Tip 6 – Read units carefully. Confirm whether figures are annual, quarterly or monthly, and whether the question says 365 or 360 days. Quarterly sales require dividing by roughly 91 days, not 365.
Tip 7 – Do not confuse DSO with the AR aging schedule or the Collection Effectiveness Index. DSO is a single average; aging schedules show distribution by age bucket; CEI measures collections relative to what was collectible. Scenario questions may ask which tool best detects a specific problem.
Tip 8 – For interpretive questions, think about causes and trade-offs. A rising DSO might indicate loose credit, poor collections or a one-time large sale late in the period. A rising DPO might indicate negotiated terms (good) or an inability to pay (bad). Choose the answer that reflects balanced treasury judgment.
Tip 9 – Eliminate answer choices that move the wrong way. If a question asks how to shorten the CCC, immediately discard any option that lengthens DSO or DIO or shortens DPO.
Tip 10 – Manage your time. These calculations are quick once memorized. Do the arithmetic once, carefully, and move on – do not second-guess a clean result.
7. Quick Practice Questions
Q1. A firm has DIO of 55 days, DSO of 42 days and DPO of 38 days. What is its cash conversion cycle?
Answer: 55 + 42 − 38 = 59 days.
Q2. Credit sales are $18,250,000 and DSO is 48 days. What is the accounts receivable balance?
Answer: Daily sales = 18,250,000 ÷ 365 = $50,000; AR = 48 × 50,000 = $2,400,000.
Q3. Which action would most likely shorten the cash conversion cycle? (a) Extending customer credit terms from 30 to 45 days; (b) Increasing safety stock; (c) Negotiating supplier terms from net 30 to net 45; (d) Paying suppliers early to capture discounts.
Answer: (c) – increases DPO, which reduces CCC. Options (a) and (b) lengthen DSO and DIO; option (d) reduces DPO.
Q4. COGS is $10,950,000. The company reduces DIO from 50 to 44 days. How much cash is freed up?
Answer: Daily COGS = 10,950,000 ÷ 365 = $30,000; 6 days × $30,000 = $180,000.
Q5. Inventory turnover is 7.3 times per year. What is DIO?
Answer: 365 ÷ 7.3 = 50 days.
8. Key Takeaways
• DSO, DIO and DPO translate balance sheet accounts into days using daily sales or daily COGS.
• CCC = DIO + DSO − DPO; Operating Cycle = DIO + DSO.
• Shorter DSO and DIO and longer DPO reduce the cash tied up in working capital.
• One day of DSO equals one day of credit sales; one day of DIO or DPO equals one day of COGS.
• On the exam, always confirm the day-count basis, the denominator (sales vs. COGS), and the sign on DPO before finalizing an answer.
With the formulas memorized and the directional logic internalized, working capital ratio questions become some of the most reliable points available on the CTP exam.
Test mode:
CTP - Working Capital Ratios: DSO, DIO and DPO Example Questions
Test your knowledge of Working Capital Ratios: DSO, DIO and DPO
Question 1
In the standard working capital formulas, which day measures divide the balance by average daily cost of goods sold, rather than daily sales, to express it in days?
Question 2
Which of the following best describes what days inventory outstanding (DIO) measures in working capital analysis?
Question 3
A treasury analyst is preparing a working capital review for a company. Using a 365-day year, the company reports days sales outstanding of 45 days, days inventory outstanding of 60 days and days payable outstanding of 30 days. What is the company's cash conversion cycle?
Unlock Premium Access
Certified Treasury Professional (CTP)
- Access to ALL Certifications: Study for any certification on our platform with one subscription
- 3177 Superior-grade Certified Treasury Professional (CTP) practice questions
- Unlimited practice tests across all certifications
- Detailed explanations for every question
- CTP: 5 full exams plus all other certification exams
- 30-Day Money-Back Guarantee: Full refund within 30 days if unsatisfied
- Cancel anytime: 7-day trial with all premium features!
More Working Capital Ratios: DSO, DIO and DPO questions
21 questions (total)
Other Corporate Liquidity concepts
Account Analysis Statement ReviewAccount Funding and Intraday LiquidityAccount Structure RationalizationBank Balance Reporting and ReconciliationBank Deposit Products and Earnings CreditCash Flow Timeline and Cash Conversion CycleCash Forecasting Horizons and PurposesCollection Float: Mail, Processing and AvailabilityControlled Disbursement and Disbursement FloatCross-Border Pooling ConstraintsDaily Cash Position and Target BalancesDisbursement Method Selection and CostsDistribution Method and Historical PatternsEffective Cost of Short-Term BorrowingElectronic Collection Methods: ACH, Wires, Cards, Real-TimeForecast Variance Analysis and AccuracyFX Exposure Types: Transaction, Translation, EconomicFX Options and Hedge Instrument SelectionFX Spot, Forward and Swap MechanicsIn-House Bank Structure and FunctionsIn-House versus Outsourced Investment ManagementIntercompany Loans and Transfer PricingInvestment Policy Limits: Credit Quality, Maturity, ConcentrationLedger Balances, Collected Balances and FloatLetters of Credit: Types and PartiesLeverage and Coverage RatiosLiquidity Ratios: Current, Quick and CashLockbox Systems: Wholesale, Retail and HybridMoney Market Funds: Government, Prime and Tax-ExemptMoney Market Instruments: T-Bills, Commercial Paper, CDsMultilateral Netting CentersNatural Hedging, Netting and Leading and LaggingOutsourcing Treasury FunctionsPayment Factories and Shared Service CentersPayment Timing and Trade Discount DecisionsPayroll and Tax Payment FundingPhysical Pooling versus Notional PoolingPro Forma Statement-Based ForecastingReceipts and Disbursements Forecasting MethodReconciliation Exceptions and Returned ItemsRe-Invoicing and Regional Treasury CentersRemote Deposit Capture and Check ConversionRepatriation Methods and ConstraintsRepurchase Agreements and Reverse ReposSettlement, Safekeeping and Rollover RiskShort-Term Borrowing OptionsShort-Term Investment Objectives: Safety, Liquidity, YieldShort-Term Yield Conventions and CalculationsStatistical Forecasting TechniquesSweep Accounts and Automated LiquidityTrade Finance Instruments and Supply Chain FinanceTrade Payment Terms and Documentary CollectionsTreasury Organization: Centralized versus DecentralizedTreasury Roles and Segregation of DutiesWithholding Tax and Thin CapitalizationYield Curve Positioning and Maturity MatchingZero-Balance Accounts and Concentration Structures