Notes on a 13-week cash flow forecast for a sit-down restaurant, ways to steady cash before borrowing, a law office forecast, and the topics of the articles for Muscatine, IA owners.
Building a 13-week cash flow forecast at a Muscatine County, IA sit-down restaurant
A 13-week forecast runs three months with a row for each week, showing cash expected in, cash going out and what is left when the week ends. Illustration only, invented figures: a sit-down restaurant starts with $12,000 in the bank, buys $7,300 of food and supplies and $2,100 of other costs each week, runs a $10,900 payroll every other week, pays $5,200 rent in weeks 1, 5 and 9, and has a $6,400 walk-in cooler repair in week 7.
| Week | Deposits | Payments out | Ending balance |
|---|---|---|---|
| Week 1 | $17,200 | $25,500 | $3,700 |
| Week 2 | $16,100 | $9,400 | $10,400 |
| Week 3 | $17,900 | $20,300 | $8,000 |
| Week 4 | $15,800 | $9,400 | $14,400 |
| Week 5 | $16,600 | $25,500 | $5,500 |
| Week 6 | $18,300 | $9,400 | $14,400 |
| Week 7 | $15,400 | $26,700 | $3,100 |
| Week 8 | $17,000 | $9,400 | $10,700 |
| Week 9 | $16,200 | $25,500 | $1,400 |
| Week 10 | $17,500 | $9,400 | $9,500 |
| Week 11 | $18,100 | $20,300 | $7,300 |
| Week 12 | $15,900 | $9,400 | $13,800 |
| Week 13 | $16,800 | $20,300 | $10,300 |
Week 9, with rent, a payroll and a full food order landing together, leaves only $1,400 in this example; by week 13 the balance has climbed back to $10,300. That dip has a size and a date, which is the shape of a line of credit draw rather than a lump sum.
How Muscatine, IA sit-down restaurants can improve cash flow before borrowing
- Order food against the forecast instead of last week's sales
- Ask suppliers for due dates that land after payroll rather than on top of it
- Treat gift card sales as meals still owed, not spare cash
- Reprice the dishes whose food cost has moved
- Match card deposits to the sales report each week so a missing batch shows up
Payroll weighs on these kitchens: 21 of the 32 establishments under Full-Service Restaurants (NAICS 722511) in Muscatine County, IA had five or more employees in 2023, by our arithmetic from County Business Patterns. When the forecast still shows a gap after these changes, working capital can cover it, and the request names the amount and the week.
How Muscatine County, IA law offices prepare a cash flow forecast
A law office forecast lists expected collections matter by matter, each dated from the firm's own payment history, and keeps contingency fees out of the base case until they settle. Rent, payroll, malpractice insurance and software go in on their due dates. In Muscatine County, IA, County Business Patterns counted 22 establishments under Legal Services (NAICS 5411) for 2023. A firm that sees a gap coming can weigh a line of credit; one buying a retiring lawyer's practice is looking at a term loan, and the payment calculator shows what that payment does to the forecast.
Articles for Muscatine, IA sit-down restaurants and chiropractic and therapy offices
- How a business term loan is repaid, month by month, for a Muscatine, IA owner
- Taking over an established Muscatine, IA business, from the seller's numbers to the funding gap
- A concession trailer for a Muscatine, IA restaurant
- Vendor and supplier financing in Muscatine, IA
- What shapes dental loan pricing in Muscatine, IA
- When a short payback fits a Muscatine, IA business
For a sit-down restaurant, the concession trailer and vendor financing topics are the closest fit. A chiropractic or therapy office buying a decompression table or treatment-room furnishings can compare the term loan and short payback topics. A gas station store adding cooler doors or a coffee bar can start with vendor financing, and a home builder pricing a skid steer can read how a term loan is repaid.
By Southglen Business Funding · Updated
