Healthcare Pro Forma Template

Start with the Assumptions sheet. The most important inputs are your payer mix percentages and your contracted reimbursement rates by payer class — these two variables drive more of the financial outcome than any other. If you're modeling an existing practice, pull your last 12 months of explanation of benefits statements to calculate your actual contracted rates and collection percentages by payer. If you're projecting a startup practice, use your specialty's Medicare fee schedule as a baseline and model commercial rates at 110–140% of Medicare depending on your market and specialty. Set your visit volume assumptions conservatively for year one — most new practices build to full panels over 12–18 months, and credentialing delays alone can push the first commercial insurance payment out 90–120 days from opening.

Once Assumptions are set, review the AR & Collections sheet carefully. The gap between gross charges and collected revenue is one of the most misunderstood aspects of medical practice finance, and it's where many practice pro formas are overstated. Enter your expected clean claim rate (95%+ is achievable with good billing processes; 80–85% is common without dedicated billing staff), your first-pass denial rate by payer, and your days-in-AR target. These inputs will make your cash flow projection materially different from a naive model that assumes revenue equals collections. Then move to Operating Expenses and enter your actual or quoted staffing costs — physician compensation in particular needs to reflect your specialty's benchmark (the MGMA Physician Compensation and Production Survey is the standard reference), or the model will not be credible to lenders with healthcare experience.

Use the 5-Year P&L and Cash Flow sheets for SBA financing applications, hospital partnership negotiations, or private equity conversations. Healthcare lenders and PE firms evaluate practices on overhead rate (costs as a percentage of collections — should be under 55–60% for most specialties), net collection rate (the billing efficiency benchmark — under 90% raises questions), and revenue per provider. Run the Break-Even Analysis before any lender meeting and know your break-even visit volume per provider per day — it is almost always the first operational question a healthcare-experienced lender asks, and answering it with a specific number tied to your actual payer mix and cost structure demonstrates credibility that generic financial projections don't provide.

Medical practice finance is fundamentally different from most other businesses because revenue is determined not by what you charge, but by what payers have agreed to pay — and because cash arrives weeks to months after services are delivered. A practice billing $500,000 in gross charges per month might collect $350,000 net, and that $350,000 might not arrive in the bank until 45–60 days later. This combination of contractual revenue adjustments and AR lag means that a practice can be clinically busy, fully staffed, and still run negative cash for months — which is why pro forma financial projections are essential for any new practice launch, expansion, or financing event. The model has to be built around net collected revenue, not gross charges, and it has to model cash timing explicitly.

The financial metrics that define practice health are net collection rate (the percentage of allowed charges actually collected — 90–95% is the target; below 85% indicates a billing problem), overhead rate as a percentage of net collections (under 55–60% for most specialties, though primary care typically runs higher), days in accounts receivable (under 30 for best-in-class practices; 45–60 days is typical), and revenue per physician FTE (varies widely by specialty — primary care averages $250,000–$400,000 in collections per physician; surgical specialties often $600,000–$1.5M+). Physician compensation typically represents 20–35% of total collections for employed physicians on productivity-based contracts, with wRVU-based compensation being the most common structure. Understanding these benchmarks is what separates a credible healthcare pro forma from one a lender will discount.

For new practices, the three biggest financial planning mistakes are underestimating credentialing timelines (commercial insurance credentialing routinely takes 90–180 days, during which you can see patients but cannot bill commercially), underestimating the working capital required to fund AR before cash flow turns positive (most new practices need 4–6 months of operating expenses in reserve before collections stabilize), and overestimating payer mix by assuming too high a percentage of commercial patients relative to Medicare and Medicaid. This template models all three explicitly: credentialing delay scenarios are built into the ramp schedule, the cash flow projection shows cumulative cash position month by month including the AR build-up period, and the revenue model requires you to commit to a specific payer mix percentage that flows through every projection.