If you know these three things, you can use Excel’s PMT function to calculate ... math behind the calculator works. You can create an amortization schedule for an adjustable-rate mortgage ...