Financial modelling
skills and careers

Financial modelling is building spreadsheet representations of a business or project to support decisions — budgets, fundraising, investments, acquisitions, pricing or loans. The work includes gathering historical data; setting assumptions and drivers; forecasting revenue, costs and capex; linking income statement, balance sheet and cash flow; adding debt, tax and working capital schedules; running scenarios and sensitivities; valuation such as discounted cash flow (DCF); building checks; and presenting outputs clearly. Good models are accurate, transparent and easy for others to follow and change.

Modelling skills are in demand across finance. AmbitionBox lists financial modelling analysts in India at a typical ₹6.5–7.2 lakh from a small sample,¹ and financial analysts — a much larger group that relies on modelling — at the same range from more than 55,000 salaries, up 20% in two years.² US financial analysts earn a $103,570 median.³ Free benchmark data, such as Aswath Damodaran's NYU Stern pages on industry margins and costs of capital, helps make assumptions realistic.⁴ Models matter most when cash is tight: CB Insights' 2026 analysis found capital ran out in 70% of startup shutdowns, with unsustainable unit economics a factor in 19%.⁵

Typical financial modelling analyst pay in India (AmbitionBox, small sample)

₹6.5–7.2 lakh

Two-year rise in financial analyst pay (AmbitionBox)

20%

US median, financial analysts (BLS, May 2025)

$103,570

Startup shutdowns where capital ran out (CB Insights, 2026)

70%

Table: How financial modellers are assessed (editorial summary)

Table: A clean financial model layout (illustrative)

Table: How financial modelling developed (editorial summary)

• A three-statement model for a listed company
• A startup model with cash runway
• Scenario and sensitivity tables
• A checks sheet that works
• A one-page output summary
• A verified financial modelling certificate

Show decisions supported: "Built three-statement model for ₹200 crore expansion; scenarios informed financing mix; created reusable template cutting model build time by half." Use real outcomes only.

"Walk me through how depreciation flows through the statements."

It reduces profit on the P&L, is added back in operating cash flow and reduces fixed assets on the balance sheet.

"Your balance sheet doesn't balance — how do you fix it?"

Check the cash flow links first, then each balance sheet movement, using the checks sheet to find where the difference starts.

"How do you choose assumptions?"

From history, management plans, industry benchmarks and logic, and document the source of each.

"What makes a model easy to audit?"

Consistent formulas across rows, colour-coded inputs, no hard-codes in calculations and clear labels.

"How do you present a model?"

Lead with the decision and key outputs, show scenarios and highlight the assumptions that matter most.

• "What decisions do models support?" — purpose.
• "Are there modelling standards?" — quality.
• "Who reviews models?" — control.
• "Which tools besides Excel?" — stack.

Table: Modelling-related roles and typical pay in India (AmbitionBox, October 2026; indicative)

Table: Common modelling tools (editorial guidance)

• Analyst — building schedules.
• Senior analyst / associate — full models.
• Manager — reviewing and presenting.
• Director / VP — deal or planning decisions.
• CFO or partner — strategy.

1. Week 1: Structure — Build a clean layout with inputs and checks.
2. Week 2: Statements — Link the three statements for a simple company.
3. Week 3: Prove it — Add scenarios and outputs; take the Financial Modelling Certification.

Related: Business Valuation, Budgeting and Forecasting and Unit Economics. Guides: business valuation, budgeting and forecasting and unit economics.

• Updates — new actuals.
• Requests — "what if?" questions.
• Scenarios — for decisions.
• Reviews — checking colleagues' models.
• Presentations — outputs for leaders.
• Templates — improving reuse.

"What's a circular reference?"

A formula that depends on its own result, often from interest calculations; avoid or handle deliberately.

"What's working capital in a model?"

Receivables, inventory and payables driven by days assumptions, affecting cash.

Table: A first-90-days plan (editorial guidance)

Learn your team's templates and formatting rules. Build schedules carefully and ask for reviews. By the third month, own a full model and present its outputs confidently.

AI now writes formulas, explains other people's models, builds first drafts and summarises outputs. That saves time, but AI-generated formulas can be subtly wrong, and models built by AI may hide assumptions. Strong modellers use AI as an assistant: they keep the structure clear, check every formula, test with checks and scenarios, and stay responsible for the logic.

Use a checks sheet: balance sheet balances, cash matches, subtotals add up. Scan rows for inconsistent formulas. Look for hard-coded numbers in calculation sheets. Test extreme inputs — zero revenue, double costs — and see if results make sense. Ask a colleague to review. Most expensive errors are simple ones nobody checked.

Open with the decision and recommendation. Show a summary of key outputs — revenue, profit, cash low point, value — under each scenario. Highlight the two or three assumptions that matter most and how sensitive results are to them. Keep detailed sheets for questions. Leaders want clarity, not formulas.

"More complex models are better." Simpler models are easier to trust and use.

"The model predicts the future." It explores possibilities based on assumptions.

"Modelling is just Excel skill." Business understanding drives good assumptions.

Startups have little history, so their models are driven by assumptions about customers and costs. Begin with the revenue engine: how many customers you can acquire each month, at what cost, how many stay and how much they pay. Model these as drivers on the inputs sheet — marketing spend, cost per acquisition, conversion, churn and price — rather than typing revenue directly.

Next, build the cost base: a hiring plan by role and month, salaries, tools, rent and variable costs per customer such as hosting or delivery. Add payment terms, because customers who pay in 60 days create a cash gap that a profit view hides. Then link everything to monthly statements and a cash balance.

The most important output is the cash low point: the month when cash is lowest and how far it falls. That tells founders how much to raise and when. Add scenarios for slower growth and higher churn, and show how long the runway lasts in each. Investors will test your assumptions, so keep them visible, sourced where possible and easy to change. A simple, honest startup model is far more useful than a complicated one nobody trusts.

• Hard-codes in formulas.
• No checks.
• Unclear assumptions.
• Unbalanced balance sheets.
• Cluttered outputs.

India pay comes from AmbitionBox (read October 2026); US pay from the Bureau of Labor Statistics (May 2025); benchmark data from Aswath Damodaran's NYU Stern pages; and startup cash data from CB Insights (March 2026). The founder scene, model structure and history are editorial. Science of Apps publishes the free test linked here. Last reviewed October 2026.

• Three-statement model — linked P&L, balance sheet and cash flow.
• Assumption — an input that drives forecasts.
• Sensitivity — how outputs change with inputs.
• DCF — discounted cash flow valuation.
• Checks — formulas that flag errors.