A loan payment calculator can be created in Excel by using a formula and a spreadsheet. The formula would calculate the monthly payment based on the loan amount, interest rate and the number of payments. The spreadsheet would show the annual interest rates and the total cost of the loan.