Distribution Method and Historical Patterns
5 minutes
5 Questions
In the Certified Treasury Professional (CTP) body of knowledge, the distribution method is a short-term cash forecasting technique used in corporate liquidity management. It relies on historical patterns to spread a known or expected total cash flow across the days, weeks, or periods in which it is likely to occur. Rather than predicting each individual transaction, treasury professionals start with an aggregate figure, such as total monthly disbursements or total expected collections, and then allocate that figure using percentages derived from past behavior. For example, if historical data show that 15 percent of checks issued clear on the first business day, 30 percent on the second, 25 percent on the third, and the remainder over subsequent days, the forecaster applies those same proportions to the current period's issuance to estimate daily cash outflows. The same logic can be applied to receipts, payroll disbursements, credit card settlements, lockbox collections, or vendor payments. Historical patterns are the foundation of this approach. Treasury analysts study prior periods to identify recurring regularities such as day-of-week effects, where Mondays and Fridays often show heavier activity, month-end and quarter-end spikes driven by payroll, rent, taxes, or dividends, and seasonal cycles tied to the business model, such as retail holiday peaks or agricultural harvest periods. Check clearing float patterns, customer payment habits, and the timing of intercompany transfers are also captured. The accuracy of the method depends on the stability and representativeness of this history, so analysts must adjust for anomalies, policy changes, shifts in payment mix toward electronic methods, and economic conditions that may alter behavior. For corporate liquidity, the value of the distribution method lies in improving daily cash positioning. By anticipating when funds will actually leave or enter accounts, treasury can minimize idle balances, reduce short-term borrowing costs, invest surplus cash more effectively, and avoid overdrafts. It is simple, inexpensive, and well suited to the near-term horizon where precision in timing matters most, though it should be validated regularly against actual results and supplemented with other forecasting techniques for longer horizons.
Distribution Method and Historical Patterns in Cash Forecasting (AFP CTP – Corporate Liquidity Management)
Why This Topic Matters
Cash forecasting sits at the heart of corporate liquidity management. A treasurer who cannot predict when cash will arrive or leave the company either holds excessive idle balances (lost investment income) or risks overdrafts and emergency borrowing (higher costs and reputational damage). Within the CTP Body of Knowledge, the distribution method is one of the core short-term forecasting techniques, alongside the receipts and disbursements (schedule) method and statistical methods. It is tested because it is simple, widely used in practice, and demonstrates a treasurer's ability to turn historical data into actionable daily cash positioning decisions. Expect calculation questions, concept-identification questions, and questions about its strengths and limitations.
What the Distribution Method Is
The distribution method is a short-term cash forecasting technique that takes a known or reliably estimated total amount for a period (for example, a week or a month) and spreads, or distributes, that total across the individual days of the period using historical percentage patterns. In other words, you already know how much will flow; the method tells you when it will flow.
Typical applications include:
• Forecasting the daily clearing of a batch of disbursement checks (e.g., payroll or vendor checks mailed on one day).
• Forecasting daily collections when total monthly receivables due are known from the aging schedule.
• Forecasting daily credit card or lockbox receipts against a known sales total.
• Forecasting the timing of dividend or coupon payment clearings.
It is sometimes called the distribution forecast, percentage distribution method, or historical pattern method.
What Historical Patterns Are
Historical patterns are recurring regularities in the timing of cash flows that are identified by studying past data. Common patterns include:
• Day-of-week patterns: Checks mailed Monday clear heavily Wednesday and Thursday; collections peak mid-week.
• Day-of-month patterns: Many customers pay on the 1st, 10th, 15th, or last day of the month; rents and payroll fall on fixed dates.
• Seasonal patterns: Retail collections spike in the fourth quarter; agricultural firms show harvest-related cycles.
• Holiday and calendar effects: Bank holidays, weekends, and month-end falling on a weekend shift flows forward or backward.
• Float patterns: Mail float, processing float, and clearing float behave predictably for a given payee population and payment method.
These patterns are expressed as percentages of the total that occur on each day (or sub-period), and those percentages become the distribution weights.
How the Distribution Method Works – Step by Step
Step 1: Gather historical data. Collect several comparable periods of daily actual flows for the item being forecast (e.g., the last 6–12 payroll cycles).
Step 2: Calculate daily percentages. For each period, divide each day's amount by that period's total. Then average the daily percentages across periods to smooth out noise. The percentages must sum to 100%.
Step 3: Determine the total to be distributed. Obtain the known amount for the upcoming period, such as the total value of checks to be issued or the total receivables due.
Step 4: Apply the percentages. Multiply the total by each day's historical percentage to get the forecast for that day.
Step 5: Adjust for known exceptions. Shift amounts for holidays, large one-time items, changes in payment terms, or customer behavior changes.
Step 6: Compare to actuals and refine. Track variances and update the percentage pattern as new data arrives.
Worked Example
A company mails $2,000,000 of vendor checks on Monday. Historical analysis shows the following clearing pattern:
• Tuesday: 10%
• Wednesday: 35%
• Thursday: 30%
• Friday: 20%
• Following Monday: 5%
Forecast daily clearings:
• Tuesday: $2,000,000 × 0.10 = $200,000
• Wednesday: $2,000,000 × 0.35 = $700,000
• Thursday: $2,000,000 × 0.30 = $600,000
• Friday: $2,000,000 × 0.20 = $400,000
• Following Monday: $2,000,000 × 0.05 = $100,000
Check: $200,000 + $700,000 + $600,000 + $400,000 + $100,000 = $2,000,000. The treasurer can now fund the disbursement account each day rather than funding the full $2,000,000 on Monday, earning interest or reducing borrowing on the temporarily unneeded balances.
Deriving the Pattern – Example
Suppose three past monthly collection totals were $900,000, $1,100,000, and $1,000,000, and collections on the 15th of each month were $180,000, $231,000, and $190,000 respectively. The 15th-day percentages are 20.0%, 21.0%, and 19.0%; the average is 20.0%. If next month's expected total collections are $1,200,000, the forecast for the 15th is $1,200,000 × 0.20 = $240,000.
Advantages
• Simple to build and explain; requires only historical data and spreadsheet tools.
• Highly effective when totals are known but timing is uncertain.
• Directly supports daily cash positioning, disbursement funding, and short-term investing/borrowing decisions.
• Captures day-of-week and day-of-month effects that simple averages miss.
Limitations
• Assumes the past pattern will repeat; structural changes (new payment terms, shift from checks to ACH, new customers, Check 21 and image clearing speeding up float) can make patterns obsolete.
• Requires a reliable estimate of the total; an error in the total propagates to every day.
• Sensitive to holidays and calendar shifts that must be manually adjusted.
• Less useful for medium- and long-term forecasts, where statistical or pro forma methods are preferred.
How It Fits with Other Forecasting Methods
• Receipts and disbursements (schedule) method: Builds the forecast from scheduled, known individual items (payroll dates, debt service, tax payments). Often used together with the distribution method, which handles the items whose timing is uncertain.
• Statistical methods (regression, moving averages, exponential smoothing, time series): Used for medium- and long-term horizons or when relationships between variables (e.g., sales and collections) must be modeled.
• Pro forma / adjusted net income methods: Long-term, accrual-based projections used for strategic planning rather than daily positioning.
The distribution method is firmly a short-term (daily to a few weeks) tool.
Exam Tips: Answering Questions on Distribution Method and Historical Patterns
1. Recognize the signal words. If a question mentions a known total being spread across days using historical percentages, day-of-week or day-of-month patterns, check clearing patterns, or percentage of total collected on each day, the answer is almost always the distribution method.
2. Master the arithmetic. Forecast for a day = Total × Historical percentage for that day. Always verify the percentages sum to 100% and that your daily figures add back to the total. If they do not, re-read the question for a missing day or a rounding instruction.
3. Work backward when needed. Some questions give the daily amount and the percentage and ask for the total (Total = Daily amount ÷ Percentage), or give actual daily amounts over several periods and ask you to compute the pattern (Day amount ÷ Period total, then average).
4. Distinguish methods clearly. Receipts and disbursements = scheduled known items; distribution = known total, uncertain timing; statistical/regression = modeled relationships, longer horizons. The exam frequently tests this classification.
5. Know the time horizon. The distribution method is a short-term technique. Any answer choice labeling it as a long-term or strategic method is incorrect.
6. Remember the key assumption and weakness. The method assumes historical patterns persist. When a question describes a change in payment method (checks to ACH or cards), new customer base, new credit terms, or faster clearing, the correct answer usually involves the pattern becoming unreliable or needing to be re-estimated.
7. Watch for calendar adjustments. If a clearing day falls on a bank holiday or weekend, the flow moves to the next business day. Questions may embed this to test whether you adjust the pattern.
8. Connect to liquidity decisions. Questions often ask why the method is valuable: it allows the treasurer to fund disbursement accounts only as checks clear, invest temporarily surplus balances, minimize borrowing, and maintain target balances. Tie your answer to float management and cash positioning.
9. Use the cumulative view when asked. Some questions ask what percentage or amount has cleared by a given day; add the daily percentages cumulatively (e.g., by Thursday in the example, 75% or $1,500,000 has cleared).
10. Eliminate distractors. Wrong answers typically mislabel the method, use percentages that do not sum to 100%, apply the percentage to the wrong base, or describe a medium/long-term application. Check each of these before selecting your answer.
Quick Review Summary
• The distribution method spreads a known total over time using historical percentage patterns.
• Patterns reflect day-of-week, day-of-month, seasonal, and holiday effects derived from past actuals.
• Formula: Daily forecast = Total × Historical %; percentages must total 100%.
• Best for short-term daily cash positioning, especially check clearing and collections timing.
• Main weakness: reliance on stable historical behavior; re-estimate when payment practices change.
• On the exam, identify the method by its signal words, compute carefully, verify totals, and link the method to liquidity and float management benefits.
Cash forecasting sits at the heart of corporate liquidity management. A treasurer who cannot predict when cash will arrive or leave the company either holds excessive idle balances (lost investment income) or risks overdrafts and emergency borrowing (higher costs and reputational damage). Within the CTP Body of Knowledge, the distribution method is one of the core short-term forecasting techniques, alongside the receipts and disbursements (schedule) method and statistical methods. It is tested because it is simple, widely used in practice, and demonstrates a treasurer's ability to turn historical data into actionable daily cash positioning decisions. Expect calculation questions, concept-identification questions, and questions about its strengths and limitations.
What the Distribution Method Is
The distribution method is a short-term cash forecasting technique that takes a known or reliably estimated total amount for a period (for example, a week or a month) and spreads, or distributes, that total across the individual days of the period using historical percentage patterns. In other words, you already know how much will flow; the method tells you when it will flow.
Typical applications include:
• Forecasting the daily clearing of a batch of disbursement checks (e.g., payroll or vendor checks mailed on one day).
• Forecasting daily collections when total monthly receivables due are known from the aging schedule.
• Forecasting daily credit card or lockbox receipts against a known sales total.
• Forecasting the timing of dividend or coupon payment clearings.
It is sometimes called the distribution forecast, percentage distribution method, or historical pattern method.
What Historical Patterns Are
Historical patterns are recurring regularities in the timing of cash flows that are identified by studying past data. Common patterns include:
• Day-of-week patterns: Checks mailed Monday clear heavily Wednesday and Thursday; collections peak mid-week.
• Day-of-month patterns: Many customers pay on the 1st, 10th, 15th, or last day of the month; rents and payroll fall on fixed dates.
• Seasonal patterns: Retail collections spike in the fourth quarter; agricultural firms show harvest-related cycles.
• Holiday and calendar effects: Bank holidays, weekends, and month-end falling on a weekend shift flows forward or backward.
• Float patterns: Mail float, processing float, and clearing float behave predictably for a given payee population and payment method.
These patterns are expressed as percentages of the total that occur on each day (or sub-period), and those percentages become the distribution weights.
How the Distribution Method Works – Step by Step
Step 1: Gather historical data. Collect several comparable periods of daily actual flows for the item being forecast (e.g., the last 6–12 payroll cycles).
Step 2: Calculate daily percentages. For each period, divide each day's amount by that period's total. Then average the daily percentages across periods to smooth out noise. The percentages must sum to 100%.
Step 3: Determine the total to be distributed. Obtain the known amount for the upcoming period, such as the total value of checks to be issued or the total receivables due.
Step 4: Apply the percentages. Multiply the total by each day's historical percentage to get the forecast for that day.
Step 5: Adjust for known exceptions. Shift amounts for holidays, large one-time items, changes in payment terms, or customer behavior changes.
Step 6: Compare to actuals and refine. Track variances and update the percentage pattern as new data arrives.
Worked Example
A company mails $2,000,000 of vendor checks on Monday. Historical analysis shows the following clearing pattern:
• Tuesday: 10%
• Wednesday: 35%
• Thursday: 30%
• Friday: 20%
• Following Monday: 5%
Forecast daily clearings:
• Tuesday: $2,000,000 × 0.10 = $200,000
• Wednesday: $2,000,000 × 0.35 = $700,000
• Thursday: $2,000,000 × 0.30 = $600,000
• Friday: $2,000,000 × 0.20 = $400,000
• Following Monday: $2,000,000 × 0.05 = $100,000
Check: $200,000 + $700,000 + $600,000 + $400,000 + $100,000 = $2,000,000. The treasurer can now fund the disbursement account each day rather than funding the full $2,000,000 on Monday, earning interest or reducing borrowing on the temporarily unneeded balances.
Deriving the Pattern – Example
Suppose three past monthly collection totals were $900,000, $1,100,000, and $1,000,000, and collections on the 15th of each month were $180,000, $231,000, and $190,000 respectively. The 15th-day percentages are 20.0%, 21.0%, and 19.0%; the average is 20.0%. If next month's expected total collections are $1,200,000, the forecast for the 15th is $1,200,000 × 0.20 = $240,000.
Advantages
• Simple to build and explain; requires only historical data and spreadsheet tools.
• Highly effective when totals are known but timing is uncertain.
• Directly supports daily cash positioning, disbursement funding, and short-term investing/borrowing decisions.
• Captures day-of-week and day-of-month effects that simple averages miss.
Limitations
• Assumes the past pattern will repeat; structural changes (new payment terms, shift from checks to ACH, new customers, Check 21 and image clearing speeding up float) can make patterns obsolete.
• Requires a reliable estimate of the total; an error in the total propagates to every day.
• Sensitive to holidays and calendar shifts that must be manually adjusted.
• Less useful for medium- and long-term forecasts, where statistical or pro forma methods are preferred.
How It Fits with Other Forecasting Methods
• Receipts and disbursements (schedule) method: Builds the forecast from scheduled, known individual items (payroll dates, debt service, tax payments). Often used together with the distribution method, which handles the items whose timing is uncertain.
• Statistical methods (regression, moving averages, exponential smoothing, time series): Used for medium- and long-term horizons or when relationships between variables (e.g., sales and collections) must be modeled.
• Pro forma / adjusted net income methods: Long-term, accrual-based projections used for strategic planning rather than daily positioning.
The distribution method is firmly a short-term (daily to a few weeks) tool.
Exam Tips: Answering Questions on Distribution Method and Historical Patterns
1. Recognize the signal words. If a question mentions a known total being spread across days using historical percentages, day-of-week or day-of-month patterns, check clearing patterns, or percentage of total collected on each day, the answer is almost always the distribution method.
2. Master the arithmetic. Forecast for a day = Total × Historical percentage for that day. Always verify the percentages sum to 100% and that your daily figures add back to the total. If they do not, re-read the question for a missing day or a rounding instruction.
3. Work backward when needed. Some questions give the daily amount and the percentage and ask for the total (Total = Daily amount ÷ Percentage), or give actual daily amounts over several periods and ask you to compute the pattern (Day amount ÷ Period total, then average).
4. Distinguish methods clearly. Receipts and disbursements = scheduled known items; distribution = known total, uncertain timing; statistical/regression = modeled relationships, longer horizons. The exam frequently tests this classification.
5. Know the time horizon. The distribution method is a short-term technique. Any answer choice labeling it as a long-term or strategic method is incorrect.
6. Remember the key assumption and weakness. The method assumes historical patterns persist. When a question describes a change in payment method (checks to ACH or cards), new customer base, new credit terms, or faster clearing, the correct answer usually involves the pattern becoming unreliable or needing to be re-estimated.
7. Watch for calendar adjustments. If a clearing day falls on a bank holiday or weekend, the flow moves to the next business day. Questions may embed this to test whether you adjust the pattern.
8. Connect to liquidity decisions. Questions often ask why the method is valuable: it allows the treasurer to fund disbursement accounts only as checks clear, invest temporarily surplus balances, minimize borrowing, and maintain target balances. Tie your answer to float management and cash positioning.
9. Use the cumulative view when asked. Some questions ask what percentage or amount has cleared by a given day; add the daily percentages cumulatively (e.g., by Thursday in the example, 75% or $1,500,000 has cleared).
10. Eliminate distractors. Wrong answers typically mislabel the method, use percentages that do not sum to 100%, apply the percentage to the wrong base, or describe a medium/long-term application. Check each of these before selecting your answer.
Quick Review Summary
• The distribution method spreads a known total over time using historical percentage patterns.
• Patterns reflect day-of-week, day-of-month, seasonal, and holiday effects derived from past actuals.
• Formula: Daily forecast = Total × Historical %; percentages must total 100%.
• Best for short-term daily cash positioning, especially check clearing and collections timing.
• Main weakness: reliance on stable historical behavior; re-estimate when payment practices change.
• On the exam, identify the method by its signal words, compute carefully, verify totals, and link the method to liquidity and float management benefits.
Test mode:
CTP - Distribution Method and Historical Patterns Example Questions
Test your knowledge of Distribution Method and Historical Patterns
Question 1
A company issues $1,600,000 in checks on Monday. Historical clearing patterns show 15% presented on day 1, 40% on day 2, 30% on day 3 and 15% on day 4. Using the distribution method, what amount should still be outstanding at the end of day 2?
Question 2
In short-term cash forecasting, which of the following best describes how the distribution method uses historical patterns?
Question 3
In short-term cash forecasting, when the distribution method is used to project check clearings, which historical measure is applied to a known total disbursement amount?
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 Distribution Method and Historical Patterns 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 CostsEffective 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 CapitalizationWorking Capital Ratios: DSO, DIO and DPOYield Curve Positioning and Maturity MatchingZero-Balance Accounts and Concentration Structures