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