Experienced financial analyst / model developer needed for start-up financial model development
We’re seeking an experienced financial analyst / model builder to create an integrated Google Sheets model with:
P&L and pricing module:
- SKU-level costing and margin structure (frames, fabrics, labour, overheads)
- Pricing simulation model based on COGS and gross-margin inputs
- Sales and revenue forecasting (12 to 18 month view with 3-4 week cycles)
- P&L, cash-flow, and working-capital summary by month (with a 12-18 month forecast as well)
Inventory & Procurement Tracker
Valuation & Shareholding Module
- Pre-money and post-money valuation
- Cap-table builder (founder shares,potential equity grants)
- Scenario analysis for seed-round fundraising (equity vs. convertible notes)
- Sensitivity tables showing valuation vs. revenue growth, margin, and cash flow
Dashboard and reporting module:
- Visual summary of KPIs: margin %, break-even, inventory value, ROI, valuation trajectory
- Color-coded charts and investor-ready presention view
Deliverables
• 1 editable model in Google Sheets (ready for collaboration)
• Cleanly structured tabs: Inputs · Financials · Inventory · Valuation · Dashboard
• Short guide
Critical for us is to ensure that we can play with the inputs... buttons, drop downs, and other input types will help us play with multiple raw material types, sales scenarios etc.
Apply tot his job
Apply To this Job