Estimates the cost of a private dental treatment plan and what it would cost per month on a payment plan.
Which cell does what, and which worksheets the model reads. These are the assignments you recreate when you import the file.
| Cell | Role | Note |
|---|---|---|
| B1 | Input | Procedure, entered as the practice's price per tooth |
| B2 | Input | Number of teeth in the treatment plan |
| B3 | Input | Deposit the patient pays upfront |
| B4 | Input | Payment plan length in months |
| B6 | Result | Subtotal before any discount |
| B7 | Lookup | Multi-tooth discount rate, banded by number of teeth on the Rates sheet |
| B8 | Result | Discount in dollars |
| B9 | Result | Estimated treatment cost, shown to the visitor |
| B10 | Result | Balance left to finance after the deposit, floored at zero |
| B11 | Lookup | APR for the chosen term, banded on the Rates sheet |
| B12 | Result | Monthly interest rate, APR divided by 12 |
| B13 | Result | Estimated monthly payment, shown to the visitor |
| B14 | Result | Deposit plus every monthly payment, shown to the visitor |
Change the numbers to yours, then paste it into your own page. It runs in the visitor’s browser and the answers are theirs, not a screenshot of yours.
Start from this model rather than a blank sheet. The inputs, the results and any lookup worksheets come with it.
The prices here are examples. Change them in the Formula view and the calculator follows — no rewiring.
Publishing gives you an iframe snippet. Drop it into your own page and enquiries land in your workspace.
No. It is an estimate built from typical private-practice list prices. A real price depends on an examination, X-rays, and the condition of each tooth, and can be higher or lower. Nothing here is clinical advice.
Many practices discount multi-tooth cases because the consultation, records, and lab setup are shared across the whole plan. The calculator applies 5% from four teeth and 10% from eight. A practice can change or remove those tiers on the Rates sheet.
The deposit is subtracted from the treatment cost, and the balance is spread over the chosen term as a standard amortising loan at the APR for that term. At 0% the balance is simply divided by the number of months.
No. It covers the treatment itself. Consultations, scans, extractions, bone grafts, temporary restorations, and follow-up care are quoted separately after an examination.
No. Payment plans are provided by a third-party lender and are subject to that lender's application and credit checks. The APRs shown are typical figures, not an offer.
Yes. The prices sit in the dropdown and the discount and APR tiers sit on the Rates sheet, so a practice edits its own numbers in the spreadsheet and the embedded calculator updates with them.