Excel model: 5-year forecast for new facility

I created a pro forma to forecast the financial impact of building a new healthcare facility. In the model, I built in dynamic levers to account for changes in operations, such as staff, number of available rooms in the building, and changes to state policy affecting revenue drivers. Model was built to be driver-based such that key drivers lived in their own tabs, and fed to primary summary pages for exec review.

Figures have been randomized in attached pictures with names removed to maintain confidentiality.