Microsoft Excel contains a function for calculating the equity and interest payments, which you can modify to include PMI and taxes. How to Convert an Annual Interest Rate to a Monthly Rate.

Here's how to do the math on a mortgage payment. When it comes to your monthly mortgage payment, you're not just paying off the sticker price of the home. Your payment typically covers the ...