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.