Real Estate Development in Excel (Includes Template)

Name: Real Estate Development in Excel (Includes Template)
Rating: 4.2 (91 reviews)

Learn Industry Standard Analysis and Valuation Techniques For Real Estate Development

Created byDaniel Davis

Last updated 2/2018

English

What you'll learn

This course comes with a fully built, plug and play model which you can download and use to analyze any real estate project
You will learn how to value a multi-family real estate project using industry standard techniques
You will be able to impress current and future employers with your understanding of real estate finance

Course content

1 section • 11 lectures • 1h 1m total length

Introduction to Real Estate Development In Excel1:52
High Level Overview of the Model11:17
High Level Overview Part 27:26
Focus on The Financing Assumptions and Valuation Metrics4:37
Financial Assumptions Explained Part Two8:00
Explain how equity investors' preferred returns and KPI metrics drive annual cash flows, cap rate valuation, debt service coverage, and IRR calculations in the Excel model.
Project Assumptions Sheet7:06
Projected Cash Flows Page6:55
Stabilization Period Income2:20
Investor Distributions3:33
Calculate investor arrears from the construction phase and apply the preferred return, then allocate investor distributions from operations to investors according to the payout ratio and their claim.
Amortization Tables and Report Templates3:25
Explore construction and permanent loan amortization templates with assumptions from the financial tab, and learn to override projected cash flows while separating interest and principal in the reports.
How to Add Years to the Model5:03

Requirements

A familiarity with Microsoft Excel will help you in this course, though it is not necessary.
Any background in real estate will be helpful, though again, it is not necessary.

Description

This course will teach you how to financially model a multi-family real estate development project and comes with a downloadable, complete Excel model. The model that comes with this course is plug and play with minimal work necessary to adapt it to any kind of multi-family development project.

This course will teach you how to use the model, the industry standard terms, metrics and valuation techniques which developers use on a daily basis.

Here are some strengths of the model:

The model dynamically calculates various metrics, including IRR, Debt Service Coverage, Yield to Cost, Loan to Cost and Project Valuation so you can see how every variable you change affects the project.
This model is used in industry for actual real estate projects
Designed to model equity investors for syndicated projects. The model will show equity IRRs and investor returns.
Designed to model a construction loan, a take-out permanent loan, a balloon payment and all of the debt service payments along the way.
The model comes with integrated amortization tables for quick analysis of loans.

The model is specifically designed to be easy to adapt to any kind of multi-family project. The video content of the course will show you everything you need to know to re-tool the model to handle any variety of unit mix, stabilization period, rent, loan, and exit date.

This course will demonstrate how to financially model the development of a 36 unit apartment complex, from equity contribution up through the sale of the project.

Welcome to Real Estate Development in Excel.

Who this course is for:

Anyone looking to learn the finances behind real estate development.
Anyone looking for a functional financial model they can use to impress future employers, or use for a RE development project
Anyone trying to learn the financial terms and techniques of real estate development
Anyone looking to grow their Excel skills