Hospital (Health Centre) Financial Model

Description
Financial model template for a hospital business. Hospital provides goods and services to treat patients with curative, preventive, rehabilitative, and palliative care. The model uses a detailed breakdown of revenue streams, direct costs and indirect costs to estimate operating assumptions on a per patient/bed, % of revenue and growth basis. All the fixed assets, current assets and liabilities are calculated to correctly ascertain financial position and solvency of the business. The model then uses Break-even analysis, Scenario analysis, ratio analysis and Discounted cash-flow.

Model has in-patient, out-patient and medical services revenue segments with all relevant cost KPIs for a hospital.

This model provides a framework to forecast next 12 years and correctly value the business in case of any investing/acquisition need arises. Highlights of this model are:
• Forecast for next 12 years (can be edited)
• Detailed breakdown of revenue and cost assumptions.
• Key Assumptions sheet to bring all important assumptions in one sheet
• Finsummary and Summary sheet to easily present analysis to stakeholders
• Fixed Asset schedule to accurately calculate depreciation and investment needs
• Break-even and Scenario analysis for better understanding of different business situations
• Detailed Profit and loss statement, Balance Sheet and Cash-flow
• Discounted cash-flow and ratio analysis for valuation
• Sensitivity Analysis for WACC

This model can be used by Owners and outsiders (Analysts, Bankers etc.). This model will be useful to apply for loans or pitch to raise capital.

The model was developed using financial modelling best practice standards. Should you have any questions on the model you're welcome to Private Message me.