Seminar
"Cash Flow Model Training for Real Estate Investments using Microsoft Excel" is your intensive seminar, which - coming from the usual Excel knowledge as a user or decision maker - opens the world of real estate investment calculation and decision making to you. Learn how to independently create fully automated cash flow models, to automate them independently and to evaluate them. Once you have successfully created a model, you will be able to use it in negotiations and time-critical purchase or financing situations and to make decisions immediately. The investment in this seminar may be the decisive investment for your educational advantage and future professional success.
12 Sessions
The complete online seminar comprises 12 sessions, that can be watched and reviewed according to your booked package.
50 Sample Files
During the seminar about 50 sample files will be explained and / or created together.
18 Hours of Videos
The sessions have been professionally recorded and cut, can be stopped and resumed at your convenience, and are available 24/7.
Curriculum
Module I
- Session 1 - Recognize Value Creation Potential: Interaction of Property, Debt and Capital Markets
- Session 2 - Model Investment Calculation (DCF): Calculation of (X)IRR, MIRR, FMRR as well as (X)NPV
- Session 3 - Create Senior Financing: Basics: Determine Framework and Covenants – CoC, ROE, ROI, ROA, MOIC and LTV, LTC, ICR, DSCR, YoC, YoD
- Session 4 - Implement Subordinate Financing: Basics: Equity Structures, Equity-Kicker-Loans, Convertible Debt, Debt Mezz., Equity Mezz., Private Equity
Module II
- Session 5 - Using Excel Efficiently: Tips and Tricks For Your Daily Modeling
- Session 6 - Create an Investment Calculation By Yourself: Structure, Model and Extend
- Session 7 - Learning By Doing: Examples Using Case Studies
- Session 8 - Integrate Financing Structures: Practical Implementation: Senior Financing, Interest and Amortisation Schedules, Leverage Effect
Module III
- Session 9 - Understand Risk Management: Critical Values, Sensitivity and Scenario Analyses, Monte Carlo Simulation
- Session 10 - Integrate Risk Analyses: Solver, Tornado Diagrams, Dynamic Scenario Analyses
- Session 11 - Make Models and Reporting Dynamic: Efficient Modeling Using Dynamic References, Diagrams and Pivot Tables
- Session 12 - Model Automation: Introduction to Macros Using VBA; Providing Useful Tools