Learn to calculate loan payments and design effective repayment schedules using Excel formulas for mortgages and other loan types.