Oxygen Bar Financial Projections Template in Excel
One editable Excel file, with the forecasts, charts, and key outputs already built. Type your assumptions into the inputs tab, and the rest is laid out for planning and investor review.
Trusted by 25,000+ startup founders, investors and CPAs
Scenario Planning Made Simple
Megan Carter, NY
I stopped juggling low, base, and high cases in separate sheets and built all three in one place. That cut my scenario prep from hours to under an hour.
Reporting Stays In One File
Daniel Brooks, TX
All the statements and charts were finally together instead of scattered across different workbooks. I put my monthly reporting together in one sitting and sent it out the same day.
Investor Questions Answered Clearly
Priya Shah, CA
I wasn’t sure what outputs investors expected, but this template showed the right structure right away. It helped me get a meeting booked faster because my numbers and tabs were already organized.
MODEL OVERVIEW
What Is the Financial Model Oxygen Bar?
This editable Excel workbook provides an oxygen bar for five years, using daily visits, a combination of services, prices, seasonality and related financial statements.
The size of scheduled services, category prices, operating costs, staff, capital needs, scenarios and financial results from one combined workbook.
Any assumptions shall provide a monthly calculation engine which incorporates operational activities into statements, scenarios and management reporting.
Built around service visitsThe revenue settings use one common visit pool and then allocate it according to a service combination before each category is valued.
REVENUE ENGINE BAR OXYGEN
How Does the Financial Model Oxygen Bar Calculate Revenue?
The model provides for a common visit pool, applies seasonality and combination of services, prices of each category, adds once extra for the business card and the sum of revenue.
01
Expected Visits
It determines the average number of visits per day, working periods, start time and seasonality to determine the volume of services.
02
Mixing
Split the pool of visits into categories of sessions using a mix with the possibility of editing.
03
Apply Prices
Visits were repeatedly allocated to each category of services at its appropriate price.
04
Add Extras
Apply the included additional revenue for one visit without duplication of the common pool of service units.
05
Calculate Income
It shall add category income and additional revenue in each forecast period to the calculation of the total revenue.
FORM OF CORRECTIONRevenue = units of services × mix of services × price of services + additional revenue
01 / REVENUE RESULTS
What Influences Can You Edit?
View The revenue assumption allows you to set the time of start, daily visits, working days, monthly seasonality, a combination of services, service prices and additional revenue for the visit.
GROUNDS FOR THE REVENUE
The sheet shows operational assumptions, session prices, service combination, seasonality and annual number of visits.
02 / COGS & OPEX
How to Structure Operational Costs?
The COGS & OPEX worksheet separates direct costs, variable costs and fixed operating costs, thus providing cost assumptions to profitability and cash planning.
COGS & OPEX
The cost sheet divides the assumptions for direct, variable and fixed operating costs by forecast period.
03 / SCENARIOS
What Can You Compare in Scenarios?
The Scenarios compared low, base and high incomes, gross margin, premium premium and EBITDA in the five-year forecast.
SCENARIOS
For key performance measures, graphs are presented for the ‘Low, Basic and High’ scenario.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The board contains a set of models, scenario control, basic finances, income set, profitability, cash flow and return on investment in one management view.
DASHBOARD
The navigation desk combines configuration controls, scenario results, financial summaries, cash flow, profitability and return charts.
FIT OF PRODUCTS
Is the Financial Model Oxygen Bar Suitable for You?
The formula matches the companies using the common service pool broken down by category and price; significant income differences or reporting structures may require non-standard modelling.
MODEL BY MADA READY
Good Example
You're planning a common pool of daily visits to the oxygen bar during the operating period.
You assign visits to different categories of services with the possibility of editing percentages of the mix.
Price of each category of services and add additional revenue for the business card once.
You want the associated costs, scenarios, statements and navigational desk to report in one workbook.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your income requires membership, cohorts, reservations, capabilities or contracts outside joint service visits.
You need separate revenue streams with different unit pools instead of one common service unit pool.
You need operational schedules that are significantly different from the included revenues, costs, wages or structure of CAPEX.
You need reporting logic or calculations outside the financial and administrative results manuals attached to this.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
Lab financial models can build or customize a model when you need a different revenue logic, operating schedules or reporting from a ready-made template.
You will receive a fully edited financial model Excel in the form of instant download, with a five-year forecast, analysis of scenarios, extracts, charts and management results.
01
Editable workbook
Change the operational and financial assumptions in Excel downloadable model.
02
Five-year forecast
Planning over five years with monthly and annual financial details.
03
Analysis of scenarios
Compare low, basic and high levels of key performance measures.
04
Financial statements
Review of related income, cash flow, balance sheet, distribution panel and related reports.
BEFORE BUYING IMPORTANT INFORMATION
Oxygen Bar Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the revenues from oxygen bars?
It provides for a common visit pool, applies seasonality and a combination of services, multiplys the number of visits allocated by price category, adds additional revenue once and the sum of each period.
02
What are the assumptions I can change?
You can change the start date, day visits, working periods, monthly seasonality, combination of services, category prices and allow additional revenue for the visit.
03
What can I compare in Low, Base and High scenarios?
The three cases may be compared with the change in revenue, gross margin, premium premium margin and EBITDA in the five-year forecast.
04
What financial results are taken into account?
The product presents a statement of revenue, a statement of cash flow, a balance sheet, a balance sheet, a summary, an analysis of scenarios, graphs and additional financial statements.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers custom financial modelling when you need different revenue logic, operating schedules, or reporting.
06
Is this a forecast or a guarantee?
This is a planned forecast, not a guarantee of the performance of business, profitability, financing or return.
What Does the Oxygen Bar Financial Model Contain?
This downloadable oxygen bar financial model gives you immediate access to all the tools you need to build a comprehensive financial forecast and business viability study.
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.
GROUNDS FOR THE REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
