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

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

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

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

M&A Financial Modeling and Deal Analysis

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

О курсе

Learn how to analyze mergers and acquisitions, build integrated M&A financial models, and evaluate deal outcomes using practical investment banking and corporate finance techniques. This course provides hands-on skills in acquisition valuation, purchase price allocation, pro forma modeling, debt financing, and EPS accretion/dilution analysis. The course begins with the foundations of mergers and acquisitions, helping learners understand deal rationale, transaction mechanics, and valuation concepts used in real-world corporate transactions. Learners will explore how acquisition opportunities are structured, analyzed, and validated through financial modeling. As the course progresses, learners build the technical foundation for M&A analysis by creating transaction assumptions, projecting financial statements, and calculating purchase prices. The course then focuses on acquisition structuring, including sources and uses of funds, purchase price allocation, and pro forma financial statement preparation. Advanced modules cover integrated three-statement financial modeling, balance sheet forecasting, working capital management, cash flow analysis, debt financing structures, and interest calculations. Learners will also analyze EPS accretion/dilution and evaluate shareholder impact under different transaction scenarios. The course concludes with sensitivity analysis and advanced deal evaluation techniques, enabling learners to assess acquisition outcomes and make data-driven financial decisions. What makes this course unique is its end-to-end coverage of the M&A modeling lifecycle combined with practical, industry-style financial modeling workflows. By the end of the course, learners will be able to confidently analyze acquisition opportunities, build professional M&A models, and support strategic financial decision-making in investment banking and corporate finance environments.

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

Financial ModelingMergers & AcquisitionsWorking CapitalBalance SheetCash FlowsBusiness ValuationFinancial StatementsFinancial Statement AnalysisLoansFinancial ReportingFinancial DataCash Flow ForecastingCorporate FinanceFinanceInvestment BankingFinancial AnalysisFinancial Forecasting

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

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

01Foundations of M&A and Deal Mechanics14 материалов

Introduction to M&A Landscape

Overview of Noble Energy and Rosetta Resources M nad A ValuationВидеоHow M and A worksВидеоM and A Calculation MethodВидеоIntroduction to M&A LandscapeЗадание

M&A Calculation Deep Dive

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

EDUCBA

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

M&A Financial Modeling and Deal Analysis
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 11.4 ч

5 модулей

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

Часть программы вашего университета
M and A Calculation Method ContinuesВидео
How to Calculate P and LBSВидео
Actual Example of M and A DealВидео
M&A Calculation Deep DiveЗадание

Validating M&A Outcomes

More on M and A DealВидеоValidate the Pro Forma post M and A DealВидеоValidating M&A OutcomesЗаданиеAnalyzing an M&A Deal: Strategy, Valuation & Model ValidationDIALOGUEFoundations of M&A and Deal MechanicsЗаданиеAnalyze an M&A Deal: Valuation Logic and Pro Forma ValidationDIALOGUE
02From Valuation to Financial Modeling Setup12 материалов

Advanced Validation & Valuation

Validate the Pro Forma post M and A Deal ContinueВидеоValuation in M and AВидеоAdvanced Validation & ValuationЗадание

Financial Statements & Assumptions

Introduction to Financial Statements and ProjectionsВидеоAssumptionsВидеоAssumptions ContinueВидеоFinancial Statements & AssumptionsЗадание

Purchase Price Fundamentals

Purchase Price Calculation Part 1ВидеоPurchase Price Calculation Part 2ВидеоPurchase Price Calculation Part 3ВидеоPurchase Price FundamentalsЗаданиеFrom Valuation to Financial Modeling SetupЗадание
03Building the Deal Structure11 материалов

Funding the Deal

Sources and Uses of FundsВидеоPurchase Price AllocationВидеоFunding the DealЗадание

Pro Forma Setup

ProForma Opening Balance sheet FormatВидеоProForma Opening Balance Sheet AdjustmentsВидеоPro Forma SetupЗадание

Forecasting Performance

Proforma PL ForecastВидеоProforma P L forecast ContinuesВидеоProforma NI and EPSВидеоForecasting PerformanceЗаданиеBuilding the Deal StructureЗадание
04Completing Financial Statements11 материалов

Balance Sheet Construction

ProForma Balance Sheet ActualsВидеоProForma Balance Sheet ForecastВидеоBalance Sheet ConstructionЗадание

Working Capital & Integration

Working capital CalculationВидеоProForma Statement CompletionВидеоWorking Capital & IntegrationЗадание

Cash Flow Modeling

Prepare ProForma Cash Flow StatementВидеоAxll Debt Repayment ScheduleВидеоDebt Repayment Schedule ContinuesВидеоCash Flow ModelingЗаданиеCompleting Financial StatementsЗадание
05Debt, EPS & Sensitivity Analysis15 материалов

Debt Structuring

ALB Debt Repayment ScheduleВидеоMore on ALB Debt ScheduleВидеоTerm Loan and Other DebtВидеоDebt StructuringЗадание

Interest & Earnings Impact

Find out Interest CostВидеоDebt Raised for AcquisitionsВидеоAlbemarle Standalone EPSВидеоInterest & Earnings ImpactЗадание

Deal Evaluation & Sensitivity

Albemarle Profit and LossВидеоwhat is EPS AccretionВидеоUse Data TableВидеоEPS Accretion SensitivityВидеоDeal Evaluation & SensitivityЗаданиеDebt, EPS & Sensitivity AnalysisЗаданиеEvaluate and Build an M&A Deal Model with Financial Validation
DIALOGUE