Trusted by 25,000+ startup founders, investors and CPAs
Formula Anxiety Gone
Megan Carter, TX
I was worried one broken cell would throw everything off, but this template kept the math organized and easy to trace. I saved hours checking formulas and could move ahead without second-guessing every input.
Clear Investor Expectations
Brian Ellis, NY
I couldn’t tell what investors wanted before, but the structure here made it obvious. The summary tabs and projections gave me a cleaner story, and I booked a follow-up meeting with my advisor after sharing it.
No Advanced Excel Needed
Sarah Nguyen, CA
I’m not strong in Excel, so this was a relief. The layout was easy to follow, and I finished a usable five-year plan in an afternoon instead of handing it off to someone else.
MODEL OVERVIEW
What is the online financial model of plants?
This edited five-year model of Excel and Google Sheets connects the clients of acquisition, follow-up orders, product mix, prices, costs, scenarios and financial statements.
Use the workbook to plan how marketing-based customer growth and repeat purchases translate into business orders, product units, revenue, costs and financial results.
The start-up time, channel budgets, acquisition customer costs, repeat customer behaviour, unit per order, sales mix and category price can be changed; the related calculations update the model results.
Built to plan the editedStart with the planned structure, replace the assumptions with your own, and compare operational and financial results.
ONLINE PLANT NURSERY ECOMMERCE REVENUE
How is revenue calculated in an online business?
The model converts channel marketing expenditure into new customers, consists of active repeat buyers, calculates orders and units, and then the price of the plant mix allocated.
01
Get customers
The cost of online and offline marketing divided by each CAC channel creates new customers.
02
Build a repeating base
Some new customers often become active buyers over a given lifetime.
03
Calculating orders
The first orders of a new customer are combined with the active repeat customers multiplied by the frequency of repeating the order.
04
allocation of units
The total number of orders is converted into units per order and then the sales mix allocates units in individual categories.
05
Calculate the Revenue
The awarded category units multiplied by category prices generate total e-commerce revenue.
CORE FORMULARevenue = Units sold × price weighted by sales mix
01 / REVENUE
Which Revenue assumptions can you edit?
Revenue sheet connects the channel and CAC budgets with new customers, recurring behaviour, orders, plant product units, sales mix and category prices.
REVENUE
The Revenue view displays information on marketing, frequent customer, units, sales mixtures, prices and seasonality.
02 / COGS & OPEX
How are operating expenses organised?
COGS & OPEX sheet separates the assumptions regarding the cost of goods from the variable and fixed operating expenses throughout forecast.
COGS & OPEX
The COGS & OPEX view separates direct costs, variable costs, fixed costs and monthly calculations.
03 / SCENARIOS
What do you compare to in Low, Base, and High cases?
In view of the scenarios, it compares the low, basic and high results for revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
SCENARIOS
The scenarios shall show the low, basic and high revenue ceilings and the margin results over five years.
04 / DASHBOARD
What does Dashboard have to do with it?
The Dashboard combines model setting, scenario control, key metrics, basic finance, a mix of revenue, profitability, cash flow and investment payback views.
DASHBOARD
Dashboard consolidates the configuration controls, the results of selected cases, financial trends, cash flow and investment metrics.
PRODUCT FIT
Is the online plant finance model right for you?
The template matches the customer's online plant plans using this acquisition, repeating buyer, unit mix and pricing logic; structural outputs may require individual modelling.
READY-MADE MODEL
It fits perfectly
You're acquiring new customers through online and offline marketing channels with channel-specific CAC.
You expect some of your new customers to become repeat buyers over a lifetime.
forecast orders, units to be ordered, sales mix of categories and prices for the forecast year.
You want related cost schedules, scenarios, financial statements, and management reports around that logic.
CUSTOM STRUCTURE
Think about the model
Your revenue depends on wholesale contracts, market commissions, memberships or another significantly different mechanic.
Your customer groups require a different retention, subscription, contract, or channel logic than the delivery structure.
Your activities require the ability to grow plants, organically produce, produce greenhouses, or implement a timetable beyond this setting.
Your report requires substantially different statements, timetables or decision outcomes from the workbook structure.
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?
Financial Models Lab can build or customize the model when you need different revenue logic, operating schedules or financial reporting.
After you purchase, you will receive a fully edited five-year financial model for Excel and Google Sheets as an instant download.
01
Editing the workbook
Change the model assumptions and use the related calculations for your own planning case.
02
5-year forecast
Work with five-year projections and monthly financial forecasts during the planning period.
03
Analysis of scenarios
Compare Low, Base, and High cases using the workbook scenario analysis view.
04
Financial statements
A review of income statement, cash flow, the balance of sheet, the summary, Dashboard and other analysis reports.
BEFORE YOU BUY
Online financial model of the FAQ plant nursery
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the online nurse model calculate revenue?
It transforms channel marketing and CAC spending into new customers, adds active repeat purchaser orders, calculates units, allocates sales mix and applies category prices.
02
Which assumptions can I change?
You can change the launch date, channel marketing budgets and seasonality, CAC, repeat customer behavior, order units, sales mix and category price.
03
What can I compare between low, basic and high scenarios?
In the scenario view, it compares the paths of low, basic and high revenue, gross margin, contribution margin and EBITDA under forecast.
04
What financial results are taken into account?
The workbook contains the income statement, the cash flow, the sheet balance, the Dashboard, the summary and the additional analytical reports presented in the review.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. Financial Models Lab offers personalised financial modelling where your revenue logic, operating schedules or reporting requirements require a different structure.
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 Online Plant Nursery Financial Model Contain?
You receive a downloadable financial model for a virtual plant store, complete with pre-built financial statements, a dynamic dashboard, and detailed sections for all your assumptions.
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
COGS & OPEX
SCENARIOS
DASHBOARD
