Trusted by 25,000+ startup founders, investors and CPAs
Clear Assumptions Fast
Megan Carter, TX
I finally had pricing, costs, and growth in one place instead of scattered across tabs. It saved me a full afternoon of cleanup before I shared the model.
Scenario Planning Was Simple
Daniel Reed, FL
Switching between low, base, and high cases used to be a slog. This template made the comparisons clear enough that I booked a planning review the same day.
Runway Looked Easier To Track
Lauren Mitchell, CA
I could see runway and cash shortfalls without rebuilding the cash flow by hand. That clarity cut my forecasting time by hours and made the next funding check-in easier.
MODEL OVERVIEW
What's the financial model for the water filling station?
The editable five-year calculation plan forecast models daily visits, buyer conversions, recurring cohorts, product mix, prices, costs, scenarios and related financial statements.
Use the workbook to translate store movement, customer behavior, order frequency, unit of order, category mix and price into the organized functioning of forecast.
The editable assumptions are the source of monthly calculations, which are part of the annual results, comparisons of low/basic/high situation and are related to the financial statements model.
Built based on retail demandThe revenue engine starts with visitors and conversions and then runs repeat customer cohorts through orders, units, category and price mixtures.
WATER REFILL STATION REVENUE ENGINE
How is the water filling station dealing with Revenue?
The model converts shoppers into new buyers, builds active recurring cohorts, calculates orders and units, allocates units by category mix and applies category prices.
01
Change visitors
A new buyer is equal to a visitor to a store multiplied by a visitor's conversion rate to the buyer.
02
Build repeating cohorts
The division of recurring customers remains active for a specified life span of months.
03
Calculating orders
monthly orders combine first orders with the active frequency of the repeat customers order.
04
allocation of units
Orders become units sold and then the sales mix allocates units to individual product categories.
05
Calculate the Revenue
Category units awarded multiplied by the price of the category and the total retail sales of revenue.
CORE FORMULARevenue = Units sold × Average price of category
01 / REVENUE ASSUMPTIONS
How are the Revenue assumptions formed?
In the Revenue Assumptions view, weekly visits, conversions, repeat behaviour, order frequency, units per order, product mix, category prices and Revenue charts are organized.
Under COGS & Operating expenses, there is a separation between direct costs, variable costs and fixed operating categories during the forecast period.
COGS & OPERATIONAL EXPENSES
The cost of worksheet displays direct COGS, variable costs and fixed operating expenditure schedules.
03 / SCENARIO ANALYSIS
What's the equivalent of a scenario analysis?
In terms of scenario analysis, it compares the low, basic and high results for revenue, gross margins, contribution margins and EBITDA over the five years of forecast.
SCENARIO ANALYSIS
The analysis identifies low, basic and high paths for revenue and key earnings.
04 / DASHBOARD
What does Dashboard have to do with it?
The Dashboard system combines model setting, scenario management, key metrics, basic finance, a mixture of revenue, cash flow profitability and investment payback at a glance.
DASHBOARD
The dashboard displays configuration controls, scenario results, financial summaries and management charts together.
PRODUCT FIT
Is the financial model of the water filling station right for you?
The ready-made model corresponds to the retail economy run by visitors, but significantly different revenue mechanisms, operational structures or reporting requirements may require customized modelling.
READY-MADE MODEL
It fits perfectly
Sales start with shoppers and the visitor to buyer conversion rate.
You need cohort of repeat customers based on shares, lifespan and monthly order frequency.
You're selling multiple product categories using order units, a mix of sales and category prices.
You want a five-year forecast with monthly details, case analysis and related financial statements.
CUSTOM STRUCTURE
Think about the model
You need a much different revenue engine than visitor conversion and visitor ordering.
You need a separate location, route, channel, or economy of a business unit, independently modeled.
You need specialized operating schedules beyond the current retail assumptions and model cost structure.
You need a different reporting structure, financial logic, or entity-level presentation for the use case.
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 Models Lab can build or adapt the model when you need a different revenue logic, operational schedule, financing mechanisms or reporting structure.
You will receive a fully edited water station financial model as sheet for immediate download with five-year forecasts and related financial statements.
01
Editing the workbook
Changes in operational, pricing, costs, employment, capital, financing and controls of the model set out in the workbook.
02
5-Year Forecast
An overview of the monthly calculations that form part of the annual results over the five-year planning horizon.
03
Analysis of scenarios
A comparison of Low, Base, and High cases between revenue and key profitability measures.
04
Financial statements
Use the linked income statement, the cash flow report, the sheet balance, the dashboard and a summary of results.
BEFORE YOU BUY
Financial model of the water filling station FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the model calculate the revenue water filling station?
It converts visitors into new buyers, adds active orders from visiting customers, calculates units, allocates a category mixture, applies revenue category prices and amounts.
02
Which filling stations can I change?
You can edit the launch time, visitors per week, conversion, repeat order frequency, units per order, sales mix, category prices and seasonality.
03
What can I compare between low, basic and high scenarios?
The scenario analysis compares the alternative cases for revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
04
What financial results are taken into account?
The report workbook shall include the results report, the results report cash flow, the balance sheet sheet, Dashboard, the summary, scenario analysis, assessment, balance sheet, ROIC, charts, indicators, indicators and DuPont.
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, operational schedule, financing mechanics or reporting.
06
Is the workbook a forecast or a guarantee?
This is a forecast based on edited assumptions and not a guarantee of business results, profitability, funding or return.
What Does the Water Refill Station Financial Model Contain?
You receive a comprehensive financial modeling toolkit with everything needed to plan, fund, and manage your water refill station business.
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 & OPERATIONAL EXPENSES
SCENARIO ANALYSIS
DASHBOARD
