An investor-ready medical practice financial model should let a reviewer trace a proposed expansion from historical results through operating assumptions to cash needs. It should answer a practical owner question: Can the practice fund this plan while maintaining its existing operations—and what changes if the opening or collections take longer than expected?

The model is not a promise of future performance. It is a documented framework for discussing a new location, financing, or a proposed capital transaction. Its usefulness depends on reconciled records, visible assumptions, and linked profit-and-loss, balance-sheet, and cash-flow schedules—not an impressive growth curve.

Start with the decision, establish a reliable opening position, and make every material forecast output traceable to a source or an explicitly identified management assumption.

1. Define the Decision and Reporting Perimeter

Before building formulas, write a short model brief covering:

  • Decision: What capital commitment or financing proposal is being evaluated?
  • Scope: Which operating entities, locations, and shared-service costs are included?
  • Timing: When will deposits, construction, hiring, opening, and collections occur?
  • Funding: What is committed, proposed, conditional, or unavailable?
  • Constraints: What cash reserve, borrowing limit, or spending approval must the plan respect?

Choose a monthly forecast horizon that captures the preopening period, operating ramp, and significant financing obligations. Extend it when necessary to show later commitments rather than stopping before a difficult repayment period.

Separate the existing practice from the proposed location. A profitable established office can otherwise conceal a new office’s cash requirements. Show location-level operating results, entity-level obligations, and consolidated totals with intercompany eliminations where applicable.

A model does not establish whether an ownership arrangement or transaction is permissible. Have qualified legal, tax, and transaction advisers review ownership terms, transaction eligibility, entity structure, and financing documents before treating a proposed arrangement as actionable.

2. Reconcile the Historical Starting Point

Use closed monthly financial statements and supporting schedules for the available history. Include enough history to understand seasonality and unusual periods, and disclose gaps rather than manufacturing comparable results.

The IRS guidance on business recordkeeping supports maintaining complete records, keeping business accounts separate, and reconciling bank records. For modeling, those disciplines establish the starting point from which projected balances roll forward.

Historical input Reconciliation or review Why it matters
General ledger and monthly statements Tie imported totals to the finalized books Prevents competing versions of historical performance
Bank and credit accounts Reconcile statements to ledger balances Establishes opening cash and outstanding obligations
Payer receipts and patient balances Bridge billing reports, adjustments, receivables, and deposits Separates recognized revenue from cash received
Provider and administrative payroll Tie payroll reports to expense and liability accounts Supports staffing costs and payroll timing
Equipment and debt Tie asset records and lender statements to the books Establishes depreciation, balances, and repayments
Shared expenses and intercompany accounts Document allocations and reconcile reciprocal balances Avoids double counting and misleading location margins

State the accounting basis. If the books are cash basis but the transaction model uses accrual financial statements, have the CPA prepare or review the conversion. Do not add a receivables forecast to cash-basis revenue and describe the result as an integrated accrual model.

Keep historical results separate from proposed adjustments. If an owner identifies an unusual expense or proposes different compensation after a transaction, show the reported amount, proposed adjustment, rationale, and supporting document. Do not silently remove the expense from history.

3. Build a Workbook Reviewers Can Follow

Separate source data, assumptions, calculations, and outputs. Use consistent period labels and a visible boundary between actual and forecast months. Avoid embedding assumptions inside formulas or maintaining different versions of the same input across tabs.

Suggested Model Tab Map

Tab Contents Main connections
Read Me and Control Purpose, scope, version, actuals cutoff, scenario selector Governs the full workbook
Historical Data Reconciled ledger imports and supporting summaries Opening balances and historical comparisons
Mapping and Adjustments Account mapping, conversion entries, proposed adjustments Bridges source records to model categories
Assumption Register Inputs, evidence, owners, review status Supplies all forecast schedules
Revenue and Collections Earned net revenue, collection timing, receivables P&L, balance sheet, operating cash flow
Staffing and Overhead Positions, start dates, compensation, rent, shared costs Expenses, accruals, payment timing
Capital and Financing Equipment, buildout, depreciation, debt, capital contributions Assets, interest, investing and financing cash flows
Three Statements Linked P&L, balance sheet, and cash-flow statement Integrated financial outputs
Scenarios and Checks Base/downside comparisons, reconciliation tests Funding decision and error review
Reviewer Summary Uses of funds, liquidity, milestones, unresolved items Meeting materials and diligence package

Label manual inputs and formulas consistently, but do not rely on color alone. Protect formula areas where practical and keep source filenames, reporting dates, and workbook versions identifiable.

Maintain an Assumption Register

Each significant assumption needs an owner and a basis. Distinguish executed agreements from quotes, historical observations, and management estimates.

Assumption Evidence or basis Responsible owner Downside treatment
Location opening date Buildout schedule and outstanding dependencies Practice administrator Delay opening while committed costs continue
Provider availability Recruiting status and proposed start dates Physician owner Shift capacity and associated revenue
Net revenue per completed visit Historical payer mix and net revenue analysis Finance lead Test a lower supported realization assumption
Collection timing Aggregate receipt patterns and receivables aging Revenue-cycle lead Shift receipts into later periods
Payroll and benefits Staffing plan, offers, and benefit estimates Administrator Retain costs that cannot be deferred
Equipment and buildout Vendor quotes and payment milestones Project lead Test overruns and earlier deposits
Financing availability Executed documents or clearly labeled proposal Owner and advisers Delay or exclude uncommitted proceeds

Record the effective date, last review date, and confidence level for each input. “Management estimate—unconfirmed” is more useful than a precise-looking number with no explanation.

4. Connect Operating Assumptions to Financial Schedules

Separate Revenue From Collections

For an accrual model, estimate net patient-service revenue using supported capacity, completed activity, payer mix, and expected net realization. Gross charges are not a substitute for expected revenue or receipts.

Then model when that revenue becomes cash. Use aggregated collection patterns, opening receivables, and patient-balance trends. Distinguish contractual adjustments from subsequent collection shortfalls, and apply a consistent accounting treatment reviewed by the CPA.

A simplified receivables roll-forward is:

Ending net receivables = opening net receivables + net revenue − cash collections − separately modeled write-offs or adjustments.

Do not deduct an adjustment again if it is already reflected in net revenue. Collection timing can change cash materially without changing the same month’s earned revenue.

Build Staffing and Overhead From Commitments

Model provider and administrative positions by start date, compensation arrangement, benefits, and applicable employer costs. Connect staffing to supported capacity rather than assuming revenue increases without the people needed to deliver it.

Separate costs into those that begin before opening, those that change with activity, and those that increase in steps. Rent, recruiting, and training may precede collections. Some staffing costs remain committed even when the opening slips.

Allocate shared costs using a documented method appropriate to the expense. Show both the location’s directly attributable result and its result after allocated overhead. An allocation changes location reporting; it does not itself create a new consolidated cash expense.

Schedule Capital Spending and Financing Separately

Track equipment and buildout payments by milestone. Distinguish capitalized assets, expenses, deposits, and prepayments with CPA review. Link capitalized assets to an appropriate depreciation schedule rather than expensing every purchase immediately.

Build a financing roll-forward showing opening debt, draws, principal repayments, and closing debt. Calculate interest using the documented terms and a clear timing convention. Keep owner contributions and distributions separate from operating revenue and expenses.

Treat proposed financing as conditional. If the forecast depends on proceeds that are not committed, make that dependency prominent.

The schedules should produce statements that reconcile without hidden balancing entries.

Profit-and-Loss Statement

Bring in net revenue, provider and administrative compensation, occupancy, supplies, shared overhead, depreciation, and interest. Show location and consolidated results consistently. Have the CPA determine the appropriate entity-level tax treatment; do not apply an assumed tax rate indiscriminately across entities.

If the summary includes EBITDA or an adjusted earnings measure, define it and reconcile it to reported earnings. Keep proposed adjustments visible rather than allowing an adjusted metric to replace the underlying statements.

Balance Sheet

Roll forward cash, receivables, prepayments, fixed assets, payables, payroll liabilities, debt, and equity. Opening balances must match the reconciled historical cutoff.

Carry earnings into equity, and separately reflect contributions and distributions. Model payment timing for accrued costs; an expense and its cash payment may fall in different months.

Cash-Flow Statement

For an indirect cash-flow statement, start with net income, add back noncash items, and adjust for working-capital movements. An increase in receivables reduces operating cash relative to earnings; an increase in unpaid operating liabilities generally increases it.

Show capital expenditures in investing activities and debt proceeds, principal repayments, contributions, and distributions in financing activities, using the applicable accounting presentation. Ending cash must equal the balance-sheet cash balance.

Required Model Checks

  • Assets equal liabilities plus equity in every period.
  • Ending cash equals opening cash plus net cash movement.
  • Receivables, fixed assets, debt, and equity roll-forwards reconcile.
  • Location totals and eliminations reconcile to consolidated statements.
  • Historical statements tie to the approved source records.
  • The reviewer summary matches the selected scenario and model version.

Do not force cash to a positive number with an unexplained financing entry. Show a funding shortfall explicitly.

6. Compare Base and Downside Cases

Keep one calculation structure with selectable assumption sets. The base case should reflect supported current expectations. The downside should change identifiable operating conditions—not simply reduce every line by the same percentage.

Illustrative example only: The following simplified opening-month cash bridge is invented to demonstrate review mechanics. It is not a forecast, benchmark, or complete three-statement model. It assumes no cash movements beyond those listed.

Opening-month cash bridge Base case Downside case
Opening cash $300,000 $300,000
Collections $200,000 $140,000
Operating cash payments ($180,000) ($180,000)
Capital spending ($250,000) ($280,000)
Financing proceeds $150,000 $150,000
Ending cash $220,000 $130,000

In this illustration, slower collections and higher capital spending reduce ending cash while operating payments remain committed. The full model must show whether the collection difference remains collectible in receivables or represents lower revenue or a collection loss. It must also test the availability of the financing proceeds rather than assuming they are certain.

Compare the lowest monthly cash balance, required funding, outstanding debt, and recovery timing across cases. If management sets a minimum cash reserve, disclose its rationale. A downside case is not proof that all risks have been captured.

7. Prepare for New-Location Reviewer Questions

A useful diligence discussion follows the model’s evidence trail.

Hypothetical reviewer question What the model should show
What happens if the opening slips? Delayed activity and receipts, continuing commitments, revised cash low point
Are new-location receipts truly incremental? Any expected transfer of activity from existing offices and the consolidated effect
What supports the staffing ramp? Position-level dates, recruiting status, and capacity dependencies
Why do earnings improve before cash does? Receivables growth, payment timing, and working-capital bridge
Are shared costs counted twice? Allocation method, entity charges, and consolidation eliminations
What if financing closes late? A separate funding-delay case and explicit cash gap
What supports each use of funds? Quotes, agreements, payment milestones, and contingency assumptions

Provide a dated model, source index, assumption register, reconciliation summary, and unresolved-items log. Use aggregate financial information where possible. Keep patient-identifiable information out of ordinary Slack messages and general-purpose AI tools; follow the practice’s approved handling process when sensitive information is necessary. HHS minimum-necessary guidance explains the standard and its exceptions.

8. Keep the Model Ready for the Next Decision

After each monthly close, replace forecast periods with reconciled actuals, explain material variances, and update assumptions prospectively. Preserve the version used for each capital discussion so reviewers can distinguish new information from changed methodology.

Lucid Financials provides CPA-led bookkeeping, tax, and CFO services for staffed US private medical practices, combining AI-assisted financial work with a human finance team. Clean books, catch-up bookkeeping, location/entity financial visibility, and support through Slack can help owners organize the financial foundation for planning discussions. Confirm the specific modeling engagement and deliverables rather than assuming reports or forecasts are generated automatically.

The final decision is not whether the spreadsheet looks optimistic. It is whether the practice can explain its assumptions, reconcile its statements, identify its funding dependencies, and make a defensible commitment under both base and downside conditions.

FAQs

What makes a medical practice model investor-ready?

Traceability: historical balances reconcile, assumptions have documented support, and operating schedules connect to all three financial statements. Reviewers should also see scenario comparisons, funding dependencies, and unresolved issues. These features support diligence but do not guarantee financing or transaction approval.

How should the model handle circular references?

Identify the dependency rather than replacing formulas with unexplained hardcoded results. Interest and borrowing calculations commonly create loops. A documented beginning-balance convention or explicit financing schedule may resolve them when appropriate to the terms. Have the model reviewer validate the approach and disclose simplifying assumptions.

How much cash should the expansion model show?

There is no universal reserve or runway target. Model the timing of payroll, rent, capital commitments, collections, debt service, and financing availability. Compare the lowest cash balance with a management-approved reserve and any applicable financing requirements. Show the funding gap openly if the plan falls below that level.