Financial Dashboard
KPIs, forecasts, and cash flow at a glance.

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.
The workbook links editable operating assumptions to monthly calculations, annual financial projections, funding schedules, and decision-focused reports.
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.
COGS & OPEX separates foreign liaison contractors, interpreting, patient acquisition, processing, service recovery, and fixed overhead. Payroll models U.S. staffing by role and FTE.
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.
Income Statement, Cash Flow, Balance Sheet, Summary, Scenarios, Returns, Valuation, Ratios, DuPont, Charts, Benchmarks, and top-revenue and expense reports support management review.
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.
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.
The model separates percentage-based direct costs and variable operating expenses from monthly fixed overhead and salaried U.S. personnel.
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.
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 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.
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.
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.
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.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 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.
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.
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.
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.
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.
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.
Key buying questions about the scope and mechanics of this medical tourism financial model.
Revenue comes from qualified enquiries, completed-case conversion, exclusive case mix, and the coordination fee assigned to each completed case.
No. Patients pay clinics, airlines, hotels, and other providers directly; the agency earns its separate coordination fee.
Yes. Payroll inputs support role-based FTE, salaries, hiring and termination dates, bonuses, payroll tax, salary growth, and annual staffing plans.
Yes. The workbook includes projected Cash Flow and Balance Sheet reports in addition to the operating EBITDA forecast described in the case brief.
No. They are illustrative projections based on the documented planning assumptions and should not be treated as observed industry results or averages.
No. EBITDA excludes depreciation, interest, tax, investing, and financing effects, so the broader financial statements must be reviewed separately.
Yes. Dashboard Scenario Controls provide Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed expenses, and payroll.
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.
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.
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.
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.