The spreadsheet simply allows you to enter the loan amount, interest rate and number of years of the loan and then calculates the monthly payment for the loan. It also gives you a couple of examples on how you can pay the loan off in a shorter period by paying more than is required every month.