Real Estate Financial Modeling - Create A Basic Model Fast

Learn to ace interview modeling tests or kickstart your career in PERE

What you'll learn

Create a dynamic real estate financial model from scratch using Microsoft Excel.

Prepare for Private Equity Real Estate tests commonly encountered during interviews.

Develop essential Excel modeling skills for real estate finance.

Gain a comprehensive understanding of real estate investment logic and process.

Requirements

Basic knowledge of how Excel works is better

Description

Learn to create financial models very fast with this Real Estate Modeling Course. I am Ibrahim, a 10-year experienced investment manager who has worked in Real Estate Acquisitions, Debt Investment and Portfolio Management. This immersive course will equip aspiring analysts and seasoned professionals alike with the indispensable skills necessary to thrive in the real estate finance industry.Throughout the program, I will guide participants through the creation of a comprehensive financial model using Microsoft Excel, offering step-by-step instruction and hands-on practice. Drawing from my extensive experience in top-tier real estate investment firms, I ensure that students receive invaluable insights and real-world knowledge tailored to excel in real estate modeling.What sets this course apart is its utilization of a real-life example: a test that can be encountered in PERE interviews. By immersing yourself in this practical exercise, you'll not only sharpen your modeling prowess but also gain a competitive edge, priming you to ace interviews and secure your dream job in the field.Already working in real estate? Congratulations! This course is designed to elevate your skills to new heights, enabling you to refine your modeling techniques and accelerate your workflow. Don't miss this opportunity to level up your career in real estate investment. Enroll today and embark with me on a journey towards unparalleled success.

Overview

Section 1: Presentation of the course

Lecture 1 Presentation of the course

Section 2: Introduction and definitions

Lecture 2 Introduction (instruction and model download)

Section 3: Tenancy modelisation

Lecture 3 Tenancy Schedule Assumptions

Lecture 4 Tenants Modelisation: First Round

Lecture 5 Tenant Modelisation : New Tenants

Lecture 6 Rent Free Period

Lecture 7 Refurbishment Costs

Lecture 8 Void Costs

Lecture 9 Property Management Fees

Lecture 10 Letting Fees

Section 4: Acquisition and Exit assumptions

Lecture 11 Acquisition Price Calculation

Lecture 12 Exit Assumptions - Exit WALB

Lecture 13 Exit Assumptions - Exit Rent and Deductions

Section 5: Building the Cashflow

Lecture 14 Building the Structure of the Cashflow

Lecture 15 Calculating Returns (IRR, EM and CoC)

Lecture 16 Building the Leveraged Cashflow

Lecture 17 Calculating Leveraged Returns (IRR, EM and CoC)

Lecture 18 Sensitivities

Section 6: Tips

Lecture 19 Functions

Lecture 20 Navigation Shortcuts

Lecture 21 Keyboard Shortcuts

Section 7: Conclusion and Additional training

Lecture 22 Conclusion

Graduates looking to start a career in Private Equity real estate,Newly hired analysts looking to improve their knowledge and impress their new coworkers with lightspeed modelling capabilities,Graduates looking for ways to better understand real estate investment before starting interviewing for positions in the field