Free 13-Week Cash Flow Calculator for Small Businesses

Cash flow can change quickly, even when a business is profitable.

A large supplier payment, slower customer collections, payroll, inventory purchases or an unexpected expense can create a temporary cash shortage that may not be obvious from monthly financial statements.

This free 13-week cash flow calculator helps business owners estimate how much cash may be available over the coming three months and identify potential shortfalls before they become urgent.

There is no signup required.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast estimates the cash a business expects to receive and pay out over approximately three months.

Unlike a profit-and-loss statement, which measures revenue and expenses for accounting purposes, a cash flow forecast focuses on when money actually enters and leaves the business.

That distinction can be important.

A business may show a profit while still experiencing a cash shortage because customers have not yet paid, inventory has been purchased in advance, payroll is due before revenue is collected, or large expenses fall within the same period.

How to Use the Calculator

Start by entering your current available business cash.

Then enter your normal weekly figures for:

• Customer payments and other cash receipts
• Payroll
• Inventory and supplier payments
• Rent and occupancy costs
• Business debt payments
• Other operating expenses

You can also add a one-time expense or expected cash receipt.

Once the forecast is generated, each of the 13 weeks can be edited individually. This is useful if you know that certain weeks will have higher sales, larger supplier bills, additional payroll or unusual expenses.

The calculator will show your projected ending balance each week, your lowest projected cash balance and whether your forecast indicates a potential cash shortfall.

Why 13 Weeks?

Thirteen weeks is long enough to identify developing cash-flow problems while remaining short enough for businesses to make reasonably detailed estimates about upcoming collections and expenses.

It can also help owners identify exactly when a cash shortage may occur rather than simply discovering that cash is tight after the fact.

For example, a business might appear comfortable today but face a significant inventory payment in Week 5 followed by payroll in Week 6.

Seeing that gap in advance gives the business more time to respond.

Cash Flow Is Not the Same as Profit

One of the most common misunderstandings in business finance is assuming that a profitable business will always have sufficient cash.

Imagine a company makes a $50,000 sale today but allows its customer 60 days to pay.

The sale may contribute to the company’s accounting profit immediately, but the business may still need to pay employees, suppliers, rent and other expenses before receiving the customer’s money.

That timing difference creates a working-capital need.

The same situation commonly occurs when businesses purchase inventory before selling it, take on larger projects, experience rapid growth or have customers that pay slowly.

What If the Calculator Shows a Cash Shortfall?

A projected shortfall does not automatically mean a business needs additional financing.

First review the assumptions behind the forecast.

Businesses may sometimes improve their cash position by collecting outstanding invoices sooner, negotiating supplier terms, adjusting inventory purchases, postponing discretionary expenses or changing the timing of certain payments.

If a genuine working-capital gap remains, the forecast can help establish approximately how much capital may be required and when it may be needed.

Businesses considering outside capital can learn more about the business financing options available from Rock Drive Business Capital.

When Should You Update Your Forecast?

A 13-week forecast is most useful when it is updated regularly.

Many businesses review their forecast weekly and replace estimated figures with actual results as each week passes.

Updating the forecast allows new information — such as changes in sales, customer payment dates, inventory purchases or unexpected expenses — to be incorporated into future projections.

Who Can Use This Calculator?

The calculator can be useful for many types of businesses, including:

Retail businesses managing inventory purchases.

Restaurants balancing payroll, food costs and seasonal sales.

Construction companies managing project expenses and customer payment schedules.

Trucking and transportation companies dealing with fuel, payroll, repairs and delayed customer payments.

Wholesalers purchasing stock before receiving customer payments.

Professional-service businesses working with invoices and longer payment terms.

Healthcare businesses balancing payroll and reimbursement timing.

The underlying principle is the same: understanding when cash is expected to enter and leave the business can make financial planning easier.

Frequently Asked Questions

Is this calculator free?

Yes. The Rock Drive Business Capital 13-week cash flow calculator is free to use and does not require an email address or registration.

Does the calculator store my financial information?

The calculator performs the calculations directly on the page. Users should nevertheless avoid entering confidential information beyond the figures needed to create the forecast.

What should I include as cash coming in?

Include cash you realistically expect the business to receive during each particular week, rather than simply sales that may be invoiced but not yet collected.

What expenses should I include?

Include expected cash payments such as payroll, inventory, supplier invoices, rent, loan payments and other operating expenses.

What happens if my projected balance becomes negative?

A negative projected balance indicates that, based on the figures entered, expected cash payments exceed available cash during that period.

It may be worth reviewing collections, expenses and available sources of working capital well before that week arrives.

Is a 13-week forecast guaranteed to be accurate?

No. A forecast is an estimate based on the information entered. Actual sales, collections and expenses may be different. Updating the forecast regularly generally makes it more useful.

---

This calculator and accompanying information are provided for general educational purposes only and should not be considered financial, accounting, legal or lending advice.