Course Image
Image
Using Excel as Your Financial Calculator
TOPIC
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
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.
See Upcoming Courses
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...
Image
Residential Real Estate Financial Analysis
Residential Real Estate Financial Analysis is designed for residential agents who want to expand their business to...