A five-step cash forecast method, an invented 13-week forecast for a gift shop with its low week marked, six ways to improve cash flow before borrowing, and the article list.
How Hawaii County, HI coffee and snack shops prepare a cash flow forecast
A cash flow forecast is a week-by-week estimate of the cash that comes in and goes out. For a coffee or snack bar, where card deposits land almost every day and beans, milk and cups are paid on supplier terms, it shows the week the account runs thin before that week arrives.
- Start with the cash in the business account today, not the profit on last month’s statement.
- List the cash expected in each week: card-processor deposits, cash sales banked and any catering invoices due.
- List the cash going out each week: rent, payroll on its real paydays, supplier invoices on their due dates, loan or lease payments and tax payments.
- Subtract to get each week’s ending cash and carry it into the next week.
- Mark the week with the least cash; that figure, and the reason for it, is what a funding request should explain.
Building a 13-week cash flow forecast at a Hawaii County, HI gift shop
Illustration only, invented figures. A gift shop opens the quarter with $6,500 in the bank. It pays $3,200 rent in weeks 1, 5 and 9 (the weeks that hold the first of a month in this example), $3,100 of payroll every other week, about $1,900 a week for supplies, utilities and card fees, and a $11,800 supplier invoice for new stock in week 6.
| Week | Cash in | Cash out | Ending cash |
|---|---|---|---|
| Week 1 | $5,800 | $5,100 | $7,200 |
| Week 2 | $6,100 | $5,000 | $8,300 |
| Week 3 | $5,900 | $1,900 | $12,300 |
| Week 4 | $6,300 | $5,000 | $13,600 |
| Week 5 | $6,000 | $5,100 | $14,500 |
| Week 6 | $5,700 | $16,800 | $3,400 |
| Week 7 | $5,600 | $1,900 | $7,100 |
| Week 8 | $6,200 | $5,000 | $8,300 |
| Week 9 | $6,400 | $5,100 | $9,600 |
| Week 10 | $6,100 | $5,000 | $10,700 |
| Week 11 | $5,900 | $1,900 | $14,700 |
| Week 12 | $6,000 | $5,000 | $15,700 |
| Week 13 | $6,300 | $1,900 | $20,100 |
The low point comes in week 6, when the stock invoice lands in a payroll week and ending cash drops from $14,500 to $3,400. Week 13 ends with $20,100 in the account. That one week is what a line of credit or inventory financing would be sized to cover, and the forecast is worth keeping ready in case a partner asks how the money would be paid back.
How Hilo, HI clothing and gift shops can improve cash flow before borrowing
Borrowing has a cost, so it pays to tighten cash first. For a Hilo, HI clothing or gift shop:
- Reorder slow-moving lines in smaller quantities and put the cash into the items that sell through.
- Ask suppliers for net-30 or net-45 terms on repeat orders, and pay on the due date unless paying early earns a discount.
- Mark down stock that has sat for months before buying more of the same category.
- Switch card deposits to daily payouts if the processor offers them.
- Hold back owner draws in the weeks the forecast shows low.
- Keep personal and business spending in separate accounts, so the bank statements a partner reads show the shop alone.
One-person shops need the same habits: Nonemployer Statistics counted 289 clothing, clothing accessories, shoe and jewelry retailers without paid employees in Hawaii County, HI in 2024 (NAICS 458), and for those the owner’s draw is the cash-out line to plan first.
Articles for Hilo, HI gift shops, inns, food trucks and landscape crews
- Putting a Hilo, HI Restaurant on Wheels: financing a food truck, its kitchen equipment and its first months on the road
- Inn and Motel Updates in Hilo, HI: funding room furnishings, linens and door locks
- Gift Shop Stock Funding in Hilo, HI: paying for inventory before it sells
- Landscape Crew Equipment in Hilo, HI: mowers, trailers and the payment math
- Working Capital for Shipping Gaps in Hilo, HI: covering the weeks between paying for goods and selling them
- Preparing a Hilo, HI Business Loan Request: the records and steps before you call
By Tealvale Capital Group · Updated
