Skilled Nursing Facility Acquisition Financial Model – Excel XLSX

BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT

1. Underwrite an SNF acquisition with linked census, reimbursement, staffing, debt, financial statements and equity-return logic.
2. Quantify turnaround value creation across occupancy, payer mix, labor, quality, working capital and operating initiatives.
3. Stress-test DSCR, valuation and investor returns with Downside/Base/Upside cases and two-way sensitivities.

FINANCIAL MODELING EXCEL DESCRIPTION

Skilled Nursing Facility Acquisition Financial Model is an Excel template (XLSX) with a supplemental PDF document available for immediate download upon purchase.

This Skilled Nursing Facility Acquisition Financial Model is a fully editable Excel decision system for evaluating the acquisition, financing, turnaround and long-term performance of an existing nursing facility. It is designed for skilled nursing operators, independent sponsors, healthcare investors, lenders, transaction advisors, consultants and management teams that need more than a generic nursing-home forecast.

The model combines transaction underwriting with operating detail. A centralized scenario manager controls Downside, Base and Upside assumptions for licensed and available beds, occupancy, payer mix, reimbursement, staffing, agency utilization, wage inflation, operating-cost inflation, purchase price, transaction costs, renovation capex, leverage, interest rate, debt amortization, exit multiple, discount rate, tax rate and exit year. The selected scenario flows through the full model.

The first 36 months are modeled in monthly detail, allowing the user to track census recovery, occupied beds, resident days, admissions, length of stay, payer mix and labor normalization during the core turnaround period. Years 4 through 10 extend the forecast for long-term operating and valuation analysis.

Medicare FFS reimbursement is modeled through a dedicated PDPM engine covering PT, OT, SLP, Nursing, NTA and non-case-mix components, with case-mix, wage and variable-per-diem logic. Medicare Advantage is modeled separately through negotiated-rate and haircut assumptions. Medicaid, private pay and other payers have their own rate and revenue schedules. This separation lets the user evaluate payer economics rather than applying a single blended rate to all resident days.

The staffing schedule converts census and HPRD assumptions into RN, LPN/LVN, CNA and therapy hours. Employee and agency labor are separated, with wage inflation, benefits burden and agency premium assumptions. A dedicated VBP and quality schedule includes eight configurable quality measures, a weighted score, payment multiplier and Medicare FFS revenue impact.

The workbook also includes departmental operating expenses, capex and maintenance, payer-specific working capital, a 24-month turnaround initiative schedule, sources and uses, senior debt amortization, DSCR, and integrated income statement, balance sheet and cash flow statement. Valuation combines DCF and exit-multiple analysis with exit debt, exit equity, equity MOIC and an IRR proxy.

Decision dashboards summarize operating recovery, reimbursement, staffing, quality, debt coverage and investor returns. Two-way sensitivity tables allow the user to test transaction and operating risk drivers, including purchase price, exit multiple, occupancy, reimbursement, wage inflation and agency utilization. An Audit and Integrity sheet independently checks core arithmetic and model relationships, while the Methodology and Sources sheet explains the calculation approach and source framework.

The primary document is the 28-sheet Excel workbook. The secondary document is a 28-page full-sheet PDF preview, with one page per worksheet for marketplace review.

Source: Best Practices in Financial Modeling, Healthcare Excel: Skilled Nursing Facility Acquisition Financial Model Excel (XLSX) Spreadsheet, PDMM Financial Models