Revenue & Calc
Edit visits, items per guest, category shares, prices and seasonality; Calc produces monthly items sold and revenue.

The Sports Bar Financial Model is an Excel template for an independent, 100-seat U.S. sports bar with a wings-and-burgers kitchen and 12 televisions. It links guest demand, menu prices, expenses and staffing to five-year projections.
The 2026–2030 case assumes a leased 3,500-square-foot restaurant and January 31, 2026 launch. Figures are estimates, not trading results or guaranteed performance; sales tax and tips are excluded.
The workbook connects sports bar inputs to forecasts, financial statements and decision reports.
Edit visits, items per guest, category shares, prices and seasonality; Calc produces monthly items sold and revenue.
Plan ingredients, shrink, sales-linked expenses, fixed commitments and role-based payroll without double counting salaries.
Schedule opening assets, record equity and assess optional borrowing with Dashboard debt controls and repayment schedules.
Review projected Income Statement, Cash Flow, Balance Sheet and Summary reports, alongside reconciliation checks.
Compare scenarios, sales and cash break-even, payback, ROIC and valuation sensitivity without presuming specific returns.
Revenue is driven by paid guest visits, three menu items per guest, one normalized monthly sports pattern, and six distinct selling-price categories.
Monthly guest visits increase from 3,200 in 2026 to 4,500 in 2030. Three items per visit create one sold-item pool; the twelve monthly sports multipliers sum to twelve each year.
The 2026 mix allocates 35% to draft beer, 12% packaged beer, 18% cocktails/wine/spirits, 15% wings/starters, 15% burgers/entrées and 5% nonalcoholic drinks. Each allocated item earns its category net price.
3,200 monthly guest visits × 3 items × 12 normalized months × $9.825 weighted net price per item = $1,131,840 revenue.
The Revenue Forecast shows guest demand, item shares, prices and seasonality. Calc allocates sold items once into monthly revenue by category to test traffic and food-versus-drink mix.
The January 31, 2026 launch month is treated as fully active; months before launch have zero revenue. Annual assumptions match the forecast year.
The forecast distinguishes direct COGS, sales-linked expenses, monthly fixed obligations and salaries, with each expense charged only once.
The COGS and Operating Expenses forecast charges 13.5% beverage inputs and shrink, 14% food inputs and waste, and 1% consumables against revenue. It also includes 2.8% merchant fees, 1% promotions and recurring occupancy, utility, rights and insurance costs.
In 2026, COGS are $322,574, variable costs $43,010 and fixed costs $210,600. Rent and occupancy start at $8,500 monthly, even if demand weakens.
Payroll multiplies annual-average FTE by annual base salary, prorated for active months. Salaries are excluded from COGS and other expense groups; employer taxes, benefits and personal taxes are outside the documented example.
The Payroll Forecast tracks FTE, hiring dates and salaries by role. In 2026 the bar plans 1 manager, 3 cooks, 2.5 bartenders, 3 servers and 1.5 utility/runner FTE, generating $376,000 in base payroll.
Opening assets, preopening cash uses, working capital and equity funding are modeled separately from annual operating expenses.
Opening assets include $90,000 leasehold improvements, $60,000 kitchen equipment, $25,000 bar equipment and $25,000 televisions/audio, plus furniture and POS hardware. Deposits, permits, training, marketing and cleaning are separate preopening cash uses.
The Capital Expenditure Plan schedules equipment and buildout purchases with depreciation treatment. It separates investment timing from operating EBITDA, rather than treating durable restaurant assets as ingredient or operating costs.
Working-capital settings use zero receivable, seven payable and twelve inventory days. The $537,124 estimated owner contribution covers assets, preopening cash, opening working capital and three months of first-year cash operating outflows; outside borrowing is unconfirmed.
The Sources and Uses of Funds report compares equity or debt inflows with spending, financing payments and retained cash. The estimated owner contribution is a planning assumption, not proof of sufficient future liquidity.
These 2026–2030 figures show the projected annual operating revenue, expense burden and EBITDA from the selected sports bar assumptions.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $1,131,840 | $952,184 | $179,656 |
| 2027 | $1,311,487 | $1,016,528 | $294,959 |
| 2028 | $1,501,056 | $1,114,866 | $386,190 |
| 2029 | $1,642,654 | $1,182,605 | $460,048 |
| 2030 | $1,791,542 | $1,252,900 | $538,642 |
Illustrative projections, not actual trading results. Dollar amounts are rounded independently to whole dollars.
Revenue rises with estimated visits and annual prices, while ingredients, occupancy and staffing drive expenses. EBITDA increases from $179,656 in 2026 to $538,642 in 2030; neither amount represents distributable cash.
EBITDA here equals revenue minus COGS, variable operating costs, fixed costs and payroll. The Income Statement extends the analysis to depreciation, interest and taxes, but this selected example does not establish net-profit figures.
The Cash Flow Forecast separates operating, investing and financing flows, then reconciles opening to closing cash. Use it to assess startup outlays and funding requirements that EBITDA alone cannot establish.
The Returns reports distinguish covering operating expenses, reaching cash break-even, recovering investment and earning a return on invested capital.
Sales break-even tests operating-cost coverage, while cash break-even tests cash coverage timing. Payback tracks when cumulative project cash flows recover the investment, and annual ROIC relates return to invested capital.
The Returns report shows sales break-even, cash break-even, cumulative project free cash flow, investment payback and annual ROIC. Changes in demand, payroll and capital spending can affect these results; no specific recovery month or return is assumed.
Low, Base and High scenarios adjust revenue and cost groups. Dashboard financing controls cover four optional debt facilities, and Valuation provides DCF sensitivity; no borrowing approval or valuation output is claimed.
Use it to test an independent sports bar concept, lease budget and staffing plan.
Vary visits, food-versus-drink mix, prices and staffing to test earnings. The 100-seat layout is contextual, not a capacity limiter in the demand-based forecast.
Replace estimated assumptions with local rent, equipment quotes, wages, licenses and traffic estimates. Review statements, scenarios and model checks before committing capital.
Key details about the editable Excel assumptions, operating projections and investment reports.
It calculates monthly sales and costs and links them to financial statements and 2026–2030 annual operating projections.
No. Revenue uses guest visits, items per guest, seasonality and prices, without a seating-capacity cap.
Yes. Edit prices and five category shares; nonalcoholic drinks receive the residual share so item allocation remains 100%.
No. Base salaries are assigned to Payroll, separate from ingredients, variable expenses and fixed overhead.
No. It is an estimated owner-funding input, not a loan approval or liquidity guarantee.
No. EBITDA precedes depreciation, interest and taxes and does not measure capital expenditures, financing cash flows or ending cash.
Yes. Returns analyzes sales and cash break-even, payback and annual ROIC, without assuming specific results.
Yes. Low, Base and High controls change revenue and major cost assumptions.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
The pricing, cost, and growth tabs were finally organized in one place, so I could update the sports bar forecast without second-guessing every input. It cut my planning time by a few hours and made the assumptions easy to explain.
I used to chase statements and charts across different files, but this template keeps the P&L, cash flow, and visuals together. It saved me a full afternoon and made my lender review much easier.
I liked having the checks built in because one broken cell can throw off the whole model. It saved me from a bad forecast and gave me a cleaner version to share with my partner.