Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Cash Flow Model Training - Full Seminar
Module I - APPLYING EXCEL-BASED INVESTMENT & FINANCE CALCULATION
Session 1 - Recognize Value Creation Potential: Interaction of Property, Debt and Capital Markets (80:40)
Session 2 - Model Investment Calculation (DCF): Calculation of (X)IRR, MIRR, FMRR as well as (X)NPV (84:25)
Session 3 - Create Senior Financing: Basics: Determine Framework and Covenants – CoC, ROE, ROI, ROA, MOIC and LTV, LTC, ICR, DSCR, YoC, YoD (108:11)
Session 4 - Implement Subordinate Financing: Basics: Equity Structures, Equity-Kicker-Loans, Convertible Debt, Debt Mezz., Equity Mezz., Private Equity (158:18)
Module II - MODELING WITH EXCEL
Session 5 - Using Excel Efficiently: Tips and Tricks For Your Daily Modeling (151:57)
Session 6 - Create an Investment Calculation By Yourself: Structure, Model and Extend (92:13)
Session 7 - Learning By Doing: Examples Using Case Studies (55:22)
Session 8 - Integrate Financing Structures: Practical Implementation: Senior Financing, Interest and Amortisation Schedules, Leverage Effect (52:27)
Module III - MODELING RISKS AND CASH FLOW MODEL AUTOMATION
Session 9 - Understand Risk Management: Critical Values, Sensitivity and Scenario Analyses, Monte Carlo Simulation (72:17)
Session 10 - Integrate Risk Analyses: Solver, Tornado Diagrams, Dynamic Scenario Analyses (46:05)
Session 11 - Make Models and Reporting Dynamic: Efficient Modeling Using Dynamic References, Diagrams and Pivot Tables (45:40)
Session 12 - Model Automation: Introduction to Macros Using VBA; Providing Useful Tools (48:32)
Session 5 - Using Excel Efficiently: Tips and Tricks For Your Daily Modeling
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock