Financial Modeler
Multi-year projections, sensitivity analysis, and scenario planning
What It Does
Builds comprehensive financial models for your business plan with 3–5 year projections, three-scenario sensitivity analysis, unit economics, and break-even calculations. Grounded in the I-P-O-C framework (Investment, Profitability, Operating costs, Cash flow).
Agent
Hermione
Research Analyst
Category
Generation
~10 minutes
Invoke
@financial-modeler
I-P-O-C Framework
The financial model is structured around four key areas:
Investment
Initial funding requirements, capital allocation, and use of funds. How much do you need and where will it go?
Profitability
Revenue projections, gross margins, and path to profitability. When does the business become self-sustaining?
Operating Costs
Fixed and variable costs, hiring plans, and overhead. What does it cost to run the business month by month?
Cash Flow
Monthly cash position, burn rate, and runway. How long can you operate before needing additional funding?
What It Produces
P&L Projections
Year-by-year revenue, cost of goods sold, gross margin, operating expenses, EBITDA, and net income.
Sensitivity Analysis
Three scenarios — base, optimistic, and pessimistic — showing how key assumptions affect outcomes. Tests variables like customer acquisition rate, churn, and pricing.
Unit Economics
Customer Acquisition Cost (CAC), Lifetime Value (LTV), LTV:CAC ratio, payback period, and monthly recurring revenue.
Break-Even Analysis
Month and year when cumulative revenue exceeds cumulative costs. Includes UK job creation milestones required for visa compliance.
Funding Requirements
Total funding needed, suggested raise structure, and how investment maps to milestones.
Seven Financial Cognitions
The knowledge system ensures Hermione evaluates your financials through seven lenses:
- Revenue model clarity — are revenue streams well-defined and realistic?
- Cost structure awareness — are all significant costs accounted for?
- Growth assumptions — are growth rates justified by market evidence?
- Cash flow timing — does the cash flow timeline account for payment delays?
- Sensitivity awareness — what happens if key assumptions are wrong?
- Benchmark alignment — do margins match industry norms?
- Funding coherence — does the ask match the runway needed?
Tips
- Start with conservative assumptions — endorsement bodies prefer realistic projections over optimistic ones
- Include UK job creation numbers — this is a key visa requirement showing scalability
- Show your working — explain how you arrived at revenue figures, not just the numbers
- Run sensitivity analysis — demonstrating you have considered downside scenarios shows maturity