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:

  1. Revenue model clarity — are revenue streams well-defined and realistic?
  2. Cost structure awareness — are all significant costs accounted for?
  3. Growth assumptions — are growth rates justified by market evidence?
  4. Cash flow timing — does the cash flow timeline account for payment delays?
  5. Sensitivity awareness — what happens if key assumptions are wrong?
  6. Benchmark alignment — do margins match industry norms?
  7. 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

Related