Blog · Finance metrics and formulas · Healthcare
Healthcare financial analysis connects service-line contribution, labor costs and liquidity. Build a monthly review from deidentified finance exports, calculate margins in Excel and reconcile the movement in cash.
Healthcare financial analysis connects service-line margins, labor costs and cash movements so a provider can decide where to focus its operating review. Start with net revenue and direct costs, then prove how contribution becomes operating profit and cash. A strong margin means little for liquidity if receivables absorb the cash it should produce.
Use deidentified finance reports aggregated by service line and month. Bring the income statement, revenue summary, payroll and agency-labor totals, supplies expense, receivables, payables and bank balances. Patient names, clinical details and individual billing records are unnecessary for this review.
Preserve the original account and service-line codes. Add a mapping column for the management categories rather than overwriting source descriptions. Finance owns the ledger tie; service-line leaders confirm that the operating assignments make sense.
Keep charges, recognized revenue and collections separate. The CMS description of provider cost reports distinguishes utilization, costs and charges by cost center, settlement data and financial-statement data. An annual cost report can provide context, but it does not replace a current monthly ledger.
Use healthcare cost analysis for the detailed assignment of costs; this review uses those assignments to connect margins and liquidity. The broader financial analysis guide provides the cross-industry framework.
Consider an illustrative US outpatient provider for September 2026. Revenue is net recognized revenue after the organization's recorded contractual adjustments and other revenue reductions. Labor includes wages, employer costs and agency labor assigned to each line. Other direct costs exclude the shared overhead and depreciation shown later.
Create a sheet called Services. Put headers in row 1 and the three service lines in rows 2 through 4. Use columns A through G in the order shown. Amounts are USD; displayed percentages are rounded to one decimal, with calculations retaining full precision.
Service-line contribution = Net revenue - Direct labor - Supplies - Other direct costs
Contribution margin = Service-line contribution / Net revenue
| Service line | Net revenue (USD) | Labor (USD) | Supplies (USD) | Other direct costs (USD) | Contribution (USD) | Margin |
|---|---|---|---|---|---|---|
| Primary care | 600,000 | 330,000 | 50,000 | 60,000 | 160,000 | 26.7% |
| Imaging | 450,000 | 180,000 | 70,000 | 50,000 | 150,000 | 33.3% |
| Therapy | 250,000 | 150,000 | 20,000 | 30,000 | 50,000 | 20.0% |
| Total | 1,300,000 | 660,000 | 140,000 | 140,000 | 360,000 | 27.7% |
Enter these formulas in F2 and G2, then fill through row 4:
=B2-SUM(C2:E2)
=IF(B2=0,NA(),F2/B2)
For row 5, sum each amount column. The total margin in G5 is:
=SUM(F2:F4)/SUM(B2:B4)
Microsoft's SUM guidance explains how to add cell ranges and warns that text values are ignored. Confirm that imported amounts are numeric before totaling them. Covirage is not affiliated with Microsoft.
Do not average the three margins. The organization earns $360,000 of contribution on $1,300,000 of revenue, so its margin is 27.7%. Labor consumes 660,000 / 1,300,000 = 50.8% of revenue. Therapy's labor share is 150,000 / 250,000 = 60.0%, compared with imaging's 180,000 / 450,000 = 40.0%.
Those differences identify questions, not staffing conclusions. Check service mix, coverage requirements, paid hours and agency use before deciding what should change. Revenue per visit alone cannot explain whether a line carries unusually high labor requirements.
Add the following organization-level bridge. Shared overhead includes costs outside the direct service-line definition; depreciation appears only here.
| Step | Amount (USD) | Calculation |
|---|---|---|
| Service-line contribution | 360,000 | Total from Services |
| Less shared overhead | 180,000 | Ledger expense |
| Less depreciation | 40,000 | Ledger expense |
| Operating profit | 140,000 | 360,000 - 180,000 - 40,000 |
Operating margin is 140,000 / 1,300,000 = 10.8%. The control is 660,000 + 140,000 + 140,000 + 180,000 + 40,000 + 140,000 = 1,300,000: direct costs, shared costs, depreciation and operating profit reproduce revenue.
Match every expense account to exactly one category. An unassigned account means the bridge is incomplete; an account included in direct labor and overhead means it is counted twice. Keep gross and contribution margins clearly labeled when sharing the review.
The SEC's financial-statement guide explains that income statements measure performance over a period, while cash-flow statements track cash movements. Build that distinction into the review.
In this simplified example, receivables rise by $90,000, supplier payables by $25,000 and accrued payroll by $15,000. Cash interest is $20,000; there are no income-tax payments or other operating adjustments in the example. Put this signed bridge on a separate Cash sheet, with headers in row 1 and amounts in column B.
| Cash bridge | Signed amount (USD) |
|---|---|
| Operating profit | 140,000 |
| Add depreciation | 40,000 |
| Cash interest | -20,000 |
| Increase in receivables | -90,000 |
| Increase in supplier payables | 25,000 |
| Increase in accrued payroll | 15,000 |
| Operating cash | 110,000 |
| Equipment purchases | -60,000 |
| Debt principal repayments | -30,000 |
| Net cash movement | 20,000 |
| Opening cash | 300,000 |
| Closing cash | 320,000 |
Calculate B8 with =SUM(B2:B7), B11 with =SUM(B8:B10) and B13 with =SUM(B11:B12). Closing cash must match the reconciled bank and ledger balance. Expand the bridge for any additional balance-sheet movements in the real file.
Upload a deidentified service-line workbook and aggregate finance reports: Covirage maps the columns, and its tools compute and check the margins and cash movements while the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for healthcare for the industry context.
Use a monthly income statement, service-line revenue and cost reports, an aggregate payroll summary, receivables balances, payables and cash movements. Keep the reporting period and service-line mapping consistent. This operating review does not require identifiable patient records.
No. Service-line contribution deducts the direct costs included in your stated definition. Operating profit also reflects shared operating costs and depreciation. Present a bridge between them so managers can see both service economics and the cost of running the whole provider organization.
Revenue can be recognized before collection, while wages and suppliers require payment. Growing receivables, equipment purchases and debt repayments can absorb cash despite positive profit. Reconcile opening and closing balances rather than treating the income statement as a cash report.