Business · Stable
Financial Analyst: Skills, Projects & Interview Questions (2026)
Build financial models, analyze performance, and turn numbers into decisions for the business.
What a Financial Analyst actually does
Building models in Excel, analyzing variances, preparing MIS reports, and presenting findings to management.
Top hiring companies: Deloitte, KPMG, EY, Goldman Sachs, JPMorgan Chase, HDFC Bank.
Top industries: Banking & Financial Services, Consulting, IT / Tech, Manufacturing, FMCG.
Skills you need to become a Financial Analyst
| Skill | Importance | Learning hours | Interview weight |
|---|---|---|---|
| Financial Modeling | 10/10 | ~50h | High |
| Excel (Advanced) | 10/10 | ~40h | High |
| Accounting Fundamentals | 9/10 | ~40h | High |
| Valuation (DCF/Comps) | 9/10 | ~40h | High |
| Financial Statement Analysis | 9/10 | ~35h | High |
| Budgeting & Forecasting | 8/10 | ~30h | High |
| Variance Analysis | 8/10 | ~20h | Medium |
| Power BI / Tableau | 7/10 | ~30h | Medium |
| SQL | 6/10 | ~30h | Medium |
| Business Acumen | 8/10 | ~20h | High |
| Presentation & Communication | 8/10 | ~20h | High |
Core tools: Excel, PowerPoint, Power BI, Tally, SAP / ERP, Bloomberg Terminal, Google Sheets.
Financial Analyst learning roadmap
Beginner · 2-3 months
Foundations & core tooling
Build: Build a linked 3-statement model and analyze one company's financials with ratios.
Intermediate · 3-4 months
Applied, real-world builds
Build: Complete a DCF valuation and a budget-vs-actuals variance dashboard.
Advanced · 3-4 months
Production, scale & specialization
Build: Deliver an investment thesis with a full model, valuation, and clear recommendation.
8 Financial Analyst portfolio projects
3-Statement Financial Model
BeginnerBuild a fully linked income statement, balance sheet, and cash flow model.
Skills: Financial Modeling, Excel (Advanced), Accounting Fundamentals
Company Financial Health Analysis
BeginnerAnalyze three years of financials with ratio and trend analysis.
Skills: Financial Statement Analysis, Accounting Fundamentals, Excel (Advanced)
DCF Valuation of a Listed Company
IntermediateValue a public Indian company using discounted cash flow.
Skills: Valuation (DCF/Comps), Financial Modeling, Financial Statement Analysis
Comparable Company Analysis
IntermediateBuild a trading-comps sheet for a sector peer group with valuation multiples.
Skills: Valuation (DCF/Comps), Excel (Advanced), Financial Statement Analysis
Annual Budget & Variance Dashboard
IntermediateBuild a budget vs actuals dashboard with variance commentary.
Skills: Budgeting & Forecasting, Variance Analysis, Power BI / Tableau
Revenue Forecasting Model
IntermediateForecast revenue with clear drivers and scenario toggles.
Skills: Budgeting & Forecasting, Financial Modeling, Excel (Advanced)
Unit Economics & Profitability Analysis
AdvancedBreak down product or segment margins and recommend actions.
Skills: Financial Statement Analysis, Business Acumen, Excel (Advanced)
Investment Pitch Deck
AdvancedBuild a buy/sell thesis with a model and valuation for one stock.
Skills: Valuation (DCF/Comps), Presentation & Communication, Financial Modeling
Common Financial Analyst interview questions
Walk me through the three financial statements.Medium
What they're testing: IS -> BS -> CF; how they link via net income and cash
How does a Rs 10 increase in depreciation flow through the statements?Hard
What they're testing: IS, CF, and BS walkthrough including the tax effect
Walk me through a DCF.Medium
What they're testing: Project FCF, discount at WACC, add terminal value, sum to EV
What is WACC and how do you calculate it?Medium
What they're testing: Weighted cost of debt and equity; CAPM for cost of equity
EBITDA vs net income, and why use EBITDA?Medium
What they're testing: Operating proxy; strips financing, tax and non-cash items; know the limits
Compare the main valuation methods.Medium
What they're testing: DCF vs comps vs precedent; intrinsic vs relative value
What makes a good financial model?Medium
What they're testing: Clear assumptions, no hardcodes in formulas, auditable, flexible
How do you handle circular references from interest and debt?Hard
What they're testing: Enable iterative calc or use a circularity switch/macro
Explain working capital and its impact on cash.Medium
What they're testing: Receivables, inventory, payables; changes move cash flow
What is variance analysis?Easy
What they're testing: Budget vs actual; price, volume, mix drivers; commentary
Key Excel functions for a financial analyst.Easy
What they're testing: INDEX-MATCH, SUMIFS, XNPV, IRR, data tables
How would you improve a company's margins?Medium
What they're testing: Pricing, cost mix, volume, product mix, opex leverage
Certifications for Financial Analysts
- CFA (Chartered Financial Analyst)CFA Institute · Very High value
- Financial Modeling & Valuation Analyst (FMVA)Corporate Finance Institute · High value
- FRM (Financial Risk Manager)GARP · High value
- NISM Investment Adviser CertificationNISM (SEBI) · Medium value
Financial Analyst career path
Financial Analyst -> Senior Financial Analyst -> Finance Manager / FP&A Lead -> Finance Director / CFO
Common moves into this role / from here:
- → Investment Banking Analyst (6-9 months) — close: LBO modeling, deal execution, pitchbooks, M&A process, long hours
- → FP&A Manager (6-9 months) — close: Driver-based forecasting, business partnering, team leadership, BI tools
- → Equity Research Analyst (6-9 months) — close: Sector deep-dives, modeling depth, thesis writing, coverage initiation
- → Data Analyst (3-4 months) — close: SQL depth, Power BI/Tableau, Python (Pandas), dashboarding
Related roles: FP&A Analyst, Investment Analyst, Business Analyst, Credit Analyst
Frequently asked questions
What skills do you need to become a Financial Analyst?
Core skills include Financial Modeling, Excel (Advanced), Accounting Fundamentals, Valuation (DCF/Comps), Financial Statement Analysis. Keep assumptions visible and never hardcode numbers inside formulas.
What projects should a Financial Analyst build for a portfolio?
Strong starter projects: 3-Statement Financial Model; Company Financial Health Analysis; DCF Valuation of a Listed Company; Comparable Company Analysis.
How long does it take to become job-ready as a Financial Analyst?
A focused plan runs roughly 2-3 months for fundamentals, then applied projects. Difficulty rating: 5/10.
What is the career path for a Financial Analyst?
Financial Analyst -> Senior Financial Analyst -> Finance Manager / FP&A Lead -> Finance Director / CFO
Ready to become a Financial Analyst?
PrepNPlaced turns this guide into action — a day-by-day roadmap, ATS-ready resume, and real interview practice.
Start free →