Revenue & Calc
Plan qualified inquiries, paid-repair completion, category allocation, and repair prices; convert them into monthly completed jobs and sales.

The Cell Phone Repair Financial Model is an Excel financial planning template for an independent, out-of-warranty smartphone repair storefront. It converts qualified customer inquiries into completed repair tickets, assigns each ticket to one repair category, and projects monthly revenue, operating costs, and financial reports.
The illustrated case is a leased 1,000-square-foot shop in the Indianapolis metropolitan area, with a January 31, 2026 launch and a 2026–2030 forecast. The model covers paid repairs rather than phone sales, accessories, carrier commissions, insurance claims, or franchise operations.
The workbook links shop-specific repair assumptions to monthly calculations, financial statements, and decision-support reports.
Plan qualified inquiries, paid-repair completion, category allocation, and repair prices; convert them into monthly completed jobs and sales.
Separate replacement parts, consumables, warranty rework, processing costs, storefront overhead, and salaried owner and staff.
Record opening equipment and fitout, equity contributions, and optional borrowing terms in their corresponding schedules.
Review the income statement, operating and financing cash flows, financial position, and an integrated reporting summary.
Set working-capital assumptions and compare Low, Base, and High cases for revenue, expenses, margins, and EBITDA.
Explore distinct break-even, payback, ROIC, and discounted cash flow analyses without treating EBITDA as cash.
Revenue comes from completed paid repair tickets, allocated once among five service categories at their corresponding average prices.
The selected demand model starts with 500 qualified inquiries per month in 2026, rising to 800 in 2030. A 60% paid-repair completion rate produces 300 monthly tickets initially and 480 in the final forecast year; free preliminary diagnosis does not count as a paid job.
The five exclusive categories are screen replacement (45% at $190), battery replacement (25% at $100), charging port repair (10% at $120), back glass repair (10% at $160), and camera or audio repair (10% at $140). Their weighted average ticket is $152.50.
The Revenue Forecast organizes inquiry volumes, conversion rates, repair mix, and average category prices. Those editable operating inputs feed monthly calculations and the annual sales projections.
500 inquiries/month × 60% paid completion × $152.50 weighted ticket × 12 months = $549,000 annual revenue.
Revenue depends on demand and paid completion, not a separate technician-capacity ceiling. Each completed ticket enters one category; average category prices absorb multi-fault work rather than counting the same customer repair more than once.
The forecast separates revenue-linked direct costs, variable selling costs, recurring fixed expenses, and fixed salaries.
Direct repair costs equal 40% of revenue: replacement parts 36%, repair adhesives and consumables 2%, and warranty parts and rework claims 2%. Additional variable operating expenses equal 4.5% of sales, comprising payment processing at 2.5% and incremental local acquisition at 2%.
Monthly fixed expenses cover rent, utilities, insurance, repair software, connectivity, accounting, baseline marketing, tool upkeep, recycling, renewals, and training. The selected $2,200 monthly store lease is one component of the $49,560 annual fixed expense total.
The COGS & Operating Expense Forecast shows how direct parts and rework costs, variable transaction expenses, and scheduled storefront overhead enter the monthly operating plan. It keeps non-payroll costs separate from staff compensation.
Payroll consists of one working owner-manager at $55,000 annually, repair technicians at $52,000 per annual-average FTE, and counter assistants at $36,000 per FTE. Technician staffing rises from 2 to 3 FTE, while counter assistance grows from 0.5 to 1 FTE over the forecast.
The Payroll Forecast tracks roles, full-time-equivalent staffing, salary assumptions, and monthly personnel expense. In this case, fixed base payroll totals $177,000 in 2026 and $247,000 in 2030, with salaries excluded from all other expense categories.
Startup assets, one-time opening cash requirements, inventory, and equity funding are planned separately from recurring operating expenses.
The example allocates $12,000 to minor fitout and signage, $6,000 to ESD workbenches and secure storage, $7,000 to testing and heat equipment, and $4,000 to point-of-sale computers and security hardware. These four startup assets total $29,000 before other opening outlays.
Separate opening cash items include refundable premises and utility deposits, registration and professional setup, a website and launch campaign, preopening occupancy and training, and initial repair-material stock. The example provides $178,863 of estimated initial owner funding, not committed third-party finance.
The Capital Expenditure Plan records equipment and fitout costs, investment timing, and depreciation schedules where applicable. It distinguishes startup investment from the repair shop’s ongoing expense and EBITDA forecasts.
Working-capital inputs use zero receivable days because customers pay at repair pickup, zero payable days, and 29 inventory days. The funding estimate includes selected opening uses and three months of first-year operating cash outflows; it does not prove that cash will remain sufficient.
The Sources and Uses of Funds report groups projected cash sources and allocations, including owner equity, optional debt, operating payments, and investment spending. It helps compare opening funding assumptions with modeled cash needs without equating owner contributions with revenue.
The selected Indianapolis shop assumptions project rising repair revenue and EBITDA through 2030, subject to the entered demand, price mix, and cost assumptions.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $549,000 | $470,865 | $78,135 |
| 2027 | $658,800 | $532,726 | $126,074 |
| 2028 | $746,640 | $593,815 | $152,825 |
| 2029 | $812,520 | $636,131 | $176,389 |
| 2030 | $878,400 | $687,448 | $190,952 |
Illustrative projections, not observed shop performance; intermediate amounts are rounded to whole dollars.
Projected sales increase from $549,000 in 2026 to $878,400 in 2030 as monthly inquiries rise, while the assumed paid completion rate and repair price mix stay constant. Total operating expenses also increase, reflecting revenue-linked replacement parts and acquisition costs plus additional salaried technicians and counter coverage.
EBITDA rises from $78,135 to $190,952 in this example. EBITDA measures modeled operating performance before depreciation, interest, and income taxes; it is not net profit, available cash, or an investment return.
The Cash Flow Forecast tracks operating, investing, and financing cash movements and reconciles opening and closing cash. Use it to assess the timing of parts inventory, capital purchases, owner funding, and any selected debt payments separately from EBITDA.
The Income Statement supports further accounting-profit analysis, while the Balance Sheet covers working capital, fixed assets, equity, and liabilities. These report functions are available in the workbook, but the supplied example establishes specific operating results only through EBITDA.
The workbook includes separate analyses for operating break-even, cash break-even, investment recovery, and return on invested capital.
The Returns report compares revenue with the level needed to cover costs, estimates cash break-even timing, evaluates investment payback from cumulative project cash flow, and calculates annual ROIC using invested capital. Those are different measures; the supplied EBITDA figures alone do not establish any payback date or return percentage.
The Return on Invested Capital Analysis examines break-even requirements, cash recovery, cumulative project cash flow, and annual ROIC. It supports checking whether a repair-shop plan recovers its opening investment, but no specific return outcome is claimed here.
Dashboard controls allow Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed costs, and payroll. Their scenario comparison helps test the resilience of the shop’s margins when inquiries, repair economics, or compensation differ from the selected case.
The Financial Scenario Analysis compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA. It reveals which operating assumptions drive downside risk without presenting a scenario as a guaranteed result.
Valuation, financial ratios, KPI benchmarking, and chart-based reports offer additional perspectives when their assumptions are populated and reviewed. Potential buyers can use the model to stress-test a location, revisit technician hiring, and compare funding structures before committing capital.
Answers to common questions about the template’s scope, editable inputs, and projected results.
An independent, leased, consumer cell phone repair storefront handling completed paid, out-of-warranty repairs; it excludes resale, accessories, carrier commissions, insurance claims, and franchise royalties.
Yes. Revenue inputs cover monthly qualified inquiries, paid completion, five mutually exclusive service shares, and their average repair prices.
No. Each completed paid ticket is allocated once to its principal category; bundled repair work is represented in that category’s average price.
Payroll uses annual-average full-time-equivalent staffing and fixed annual base compensation by role, with salaries excluded from COGS and other operating expenses.
No. It is an illustrative EBITDA forecast before depreciation, interest, and income taxes, not a statement of net profit or available cash.
Yes. CAPEX, CapTable, Debt, Sources & Uses, and Cash Flow schedules support investment and financing analysis; the example assumes estimated owner funding rather than committed debt.
No. Returns and Valuation provide calculation frameworks based on model inputs; the supplied case does not establish an actual payback date, ROIC, or business value.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
I used to get stuck on the spreadsheet side, but this template made the numbers easy to follow and cut my setup time by about 6 hours.
I wasn’t sure what to include for lenders and investors, but the template gave me the right structure and outputs, so I booked a meeting with a cleaner deck in hand.
I liked that the formulas were already set up, because one broken cell used to throw off my whole plan. This saved me from rechecking every tab and kept my forecast consistent.