Service-Hotline +49 6723 9950-30irebs@irebs.de

Search
close menu
Online seminar

Introduction to Financial Modelling

Financial Modelling: An Online Video and Excel Course
Duration of seminar

2 days

Seminar format

Digital

Language(s)

English

Seminar Fees

from €500

Register now
Print
Overview

Enhance Your Career with Financial Modelling:
An Online Course for Aspiring Analysts

Many professionals already in the workforce often lack the necessary expertise to advance in their careers or transition into the financial services sector. So, what can graduates and professionals with limited or no relevant work experience do? The solution is straightforward: they must acquire the practical skills required for the job. In the financial industry, one skill stands out above the rest - financial modelling.

This comprehensive online video and Excel course offers aspiring analysts the opportunity to acquire fundamental skills in financial modelling. Through engaging video lectures, hands-on Excel exercises, and detailed step-by-step instructions, participants will be guided through every stage of the financial modelling process.

Contact Person

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.

Phone: +49 6723 9950-30
E-Mail: katharina.klocke@irebs.de

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
Contact Register now
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.

Flexible Scheduling

Immerse yourself in a tailored learning journey, where you can enjoy the perks of a personalized approach to education, allowing you to learn at your own pace and according to your schedule.

Seminar Structure

Flexible Learning Structure and Optional Exit Exam

The seminar is divided into four blocks. You are free to organise your learning time as you wish. If you wish, you can also take an exit exam for an additional fee.

Content Overview

What you learn in the seminar Introduction in Financial Modelling

Module 1 Module 2 Module 3 Module 4

Module 1

Module 1

Financial Statement Analysis

Analysis, adjustment and simplification of published financials to set up the model

  • Combining published P&L line items into simplified modelline items
  • Using financial statement notes to filter out non-cash andnon-recurring income and expenses
  • Introducing non-accounting terms: NOI, EBITDA, FFO
  • Creating a complete model P&L using published financials, from top line revenue through bottom line FFO
  • Adjusting the published Balance Sheet
  • Modeling exercise: Calculating analyst-adjusted FFO from published financials

Module 2

Module 2

Modeling the P&L

P&L modeling from top-line revenue through bottom line FFO, excluding more complex interest expense and D&A calculations

  • Revenue modeling: organic rental income and external rents
  • Modeling exercise & step-by-step video solution:modeling revenue
  • Modeling NOI, EBITDA, EBIT and Profit before Tax
  • Modeling cash taxes, JV income and FFO
  • Modeling exercise & step-by-step video solution: modeling the P&L with placeholders for D&A and interestexpense

Module 3

Module 3

Financial Statement Analysis

Analysis, adjustment and simplification of published financials to set up the model

  • Combining published P&L line items into simplified modelline items
  • Using financial statement notes to filter out non-cash andnon-recurring income and expenses
  • Introducing non-accounting terms: NOI, EBITDA, FFO
  • Creating a complete model P&L using published financials, from top line revenue through bottom line FFO
  • Adjusting the published Balance Sheet
  • Modeling exercise: Calculating analyst-adjusted FFO from published financials

Module 4

Module 4

Modeling the Cash-Flow-Statement

Cash-Flow Statement modeling including operating cash flow and changes in assets and liabilities. Includes modeling of cash, debt and equity balances and interest expense, previously omitted

  • Modeling operating cash flow after dividends
  • Modeling changes in assets and liabilities
  • Modeling cash, debt and interest expense
  • Finalizing FFO and FFO per share calculations
  • Modeling exercise & step-by-step video solution: modeling the cash-flow statement including cash and debt schedules
  • Refining model assumptions, using management guidance
Registration

All you need to know

Structure & Study Formats

Tuition Fees

Target Group & Admission Requirements

Certificate of Completion

Structure & Study Formats
  • Duration: Approx. 2 days
  • Flexible scheduling
  • Practical exercises complement this seminar
  • Included: digital seminar materials
  • To participate in the seminar, you will need a computer with Windows 10 and Microsoft Office 2016 or later
Tuition Fees
Seminar fees 500 €
Seminar fees including Exit Exam 650 €*


* Participants taking the online exit exam will be awarded a Certificate of Completion by IREBS upon successful completion of the exam. Course participants who pass the optional exit exam will receive a graded "Certificate of Completion" along with 3 ECTS credits from IREBS.

Target Group & Admission Requirements
  • Master and undergraduate students with some prior knowledge of accounting or corporate finance, interested in supplementing classroom learning with hands-on training in financial modeling.
  • Professionals trying to transition into the financial services industry or add to their existing skillsets in order to improve opportunities for career-advancement. The fully accredited course is an ideal complement to other IRE|BS programs such the Executive Real Estate MBA or the Certified Real Estate Investment Analyst.
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.

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