This excel spreadsheet calculates how much the total payment will be on a loan when interest rates and the duration of loan is known.