# Florist Model See how everyday orders, events, weddings, and seasonal peaks shape a florist. - Canonical: https://finamodel.com/templates/florist - Excel download: https://finamodel.com/templates/florist.xlsx - Category: Ecommerce - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Florist and floral-design business owners, Wedding and event-services investors, Small-business buyers and lenders, Retail franchise and multi-unit operators - Tags: florist, retail, perishable-goods, operating-model, dcf ## Overview 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's included - 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 - Revenue sheet: base, holiday, wedding and corporate revenue at their own escalating prices, mix and holiday-share KPIs - P&L sheet: revenue to net income with four channel-specific cost-of-goods-sold rates plus the mix-derived spoilage charge, the opex stack, margins, identity check - FCF sheet: NOPAT, depreciation add-back, van-fleet and equipment-refresh capex, the working-capital balance and its change, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with revenue, holiday revenue share Year 1 vs Year 7, blended gross margin, blended spoilage rate, EBITDA, EBITDA margin, enterprise value, value per share - Weddings: bookings and growth, average contract value and its growth, deposit rate, Q4 next-year-delivery share - Corporate accounts: opening accounts, net adds per year, monthly fee and its growth - Spoilage: walk-in/holiday spoilage rate, wedding/corporate spoilage rate - Labor and delivery: orders-per-florist productivity and its growth, florist wage and its growth, delivery share, per-order van cost, existing van count and capacity, van unit cost and life - Fixed costs: occupancy and its growth, marketing percent of revenue, G&A and its growth - Capital and working capital: equipment-refresh capex rate and life, net-working-capital percent of revenue growth, base-year working capital - Operations sheet: base and holiday volume build, wedding and corporate build, weighted staffing, delivery fleet sizing, working capital including the wedding-deposit liability, 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. ## A holiday wholesale-cost premium that compresses margin exactly when revenue peaks Holiday wholesale flower cost (50.0% of holiday revenue) sits far above everyday wholesale cost (32.0% of base revenue), because every florist buys the same flagship-date flowers at once. As the holiday-volume multiplier compounds faster than everyday traffic growth, holiday revenue's mix share rises from 18.2% to 23.1% and blended gross margin compresses from 62.8% to 61.9% - a real, documented seasonal cost dynamic no other archetype in this library has modeled. ## Designed for one-edit responsiveness Every input - the volume and holiday-multiplier build, pricing, wedding and corporate growth, the spoilage-rate blend, the cost stack, capex and the WACC - is a named-range cell. Edit one and the operations build, revenue, P&L, free-cash-flow bridge, valuation, and dashboard all recompute. No formula rewrites are needed to test a holiday-marketing, channel-mix, or waste-rate scenario. ## An unlevered DCF, not an EBITDA shortcut A florist keeps sinking capex into equipment refresh and carries a real wedding-deposit liability against future deliveries, so the model bridges to unlevered free cash flow - charging total capex and the change in working capital - and discounts it at a WACC set for a small-format, single-location retail business. Enterprise value bridges through net debt to equity value and value per share, and the implied EV/EBITDA falls out as a sanity check against where main-street retail concepts change hands. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Dashboard Headline metrics, the holiday-mix trend, and revenue mix. - Revenue, holiday revenue share Year 1 vs Year 7 - Blended gross margin and blended spoilage rate - EBITDA and EBITDA margin - Enterprise value and value per share - Seven-year trend grid and a revenue-to-net-income waterfall ### Assumptions Every driver in one sheet: volume, pricing, weddings, corporate, cost, capital. - Weekly transaction run-rate, holiday volume multiplier, holiday weeks per year - Base and holiday ticket price, wholesale cost rates by channel - Wedding bookings, contract value, deposit rate; corporate accounts and fee - Spoilage rates by channel mix - Labor, delivery, fixed-cost, capex, and working-capital rates; WACC, terminal growth, net debt, shares ### Operations Volume build, wedding and corporate build, staffing, delivery fleet, and working capital. - Base retail transactions and holiday transactions - Weddings booked and corporate accounts - Weighted order count and florist FTE - Delivery order volume and van-fleet sizing - Working capital including the wedding-deposit liability roll-forward ### Revenue Revenue by channel. - Base retail revenue equals base transactions times escalated base price - Holiday revenue equals holiday transactions times escalated holiday price - Wedding revenue and corporate revenue - Total revenue and mix and holiday-share KPIs ### P&L Revenue to net income. - Revenue from the Revenue sheet - Four channel-specific wholesale cost-of-goods-sold rates plus the mix-derived spoilage charge - Gross profit and gross margin - Design labor, delivery, occupancy, marketing and G&A to EBITDA - Depreciation, EBIT, tax, net income, margins, identity check ### FCF Unlevered free cash flow bridge. - EBIT and unlevered tax from the P&L - NOPAT equals EBIT less unlevered tax - Add back depreciation - Van-fleet capex and the equipment-refresh capex line - Change in working capital, including the wedding-deposit liability swing - Unlevered free cash flow, discount factor, and PV ### Valuation Discounted cash flow. - Sum of PV of explicit UFCF - Gordon-growth terminal value and its PV - Enterprise value - Less net debt to equity value - Shares outstanding and value per share - Implied EV/EBITDA ## Features - **A holiday wholesale-cost premium that compresses margin exactly when revenue peaks:** Holiday wholesale flower cost (50.0% of holiday revenue) sits far above everyday wholesale cost (32.0% of base revenue), because every florist buys the same flagship-date flowers at once. As the holiday-volume multiplier compounds faster than everyday traffic growth, holiday revenue's mix share rises from 18.2% to 23.1% and blended gross margin compresses from 62.8% to 61.9% - a real, documented seasonal cost dynamic no other archetype in this library has modeled. - **A waste rate that is a formula output of channel mix, not a flat assumption:** Walk-in and holiday volume is purchased against an uncertain forecast (8.5% spoilage); wedding and corporate volume is purchased to a known, pre-confirmed order (1.4% spoilage). As pre-order revenue share climbs from 30.3% to 36.6% on faster wedding and corporate growth, the blended spoilage rate falls from 6.35% to 5.90% even as spoilage dollars still rise from $14,647 to $25,224 on overall scale - both directions reported, not just the favorable one. - **An existing delivery fleet that absorbs the whole horizon with zero incremental capex:** Two existing delivery vans cover the entire seven-year delivery-volume growth without a single new vehicle purchase, because delivery-order volume never crosses the third-van capacity threshold within the horizon - van-fleet depreciation stays flat at $14,000/year and van-fleet capex is $0 every year, a disclosed finding rather than an oversight. ## Use cases - **Intrinsic valuation of a retail florist:** Set the volume, pricing, wedding and corporate growth assumptions and a WACC, and read enterprise value, equity value and value per share off mature-year earnings. - **Holiday-mix and margin sensitivity testing:** Flex the holiday volume multiplier, the holiday wholesale-cost rate, or the holiday ticket premium to see how blended gross margin and revenue respond to leaning harder into flagship-holiday demand. - **Channel-mix and waste-rate planning:** Flex wedding-booking growth, corporate-account adds, or the walk-in/pre-order spoilage rates to see how the blended waste rate and its dollar cost respond as the business shifts toward pre-ordered volume. ## Frequently asked questions ### 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. ## Related templates - [Bakery Chain Model](https://finamodel.com/templates/bakery) - [Coffee Shop Chain Model](https://finamodel.com/templates/coffee-shop) - [Retail Store Model](https://finamodel.com/templates/retail-store)