Skip to main content
Course Image
Using Excel as Your Financial Calculator image for The CCIM Institute course

Using Excel as Your Financial Calculator


The Course Will Teach You to

Course Objectives
  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

Course Description

Course Description

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.

Tech Requirements
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 The 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: The CCIM Institute courses are optimized for use with the Google Chrome web browser.

Course Tuition
Member Price
For Members
Realtor Price
For Realtors®
Non-member Price
For Non-members
See Upcoming Courses
Filter By
Start Date
End Date
Showing 3 Results
Course Details and Register Start Date Format
Online January 1, 2024 Online - Self Paced Register
Online August 12, 2024 Online - Instructor Led Register
Online December 4, 2024 Online - Instructor Led Register
Getting Started in Commercial Real Estate?

"It's a wonderful time to be new in commercial real estate ... and certainly organizations like The CCIM Institute can help train someone in the industry" - Jay Olshonsky, President of NAI Global