Florist Model
Ecommerce Financial Model (Free Excel Download)
Plan florist operations using event orders, everyday sales, average ticket, seasonal demand, product waste, delivery costs, labor, inventory, and cash flow.
professionals from Deloitte
Used by professionals from
About this model
This model helps you plan a florist serving everyday customers, weddings, events, and corporate accounts. It brings bouquet sales, delivery, subscriptions, and event work together with flower purchases, staff, waste, rent, and marketing costs.
Use it to assess a new shop, wedding-focused business, or seasonal growth plan. Test order volume, average spend, product mix, and delivery capacity to see how they affect cash flow and profit.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Florist Model
- Volume inputs: weekly walk-in transaction run-rate and its growth, holiday volume multiplier and its growth, holiday and non-holiday weeks per year
- Pricing: base and holiday ticket price and escalation, holiday ticket premium
- Wholesale cost: base, holiday, wedding and corporate cost-of-goods-sold rates
- Weddings and corporate accounts: bookings and growth, average contract value, deposit rate, Q4 next-year-delivery share, opening accounts and net adds
- Cost structure: spoilage rates by channel mix, florist wage and productivity, delivery cost, occupancy, marketing, G&A; depreciation; tax
- Capital and working capital: equipment-refresh capex rate and life, van unit cost and life, net-working-capital percent of revenue growth, base-year working capital
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Operations sheet: base and holiday volume build, wedding and corporate build, weighted staffing, delivery fleet sizing, working capital, capex and depreciation
Florist Financial Model: How the Template Captures Holiday Peaks and Perishable Waste
This florist financial model projects seven years of operations and an unlevered discounted cash flow for a single-location retail florist with an attached wedding and event studio. It links four revenue channels to a shared perishable supply chain, revealing how holiday demand spikes compress margins and how channel mix determines spoilage costs.
How the four sales channels drive volume and pricing
The model builds revenue from four distinct channels: everyday walk-in retail, three flagship gifting holidays, wedding and event contracts, and standing corporate accounts.
- Everyday retail volume starts with a weekly transaction run-rate applied across 49 non-holiday weeks, while holiday volume multiplies that same run-rate by a holiday volume factor and applies it to three holiday weeks.
- Wedding bookings and corporate accounts are projected separately, with their own growth rates and average contract or fee values.
- Each channel carries its own escalating price, so total revenue reflects both volume growth and price increases.
Holiday weeks: high revenue, lower margin
Flagship holidays generate the highest revenue per week but also carry a wholesale-cost premium.
- The model prices holiday revenue using a holiday volume multiplier that grows faster than everyday traffic, and it applies a higher wholesale-cost rate to holiday sales than to base retail.
- Because this high-cost holiday volume grows as a share of total revenue, blended gross margin compresses over the forecast period even though every channel's own margin remains unchanged.
- This mechanic makes the mix effect on gross margin explicit rather than leaving it to a single blended assumption.
Waste as a formula-driven blend of channel mix
Spoilage is not a flat percentage but a weighted blend based on how much revenue comes from pre-ordered versus forecast-based channels.
- Wedding and corporate volume is purchased to confirmed orders, so its spoilage rate is low, while walk-in and holiday volume is bought against uncertain demand, so its spoilage rate is higher.
- The model calculates a blended spoilage rate from the revenue shares of these groups and applies it to total wholesale cost.
- As pre-order channels grow faster, the blended rate falls, but total spoilage dollars can still rise because the purchase base expands.
Staffing, fleet, capex, and cash flow to valuation
Design labor is driven by a weighted order count that gives extra weight to holiday arrangements and wedding installations, then divided by a productivity ratio that improves annually. Delivery capacity is sized by order volume against existing vans, and in the base case no additional vans are needed.
- Capex covers a smooth equipment-refresh line and any fleet additions, each depreciated separately. The model then builds an unlevered free cash flow bridge from net operating profit after tax, adds back depreciation, subtracts capex and working capital changes, and discounts at a specified WACC to estimate enterprise value, equity value, and value per share.
- A dashboard summarizes key metrics including holiday revenue share, blended gross margin, and EBITDA margin.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a florist financial model?+
A florist financial model captures the seven-year operating economics and intrinsic value of a single-location retail florist with a wedding/event design studio. It prices flagship-holiday revenue at a wholesale-cost premium that compresses gross margin, derives the shop's waste rate from its walk-in-versus-pre-order channel mix, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.
Why does gross margin compress even though EBITDA margin expands?+
Gross margin compresses because flagship-holiday revenue (a rising share of the mix) carries a materially higher wholesale-cost rate than everyday revenue - a pure mix effect, not a rate change on any single channel. EBITDA margin still expands because occupancy and G&A, the two largely fixed cost lines, grow far slower than revenue; that fixed-cost operating leverage outweighs the gross-margin drag.
Why is the waste/spoilage rate a formula instead of an assumption?+
Wedding and corporate volume is purchased to a known, pre-confirmed order, so it carries minimal spoilage risk; walk-in and holiday volume is purchased against an uncertain daily forecast, so it carries materially more. Blending the two rates by each channel's actual revenue share makes the waste rate a genuine output of the business's evolving channel mix rather than a single flat percentage applied to everything.
Why doesn't the delivery fleet need any new vans?+
The model sizes van requirements off delivery-order volume against each van's capacity. With two existing vans already covering current volume, and delivery-order growth driven mostly by the walk-in-and-holiday channels rather than a fleet-heavy channel, volume never crosses the threshold that would require a third van within the seven-year horizon - a genuine formula result, not a hardcoded assumption.
Have more financial modelling questions? Contact us
Related templates
Bakery Chain Model
Plan and value an artisan bakery chain using retail foot traffic, wholesale orders, ingredient costs, spoilage, and a DCF.
Coffee Shop Chain Model
Plan and value a specialty coffee chain using store foot traffic, average ticket size, beverage gross margins, and a DCF.
Retail Store Model
Plan and value a retail-store chain using new stores, customer traffic, sales, inventory, and operating costs.
