A mortgage amortization schedule is calculated using the loan ... For a 30-year, $150,000 mortgage with a 3.5% interest rate, the equation to enter in an Excel cell would be =PMT(3.5%/12,360,150000).