Basics of Financial Modelling

What You Will Learn
Foundations of financial statements and their interconnections
How to make financial models from scratch
Forecasting revenue, expenses, and profitability using logical assumptions
How to develop project finance models and perform sensitivity/scenario analysis
Business valuations using DCF (FCFE & FCFF) and relative valuation methods
Practical understanding of models using real companies like DMart and PVR
Building valuation-friendly models using Excel functions like IRR, WACC, and CAPM
Your Course Overview
11 sections • 55 topics • 15 hrs 23 mins content
1. Introduction
32 mins
Five glorious careers in finance
Start Learning
About the course
Start Learning
Five careers in finance
Start Learning
2. Summary of Financial Statements
1 hr
Understanding of IS, BS, CFS
Start Learning
Financial ratios
Start Learning
How to use Tickertape
Start Learning
3. Creating a First Model
59 mins
EBITDA forecast (F1)
Start Learning
Completing the first model (F2)
Start Learning
Resource Material
Download
4. Creating a Second Model from Scratch
2 hrs
Revenue
Start Learning
Fuel Cost
Start Learning
EBITDA
Start Learning
EBIT
Start Learning
BS and CFS
Start Learning
Debt
Start Learning
IRR
Start Learning
Sensitivity Analysis
Start Learning
Scenario Manager
Start Learning
Resource Material
Download
5. Creating Your Third Model from Scratch
59 mins
Quick revision
Start Learning
EBITDA forecast
Start Learning
PAT forecast
Start Learning
BS, CFS forecast
Start Learning
Resource Material
Download
6. Project Finance Model – Summary and Assignments
1 hr
Summary
Start Learning
Assignment V1
Start Learning
Assignment V2
Start Learning
Assignment V3
Start Learning
Quick recap
Start Learning
Resource Material
Download
7. Basics of DCF Valuation
1 hr
Project vs Business
Start Learning
Terminal value
Start Learning
CAPM
Start Learning
WACC
Start Learning
8. DCF Valuation Model – DMart
3 hrs
EBITDA Forecast
Start Learning
EBIT Forecast
Start Learning
BS, CFS Forecast
Start Learning
FCFE Model
Start Learning
Adjusting the Inputs
Start Learning
Calculating Beta
Start Learning
FCFF Model
Start Learning
3 Stage Model
Start Learning
Resource Material
Download
9. DCF Valuation Model – PVR
1 hr
EBITDA forecast (PV1)
Start Learning
PAT forecast (PV2)
Start Learning
BS and CFS forecast (PV3)
Start Learning
FCFE DCF valuation (PV4)
Start Learning
FCFF DCF valuation (PV5)
Start Learning
Summary (PV6)
Start Learning
Resource Material
Download
10. Relative Valuation – IT Sector
58 mins
Concept of relative valuation
Start Learning
IT companies relative valuation
Start Learning
Application of the concepts
Start Learning
Resource Material
Download
11. Next Steps and Projects
24 mins
Summary and projects
Start Learning
About The Course
How to Select the Right Equity Mutual Fund by Kirtan Shah is a practical course that teaches you how to evaluate, compare, and confidently invest in mutual funds. You will learn the importance of asset allocation, goal-based investing, fund categories, and key risk-return metrics like CAGR and Sharpe Ratio. With real-life examples and easy-to-follow strategies, this course helps you move beyond returns and choose funds that align with your goals. Perfect for investors, students, and advisors looking to make smarter, data-driven investment decisions.
In Lesson 1, Introduction, you will understand the purpose and structure of the course and why choosing the right equity mutual fund is a key pillar of successful investing.
In Lesson 2, Asset Allocation, you will learn why asset allocation is more important than picking the best-performing fund. Understand how balancing between equity, debt, and other assets impacts overall portfolio risk and return.
In Lesson 3, Goal-Based Investing, you will get an understanding of the time value of money through practical examples and a detailed case study. Learn how to link mutual fund investments to specific life goals like retirement, education, or wealth building.
In Lesson 4, Scheme Categorization, you will explore the different types of equity and hybrid mutual funds and learn how each category serves different investment needs and risk profiles.
In Lesson 5, Macro Economics Analysis, you will understand key macro factors like interest rates, inflation, economic cycles, and how they influence mutual fund performance and market behavior.
In Lesson 6, Different Types of Returns, you will learn terms like HPR, CAGR, IRR, and XIRR, and how rolling returns help measure consistency and performance beyond one-time snapshots.
In Lesson 7, Different Types of Risks, you will understand essential risk metrics like standard deviation and beta to measure volatility and market sensitivity of mutual funds.
In Lesson 8, Risk-Adjusted Returns & Practical Interpretation, you will learn about the Sharpe Ratio, the Treynor Ratio, and Jensen’s Alpha, and how to use them to compare funds not just by returns, but by how efficiently they manage risk.
In Lesson 9, Advanced Performance Metrics, you will learn advanced ratios and performance indicators, giving you a refined view of how different funds stack up.
In Lesson 10, How to Pick the Right Fund, you will learn how to evaluate and select the best fund, using historical data, forward-looking, and research-based approaches.
In Lesson 11, Bonus, you will gain hands-on skills in performance and portfolio analysis using real mutual fund examples, tying theory to practice.
Course Highlights :
- How to align mutual fund investments with your financial goals using goal-based planning
- The importance of asset allocation and how to apply it in real portfolios
- How to categorize equity and hybrid funds and select based on your risk profile
- Macroeconomic factors that impact fund performance
- How to calculate and interpret returns like HPR, CAGR, IRR, and XIRR
- The role of risk metrics like standard deviation and beta in evaluating volatility
- How to assess funds using risk-adjusted return ratios
- A complete framework to select the right mutual fund
Who is this course for :
- Individuals planning long-term investments through mutual funds
- Beginners and intermediate investors who want to learn how to pick the right equity mutual funds
- Working professionals looking to align investments with long-term financial goals
- Finance students and enthusiasts looking to gain practical, in-depth knowledge of equity mutual funds
- Anyone interested in optimizing returns with a balanced, risk-aware approach
Learn From - Suresh Varma

Director, FPA Edutech Pvt. Ltd.
8+ Years Experience in Finance
Suresh Varma
Suresh has over eight years of experience in investment banking and training, with an IIT engineering degree, and an IIM MBA, and has cleared CFA Level 3. He specializes in financial analysis, equity valuation, and financial modeling, delivering industry-relevant courses. With 4000+ hours of training experience, he simplifies complex financial concepts effectively.
Frequently Asked Questions
Do I need prior experience in finance?
What tools do I need for this course?
How will this course help me in my career?
How long will I have access to this course?
Will I get a certificate of completion?
₹---
This Course is not included in PRO