Determining the Number of Loan Installments

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

Excel Determining the Number of Loan Installments

Principal, interest, and installment amounts are entered into the table. The repayment period is calculated using formulas. Alternative scenarios are compared. The payment plan is visualized with graphs. Results are made available for output.

Hope it is useful.