One-Time 3-Month Budget and Cash Flow Forecast for a Cafe (Excel)

Project Desciption

About the job
I run a small café in Yan, Kedah. I need a one-time Excel forecast showing my expected income, costs and cash position over the next 3 months, so I can plan purchases, pay suppliers on time and spot any month where cash may run short. This is a single project with a clear end, not ongoing work.

What you’ll do

• Build a 3-month budget and cash flow forecast in Excel, month by month
• Income: forecast sales from my past POS data (daily average sales, trading days per month, average spend per receipt), with low, expected and high scenarios
• Costs: variable costs (ingredients, packaging as a % of sales) and fixed costs (rent, utilities, staff, loan or other repayments, subscriptions)
• One-off items: planned expenses such as the brand refresh, equipment and repairs
• Show opening cash, cash in, cash out and closing cash for each month, plus a line for the lowest cash point
• Include supplier payment timing (paid vs on credit) and customer payment timing (cash vs QR, with bank settlement delay if applicable)
• Flag any month where closing cash goes below a minimum buffer I set
• Write a 1-page plain-language summary with 3–5 recommendations

What I’ll provide

• POS sales exports for [__] months
• Fixed monthly costs list and planned one-off spending
• Current cash balance (rounded is fine, no bank logins)
• Supplier payment terms, if any

Deliverables

1. Excel workbook with these tabs:
   • Assumptions: every input in one place (sales drivers, cost %, fixed costs, opening cash, minimum buffer)
   • Budget: monthly income and expense forecast
   • Cash flow: monthly opening cash, cash in, cash out, closing cash
   • Scenarios: low / expected / high sales
2. A 1-page summary (PDF or Word)
3. A short handover note: how to change an input and read the results

Requirements

• Accounting student or graduate who understands budgeting and the difference between profit and cash
• Good Excel: formulas, scenarios, simple charts
• Ability to explain results to a non-accountant
• Every assumption written down

Rules

• Use formulas only. No hardcoded results, so I can change inputs and see new numbers.
• Mark estimated or missing figures clearly (some item costs in my POS are recorded as zero)
• One revision round included
• All files and work remain mine