I'm putting together a business plan to seek a small business loan for my new coffee shop, and the bank has asked for a detailed three-year financial model. I have a basic grasp of the numbers—projected sales, cost of goods, rent, and wages—but I'm struggling to build a cohesive, professional-looking model from scratch in Excel. I've found some generic financial modeling templates online, but they don't seem tailored to a retail food service business with its specific inventory and labor variables. Does anyone have a recommendation for a template or framework that's worked well for a similar small brick-and-mortar startup?
There are a lot of free templates you can start with. A good first stop is SCORE’s Financial Projections Template and the SBA’s 3-year forecast package. For a cafe/coffee shop, build around your real drivers: monthly customers, average ticket, and days open. Create a monthly forecast for year 1, then quarterly for years 2–3. Include COGS by category (beverages, food, packaging), labor, rent, utilities, marketing, and a line for equipment depreciation. Don’t forget a debt service row if you plan to borrow, plus a simple capex schedule for new espresso machines or POS upgrades. Prepare three scenarios (best/base/worst) to show resilience.
Two ready-made options that fit retail food service are Vertex42’s Restaurant Financial Projection Template (Excel) and a general restaurant/model template you’ll find on other template sites; both handle inventory/spoilage and labor planning more cleanly than a generic business model. If you’re open to paid tools, LivePlan has a restaurant template too. The key is driver-based: forecast revenue from customers-per-day and average order value, then apply your COGS and labor as percentages of revenue.
Structure your model with a clean flow: Assumptions page; 12-month monthly P&L; 12-month cash flow; and a 36-month balance sheet plus a capex/debt schedule. Your main drivers should be: open days, average ticket, and customers per day; tie COGS to revenue, and set labor as a percentage of revenue (plus any fixed staff costs). Include seasonality and a break-even analysis so you can show when you’re covering fixed costs.
Use scenarios and a simple dashboard so a banker can see the story quickly. Build a 3-scenario (best/base/worst) forecast, and show the impact on key measures like GM, cash on hand, and debt-service coverage. A small sensitivity table (±10–20% in customers or price) helps illustrate risk. Also include a short executive summary and a clearly labeled 3-year schedule for the loan package.
Tips to keep it practical: start simple, then add complexity. Use a base case for the year ahead, a conservative case, and an optimistic case. Don’t overfit the model with too many assumptions. Make sure you align with bank requirements—some lenders want monthly cash flow for 12 months and annuals after that. If you want, share a rough outline of your numbers and I’ll sketch a starter skeleton you can reuse.
If you’d like, I can draft a basic skeleton 12-month P&L and a 3-year cash flow schedule with placeholder numbers you can plug in. Just tell me your expected average daily sales, days open per month, and your rough COGS and labor percentages, and I’ll tailor a template you can drop into Excel.