Clinic & Medical Practice Finance
Capacity, payer mix, collections and days in A/R, no-shows and overbooking, staffing cost, break-even for a new provider, supply costs and a KPI dashboard: run the numbers of a medical practice in a live spreadsheet that checks every cell.
The first lesson is free — no account needed.
About this course
A medical practice finance course that runs one family practice's numbers in a spreadsheet, for practice managers, physicians and healthcare administration students. You turn provider schedules into capacity and utilisation, calculate the payer mix and the weighted revenue per visit, roll accounts receivable forward to the net collection rate and days in A/R, measure the no-show rate, the revenue it costs and a sensible overbooking level, work out staffing ratios and staff cost per visit, find the break-even visits for a new physician, cost a procedure's supply kit with inventory turns and finish with a practice KPI dashboard and chart. Fictional practice, illustrative numbers. The first lab is free.
Lessons
- Patient Volume, Capacity & UtilisationFree
- Revenue per Visit & Payer Mix with SUMPRODUCT Pro
- Collections, Net Collection Rate & Days in A/R Pro
- No-Show Rate, Lost Revenue & Overbooking Pro
- Staffing Ratios & Staff Cost per Visit Pro
- Break-even Visits for a New Provider Pro
- Supply Cost per Procedure & Inventory Turns Pro
- Practice KPI Dashboard with a Chart Pro