Donut Shop Financial Model

Five-year projections, dashboard, P&L, cash flow, balance sheet, and three scenarios - pre-built in Excel and Google Sheets. Made for donut shop planning and delivered as an instant download.
Donut Shop Financial Model - overview hero image introducing the model, highlighting purpose to forecast bakery revenues, costs, staffing, cash runway and investor-ready summaries for decision making
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Donut Shop Financial Model - overview hero image introducing the model, highlighting purpose to forecast bakery revenues, costs, staffing, cash runway and investor-ready summaries for decision making
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Donut Shop Bundle
See included products:
Financial Model iDonut Shop Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iDonut Shop Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iDonut Shop Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Donut Shop Financial Model is an Excel financial model for planning an independent retail donut bakery. It turns daily paid orders, five basket prices, operating costs, staffing, and startup investment assumptions into a monthly forecast and connected financial reports.

The illustrated case represents a 1,200-square-foot suburban U.S. bakery with counter service and prepaid pickup, trading 26 days per month. The forecast covers 2026 through 2030; its assumptions and outcomes are estimates, not actual store performance or industry averages.

Forecast
5annual forecast years
Basket types
5exclusive sales categories
Trading days
26per modeled month
Staff roles
4separate payroll plans
WHAT IS INCLUDED

An Integrated Donut Shop Planning Workbook

The template links bakery-specific operating inputs to monthly calculations, financial statements, and decision-oriented reporting.

Revenue and Calc

Set orders, trading days, basket shares, and selling prices. Calc builds monthly sales by basket.

COGS & OPEX and Payroll

Plan ingredients, packaging, processing, marketing, overhead, and staffing separately.

CAPEX, CapTable and Debt

Schedule bakery assets, equity contributions, and optional debt facilities, including repayments and interest.

IS, CF and BS

Review projected income, cash flow, and balance sheet reports; supplied case results stop at EBITDA.

Scenarios and Management Reports

Compare scenarios with Dashboard, Returns, Sources & Uses, Valuation, Charts, and Checks.

REVENUE BUILD

How Daily Donut Orders Become Sales

Revenue is driven by one paid-order pool, allocated among five complete basket types rather than independently forecast product quantities.

Edit orders, trading days, basket allocations, and annual prices. Categories are Single Classic Donut, Donuts and Coffee Combo, Classic Half Dozen, Classic Dozen, and Premium Dozen.

Shares are 20%, 30%, 20%, 20%, and 10%, with the fifth calculated as a residual. The combo includes coffee once.

Revenue Forecast

The Revenue Forecast translates one pool of daily paid orders into basket quantities and revenue using trading days, mix percentages, and complete ticket prices. Adjust demand or realized price to see how each sales stream changes.

donut shop financial model revenue fml30
Illustrative 2026 monthly revenue

110 paid orders per day × 26 trading days × $10.50 weighted basket price = $30,030 per modeled month.

Daily orders rise from 110 to 160 by 2030, with 26 trading days monthly. The 2026 weighted ticket is $10.50.

Orders are zero before the January 31, 2026 launch; that month is modeled in full. There is no separate capacity constraint, wholesale, or marketplace delivery.

OPERATING COSTS

Direct Costs, Overhead and Staff Pay

The expense forecast separates sales-linked ingredient and selling costs, monthly overhead, and base salaries so each component is counted once.

Ingredients cost 26% of revenue; packaging costs 3%. Card processing declines from 3.8% to 3.6%, and local marketing remains 2%.

Fixed costs cover rent, utilities, insurance, cleaning, repairs, bookkeeping, software, communications, and licenses. Monthly rent rises from $3,000 to $3,375.

COGS and Operating Expenses

The COGS and Operating Expenses forecast separates direct food and packaging costs from variable payment and marketing charges and recurring fixed shop expenses. It helps test the EBITDA effect of changes in sales and cost assumptions.

donut shop financial model cogs opex fml30

Payroll Forecast by Staff Role

The Payroll Forecast organizes FTE, annual salaries, and staffing schedules for the shop manager, lead baker, assistant baker, and counter associates. Salary planning is separate from ingredient and overhead assumptions to avoid counting the same wages twice.

donut shop financial model payroll fml30

The manager earns $48,000 and lead baker $40,000 annually. By 2030 assistant bakers rise from 0.6 to 1.0 FTE; counter associates rise from 1.0 to 1.4 FTE, at $34,000 and $32,000 per FTE.

The illustrative expense scope excludes employer payroll taxes, benefits, and personal taxes; tailor these to your location.

STARTUP INVESTMENT

Equipment, Opening Cash and Funding

Opening investment is planned independently of ongoing shop expenses and EBITDA, including equipment, preopening payments, working capital, and reserves.

Startup assets include $24,000 for fryer/mixer/proofing equipment, $20,000 for ventilation/fire suppression, $9,500 for refrigeration, and $6,500 for display fixtures, plus other bakery equipment.

Other opening payments cover permits, refundable deposits, preopening training and payroll, and launch marketing; they are outside annual operating expenses.

Capital Expenditure Plan

The Capital Expenditure Plan schedules bakery equipment and other eligible capital purchases, alongside depreciation and net book value. It distinguishes asset spending from the operating cost assumptions used to calculate EBITDA.

donut shop financial model capex fml30

Working-capital controls are zero receivable days, seven payable days, and 14 inventory days. Estimated owner funding of $235,431 includes opening assets, cash uses, working capital, and a three-month outflow reserve.

Sources and Uses of Funds

The Sources and Uses of Funds report organizes equity, debt, cash receipts, operating payments, and investment spending over a selected period. Use it to connect the opening bakery budget with the planned funding mix and cash allocation.

donut shop financial model sources uses fml30
FIVE-YEAR FORECAST

Illustrative Annual Revenue and EBITDA

The example shows how changes in paid-order volume, basket pricing, shop expenses, and staffing flow into projected operating EBITDA.

Illustrative donut shop operating forecast, USD
Year Revenue Operating Expenses EBITDA
2026 $360,360 $329,705 $30,655
2027 $421,785 $359,335 $62,450
2028 $486,508 $390,578 $95,930
2029 $536,843 $416,352 $120,491
2030 $589,855 $443,610 $146,245

Forecast estimates rounded to whole dollars; totals may differ slightly due to displayed rounding.

Revenue rises from $360,360 to $589,855, and expenses from $329,705 to $443,610. EBITDA rises from $30,655 to $146,245 between 2026 and 2030.

EBITDA is not net profit or free cash flow. Depreciation, interest, tax, investment purchases, working-capital movements, and financing activity require their own schedules before assessing accounting earnings or liquidity.

Cash Flow Forecast

The Cash Flow Forecast tracks operating, investing, and financing cash movements and reconciles opening to closing cash. Review it separately from EBITDA to assess the timing of equipment outlays, debt service, owner contributions, and potential liquidity shortfalls.

donut shop financial model cf fml30

Monthly Income Statement, Balance Sheet, and Summary reports are included, but the source supplies no net profit, closing cash, or debt balance values.

DECISIONS AND RETURNS

Break-Even, Payback and Scenario Testing

Use the model reports to evaluate required sales, operating profitability, cash recovery, and sensitivity without treating those measures as interchangeable.

Returns separates sales break-even, cash break-even, investment payback, and annual ROIC. Sales break-even tests operating cost coverage; the other measures depend on cash timing or invested capital.

Break-Even, Payback and ROIC

The Returns analysis brings together break-even requirements, project cash flows, investment payback, and ROIC. It supports questions about operating cost coverage and invested-capital efficiency without equating an EBITDA margin with a cash payback period.

donut shop financial model returns fml30

Low, Base, and High controls vary revenue, cost rates, overhead, and payroll. Compare staffing and pricing choices; the annual table is not a tested downside result.

Financial Scenario Analysis

The Financial Scenario Analysis compares Low, Base, and High revenue, gross margin, contribution margin, and EBITDA projections. It helps identify which changes to ticket demand, pricing, expense rates, or staffing assumptions most affect modeled operating performance.

donut shop financial model scenarios fml30
PLANNING APPLICATIONS

When This Donut Bakery Model Fits

The template is suited to evaluating an independent counter-service donut shop with one physical retail location and a tightly defined paid-basket mix.

Prepare budgets, test order volumes and staff coverage, model cost pressures, and review reports with advisers or financing partners.

The example excludes franchises, wholesale, and marketplace delivery. Shops using these channels must adapt revenue, fees, payment timing, and staffing.

FREQUENT QUESTIONS

Questions About the Donut Shop Model

These answers clarify the operating assumptions, workbook functions, and limits of the illustrated financial projections.

Can I edit the daily order forecast?

Yes. Edit daily paid orders, monthly trading days, basket mix, and annual prices.

How does the model avoid counting coffee twice?

Each order belongs to one basket, and coffee is included once in the combo price.

Does the model include bakery employees?

Yes. Payroll separately plans four roles using salaries and FTE.

Are bakery equipment costs included in EBITDA?

No. CAPEX and opening cash are separate; asset purchases and depreciation have their own schedules.

Are cash flow and balance sheet reports included?

Yes. Cash Flow and Balance Sheet reports are included, while illustrated case outputs stop at EBITDA.

Can I compare downside and upside cases?

Yes. Scenario controls compare Low, Base, and High operating assumptions and profitability.

Does the forecast guarantee profit or financing?

No. Estimates do not establish net profit, lending eligibility, payback timing, or cash sufficiency.

What Does the Donut Shop Financial Model Contain?

donut shop financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

donut shop financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

donut shop financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

donut shop financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

donut shop financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

donut shop financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

donut shop financial model summary fml30

Financial Summary

Annual and monthly financial performance.

donut shop financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Assumptions Organized Fast

Megan Turner, TX

4 star rating

This template put pricing, costs, and growth in one place, so I stopped chasing numbers across tabs. I cut my planning time by about 4 hours and could explain the assumptions much more clearly.

Break-Even Was Clear

Daniel Brooks, FL

5 star rating

I could finally see margins and break-even without rebuilding formulas. That saved me a messy afternoon and made my lender call a lot easier to prepare for.

Scenario Planning Felt Simple

Lauren Mitchell, NY

5 star rating

Low, base, and high cases were set up in a way that made comparisons quick instead of tedious. I got through my scenario review in under an hour and booked the next planning meeting the same day.