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

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

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

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

Financial Modeling & Valuation: Analyze & Forecast

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

О курсе

Build practical financial modeling and valuation skills by creating a complete financial model based on the real-world case of Big Books Corp. In this hands-on course, you'll progress from analyzing historical financial performance and forecasting revenues to constructing integrated financial statements and performing business valuation using Excel. You'll learn how to forecast revenue, SG&A, capital expenditures, depreciation, amortization, working capital, debt, and equity while linking the income statement, balance sheet, and cash flow statement into a dynamic financial model. As you advance, you'll calculate key valuation metrics including Free Cash Flow to the Firm (FCFF), Free Cash Flow to Equity (FCFE), Net Present Value (NPV), Discounted Cash Flow (DCF), WACC, enterprise value, equity value, EV/Revenue, and EV/EBITDA to evaluate business performance and compare companies. Designed for learners interested in financial modeling, valuation, corporate finance, equity research, and investment analysis, this course emphasizes both model construction and interpretation. Rather than focusing only on formulas, you'll understand how financial assumptions influence forecasts, valuation outcomes, and business decisions. By the end of the course, you'll be able to build, analyze, forecast, and interpret comprehensive financial models while applying both intrinsic and relative valuation techniques to assess company performance with confidence.

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

Income StatementFinanceExcel Formulas

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

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

01Introduction and Revenue Forecasting11 материалов

Company and Revenue Overview

Overview of Big Books CorpВидеоSegment Wise Revenue CalculationsВидеоRevenue Forecasting - Notebook SegmentВидеоCompany and Revenue OverviewЗадание

Financial Modeling Foundation

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

EDUCBA

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

Financial Modeling & Valuation: Analyze & Forecast
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.7 ч

8 модулей

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

Субтитры: Казахский

Часть программы вашего университета
Purpose of Buiding a Financial ModelВидео
Calculating the Total Revenue from All SegmentsВидео
Calculating Cost of SalesВидео
Financial Modeling FoundationЗадание
Forecasting Revenue Drivers for Big Books Corp: From History to Future AssumptionsDIALOGUE
Introduction and Revenue ForecastingЗадание
Forecasting Revenue for Big Books Corp: Segment-Level AnalysisDIALOGUE
02Operating Expenses and Linkages8 материалов

SG&A and Financial Linkages

Calculating SG and A ExpensesВидеоLinking Revenue and ExpensesВидеоSG&A and Financial LinkagesЗадание

Depreciation and Capital Expenditure Basics

Depreciation and Gross PPEВидеоUnderstanding Capital ExpenditureВидеоCalculating Segment wise CapexВидеоDepreciation and Capital Expenditure BasicsЗаданиеOperating Expenses and LinkagesЗадание
03Depreciation and Amortization8 материалов

Detailed Depreciation Calculations

Depreciation InputsВидеоDepreciation Calculation - Machinery and EquipmentsВидеоDepreciation Calculations ContinuedВидеоDetailed Depreciation CalculationsЗадание

Amortization and Linkages

Amortization CalculationsВидеоLinking Depreciation and AmortizationВидеоAmortization and LinkagesЗаданиеDepreciation and AmortizationЗадание
04Cash Flow and Working Capital9 материалов

Building the Cash Flow Statement

Building the Cash Flow StatementВидеоUnderstanding Working CapitalВидеоLinking the Historical Working Capital BalancesВидеоBuilding the Cash Flow StatementЗадание

Working Capital Dynamics

What is Cash Conversion CycleВидеоProjecting Working Capital BalancesВидеоIncrease and Decrease in Working CapitalВидеоWorking Capital DynamicsЗаданиеCash Flow and Working CapitalЗадание
05Equity and Financing Activities10 материалов

Share Repurchase and Capital Structure

Share Repurchase ForecastВидеоShare Repurchase Forecast ContinuedВидеоShares OutstandingВидеоShare Repurchase and Capital StructureЗадание

Liabilities and Debt Forecasting

Other Assets and LiabilitiesВидеоForecasting DebtВидеоInterest Expense and Interest IncomeВидеоCompleting the Missing LinksВидеоLiabilities and Debt ForecastingЗаданиеEquity and Financing ActivitiesЗадание
06Valuation Introduction – DCF Approach10 материалов

DCF and Free Cash Flow

Checking the DashboardВидеоDCF Analysis OverviewВидеоFree Cash Flow to the FirmВидеоFree Cash Flow to the Firm ContinuedВидеоDCF and Free Cash FlowЗадание

FCFF and FCFE

Free Cash Flow to the Firm- Backward CalculationВидеоFree Cash Flow to EquityВидеоNet Operating Profit After TaxВидеоFCFF and FCFEЗаданиеValuation Introduction – DCF ApproachЗадание
07Advanced Valuation Metrics10 материалов

Equity Value and DCF Completion

Complete Equity BusinessВидеоBuilding the DCF ModelВидеоRisk-free Rate and BetaВидеоEquity Value and DCF CompletionЗадание

WACC and Enterprise Value

Cost of Capital CalculationВидеоWACC CalculationВидеоBeta CalculationВидеоUnderstanding the WACC ConceptВидеоWACC and Enterprise ValueЗаданиеAdvanced Valuation MetricsЗадание
08Valuation Outputs and Comparables11 материалов

Enterprise Value and Share Price

NPV of Explicit PeriodВидеоEnterprise ValueВидеоShare Price- Forecast 1 and 2ВидеоShare Price- Forecast 1 and 2 ContinuedВидеоEnterprise Value and Share PriceЗадание

Market Multiples and Relative Valuation

Relative ValuationВидеоEV to RevenueВидеоEV to EBITDAВидеоMarket Multiples and Relative ValuationЗаданиеValuation Outputs and ComparablesЗаданиеBuilding and Valuing Big Books Corp: From Revenue Forecast to Share PriceDIALOGUE