Modules

Module 1: Strategic PlanningToolbox
1.2 Predicting Financial Sustainability: Revenue and Expenses


A table is available that provides information about costs for different types of safety net dental clinics. Your clinic’s cost figures are one piece of the puzzle, but you can’t predict your clinic’s sustainability until you compare costs with revenue, which comes from direct patient care and possibly from non-patient care sources, such as grants.

The interactive budget planning spreadsheet (click on toolbox icon) lists typical sources of expenses and revenue for a six-chair clinic. The spreadsheet allows you to enter and analyze data and save the analysis of the financial impacts of different decisions, assumptions, and costs specific to your situation. For example, decisions about the fee schedule and sliding fee scale structure, the payer mix, and productivity targets will affect your patient care revenue and clinic expenses.

Although you may not yet have all the information you need to complete the spreadsheet, you should download it to your computer now. As you continue through this curriculum, you will come upon more of the information you need.

The spreadsheet has three worksheets (tabs). After you complete the revenue worksheet and the expenses worksheet, the summary worksheet will be generated automatically.