Module: Advanced Microsoft Excel Application For Loan & Investment Calculations
Lesson1. The Time Value of Money
Lesson2. Loan Calculations
Specialized functions to calculate loan information.
Familiarize with various loan calculation
Calculate interest rate.
Credit Card Payments
Creating a Loan Amortization Schedule Table
Summarizing Loan Options by Using a Data Table
Creating a One-Way Loan Data Table
Creating a Two-Way Loan Data Table
Calculating a Loan with Irregular Payments
Lesson3. Investment Calculations
Future Value of a Single Deposit
Calculating Simple Interest
Calculating Compound Interest
Calculating Interest with Continuous Compounding
Rule 72
The Annuity Calculator
Lesson4. Depreciation Calculations
Excel Depreciation Functions
Depreciation Methods
Arguments for the depreciation functions