Dynamic Excel Financial Model & Dashboard Creation
Budget: ₹1,500 – ₹12,500 INR
We are working on the core 5-year financial projections (Revenue, Expenses, P&L, Cash Flow) for our subscription-based creator platform. We require an Excel expert to implement two critical features to make the model investor-ready and dynamic.
Specific Tasks Required:
Dynamic Scenario Switch Implementation:
1. Implement a Scenario Switch (Dropdown Menu) on the Inputs sheet to instantly toggle between three cases: Base-Case, Aggressive Growth, and Conservative.
Use advanced functions (INDEX/MATCH or HLOOKUP) and Data Validation to ensure all key drivers (e.g., Platform Fee, CAC, Referral Rate) throughout the P&L, Cash Flow, and DCF sheets update instantly based on the selection. This is the primary technical deliverable.
2. Interactive Investor Dashboard:
Create a clean, visually appealing, single-sheet Dashboard within the Excel file.
Build charts and tables that are dynamically linked to the Scenario Switch, ensuring they update with the data from the chosen scenario. Key visualizations include:
-Annual Net Platform Revenue Growth (Line/Bar Chart)
-Cash Flow & Peak Funding Requirement (Cumulative Cash Chart)
-Key Metrics Table (LTV:CAC Ratio, Year 5 Revenue, Burn Rate).
Looking forward to applications from ideal candidates. My max budget for this task is $100
Specific Tasks Required:
Dynamic Scenario Switch Implementation:
1. Implement a Scenario Switch (Dropdown Menu) on the Inputs sheet to instantly toggle between three cases: Base-Case, Aggressive Growth, and Conservative.
Use advanced functions (INDEX/MATCH or HLOOKUP) and Data Validation to ensure all key drivers (e.g., Platform Fee, CAC, Referral Rate) throughout the P&L, Cash Flow, and DCF sheets update instantly based on the selection. This is the primary technical deliverable.
2. Interactive Investor Dashboard:
Create a clean, visually appealing, single-sheet Dashboard within the Excel file.
Build charts and tables that are dynamically linked to the Scenario Switch, ensuring they update with the data from the chosen scenario. Key visualizations include:
-Annual Net Platform Revenue Growth (Line/Bar Chart)
-Cash Flow & Peak Funding Requirement (Cumulative Cash Chart)
-Key Metrics Table (LTV:CAC Ratio, Year 5 Revenue, Burn Rate).
Looking forward to applications from ideal candidates. My max budget for this task is $100