All guides

Equipment Financing Cash Flow: Build a 13-Week Forecast

Map equipment payments, supplier deposits and customer collections over 13 weeks. Test delivery delays and identify the lowest projected cash balance.

By · Published · Updated

Sources, examples and editorial standards

In this guide

The week your new machine arrives can be the week your bank balance reaches its lowest point. You have paid the deposit, installation contractors want their money, and the first customer invoice may still be several weeks away. A profitable purchase can create a cash shortage during that gap.

An equipment purchase forecast should show when money moves through the bank account. Put the supplier’s payment schedule beside your payroll calendar and customer collection dates. Then add financing proceeds only when the provider has confirmed the conditions for releasing them. An approval letter and cleared funds are different events.

A thirteen-week forecast is a useful planning format for a purchase nearing delivery. It is short enough to update every week and long enough to expose a substantial installation or collection delay. Add a monthly forecast beyond that period when repayment, seasonal demand or a long commissioning schedule requires it. The time horizon should fit the purchase.

Start with the bank balance you can actually spend

Choose a forecast start date and reconcile the opening balance. Outstanding payments, payroll withdrawals already submitted and restricted balances can make the amount displayed in online banking larger than the amount available for a deposit. Keep those adjustments visible so another person can reproduce the starting number.

Record the currency at the top of the workbook. If the equipment invoice is in another currency, give it its own calculation with an exchange-rate assumption. Mixing a Canadian-dollar bank balance with a U.S.-dollar invoice produces a forecast that can look comfortable while being materially wrong.

Choose a minimum cash balance for internal planning. This is an operating decision, not a universal lender requirement. A contractor with weekly payroll and volatile collections might choose a different cushion from a business with monthly subscriptions. Identify the bills that the cushion is intended to cover. A round number without a reason is hard to defend when someone proposes spending it.

Keep an undrawn credit facility outside opening cash. You can show a separate borrowing row if drawing is permitted and feasible, but available borrowing and cash already in the account are different resources. Check any limits or conditions before assuming the entire facility can fund the installation.

Use collections rather than sales

Begin with invoices already issued. For each material invoice, record its amount, due date, expected receipt date and reason for that date. A signed payment schedule, a customer’s recent payment pattern and a verbal promise have different levels of reliability. You can flag uncertainty without inventing a precise probability.

Next add work that has been booked but not invoiced. Map the sequence from production to shipment, customer acceptance, invoicing and payment. If the customer pays thirty days after accepting the work, the forecast needs an acceptance date as well as a shipment date. A machine that starts producing in week six may contribute no cash until week eleven.

Keep proposed new orders separate from committed work. This lets you test the purchase using an existing order book before including sales that still depend on winning a bid. It also helps identify whether the purchase is justified by demonstrated demand or by an expansion plan that needs its own financing cushion.

Avoid putting the entire accounts receivable balance into the first week. Old disputed invoices should receive individual attention. If collection is uncertain, place them in an upside scenario until you have enough evidence to include them in the working forecast.

Build the equipment payment timeline

Request a supplier schedule that identifies the deposit, any construction milestones, shipment balance, installation charge and final acceptance payment. For each milestone, record the documents or events that trigger payment. A shipment balance due before dispatch may have to be paid several weeks before you can inspect the machine at your premises.

Now map the financing provider’s disbursements. Will it pay the supplier directly? Will it reimburse an earlier payment? Does it require serial numbers, an invoice, proof of insurance or acceptance? Ask for the answer in writing and put the expected funding date beside the supplier’s due date.

Direct supplier funding belongs in a separate project schedule if it never enters your operating account. Counting the proceeds as cash received while omitting the matching supplier payment overstates the bank balance. Alternatively, show both sides explicitly and label them as direct settlement so readers understand the movement.

Add freight, rigging, electrical work, initial supplies and training as distinct rows. Some may be financed; others may need cash. The financing offer should identify the approved costs. A purchase price and an installed operating cost are rarely interchangeable planning numbers.

A worked purchase forecast

Consider a fictional workshop that starts with $48,000 in available cash and wants to maintain a $20,000 operating cushion. All amounts below use one currency. Taxes are omitted solely to keep the illustration readable; a real forecast needs the actual tax payments and any recoveries at their expected dates.

The machine costs $80,000. The shop pays a $16,000 deposit in week one. Its financing provider pays the remaining $64,000 directly to the supplier in week three. The workshop then pays $8,000 for installation in week four and $4,000 for tooling in week five. The direct $64,000 settlement does not enter the bank-account table.

The hypothetical financing schedule requires $1,400 monthly, beginning in week five, with another payment in week nine. This is a planning assumption, not an interest-rate quote or a calculated amortization schedule. Replace it with the contractual schedule before relying on the forecast.

Week Opening cash Collections Ordinary operating payments Equipment and finance payments Closing cash
1 $48,000 $18,000 $15,000 $16,000 $35,000
2 $35,000 $16,000 $17,000 $0 $34,000
3 $34,000 $22,000 $16,000 $0 $40,000
4 $40,000 $15,000 $18,000 $8,000 $29,000
5 $29,000 $20,000 $17,000 $5,400 $26,600
6 $26,600 $18,000 $19,000 $0 $25,600
7 $25,600 $24,000 $18,000 $0 $31,600
8 $31,600 $20,000 $20,000 $0 $31,600
9 $31,600 $26,000 $19,000 $1,400 $37,200
10 $37,200 $22,000 $21,000 $0 $38,200
11 $38,200 $28,000 $20,000 $0 $46,200
12 $46,200 $24,000 $22,000 $0 $48,200
13 $48,200 $30,000 $21,000 $0 $57,200

Each closing balance equals opening cash plus collections minus both payment columns. Total collections are $283,000, operating payments total $243,000, and equipment-related bank payments total $30,800. Starting cash of $48,000 therefore becomes $57,200.

The lowest projected balance is $25,600 in week six. The planned cushion is only $5,600 below that low point. Looking solely at the final $57,200 balance would conceal the tighter period immediately after installation.

The scheduled operating payments include the business’s existing costs. In a real workbook, split them into payroll, materials, premises, taxes, existing debt and other obligations so you can see which dates are movable and which are fixed.

Test a collection delay without changing the sale

Suppose $12,000 of week-five collections arrives in week eight instead. Revenue and the total thirteen-week receipts are unchanged. Cash timing changes considerably: closing cash becomes $14,600 in week five, $13,600 in week six and $19,600 in week seven. Receipt in week eight restores the original path.

The maximum shortfall against the $20,000 planning cushion is $6,400. The business still has positive cash, but its desired operating protection has disappeared. That could justify arranging additional liquidity, changing the supplier schedule or postponing the installation until a large receivable clears.

Do not label this scenario a failed purchase merely because it breaches an internal cushion. The forecast identifies a decision. Management still has to decide whether the remaining cash is enough, whether the delayed collection is credible and whether an alternative funding source is available on acceptable terms.

A useful scenario sheet changes only the assumptions being tested. If you silently improve sales elsewhere while delaying a receipt, the effect becomes difficult to interpret. Keep the base forecast and the delayed-collection forecast side by side.

Test commissioning and production separately

A delayed start can affect several rows. It may postpone customer invoices, require rental equipment, extend installation labour and leave finance payments starting before production. Enter these effects separately to avoid counting the same loss twice.

For example, imagine the workshop must rent temporary equipment for two weeks at $900 per week. The extra cash cost is $1,800. If this cost occurs in weeks five and six, the base-case low point falls from $25,600 to $23,800. Combining that expense with the collection-delay scenario reduces the low point to $11,800.

There may also be savings during the delay because the new machine has not consumed materials or power. Include those only if the payments genuinely disappear or move beyond the relevant weeks. An employee who remains on payroll during commissioning does not create a payroll saving simply because production is lower.

Separate capacity from demand. A machine capable of producing twice as much does not automatically bring twice the cash receipts. The forecast needs an order volume, selling price, variable cost, production schedule and collection assumption. The equipment utilization guide can support the operating side of that calculation.

Make the forecast useful to a financing provider

A readable forecast explains the requested amount and when it is needed. Attach the supplier quote, milestone schedule, installation estimate and proposed payment schedule. Reconcile forecast opening cash to the statements supplied with the application. Explain unusual receipts or transfers that materially change liquidity.

Provide a brief assumptions page. List expected delivery, first production, first incremental invoice and first collection dates. Explain whether additional operators are already employed, need training or must be hired. Show how the new purchase affects existing debt payments and any seasonal low point beyond thirteen weeks.

The U.S. Small Business Administration’s business-plan guidance describes financial projections as part of a traditional business plan and calls for forecasts to align with the funding request. A weekly cash schedule is one practical supporting document; it does not replace whatever financial information a particular provider requests.

Use plain explanations for adverse weeks. A supplier deposit in week one is understandable. A large unexplained withdrawal is harder to evaluate. Avoid moving expenses into later weeks merely to make the application appear stronger; a schedule that reflects actual obligations is more useful to both parties.

Update the forecast after every material change

Choose one owner for the workbook and one regular update time. Replace the completed week’s estimate with actual receipts and payments. Explain major differences, move the forecast forward by a week, and add a new final week so the planning horizon remains useful.

Track timing differences separately from permanent changes. A customer payment arriving one week late is different from an invoice being written off. Installation that costs $2,000 more is different from an unchanged installation bill being paid earlier. This separation helps prevent repeated optimistic assumptions.

Retain dated versions. If every revision overwrites the previous assumptions, you cannot see whether delivery has slipped repeatedly or collections have consistently arrived later than expected. A small variance log can be enough: planned date, actual date, amount, explanation and next action.

After the equipment begins operating, compare expected contribution with actual output and direct costs. A bank balance can be supported temporarily by old receivables even when the new asset is underperforming. The cash forecast and the production review answer different questions and should be read together.

Questions that often expose missing cash needs

Should depreciation appear as a payment?

Depreciation is not itself a bank withdrawal. The equipment purchase and financing payments belong in the cash forecast at their actual dates. Your accountant may need depreciation elsewhere in financial projections or tax calculations, but including it as another cash payment would distort this schedule.

Where do owner contributions belong?

Show a confirmed owner contribution as a separate financing receipt on its expected date. Identify whether it is equity or a repayable advance in the supporting records. If it remains an intention, show the forecast both with and without it. Personal cash that has not been committed should not quietly solve a business shortfall.

Can an expected tax recovery fund the deposit?

Only money available by the deposit deadline can fund that deadline. Ask your accountant about the applicable treatment and realistic timing, then enter any recovery separately. Do not deduct an expected future recovery from a supplier invoice that must be paid in full today.

What if the first thirteen weeks look comfortable?

Extend the forecast across the first seasonal downturn and any final purchase payment or balloon. The initial period can look healthy because customers paid deposits or the supplier offered deferred payments. Put those later obligations on the calendar before deciding how much opening cash can be spent.

Bring the completed schedule into the purchase decision before signing an inflexible supplier commitment. The most useful result is a clear funding date, an achievable payment schedule and a credible response if collections or commissioning run late.

Ready to compare financing?

Use the on-site tool to compare upfront cash, scheduled payments, fees and end-of-term costs from your written quotes.

Compare written quotes

Educational tool, not an application. See our publisher disclosure.

Put the research to work

Check the numbers and your next steps

Original worked illustration · not lender pricing

Test coverage after adding the new payment

For equipment financing cash flow, test the operating assumption that can change affordability before comparing payments.

Calculation: Illustrative debt service coverage = cash available for debt service ÷ annual debt service

Hypothetical inputs and calculated results. Use one consistent currency unless a currency pair is explicitly shown; figures are not market averages or financing offers.
Input or measureIllustration
Annual cash available (assumed)65,000
Existing annual debt service50,000: 1.30× coverage
Proposed additional annual debt service15,000
Combined annual debt service / coverage65,000 / 1.00×

Decision takeaway: The example leaves no modeled debt-service cushion after the purchase. Lenders define cash available and coverage differently; these are not approval thresholds.

Relevant next reads

Choose the next guide for your asset, application or contract question. Each link leads to a different part of the equipment decision.

Additional decision metrics and research links updated . Existing provider-source review dates remain separate.