Using Excel As Your Financial Calculator Self-Paced 2020
Start Date & Time:
January 1, 2020 : 12:00 AM CT
End Date & Time:
March 31, 2021 : 11:59 PM CT
Using Excel as Your Financial Calculator
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.
- 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