Financial Model Report

3-Statement Model with Scenario Analysis | Restaurant Business
Generated: December 13, 2025 at 12:47 PM
Base Case Revenue (2028)
$2.77M
5Y CAGR: 4.2%
Base Case EBITDA (2028)
$438.2K
Margin: 15.8%
Base Case Net Income (2028)
$297.4K
Margin: 10.7%
5Y Total FCF (Base)
$1.35M
Cumulative
Ending Cash (2028)
$1.32M
Base Case
Base Case
Year 5 Revenue $2.77M
Year 5 EBITDA $438.2K
EBITDA Margin 15.8%
Year 5 Net Income $297.4K
Net Margin 10.7%
5Y Total Net Income $1.27M
5Y Total FCF $1.35M
Upside Case
Year 5 Revenue $3.47M
Year 5 EBITDA $698.9K
EBITDA Margin 20.1%
Year 5 Net Income $474.7K
Net Margin 13.7%
5Y Total Net Income $1.81M
5Y Total FCF $1.78M
Downside Case
Year 5 Revenue $2.40M
Year 5 EBITDA $253.5K
EBITDA Margin 10.6%
Year 5 Net Income $163.7K
Net Margin 6.8%
5Y Total Net Income $627.5K
5Y Total FCF $743.3K

Income Statement Projection - Base Case

Metric 2024 2025 2026 2027 2028
Revenue$2.35M$2.47M$2.58M$2.68M$2.77M
COGS$950.9K$986.1K$1.02M$1.04M$1.08M
Gross Profit$1.40M$1.48M$1.56M$1.63M$1.69M
Total OpEx$1.10M$1.13M$1.18M$1.21M$1.25M
EBITDA$301.3K$345.4K$377.3K$421.8K$438.2K
Net Income$198.3K$230.3K$253.8K$285.3K$297.4K
Gross Margin %59.5%60.0%60.5%61.0%61.0%
EBITDA Margin %12.8%14.0%14.6%15.7%15.8%
Net Margin %8.4%9.3%9.9%10.6%10.7%

Key Financial Ratios - Base Case (2028)

Gross Margin
61.0%
EBITDA Margin
15.8%
Net Margin
10.7%
Prime Cost %
66.0%
Current Ratio
32.86x
Quick Ratio
32.36x
Debt to Equity
0.03x
Interest Coverage
236.1x
ROE
20.7%

Key Assumptions - Base Case

Assumption 2024 2025 2026 2027 2028
Revenue Growth6.0%5.0%4.5%4.0%3.5%
Food Cost %31.5%31.0%31.0%30.5%30.5%
Labor Cost %28.0%27.5%27.5%27.0%27.0%
CapEx$25.0K$20.0K$15.0K$30.0K$15.0K