Using Excel as Your Financial Calculator | The CCIM Institute (2024)

InPage Navigation

I Want To
- Register for a Course
- Become a Member
  
  group
- Work with a CCIM Designee
- Renew My Membership
- Find a CCIM
- Find My Courses
- Get Featured in Deal Makers
- Find My Chapter
- Go to CCIMConnect
Quick access to links members of The CCIM Institute frequently use.
About
- Our Mission
- What is the CCIM Designation?
- Contact Us
- History and Impact
  - The CCIM Institute Milestones
  - Past Presidents of The CCIM Institute
- Diversity, Equity and Inclusion
- Careers
- Leadership and Governance
  - The CCIM Institute Leadership
- The CCIM Institute Foundation
- FAQs
The CCIM Institute meets the emerging needs of industry professionals, delivering its education, technology, and network to advance the commercial real estate profession.
Education
- Pursue the CCIM Designation
  - Designation Curriculum
  - The Comprehensive Exam
  - Designation Calendar
  - Earning Elective Credits
  - Portfolio of Qualifying Experience
- Professional Development
  - Development Specialty Track
    
    Global Commercial Real Estate Bootcamp
  - Business Development
  - Financial Investment Tools
    
    Financial Investment Tools Basic Level
    
    Financial Investment Tools Intermediate Level
    
    Financial Investment Tools Advanced Level
  - Market Analysis/Technology
  - Negotiations
  - Professional Growth
  - Property Development
  - Taxes and Tax-Related
- Get Started in Commercial Real Estate
  - NEW! Introduction to Commercial Real Estate Certificate Program
  - Foundations Course
  - Introduction to CRE
  - Residential Real Estate Financial Analysis
- The CCIM Institute Student Tools
  - Find a Course
    
    Class Formats
    
    Online Instructor-Led Course Logistics
  - Education Policies and Program Guidance
  - Tuition
    
    Prepaid Tuition Program
  - eCampus
  - Instructor Directory
  - Apply to Teach
- Find My Courses
- Register for a Course
- Earn Continuing Education Credits
Advance your career and deepen your knowledge with the comprehensive educational resources available from The CCIM Institute.
Membership and Tools
- Become a Member
  - Guidelines for Use of Candidate Membership
- Membership Benefits
  - Membership Benefits: An In-Depth Look
  - Additional Discounts for Members
  - Code of Ethics and Standards of Practice
- Renew My Membership
- Find a Chapter
- Get Involved
- Programs
  - Cultural Diversity Education Program
  - International
  - University Outreach
  - JWL Leadership Development
  - Mentorship
Your membership in The CCIM Institute provides valuable and practical resources throughout the year to grow your business.
Events
- Meetings and Events
  - The CCIM Institute's Trade Show Schedule
- Governance Meetings
- Events App
Connect with your colleagues and expand your network at The CCIM Institute’s events.
Corporate Solutions
- Strategic Partnerships
- Conferences and Trade Shows
- Membership Advantage Provider
- Work with a CCIM Designee
Our global network of over 13,000 commercial real estate professionals opens doors to new connections, potential clients, and valuable partnerships.

See Also
Best Financial Calculator 2021: How to Choose a Financial Calculator How are Financial Calculators Helpful?5 Types of Calculators and Which To Choose
Real Estate Insights
- CCIM Connections Magazine
  - All Articles
  - All Issues
  - Customized Reprints
  - Editorial Staff
  - Write for Us
- Podcast
- Blog
  - Innovation and Inside Voices with Andie Edmonds, CCIM
  - Nick Miner, CCIM and the Biggest Deal from Spring/Summer 2023
- Get Featured in Deal Makers
- RPAC - The REALTORS Political Action Committee
As Commercial real estate expands and shifts, Real Estate Insights offers relevant and engaging content to professionals in a variety of formats.

TOPIC

Financial Analysis (All)

Financial Analysis (Basics)

Jump to All Upcoming Courses

The Course Will Teach You to

Course Objectives

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

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

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

$189

For Members

Realtor Price

$209

For Realtors®

Non-member Price

$229

For Non-members

See Upcoming Courses

Filter By

Showing 2 Results

Course Details and Register	Start Date	Format
Online	January 1, 2024	Online - Self Paced	Register
Online	December 4, 2024	Online - Instructor Led	Register

Image

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

Related Courses

Image

Splitting Profits in Commercial Real Estate

This 90-minute online course is for commercial real estate professionals who work with equity partners. Students...

View Course

Image

Residential Real Estate Financial Analysis

Residential Real Estate Financial Analysis is designed for residential agents who want to expand their business to...

View Course