Restaurant Financial Toolkit

Eight sheets, one file

Start Here — instructions, color legend, preset dropdown (Restaurant / Bar / Cafe / Food Truck)
Dashboard — food, beverage, labor and prime cost %, occupancy cost %, EBITDA %, sales and covers per day vs break-even, average check, hourly staff turnover vs 2025 industry data, Year 1 net margin; plus an actual-month block using the inventory method
Inputs — 76 light-blue assumptions in 11 blocks, with three preset libraries and a "Your value" column that overrides them
Monthly P&L — 12 months: sales by category, COGS, labor, prime cost, occupancy, operating expenses (including a staff turnover cost line: headcount × turnover rate × cost per departure), G&A, EBITDA
Menu Pricing — 20 items: recipe cost to suggested price at your target cost %, contribution margin, menu mix
Break-Even — per month, per day, in covers, per seat, per service, including loan payments; margin of safety
3-Year Projection — annual P&L, loan schedule, DSCR, simplified cash flow, sources & uses, printable on one page
Assumptions & Sources — every benchmark with publisher, title, year and link

A one-minute tour

51 seconds, no sound. Real screenshots of the fictional Restaurant preset.

Every sheet, before you buy

Restaurant Financial Toolkit — Dashboard sheet — **Dashboard**Food, beverage, labor and prime cost vs sourced benchmarks; covers per day vs break-even; Year 1 net margin.

Restaurant Financial Toolkit — Monthly P&L sheet — **Monthly P&L**12 months: sales by category, COGS, labor, prime cost, occupancy, operating expenses (incl. staff turnover), EBITDA.

Restaurant Financial Toolkit — Break-Even sheet — **Break-Even**Per month, per day, in covers, per seat, per service — loan payments included — and margin of safety.

Restaurant Financial Toolkit — Menu Pricing sheet — **Menu Pricing**20 items: recipe cost → suggested price at your target cost %, contribution margin, menu mix.

Restaurant Financial Toolkit — 3-Year Projection sheet — **3-Year Projection**Annual P&L, loan schedule, DSCR, simplified cash flow, sources & uses — prints on one page for a lender.

Restaurant Financial Toolkit — Inputs sheet — **Inputs**76 light-blue assumptions in 11 blocks, three presets (restaurant / bar / cafe–food truck) and a 'Your value' column.

Restaurant Financial Toolkit — Assumptions & Sources sheet — **Assumptions & Sources**Every benchmark with publisher, title, year and link. Where no reliable source exists, it says so.

Restaurant Financial Toolkit — Start Here sheet — **Start Here**Instructions, color legend, preset dropdown, seven steps to a bank-ready file.

Three presets to start in ten minutes

Fictional but realistic: an 80-seat restaurant (140 covers a day, $55 average check), a 60-seat bar (150 covers, $32.50) and a 30-seat cafe or food truck (200 covers, $13). Replace the inputs with your own numbers block by block.

Why the numbers can be trusted

Every benchmark is sourced: food cost 28–35% (MarginEdge, 2026), beverage cost 18–24% (Backbar Academy, 2019), labor 34.2–36.5% (National Restaurant Association, 2025), prime cost 60–65% (Restaurant365), hourly turnover ~92% full service and ~110% limited service (Black Box Intelligence, 2025). Where no reliable source exists, the sheet says "No benchmark".
Every calculated cell is a formula. Automated tests check for zero errors on all presets and that the control results match within 0.5%.
Excel 2016+ and Google Sheets. No macros, no subscription.

What it is not

A planning model, not accounting software or tax advice. It does not connect to your POS. Seat turns per service are shown as reference only, and the food truck preset shares the cafe benchmarks.

Guarantee and support

Full refund within 14 days if the file does not work as described. Email support: outilfinance@gmail.com.

Before you buy any restaurant spreadsheet

1.Can you see every sheet before you pay?

Screenshots of every sheet on this site, a 3-page sample PDF with no email asked, and a free calculator built by the same code as the paid files.

2.Where do the benchmarks come from?

Each range names its publisher, title, year and link. Where no reliable source exists, the file shows no benchmark instead of a guess. See the full list.

3.Can you audit the math?

Every result is a visible formula. No macros, no locked sheets, no hidden cells you cannot open.

4.Has anyone checked the formulas?

An automated test suite rebuilds the files and checks them for errors and against control numbers before each release. What the tests check.

5.Will you pay every month?

No. One payment, the file is yours, it works offline in Excel or in Google Sheets.

6.What if it does not fit your concept?

Full refund within 14 days, and email support from the person who built it.

Who builds this

Elliot Pelletier · PrimeCost Lab · Québec, CanadaFinance student with hands-on experience in SMB financing analysis. I build the models I would want on the other side of a loan file: every benchmark sourced, every formula tested, and a free version that is actually useful. Not sure which file fits? Email me before you buy: outilfinance@gmail.com.