Set up columns for each payroll tax your company is required to report to the IRS. Include columns for Social Security taxes and Medicare taxes.

Microsoft Excel contains a function for calculating the equity and interest payments, which you can modify to include PMI and taxes.