$0.00

Medical Tourism Financial Model Template for Excel and Google Sheets

Five-year projections. Three scenarios. Every statement. One Excel file.
  • Fully Editable
  • Instant Download
  • Professional Design
  • Pre-Built
  • No Expertise Is Needed

This Medical Tourism Financial Model is an Excel planning template for an Atlanta-based agency that coordinates overseas treatment travel for self-pay U.S. residents. Revenue is driven by qualified enquiries, completed-case conversion, treatment-purpose mix, and a separate coordination fee for each completed case.

Patients pay clinics, airlines, hotels, and other treatment or travel providers directly, so the model focuses on agency fees and the operating cost structure required to manage those cases. The documented industry-specific operating forecast runs from 2026 through 2030 and ends at EBITDA; the broader workbook also contains financial statements and analytical reports.

Forecast
5
years
Case types
5
revenue categories
Scenario cases
3
Low Base High
MODEL STRUCTURE

What Is Included in the Medical Tourism Model

The workbook links editable operating assumptions to monthly calculations, annual financial projections, funding schedules, and decision-focused reports.

Revenue & monthly calculations

Revenue inputs define enquiries, conversion, launch timing, case mix, and coordination fees. Revenue and Calc translate these assumptions into monthly completed cases and fee revenue by treatment-purpose stream.

Costs & staffing

COGS & OPEX separates foreign liaison contractors, interpreting, patient acquisition, processing, service recovery, and fixed overhead. Payroll models U.S. staffing by role and FTE.

Funding & investment

CAPEX, CapTable, Debt, Sources & Uses, and Cash Flow connect opening investment, equity, optional financing, capital spending, and liquidity analysis without treating startup funding as operating revenue.

Statements & analysis

Income Statement, Cash Flow, Balance Sheet, Summary, Scenarios, Returns, Valuation, Ratios, DuPont, Charts, Benchmarks, and top-revenue and expense reports support management review.

REVENUE FORECAST

How the Model Calculates Medical Tourism Revenue

The demand-based revenue engine multiplies qualified enquiries by completed-case conversion, assigns each completed case once across five exclusive case types, and applies the relevant coordination fee.

Qualified enquiries increase from 100 per month in 2026 to 200 in 2030, while conversion rises from 8% to 12%. That produces planning averages of 8, 11.7, 16, 19.8, and 24 completed cases per month before the case mix is allocated.

Revenue engine
Qualified enquiries × completed-case conversion × case-type share × coordination fee = agency fee revenue.

Revenue Forecast

The Revenue Forecast shows the operating assumptions behind case volume, mix, and coordination fees. It lets a buyer test how changes in enquiries, conversion, or treatment-purpose mix flow through to annual agency revenue.

Selected coordination fees are $1,500 for dental, $2,500 for cosmetic, $2,800 for bariatric, $3,500 for orthopedic, and $3,000 for fertility. Dental, cosmetic, bariatric, and orthopedic use 30%, 25%, 20%, and 15% shares; fertility is the residual share.

COST STRUCTURE

How Direct Costs, Overhead, and Payroll Feed EBITDA

The model separates percentage-based direct costs and variable operating expenses from monthly fixed overhead and salaried U.S. personnel.

COGS & Operating Expense Forecast

The COGS & Operating Expense Forecast models foreign liaison contractors and interpreting as direct costs, then adds patient acquisition, card processing, service recovery, and recurring fixed overhead to show the operating cost base.

Direct costs are 12% of revenue for foreign liaison contractors and 3% for translation and interpreting. Variable operating expenses add 10% for patient acquisition, 3% for card processing, and 1% for disputes and service recovery.

Fixed costs cover office access, secure records and software, phones, insurance, legal and privacy support, bookkeeping, provider diligence, training, supplies, and maintenance. The example office and meeting access input is $800 per month for 12 paid months.

Payroll Forecast

The Payroll Forecast shows staffing FTE and annual base pay by role. The case uses one owner-manager, patient coordinators that rise from 1.0 to 3.0 FTE, and client administration that rises from 0.25 to 0.75 FTE.

Annual base pay is $65,000 for the owner-manager, $55,000 per patient coordinator FTE, and $48,000 per client-administrator FTE. Employer taxes and benefits are excluded under the documented scope, and foreign service vendors are not duplicated in payroll.

STARTUP & FUNDING

How Opening Investment Is Kept Separate from Operations

Startup assets, one-time opening cash items, and owner funding are modeled separately from recurring operating expenses and EBITDA.

Startup assets include $6,000 for four secured workstation bundles, $2,500 for office furnishings, and $1,500 for network and backup equipment. Separate opening cash items cover privacy setup, website and CRM configuration, launch marketing, provider diligence visits, training, and an office deposit.

Capital Expenditure Plan

The Capital Expenditure Plan records asset purchases and depreciation timing. It keeps opening equipment and furnishings distinct from recurring operating expenses so investment spending can flow correctly into the financial statements.

The documented initial owner funding input is $102,921.60, based on startup assets, one-time opening cash payments, and three months of first-year recurring operating outflows. This is a planning reserve, not a tested statement of peak cash need.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles funding sources with operating, investment, financing, and retained-cash uses. It helps distinguish owner equity and optional debt from revenue generated by the agency.

ILLUSTRATIVE FORECAST

What the 2026–2030 Operating Forecast Shows

In the documented base case, higher monthly case volume raises agency revenue faster than operating expenses, moving EBITDA from negative in 2026 to positive from 2027 onward.

Illustrative annual forecast, USD
YearRevenueOperating ExpensesEBITDA
2026$236,160$253,286-$17,126
2027$345,384$324,461$20,923
2028$472,320$388,773$83,547
2029$584,496$448,804$135,692
2030$708,480$524,259$184,221

Amounts are illustrative projections and rounded to whole dollars for display.

The 2026 operating loss reflects the initial staffing and overhead base before enquiry volume and conversion have scaled. By 2030, revenue reaches $708,480 while total operating expenses reach $524,259 in the documented example.

EBITDA is not net profit or cash
The industry-specific brief ends at EBITDA. Use the workbook’s Income Statement, Cash Flow, and Balance Sheet to examine depreciation, financing, tax, liquidity, and financial position rather than inferring those from EBITDA alone.

Cash Flow Forecast

The Cash Flow Forecast tracks operating, investing, and financing cash movements with an opening-to-closing cash reconciliation. It is the report to review for liquidity and funding requirements rather than treating EBITDA as cash generated.

RETURNS & DECISIONS

How the Model Supports Break-Even, Payback, and Return Analysis

The workbook provides separate tools for operating break-even, cash break-even, investment payback, annual ROIC, scenarios, and valuation without assuming a return result that is not documented in the case inputs.

Return on Invested Capital Analysis

The Return on Invested Capital Analysis combines sales break-even, cash break-even timing, investment payback, and annual ROIC. These measures answer different questions about operating coverage, cash recovery, and returns on invested capital.

Scenario Controls on the Dashboard apply Low, Base, and High multipliers to revenue, COGS, variable operating expenses, fixed expenses, and payroll. This makes it possible to test how weaker conversion or higher operating costs affect margins and EBITDA before relying on a single plan.

Financial Scenario Analysis

The Financial Scenario Analysis compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA. It helps evaluate how operating assumptions change profitability across the forecast period.

Valuation can estimate enterprise and equity value from discounted unlevered free cash flow and a terminal valuation multiple, while Debt controls can model optional facilities. No borrowing terms, valuation result, payback month, or ROIC percentage is assumed here because none is specified in the case brief.

MODEL FIT

Who This Excel Financial Model Is Built For

The template fits a medical tourism facilitator that earns coordination fees while patients pay treatment and travel suppliers directly.

It is especially useful when planning depends on enquiry volume, conversion, case mix, coordination fees, foreign liaison costs, interpreting, digital acquisition, U.S. staffing, startup investment, and liquidity. The structure can be edited when the buyer’s operating assumptions differ from the illustrated Atlanta case.

FAQ

Frequently Asked Questions

Key buying questions about the scope and mechanics of this medical tourism financial model.

What drives revenue in this model?

Revenue comes from qualified enquiries, completed-case conversion, exclusive case mix, and the coordination fee assigned to each completed case.

Does the model include treatment or airfare revenue?

No. Patients pay clinics, airlines, hotels, and other providers directly; the agency earns its separate coordination fee.

Can I change staffing assumptions?

Yes. Payroll inputs support role-based FTE, salaries, hiring and termination dates, bonuses, payroll tax, salary growth, and annual staffing plans.

Does the model include cash flow and a balance sheet?

Yes. The workbook includes projected Cash Flow and Balance Sheet reports in addition to the operating EBITDA forecast described in the case brief.

Are the displayed forecast numbers historical results?

No. They are illustrative projections based on the documented planning assumptions and should not be treated as observed industry results or averages.

Does positive EBITDA mean the business is profitable after tax?

No. EBITDA excludes depreciation, interest, tax, investing, and financing effects, so the broader financial statements must be reviewed separately.

Can the workbook test different scenarios?

Yes. Dashboard Scenario Controls provide Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed expenses, and payroll.

What Does the Medical Tourism Financial Model Contain?

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

Sources & Uses

Funding sources, spending, and closing cash.

Returns & Break-Even

Cash break-even, payback, and ROIC.

Business Valuation

DCF valuation and sensitivity analysis.

Expense Breakdown

Largest costs and spending trends.

Financial Summary

Annual and monthly financial performance.

KPI Benchmarks

Compare margins and returns to benchmarks.

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

Hours Back on Forecasting

Megan Carter, FL

5 star rating

Building the model by hand used to eat whole afternoons, but this template cut my setup time by nearly two days. I was able to move straight into assumptions and send a draft to my partner the same week.

One Broken Cell, No Panic

Dylan Foster, CA

5 star rating

I used to worry that one bad formula would throw off the whole sheet. This model kept the calculations consistent, and I caught issues fast instead of rebuilding everything from scratch.

Everything In One Place

Laura Bennett, NY

4 star rating

My statements and charts were scattered across different files, which made reviews messy. This template brought the P&L, cash flow, and dashboard together, so I booked an investor meeting with a cleaner story.