Explanation
Data Tables are also useful for financial analysis.
Suppose you want to compare monthly EMI for different:
- Interest rates
- Loan periods
Loan Data
Loan Amount: ₹5,00,000
|
Interest Rate ↓ / Years → |
3 |
5 |
7 |
10 |
|
8% |
||||
|
9% |
||||
|
10% |
||||
|
11% |
||||
|
12% |
EMI Formula
=PMT(Rate/12,Years*12,-500000)
The Data Table can show how EMI changes when both interest rate and loan period change.
Practice
Create the complete EMI comparison table.