To register, you will first need to log in or create an account. If you don’t have a CCIM Institute account, select “Create Account” on the main menu before proceeding with your registration.

Combine the personal attention of an instructor with the flexibility of online learning. Courses have virtual sessions and defined start and end dates. All materials are provided online. Review the Schedule for specific session times.

Learn how to fully harness the power of Microsoft Excel for your financial calculations in real estate analysis. Using Excel as Your Financial Calculator takes you step-by-step in utilizing the program as a powerful financial tool, replacing a financial calculator or a financial calculator app. You'll also learn the building blocks for any financial analysis and how to create customized analyses for any situation.

Using Excel as Your Financial Calculator covers the following four modules, each with optional assessment questions at the end to assess your knowledge gained.

1. TVM Factors and Calculations: PV, FV, NPER, RATE, and PMT
2. Loan Calculations: Loan Balance, Interest, Principal, APR, and Maximum Loan
3. DCF Calculations: IRR, NPV, and Investment Value
4. Practical Applications and Problems: Real-World Examples and Best Practices
   
   

Tech Requirements
This course may require the use of a laptop or desktop computer with full Excel capabilities. Mobile devices, like iPads, tablets, and cellphones, will not run CCIM Institute's macro-enabled spreadsheets.
PC: Microsoft Office 2000 or higher is necessary to run the CCIM Institute macro-enabled spreadsheets.
Mac: Mac versions of Microsoft Office 2004, 2011, 2016, or 365 are required to run the CCIM Institute macro-enabled spreadsheets.
Browser: CCIM Institute courses are optimized for use with the Google Chrome web browser.

Instructor

Jeff Engelstad, CCIM
University of Denver - Daniels College of Business | Professor of the Practice

Venue

This course takes place online.