Revenue and Calc
Edit foot traffic, open days, purchase rates, units per purchase, selling prices, category mix, and seasonality. Monthly calculations allocate projected candy sales among six categories.
Candy Store Financial Model
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Candy Store Financial Model is an Excel template for planning a neighborhood candy retailer that purchases finished confectionery and resells it across six categories. It connects store visits, purchase conversion, units per sale, category prices, inventory costs, staffing, and overhead to a monthly operating forecast.
The supplied example represents an estimated 1,200-square-foot independent U.S. shop, with illustrative projections for 2026 through 2030. Its stated operating results stop at EBITDA; sales, earnings, financing needs, and cash positions change when the buyer edits the workbook assumptions.
- Forecast
- 5annual forecast years
- Candy categories
- 6exclusive sales streams
- Open days
- 26per month assumed
- Purchase conversion
- 70%of in-store visits
WHAT IS INCLUDED
Linked Worksheets for Retail Financial Planning
The template separates candy-store assumptions, calculation schedules, funding inputs, and financial reports so edits can flow through the model.
COGS & OPEX and Payroll
Plan purchased stock, freight, shrinkage, checkout costs, store overhead, and annual-average staffing. Role-level base salaries remain separate from merchandise costs.
CAPEX, CapTable, and Debt
Record opening retail equipment, investment dates, owner contributions, and optional financing inputs. Debt schedules calculate borrowing balances, interest, and repayments when facilities are entered.
Financial Statements
The Income Statement, Cash Flow, Balance Sheet, and Summary organize projections into operating results, cash movement, and financial position, subject to their supporting assumptions.
REVENUE FORECAST
How Candy Store Sales Are Calculated
Revenue starts with expected walk-in demand, then applies purchase conversion, units per purchase, category allocation, and selling prices.
The example begins with 90 store visits per open day in 2026, rising to 130 by 2030, and assumes 26 open days per month. Of those visits, 70% convert into purchases with 1.4 selling units per transaction.
A repeating January-to-December seasonal pattern adjusts monthly demand before the units are distributed among the six categories. Pick-and-Mix Bags represent 25% of units, Chocolate Packs 20%, Classic Candy Packs 20%, Gummy and Sour Packs 15%, Gift Boxes 12%, and Novelty and Imported Candy 8%.
Revenue Forecast
The Revenue Forecast organizes the store-visit assumptions, conversion, selling units, six-category product mix, and category prices. Its monthly calculations feed the annual sales projection rather than treating the store as constrained by production capacity.
Illustrative 2026 annual sales calculation
90 visits/day × 26 days/month × 70% conversion × 1.4 units/purchase × $9.54 weighted price × 12.0 total seasonal factors ≈ $262,526 annual revenue.
The $9.54 weighted selling price comes from the six documented prices and their unit shares, not a separate arbitrary ticket assumption. Change demand, category mix, or prices to see how a greater share of $25 gift boxes, for example, affects sales.
OPERATING COSTS
Merchandise, Overhead, and Payroll Stay Separate
The store forecast deducts purchased stock costs, sales-linked charges, fixed operating overhead, and role-based payroll from revenue to calculate EBITDA.
The three direct-cost assumptions are purchased confectionery at 45% of revenue, inbound freight and cooling at 1.2%, and stock spoilage or shortages at 1.3%. Together they equal 47.5% of projected sales before variable checkout and packaging expenses.
Payment processing consumes 3% of sales and packaging 1%. Fixed expenses cover rent, utilities, insurance, software, marketing, cleaning, administration, communication, and recurring fees.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates merchandise purchases and shrinkage from revenue-based selling costs and monthly fixed charges. This distinction helps test whether price, traffic, and gross margin can support the store’s occupancy and administration costs.
| Expense category | 2026 | 2030 |
|---|---|---|
| COGS | $124,700 | $180,122 |
| Variable costs | $10,501 | $15,168 |
| Fixed costs | $57,120 | $64,512 |
| Payroll | $75,200 | $88,800 |
Each expense appears once in the operating forecast; amounts are model-case projections, not store industry averages.
Payroll uses one paid owner-manager with a $48,000 annual base salary and part-time sales associates with a $34,000 full-time base. Associate staffing rises from 0.8 annual-average FTE in 2026 to 1.2 in 2030.
Payroll rises from $75,200 in 2026 to $88,800 in 2030. This scenario excludes employer payroll taxes, employee benefits, and personal taxes.
Payroll Forecast by Staff Role
The Payroll Forecast plans staffing by role, annual-average FTE, base salaries, and timing-related inputs. It provides a separate personnel schedule so owner-manager and associate compensation are not counted again as purchased candy or operating overhead.
STARTUP FUNDING
Opening Investment and Working Capital Assumptions
Startup equipment, opening cash outlays, and initial owner funding are planned separately from annual revenue and EBITDA.
Opening assets include merchandising shelves, food-safe display cases, checkout equipment, leasehold improvements, security, and signs. Examples are $10,000 of shelving, $3,000 of display cases, and a $2,500 checkout station.
Deposits, permits, opening promotion, and preopening wages are separate startup cash needs, not recurring annual store expenses.
Capital Expenditure Plan
The Capital Expenditure Plan records asset purchases, budgets, expenditure dates, and applicable depreciation schedules. It helps distinguish the cost of preparing a candy retail location from merchandise purchases and recurring expenses that affect operating EBITDA.
The case uses 45 inventory days, 15 accounts-payable days, and zero receivable days to reflect shelf stock, supplier credit, and immediate consumer checkout. The opening owner-funding assumption is $125,329, with no committed external financing in this case.
Sources and Uses of Funds
Sources and Uses of Funds compares funding sources with operating payments, initial investment, and cash retained. Its cash-allocation view is useful when checking whether owner contributions and any entered borrowing cover planned opening inventory and other cash requirements.
FIVE-YEAR FINANCIAL PROJECTIONS
Illustrative Candy Store Operating Results
In the supplied planning case, projected annual EBITDA improves from a first-year loss to a positive operating contribution as modeled store visits increase.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $262,526 | $267,521 | −$4,995 |
| 2027 | $291,695 | $287,743 | $3,952 |
| 2028 | $320,865 | $308,001 | $12,863 |
| 2029 | $350,034 | $328,284 | $21,751 |
| 2030 | $379,204 | $348,602 | $30,602 |
Annual values are illustrative and rounded to whole dollars; small differences may result from displayed rounding.
The example moves from $262,526 of revenue and approximately $4,995 of negative EBITDA in 2026 to $379,204 of revenue and $30,602 of positive EBITDA in 2030. These are modeled results tied to the specified assumptions, not actual store earnings or an industry performance benchmark.
Operating expenses include direct costs, variable costs, fixed overhead, and payroll. EBITDA excludes depreciation, interest, and taxes; the supplied brief does not establish net profit or available cash.
Cash Flow Forecast
The Cash Flow Forecast shows operating cash movements alongside investing and financing flows, with an opening-to-closing cash reconciliation. It provides a different perspective from EBITDA when inventory purchases, equipment spending, owner funding, or debt repayment alter liquidity.
The linked Income Statement, Balance Sheet, and Summary are available as model reports, while the supplied numeric example is limited to revenue, operating expenses, and EBITDA. Buyers can assess projected cash and financial position inside the workbook without treating EBITDA as cash generated.
BREAK-EVEN AND RETURNS
Evaluate Sales Thresholds, Funding, and Returns
The workbook supplies separate management tools for operating break-even, cash break-even, investment payback, and return on invested capital.
The Returns worksheet compares sales with costs needed to cover operations, then examines project cash flows, accumulated recovery, and annual return on invested capital. The threshold for covering operating expenses is not automatically the date when total opening investment is recovered.
Payback is based on investment and cash flow, not EBITDA. The brief does not establish a payback month, ROIC percentage, or business value.
Break-Even, Payback and ROIC
The Returns report examines break-even revenue, project and cumulative cash flows, investment payback, and annual ROIC. These measures address different questions about store sustainability and investor capital recovery, rather than converting the EBITDA forecast into a claimed investment return.
For sensitivity testing, the Dashboard includes Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed costs, and payroll. Compare modeled EBITDA paths after changing traffic assumptions, category prices, rent, or staffing before choosing a planning case.
Financial Scenario Analysis
Financial Scenario Analysis compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA. It helps identify how an unfavorable traffic scenario or higher store expenses could affect operating coverage across the five forecast years.
FREQUENTLY ASKED QUESTIONS
Common Questions About the Candy Store Model
These answers explain the demand forecast, editable assumptions, financial reports, and boundaries of the supplied example.
What drives revenue in this candy store model?
Store visits per open day, open days, purchase conversion, units per purchase, seasonal factors, category mix, and six selling prices drive projected candy sales.
Can I change candy prices and product mix?
Yes. Revenue inputs include category-level prices and unit shares for Pick-and-Mix Bags, Chocolate Packs, Classic Candy Packs, Gummy and Sour Packs, Gift Boxes, and Novelty and Imported Candy.
Does the model include staffing and rent?
Yes. Payroll plans the owner-manager and sales-associate FTEs separately, while fixed operating expenses include rent and other recurring store overhead.
Are opening investments included in EBITDA?
No. Opening assets, prelaunch cash items, and owner equity contributions are distinct from the documented operating expense and EBITDA forecast.
Does the template include cash flow and balance sheet reports?
Yes. Cash Flow and Balance Sheet are declared workbook reports, but the supplied example does not establish a verified ending cash balance or balance sheet total.
Does positive EBITDA mean the store has paid back its investment?
No. EBITDA excludes investing and financing cash flows. Cash break-even and investment payback are separate analyses in the Returns report.
What Does the Candy Store Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Blank Page To Working Model
The blank-sheet problem disappeared fast. I had a full candy store model to start from instead of staring at an empty file, and I saved about 6 hours on setup.
Margin Clarity In Minutes
This made profitability easier to read right away. I could see margins and break-even more clearly, which helped me tighten assumptions before a lender call.
Safer Numbers, Less Stress
I’m always nervous about formulas, but this template kept the structure clean. One broken cell didn’t send me chasing errors for half a day, so I got the model finished faster.