Cash Flow Projection: Formula, Examples, Methods & AR Forecasting
A cash flow projection is an estimate of the cash a business expects to receive and spend over a defined future period. It forecasts cash inflows, cash outflows, and the resulting ending cash balance so finance teams can identify potential cash shortages, plan payments, manage working capital, and make informed business decisions.
The basic cash flow projection formula is:
Ending Cash Balance = Beginning Cash Balance + Projected Cash Inflows − Projected Cash Outflows
For accounts receivable-driven businesses, the quality of a cash flow projection depends heavily on how accurately future customer payments are estimated. Invoice due dates, historical payment behavior, accounts receivable aging, Days Sales Outstanding (DSO), disputes, deductions, collections activity, and unapplied cash can all affect when expected cash actually arrives.
What Is a Cash Flow Projection?
A cash flow projection is a forward-looking estimate of the amount of cash a business expects to have at future points in time. It considers when cash is expected to come into the business and when cash is expected to leave it.
Unlike an income statement, which measures revenue and expenses according to accounting principles, a cash flow projection focuses on the timing of actual or expected cash movements.
A company can be profitable and still experience a cash shortage if customers pay late, suppliers require payment before collections arrive, or large expenses occur during a period of weak cash inflows.
What Is the Cash Flow Projection Formula?
The fundamental cash flow projection formula is:
| Component | Meaning |
|---|---|
| Beginning Cash Balance | Cash available at the start of the projection period |
| Projected Cash Inflows | Cash the business expects to receive during the period |
| Projected Cash Outflows | Cash the business expects to pay during the period |
| Ending Cash Balance | Expected cash remaining at the end of the period |
Formula:
Ending Cash = Beginning Cash + Cash Inflows − Cash Outflows
Net cash flow for the period can be calculated as:
Net Cash Flow = Cash Inflows − Cash Outflows
Then:
Ending Cash = Beginning Cash + Net Cash Flow
Cash Flow Projection Example
Suppose a company begins the month with $100,000 in cash. It expects to collect $250,000 from customers and receive another $25,000 from other sources. During the same month, it expects to pay $200,000 in operating expenses, suppliers, payroll, taxes, and other obligations.
| Cash Flow Item | Projected Amount |
|---|---|
| Beginning cash | $100,000 |
| Customer collections | $250,000 |
| Other inflows | $25,000 |
| Total cash inflows | $275,000 |
| Total cash outflows | $200,000 |
| Ending cash | $175,000 |
The calculation is:
$100,000 + $275,000 − $200,000 = $175,000
The example demonstrates why cash-flow projection is primarily about timing and liquidity, not simply profitability.
Cash Flow Projection vs. Cash Flow Forecast
Cash flow projection and cash flow forecasting are closely related terms, and businesses often use them interchangeably. In practice, “forecast” generally refers to an estimate of likely future cash based on available information and expected trends, while a “projection” may also incorporate planned assumptions or hypothetical scenarios.
| Cash Flow Projection | Cash Flow Forecast |
|---|---|
| Estimates future cash based on assumptions and planned events | Estimates likely future cash based on available information and trends |
| Can model specific business scenarios | Often emphasizes expected outcomes |
| Useful for planning and what-if analysis | Useful for ongoing monitoring and decision-making |
| May include planned financing, investments or strategic actions | Can incorporate historical and current operating data |
The terminology varies between organizations, so the more important distinction is the methodology, assumptions, time horizon, and purpose of the model.
Why Is Cash Flow Projection Important?
The primary purpose of a cash flow projection is to determine whether expected cash will be sufficient to cover future obligations.
Cash flow projections help finance leaders:
- Identify potential cash shortages before they occur.
- Plan supplier, payroll, tax, and debt payments.
- Determine whether additional financing may be required.
- Plan capital expenditures and investments.
- Manage working capital.
- Evaluate the timing of customer collections.
- Assess the effect of delayed payments.
- Compare expected cash with minimum liquidity requirements.
- Prepare best-case, expected-case, and downside scenarios.
- Support strategic growth and financing decisions.
A projection is most useful when it is updated as actual cash activity changes rather than treated as a static spreadsheet.
Key Components of a Cash Flow Projection
A practical cash flow projection combines a beginning cash position with expected inflows and outflows over a defined period. The quality of the projection depends on the accuracy of both the amount and the timing of those cash movements.
Beginning Cash Balance
The beginning cash balance is the amount of cash available at the start of the projection period. For a rolling projection, the prior period’s ending cash balance becomes the next period’s beginning balance.
Projected Cash Inflows
Cash inflows can include customer collections, cash sales, financing proceeds, investments, asset sales, tax refunds, grants, and other expected receipts.
For businesses that sell on credit, customer collections are often the largest operating inflow and therefore require careful forecasting.
Projected Cash Outflows
Cash outflows can include supplier payments, payroll, taxes, rent, utilities, debt repayments, capital expenditures, interest, insurance, and other operating or financing payments.
Timing Assumptions
The amount alone is not enough. A projection needs to estimate when each inflow or outflow will occur.
For example, a $500,000 invoice does not necessarily mean $500,000 of cash will arrive when the invoice is issued. The projected receipt date depends on payment terms, customer behavior, disputes, deductions, collections activity, and other factors.
How to Create a Cash Flow Projection
To create a cash flow projection, establish the beginning cash balance, estimate cash inflows by expected receipt date, estimate cash outflows by expected payment date, calculate net cash flow, and determine the ending cash balance for each period.
Step 1: Determine the Beginning Cash Balance
Start with the cash available at the beginning of the projection period. Use actual bank and accounting information where available.
Step 2: Estimate Customer Collections
Review open invoices, payment terms, historical payment behavior, AR aging, customer commitments, disputes, deductions, and collection activity to estimate when customer payments are likely to arrive.
Cash inflows from customers should be modeled according to expected payment timing rather than simply the total value of outstanding invoices.
Step 3: Estimate Other Cash Inflows
Add other expected receipts, such as financing proceeds, asset sales, investment income, refunds, grants, or other sources of cash.
Step 4: Estimate Cash Outflows
List expected payments by date or period, including suppliers, payroll, taxes, debt service, rent, utilities, capital expenditures, and other obligations.
Step 5: Calculate Net Cash Flow
Subtract projected cash outflows from projected cash inflows.
Net Cash Flow = Projected Inflows − Projected Outflows
Step 6: Calculate Ending Cash
Add net cash flow to the beginning cash balance.
Ending Cash = Beginning Cash + Net Cash Flow
Step 7: Identify Potential Cash Gaps
Compare projected ending cash with minimum cash requirements, debt obligations, planned investments, and other liquidity needs. A projected deficit can then trigger contingency planning.
How Accounts Receivable Affects Cash Flow Projections
Accounts receivable is one of the most important inputs into a cash flow projection because outstanding invoices do not become cash until customers actually pay.
Accounts receivable plays a central role in determining when sales convert into cash.
Several AR factors can affect the timing of projected inflows:
- Invoice due dates
- Customer payment behavior
- Historical days to pay
- Days Sales Outstanding
- Accounts receivable aging
- Customer credit risk
- Payment promises
- Disputes and deductions
- Unapplied cash
- Collection activity
- Changes in payment terms
How DSO Affects Cash Flow Projection
Days Sales Outstanding measures the average time required to collect accounts receivable.
When DSO increases, customer payments generally take longer to arrive. If projected collections are based on outdated payment assumptions, the cash flow projection may overstate near-term liquidity.
For this reason, DSO should be considered alongside invoice-level payment behavior and AR aging rather than being used as the only forecasting input.
AR Aging and Cash Flow Projection
Accounts receivable aging divides outstanding invoices into time buckets based on how long they have remained unpaid.
| AR Aging Bucket | Cash Flow Forecasting Consideration |
|---|---|
| Current | Often represents invoices that may be collected according to normal payment behavior |
| 1–30 days overdue | May require adjustment based on customer payment patterns |
| 31–60 days overdue | Increasing likelihood of collection delay should be considered |
| 61–90 days overdue | May require closer collection and risk assessment |
| 90+ days overdue | Should receive specific review because timing and collectability may be less certain |
Aging should not be treated as a universal prediction rule. Customer-specific payment behavior and current collection information can provide additional context.
How to Forecast Accounts Receivable Cash Inflows
AR cash inflows can be forecast by estimating when each outstanding invoice is likely to be paid, then aggregating those expected payment amounts by day, week, month, or another reporting period.
A simple approach is:
- List open invoices.
- Group invoices by customer and due date.
- Review historical payment behavior.
- Adjust expected payment dates for known disputes or promises to pay.
- Consider aging and customer risk.
- Estimate expected payment amounts.
- Aggregate expected collections by forecast period.
- Compare forecast collections with actual receipts.
Businesses with strong AR cash flow management can use more granular customer and invoice information to improve the timing assumptions within their projections.
Cash Flow Projection and the Order-to-Cash Cycle
The order-to-cash (O2C) cycle directly influences how quickly sales become cash.
Delays can occur at multiple stages:
| O2C Stage | Potential Cash Flow Impact |
|---|---|
| Credit management | Determines customer credit terms and exposure |
| Order management | Can affect order release and fulfillment timing |
| Invoicing | Invoice errors or delays can postpone payment |
| Collections | Late follow-up can delay receipts |
| Payment | Payment-channel and customer behavior affect timing |
| Cash application | Unapplied payments can reduce AR visibility |
| Dispute management | Unresolved disputes can delay collection |
Connecting these processes helps finance teams understand not just how much cash is expected, but why the timing of that cash may change.
Cash Application and Cash Flow Projection
Cash application affects the quality of AR data used in cash-flow planning. When customer payments are received but remain unapplied, the organization may have incomplete visibility into which invoices have actually been settled.
Reducing unapplied cash improves the quality of receivables information and can help finance teams maintain a clearer view of expected collections.
Accurate cash application therefore supports cash-flow forecasting indirectly by keeping customer balances and open-invoice information current.
Historical Data in Cash Flow Projection
Historical cash and payment data can provide useful evidence for estimating future cash movements. However, historical patterns should be adjusted when business conditions have changed.
Useful historical inputs include:
- Customer payment history
- Historical DSO
- Collection rates
- Seasonality
- Revenue patterns
- Supplier payment patterns
- Payroll cycles
- Tax payment schedules
- Capital expenditure patterns
- Historical forecast variance
Seasonality and Business Cycles
Seasonality can materially affect cash inflows and outflows. Retail businesses may experience stronger collections during specific periods, while some industries may have predictable slow seasons.
A projection should therefore avoid assuming that every month will behave like the previous month.
Historical seasonal patterns can be used as a baseline, then adjusted for current sales expectations, customer behavior and known business changes.
One-Time Events and Cash Flow Projections
Large one-time transactions can distort a projection if they are treated as recurring events.
Examples include:
- Large customer contracts
- Major capital expenditures
- Acquisitions
- Debt financing
- Loan repayments
- Tax settlements
- Insurance proceeds
- Asset sales
- Large legal or regulatory payments
These events should be explicitly identified so decision-makers understand which cash movements are recurring and which are exceptional.
Short-Term vs. Long-Term Cash Flow Projections
Different planning horizons serve different purposes.
| Time Horizon | Primary Purpose | Typical Detail |
|---|---|---|
| Daily | Liquidity and operational cash management | High |
| Weekly | Near-term liquidity planning | High |
| 13-week | Short-term treasury and liquidity management | High |
| Monthly | Budget and operating planning | Medium |
| Quarterly | Financial and strategic planning | Medium |
| Annual | Long-term financial planning | Lower |
13-Week Cash Flow Projection
A 13-week cash flow projection is a commonly used short-term liquidity planning approach that provides a rolling view of expected cash inflows and outflows over approximately one quarter.
It can help finance and treasury teams monitor:
- Beginning cash
- Expected customer collections
- Supplier payments
- Payroll
- Taxes
- Debt service
- Capital expenditures
- Financing activity
- Ending cash
The value of a 13-week model depends on keeping its assumptions current. For businesses with significant receivables, customer-level collection information can improve the quality of expected inflow estimates.
Scenario Planning for Cash Flow
Scenario analysis tests how changes in assumptions could affect future cash balances.
| Scenario | Example Assumptions |
|---|---|
| Base case | Expected collections and planned expenses |
| Upside case | Faster collections or stronger sales |
| Downside case | Slower collections or higher expenses |
| Stress case | Significant collection delays combined with major unexpected outflows |
Scenario planning allows management to define potential responses before a liquidity problem occurs.
Cash Flow Projection vs. Budget
A budget and a cash flow projection answer different questions.
| Cash Flow Projection | Budget |
|---|---|
| Focuses on expected cash movements | Focuses on planned financial performance |
| Emphasizes timing of receipts and payments | Emphasizes planned revenue and expenses |
| Used to manage liquidity | Used to manage financial targets and resources |
| Can be updated frequently as conditions change | Often provides a baseline for a defined planning period |
Common Cash Flow Projection Mistakes
Using Invoice Value as Expected Cash
An open invoice represents a receivable, not necessarily cash available today. Payment timing should be estimated based on actual customer behavior.
Ignoring Delayed Collections
Assuming every customer pays exactly on the contractual due date can make a projection overly optimistic.
Using Stale AR Data
Outdated invoice, aging or payment information can distort expected inflows.
Ignoring One-Time Payments
Large tax payments, capital expenditures, debt repayments or other exceptional outflows can create unexpected liquidity gaps if they are omitted.
Failing to Update the Projection
A projection loses value when actual results are not compared against expected results and assumptions are not updated.
Relying on One Scenario
A single forecast can hide uncertainty. Base, upside and downside scenarios provide a broader view of potential liquidity outcomes.
Cash Flow Projection and Forecast Accuracy
Forecast accuracy should be measured by comparing projected cash movements with actual results.
Finance teams can analyze:
- Projected vs. actual customer collections
- Projected vs. actual payment dates
- Projected vs. actual supplier payments
- Forecast variance by customer
- Forecast variance by aging bucket
- Forecast variance by business unit
- Forecast variance by time period
Repeated variance analysis helps identify which assumptions are consistently wrong and where forecasting models need refinement.
How AI Improves Cash Flow Projection
AI can improve cash flow projection by analyzing historical payment behavior, invoice-level data, customer patterns, AR aging, collections activity and other signals to estimate when cash is likely to arrive.
Instead of treating all receivables as equally likely to be collected on their due dates, AI-based approaches can incorporate customer-specific behavior and transaction history.
Finance teams can use predictive insights to plan working capital and evaluate expected cash availability with more granular information.
Customer Payment Behavior
Different customers may pay at different speeds even when they have identical contractual payment terms. Historical payment behavior can therefore be an important forecasting signal.
Invoice-Level Forecasting
Invoice-level forecasting estimates expected payment timing at the individual invoice level before aggregating results into weekly or monthly cash projections.
Dispute and Deduction Signals
Invoices involved in unresolved disputes or deductions may have a different expected payment date from invoices that are progressing normally.
Collections Activity
Collection actions and customer promises to pay can provide additional information about the expected timing of cash receipts.
Continuous Updates
AI-enabled forecasting can update projections as new payments, invoices, disputes, customer interactions and other data become available.
Technology-Driven Cash Planning in O2C
The order-to-cash process creates many of the data points required for accurate cash forecasting.
Cash flow forecasting in O2C environments benefits from real-time visibility into invoices, payments, exceptions, collections and customer behavior.
Automated Cash Application
When payments are matched and applied promptly, the AR ledger provides a more current view of outstanding receivables.
Collections Automation
Collections workflows can provide information about customer commitments, overdue invoices and expected payment dates.
Credit Risk Monitoring
Changes in customer credit risk can influence the probability and timing of future collections.
Dispute Management
Unresolved disputes can delay payment and should therefore be incorporated into cash-inflow assumptions where relevant.
Cash Flow Projection for Working Capital Management
Cash flow projection and working capital management are closely connected. The timing of customer collections, supplier payments, inventory purchases and other operating cash movements affects how much liquidity remains available to the business.
Improving the accuracy of expected collections can help finance teams make better decisions about:
- Short-term borrowing
- Supplier payment timing
- Capital expenditure
- Inventory purchases
- Investment decisions
- Cash reserves
- Debt repayment
For businesses with significant accounts receivable, improving the quality of AR data is therefore an important part of improving cash visibility.
How Emagia Supports Intelligent Cash Flow Forecasting
Unified AR and Cash Intelligence
Emagia delivers unified visibility across accounts receivable, cash application, and order-to-cash operations. Connecting these data sources can help finance teams understand expected customer collections and the receivables factors affecting liquidity.
AI-Driven Predictive Insights
Emagia uses AI and analytics to analyze customer payment patterns and receivables information to support predictive cash planning.
Receivables-Based Cash Visibility
Because customer collections are a major source of operating cash for many businesses, connecting receivables information with cash forecasting can provide a more granular view of expected inflows.
Operational Efficiency
Automating repetitive AR processes can help finance teams maintain more current data and spend less time manually compiling information for cash planning.
O2C Connection
Cash visibility becomes more useful when it is connected to the broader order-to-cash cycle, including invoicing, collections, cash application, disputes and credit management.
Frequently Asked Questions About Cash Flow Projection
What is a cash flow projection?
A cash flow projection is an estimate of future cash inflows, cash outflows, and ending cash balances over a defined period. It helps businesses plan liquidity, identify potential shortages, and make informed financial decisions.
What is the cash flow projection formula?
The basic formula is Ending Cash = Beginning Cash + Projected Cash Inflows − Projected Cash Outflows. Net cash flow is calculated as projected inflows minus projected outflows.
How do you create a cash flow projection?
Start with the beginning cash balance, estimate expected cash inflows and outflows by timing, calculate net cash flow, determine the ending cash balance, and compare projected cash with required liquidity levels. Update the projection as actual results and assumptions change.
Why is accounts receivable important for cash flow projection?
Accounts receivable determines when credit sales are expected to convert into cash. Payment behavior, invoice aging, DSO, disputes, deductions and collection activity can all affect the timing of customer cash inflows.
What is the difference between a cash flow projection and a cash flow forecast?
Both estimate future cash movements. A forecast generally emphasizes the most likely future outcome based on available data, while a projection may also incorporate planned actions or hypothetical assumptions. Organizations often use the terms interchangeably.
How often should a cash flow projection be updated?
The appropriate frequency depends on the business and its liquidity needs. Businesses with tight or rapidly changing cash positions may update projections daily or weekly, while others may use monthly or longer planning cycles.
What is a 13-week cash flow projection?
A 13-week cash flow projection is a rolling short-term liquidity model that estimates cash inflows, outflows and ending balances across approximately 13 weeks. It is commonly used to monitor near-term liquidity and identify potential funding gaps.
How does DSO affect cash flow projections?
DSO measures the average time required to collect accounts receivable. Higher DSO generally means customer cash arrives later, which can reduce near-term projected liquidity if other factors remain unchanged.
Can AI improve cash flow forecasting?
AI can analyze historical payment behavior, invoice-level information, AR aging, collections activity and other signals to estimate expected payment timing. This can support more granular and frequently updated cash-flow projections.
What are the main components of a cash flow projection?
The main components are beginning cash, projected cash inflows, projected cash outflows, net cash flow and ending cash. Timing assumptions are also critical because the objective is to understand when cash will actually be available.
What is the difference between cash flow and profit?
Profit measures financial performance using accounting principles, while cash flow measures actual cash entering and leaving the business. A profitable business can experience a cash shortage when collections are delayed or significant cash payments occur before customer receipts.
How can businesses avoid cash flow shortfalls?
Businesses can reduce the risk of cash shortfalls by maintaining rolling projections, improving collection visibility, monitoring AR aging and payment behavior, planning major outflows, using scenario analysis, and maintaining appropriate liquidity reserves or financing options.
Key Takeaways
- Cash flow projection estimates future cash availability.
- The basic formula is Beginning Cash + Inflows − Outflows = Ending Cash.
- Cash-flow planning focuses heavily on the timing of receipts and payments.
- Accounts receivable is a critical source of projected operating cash inflows.
- DSO, AR aging, payment behavior, disputes and collections can affect expected collection timing.
- A 13-week projection can provide detailed short-term liquidity visibility.
- Scenario analysis helps finance teams prepare for different cash outcomes.
- Comparing forecasted and actual results helps improve future projections.
- AI can support invoice-level and customer-level payment forecasting.
- Connecting AR automation with cash forecasting can provide more current and granular cash visibility.
Conclusion
A cash flow projection gives finance teams a forward-looking view of when cash is expected to enter and leave the business. Its fundamental calculation is simple, but producing a useful projection requires reliable data and realistic assumptions about payment timing, operating expenses, financing activity and other cash movements.
For businesses with significant accounts receivable, the quality of the projection depends heavily on understanding customer payment behavior. AR aging, DSO, disputes, collections, cash application and invoice-level payment patterns can all influence when expected cash becomes available.
Modern finance teams can strengthen cash visibility by connecting accounts receivable data with automated cash application, collections, reconciliation and predictive analytics. This creates a more dynamic view of future liquidity and enables finance leaders to respond earlier to potential cash gaps.
A well-maintained cash flow projection is therefore more than a spreadsheet. It is a continuously updated decision-making tool that connects cash, accounts receivable, working capital and the order-to-cash cycle.
