What is a Financial Analyst?
A financial analyst studies financial data to help a business or investor make better decisions. They read financial statements, build forecasts and models, value companies and explain what the numbers mean in plain language.
Financial analysts work in corporate finance teams, banks, investment firms, consulting companies and startups. Their daily tools are Excel, financial statements, presentation slides and, more and more, data tools such as SQL, Power BI and Python.
How to use this financial analyst roadmap
Follow this financial analyst roadmap step by step. Each step builds on the one before it, so start with accounting basics even if they feel simple.
Use real company annual reports while you learn. Pick two or three listed companies you like and analyse them as you move through each step.
1Step 1: Finance and accounting basics
Learn the language of business: revenue, costs, profit, assets, liabilities and cash.
What is it?
The three financial statements tell the story of a company. The income statement shows profit over a period, the balance sheet shows what the company owns and owes on one date, and the cash flow statement shows where cash came from and went.
What to learn
You cannot analyse numbers you do not understand. Spend real time here. Our accountant roadmap goes deeper into accounting.
Example
text
Income statement (simple)
Revenue 1,000,000
Cost of sales -600,000
Gross profit 400,000
Operating expenses -250,000
Operating profit 150,000
Tax -30,000
Net profit 120,000Each line subtracts a type of cost until you reach net profit, the money left for the owners.
Helpful resource: Khan Academy: Economics and Finance
2Step 2: Excel for finance
Excel is the main tool of every financial analyst. Learn to work fast and accurately.
What is it?
Excel formulas let you calculate, look up and summarise data automatically. Financial analysts use them to build reports and models that update when inputs change.
What to learn
Learn absolute and relative references early. Most model errors come from wrong references.
Example
excel
=SUMIFS(D2:D500, B2:B500, "Marketing", C2:C500, "2026")
=XLOOKUP(G2, A2:A500, D2:D500, "Not found")
=IFERROR(D2/C2, 0)The first formula totals marketing spend for 2026, the second finds a value by ID, and the third avoids errors when dividing by zero.
Helpful resource: Microsoft Excel help and learning
3Step 3: Financial statement analysis
Use ratios and trends to judge how healthy and profitable a company is.
What is it?
Ratio analysis turns raw numbers into simple signals. For example, the current ratio shows if a company can pay its short-term bills, and net margin shows how much profit it keeps from each sale.
What to learn
A ratio alone means little. Compare it with past years and with similar companies.
Example
excel
Net profit margin = Net profit / Revenue
= 120,000 / 1,000,000 = 12%
Current ratio = Current assets / Current liabilities
= 500,000 / 250,000 = 2.0
Debt to equity = Total debt / Total equityA 12% margin means the company keeps 12 cents of profit from every 1 of revenue.
Helpful resource: CFI: Financial ratios
4Step 4: Financial modelling
Build models that forecast a company’s future performance.
What is it?
A financial model is a spreadsheet that links assumptions (like sales growth) to forecast statements. Change one assumption and the whole forecast updates.
What to learn
Keep inputs, calculations and outputs on separate sheets, and colour inputs blue so anyone can follow your model.
Example
excel
Year 1 revenue: =B5
Year 2 revenue: =C10*(1+$B$3)
B3 = growth rate assumption (10%)
B5 = starting revenueEach year’s revenue grows by the rate in cell B3. The $ signs lock the reference so it does not move when copied.
Helpful resource: CFI: Financial modeling guides
5Step 5: Valuation
Learn how to estimate what a business or share is worth.
What is it?
A DCF values a business by forecasting its future cash flows and converting them into today’s money with a discount rate. Money in the future is worth less than money today.
What to learn
Valuation is part science and part judgement. Always show the range of values, not one exact number.
Example
excel
=NPV(10%, C20:G20) + H20/(1+10%)^5
C20:G20 = free cash flow years 1 to 5
H20 = terminal valueNPV discounts five years of cash flows at 10%, then the terminal value is discounted and added.
Helpful resource: Investopedia: Discounted cash flow
6Step 6: Budgeting, forecasting and variance analysis
Help managers plan spending and explain differences between plan and actual results.
What is it?
Variance analysis compares what was planned with what really happened. It helps a business spot problems and opportunities early.
What to learn
Managers want to know why numbers changed, not only by how much. Always add a short explanation.
Example
excel
Variance = Actual - Budget
Variance % = (Actual - Budget) / Budget
=IF(D2>C2, "Over budget", "Within budget")A positive cost variance means spending was higher than planned, which managers need to explain.
Helpful resource: CFI: FP&A resources
7Step 7: Data tools: SQL, Power BI and Python
Modern analysts pull and visualise large data sets, not just spreadsheets.
What is it?
Data tools let you work with thousands or millions of rows quickly and repeat the same analysis every month without manual work.
What to learn
You do not need to become a programmer. Basic SQL and one dashboard tool already make you stand out. See our SQL roadmap.
Example
python
import pandas as pd
df = pd.read_csv("sales.csv")
monthly = df.groupby("month")["revenue"].sum()
print(monthly.pct_change().round(3))This reads a sales file, totals revenue by month and shows the month-on-month growth rate.
Helpful resource: Microsoft Learn: Power BI
8Step 8: Communication, reporting and certifications
Turn your analysis into clear advice and grow your credentials.
What is it?
Analysis is only useful if people understand it. A short memo with a clear recommendation is the most common output of a financial analyst.
What to learn
Lead with the answer, then support it with the numbers. Busy managers read the first paragraph only.
Example
text
Investment memo: Company X
Recommendation: Buy (target value 52, price 44)
Why:
1. Revenue grew 15% a year for 3 years
2. Margins improving from 9% to 12%
3. Low debt (debt/equity 0.3)
Risks: new competitors, currency movesA simple structure: recommendation first, three reasons, then the risks.
Helpful resource: CFA Institute
Financial Analyst roadmap project ideas
Projects turn what you learn into real skills. Build at least one project from each level below, and put every finished project on GitHub with a clear README.
Company ratio report
Analyse ten ratios for a listed company over three years.
Personal budget model
A monthly budget with savings goals and charts.
Three-statement model
Linked income statement, balance sheet and cash flow for five years.
Budget vs actual dashboard
Variance report with comments and charts in Excel or Power BI.
DCF valuation
Full DCF with WACC, scenarios and sensitivity table.
Investment pitch
Memo and slides recommending buy, hold or sell on a real company.
Tips to finish this financial analyst roadmap
- Learn by doing. Put every step into practice with a real or sample case. Practical work teaches far more than reading alone.
- Be consistent. One focused hour every day beats a long session once a week. Small daily progress adds up quickly.
- Build a portfolio. Save your best work, reports and case studies. A portfolio proves your skills to employers and clients.
- Find a mentor and a community. Talk to people already working in the field. Their advice saves you time and opens doors.
- Master the basics first. The fundamentals in this financial analyst roadmap change slowly. Learn them well before chasing new tools and trends.
Career paths and next steps
After this financial analyst roadmap, you can apply for roles such as junior financial analyst, FP&A analyst, credit analyst or investment analyst. With experience you can grow into senior analyst, finance manager, investment banker or CFO.
If you want stronger accounting foundations, follow our accountant roadmap, and for data skills see the data analyst roadmap.
Related roadmaps
Financial Analyst Roadmap FAQs
How long does it take to become a financial analyst?
With focused study, most learners cover this roadmap in six to twelve months. A finance or business degree helps, but strong Excel, modelling skills and a portfolio can also open doors.
Do financial analysts need to code?
Coding is not required for most roles, but SQL and basic Python or Power BI are becoming common and make you more competitive.
Which certification is best for a financial analyst?
The CFA is widely respected for investment roles. Shorter courses such as FMVA are useful for practical modelling skills. Choose based on the career path you want.
Is Excel still important for financial analysts?
Yes. Excel remains the core tool for models, budgets and reports in almost every finance team.