← All certificate courses
Certificate courseFinanceIntermediate
Financial Analysis & Excel Modelling
Read financial statements like an analyst, compute the ratios that matter, build clean three-statement and budgeting models in Excel, and value a business with DCF and multiples.
About 1 h of reading, plus practice5 modules · 25 quiz questions · final exam
Skills you'll learn
What you'll be able to do
- Read and connect the income statement, balance sheet and cash flow statement
- Analyse profitability, liquidity, leverage and efficiency with ratios
- Build structured, auditable Excel models with clear assumptions
- Forecast revenue and costs, and run budgets, variances and scenarios
- Value a company with DCF and trading multiples, and explain the result
Syllabus
- 1
The three financial statements
5 min5-question quiz- The income statement (profit and loss)
- The balance sheet
- The cash flow statement
- How the statements link
- Profit versus cash: why companies fail while "profitable"
- Where to find real numbers
- Summary
- 2
Ratio analysis
5 min5-question quiz- Profitability
- DuPont analysis
- Efficiency and working capital
- Liquidity: can it pay its bills?
- Solvency and leverage: how risky is the debt?
- Market ratios (listed companies)
- Using ratios well
- Summary
- 3
Building professional Excel models
5 min5-question quiz- Structure: inputs, calculations, outputs
- Formatting conventions
- Formula discipline
- Building blocks of a three-statement model
- Checks
- Sensitivity and scenarios
- Review and version control
- Excel productivity
- Summary
- 4
Budgeting, forecasting and variance analysis
5 min5-question quiz- Budgets and forecasts
- Approaches to budgeting
- Driver-based forecasting
- Fixed, variable and break-even
- Variance analysis
- The monthly reporting pack
- Cash planning
- Indian context to know
- Summary
- 5
Valuation: DCF and multiples
5 min5-question quiz- Time value of money
- Free cash flow
- The discount rate: WACC
- Terminal value
- From enterprise value to equity value
- Relative valuation: multiples
- Bringing it together
- Summary
- ★Final exam & certificate15 questions · 30 minutes · 70% to pass · 3 tries
Your certificate
HireSol certified in Financial Analysis & Excel Modelling
Signed by HireSol and verifiable online with its own ID. Download it as a PDF, add it to LinkedIn in one click, and it shows on your HireSol profile to companies.
Questions
- Who is this course for?
- College students, freshers and anyone switching careers who wants a job-ready grounding in Financial Analysis & Excel Modelling. It's an intermediate course; every module explains the ideas with worked examples from real jobs.
- Is the course online and self-paced?
- Yes. It's fully online: about 1 hours of reading across 5 modules, on your phone or laptop, whenever it suits you.
- How do I get the certificate?
- Pass the quiz at the end of each module (70% or more), then the final exam: 15 questions drawn from a larger pool, 30 minutes, 70% to pass, 3 tries. Your certificate is issued the moment you pass.
- Can recruiters check that my certificate is real?
- Yes. Every certificate has its own page on hiresol.cloud with an ID and a digital signature from HireSol, so anyone can verify your name, the course, your score and the date.
- What happens if I fail the final exam?
- You have 3 tries, with new questions each time. If all 3 miss the mark, the course locks and you can unlock it again to start over.