Real Estate Financial Analysis and Modeling

Real Estate Financial Analysis and Modeling

Learn how to analyze real estate investments in Excel and how to make investment recommendations based on your analysis. On this course you will have the opportunity to practice and become a true excel modelling wiz with the four cases included in the course materials.

The models you build will be completely automated and dynamic and will allow you to test your assumptions and run sensitivity analysis on your main investment assumptions.

If you are preparing for an interview for both real estate investment and asset management roles, this course will help you pass the Excel test that is the first stage on the interview process, because it is based on modeling exercises that I have done as part of recruiting processes.

To get the most out of this course you need previous knowledge of Excel and finance, including among other the use of formulas such as EDATE, SUMIF, INDEX, MATCH, and finance concepts related to revenue, costs, profitability and returns, such as the IRR, equity multiple, cash on cash returns and gross and net initial yields.

It's also good to have some knowledge on debt financing such as loan to value, ratios and financial solvency such as debt yield, debt service coverage ratio and interest coverage ratio.

Basic course on financial modeling on Excel for Real Estate Investing

Url: View Details

What you will learn

• How to build a functional, dynamic financial model on excel for the analysis of real estate investments
• How to create institutional, professionally formatted models to present pro forma calculations to investors and partners
• Gain speed and efficiency in Microsoft Excel by learning powerful tools and functions

Rating: 2.33333

Level: Intermediate Level

Duration: 1 hour

Instructor: Carmen Linares