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

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

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

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

Financial Valuation and Deal Modeling with Excel

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

О курсе

Financial Valuation and Deal Modeling with Excel is a deep-dive course for financial professionals who want to develop expert-level skills in creating comprehensive valuation models. This intensive course teaches you to construct sophisticated financial models used in investment banking, corporate finance, and strategic decision-making. You'll learn to build Discounted Cash Flow (DCF) models from the ground up, perform rigorous comparable company and precedent transaction analyses, and develop complex valuation techniques used by top-tier financial professionals. The course covers advanced Excel techniques for creating intricate financial models that can assess company value, support mergers and acquisitions, and provide critical insights for high-stakes financial decisions. Practical sessions focus on real-world scenarios, including project finance waterfalls, Net Present Value (NPV) calculations, and advanced valuation methodologies. You'll practice building models that are not just technically sound, but also capable of telling a comprehensive financial story. Who this is for: Investment analysts, corporate finance professionals, financial consultants, and business strategists looking to elevate their financial modeling and valuation skills. Strong financial analysis background and advanced Excel skills recommended.

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

Financial ModelingBusiness ValuationExcel FormulasCash FlowsProject FinanceFinancial AnalysisCapital BudgetingData TransformationModel EvaluationMicrosoft ExcelMergers & AcquisitionsBenchmarkingWaterfall MethodologyCompetitive AnalysisTechnical AnalysisFinancial ForecastingCash Flow ForecastingInvestment BankingBusiness AnalysisRisk Analysis

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

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

01Financial Valuation with Excel Models15 материалов
AI Coach: The Valuation ChallengeDIALOGUEBlueprint of Valuation: DCF, Comps, and PrecedentsЧтениеChoosing the Right Tool for the JobВидеоAI Coach: What's the Best Method?DIALOGUE

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

Professionals from the Industry

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

Financial Valuation and Deal Modeling with Excel
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 24.5 ч

10 модулей

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

Субтитры: Дари, Пушту

Часть программы вашего университета
Knowledge Check: Valuation MethodologiesЗадание
AI Coach: The Fight Over Intrinsic ValueDIALOGUE
The Anatomy of a DCF ModelЧтение
How-To: Populate the DCF Model in ExcelВидео
Hands-On Learning: Calculate Enterprise Value with a DCF ModelЗадание
Knowledge Check: DCF Model ApplicationЗадание
AI Coach: The Analyst's DilemmaDIALOGUE
Decoding the Discount Rate (WACC)Чтение
How-To: Run a Sensitivity Analysis in ExcelВидео
Hands-On Learning: Quantify the Impact of the Discount RateЗадание
Valuation MemoЗадание
02Financial Modeling with Excel NPV13 материалов
Making Your First Million-Dollar DecisionDIALOGUEThe Real Cost of Ignoring Cash Flow TimingВидеоThe Language of Value: Deconstructing the NPV FormulaЧтениеBuilding Your First Valuation Model with NPVВидеоHands-On Learning: Recall and Apply NPV FundamentalsЗаданиеNPV Fundamentals QuizЗаданиеUnderstanding the Importance of Cash Flow TimingDIALOGUEUnderstanding XNPV: Key ConceptsВидеоWhen Regular Payments Aren't Reality: Introducing XNPVЧтениеModeling Irregular Cash Flows with XNPVВидеоHands-On Learning: Proficiency in Present Value CalculationsЗаданиеAdvanced Valuation with XNPV and Comparative Analysis QuizЗаданиеThe "Efficiency vs. Expansion" Capital Budgeting DecisionЗадание
03Model Project Cashflows with Confidence14 материалов
The First Question in Project FinanceDIALOGUEChannel Tunnel: When Forecasts FailВидеоThe Three Acts of a Project's Financial LifeЧтениеAnatomy of a Cash Flow WaterfallВидеоBlueprint for a Bulletproof Model: Structuring Your Excel FileЧтениеHands-On Learning: Setting Up Your Project Model in ExcelЗаданиеKnowledge Check: Project Finance FoundationsЗаданиеDefending Your Model's AssumptionsDIALOGUEInterpreting the Results: What the Numbers Tell YouЧтениеModeling the Numbers: From Revenue to CFADSВидеоFormulas for Forecasting: Key Excel FunctionsЧтениеCompleting the Waterfall: Modeling Debt and EquityВидеоHands-On Learning: Analyzing Solvency: The Final CheckЗаданиеModel a Mini Solar ProjectЗадание
04Analyze Cases, Evaluate Models, Finance16 материалов
The Enron AutopsyDIALOGUEAnatomy of a Flawed Model: Lessons from EnronЧтениеTrace Errors: From Flawed Assumption to Failed ValuationВидеоHands-On Learning: Practice Analysis: Quantifying the WeWork FlawЗаданиеKnowledge Check: Principles of Model DeconstructionЗаданиеWhy Checklists Matter: The Cost of "Good Enough"ВидеоAnatomy of a Professional QA ChecklistDIALOGUEFrom Gut Feeling to Evidence: The Three Pillars of Model AuditingВидеоThe QA Checklist in Practice: The LTCM LessonЧтениеHands-On Learning: Practice Audit: Applying the QA ChecklistЗаданиеKnowledge Check: First-Pass AuditЗаданиеFrom Analyst to Advisor: The Power of a Good CritiqueВидеоHow to Write and Visualize a Defensible CritiqueЧтениеFinal Project Walkthrough: From Audit to SubmissionВидеоRehearsing Your CritiqueDIALOGUEThe Financial Model AuditЗадание
05Comps: Valuate Companies Smartly8 материалов
Why Valuation is More Art Than Science?DIALOGUEThe Power and Pitfalls of Comps: Lessons from the Salesforce-Slack AcquisitionВидеоFrom Anatomy to Calculation: A Practical Guide to Comps AnalysisЧтениеSelecting Your Peers: The Art of Finding Truly Comparable CompaniesВидеоBuilding a Comps Sheet in ExcelВидеоHands-On Learning: Build Your Own Comps AnalysisЗаданиеKnowledge Check: Core Concepts of CompsЗаданиеValuation Analysis and RecommendationЗадание
06Evaluate and Transform M&A Data for Valuations8 материалов
The Hidden Biases in M&A DataDIALOGUEWhy Normalization Matters?ВидеоThe Analyst's Guide to M&A Data TransformationЧтениеDecoding the Data: Identifying Transaction-Specific FactorsВидеоNormalizing M&A Data and Calculating Premiums in ExcelВидеоHands-On Learning: M&A Data Transformation in ActionЗаданиеKnowledge Check: Core Principles of M&A ValuationЗаданиеM&A Valuation and Data Analysis ReportЗадание
07DCF: Build, Apply, and Evaluate18 материалов
Why Analyze Before You Build?DIALOGUEValuing High-Growth TechВидеоThe Three Pillars: FCF, WACC, and Terminal ValueЧтениеConceptual Walkthrough: Deriving the Key ComponentsВидеоHands-On Learning: Deconstruct a Valuation ScenarioЗаданиеKnowledge Check: DCF ComponentsЗаданиеFrom Spreadsheet to BoardroomВидеоThe Mechanics of DiscountingЧтениеCalculating Enterprise Value in ExcelВидеоSensitivity Analysis and Key DriversDIALOGUEHands-On Learning: Calculate Enterprise ValueЗаданиеKnowledge Check: Applying the DCF MethodologyЗаданиеThe Problem with Static ModelsВидеоAnatomy of a Modular and Auditable DCF ModelЧтениеBuilding a Dynamic and Validated Model in ExcelВидеоDefending Your Model's IntegrityDIALOGUEKnowledge Check: Model Creation and ValidationЗаданиеComprehensive DCF Valuation of a Public CompanyЗадание
08Model and Analyze Project Finance Viability16 материалов
Is This Project Bankable?DIALOGUEUnderstanding the DSCR CovenantЧтениеThe Downside Case Matters MostВидеоWhat is Scenario Analysis?ЧтениеHow to Analyze Scenarios in a ModelВидеоHands-On Learning: Project Viability Assessment DrillЗаданиеKnowledge Check: Analytical ConceptsЗаданиеA Lesson in Flawed AssumptionsЧтениеForecasting Project Cash FlowsВидеоAnatomy of a Project Finance ModelЧтениеHow to Build a Sculpted Debt ScheduleВидеоHow to Structure an Equity WaterfallЧтениеNavigating the Equity WaterfallDIALOGUEHands-On Learning: Build the Model SkeletonЗаданиеImpact of Interest Rate Change on a Project Finance ModelЗаданиеBuild and Evaluate a Renewable Energy Project Finance ModelЗадание
09Financial Forecasts: Learn from Errors14 материалов
AI Coach: The Forecast is BrokenDIALOGUEFrameworks for Failure AnalysisЧтениеHow-To: Deconstruct a Failed ModelВидеоHands-On Learning: Identify the Root CauseЗаданиеKnowledge Check: Root Cause AnalysisЗаданиеAI Coach: Replicating SuccessDIALOGUEFrom Success to System: The Art of Knowledge TransferЧтениеHow-To: Build a Checklist in ExcelВидеоHands-On Learning: Draft a Checklist ItemЗаданиеKnowledge Check: Effective Checklist DesignЗаданиеWhy Good Analysis Isn't EnoughВидеоClosing the Loop: From Insight to ActionЧтениеAI Coach: Connecting the DotsDIALOGUEConnecting an Insight to an ActionЗадание
10Valuation and Deal Model (Portfolio Artifact)3 материалов
Why This Project Matters: Building a Defensible Valuation and Deal ModelЧтениеYour Project Blueprint: Requirements and EvaluationЧтениеProject: Valuation and Deal Model (Portfolio Artifact)Задание