University-level Education
The IREBS Executive Education is part of the Faculty of Business, Economics, and Management at the University of Regensburg.
2 days
Frankfurt
In-class Teaching
German
from €1,700
Building upon the foundations laid in the Cash Flow Modelling I seminar, Cash Flow Modelling II offers participants the opportunity to delve deeper and broaden their knowledge and skills in MS Excel modelling. The seminar's primary focus lies in the conception and hands-on implementation of flexible and efficient models tailored for real-world professional applications.
Need help with the seminar? Click on the preferred start date to get a detailed overview and don't hesitate to reach out to our study management. We're excited to assist you with any inquiries!
Telephone | +49 (0) 6723 9950-30 |
The seminar is scheduled for two days, divided into four blocks, and will run from 9:30 a.m. to 5:30 p.m. each day. Prior knowledge (Cash Flow Modelling I) is necessary. Participants will be provided with a laptop for the duration of the seminar.
Through the Cash Flow Modelling Seminar, you will acquire comprehensive knowledge of key financial mathematical concepts and investment evaluation methods. You will learn to apply these methods in Excel and implement practical solutions for your professional endeavours.
In the cash flow modelling seminar, you will acquire a well founded knowledge of the key financial mathematical concepts and methods of investment calculation. You will learn how to model these methods in Excel and implement them in practical solutions for your everyday work. You are welcome to ask your own questions in advance or during the seminar in order to discuss them in the classroom.
Time: 9:30 a.m. to 11:00 a.m. and 11:30 a.m. to 1:00 p.m.
During this session, you will review and enhance your Excel proficiency while gaining a comprehensive insight into the capabilities and constraints of Excel-based approaches to Cash Flow Modelling. Key focuses include model flexibility, efficient implementation, and the performance of the developed solutions.
Excel Refresher and Advanced Techniques
Objectives:
Time: 2:00 p.m. to 3:30 p.m. and 4:00 p.m. to 5:30 p.m.
This session will provide participants with a comprehensive understanding of the methods and tools used in Cash Flow Modelling for lease agreements, using practical examples. Building on this knowledge, we will explore concepts and methods for analyzing and evaluating lease comparison conditions. Gradually, the basic lease model will be expanded to address real-world challenges systematically. Additionally, we will delve into perspectives from the landlord's point of view, considering contract-induced and/or tenant turnover-induced costs.
Conceptualization and Structure of Forecast Models
Practical Construction of a Model for Calculating an Escalation Lease Contract
Practical Construction of a Model for Calculating an Index Lease Contract
Design as Point or Percentage Variant
Determining Adjustment Dates based on Previously Forecasted Index Development
Calculation of Passed-On Costs to the Tenant
Consideration of Advance Notice Periods
Objective:
Through practical examples, participants will develop a solid understanding of the concepts and functionalities required for modelling a lease agreement in MS Excel. They will then apply these concepts directly to create corresponding models and assess their accuracy and practical applicability using the previously used examples.
Advancement of models for representing the terms of lease agreements
Systematic consideration of options:
Approach for considering subsequent leases:
Methods and tools for modeling and depicting lease agreements:
Depicting rent adjustment rules
Importance of and approach for considering options
Representing variable rent ceiling limits (e.g., 20% rule for residential properties)
Subsequent leases
Implementing "what-if" analyses for rent forecasts
Working with scenarios - constructing and implementing the necessary structures.
Objectives
Time: 9:00 a.m. to 10:30 a.m.
In this session, together we will develop a model for analysing and forecasting data series, such as the CPI (Consumer Price Index), and practically implement it in MS Excel. We will first explore the essential tools for modelling uniform and/or cyclical developments, such as market trends, and then proceed to create a flexible and user-friendly model.
Addition:
Objectives:
Expanding model functionality through systematic use of User-Defined Functions.
Time: 11:00 a.m. to 12:30 p.m.
Analysis and optimization of model efficiency:
Basic knowledge and usage of macros/VBA:
Time: 1:30 p.m. to 3:00 p.m. and 3:30 p.m. to 5:00 p.m.
During the last block, participants will collaboratively implement the seminar contents into a comprehensive, flexible, and user-friendly model. They can either choose from a question and task provided by the facilitator or formulate their own to serve as the basis for the implementation.
Potential Case Study Assignment
The objective is to develop a straightforward, flexible, and reusable calculation model from the tenant's standpoint for evaluating a potential relocation in a major German city. After conducting an initial market analysis and evaluating a longlist, three properties have been shortlisted for further consideration. The primary focus is to compare these options based on their economic feasibility. Participants are required to create a decision proposal along with a brief rationale, while thoroughly documenting the results and their derivation.
In addition to the tenant's perspective, the model should also encompass the landlord's viewpoint to identify any potential negotiation possibilities and critically assess the calculation methods utilized for the tenant's perspective. Furthermore, the analysis should encompass the impact of different financing approaches (leverage) on the landlord's side and be incorporated into the model to ensure a comprehensive evaluation.
To account for the dynamic nature of such evaluations, participants will be introduced to and, to the extent feasible, model various approaches that systematically represent and compare alternative scenarios (e.g., variations in renovation costs, financing terms, and scope of renovations).
Summary
By the end of the seminar, participants will have acquired in-depth knowledge and practical skills in implementing Cash Flow Models. They will be able to design and build their own relevant models, as well as analyze and evaluate existing ones. Additionally, they will proficiently utilize tools and models in this domain, understanding the possibilities and limitations of each approach and explaining them effectively.
Furthermore, participants will develop the ability to identify questions that cannot be adequately addressed through standardized methods. This will enable them to provide clients with optimal advice and, if needed, conceptualize or even implement necessary modifications to existing models as required.
Seminar fees: | €1,850 |
Reduced seminar fees: | €1,700* |
* For alumni, members of IMMOEBS e.V., or IREBS Core e.V. and participants of Cash Flow Modelling I
All prices are subject to the legally applicable VAT. Discounts cannot be combined.
To participate in this seminar, a solid grasp of Cash Flow Modelling is essential. Thus, we highly recommend attending the foundational seminar, Cash Flow Modelling I, beforehand.
The is open to following individuals:
Upon completion, participants will be awarded a certificate of participation, confirming attendance and attesting to the knowledge and skills you have gained. Our seminars are highly regarded in the real estate industry, earning recognition from industry experts and professionals. Our practical and high-quality training provides you with valuable career opportunities.