Blog · Finance metrics and formulas · Healthcare
A healthcare facility cost-benefit analysis compares incremental investment costs with measurable operating cash benefits. Build a workbook from quotes, spending records and utilization assumptions, then test the result before approving the project.
Cost benefit analysis in health care compares a facility investment's incremental cash costs with the operating benefits it can reasonably deliver. Start with the current operating arrangement, show exactly what the proposal changes, and test whether the benefit assumptions survive a less favorable case. A positive spreadsheet result supports a business decision; it does not replace clinical, safety or operational review.
The baseline is what the organization expects to do without the proposed investment. It includes required maintenance and any unavoidable replacement spending. Comparing a new system with an unrealistic assumption that the existing facility costs nothing creates an artificial benefit.
Document the facility, decision date, implementation timing, study period and responsible manager. Keep the analysis at department or facility level. Patient records and clinical outcomes are unnecessary for this financial schedule.
The NIST life-cycle costing manual explains how future facility costs are brought to a common present value, including one-time amounts and recurring costs. It is written for federal facilities; the transferable method here is consistent timing and discounting. A private provider should use its own approved investment assumptions rather than adopting federal rates automatically.
For the operating expense baseline itself, use healthcare cost analysis. This page starts where that work ends: deciding whether a proposed facility investment improves the cash position enough to justify its cost.
Use a quote register for installation costs, the expense ledger for costs that would stop, and an aggregated utilization schedule for the volume-sensitive benefits. Each assumption needs a source, an owner and a statement of what must happen for the saving to become cash.
| Workbook field | Example entry | Evidence to retain |
|---|---|---|
| Initial equipment cost | Storage equipment purchase | Supplier quote and scope |
| Installation and training | One-time implementation spending | Separate quote lines |
| Avoided recurring expense | Off-site storage contract | Contract termination date and notice terms |
| Avoided labor spending | Counting overtime | Overtime hours and fully loaded cash rate |
| Volume-sensitive benefit | Fewer supplies discarded | Historical discarded units and replacement unit cost |
| New recurring expense | Support and consumables | Annual pricing and escalation terms |
Do not count the same labor benefit in both reduced overtime and reduced unit processing cost. If an expense remains after installation, it is not avoided. Record capacity improvements separately when staff can do other work but payroll spending remains unchanged.
An illustrative US outpatient group is evaluating supply-storage equipment. Operations expects it to eliminate an external storage contract, reduce paid counting overtime and reduce discarded supplies. All figures below are assumptions for this example, not vendor performance claims.
| Initial spending | Calculation | Cash cost (USD) |
|---|---|---|
| Equipment | Quoted amount | 180,000 |
| Installation | Quoted amount | 20,000 |
| Training | One-time cost | 10,000 |
| Initial investment | 180,000 + 20,000 + 10,000 | 210,000 |
The group assumes the equipment is available immediately, benefits begin in the first year and cash flows occur at each year end. It uses a five-year evaluation period, an illustrative annual discount rate of 8%, no price escalation, no residual value and no tax effects. Finance must replace these with the organization's actual assumptions before approval.
| Annual cash item | Driver calculation | Amount (USD) |
|---|---|---|
| Storage contract avoided | Contract annual cash payment | 24,000 |
| Counting overtime avoided | 600 hours × 40 per hour | 24,000 |
| Discarded supply replacement avoided | 12,000 units × 2 per unit | 24,000 |
| Gross operating benefits | 24,000 + 24,000 + 24,000 | 72,000 |
| New support expense | Annual agreement | 12,000 |
| New consumables | Annual estimate | 6,000 |
| New recurring costs | 12,000 + 6,000 | 18,000 |
| Net annual cash benefit | 72,000 − 18,000 | 54,000 |
The overtime assumption means those paid hours are actually removed. The supply assumption means lower replacement purchases, with no reduction in required service levels. Neither benefit should enter the approved case until the responsible manager confirms those conditions.
Net present value = Initial cash flow + Sum of each future net cash flow / (1 + Discount rate)^Year
Benefit-cost ratio = Present value of gross benefits / Present value of all incremental costs
Keep costs positive when building the benefit-cost ratio. For net present value, use a negative initial investment and positive future net benefits.
| Year | Net cash flow (USD) | Present-value calculation | Present value (USD) |
|---|---|---|---|
| 0 | −210,000 | Initial cash flow | −210,000 |
| 1 | 54,000 | 54,000 / 1.08^1 | 50,000 |
| 2 | 54,000 | 54,000 / 1.08^2 | 46,296 |
| 3 | 54,000 | 54,000 / 1.08^3 | 42,867 |
| 4 | 54,000 | 54,000 / 1.08^4 | 39,692 |
| 5 | 54,000 | 54,000 / 1.08^5 | 36,751 |
| Total net present value | 5,606 |
Displayed dollar results are rounded to whole dollars; calculations retain full precision. In a spreadsheet, put years 0–5 in A2:A7, signed net cash flows in B2:B7 and the discount rate in F1. The row-level calculation in C2 is:
=B2/(1+$F$1)^A2
Fill down, then calculate the result independently:
=SUM(C2:C7)
=NPV($F$1,B3:B7)+B2
The two results must agree. Microsoft's NPV documentation specifies equally spaced end-of-period cash flows and explains why a beginning-of-period initial payment is added outside the function. Covirage is not affiliated with Microsoft.
The five-year discount factor sum is 3.992710. Present-value benefits are $72,000 × 3.992710 = $287,475. Present-value costs are $210,000 + $18,000 × 3.992710 = $281,869. Their difference is the same $5,606, and their ratio rounds to 1.02. The factor shown is rounded; use the unrounded factor in the workbook.
Simple payback is $210,000 / $54,000 = 3.89 years, rounded to two decimals, if benefits accrue evenly within each year. That is a useful timing indicator, but it omits discounting and should sit beside the present-value result.
The case has little room for the operating benefits to disappoint. Change just one assumption: avoided discarded supplies fall from 12,000 units to 6,000 units annually. The unit replacement cost and every other assumption stay fixed.
| Measure | Base case | Lower avoided-waste case |
|---|---|---|
| Avoided supply purchases (USD annually) | 24,000 | 12,000 |
| Gross benefits (USD annually) | 72,000 | 60,000 |
| Net cash benefit (USD annually) | 54,000 | 42,000 |
| Net present value (USD) | 5,606 | −42,306 |
The second result is $42,000 × the unrounded discount factor − $210,000. It changes the financial conclusion without changing the equipment price. Use cost-benefit sensitivity analysis when several assumptions need separate tests, and construction project cost-benefit analysis when installation scope becomes a broader construction decision.
Finance owns the cash-flow schedule and reconciliation. Operations owns the utilization and implementation assumptions, procurement confirms quoted scope, and the approving manager decides whether the supported financial result meets internal requirements.
Bring your facility-level quote, operating cost and utilization assumptions in a file or Google Sheet. Covirage maps the columns, its tools compute and check the supplied figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.
See cost variance analysis for the supporting approach to understanding operating cost differences.
Include cash spending that the project would avoid, such as a canceled storage contract or demonstrably reduced overtime. Additional activity can count only at its incremental cash contribution after related costs. Describe service and capacity improvements separately when there is no defensible cash estimate.
Only when those hours change actual cash spending, such as overtime or contract labor that will no longer be purchased. Salaried time reassigned to other work is a capacity benefit. It needs a separate explanation rather than an automatic payroll saving.
Simple payback estimates when undiscounted net cash benefits recover the initial investment. Net present value discounts the entire stated cash-flow period and includes later costs and benefits. A project can repay its initial cost yet have little value after discounting.
No. This business-side schedule compares facility costs and operating benefits expressed in dollars. It does not value patient outcomes, calculate quality-adjusted life years or recommend clinical services. Clinical and safety requirements need their own assessment even when a facility investment has a positive financial result.