Financial Model
Nicolas Jusid
Data Modelling Analyst
Financial Analyst
Business Analyst
Microsoft Excel
Visual Studio Code
My client required a robust Financial Model deveolped for a subscription based music themed app in development which needed to be simple to understand while relying on complex backend calculations. On top of the formulas involved in calculating all the different elements, the template also counts with a simple assumptions tab that the client can edit as needed to view different scenarios and an automated function to add new bands into the model and refresh calculations through VBA scripts.
Assumptions Tab
Automated VBA form for the client to insert new bands and refresh the model
Detailed calculatinos per band
Total Revenue and Expenses
