When you enroll in this course, you'll also be enrolled in this Specialization.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate
There are 6 modules in this course
Master equity research and financial modeling techniques used by professional analysts to evaluate companies and investment opportunities. Learn how to analyze financial statements, forecast revenues and cash flows, build integrated financial models, and apply valuation methods using real-world company data.
This course provides a practical, step-by-step approach to equity research modeling through the real-world case study of Praj Industries and the capital goods sector. You’ll explore industry dynamics, macroeconomic demand drivers, and company-specific growth factors while learning how analysts convert business insights into financial projections and investment decisions.
Through structured lessons and Excel-based implementation, you’ll build integrated income statement, balance sheet, and cash flow models while learning how to forecast revenues, margins, operating costs, and profitability drivers. The course also explores advanced modeling topics including forex impact, non-operating income adjustments, cash flow analysis, and PE-based valuation techniques used in equity research.
A unique feature of this course is its complete end-to-end financial modeling workflow that combines conceptual finance knowledge with practical implementation skills. This enables learners to move beyond theory and develop job-ready analytical capabilities used in equity research, investment banking, and corporate finance roles.
By the end of the course, you’ll be able to construct professional financial models, interpret key valuation metrics, analyze company performance, and make informed investment decisions with greater confidence.
This module introduces learners to Praj Industries and the broader ethanol industry, helping them understand business models, industry structure, and key growth drivers shaping the capital goods sector.
What's included
8 videos5 assignments
Show info about module content
8 videos•Total 72 minutes
Introduction to Praj Industries Ltd•10 minutes
How Company Makes Ethanol•11 minutes
Ethanol Industry Overview•6 minutes
Ethanol Segment•9 minutes
Learn Emerging Market•12 minutes
Punching Qtrly Consol Income Statement (IS)•10 minutes
This module focuses on building a strong foundation in financial data entry, enabling learners to input, structure, and link income statement and balance sheet data for accurate financial modeling.
What's included
8 videos5 assignments
Show info about module content
8 videos•Total 72 minutes
Key Developments•11 minutes
Punching Quarterly Standalone Income Statement•9 minutes
Punching Quarterly Standalone Income Statement Continues•11 minutes
Linkages of Console Yearly Income•11 minutes
More on Console Yearly Income Statement•10 minutes
This module helps learners understand cash flow construction and macroeconomic demand drivers, enabling them to evaluate industry demand, order flows, and their impact on financial projections.
What's included
8 videos5 assignments
Show info about module content
8 videos•Total 83 minutes
Punching Consolidated Cash Flow Items•11 minutes
Projecting Actual FY16 Cash Flow without Annual Report•11 minutes
Projections of Petrol Demand in India•9 minutes
Petroleum Planning and Analysis Cell•10 minutes
Projections of Ethanol Demand•9 minutes
Incremental Order Flows for EPC Players•11 minutes
Sensitivity Analysis for Overall Order Flows•12 minutes
Projection of Brewery Order Flows•9 minutes
5 assignments•Total 70 minutes
Cash Flow Construction•10 minutes
Macro Demand Drivers•10 minutes
Industry Demand & Order Flow•10 minutes
Order Flow Sensitivity & Segments•10 minutes
Cash Flow & Demand Drivers•30 minutes
Revenue Modeling & Assumptions
Module 4•2 hours to complete
Module details
This module focuses on forecasting revenues and costs using structured assumptions, helping learners build realistic financial projections and evaluate profitability through margin analysis.
What's included
8 videos5 assignments
Show info about module content
8 videos•Total 68 minutes
Console Assumption Sheet•5 minutes
Projection of Emerging Market Order Flows•12 minutes
Projections of Revenues•11 minutes
More on Projections of Revenues•9 minutes
Projection of Operating Cost•8 minutes
Projection of Operating Cost Continues•8 minutes
Operating Margins•9 minutes
Linking Operating Margins•7 minutes
5 assignments•Total 70 minutes
Assumptions & Market Expansion•10 minutes
Revenue Forecasting•10 minutes
Cost Forecasting•10 minutes
Margin Analysis•10 minutes
Revenue Modeling & Assumptions•30 minutes
Advanced Income Statement Projections
Module 5•2 hours to complete
Module details
This module covers advanced components of financial modeling, including forex impact, non-operating income, and cost allocations, enabling learners to build detailed and accurate income statement projections.
What's included
8 videos5 assignments
Show info about module content
8 videos•Total 76 minutes
How to Calculate Forex Gain or Loss•8 minutes
How to Calculate Forex Gain or Loss Continues•8 minutes
Projection of Other Income•7 minutes
Projection of Depreciation•10 minutes
Projection of Amortization•8 minutes
Projection of Finance Cost•11 minutes
Projection other Income Statement Items•11 minutes
Projection of Balance Sheet Items•12 minutes
5 assignments•Total 70 minutes
Forex & External Impacts•10 minutes
Other Income & Adjustments•10 minutes
Cost Allocation & Financing•10 minutes
Final Income Statement Items•10 minutes
Advanced Income Statement Projections•30 minutes
Balance Sheet, Cash Flow & Valuation
Module 6•2 hours to complete
Module details
This module integrates balance sheet projections, cash flow analysis, and valuation techniques, enabling learners to complete financial models and derive actionable investment insights.
What's included
9 videos5 assignments
Show info about module content
9 videos•Total 80 minutes
Projection of Balance Sheet Items Continues•11 minutes
Calculating Trade Payable•7 minutes
Projection of Cash Flow Statement•8 minutes
Projection of Cash Flow Statement Continues•8 minutes
How to Draw 1 Year Rolling PE Chart•10 minutes
How to Draw 1 Year Rolling PE Chart Continues•5 minutes
How to Draw 2 year Rolling PE Chart•10 minutes
Preparation of Summary Sheet•10 minutes
Preparation of Summary Sheet Continue•11 minutes
5 assignments•Total 70 minutes
Balance Sheet Completion•10 minutes
Cash Flow Projections•10 minutes
Valuation – PE Analysis•10 minutes
Final Output & Summary•10 minutes
Balance Sheet, Cash Flow & Valuation•30 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.