A free flower shop business model in Excel, with a full worked case
Seven order streams, the calendar by month, recipes and spoilage, wedding deposits, wire orders and corporate accounts, staffing from the schedule, delivery, a P&L with adjusted EBITDA and SDE, break-even and four stresses, the quarters and the line of credit, a new shop, a workshop studio and two offers for the business.
The file follows Quillerby Flowers & Events, a fictional full-service flower shop of 3,200 sq ft with a walk-in cooler, two vans and a wire network membership. It earns revenue of $1,383,372 and EBITDA of $137,986 (10.0%) and breaks even at 82.5% of its volumes. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Flower_Shop_Model_Quillerby.xlsx (89 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is the worked case of The Flower Shop Owner. The book explains every assumption and every tab: why the margin is made recipe by recipe, what the dump log says about buying, why a wedding deposit is never revenue, what the wire network keeps, why the schedule and not the sales sets the payroll, which deliveries a 17-year-old may not drive, why the third quarter consumes cash, what a workshop studio costs, and how two buyers would value the shop.
Fifteen tabs, in the order of the book’s appendix A. Every input is a blue cell on the first tab; every other cell is a formula.
Assumptions
Opening hours, orders and average orders, product cost rates and spoilage, the wire network’s terms, delivery, tenders and credit, deposits, the schedule and pay, occupancy and other costs, the loan and the line, the month shares, the 2022 opening and a new shop, the plan and the studio, the stresses and the two offers.
Revenue
Orders times average order for each stream, delivery fees and the commission on orders sent ($1,383,372 in the case).
Calendar
Revenue by month and by quarter, from 5.2% of the year in January to 12.8% in December.
Product and Spoilage
Product cost by stream, spoilage at cost ($36,168), fresh product and hard goods on hand, and purchases.
Weddings and Deposits
Deposits held at year end ($35,280) and their movement through the quarters, kept out of revenue.
Wire and Corporate
Orders received and the network’s deductions, orders sent and the commission, the monthly settlement, corporate receivables, bad debts and gift cards.
Schedule and Payroll
Hours from the opening hours and positions, peak weeks, processing, event crews and driving, sick leave, pay with burden and the count toward fifty.
Delivery
Deliveries, driver hours and the average cash cost of a delivery ($10.02 in the case).
P&L
Revenue, variable costs with card fees on counter receipts, contribution, fixed costs, EBITDA, adjusted EBITDA and SDE ($222,541).
Break-Even and Stresses
The share of 2026 volumes at which EBITDA is zero (82.5%), and the year rerun with lower volumes, dearer flowers, higher wages and fewer weddings.
Cash by Quarter
Four quarters: loan payments, deposits moving with the season, tax distributions on the tax calendar, the line and the cash floor, and the volume stress.
Opening
The 2022 opening, sources equal to uses, and a new shop’s first year with receivables built from zero.
Plan and Studio
2027 to 2029 with the studio: EBITDA, coverage, working capital, the line quarter by quarter, the studio’s own EBITDA and its reserve.
Valuation
An operator’s offer on adjusted EBITDA and an individual buyer’s offer on SDE, inventory at cost added once, the cash the seller keeps, the buyer’s coverage test and the buyer’s whole project.
Checks
Internal checks, the tests of the case (the line, reserves, distributions, the buyer’s coverage) and a comparison with every figure printed in the book.
Three things to try
Make the flowers dearer. Set the product cost stress: ten percent more for flowers and supplies, at unchanged prices, changes EBITDA by -$44,203 in the case.
Lose a third of the weddings. The wedding stress changes EBITDA by -$38,825, and the deposits that carry the winter shrink with it.
Cut the volumes. Set the volume stress and read the line of credit: in the case it would go $22,971 past its limit, while distributions cut to the tax and deferred capital spending keep it within.
Questions
Does it keep wedding deposits out of revenue?
Yes. Deposits are a liability until the wedding; the cash tab moves them with the season and they net to zero over the year.
Does it use macros?
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Can I use it for my own shop?
Yes: replace every blue input, starting with your orders, average orders, product cost rates, spoilage and schedule. Quillerby and every figure in it are fictional case assumptions, not market data.