3-Year Mental Hospital Financial Projections

I am planning a new mental health hospital in Windhoek and need a complete three-year financial model built entirely from scratch. The work must generate an integrated set of statements that I can take to lenders and potential investors.

Please structure the model in Excel (or Google Sheets if you prefer) with clearly separated assumption tabs so I can easily update items such as bed capacity, average length of stay, fee schedules, staffing levels, equipment costs, lease or build expenses, and local regulatory fees. From those inputs the file should automatically flow into:

• Income Statement
• Cash Flow Statement
• Balance Sheet

Accuracy and transparency are critical. Every formula should be traceable; no hard-coded numbers hidden in calculations. Local context is also essential, so factor in Namibian taxation, labor costs, medical aid reimbursement norms, and realistic occupancy ramp-up assumptions for a new facility.

Deliverables:
1. An editable Excel workbook with the three linked statements plus assumption and supporting schedules.
2. A brief PDF explaining key drivers, methodologies and any external data sources used.
3. One revision round after my review to fine-tune assumptions.

If you have healthcare or hospital modelling experience, let me know—the more specific your background, the faster we can finalise solid, investor-ready projections.