Personal Training Business Financial Model Template
Excel financial planning template for personal training business. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 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 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe inspected seller Revenue screen shows daily visits, operating days, seasonality, service prices, mix and extra revenue per visit. This online illustration uses completed hour-long one-to-one sessions.Explore layout ↓
02COGS & OPEXThe current product description and visible tab identify direct and operating costs. This web illustration separates payment/supply cost from the committed premises budget.Explore layout ↓
03PayrollA Payroll tab is visible in the inspected gallery. The StartFigures illustration funds the owner, employee nonbillable work and paid absence cover.Explore layout ↓
04CAPEX and CapitalThe inspected gallery shows investment and funding tabs. The online case separates opening setup, deposits, contingency and operating cash.Explore layout ↓
05IS, CF and BSThe gallery tabs and seller description identify income statement, cash flow and balance sheet reports; these web tables use the separately authored operating case.Explore layout ↓
06Scenarios and DashboardCurrent seller material presents scenario analysis and a dashboard, and both tabs are visible. The web illustration compares price and completed-session sensitivities at the same paid staffing.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.
Personal Training BusinessHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$188,355
$259,800
$259,800
Payment fees and session-linked supplies
$9,418
$12,990
$12,990
Owner, employee, employer costs and absence cover
$156,048
$156,048
$156,048
Premises, systems, marketing and operating overhead
$66,000
$66,000
$66,000
EBITDA
−$43,111
$24,762
$24,762
EBITDA margin
-22.9%
9.5%
9.5%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The inspected seller Revenue screen shows daily visits, operating days, seasonality, service prices, mix and extra revenue per visit. This online illustration uses completed hour-long one-to-one sessions.
Inputs
Active-client roster and completed hours per client as an external schedule
Completed one-to-one sessions across both trainers
Realized revenue per completed hour after discounts and refunds
Opening ramp and operating calendar
One training category; group, retail and extra-visit revenue set to zero
Outputs
Session-based earned revenue
Client-hour and sold-session reconciliation
Capacity comparison with paid offered hours
Scope and limitations
The inspected screen is a visit-and-service-mix structure. It does not verify native acquisition, retained-client cohorts, churn or billable-hour formulas.
One visit equals one billable hour only for this fixed-duration one-to-one case. Longer sessions, partner training or travel need separate duration and capacity schedules.
Gallery example values are not this studio assumptions or local market benchmarks.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: The current product description and visible tab identify direct and operating costs. This web illustration separates payment/supply cost from the committed premises budget.
Inputs
Selected payment-channel and session-linked supply share
Annual lease basis, property charges and utilities
Insurance, booking, marketing, cleaning, upkeep and professional services
Outputs
Variable contribution by delivered session
Recurring overhead schedule
Cost classification without repeated payroll
Scope and limitations
The selected variable share is simplified; percentage plus fixed card fees change with price and transaction size.
Scheduled trainer compensation remains in payroll and is not deducted again as a session-linked cost.
Local lease and supplier terms replace allowances; the seller screen does not verify the delivered cost formulas.
03PayrollOperating assumptions
Payroll
Scenario purpose: A Payroll tab is visible in the inspected gallery. The StartFigures illustration funds the owner, employee nonbillable work and paid absence cover.
Inputs
Working-owner annual compensation
Employee hourly wage and all paid weekly hours
Selected employer-cost allowance
Replacement-coaching hours and rate
Offered session hours after programming, intake and administration
Outputs
Complete annual labor allowance
Paid-hour versus offered-hour roster
Owner-delivery and backup responsibilities
Scope and limitations
National wages do not verify a local offer; the allowance is not a prescribed tax rate.
The backup provision needs a qualified available trainer and actual employment or service terms.
A visible tab is not a formula audit, a funded general manager or evidence of owner independence.
04CAPEX and CapitalOperating assumptions
CAPEX and Capital
Scenario purpose: The inspected gallery shows investment and funding tabs. The online case separates opening setup, deposits, contingency and operating cash.
Inputs
Compatible-site bid and complete equipment basket
Deposits and pre-opening payments
Opening contingency
Operating reserve and funding timing
Outputs
Opening uses allocation
Reserve bridge through the attendance ramp
Funding and unspent-cash reconciliation
Scope and limitations
A rack price supports one component, not the entire installed studio budget.
No property purchase, landlord contribution or debt is assumed.
Reserve adequacy excludes taxes, financing and unmodeled payment delays; do not add the same opening loss twice.
05IS, CF and BSOperating assumptions
IS, CF and BS
Scenario purpose: The gallery tabs and seller description identify income statement, cash flow and balance sheet reports; these web tables use the separately authored operating case.
Inputs
Reconciled delivered-session revenue and operating costs
Investment, deposits, funding and actual collection timing
Prepaid client credits and refunds as a separate liability/cash bridge
Outputs
Five-year operating scenario
Income-to-cash distinctions
Opening asset and funding review
Scope and limitations
The public operating proxy excludes depreciation, interest, income tax, replacement capital and owner distributions.
Recognized prepaid service revenue and package cash are counted once in their respective schedules.
Current native attachments and financial-statement cell links have not been inspected.
06Scenarios and DashboardOperating assumptions
Scenarios and Dashboard
Scenario purpose: Current seller material presents scenario analysis and a dashboard, and both tabs are visible. The web illustration compares price and completed-session sensitivities at the same paid staffing.
Inputs
Base and changed realized hourly yield
Completed sessions within the offered calendar
Unchanged fixed roster and recurring overhead for the sensitivity
Slower attendance and reserve stress
Outputs
Base and adverse operating results
Capacity-constrained break-even checks
Monthly ramp and cash-reserve comparison
Scope and limitations
Cases are assumptions, not probabilities or national outcomes.
A different timetable, staffing step or service mix requires new costs and cannot rely on fixed-roster sensitivities.
Seller-described dashboard measures and returns do not certify this project valuation or owner cash.
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.
Personal Training Business input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Realized revenue per completed 60-minute session
$100.00
$80.00 – $110.00
Revenue per sold unit
Completed 60-minute sessions per day across both trainers
10
6 – 12
Daily throughput in the stated operating scope
Operating days per week
5
4 – 5
Trading schedule
Fixed operating costs / month
$18,504
Held constant
Operating break-even threshold
Contribution margin
95.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
45.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 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
6
$12,990
$19,478
Not reached
Base volume
10
$21,650
$19,478
Month 10
Higher volume
12
$25,980
$19,478
Month 7
Only completed 60-minute sessions per day across both trainers changes. Realized revenue per completed 60-minute session: $100.00; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-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
$188.4k
Year 1
$259.8k
Year 2
$259.8k
Year 3
$294.4k
Year 4
$302.9k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Leasehold, flooring, electrical and access work$25,000
Strength equipment, benches, weights and storage$20,000
Lease deposit and pre-opening occupancy$7,500
Professional, permit, credential and insurance setup$6,000
Booking, website, security, reception and payment setup$4,000
Pre-opening payroll, staff training and launch marketing$9,500
Construction and opening contingency$8,000
Operating cash reserve$65,000
One-time budget: $145,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $259,800.
Payment fees and session-linked supplies$12,990
Owner, employee, employer costs and absence cover$156,048
Premises, systems, marketing and operating overhead$66,000
EBITDA$24,762
EBITDA margin: 9.5%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
9
Break-even revenue / month
$19,478
Base revenue / month at maturity
$21,650
First operating break-even
Month 10
Units mean completed 60-minute sessions per day across both trainers. The ramp covers 24 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
$188,355
$188,355
Year 1 operating result
−$43,111
−$43,111
Year 2 revenue
$259,800
$259,800
Year 2 operating result
$24,762
$24,762
Year 3 revenue
$259,800
$259,800
Year 3 operating result
$24,762
$24,762
Year 3 / full-volume annual revenue
$259,800
$259,800
Year 3 / full-volume annual operating result
$24,762
$24,762
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 personal training business 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 Personal Training Business 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 Revenue, COGS & OPEX, Payroll, CAPEX and Capital, IS, CF and BS, Scenarios and Dashboard 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 realized revenue per completed 60-minute session, completed 60-minute sessions per day across both trainers, 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.
