SaaS Financial Excel Model Construction
Budget: £20 – £250 GBP
Project Title: Create Dynamic SaaS Financial Model (Excel) for a SaaS
Project Description: I am looking for an experienced financial modeler to create a full 5-Year SaaS Financial Model for my company, Kollabsy.
I have the raw data and revenue projections (Subscription, Transaction, Services), but I need a professional, working Excel model built that ties everything together dynamically.
Key Requirements:
Build the Core Model: Create a dynamic Excel workbook that generates a 3-Statement view (Income Statement, Cash Flow, Balance Sheet) based on my inputs.
Integrate Multiple Revenue Streams: The model must handle distinct revenue logic for:
Subscriptions: (MRR/ARR, Churn, Expansion).
Transactions: (Volume-based revenue).
Services: (One-time fees).
SaaS Metrics Dashboard: I need the model to automatically calculate key metrics (LTV, CAC, Magic Number, Rule of 40) based on the financial outputs.
Scenario Planning: The model should allow me to toggle assumptions (e.g., "Aggressive Growth" vs. "Conservative") to see the impact on cash flow.
Provided Materials: I will provide the Revenue Summary and Control data exports which contain our baseline numbers and structure. You will use these to build the logic and formulas.
Deliverable: A fully functional, unlocked .xlsx file with transparent formulas and a clean "Summary" dashboard.
Project Description: I am looking for an experienced financial modeler to create a full 5-Year SaaS Financial Model for my company, Kollabsy.
I have the raw data and revenue projections (Subscription, Transaction, Services), but I need a professional, working Excel model built that ties everything together dynamically.
Key Requirements:
Build the Core Model: Create a dynamic Excel workbook that generates a 3-Statement view (Income Statement, Cash Flow, Balance Sheet) based on my inputs.
Integrate Multiple Revenue Streams: The model must handle distinct revenue logic for:
Subscriptions: (MRR/ARR, Churn, Expansion).
Transactions: (Volume-based revenue).
Services: (One-time fees).
SaaS Metrics Dashboard: I need the model to automatically calculate key metrics (LTV, CAC, Magic Number, Rule of 40) based on the financial outputs.
Scenario Planning: The model should allow me to toggle assumptions (e.g., "Aggressive Growth" vs. "Conservative") to see the impact on cash flow.
Provided Materials: I will provide the Revenue Summary and Control data exports which contain our baseline numbers and structure. You will use these to build the logic and formulas.
Deliverable: A fully functional, unlocked .xlsx file with transparent formulas and a clean "Summary" dashboard.
Related categories:
Excel
Finance
Business Analysis
Financial Analysis
Data Analysis
Financial Forecasting
Financial Modeling
SaaS