Introduction to Excel for Real Estate Professionals

Welcome to the Course!

Before you begin...

Course Introduction

What is Excel?

Why Master Excel?

Resources for Before You Start

Project Evaluation Criteria

Excel Layout

Basic Functions

Common Math Functions

Time Value of Money

Finance Functions

Investment Evaluation- NPV & IRR

Date Functions

Conditional Formulas

File Shortcuts

Moving Around

Selecting Data

Editing Shortcuts

Real Estate Models Layout

Layout to Model Inputs and Outputs

Building Our Model

Formatting the Model

Number Formatting

Cell Names, Troubleshooting Formulas, and High Level Reports

Advanced Applications of Conditional Formatting

What is an Amortization Schedule?

Building Amortization Schedule

IPMT / PPMT

What is Debt Service?

Debt Service

XNPV / XIRR

Sensitivity Analysis

Scenario Analysis

Up Next: Test Your Knowledge

Introduction to Excel for Real Estate Professionals Quiz

Next Steps

Before you go...