Excel financial planning template for tattoo shop. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
5 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 5 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Session mix and revenueOnline illustration of one completed-session pool, service-category mix, net tattoo charges and trading days.Explore layout ↓
02Artist time and completion capacityOnline capacity audit connects the two-artist paid roster with tattooing, setup, turnover and lost reservations.Explore layout ↓
03Opening allocation and reserveOnline illustration separates one-time premises/equipment spending from cash retained for the opening ramp.Explore layout ↓
04Paid labor and operating costsOnline illustration keeps owner and employee labor fixed and distinguishes it from per-session supplies and card charges.Explore layout ↓
05Ramp, downside and operating resultsOnline illustration links the monthly booking ramp to the first three annual rows and tests price, cancellation and funding pressure.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Tattoo ShopHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$299,290
$414,987
$415,680
Session supplies and payment processing
$44,893
$62,248
$62,352
Paid owner, employee artist, reception and burden
$212,000
$212,000
$212,000
Premises, insurance, waste and operating overhead
$64,000
$64,000
$64,000
EBITDA
−$21,603
$76,739
$77,328
EBITDA margin
-7.2%
18.5%
18.6%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Session mix and revenueOperating assumptions
Session mix and revenue
Scenario purpose: Online illustration of one completed-session pool, service-category mix, net tattoo charges and trading days.
Inputs
Small, standard and extended completed-session shares.
Net session prices after deposit credit; tips and collected tax excluded.
Completed sessions per day and trading days; no ancillary sales.
Outputs
Weighted completed-session ticket.
Monthly sales and annual revenue from the common session pool.
Scope and limitations
Online explanatory panel, not a verified paid workbook tab inventory.
Consultations consume non-sale roster time in this case. A cancelled booking is not a completed tattoo.
Category duration and staffing capacity require the separate hours audit.
02Artist time and completion capacityOperating assumptions
Artist time and completion capacity
Scenario purpose: Online capacity audit connects the two-artist paid roster with tattooing, setup, turnover and lost reservations.
Inputs
Paid roster and reservable blocks after design, breaks and administration.
Tattoo and turnover hours by session category.
Booking completion/refill rate and artist availability.
Outputs
Reserved hours required for the completion target.
Feasible completed sessions and the effect of artist absence.
Scope and limitations
Independent check supplied for the online case; it is not claimed as a native paid-file capacity module.
Prices and days cannot be moved independently of duration and the roster.
The upper volume input requires a stronger completion rate than the base assumption.
03Opening allocation and reserveOperating assumptions
Opening allocation and reserve
Scenario purpose: Online illustration separates one-time premises/equipment spending from cash retained for the opening ramp.
Inputs
Local premises, furniture, machines, sterile opening stock and permissions quotes.
Paid pre-opening work and launch costs.
Reserve and stress-ramp funding.
Outputs
Opening allocation and low/base/high scope comparison.
Peak operating cash deficit against the selected reserve.
Scope and limitations
Vendor examples do not quote a complete installed studio.
This is not a full cash-flow forecast: debt, taxes, delays and deposit liabilities require additional modeling.
04Paid labor and operating costsOperating assumptions
Paid labor and operating costs
Scenario purpose: Online illustration keeps owner and employee labor fixed and distinguishes it from per-session supplies and card charges.
Inputs
Owner labor allowance, employee artist pay, receptionist hours and employer burden.
Premises, insurance, waste, marketing, software and maintenance.
Selected supplies and processing allowances.
Outputs
Annual payroll and overhead reconciled to monthly fixed costs.
Contribution after supplies and processing, before fixed pay.
Scope and limitations
Annualized wage budgets do not establish salary exemption or contractor status.
If artist commission is variable, change both payroll and contribution margin and fund any legal pay floor.
05Ramp, downside and operating resultsOperating assumptions
Ramp, downside and operating results
Scenario purpose: Online illustration links the monthly booking ramp to the first three annual rows and tests price, cancellation and funding pressure.
Inputs
Opening volume share, monthly ramp increment and the mature session case.
Later-year price, completion and selected cost changes.
Downside assumptions and committed funding.
Outputs
Five annual revenue and cost rows.
Monthly operating coverage, break-even traffic and cumulative deficit.
Scope and limitations
The operating proxy is before depreciation, interest and tax.
Neutral mature seasonality is a placeholder for verified local booking history, not a demand claim.
The paid model's published five-year scenario/report capabilities are broader than these explanatory panels.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Tattoo Shop input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net tattoo charge per completed session
$400.00
$250.00 – $650.00
Revenue per sold unit
Completed tattoo sessions across both artists per day
4
2 – 5
Daily throughput in the stated operating scope
Operating days per week
5
4 – 6
Trading schedule
Fixed operating costs / month
$23,000
Held constant
Operating break-even threshold
Contribution margin
85.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
50.0%
Base ramp input
Opening month revenue
Mature volume added / month
4.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
18 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
2
$17,320
$27,059
Not reached
Base volume
4
$34,640
$27,059
Month 9
Higher volume
5
$43,300
$27,059
Month 5
Only completed tattoo sessions across both artists per day changes. Net tattoo charge per completed session: $400.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 18-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$299.3k
Year 1
$415.0k
Year 2
$415.7k
Year 3
$447.4k
Year 4
$480.1k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold work, handwashing and washable finishes$42,000
Two stations: chairs, stools, carts and lighting$18,000
Machines, power, stencil and design equipment$10,000
Opening sterile instruments and hygiene stock$7,000
Reception, payment tools, signage and security$7,500
Deposits, design, permissions, legal and opening insurance$14,500
Paid pre-opening training and launch$6,000
Working capital retained for the operating ramp$65,000
One-time budget: $170,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $415,680.
Session supplies and payment processing$62,352
Paid owner, employee artist, reception and burden$212,000
Premises, insurance, waste and operating overhead$64,000
EBITDA$77,328
EBITDA margin: 18.6%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
4
Break-even revenue / month
$27,059
Base revenue / month at maturity
$34,640
First operating break-even
Month 9
Units mean completed tattoo sessions across both artists per day. The ramp covers 18 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$299,290
$299,290
Year 1 operating result
−$21,603
−$21,604
Year 2 revenue
$414,987
$414,987
Year 2 operating result
$76,739
$76,739
Year 3 revenue
$415,680
$415,680
Year 3 operating result
$77,328
$77,328
Year 3 / full-volume annual revenue
$415,680
$415,680
Year 3 / full-volume annual operating result
$77,328
$77,328
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your tattoo shop together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Tattoo Shop Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Session mix and revenue, Artist time and completion capacity, Opening allocation and reserve, Paid labor and operating costs, Ramp, downside and operating results using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review net tattoo charge per completed session, completed tattoo sessions across both artists per day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
