M
MISE — Premium Financial Model
5-Year Projection Dashboard · v3
[Insert Name] Template 5-Year
← Back to Home
Size
1,500
sq ft
Seat Count
50
interior seats
Weekly Covers
1,650
guests / 6 days open
Avg Guest Spend
$32.11
food + bev combined
Total Investment
$753K
all-in project cost
Location & Volume
Size of location1,500 sq ft
Seat count50 seats
Open days per week6 days
Guests per day275
Guests per week1,650
Avg ticket / order (2 guests)$64.22
Avg guests per order2
Annual revenue YoY growth3.0%
Sales discounts / comps5.0% of gross
Project Timeline
Start
Sep 2025
Kick-off
Buildout
6 months
Sep 25 – Mar 26
Training
1 month
Mar 26
Opening
Apr 2026
Yr 1 begins
1st calendar year startsJan 2026
Opening dateApr 1, 2026
Loan start dateJan 1, 2026
Loan starts X months before opening3 months
Capex reserve (annual)5% of buildout
Sources & Uses of Capital
Uses of Capital — $753K total
Buildout 53%
W.Cap 16.7%
Buildout $400K Equipment $65K FF&E $40K Working Cap $125.5K
Uses
Security deposit$22,500
Buildout & fixtures$400,000
Equipment & appliances$65,000
Furniture & fixtures$40,000
IT / technology$25,000
Inventory (initial)$5,000
Permitting & licenses$6,000
Signage$15,000
Menus$1,500
Pre-opening & training$7,500
Contingency$20,000
Opening marketing$20,000
Subtotal (pre working cap)$627,500
Working capital (20%)$125,500
Total investment needed$753,000
Sources
Equity (85%)$640,050
Debt financing (15%)$112,950
Tenant allowance$0
Total sources$753,000
Financing Terms
Loan amount$112,950
Interest rate15.0%
Term5 years
Monthly payment$2,687
Max cash need$700,000
Funding cushion+$53,000
Menu Build Summary
Day-Part Sales Split
Breakfast
20%
55 guests/day
30%
Lunch
82.5 guests/day
Dinner
40%
110 guests/day
Per-Unit Economics
$/sq ft (project)
$502
$/seat (project)
$15,060
Revenue/sq ft Yr1
$1,451
Revenue/seat Yr1
$43,533
Avg weekly sales
$52,982
Avg annual sales
$2.76M
5-Year IRR
34.6%
vs 10% avg benchmark
Cash-on-Cash
2.59×
vs 1.1× avg benchmark
Payback Period
38 mo
vs 48 mo avg benchmark
Yr 1 EBITDA Margin
8.1%
Yr 3: 15.2%
Annual Revenue vs EBITDA ($K)
RevenueEBITDA
Monthly Sales — First 24 Months ($K)
Cumulative Cash Flow ($K)
Breakeven
Yr 4
5-Yr Total
$567K
Project Cost
$753K
Sales by Day-Part — Yr 1
Dinner54.8%
Lunch31.3%
Breakfast13.9%
Total Yr 1 guests60,216
Avg spend / guest$33.71
Cost Stack by Year ($K)
COGSLaborCtrlNon-CtrlOccEBITDA
Margin % of Net Sales
COGS%Labor%EBITDA%
Full P&L Summary ($K)
MetricYear 1Year 2Year 3Year 4Year 5
Gross Sales$2,177K$2,925K$3,014K$3,105K$3,200K
COGS$669K$875K$901K$929K$957K
Labor$667K$782K$805K$828K$852K
Prime Costs$1,337K$1,657K$1,706K$1,757K$1,809K
Controllable$291K$391K$403K$415K$428K
Non-Ctrl$106K$108K$111K$113K$115K
Occupancy$131K$160K$165K$170K$175K
EBITDA 4-Wall$165K$411K$426K$441K$457K
EBITDA Margin8.1%15.1%15.2%15.2%15.3%
Net Cash Flow by Year ($K)
Cumulative Cash Position ($K)
Monthly Sales — First 24 Months ($K)
Yr 1 Total
$2.18M
Yr 2 Total
$2.93M
Peak Month
~$267K
Opening Month
~$119K
By Day-Part
Dinner54.8%
Lunch31.3%
Breakfast13.9%
By Order Mode
Dine-In50.6%
Takeout15.9%
Delivery13.9%
3rd Party15.2%
Food vs Beverage
Food79.7%
Beverage20.3%
Food revenue$1,735K
Bev revenue$442K
Revenue Summary by Year
MetricYr 1Yr 2Yr 3Yr 4Yr 5
Total Guests60,21680,90683,36785,90388,515
Avg Guest Spend$33.71$33.71$33.71$33.71$33.71
Food Revenue$1,735K$2,331K$2,402K$2,475K$2,551K
Bev Revenue$442K$593K$611K$630K$649K
Total Sales$2,177K$2,925K$3,014K$3,105K$3,200K
Breakfast Guests13,38117,97918,52619,08919,670
Lunch Guests20,07226,96927,78928,63429,505
Dinner Guests26,76235,95837,05238,17939,340
Investor Metrics
Operational Metrics
Full Benchmark Comparison
MetricThis ModelIndustry AvgStrong BenchmarkStatus