University-level Education
The IREBS Executive Education is part of the Faculty of Business, Economics, and Management at the University of Regensburg.
about 7 hours
Digital
German, English
from €455
Attendees of the Cash Flow Modelling (Webcast) seminar will be provided with an overview of the basics of financial mathematics and investment analysis. Building on these fundamentals, they will receive a comprehensive introduction to the methodology of Cash Flow Modelling. The Webcast session covering financial mathematics will have a net lecture duration of approximately two hours.
Need help with the seminar? Don't hesitate to reach out to our study management. We're glad to assist you with any inquiries!
Telephone | +49 (0) 6723 9950-30 |
The webcast consists of two lectures. In Block 1, participants will receive a refresher on financial mathematical methods (only in German language), which will serve as a foundation for the Cash Flow Modelling in Block 2. The Financial Mathematics lecture lasts for about two hours and is divided into 5 blocks or 14 units, covering fundamental concepts. The Cash Flow Modelling lecture has a net lecture time of approximately five hours. Participants will have access to the webcast for eight weeks. Upon completion of the webcast, they will receive a certificate of participation.
This seminar will provide a step-by-step presentation of the components of a cash flow model, demonstrating their practical implementation in Microsoft Excel through concrete examples. You will gain a deeper understanding of relevant investment theory concepts and apply them to construct a calculation framework. Furthermore, we will explore how to incorporate real-life scenarios into the model. By the end of the seminar, you will possess an extensive toolkit to effectively address questions that arise in your professional endeavors. This includes evaluating the appropriate level of modeling complexity and interpreting analysis outcomes.
Time: Approx. 2 hours - Prof. Dr. Tobias Just (FRICS) – in German language
Financial mathematics plays a crucial role in the real estate industry, especially considering the long-term timeframes and planning involved in real estate projects, which highlight the time value of money. The main focus lies in interest and annuity calculations, supplemented by credit & repayment, as well as investment appraisal (including complete financial plans).
Learning objectives:
Time: Approx. 5 hours - Prof. Dr. Leo Cremer
Participants will learn how the capital value model works and will be able to assess how the included parameters influence each other after this block. Together, we will develop a DCF (Discounted Cash Flow) model in Microsoft Excel, followed by a model to calculate the yield using the Internal Rate of Return (IRR).
In the webcast, we will first build a simple basic model, which will then be gradually expanded and brought closer to the "real" world. Participants will learn how a DCF model can be converted into an interest rate or yield (IRR) and the significance of a calculated yield using this method. Additionally, participants will learn under which conditions they can apply the learned methods effectively and when not.
Learning Steps: Concepts of Investment Analysis
For the seminar, you will need a computer and Microsoft Office 2016 or later.
Seminar fees: | €495 |
Reduced seminar fees: | €455 |
* For alumni, members of IMMOEBS e. V., or IREBS Core e. V.
All prices are subject to the legally applicable VAT. Discounts cannot be combined.
Participants with basic knowledge of MS Excel usage, as well as anyone interested in expanding their knowledge in Cash Flow Modelling. Target audience includes:
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.