Kiln
Year 1 P&L — Editable Model — Rochester Market
Edit any input on the left
All formulas recalculate instantly
Every cost line included
Assumptions — Edit Here
Revenue Drivers
Avg dine-in covers/day
Avg dine-in check ($)
$
Bar % of dine-in revenue
%
Takeout orders/day
Avg takeout check ($)
$
Operating days/year
Cost of Goods
Food COGS %
%
Bar COGS %
%
Takeout COGS %
%
Packaging / year ($)
$
Labor — Key Salaries & Wages
Owner salary ($)
$
Exec Chef salary ($)
$
Payroll burden %
%
BOH hourly labor / yr ($)
$
FOH hourly labor / yr ($)
$
Counter labor / yr ($)
$
Pre-opening payroll ($)
$
Sick leave accrual ($)
$
Occupancy
Annual rent + NNN ($)
$
Gas + Electric / yr ($)
$
Water + Sewer / yr ($)
$
Trash + Snow + Pest ($)
$
Technology & Processing
Credit card processing %
%
POS + tech / yr ($)
$
Fixed Annual Costs
CPA + Legal ($)
$
Insurance (all) ($)
$
Kitchen compliance ($)
$
Facility & service ($)
$
Marketing ($)
$
Contingency ($)
$
Debt Service
SBA loan amount ($)
$
Interest rate %
%
Loan term (years)
Revenue 62 covers × $55 avg × 365 days
Dine-In Food
$0
—
Dine-In Bar
$0
—
Takeout Counter
$0
—
Total Revenue
$0
—
Cost of Goods Sold—
Food COGSFood revenue × food COGS %——
Bar COGSBar revenue × bar COGS %——
Takeout COGSTakeout revenue × takeout COGS %——
Packaging & ContainersBags, boxes, branded materials——
Total COGS——
Gross Profit——
Labor (all wages + payroll burden)—
Owner Salary + BurdenYour compensation as operator——
Executive Chef + BurdenWorking kitchen lead——
BOH Hourly Team + BurdenLine cooks, prep, dishwashers——
FOH Tipped & Service + BurdenServers, bartenders, host, runner——
Counter Staff + BurdenCounter lead + 2 staff——
Pre-Opening PayrollTraining period — zero revenue——
MI Earned Sick Time AccrualRequired by Michigan law——
Total Labor——
Occupancy—
Rent + NNNRochester — 2,400 sf——
Gas + ElectricCommercial kitchen, smoker, HVAC——
Water + SewerHigh-volume kitchen usage——
Trash + Snow Removal + Pest ControlMichigan winters are real——
Total Occupancy——
Technology & Payment Processing—
Credit Card Processing% of total revenue — unavoidable——
POS + Reservations + TechToast, Resy, ordering, internet——
Total Technology——
Professional Services, Insurance & Operations—
CPA + LegalMonthly bookkeeping + year-end + counsel——
Insurance (GL + Liquor + BOP)All three policies required——
Kitchen ComplianceHood cleaning, grease trap, equipment maint.——
Facility & ServiceLinen, smallwares, cleaning, music licensing——
Marketing & BrandSocial, photography, opening event, ads——
Contingency ReserveEmergency repairs + unexpected costs——
Total Professional / Operations——
Debt Service—
SBA 7(a) — Principal + Interest———
Total Debt Service——
Owner Year 1 Financial Picture
Total Revenue—
Total COGS—
Total Labor—
Total Overhead—
SBA Debt Service—
Net Operating Profit/Loss—
+ Owner Salary (in labor above)—
Total Owner Compensation
—
Key Financial Metrics
Gross Margin (after COGS)—
Prime Cost (COGS + Labor % of rev)—
Labor % of Revenue—
Occupancy % of Revenue—
Net Margin (after all costs)—
EBITDA (before debt service)—
Break-even covers/day (w/ takeout)—
Monthly SBA payment—
Total Revenue
—
Net Profit
—
Owner Comp
—
Prime Cost
—
Net Margin
—