How to Create a Pro Forma Cash Flow Statement for Your Business

A pro forma cash flow statement is one of the most useful planning tools a business owner can build. It helps you estimate how much cash will enter and leave the business over a future period so you can spot shortages early, prepare for growth, and make more confident decisions.

For startups and small businesses, this forecast is especially important. A company can be profitable on paper and still run out of cash if customers pay slowly, expenses arrive early, or one-time startup costs are larger than expected. A pro forma cash flow statement helps you see those timing gaps before they become problems.

If you are forming a new LLC or corporation, this kind of forecast can also help you judge whether your business has enough capital to cover formation costs, registered agent fees, equipment, inventory, payroll, marketing, and other early operating expenses.

What Is a Pro Forma Cash Flow Statement?

A pro forma cash flow statement is a forward-looking estimate of your business's cash inflows and cash outflows for a specific period, such as a month, quarter, or year. Unlike a historical cash flow statement, which shows what already happened, a pro forma statement shows what you expect to happen.

It is built around cash movement, not accounting profit. That means it focuses on when cash is actually received and when cash is actually paid out. This distinction matters because a business can record revenue and still not have enough cash in the bank to pay bills.

A complete financial plan often includes three related projections:

• A pro forma income statement, which estimates profit or loss
• A pro forma balance sheet, which estimates assets, liabilities, and equity
• A pro forma cash flow statement, which estimates cash availability

Together, these projections give a clearer view of your business's financial health.

Why It Matters

A pro forma cash flow statement helps you answer practical questions such as:

• Will the business have enough cash to cover payroll and rent?
• When will customers' payments actually arrive?
• How much working capital is needed to keep the business running?
• Will the business need a loan, investor funding, or owner contributions?
• Can the business afford to expand at the planned pace?

For new businesses, the answer to these questions can shape everything from launch timing to hiring plans. For established companies, a cash flow forecast helps with expansion, seasonal planning, and risk management.

What You Need Before You Start

Before you build your forecast, gather the key assumptions that drive cash movement. The more realistic your inputs, the more useful your projection will be.

1. Opening cash balance

Start with the amount of cash currently available in the business bank account.

2. Expected cash inflows

These may include:

• Sales revenue collected in cash
• Customer payments on invoices
• Investment capital
• Loan proceeds
• Grants or other funding sources
• Asset sales

3. Expected cash outflows

These may include:

• Inventory purchases
• Payroll and contractor payments
• Rent and utilities
• Insurance
• Taxes
• Loan payments
• Marketing costs
• Software subscriptions
• Professional services
• One-time startup expenses

4. Timing assumptions

This is one of the most important parts of the model. Revenue is not always received when it is earned, and expenses are not always paid at the moment they are incurred. You need to know:

• How long customers take to pay
• When vendor invoices are due
• Whether payroll is weekly, biweekly, or monthly
• Which costs are paid upfront
• Which expenses are seasonal or irregular

5. Planned financing

If you expect to use savings, outside investment, or debt financing, include those funds in the forecast and note when they will arrive.

How to Create a Pro Forma Cash Flow Statement

Follow these steps to build a useful forecast.

Step 1: Choose your forecast period

Decide whether you are projecting monthly, quarterly, or weekly. Monthly forecasts work well for most small businesses. Weekly forecasts can be better for businesses with tight margins or rapid cash turnover.

A good planning horizon is 12 months for a new business and 12 to 24 months for a growing business.

Step 2: Estimate cash inflows

List every expected source of cash for each period. Be conservative. If some revenue is uncertain, discount it or move it to a later period.

For example, if you sell services on 30-day terms, a sale made in January may not produce cash until February. If you sell products through an online store, some cash may arrive immediately, but refunds or chargebacks should also be considered.

Step 3: Estimate cash outflows

List every planned cash payment. Include fixed costs, variable costs, and one-time startup costs. Do not forget less obvious expenses such as annual report filings, permits, professional fees, or equipment replacement.

New businesses often underestimate early outflows because they focus on launch revenue and forget about setup costs that occur before revenue begins.

Step 4: Account for timing differences

Cash flow forecasting is mostly about timing. A profitable sale does not help if the cash does not arrive soon enough to pay rent.

Common timing issues include:

• Customers paying later than expected
• Suppliers requiring deposits
• Payroll coming due before customer payments clear
• Tax obligations being paid quarterly instead of monthly
• Seasonal spikes in inventory purchases

Build your forecast around the actual payment dates, not just the accounting dates.

Step 5: Calculate net cash flow

For each period, subtract total cash outflows from total cash inflows.

Net cash flow = Cash inflows - Cash outflows

If the result is positive, cash is increasing. If the result is negative, the business is using more cash than it is generating.

Step 6: Calculate ending cash balance

Take the opening cash balance and add the net cash flow for the period.

Ending cash balance = Opening cash balance + Net cash flow

That ending balance becomes the next period's opening balance.

Step 7: Review the low points

The most important part of the forecast is not the final number. It is the lowest cash balance in the plan. That is the point where the business is most likely to need financing, delayed spending, or a change in operations.

Example of a Simple Pro Forma Cash Flow

Here is a basic monthly example for a new business.

This example shows a business that is still burning cash each month, even though revenue is growing. A forecast like this helps the owner see how much additional capital is needed before the cash balance becomes too low.

How to Interpret the Results

Once the forecast is complete, look for the patterns.

Positive cash trends

If cash balances are rising steadily, the business may have room to hire, invest, or build a reserve.

Negative cash trends

If the ending balance keeps shrinking, the business may need to cut costs, accelerate collections, increase prices, or secure funding.

Seasonal swings

Some businesses are cash-rich in one quarter and cash-poor in another. Retail, landscaping, tax preparation, and many consumer services businesses often need seasonal planning to avoid cash strain.

Financing gaps

If the forecast shows a shortfall, identify the exact month when the gap appears. That is the best time to explore funding options, instead of waiting until the account is nearly empty.

Common Mistakes to Avoid

Confusing profit with cash

Profit and cash are not the same. A business can show profit but still be short on cash if receivables are unpaid or large expenses are due.

Overestimating revenue

Early forecasts often assume sales will arrive faster than they really do. Use realistic assumptions and build in a cushion.

Ignoring payment timing

Always model when cash is collected and when bills are paid. Timing is often the difference between a healthy forecast and a misleading one.

Forgetting one-time expenses

Startup costs, legal fees, equipment purchases, and deposits can have a major impact on cash flow. Include them from the start.

Leaving the forecast unchanged

A pro forma cash flow statement should be updated regularly. If sales, expenses, or timing assumptions change, the forecast should change too.

Best Practices for a Better Forecast

• Use conservative assumptions for revenue and collections
• Separate fixed costs from variable costs
• Include a reserve for unexpected expenses
• Compare actual results against projected results each month
• Update the model when prices, headcount, or vendor terms change
• Build scenarios for best case, expected case, and worst case

Scenario planning is especially helpful for new businesses. If the best-case forecast looks great but the worst-case forecast creates a funding problem, you know in advance that you need a backup plan.

How This Helps New Businesses

For entrepreneurs forming a new business, a pro forma cash flow statement is more than a spreadsheet. It is a planning tool that helps you decide whether the company is ready to launch, how much capital it needs, and how quickly it can grow.

If you are starting an LLC or corporation, your early expenses may include:

• State filing fees
• Registered agent services
• Operating agreement or bylaws preparation
• Business licenses and permits
• Website and branding costs
• Equipment, supplies, and inventory
• Marketing launch expenses
• Payroll or contractor costs

A realistic forecast helps you understand whether the business can handle those costs without running out of money. That kind of clarity supports better decisions before and after formation.

Final Thoughts

A pro forma cash flow statement gives you a practical view of the money your business is likely to have in the future. It helps you plan for slow customer payments, seasonal shifts, startup spending, and growth opportunities.

The process is straightforward: estimate cash inflows, estimate cash outflows, account for timing, and calculate the ending balance for each period. Once you do that, you can spot risks early and make decisions with more confidence.

For any business owner, especially one launching a new company, cash flow planning is not optional. It is one of the core tools for staying financially stable and building a business that can grow.

This article is for general informational purposes only and does not constitute legal, tax, or accounting advice. For specific questions, consult a licensed professional.