Financial Analysis Projects in Seattle
Financial Analysis Projects in Seattle
Sign Up
Post a job
Sign Up
Log In
Filters
2
Projects
People
22
Joy Z
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.
22
183
0
Joy Z
Salary and Benefits budget for grant tracking The goal was to build a spreadsheet that tracked all expenses on a grant budget, the salary and benefits being the most complex. The challenge was capturing all employees' varying start/end dates at varying amounts, and designed in a digestible way for non-finance users to understand. The spreadsheet needed to also account for one-off stipend amounts that didn't align to regular budget cycles. Figures have been randomized in attached pictures with names removed to maintain confidentiality.
0
28
Explore projects