Skilled Nursing Facility Acquisition Financial Model   Excel template (XLSX)
$169.00

Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Log in to unlock full preview.
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Skilled Nursing Facility Acquisition Financial Model (Excel template (XLSX)) Preview Image
Arrow   Click main image to view in full screen. Unlock all 16 preview images:   Login Register

Skilled Nursing Facility Acquisition Financial Model – Excel XLSX

Excel (XLSX) + supplemental PDF

$169.00
Created by PDMM Financial Models, a specialist financial modeling provider focused on valuation, forecasting, feasibility analysis, investment returns, and decision-ready business planning tools.
Add to Cart
  


Immediate download
Fully editable Excel
Free lifetime updates

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.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

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


$169.00
Created by PDMM Financial Models, a specialist financial modeling provider focused on valuation, forecasting, feasibility analysis, investment returns, and decision-ready business planning tools.
Add to Cart
  

ABOUT THE AUTHOR

Author image
Additional documents from author: 88

PDMM Financial Models develops professional, decision-ready Excel models for business owners, entrepreneurs, investors, consultants, analysts, and finance teams. Our objective is to transform complex business assumptions into clear, structured analysis that supports better planning and investment decisions.

Our models cover business planning, forecasting, budgeting, feasibility analysis, ... [read more]

Ask the Author a Question

You must be logged in to contact the author.

Click here to log in Click here register

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.




Trusted by over 10,000+ Client Organizations
Since 2012, we have provided business templates to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab





Read Customer Testimonials

 
"As a consultant requiring up to date and professional material that will be of value and use to my clients, I find Flevy a very reliable resource.

The variety and quality of material available through Flevy offers a very useful and commanding source for information. Using Flevy saves me time, enhances my expertise and ends up being a good decision."

– Dennis Gershowitz, Principal at DG Associates
 
"Last Sunday morning, I was diligently working on an important presentation for a client and found myself in need of additional content and suitable templates for various types of graphics. Flevy.com proved to be a treasure trove for both content and design at a reasonable price, considering the time I "

– M. E., Chief Commercial Officer, International Logistics Service Provider
 
"As a consulting firm, we had been creating subject matter training materials for our people and found the excellent materials on Flevy, which saved us 100's of hours of re-creating what already exists on the Flevy materials we purchased."

– Michael Evans, Managing Director at Newport LLC
 
"Flevy is our 'go to' resource for management material, at an affordable cost. The Flevy library is comprehensive and the content deep, and typically provides a great foundation for us to further develop and tailor our own service offer."

– Chris McCann, Founder at Resilient.World
 
"I have used FlevyPro for several business applications. It is a great complement to working with expensive consultants. The quality and effectiveness of the tools are of the highest standards."

– Moritz Bernhoerster, Global Sourcing Director at Fortune 500
 
"[Flevy] produces some great work that has been/continues to be of immense help not only to myself, but as I seek to provide professional services to my clients, it gives me a large "tool box" of resources that are critical to provide them with the quality of service and outcomes they are expecting."

– Royston Knowles, Executive with 50+ Years of Board Level Experience
 
"I have found Flevy to be an amazing resource and library of useful presentations for lean sigma, change management and so many other topics. This has reduced the time I need to spend on preparing for my performance consultation. The library is easily accessible and updates are regularly provided. A wealth of great information."

– Cynthia Howard RN, PhD, Executive Coach at Ei Leadership
 
"As a niche strategic consulting firm, Flevy and FlevyPro frameworks and documents are an on-going reference to help us structure our findings and recommendations to our clients as well as improve their clarity, strength, and visual power. For us, it is an invaluable resource to increase our impact and value."

– David Coloma, Consulting Area Manager at Cynertia Consulting



Customers Also Like These Documents

Explore Templates on Related Management Topics



Your Recently Viewed Documents
Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.