Register Online - Add to Cart


Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 405501
Credit & Course Provided by:

Creating Real Estate Financial Models in Excel

Live Webinar
May 22, 2019
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart

Learn how to break down the real estate pro forma in Excel®

In this topic, the information, will bring prior commercial real estate experience to the forefront and walk you through creating a simplified real estate proforma. The information will cover worksheet functions, such as SUMIF for looking up numbers from Excel® profit & loss reports and other sources; contrasting IRR and XIRR; and using CUMIPMT and CUMPRINC to eliminate building and referencing amortization tables when calculating debt service. Other techniques will include using the conditional formatting feature to color code lease expirations and heat map rental rates. You’ll learn how to build a waterfall chart to illustrate NOI (net operating income) for a given year, and how to use keyboard shortcuts, including the F4 key for toggling absolute references and Ctrl-R for copying formulas to the right. The information will cover such nuances as opening CSV files in Excel® as well as managing the protected view prompt, which can slow you down when you open reports exported from cloud-based software.

Learning Objectives

• You will be able to iIllustrate financial statements with a Waterfall chart in Excel® 2016 and later.

• You will be able to cite which character signifies an absolute reference within a formula.

• You will be able to recognize the keyboard shortcut that enables you to transfer the contents of a cell across a row of adjacent cells that you’ve selected.

• You will be able to identify the worksheet function that enables you to calculate a return for a series of cash flows distributed at irregular dates.


Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart