Using Excel as Your Financial Calculator
The Course Will Teach You to
- 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
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.
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.