Curriculum
Module I - APPLYING EXCEL-BASED INVESTMENT & FINANCE CALCULATION
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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)