# Quick Answer: How Do You Calculate PMI On A Mortgage?

The PMI formula is actually simpler than a fixed-rate mortgage formula.

• Find out the loan-to-value, or LTV, ratio of your house.
• 450,000 / 500,000 = 0.9.
• 0.9 X 100 = 90 percent LTV.
• Look at the lender’s PMI table.
• Multiply your mortgage loan by your specific PMI rate according to the lender’s chart.

## How can I avoid PMI without 20% down?

The traditional way to avoid paying PMI on a mortgage is to take out a piggyback loan. In that event, if you can only put up 5 percent down for your mortgage, you take out a second “piggyback” mortgage for 15 percent of the loan balance, and combine them for your 20 percent down payment.

## How do you calculate when PMI will drop off?

One way to get rid of PMI is to simply take the purchase price of the home and multiply it by 80%. Then pay your mortgage down to that amount. So if you paid \$250,000 for the home, 80% of that value is \$200,000. Once you pay the loan down to \$200,000, you can have the PMI removed.

## How do I calculate PMI in Excel?

Enter the monthly PMI fee in cell A4. This fee varies between lenders, so you need to contact the mortgage company to find out the amount they charge. If you only wish to estimate PMI, you can enter “=A3/1500” or “=A3/3700” which calculates PMI based on common formulas. Enter the annual escrow amount in cell A5.

## Can you negotiate PMI?

Private mortgage insurance provides your lender 10 percent of the cost of the loan should you default on the mortgage. You cannot negotiate the rate of your PMI, but there are other ways to lower or eliminate PMI from your monthly payment.

## Is paying PMI worth it?

You might pay a couple hundred dollars per month for PMI. But you could start earning upwards of \$20,000 per year in equity. So for many people, PMI is worth it. Mortgage insurance can be your ticket out of renting and into equity wealth.