Start typing, then use the up and down arrows to select an option from the list
CCIM: Using Excel as Your Financial Calculator
Learn to use Excel for all of your financial calculations for real estate decisions. Unlock the potential of Excel to make more money.
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 class, students learn step-by-step instructions for creating an accurate proforma for analyzing the financial performance of commercial and investment real estate.
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.
The content provider is the Certified Commercial Investment Member (CCIM) Institute. The CCIM Institute is an affiliate of the National Association of REALTORS®. Learn more at www.CCIM.com
Please click here to determine if you have
You will have access to your course for 12 months from the date of purchase. After one year, the course will expire. No extensions will be given after the course expires; if you do not complete the course during the 12-month timeframe, you will need to repurchase it at full price and start again at the beginning.
Continuing Education Information
Not available for this course.