Five-year projections, dashboard, P&L, cash flow, balance sheet, and three scenarios - pre-built in Excel and Google Sheets. Built for tea room planning. Delivered as an instant download.
Trusted by 25,000+ startup founders, investors and CPAs
Runway Became Easy To Track
Megan Carter, NY
The cash flow tab made runway and shortfalls much clearer, so I could plan funding timing without guessing. It saved me hours of manual updates each week.
Margins Were Easy To See
Daniel Brooks, CA
I finally had a clean view of margins and break-even, which made pricing decisions much simpler. It also helped me prep a lender call with numbers I could explain quickly.
Simple Enough To Use Fast
Priya Shah, TX
I’m not strong in Excel, so the step-by-step structure made the model easy to fill in. I had the first draft done in under an hour instead of getting stuck on formulas.
MODEL OVERVIEW
What's the financial model?
The Tea Room financial model is an edited five-year Excel forecast built around weekday covers, average checks, monthly seasonality and related financial results.
Use the workbook to plan how weekday orders, midweek and weekend spending, the revenue mix, costs, staff and funding translate into forecast's five-year activity.
The editable inputs flow through monthly calculations to the revenue, expenditure, financial statements, scenarios and management reports.
Built for planningChange the assumptions in the tea room to reflect your operational plan and analyze the response to the associated results.
TEA ROOM REVENUE ENGINE
How is Revenue calculated in the tea room?
Revenue starts with weekday covers or orders, uses an operational calendar and monthly seasonality, and then uses midweek or weekend checks and a mix of categories.
01
Weekday covers
Set average covers or orders for every day of the week.
02
Operational calendar
Convert the daily pattern by working days, weeks, opening and closing dates.
03
Seasonality
Monthly seasonality should be used to adjust the coverage during the operational year.
04
Check and mix
Application of midweek or weekend averages and then allocation of sales in terms of revenue.
05
Total Revenue
Amounts of sales of the monthly category, including any ancillary sales modelled separately.
CORE FORMULARevenue = Covers × Average check
01 / REVENUE ASSUMPTIONS
Which shipments drive the salon to Revenue tea?
The Revenue sheet tabs show the opening time, the weekday covers, the monthly seasonality, the average check and the mix of categories that drive the forecast tea room.
REVENUE ASSUMPTIONS
This view shows weekday covers, monthly seasonality, average check and product category mix.
02 / COGS & OPEX
How are operating expenses organised?
COGS and OPEX sheet separate direct costs, Variable Costs and Fixed operating expenses so that each cost driver can pay for forecast.
COGS & OPEX
This view displays direct costs, variable costs and fixed monthly operating expenses.
03 / SCENARIOS
How can you compare Low, Base, and High cases?
sheet scenarios compare Low, Base, and High cases with respect to revenue, gross margin, contribution margin and EBITDA with respect to forecast.
SCENARIOS
This view compares five-year paths of low, basic and high performance in key metrics.
04 / DASHBOARD
What does Dashboard have to do with it?
The Dashboard combines scenario control management, basic finance, a mixture of revenue, profitability, cash flow and investment payback in one view.
DASHBOARD
This dashboard combines scenario controls, five-year financial statements, cash flow and investment visualizations.
PRODUCT FIT
Is this financial model right for you?
the finished model is matched to tea rooms using common covers or orders and average check; different revenue architectures or reporting needs may require individual modelling.
READY-MADE MODEL
It fits perfectly
You're planning revenue with weekday covers or customer orders and average expenses.
You need interviews in the middle of the week and on weekends with monthly seasonality.
You want an edited mixture of revenue, operating expenses, salary and capital commitments.
You want to combine Low, Base, and High cases with financial statements and dashboards.
CUSTOM STRUCTURE
Think about the model
You need separate customer channels or revenue engines that don't share the same order base.
You need capabilities, subscriptions, franchises, or other operational logic outside the revenue mechanic provided.
You need specialized schedules or calculations that significantly alter the structure of the workbook.
You need a reporting system or a decision-making framework based on customized requirements.
The indicator is the starting point for planning, not a guarantee of performance.
CUSTOM FINANCIAL MODELING SERVICE
Do you need a pattern that meets your requirements?
The Financial Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from the finished structure.
When you're done with the money, you'll get an edited Tea Room Financial Model as an instant download for Excel or Google Sheets, with five-year projections and scenarios.
01
Editing the workbook
Use a pre-built Excel model and replace editable assumptions with your own plan.
02
five-year forecast
Review of projected revenue, expenditure, cash flow and other related performance over five years.
03
Analysis of scenarios
Compare Low, Base, and High cases without reconstructing the separate forecast files.
04
Financial statements
Use the combined sources of P&L, cash flow, sheet, dashboard and supporting reports.
BEFORE YOU BUY
Financial model of the Tea Room FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model calculate Tea Room revenue?
It predicts weekday covers or orders, uses an operational calendar and monthly seasonality, then uses mid-week or weekend checks and allocates sales by category.
02
Which assumptions can I change?
You can change the opening date, the weekday covers or orders, the operating calendar, the monthly seasonality, midweek and weekend checks, the revenue mix and additional sales assumptions.
03
What can I compare between low, basic and high scenarios?
In view of the scenarios, it compares Low, Base, and High cases under revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
04
What financial results are taken into account?
The workbook shall include the dashboard, P&L, cash flow, sheet balance, summary, failure, valuation, ratio, ROIC, charts and report from KPI.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab can build or customize the model when you need a different revenue logic, operating schedule or reporting.
06
Is this a forecast workbook or a warranty?
This is forecast planning based on edited assumptions, not a guarantee of business results or financial results.
What Does the Tea Room Financial Model Contain?
This comprehensive restaurant financial model template includes everything you need to plan, forecast, and manage your tea room's finances in one place.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
REVENUE ASSUMPTIONS
COGS & OPEX
SCENARIOS
DASHBOARD
