Loan EMI / Amortization Calculator
Same monthly amortization logic as in the app. Choose interest type and rate basis, then export to Excel.
Loan details
Principal, rate, term, and interest method (same as app).
Summary
- Payment per period
- 8,833.33
- Total payment
- 103,250.00
- Total interest
- 3,250.00
Amortization schedule
Month-by-month breakdown. Same columns as in the app; export to Excel for a full print.
| Month | Balance | Amortization | Interest | To pay | New balance |
|---|---|---|---|---|---|
| 1 | 100,000.00 | 8,333.33 | 500.00 | 8,833.33 | 91,666.67 |
| 2 | 91,666.67 | 8,333.33 | 458.33 | 8,791.67 | 83,333.33 |
| 3 | 83,333.33 | 8,333.33 | 416.67 | 8,750.00 | 75,000.00 |
| 4 | 75,000.00 | 8,333.33 | 375.00 | 8,708.33 | 66,666.67 |
| 5 | 66,666.67 | 8,333.33 | 333.33 | 8,666.67 | 58,333.33 |
| 6 | 58,333.33 | 8,333.33 | 291.67 | 8,625.00 | 50,000.00 |
| 7 | 50,000.00 | 8,333.33 | 250.00 | 8,583.33 | 41,666.67 |
| 8 | 41,666.67 | 8,333.33 | 208.33 | 8,541.67 | 33,333.33 |
| 9 | 33,333.33 | 8,333.33 | 166.67 | 8,500.00 | 25,000.00 |
| 10 | 25,000.00 | 8,333.33 | 125.00 | 8,458.33 | 16,666.67 |
| 11 | 16,666.67 | 8,333.33 | 83.33 | 8,416.67 | 8,333.33 |
| 12 | 8,333.33 | 8,333.33 | 41.67 | 8,375.00 | 0.00 |