Restaurant Pro Forma Template

Start with the Assumptions sheet. Enter your seating capacity, turns per day, and average check size — these three inputs drive most of the revenue model. If you're opening a new restaurant, set a realistic ramp schedule: most new restaurants operate at 40–60% of their target cover count for the first three to six months as they build the customer base and work out operational issues. Getting these assumptions right before looking at any outputs takes about 30 minutes and is the most important work you'll do with this template.

Once assumptions are in, review the Revenue Projections and Operating Expenses sheets to make sure the categories match your concept. A fast-casual counter-service operation has a fundamentally different cost structure than a full-service restaurant — toggle off revenue lines that don't apply and adjust the labor ratios to reflect how your specific concept is staffed. Use the Startup Costs sheet to compile your buildout and equipment estimates as bids come in; the total investment figure there feeds the break-even math automatically.

Use the 5-Year P&L Summary and Break-Even Analysis sheets when presenting to lenders or investors. The P&L shows the full financial trajectory — when you hit profitability, what EBITDA looks like at maturity, and how margins build over time. The break-even sheet answers the question every lender asks: how many covers do you need per day to cover your costs? Run the break-even under a few different average check assumptions before your SBA meeting or investor pitch — it shows you've stress-tested the model and know where the floor is.

A restaurant pro forma serves two different audiences, and getting it right matters for both. For lenders — especially SBA 7(a) lenders — the pro forma is a required document that shows you understand your unit economics. They want to see realistic food cost and labor percentages, a plausible ramp schedule, and a clear path to debt service coverage. For investors or equity partners, the pro forma needs to show the upside: what the concept looks like at maturity, what the return on invested capital is, and how long the payback period is. A spreadsheet that's too optimistic loses credibility with both audiences.

The three numbers that define restaurant financial health are food cost percentage (28–35% of food revenue for most concepts), total labor cost percentage (30–35% of total revenue including management and benefits), and occupancy cost percentage (ideally under 10% of revenue, though this is difficult in high-rent urban markets). A restaurant that controls all three can operate at 10–20% EBITDA margins even in a competitive market. A restaurant where food cost runs at 38% and labor runs at 38% is structurally unprofitable regardless of how good the food is — and a pro forma built before opening is the time to discover that, not six months in.

The ramp-up period is where most restaurant pro formas go wrong. New restaurant openings typically run at 50–70% of their projected revenue in months one through six, then ramp to 80–90% in months seven through twelve as word-of-mouth builds, the team becomes efficient, and the menu is dialed in. Modeling full revenue from day one is the most common mistake in restaurant feasibility analysis, and it's the reason so many restaurants run out of working capital in the first year. This template's ramp schedule forces you to model the lean months explicitly, which makes your working capital requirement realistic and your lender presentation credible.