How to become a Financial Analyst

A complete, honest roadmap for the skills financial analysts actually use, from accounting and corporate finance through financial statement analysis, Excel, modelling, forecasting, variance analysis, valuation, data tools, communication, and AI. It runs top to bottom, foundational to advanced, so you always know what comes next. Free to read, no signup required.

1. 01

   Step 01Accounting fundamentals

   Accounting is the language of business, and a financial analyst has to be fluent. Everything else on this roadmap builds on understanding how the numbers are put together.

   • The three statements: The income statement, balance sheet, and cash flow statement, and what each one tells you.
   • How they connect: How net income flows to equity and cash, so a change in one statement moves the others. This is the core insight modelling relies on.
   • Accrual accounting: Why profit and cash are not the same thing, and why a profitable company can still run out of money.
   • Reading the numbers: Enough of debits, credits, and common line items to follow a real set of financial statements.

   Analysts who skip accounting fundamentals build models on sand. Understanding how the three statements link is what separates a real analyst from someone who copies a template.

   Income statementBalance sheetCash flowAccrual accountingHow statements link
2. 02

   Step 02Corporate finance fundamentals

   Finance theory gives you the tools to compare choices about money over time. These ideas underpin almost every decision an analyst supports.

   • Time value of money: Why a dollar today is worth more than a dollar next year, and how to discount future cash to today.
   • NPV and IRR: Judging whether an investment creates value, the everyday tools of capital decisions.
   • Risk and return: Why riskier investments demand higher expected returns, and how that shapes required rates.
   • Cost of capital: What it costs a company to fund itself, and why that rate is the hurdle every project must clear.

   Time value of moneyNPVIRRRisk & returnCost of capital
3. 03

   Step 03Financial statement analysis

   Reading statements is one skill; interpreting them is another. Analysis turns raw figures into a judgement about how a business is really doing.

   • Ratio analysis: Liquidity, profitability, efficiency, and leverage ratios, and what a healthy or worrying value looks like.
   • Trend analysis: Comparing periods to see where a business is improving or deteriorating, and asking why.
   • Comparisons: Benchmarking a company against its own history and its peers to judge performance in context.
   • Reading a report: Working through a real annual report or filing, including the notes where the important detail hides.

   RatiosTrend analysisBenchmarkingAnnual reportsFootnotes
4. 04

   Step 04Excel mastery

   Excel is where a financial analyst lives. Deep, fast, careful spreadsheet skill is one of the most valuable and testable abilities in the job.

   • Formulas & functions: Lookups, logical functions, and the everyday formulas that do the real work of analysis.
   • Pivot tables & data tools: Summarising and slicing data quickly, and running sensitivities with data tables.
   • Speed & shortcuts: Working efficiently with the keyboard, which matters both on the job and in timed interviews.
   • Clean structure: Laying out a workbook so it’s clear, auditable, and free of the errors that creep into messy sheets.

   Spreadsheet errors have caused real, expensive mistakes at large organisations. Careful structure and a habit of checking your work are as important as the formulas themselves.

   FormulasLookupsPivot tablesData tablesShortcutsClean layout
5. 05

   Step 05Financial modelling

   Building a model that projects a company’s future is a defining analyst skill. It ties the accounting, finance, and Excel work together.

   • The three-statement model: Linking the income statement, balance sheet, and cash flow so they move together as one connected model.
   • Assumptions & drivers: Building projections on clearly stated, sensible assumptions rather than numbers pulled from thin air.
   • Best practices: Separating inputs from calculations, keeping formulas consistent, and making a model someone else can follow.
   • Sensitivity analysis: Testing how the outcome changes when key assumptions do, since the future is a range, not a point.

   Three-statement modelAssumptionsModel structureSensitivity analysis
6. 06

   Step 06Forecasting & budgeting

   Much analyst work is planning the future: what a business will earn and spend, and whether it’s on track. This is the heart of financial planning and analysis.

   • Building forecasts: Projecting revenue and costs from real drivers rather than a flat percentage on last year.
   • Budgets: Turning plans into a budget teams are held to, and understanding how budgets are set and used.
   • Driver-based planning: Tying the forecast to the operational drivers behind it, so a plan can be understood and adjusted.
   • Rolling forecasts: Updating projections as reality unfolds instead of setting a number once a year and hoping.

   ForecastingBudgetingDriver-based planningRolling forecastsFP&A
7. 07

   Step 07Variance & cost analysis

   Plans meet reality, and the gap is where analysts add value. Explaining variances is a core, recurring part of the job.

   • Actual vs budget: Comparing results to plan and measuring the difference, the routine that drives most monthly reporting.
   • Explaining variances: Finding the real reasons behind a gap so leaders understand what happened, not only that it happened.
   • Cost analysis: Understanding fixed and variable costs and where money is actually going.
   • Actionable insight: Turning the analysis into a recommendation, since the point is a better decision, not a prettier table.

   Actual vs budgetVariance analysisCost analysisInsight
8. 08

   Step 08Valuation

   Putting a defensible number on what a business or asset is worth is a high-value analyst skill, common in corporate finance, investing, and strategy roles.

   • Discounted cash flow: Valuing a business by projecting its cash flows and discounting them to today, the foundational method.
   • Comparable companies: Valuing by comparison to similar public companies and the multiples they trade at.
   • Precedent transactions: Using what buyers actually paid for similar companies as another reference point.
   • Judgement: Knowing that valuation is a range built on assumptions, and being honest about the ones that matter most.

   A valuation is only as good as its assumptions. Precision in a model can hide how much the answer depends on a couple of judgement calls, so surface those rather than bury them.

   DCFComparable companiesPrecedent transactionsMultiplesAssumptions
9. 09

   Step 09Data analysis & tools

   Finance is moving beyond the spreadsheet for larger data. Some data and automation skill makes you faster and more capable than a spreadsheet alone allows.

   • SQL basics: Pulling data from a database directly, so you aren’t waiting on someone else for every number.
   • BI & dashboards: Building dashboards that report key metrics clearly, often with a tool like Power BI or Tableau.
   • Automation: Reducing repetitive manual work so more time goes to analysis and judgement.

   SQLPower BI / TableauDashboardsAutomation
10. 10

    Step 10Business communication

    Numbers change nothing until someone acts on them. Communicating findings clearly to non-financial audiences is what makes an analyst influential.

    • Executive summaries: Leading with the conclusion and the recommendation, then the supporting detail for those who want it.
    • Presenting numbers: Explaining figures so a non-financial leader understands the story and the decision they face.
    • Storytelling with data: Building a clear narrative from the analysis rather than reciting every calculation.
    • Written memos: Crisp, well-structured writing, since a lot of finance work is delivered on the page.

    The gap between a good analyst and a trusted one is usually communication. A perfect model nobody understands changes nothing.

    Executive summariesPresentingData storytellingMemos
11. 11

    Step 11Business acumen & AI in finance

    The best analysts understand the business behind the numbers, and increasingly use AI to work faster. Both raise the value of your judgement.

    • Understanding the business: Knowing what drives revenue and cost in your industry, so your analysis reflects how the business really works.
    • Unit economics: The economics of a single customer or product, which is where many financial questions actually start.
    • AI in the workflow: Using AI to draft analysis, build formulas, and summarise documents, with careful checking of every number.
    • Verifying AI output: Treating AI as a fast assistant, not an authority, since a confident wrong number is worse than no number.

    AI can speed up the mechanics of analysis, which raises the value of what it can’t do: understanding the business, questioning the assumptions, and standing behind the recommendation.

    Business acumenUnit economicsIndustry contextAI for analysisVerifying output