# Dental Practice Dashboard

See five-year dental practice collections, EBITDA, EBITDA margin, collection rate, production per visit, doctor productivity, visits, and service mix together clearly on one practice dashboard.

- Canonical: https://finamodel.com/excel-dashboard/dental-practice
- Excel download: https://finamodel.com/templates/dental-practice.xlsx

## About this dashboard

The Dental Practice Dashboard summarises a five-year operating forecast for a single-location practice. It highlights collections, EBITDA, EBITDA margin, collection rate, production per visit, doctor productivity, and Year 5 visits, giving the practice owner a compact view of operating performance and the drivers behind it.

Use the service-mix table to see Year 5 production across Hygiene, Restorative, Major, and Ortho. The dashboard connects visit volume and average ticket to gross production, then shows how the collection rate translates production into collections. This makes the relationship between service mix, production yield, and collected revenue easier to review.

The P&L underneath the dashboard accounts for doctor and hygienist compensation, lab fees, supplies, rent, admin payroll, other operating expenses, D&A, tax, and net income. Status labels can be driven by user-set thresholds for selected headline metrics, supporting acquisition diligence, service-mix review, and compensation analysis across the practice forecast.

## What's included

- Y5 collections
- Y5 EBITDA and EBITDA margin
- Collection rate
- Production per visit
- Doctor productivity and Y5 visits
- Y5 service mix

## Frequently asked questions

### What does the Dental Practice Dashboard show?

It shows Year 5 collections, EBITDA, EBITDA margin, collection rate, production per visit, doctor productivity, and total visits. It also includes a Year 5 service-mix table showing production by Hygiene, Restorative, Major, and Ortho.

### How are production and collections connected?

Production is calculated from visits multiplied by the average ticket for each service category. Collections then apply the firm-wide collection rate to total production, making the difference between billed production and collected revenue visible.

### What does the service-mix table measure?

The Year 5 service-mix table shows production by Hygiene, Restorative, Major, and Ortho, along with each category's share of total production. It helps connect visit growth and average ticket assumptions to the practice's revenue composition.

### What is doctor productivity in this model?

Doctor productivity compares production with doctor compensation. It provides an operating view of production generated relative to the doctor-compensation line used in the practice P&L.

### How do dashboard status labels work?

Selected metrics, including EBITDA margin, collection rate, and production per visit, can display status labels based on thresholds held in the Assumptions sheet. Users can tune those thresholds to fit their own review framework.

## Related dashboards

- [Ecommerce Forecast Dashboard](https://finamodel.com/excel-dashboard/ecommerce)
- [Retail Store Dashboard](https://finamodel.com/excel-dashboard/retail-store)
- [Restaurant Dashboard](https://finamodel.com/excel-dashboard/restaurant)
- [Hotel Dashboard](https://finamodel.com/excel-dashboard/hotel)