We Know How
Restaurant Consulting
Free Tool — Restaurant Finance
Know Your Numbers Before You Sign the Lease
A fully built financial model for new restaurant sites — three P&L scenarios, break-even analysis, and a 12-month cash flow projection. Enter your numbers, get your answers.
Free Download · Excel (.xlsx) · No formulas to build
What’s Inside
Three tabs. One complete picture of site viability.
Built for operators evaluating a new location — whether it’s your first unit or your tenth. Enter your assumptions in the Inputs tab and the model does the rest.
1
Inputs — Your Numbers Go Here
Square footage, build-out estimate (with high/low range by space type), revenue scenarios, growth rate, channel mix, and all cost assumptions. Blue cells only — everything else calculates automatically.
Build-Out Cost Working Capital Revenue Scenarios Channel Mix Labor % Rent + CAM Royalty Fees
2
Results — P&L, Break-Even & ROI
Full income statement across three scenarios side by side: Below Average, Average, and Above Average. Includes break-even revenue (annual, monthly, daily), NOI margin, payback period, and 5-year revenue projection.
Gross Profit NOI Margin Break-Even Cash-on-Cash ROI Payback Period 5-Year Revenue
3
Monthly Cash Flow — Year 1 Month by Month
Select a scenario and see a full 12-month breakdown of revenue, COGS, labor, and operating expenses — every line item, every month. Know what you need in the bank before you open the doors.
Monthly Revenue Monthly Labor Monthly COGS Monthly OPEX All 3 Scenarios
This Tool Is For You If…
- You’re evaluating a new site and need to run the numbers before committing
- You’re a franchisor building a standard model for prospective franchisees
- You’re opening your first restaurant and want to understand the real cost structure
- You want to pressure-test your revenue assumptions against industry benchmarks before you sit across from a landlord
“Most operators sign a lease before they’ve run a serious financial model. The numbers that feel ambitious at signing feel uncomfortable six months in. This tool exists to close that gap.”
Bill Holleman · Principal, We Know How Restaurant Consulting
Get the Proforma — Free
Enter your name and email. We’ll send you the download link immediately.
About the Author
Bill Holleman is Principal of We Know How, a restaurant consulting firm focused on operations, profitability, and training for emerging restaurant brands. His background includes leadership roles at Panera Bread, Potbelly, Jimmy John’s, and Roti Mediterranean.
weknowhow.pro · 224-433-0629
