10 Year Financial Model for Hair Salon / Barbershop

SmartHelping / Salon & Barbershop / Business Planning

Hair Salon & Barbershop Financial Model

Plan up to 10 years of salon operations across services and product sales. Build the revenue mix, test Low / Base / High scenarios, and connect operating costs, startup investment, financing, and exit assumptions with projected cash flow and returns.

Up to 10 years3 income streamsLow / Base / High casesIRR & break-even analysis
Hair salon and barbershop illustration
$75One-time purchase / Excel download
Add Hair Salon Financial Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

Video walkthrough & spreadsheet preview

See the salon forecast from inputs to returns.

Review the revenue assumptions, scenario controls, financial reports, and executive summary. Open the screenshots to explore the workbook layout.

Open the model screenshots

Preview the operating assumptions, forecast reports, and investment summary.

Multiple streams with item-level detail

Build a revenue mix that matches your salon.

The model separates haircuts, other services, and products. Enter an average service price or product gross profit per unit, an offering start month, and a monthly sales count for each forecast year.

10 haircut types

Set an average price and forecast monthly sales volumes for each haircut type, with separate volume assumptions for years 1 through 10.

13 other-service lines

Plan additional services such as waxing, manicures, and massage, with an average price, start month, and monthly sales count by year for each line.

13 product lines

Enter gross profit per unit and monthly unit sales by forecast year for retail products, including the template's shampoo, conditioner, skin care, and nail care examples.

Flexible launch timing

Start different offerings at different times. You can also switch off any of the three income streams from the central controls.

Low / Base / High scenario planning

Compare different operating expectations.

Each of the three income streams has its own Low / Base / High selector, adjustment magnitude, and On / Off control. Set the streams independently and review the changes in the forecast and investment outputs.

Use these controls to compare different combinations of haircuts, other services, and product sales from one place.

How product sales enter the forecast

Enter product gross profit per unit.

The product section uses the amount retained after the product's acquisition cost. That gross profit contribution feeds the model's revenue totals alongside service revenue. Keep this basis in mind when reviewing total revenue and the revenue-based exit valuation.

From startup spending to ongoing cash flow

Bring the cost and funding plan into the forecast.

Connect the operating plan with the costs of opening and running the salon, along with any business financing.

Fixed & variable operating costs

Set monthly running costs and their start months, including worker costs and overhead. Five variable-cost lines can be entered as percentages of the model's total revenue.

Startup investment

Enter initial costs such as construction, chairs, equipment, tools, and other setup expenses when evaluating the cash needed to get started.

Capital expenditures

Schedule capital spending by month, including equipment upgrades or other one-time investments, and follow its effect on cash flow.

Debt financing

Set the financing amount, rate, term, payments per year, and first-payment date on the Control tab. The debt schedule feeds the forecast summaries automatically.

Monthly, annual & executive reporting

Review the detail and the overall investment case.

Use the detailed reports to understand the operating mix, then use the executive summary to evaluate the resulting cash flow and returns. Included charts show revenue, expenses, EBITDA, revenue by stream, and monthly versus accumulated cash flow.

Monthly & annual P&L

Review individual revenue line items within each income stream, along with the more detailed expense and profitability forecast.

Before-tax cash flow summary

Follow revenue, expenses, EBITDA, capital expenditures, debt service, financing proceeds, loan repayment, exit value, and annual cash flow before tax.

IRR & ROI measures

The executive summary reports internal rate of return, ROI as a percentage, simple annualized ROI, and average annual net cash returns.

Break-even timing

Review the model's break-even month and year alongside the capital needed and cash returned over the forecast.

Discounted cash flow & NPV

The Annual P&L includes a discounted cash flow section with an input discount rate and a net present value output.

Debt service coverage & loan detail

Review DSCR alongside the forecast, and use the financing schedule to see interest, principal payments, and the remaining loan balance.

Choose your holding period

Model an exit before the full 10 years.

Select an exit month to evaluate a shorter period, such as three or five years. Enter an exit valuation based on a percentage of annual revenue.

If debt remains at exit, the model assumes that the outstanding loan balance is repaid in that month.

A practical planning workflow

Build the base case, then compare alternatives.

  1. Define the revenue mix

    Set up the service and product offerings you plan to sell, with the relevant operating assumptions and start dates.

  2. Add costs, financing, and exit assumptions

    Enter the business's operating costs, startup investment, capital spending, debt assumptions, and planned exit timing.

  3. Compare scenarios and returns

    Use the Low / Base / High cases and income-stream switches to review how different plans affect cash flow, break-even timing, and investment returns.

Also included in a bundle

Explore more industry-specific financial models.

This model is included in the Industry-Specific Financial Model Bundle. Browse the collection for other business forecasts built from their operating assumptions.

Questions before you buy

A few useful details.

Who is this model designed for?

It is designed for planning a hair salon or barbershop, with separate income streams for haircuts, other services, and product sales. The input layout includes 10 haircut types, 13 other-service lines, and 13 product lines.

Do I need to use all three income streams?

No. You can manually switch off any of the three income streams from the central controls.

Can different offerings start at different times?

Yes. The model supports different start timing for the offerings within the revenue streams.

How does scenario analysis work?

Each income stream has its own Low / Base / High setting, adjustment magnitude, and On / Off control. The forecast updates from those selections.

Do product inputs use the retail selling price?

Enter gross profit per unit in the product section. That product contribution is included alongside service revenue in the model's reported revenue total.

Are the cash flow projections before or after tax?

The forecast reports cash flow before tax. Its executive summary also includes IRR, ROI, and average annual cash return measures.

Can I forecast for fewer than 10 years?

Yes. Use the exit month to evaluate a shorter holding period within the 10-year model.

How are financing and loan repayment handled?

Enter the loan assumptions on the Control tab. The debt schedule feeds the forecast summaries, and any outstanding balance is assumed repaid in the exit month.

What reports are included?

The model includes detailed monthly and annual P&L reports and an executive summary with before-tax annual cash flow, IRR, ROI measures, and break-even timing. A discounted cash flow and NPV section is included in the Annual P&L.

How much does the template cost?

The one-time price is $75 for the Excel download, available immediately after purchase. It is also included in the Industry-Specific Financial Model Bundle linked above.

Plan your salon or barbershop

Connect the service mix with cash flow and returns.

Get the Hair Salon Financial Model. Have a question? Contact SmartHelping.

Get the Hair Salon Financial Model

Financial Model for a Gym/Fitness Center Startup

SmartHelping / Gym & Fitness Center / Excel

Gym & Fitness Center Financial Model

Build a 10-year financial plan for opening and operating a gym. Connect membership capacity, monthly fees, equipment investment, and operating costs with funding needs, three financial statements, and projected investor returns.

Up to 10 years Membership & capacity planning Integrated 3 statements IRR, NPV & investor returns
Modern fitness center with strength equipment, free weights, and treadmills
$75 One-time purchase / Excel download
Add Gym Financial Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

Video walkthrough & spreadsheet preview

See how the gym forecast comes together.

Explore the model's assumptions, operating forecast, financial reports, and investment analysis. Open the screenshots below for a closer look at the workbook.

Open the model screenshots

Preview the model's inputs, financial statements, charts, and executive summary.

From opening day to target membership

Build revenue from capacity and membership fees.

Set a maximum member count, the share of that capacity reached at launch, and a monthly ramp toward the target. The model connects projected membership with your monthly pricing assumptions.

Membership capacity

Use the station and simultaneous-user planning table to explore capacity estimates, then enter the maximum membership target you want to use in the forecast.

Opening membership

Choose the revenue start month and the initial percentage of your membership target. This establishes the starting member count when the gym begins earning revenue.

Monthly membership ramp

Set the monthly increase in capacity attained for each forecast year. Membership builds toward the chosen maximum, with capacity attained capped at 100%.

Pricing by forecast year

Enter a monthly membership fee for each of the 10 forecast years. Revenue follows the projected number of members and the fee applicable to that year.

How membership growth works

A clear ramp toward your capacity target.

The monthly growth assumption adds percentage points to the share of capacity attained. For example, starting at 20% with a 2% monthly improvement moves the forecast to 22%, then 24%, until the target is reached.

The capacity planning table is a guide. Enter your chosen maximum member count in the revenue assumptions to apply it to the forecast.

Opening costs & ongoing operations

Plan the investment behind the gym.

Bring equipment purchases, opening expenses, staffing budgets, and recurring overhead into the same financial forecast.

46 operating-cost lines

Budget monthly costs by forecast year and set individual start dates. Customize the descriptions for payroll, rent, utilities, maintenance, insurance, and other running costs.

16 startup-cost lines

Itemize the expenses required to get the business ready to operate, alongside the separate schedule for capital assets.

78 capital-asset entries

Schedule equipment and other capital investment using cost, expenditure date, and useful life. The CapEx schedule calculates straight-line depreciation and tracks asset book values.

Property & equipment planning

The capital schedule includes a dedicated building/property entry and a separate building sale-value assumption. Budget rent in running costs when planning a leased location.

Debt, equity & the holding period

Connect the operating plan with its funding.

Review the cash needed to launch and sustain the business, then evaluate how financing and an optional exit affect the investment.

Debt financing

Enter the loan amount, interest rate, term, payment frequency, and first-payment date. Follow interest expense, principal repayments, and the remaining balance through the debt schedule.

Equity requirement

Review the projected funding requirement after bank financing. The model uses the peak cumulative cash deficit to help estimate the equity needed for the plan.

Cap table & distributions

Enter contributions and share allocations to review fully diluted ownership, annual distributions, and individual investment returns. The model assumes the main equity funding is contributed upfront.

Taxes & optional exit

Set income and capital-gains tax assumptions. Choose an end month within the 10-year forecast and optionally include a business exit value based on trailing 12-month EBITDA and an input multiple.

Monthly detail & investment reporting

Review the business from cash flow to investor returns.

Use the detailed forecasts to understand the operating plan, then review the executive summary and charts to assess the overall investment case.

Integrated financial statements

Review monthly and annual income statements, balance sheets, and cash flow statements linked to the model's operating and financing schedules.

Executive summary

Follow annual revenue, year-end membership, EBITDA, taxes, capital expenditures, debt service, cash flow, funding needs, and cash returned.

Project, investor & owner returns

Evaluate annual IRR, equity multiples, and ROI for the project and the investor/owner interests. Review discounted cash flow and NPV using separate input discount rates.

Operating & financing metrics

Review membership capacity attained, EBITDA per member, and debt service coverage alongside the forecast to understand the economics of the gym.

Membership & performance charts

Visualize membership and capacity attained, revenue, expenses, EBITDA, EBITDA per member, and debt service coverage.

Cash flow charts

Compare monthly and accumulated cash flow, and review the projected cash flows attributable to investors and owners.

Optional business sale

Evaluate the effect of an exit.

Turn terminal value on to estimate a business sale from trailing 12-month EBITDA multiplied by your chosen exit multiple. The model includes asset-sale allocation and a separate building sale-value input.

When terminal value is enabled, the remaining loan balance is repaid at exit. You can also turn terminal value off to review the forecast without a modeled business sale.

A practical planning workflow

Build your gym's financial plan.

  1. Define capacity, launch timing, and pricing

    Set the maximum member target, starting membership, monthly capacity ramp, and membership fee for each forecast year.

  2. Budget the opening and ongoing operations

    Add startup expenses, capital assets, running costs, loan assumptions, equity ownership, and the planned holding period.

  3. Review funding needs and returns

    Use the financial statements, executive summary, and charts to evaluate the plan. Adjust the assumptions to explore different membership ramps, prices, costs, or exit values.

Also included in bundles

Explore the broader model collections.

This model is included in the Industry-Specific Financial Model Bundle and the Hospitality Financial Models Bundle.

Questions before you buy

A few useful details.

Who is this model designed for?

It is designed for planning the opening and operation of a single gym or fitness center with monthly membership revenue. Use it to connect membership assumptions with equipment investment, operating costs, financing, cash flow, and investment returns.

How long is the forecast?

The model includes up to 10 years of monthly and annual projections. Set the end month to evaluate a shorter operating or holding period.

Does the model forecast member churn or separate membership tiers?

The included revenue engine uses a maximum member count, a starting capacity percentage, a monthly ramp toward that target, and one monthly membership fee for each forecast year. Separate churn, membership-tier, class, or personal-training revenue schedules would require customization.

Does the station calculator automatically set the member target?

No. It provides estimates to help with planning. Enter the maximum member count you choose in the revenue assumptions to use that target in the forecast.

Can I plan equipment purchases and depreciation?

Yes. The capital schedule includes 78 asset entries, including a dedicated building/property row. Enter each asset's cost, expenditure date, and useful life to project capital spending, straight-line depreciation, and book value.

Can I model a leased gym location?

Yes. Budget lease payments in running costs and enter the equipment and capital improvements relevant to your plan. Use a building purchase and sale assumption only when it applies to the investment you are modeling.

Are all three financial statements included?

Yes. The workbook includes integrated monthly and annual income statements, balance sheets, and cash flow statements, along with detailed operating forecasts, an executive summary, charts, and return analysis.

Are taxes included?

Yes. The model includes income-tax and capital-gains-tax inputs and incorporates modeled taxes into cash flow. The applicable assumptions should be set for the business and transaction you are evaluating.

Can I include a business sale?

Yes. Enable terminal value and enter an EBITDA multiple to calculate a business exit value from trailing 12-month EBITDA. The model also includes asset-sale allocation and a separate building sale-value assumption. With terminal value enabled, outstanding debt is repaid at exit.

What do I receive after purchasing?

The one-time price is $75 for the Excel workbook, available immediately after purchase. The walkthrough and screenshot preview above show the model, and the bundle links provide other purchasing options.

Plan your gym or fitness center

Connect membership growth with cash flow and returns.

Get the Gym & Fitness Center Financial Model. Have a question? Contact SmartHelping.

Get the Gym Financial Model

IRR Based Investment Comparison Model in Excel

SmartHelping / Investment Analysis / Excel

IRR-Based Investment Comparison Model in Excel

Compare up to 19 projects using their initial investment, projected cash flows, and timing. Set a required return and review individual project IRRs alongside the consolidated return across your investments.

Up to 19 projects Up to 20 years Date-based XIRR Comparison dashboard
Blue comparison bars with gold dollar symbols representing investment analysis
$45 One-time purchase / Excel download
Add IRR Comparison Model to Cart

Immediate download after purchase. By purchasing, you agree to the Terms of Service.

Video walkthrough & workbook preview

See how project cash flows become comparable returns.

Watch the input process and review the dashboard, project-level IRRs, required-return comparison, and consolidated result.

Open the model screenshots

Preview the workbook before entering your own project assumptions.

Compare projects in one place

Bring investment timing and return targets into the same review.

Built for CFOs, project managers, business owners, and investors evaluating projects with an initial cash outlay and expected future cash inflows.

Up to 19 project comparisons

Review individual project IRRs together on a dashboard, with a forecast timeline extending up to 20 years.

Required-return screening

Enter your required rate of return. The dashboard compares projected IRRs with that target and displays an approve/reject result, supported by a comparison chart.

Different start and end dates

Projects do not need identical timing. The workbook combines XIRR with dynamic cash-flow ranges based on each project's investment and cash-flow dates.

Consolidated investment return

Review the combined IRR across the projects, using a cash-flow timeline from the first investment outflow through the last projected inflow.

Three core input groups

Start with the cash going out and when it comes back.

Enter each project's investment and expected cash flows, then use the dashboard to compare the resulting return with your target.

  1. Set the investment amount and date

    Enter the initial cash required for the project and when that investment occurs.

  2. Enter expected net cash flows

    Set the projected cash flows from the investment and the date those cash flows are expected to begin.

  3. Define the end month and optional exit value

    Specify when the cash flows stop and include an exit value when applicable. Review the updated project IRR and consolidated result.

The value behind the dashboard

Compare projects even when their cash-flow periods differ.

The workbook selects the relevant cash-flow range for each project and passes that range into the XIRR calculation. This connects the return analysis to the dates you enter, while keeping the input process straightforward.

The approve/reject label reflects the required-return test. Use it to organize your comparison alongside the amount invested, timing, and underlying project assumptions.

Explore the SmartHelping collection

Need more than one template?

Questions before you buy

A few useful details.

How many projects can I compare?

The template supports up to 19 projects and a forecast timeline of up to 20 years.

Can projects have different investment and cash-flow dates?

Yes. Each project's dates determine the cash-flow range used in its XIRR calculation, so projects can begin and end at different times.

Can I include an exit value?

Yes. An exit value can be entered when applicable, alongside the month when the project's cash flows stop.

What does the approve/reject result represent?

It compares the modeled project's return with the required rate of return you enter. The result depends on your cash-flow and timing assumptions.

What is the price and file format?

The one-time price is $45 for the Excel template. The download is available immediately after purchase.

Compare the opportunities in front of you

Put project timing, cash flows, and return targets together.

Get the IRR-Based Investment Comparison Model in Excel. Have a question? Contact SmartHelping.

Get the IRR Comparison Model