К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Equity Research & Financial Modeling in Excel · LearnSpace
Назад в каталог
courseraБизнес

Equity Research & Financial Modeling in Excel

Курс от EDUCBA
Уровень не указан≈ 15.7 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Financial ModelingFinancial ForecastingFinancial StatementsFinancial Statement AnalysisBalance SheetCash FlowsIncome StatementCash Flow ForecastingRevenue ForecastingEquitiesFinancial AnalysisPrivate EquityMarket DynamicsFinancial AccountingMarket AnalysisBusiness ValuationExcel FormulasFinancial Data

Программа курса

6 модулей · 82 учебных материалов

01Company & Industry Foundations15 материалов

Introduction to Business & Product

Introduction to Praj Industries LtdВидеоHow Company Makes EthanolВидеоIntroduction to Business & ProductЗадание

Industry Overview & Segments

Ethanol Industry OverviewВидео

Учитесь у экспертов

EDUCBA

Преподаватель курса

Equity Research & Financial Modeling in Excel
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 15.7 ч

6 модулей

Язык: Английский

Часть программы вашего университета
Ethanol SegmentВидео
Industry Overview & SegmentsЗадание

Market Expansion & Opportunities

Learn Emerging MarketВидеоPunching Qtrly Consol Income Statement (IS)ВидеоMarket Expansion & OpportunitiesЗадание

Management Insights & Performance

Management HighlightsВидеоQuarterly Income Statement AnalysisВидеоManagement Insights & PerformanceЗаданиеAnalyzing Ethanol Industry Demand and Business Model FitDIALOGUECompany & Industry FoundationsЗаданиеEvaluating Ethanol Industry Demand and Business Model FitDIALOGUE
02Financial Statement Input (Income Statement Focus)13 материалов

Business Developments & Data Input

Key DevelopmentsВидеоPunching Quarterly Standalone Income StatementВидеоBusiness Developments & Data InputЗадание

Standalone Statement Continuation

Punching Quarterly Standalone Income Statement ContinuesВидеоLinkages of Console Yearly IncomeВидеоStandalone Statement ContinuationЗадание

Annual Income Statement Analysis

More on Console Yearly Income StatementВидеоCalculating Total RevenueВидеоAnnual Income Statement AnalysisЗадание

Balance Sheet Data Entry Basics

Punching Consolidated Balance Sheet itemsВидеоPunching Consolidated Balance Sheet items ContinuesВидеоBalance Sheet Data Entry BasicsЗаданиеFinancial Statement InputЗадание
03Cash Flow & Demand Drivers13 материалов

Cash Flow Construction

Punching Consolidated Cash Flow ItemsВидеоProjecting Actual FY16 Cash Flow without Annual ReportВидеоCash Flow ConstructionЗадание

Macro Demand Drivers

Projections of Petrol Demand in IndiaВидеоPetroleum Planning and Analysis CellВидеоMacro Demand DriversЗадание

Industry Demand & Order Flow

Projections of Ethanol DemandВидеоIncremental Order Flows for EPC PlayersВидеоIndustry Demand & Order FlowЗадание

Order Flow Sensitivity & Segments

Sensitivity Analysis for Overall Order FlowsВидеоProjection of Brewery Order FlowsВидеоOrder Flow Sensitivity & SegmentsЗаданиеCash Flow & Demand DriversЗадание
04Revenue Modeling & Assumptions13 материалов

Assumptions & Market Expansion

Console Assumption SheetВидеоProjection of Emerging Market Order FlowsВидеоAssumptions & Market ExpansionЗадание

Revenue Forecasting

Projections of RevenuesВидеоMore on Projections of RevenuesВидео Revenue ForecastingЗадание

Cost Forecasting

Projection of Operating CostВидеоProjection of Operating Cost ContinuesВидеоCost ForecastingЗадание

Margin Analysis

Operating MarginsВидеоLinking Operating MarginsВидеоMargin AnalysisЗаданиеRevenue Modeling & AssumptionsЗадание
05Advanced Income Statement Projections13 материалов

Forex & External Impacts

How to Calculate Forex Gain or LossВидеоHow to Calculate Forex Gain or Loss ContinuesВидеоForex & External ImpactsЗадание

Other Income & Adjustments

Projection of Other IncomeВидеоProjection of DepreciationВидеоOther Income & AdjustmentsЗадание

Cost Allocation & Financing

Projection of AmortizationВидеоProjection of Finance CostВидеоCost Allocation & FinancingЗадание

Final Income Statement Items

Projection other Income Statement ItemsВидеоProjection of Balance Sheet ItemsВидеоFinal Income Statement ItemsЗаданиеAdvanced Income Statement ProjectionsЗадание
06Balance Sheet, Cash Flow & Valuation15 материалов

Balance Sheet Completion

Projection of Balance Sheet Items ContinuesВидеоCalculating Trade PayableВидеоBalance Sheet CompletionЗадание

Cash Flow Projections

Projection of Cash Flow StatementВидеоProjection of Cash Flow Statement ContinuesВидеоCash Flow ProjectionsЗадание

Valuation – PE Analysis

How to Draw 1 Year Rolling PE ChartВидеоHow to Draw 1 Year Rolling PE Chart ContinuesВидеоValuation – PE AnalysisЗадание

Final Output & Summary

How to Draw 2 year Rolling PE ChartВидеоPreparation of Summary SheetВидеоPreparation of Summary Sheet ContinueВидеоFinal Output & SummaryЗаданиеBalance Sheet, Cash Flow & ValuationЗаданиеBuilding an Equity Research Model for an Ethanol EPC CompanyDIALOGUE