How to Calculate a Loan's Monthly Payment in Excel With Tax & PMI. Your monthly loan payment consists of more than just equity and interest payments. If you didn't put down at least 20 percent ...

You can also use a biweekly loan amortization template to figure out how your payments and schedule differs by making half-payments every two weeks instead of 12 whole payments in a year.