Search
close menu
Seminar

Cash Flow Modelling Webcast

In the online seminar "Cash Flow Modelling," attendees will acquire comprehensive knowledge of key financial mathematical concepts and investment evaluation techniques. They will learn to apply these methods in Microsoft Excel and effectively implement them in their everyday professional tasks.
Duration of seminar

about 7 hours

Seminar format

Digital

Language(s)

German, English

Seminar Fees

from €455

Overview

Cash Flow Modelling Webcast:
Deepening Knowledge in Financial Mathematics
and Investment Analysis

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.

Contact Details

Katharina Klocke
Programme management Frankfurt | Seminars

Katharina Klocke mainly advises and supports the participants of the contact study programme Real Estate Economics in Frankfurt as well as the intensive study programme Sustainable Real Estate Management and is happy to advise you on our seminar offers.

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
Key Benefits

Discover the benefits of choosing our institution for your education

University-level Education

The IREBS Executive Education is part of the Faculty of Business, Economics, and Management at the University of Regensburg.

Renowned

You will engage in expert discussions with high-profile and renowned lecturers from academia and industry.

Pioneers

IREBS Executive Education has been in the market for over three decades and has successfully trained over 7,500 professionals.

Prospects

Achieving certification from IREBS is held in high regard by executives and HR managers in the real estate industry.

Seminar Plus

We provide our students with the necessary materials in digital form.

Optimal Learning Environment

With small group sizes, we ensure an optimal learning environment, leading to higher learning success. Therefore, the available seats are limited.

Seminar Structure

Financial Mathematics and
Excel-based Cash Flow Modelling

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.

Content Overview

Mastering Cash Flow Modelling: A Comprehensive Webcast

Block 1 Block 2

Block 1

Block 1

Basics of Financial Mathematics

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:

  • Introduction to Financial Mathematics
  • Interest Calculation:
    • Basics of interest calculation
    • Exponential compounding and discounting
    • Compounding within interest-on-interest calculations
    • Excursion - Logarithms
  • Annuity Calculation:
    • Annuities and future value of annuities
    • Present value of annuities
    • Perpetuity
    • Advance payment in annuity calculation
  • Credit & Repayment:
    • Basics of repayment
    • Annuity repayment
  • Investment Appraisal:
    • Net present value method
    • Internal rate of return
    • Return on investment (ROI)

Block 2

Block 2

Cash Flow Modelling

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

  • Overview: Cash Flow Modelling is aimed to support investment decisions. The individual learning modules are oriented towards this goal and are motivated by this objective in the overview.
  • Basic Model: The starting point of the Cashflow Model is the cash flows of real estate. The jointly created basic model captures cash flows from transactions, such as buying and selling, and from operational management, such as rents and operations.
  • Dynamics: Since the cash flows from a property change over time, this dynamic needs to be included in a Cash Flow Model. We focus on depicting the development of rental payments both generally and individually; furthermore, we establish a connection to estimating the selling price.
  • Key Figures: Various key figures have been developed to make investments more comparable, based on cash flows. Several variants of the net present value and yield will be introduced, implemented, and analyzed.
  • Financing: The investment is opposed by its financing, and for real estate, a significant component is bank loans. We will implement cash flows for the central loan options, examine the leverage effect, and include common credit indicators.
  • Taxes: We will complement the model components of property and loan with the aspect of income taxes. As their impact is highly individual, the focus here is on supplementing the typical depreciation structure and income statement.
  • Risk: A significant advantage of an Excel-based Cash Flow Model is the ability to easily calculate alternative scenarios. Therefore, we will develop several options to incorporate meaningful risk analyses, including simulation, using built-in tools.
  • Outlook: Now it's your turn: Design, implement, and interpret an individual Cash Flow Model for your specific situation.
Lecturers

Expertise from academia and industry

Tobias Just
Prof. Dr. Tobias Just (FRICS)
Managing Director | Academic Director | Chair of Real Estate at the University of Regensburg

The IREBS Executive Education is headed academically and as managing director by real estate expert Professor Tobias Just (FRICS), who most recently held a leading position in industry and real estate market research at Deutsche Bank. Tobias Just holds the Chair of Real Estate Management at the IREBS Institute for Real Estate Management at the University of Regensburg.

Leo Cremer
Prof. Dr. Leo Cremer
Professor for Mathematical Methods in Construction and Real Estate Management at University RheinMain

In his former life Leo Cremer was a banker, but since the beginning of October he has been a professor at the RhineMain University of Applied Sciences in Wiesbaden. There he has taken over the newly created professorship for Mathematical Methods in Construction and Real Estate Management as part of the Bachelor's degree programme in Real Estate Management. Previously he had already been a guest lecturer for the university.

Registration

Everything you need to know

Structure & Study Formats
  • Duration: Approximately 7 hours
  • The webcast will be available to you for eight weeks
  • Includes: Digital seminar materials

For the seminar, you will need a computer and Microsoft Office 2016 or later.

Tuition Fees
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.

Target Group & Admission Requirements

Participants with basic knowledge of MS Excel usage, as well as anyone interested in expanding their knowledge in Cash Flow Modelling. Target audience includes:

  • Real estate professionals
  • Financial analysts
  • Investors
  • Property developers
  • Real estate agents
  • Property managers
  • Financial advisors
Certificate of Completion

Upon completing our seminar successfully, you will be awarded an official certificate of participation, acknowledging your successful attendance and 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.

Student advisory services
close call +49 6723 9950-30E-mail to irebs@irebs.de