Revenue & Calc
Adjust chairs, operating days, reserved blocks, utilization, launch timing, package prices and mix to build monthly activity and annual revenue.
Iv Hydration Financial Model Template in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The IV Hydration Therapy Financial Model is an Excel template for a physician-owned, cash-pay clinic in suburban Austin, Texas. It projects completed infusions, revenue and operating expenses through EBITDA for 2026–2030 using four staffed chairs in approximately 1,200 square feet.
Each reserved one-hour block includes intake, infusion, observation, charting and turnover. The example excludes mobile visits, insurance billing, NAD+, injections, retail sales and memberships, keeping its forecast focused on five clinic-based IV packages.
- Forecast
- 5years
- Treatment chairs
- 4shared capacity pool
- IV packages
- 5revenue categories
WORKBOOK CONTENTS
Edit Clinic Assumptions and Review Their Effects
The workbook connects editable operating assumptions with monthly calculations, financial statements and management reports.
COGS & OPEX and Payroll
Change supply percentages, acquisition spending, overhead, role FTEs and compensation to evaluate how the clinic’s cost structure affects EBITDA.
CAPEX, CapTable & Debt
Plan equipment purchases, owner contributions and financing schedules separately from operating earnings; debt controls describe facilities only when entered.
Dashboard, Summary & Checks
Select scenarios, review combined reporting and inspect reconciliation or negative-cash alerts before using the model for funding discussions.
CAPACITY AND PRICING
Revenue Follows Chair Utilization and Package Mix
The revenue forecast converts available chair blocks into completed infusions and allocates each infusion once to an IV package.
Four chairs × 26 treatment days × eight daily blocks provide 832 available blocks per month. Completed utilization is 25%, 35%, 45%, 55% and 60% in successive forecast years; no second demand or staffing cap is added.
| IV package | Price per infusion | Share of infusions |
|---|---|---|
| Basic hydration | $99 | 25% |
| Myers-style vitamin | $199 | 30% |
| Immune support | $199 | 20% |
| Recovery | $189 | 15% |
| Performance | $179 | 10% residual |
Estimated planning inputs; the residual Performance share brings the allocation to 100%.
Revenue Forecast
The Revenue Forecast links chair capacity, utilization, package mix and prices to annual sales. Prices and mix stay constant in this example, producing a $170.50 weighted price per infusion; growth comes from using more of the same chair capacity.
2026 capacity-to-revenue calculation
4 chairs × 26 days × 8 blocks × 25% = 208 monthly infusions; 208 × $170.50 = $35,464 monthly revenue; $35,464 × 12 = $425,568 annual revenue.
The January 31, 2026 launch setting counts January as a full operating month under this model’s convention. Revenue is zero before the selected launch month, and annual results sum the applicable monthly calculations.
OPERATING COST STRUCTURE
Fixed Staffing Drives the Clinic’s Operating Costs
Annual payroll of $544,800 is the largest operating cost and remains fixed throughout the illustrated forecast.
COGS and Operating Expenses
The COGS and Operating Expenses report separates revenue-based supplies and variable costs from monthly overhead. Displayed COGS inputs are approximately 19.35% for fluids/formulations and 5.28% for kits/disposables; payment processing is 2.8%, while patient acquisition declines from 7% to 5%.
Fixed overhead totals $100,800 annually, including occupancy at $4,000 monthly for 12 paid months. Other coverage includes utilities, insurance, clinical software, equipment service, waste and laundry, accounting and legal work, licenses and training, cleaning and security.
| Role | Average FTE | Annual base per FTE |
|---|---|---|
| Infusion registered nurses | 2.5 | $98,000 |
| Prescribing nurse practitioner | 1.3 | $132,000 |
| Medical director physician | 0.15 | $260,000 |
| Patient coordinator | 1.3 | $44,000 |
| Practice manager | 0.4 | $80,000 |
Annual-average FTEs are staffing equivalents, not individual employee counts.
Payroll Forecast by Staff Role
The Payroll Forecast shows staffing equivalents and fixed compensation by role. These assumptions let you test staffing changes independently of package supply costs while tracking their effect on personnel expense and EBITDA.
Each salary is counted once in Payroll and excluded from COGS, variable costs and fixed overhead. Employer taxes, benefits and personal taxes are excluded from this selected case, even though the standard workbook includes broader payroll controls.
STARTUP AND FUNDING
Separate Opening Investment From Operating Earnings
Estimated initial owner funding of $331,651 combines startup assets, separate opening payments, opening stock and a three-month operating reserve.
Selected assets include recliners at $10,000, infusion equipment at $10,000, leasehold improvements at $45,000 and furnishings at $6,000. Additional categories cover clinical IT, cold storage and emergency equipment; deposits, permits, preopening payroll, promotion and systems onboarding are separate startup cash items.
Sources and Uses of Funds
Sources and Uses of Funds reconciles funding sources and cash allocation over a selected period. Use it with CAPEX and CapTable to review how equipment, other opening payments and owner contributions affect the funding plan.
Working-capital controls are zero receivable days, zero payable days and 30 inventory days. They affect cash timing and stock requirements separately from EBITDA; no uncommitted financing is assumed.
ILLUSTRATIVE FINANCIAL PROJECTIONS
Annual EBITDA Turns Positive in 2030
The selected case reaches positive annual EBITDA as utilization rises to 60% while payroll and fixed overhead remain unchanged.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $425,568 | $792,138 | -$366,570 |
| 2027 | $595,795 | $847,774 | -$251,979 |
| 2028 | $766,022 | $901,708 | -$135,685 |
| 2029 | $936,250 | $953,939 | -$17,690 |
| 2030 | $1,021,363 | $976,863 | $44,500 |
Source projections rounded independently to whole dollars; displayed subtraction may differ by $1.
The 2030 EBITDA of $44,500 represents approximately 4.36% of revenue, following losses in 2026–2029. These are illustrative model outputs based on estimated assumptions, not observed clinic results or industry averages.
Cash Flow Forecast
The Cash Flow Forecast separates operating, investing and financing movements and reconciles opening to closing cash. Its function supports liquidity review, but the supplied case establishes numerical operating results only through EBITDA and does not demonstrate cash sufficiency.
BREAK-EVEN AND SCENARIOS
Evaluate Break-Even, Payback and Funding Choices
The Returns and scenario reports help evaluate operating thresholds and investment recovery without treating positive EBITDA as a payback result.
Break-Even, Payback and ROIC
The Returns report combines sales break-even, cash break-even timing, investment payback and annual return on invested capital. It provides distinct views of operating coverage, cash generation and investment performance; no numerical return outcomes are established by this case brief.
Sales break-even compares revenue with the level needed to cover operating costs; cash break-even examines when cash generation covers cash requirements. Investment payback tracks recovery through cumulative project free cash flow, while annual ROIC measures operating return relative to invested capital.
Financial Scenario Analysis
Financial Scenario Analysis compares Low, Base and High revenue, gross margin, contribution margin and EBITDA. Dashboard multipliers vary revenue, COGS, variable costs, fixed costs and payroll, helping test the clinic’s sensitivity to sales and expense changes.
Dashboard debt controls can schedule facility amounts, draw timing, interest and repayment through the Debt sheet. Available financing controls do not establish a committed loan, and positive EBITDA does not establish net profit or investment recovery.
PRODUCT QUESTIONS
Frequently Asked Questions About This Financial Model
Use these answers to assess the template’s operating scope, editable assumptions and financial interpretation.
Who is this financial model designed for?
It fits owners and advisers planning a physician-owned, cash-pay IV clinic with chair-based capacity and fixed clinical staffing, using the suburban Austin example as a starting case.
Can I change utilization, prices and package mix?
Yes, the Revenue inputs support these changes, with sold infusions allocated across one shared chair pool and Performance IV receiving the residual mix share.
Does it include mobile visits or memberships?
The documented case excludes mobile visits, memberships, insurance billing, NAD+, injections and retail sales; adding those activities requires adapting the revenue and cost assumptions.
Does the initial owner funding cover all losses?
Cash sufficiency has not been established: the opening contribution includes a three-month reserve, while the example has four years of negative EBITDA and may need additional funding.
Are the assumptions verified industry benchmarks?
No, the selected inputs are estimates for planning, and the forecast is illustrative; referenced background material does not independently validate those selections.
Are net profit, payback or valuation results provided here?
The supplied operating results end at EBITDA; declared workbook reports support further analysis, but this case does not establish net profit, cash break-even, payback, ROIC or valuation amounts.
What Does the IV Hydration Therapy 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
Scenario Planning Made Simple
I could finally work through low, base, and high cases without juggling separate sheets. It saved me hours and made the forecast easy to explain in one meeting.
No Advanced Excel Skills Needed
I’m not an Excel power user, so this template was a relief. The layout and formulas made the model easy to follow, and I had a clean draft ready the same afternoon.
Assumptions Stay Organized
The pricing, cost, and growth inputs are laid out clearly, so I wasn’t chasing numbers across tabs. That alone saved me a few hours and made my assumptions easier to review.