HA520 Unit 10 Comprehensive Financial Analysis Example

Not Yet, and Here Is What Would Change the Answer: A Comprehensive Financial Analysis for a Composite 186-Bed Nonprofit Hospital's Board Finance Committee on an Eighty-Five Million Dollar Bed Tower, Carrying Three Years of Results, Ratio Trends, Payer Exposure and a Borrowing Pro Forma Into One Recommendation

[Student Name]

Purdue University Global

HA520: Health Care Financial Management

Unit 10 Comprehensive Financial Analysis

[Instructor Name]

[Date]

The hospital, the project and every figure are composite and bracketed, drawing together the term's earlier analyses; the report is a course model, not financial advice.

Summary for the Committee

Recommendation: defer final approval of the bed tower for twelve months. Proceed with design work. Approve construction if, over the next four quarters, the operating margin returns to at least [3] percent and days in accounts receivable fall to [47] or below. Reason: the hospital can borrow for the tower without breaching covenants, but the added depreciation and interest would nearly erase current operating income, leaving almost no room for further deterioration in payer mix or labor costs.

Historical Performance

Operating revenue: [$296.4], [$312.0] and [$327.0] million over three years. Operating income: [$17.1], [$19.1] and [$5.5] million. Operating margin: [5.8], [6.1] and [1.7] percent. The last year's decline came from expenses rising about twice as fast as revenue, led by agency staffing and supplies (Unit 2). Nonoperating gains of [$9.8] million held the bottom line above zero, but that cushion sits outside operations.

Ratio Dashboard

Liquidity: days cash on hand [191.0], above the peer median; days in receivables [52.5], worse than peers. Coverage: debt service coverage [3.46] times, down from [4.39]. Debt: debt to capitalization [34.0] percent. Plant: average age [13.9] years, older than peers, which supports the case for new beds (Unit 3). Indicators of this kind, tracked over time, are among the best early warnings of financial distress for hospitals (Pink et al., 2006).

Risks

Payer mix: a modest drift from commercial to Medicare Advantage and from Medicaid to self-pay could cut net revenue by about [$10.3] million (Unit 5). Receivables: [$6.4] million of cash sits in excess receivables (Unit 9). Labor: agency costs remain high and could rise again. National research on hospital profitability links a larger Medicare share and higher spending per discharge with weaker patient care profits (Bai & Anderson, 2016), and this hospital is drifting toward both. The tower is affordable under today's covenants but not under today's operations, and the gap between those two statements is the reason to wait.

The Pro Forma

Financing: borrow [$60] million at [5] percent over thirty years, adding about [$3.90] million of annual debt service; spend [$25] million of reserves. Debt service coverage: [3.46] falls to [2.57] times, above a typical covenant floor. Days cash on hand: [191.0] falls to [160.9]. Debt to capitalization: rises to [43.2] percent. Every covenant holds. Income effect: new depreciation of about [$2.43] million a year, over a [35]-year life, and first-year interest of about [$3.0] million add [$5.43] million of expense, nearly erasing the [$5.5] million of current operating income.

What New Beds Would Bring

The tower would add [48] private rooms and replace [40] semi-private beds, raising capacity and patient experience. If volume grows [four] percent and the payer mix holds, incremental operating income could reach [$4] million a year by year three, offsetting most of the new expense. But that volume is uncertain, and the payer mix is moving the wrong way.

How the Term's Analyses Fit Together

Each earlier analysis points to the same conclusion from a different angle. The statements showed expenses outrunning revenue; the ratios showed a strong balance sheet and weakening operations; the payer mix analysis showed revenue at risk; the budget and variance work showed where costs drift; the capital evaluation showed how sensitive a large project is to volume; and the revenue cycle review showed cash waiting to be collected. Together they say the hospital's constraint is operating performance, not borrowing capacity.

Options

1. Approve now: highest risk; operating losses likely if trends continue.

2. Defer twelve months with targets: proceed with design, preserve the option, require operational recovery first.

3. Reduce scope: build [30] beds in phase one for about [$55] million.

4. Cancel: avoids risk but leaves an aging plant.

Health care finance texts emphasize that capital capacity depends on operating cash flow as well as on balance sheet strength (Cleverley & Cleverley, 2018), which favors option 2 or 3.

The Two Targets

1. Operating margin at or above [3] percent for four consecutive quarters, achieved by reducing agency staffing and controlling supply costs.

2. Days in accounts receivable at or below [47], achieved through the revenue cycle improvements in Unit 9.

Meeting both would add roughly [$4.3] million to annual operating income and release about [$4.7] million of cash, restoring the room the tower needs.

What Management Must Do in the Next Twelve Months

1. Cut agency spending by half through recruitment and retention.

2. Implement real-time eligibility checks and a denial prevention team.

3. Renegotiate Medicare Advantage contracts with clearer authorization terms.

4. Report progress on both targets to the committee quarterly.

Questions Board Members Are Likely to Ask

Why not borrow while rates are reasonable? Because the cost of the tower is not only interest; depreciation and operating costs of new space would arrive whatever the rate, and operations cannot absorb them yet. Will construction costs rise if we wait? Probably, by about [four] to [five] percent a year. A year's delay may add [$3] to [$4] million, which is less than one year of the operating losses the tower could cause if approved now. Are we losing patients to competitors because of old rooms? Some, mostly in obstetrics and orthopedics; the design phase can test whether a smaller first phase addresses those service lines.

Community Considerations

The hospital is the only one in its county with intensive care. Its financial stability matters to the community more than any single building. Approving a project that weakens operations could put existing services at risk; deferring it while operations recover protects them.

Timeline for the Next Decision

Quarter 1: design development and baseline targets. Quarters 2 to 4: quarterly reports on both targets. Month 12: final decision on full scope, phased scope or further deferral.

Limits

Projections rest on assumptions about volume, payer mix and costs. Covenant terms vary. The bed tower's operating benefits are estimates.

Conclusion

The hospital can afford the tower on paper but not yet in practice. Deferring final approval for a year, while meeting two clear operating targets, protects the hospital's financial position and keeps the project alive.

References

Bai, G., & Anderson, G. F. (2016). A more detailed understanding of factors associated with hospital profitability. Health Affairs, 35(5), 889-897. https://doi.org/10.1377/hlthaff.2015.1193

Cleverley, W. O., & Cleverley, J. O. (2018). Essentials of health care finance (8th ed.). Jones & Bartlett Learning.

Pink, G. H., Holmes, G. M., D'Alpe, C., Strunk, L. A., McGee, P., & Slifkin, R. T. (2006). Financial indicators for critical access hospitals. The Journal of Rural Health, 22(3), 229-236. https://doi.org/10.1111/j.1748-0361.2006.00037.x