A scenario model can make a new provider hire, equipment purchase or additional location look affordable while hiding the month the practice cannot cover payroll. The problem may not be the forecast’s overall direction. It may be a duplicated receipt, an annual expense placed in a monthly column or a collection delay that never reaches the cash forecast.
Before approving a commitment, review whether the model’s assumptions, formulas and cash movements tell the same story. A detailed spreadsheet is not necessarily a reliable one.
This guide focuses on finding errors in an existing medical practice scenario model—not building scenarios from scratch. The review should answer three questions:
- Does the model represent the practice’s operations and financial records correctly?
- Do the assumptions within each case fit together?
- Can the practice fund the proposed decision when payments actually come due?
Start With the Decision and the Model’s Boundaries
Ask the preparer to state the decision the model supports. “Approve another provider” is incomplete without a proposed start date, compensation commitment, supporting staff requirements and the location or entity that will pay.
Then confirm the model’s boundaries:
| Review item | What must be clear |
|---|---|
| Decision | The spending, staffing or expansion commitment under consideration |
| Time period | Monthly or weekly columns, with consistent start and end dates |
| Accounting basis | Whether each schedule shows earned revenue, billed charges or cash receipts |
| Scope | Included locations, entities, bank accounts and shared expenses |
| Starting position | Opening cash, receivables, unpaid bills and existing commitments |
| Comparison | The proposed decision versus continuing without it |
That last comparison matters. A new location may appear profitable because the model assigns it revenue transferred from an existing office without showing the corresponding reduction there. Review both the location view and the total practice effect.
sbb-itb-17e8ec9
A Flawed Model Excerpt: What Should Stop Approval?
Illustrative example: all amounts and operating assumptions in this section are invented for review purposes. These are selected lines from a flawed February expansion model, not a complete financial statement.
| Model line | Flawed entry or logic | Reviewer’s finding |
|---|---|---|
| Provider salary expense | Annual salary of $240,000 entered as February expense | Annual and monthly units are mixed; a full month’s salary would be $20,000 before other employment costs |
| Total revenue | $120,000 expected net service revenue plus $80,000 payer receipts equals $200,000 | Receipts are added to revenue even though they represent collections of receivables, not separate services |
| February cash inflow | All $120,000 of February net service revenue collected in February | Collection timing is assumed rather than supported |
| Completed visits | 800 visits from one provider with 16 clinical days and 20 available slots per day | Only 320 slots exist before cancellations or other scheduling constraints |
| Downside expenses | Every cost falls by the same percentage as revenue | Lease payments and committed salaries do not necessarily decline with volume |
| Ending cash | Opening cash plus reported profit | Equipment payments, debt principal and collection timing are missing |
These errors should not be netted against one another. An overstated salary might accidentally offset overstated revenue, leaving a plausible-looking result built on incorrect logic.
The reviewer should require corrected source schedules and rerun the outputs before relying on the recommendation.
1. Mixing Time Periods and Units
A monthly heading does not prove that every input is monthly. Models often combine annual compensation, quarterly vendor payments, weekly staffing hours and monthly visit counts without converting them consistently.
Check each material input’s unit and effective date. For payroll, distinguish an annual compensation rate from the expense attributable to the modeled period and the dates cash is paid. A provider beginning partway through a month should not automatically generate a full month of payroll expense or clinical capacity.
Also inspect summary formulas. A quarterly report can accidentally add a year-to-date column to three monthly columns, counting the same activity twice.
Correction: Label units beside inputs, separate rates from period totals and verify that summary columns include only the intended periods. Use actual payroll payment dates in the cash schedule rather than assuming every month has identical payroll outflows.
2. Double-Counting Revenue and Collections
Medical practice models need clear distinctions among gross charges, expected net revenue and cash received. They are not interchangeable measures.
Common duplication errors include:
- Adding payer receipts to revenue already recognized for the underlying services.
- Adding patient balances to a revenue estimate that already includes patient responsibility.
- Treating collections of opening receivables as new service revenue.
- Recording transfers between practice bank accounts as outside revenue.
- Counting intercompany charges as additional revenue in a consolidated practice view without eliminating the corresponding internal activity.
Trace a service period through the schedules. Where does its revenue appear? Where do its later collections appear? Is either amount counted again in the total?
Correction: Keep the revenue schedule separate from the receipts schedule. Reconcile opening receivables, new net receivables, collections, adjustments and ending receivables using consistently defined categories. At the consolidated level, remove internal transfers and intercompany activity that would otherwise overstate totals.
3. Omitting Collection Lags
A model can estimate eventual collections reasonably and still misstate near-term cash. Payer receipts and patient payments may arrive after the practice has paid provider and administrative payroll.
Inspect whether the model distinguishes:
- Collections from receivables already outstanding at the start.
- Collections from services delivered during the forecast.
- Payer and patient payment timing where their patterns differ materially.
- Delayed receipts from amounts the practice no longer expects to collect.
A delay moves cash to a later period. A reduction in expected collectibility changes the amount ultimately expected. Those are different assumptions and should not be applied twice to the same balance without justification.
Correction: Require a collection schedule supported by the practice’s historical receipt patterns and relevant receivables information. Check that a delay reduces cash in the affected month and leaves the corresponding amount outstanding until collection or adjustment.
Use aggregated financial information where possible. Patient-identifiable details generally are not needed for an owner’s scenario review and should not be placed in ordinary Slack messages or general-purpose AI tools.
4. Forecasting More Activity Than the Practice Can Deliver
Revenue projections should fit within operating capacity. A model that assumes a full schedule from a new provider’s first day may overlook ramp-up time, room availability or supporting staff coverage.
Compare modeled activity with the most relevant constraints:
- Provider clinical days and available appointment slots.
- Expected completed visits rather than scheduled appointments alone.
- Room and equipment availability.
- Administrative and clinical support staffing.
- Coverage changes when providers split time between locations.
Capacity at one location cannot also be used at another during the same hours. Similarly, hiring a provider does not automatically create patient demand or make every appointment slot collectible at the same amount.
Correction: Reconcile completed visits to available capacity, then verify that the revenue assumptions match the expected service and payer mix. Ask for support when the model assumes performance materially above the practice’s own experience.
5. Using Unsupported Relationships in the Downside Case
A downside case is not simply the base case with every line reduced by the same percentage. It should describe a plausible chain of events.
Consider a slower-than-planned provider ramp-up. Fewer completed visits may reduce net revenue and some supplies expense. But guaranteed compensation, rent and essential administrative coverage may remain unchanged. Collections may also trail the reduced service activity.
| Assumption | Coherent slower-ramp downside | Relationship to challenge |
|---|---|---|
| Completed visits | Lower because the schedule fills more slowly | Visits remain unchanged while revenue falls without explanation |
| Net revenue per visit | Held steady unless mix or reimbursement assumptions also change | Automatically falls whenever visit volume falls |
| Collections | Follow the revised service activity and supported payment timing | Improve simply because the case needs more cash |
| Payroll | Reflects compensation terms and required coverage | Falls immediately in proportion to revenue |
| Supplies | Changes with the relevant activity | All spending is treated as fully variable |
| Existing location | Reflects any provider time or patient activity moved elsewhere | Keeps all original activity while the new office counts it again |
Correction: Ask the preparer to explain each material relationship in plain language. Historical data, compensation arrangements, vendor terms and operating plans should support the connections. Do not assign precise probabilities to scenarios without a defensible basis.
6. Ignoring Fixed Commitments and Shared Costs
A downside model may show reassuring margins because it assumes management can immediately remove costs that are already committed.
Review leases, equipment financing, compensation arrangements, software contracts and other obligations. Separate costs that can be avoided before approval from costs that continue after the commitment is made. Potential reductions should reflect feasible timing, not merely a spreadsheet formula.
For multi-location practices, inspect shared-cost allocation as well. Moving central administrative expense from one location to another changes location-level profitability but does not reduce total practice spending.
Correction: Request a commitment schedule showing payment amounts, timing, responsible entity and any assumptions about changing or ending the commitment. Distinguish incremental costs caused by the proposal from existing costs allocated to it, while keeping both visible in the appropriate reports.
7. Confusing Profit With Available Cash
A profitable proposal can still require cash the practice does not have. On an accrual-based forecast, revenue may precede collection. Equipment purchases, debt principal and owner distributions also affect cash differently from operating expenses.
Illustrative example: all figures below are invented. A practice starts a month with $25,000 in cash. It expects $120,000 in net service revenue, but total cash receipts during the month are only $80,000. Operating cash payments are $95,000, and an equipment payment requires another $20,000.
Its ending cash is:
$25,000 + $80,000 − $95,000 − $20,000 = negative $10,000.
The revenue forecast does not make those payment obligations affordable. The proposal needs a documented funding solution, a different commitment schedule or reconsideration.
Correction: Review a direct cash schedule alongside profitability. It should include opening cash, receipts, payroll and vendor payments, equipment spending, financing flows, distributions and applicable tax payments reviewed with the CPA. Check the lowest cash point—not just the year-end balance. Where monthly totals conceal payroll pressure, inspect shorter periods around the decision.
Pre-Approval Model Review Checklist
Use this checklist to document findings rather than accepting a general statement that the model has been reviewed.
| Error risk | Detection test | Required correction |
|---|---|---|
| Inconsistent periods | Inspect units, dates and summary ranges | Align periods and separate rates from totals |
| Double-counted revenue | Trace service revenue, receipts and transfers | Separate revenue from collections; eliminate internal duplication |
| Missing collection lags | Reconcile receivables and receipt timing | Show supported collection timing and opening receivables |
| Unrealistic capacity | Compare visits with provider, room and staff availability | Cap activity at supportable operating levels |
| Unsupported relationships | Explain why connected assumptions move together | Replace blanket changes with coherent operating logic |
| Ignored commitments | Compare expense reductions with payment obligations | Retain committed costs and realistic reduction timing |
| Profit mistaken for cash | Reconcile beginning to ending cash | Include all material cash movements and funding needs |
| Misleading location results | Reconcile location and entity schedules to practice totals | Correct allocations, transfers and duplicated activity |
Before approval, retain the reviewed model version, unresolved assumptions, supporting schedules and the owner’s decision. If a material error could change affordability, return the model for correction rather than approving around it.
Lucid Financials provides CPA-led bookkeeping, tax and CFO services for staffed US private medical practices. Clean books and location/entity financial visibility provide a stronger foundation for reviewing these decisions; they do not replace checking the model’s assumptions and cash logic.
FAQs
Does a positive profit forecast mean the practice can afford another provider?
No. Review compensation commitments, supporting staff costs, collection timing and the lowest projected cash balance. Profitability and the ability to meet payments are separate approval questions.
Should every assumption get worse in a downside case?
No. Change assumptions that belong to the stated downside event and preserve relationships that remain valid. Slower visit growth may reduce some supplies expense without reducing rent or committed salaries. Making every line worse can be as misleading as making every line optimistic.
What should an owner request when a scenario model fails review?
Request the corrected model, an explanation of the error, the affected outputs and supporting evidence for the revised assumptions. The preparer should show whether the correction changes cash needs, location profitability or the recommendation. Do not rely only on a revised summary slide.