A cash flow forecast starts from today’s balance and adds known receipts and bills week by week. Its low point shows whether a short draw, a later purchase or a change in billing is needed. All figures on this page are invented examples.
A sewer jetter repair bill in week 2: how to prepare a cash flow forecast at an Adrian, MI plumbing contractor
A cash flow forecast is a week-by-week list of the money expected in and the money going out, starting from the bank balance today. It is built from what the business already knows: invoices sent and when each customer has paid before, payroll dates, supplier bills, loan payments and any repair bill already on the desk.
Illustration only, invented figures: an Adrian, MI plumbing contractor has $9,300 in the bank and a $5,840 repair bill for its sewer jetter due in week 2. Invented payroll of $7,450 goes out every other week, and supplier bills run about $1,350 a week.
| Week | Money in | Payroll | Other bills | Ending balance |
|---|---|---|---|---|
| Week 1 | $6,200 | $7,450 | $1,350 | $6,700 |
| Week 2 | $4,100 | none | $7,190 | $3,610 |
| Week 3 | $5,300 | $7,450 | $1,350 | $110 |
| Week 4 | $7,900 | none | $1,350 | $6,660 |
| Week 5 | $4,600 | $7,450 | $1,350 | $2,460 |
| Week 6 | $6,800 | none | $1,350 | $7,910 |
The forecast never goes below zero, but week 3 ends at $110, after the jetter bill and a payroll land in consecutive weeks. A cushion that thin leaves no room for a late receipt. In this invented case, a $4,000 draw on a line of credit at a 14.05% annual rate, taken at the start of week 3 and paid back 24 days later in week 6, keeps week 3 at $4,110 and costs $36.95 in interest. A business line of credit is built for short gaps like this one.
Thirteen weeks at an Adrian, MI engineering firm: where the liability premium lands in a 13-week cash flow forecast
Thirteen weeks is one quarter, close enough to see a large bill coming and short enough to estimate receipts with some confidence. Illustration only, invented figures: an Adrian, MI engineering firm starts the quarter with $12,400. Invented payroll of $9,200 goes out in odd-numbered weeks, rent of $2,300 falls on the first of each month (weeks 1, 5 and 10 here), other bills run $850 a week, and the annual professional liability premium of $11,600 is due in week 9.
| Week | Client receipts | Payroll | Rent, premium and other bills | Ending balance |
|---|---|---|---|---|
| Week 1 | $7,600 | $9,200 | $3,150 | $7,650 |
| Week 2 | $5,200 | none | $850 | $12,000 |
| Week 3 | $8,900 | $9,200 | $850 | $10,850 |
| Week 4 | $6,100 | none | $850 | $16,100 |
| Week 5 | $4,800 | $9,200 | $3,150 | $8,550 |
| Week 6 | $9,700 | none | $850 | $17,400 |
| Week 7 | $5,600 | $9,200 | $850 | $12,950 |
| Week 8 | $6,300 | none | $850 | $18,400 |
| Week 9 | $7,200 | $9,200 | $12,450 | $3,950 |
| Week 10 | $4,900 | none | $3,150 | $5,700 |
| Week 11 | $8,800 | $9,200 | $850 | $4,450 |
| Week 12 | $6,600 | none | $850 | $10,200 |
| Week 13 | $7,400 | $9,200 | $850 | $7,550 |
The low point is week 9, at $3,950, when the premium and a payroll land together. Where the insurer offers a quarterly plan, the invented $11,600 premium becomes four payments of $2,900, and only the first falls inside this forecast: week 9 then ends at $12,650, weeks 10 to 13 each end $8,700 higher, and the lowest week becomes week 1 at $7,650. Any installment charge is the insurer's to set, and the three later payments belong in the next quarters' forecasts.
How a business can improve cash flow before financing technician tools: a Lenawee County, MI auto repair shop
A business improves its cash flow by changing timing: money in sooner, money out on the full terms already agreed, and less cash tied up in parts that wait on a shelf. For an auto repair shop, that can mean:
- Taking a deposit on large special-order parts before ordering them.
- Invoicing fleet accounts every week instead of once a month.
- Sending slow-moving parts back where the supplier accepts returns.
- Paying the parts account on its due date rather than early, unless an early-pay discount is offered.
- Setting a new tool payment’s due date after the weekly fleet receipts arrive.
Illustration only, invented figures: a Lenawee County, MI auto repair shop wants cordless impact wrenches, a torque wrench set and a strut compressor, $7,480 together. Put on equipment financing for 36 months at a 12.2% annual rate, the invented set costs $249.16 a month, and the payments sum to $8,969.76, interest being $1,489.76 of it. If weekly fleet invoicing brings $2,600 of receipts in about three weeks earlier, that one-time gain in cash on hand is enough for 10 of those payments.
What each Adrian, MI funding article on this blog works through
Each article takes one question an Adrian, MI owner might bring to a call: how a term loan compares with other business loans, what contractor financing means for a contractor’s own costs and for its customers, how a child care center pays for strollers, a laundry machine and a three-payday month, which fees and collateral can come with a therapy clinic’s loan, which costs follow when a shop or restaurant changes hands, and how a UCC lien is filed and released.
Figures in the articles are invented and marked that way, the arithmetic is shown in full, and each one ends with links to the funding pages that match its case. The trades are ones counted in Lenawee County, MI, and the contractor article cites the county’s Census figures for its trade group.
By Valeshire Financial · Updated
