Loan Amortization Tracking Schedule

An Excel file that teaches how to perform Calculating Date and Day Difference operation.

Excel Source: Loan Amortization Tracking Schedule

Installment amounts and interest rates are entered into the table. A period-based payment plan is created. The remaining debt is calculated using formulas. The payment process is visualized with graphs. Results are made printable.

Hope it is useful.