Online Self-Paced Real Estate Financial Analysis Using Excel 2017
Location:
Online
Date:
January 1, 2017 To December 31, 2017
Add to Calendar Download

Online Self-Paced Real Estate Financial Analysis Using Excel

Building an accurate proforma is a crucial first step in every real estate investment or development venture. Mastering Microsoft Excel’s financial analysis capabilities can make proforma models more accurate and bring enhanced meaning to sensitivity analyses. In this self-paced class, students learn step-by-step instructions for creating an accurate proforma for analyzing the financial performance of commercial and investment real estate. Students will proceed one-by-one through interactive videos. Excel workbooks for each session will allow students to review and practice as they desire.

This self-paced course contains 18 video sessions - ranging from about 30 minutes to over an hour in length. You will have access for 90 days.

The class is designed specifically for real estate professionals interested in expanding their knowledge of financial concepts and Excel tools. Students learn Excel’s advanced tools financial analysis functions and then apply them to their own investment and development models.

The class is designed specifically for real estate professionals interested in expanding their knowledge of financial concepts and Excel tools. Students learn Excel’s advanced tools financial analysis functions and then apply them to their own investment and development models.

During the course, students develop their own spreadsheets that allow them to quickly and effectively model a variety of real estate investment scenarios. The course concludes with students building a complex financial investment model using Excel. Financial concepts such as compounding and discounting, internal rate of return (IRR), and net present value (NPV) are explained in detail. Excel applications covered include:

  • Logic functions
  • Absolute and relative references
  • Midpoint discounting and XIRR
  • Reinvestment and MIRR
  • Goal seek
  • Hyperlink, Data Validation, Group and Ungroup
  • And many more

Students are expected to have a basic knowledge of Excel and a firm grasp of basic real estate finance concepts such as time value of money, IRR, and NPV.

  • List Price: $535.00 USD
  • Member Price: $435.00 USD
 
Want to save more?
to see if you qualify for a lower rate.
Members save $100.00 USD or more