Dental Practice Pro Forma Template

Start with the Assumptions sheet. Enter your projected patient volume by appointment type, your average fee or production per procedure category, and your payer mix — what percentage of your patients will be PPO, fee-for-service, or Medicaid. If you're buying an existing practice, use the seller's production and collections history as your starting point and adjust for planned changes. If you're starting from scratch, research the demographics and insurance penetration in your target market to build realistic assumptions. Getting the payer mix right is especially important — a practice that's 80% PPO will collect significantly less per procedure than one that's 60% fee-for-service, and that difference flows through every projection in the model.

Once your assumptions are set, review the Patient Volume Projections and Revenue sheets to check whether the ramp-up schedule looks realistic. New dental practices typically add 20–40 new patients per month in Year 1 through a combination of online advertising, referrals, and community outreach. The Revenue sheet will show you how production and collections grow as your patient base builds. Use the Break-Even Analysis to check your daily production target — a solo general dentist typically needs $1,500–$2,500 in daily production to cover overhead, and this target should be achievable within 6–9 months of opening. If the break-even looks out of reach under your assumptions, adjust your fee schedule, payer mix, or overhead inputs before you commit to the space.

When you're ready to share the model with a lender, the Pro Forma Income Statement and Startup Costs sheets are the pages most reviewers will focus on. Dental practice lenders — including Bank of America Practice Solutions, TD Bank, and most SBA-approved lenders — have seen thousands of dental pro formas and will immediately check whether your overhead ratios fall within industry norms. If your supplies, lab fees, or staff costs are projected above industry benchmarks, be prepared to explain why. Export those sheets as PDFs or send the full .xlsx file. Lenders who can see your formulas and trace your assumptions build confidence faster than those handed static PDFs with no supporting detail.

Opening or buying a dental practice is one of the largest financial decisions a dentist will make — and unlike most small business acquisitions, the numbers are relatively predictable if you model them correctly. A de novo startup typically requires $300,000 to $600,000 in startup capital before a single patient walks through the door. An acquisition typically trades at 60–80% of annual collections for a solo general practice. In both cases, banks and SBA lenders will not approve financing without a detailed 3-year pro forma, and the quality of that document often determines not just approval but also loan terms.

Dental practice finances have a structure unlike most small businesses. Revenue is driven by procedure mix and payer mix, not just volume. A practice seeing 40 new patients per month that's heavily weighted toward PPO insurance may collect the same as a practice seeing 25 new patients per month that's primarily fee-for-service — because PPO write-offs often reduce gross production by 25–40%. Understanding your net collection rate by payer type is the foundation of any accurate dental pro forma. On the expense side, three categories dominate: staff compensation (typically 25–30% of collections), dental supplies (5–7%), and lab fees (7–10%). Total overhead should target 59–65% of collections, leaving a 35–41% operating margin for the practice owner — which is strong compared to most small businesses but must be sustained through disciplined purchasing and payer contract management.

The most useful thing a dental pro forma does is force you to stress-test the economics before you're committed. What happens to your breakeven if you're 20% below your projected production in Year 1? Can the practice service its debt if PPO reimbursements continue to decline 2–3% annually? What does adding a second hygienist do to your collections and overhead ratio? This template is built to answer those questions directly — not just produce a best-case projection for a loan package, but serve as a working model you can return to as assumptions change and actuals come in.