Mortgage Calculator - Excel

Document Sample
Mortgage Calculator - Excel
MORTGAGE CALCULATOR

Home Value Loan Amount Interest Rate Loan Term Property Tax Rate Start Date 300,000.00 250,000.00 6.50 % 30 years 1.25 %

May May



PMI, 0.29%



Tax, 16.38%



5 2009 2009



10



Mortgage Repayment Summary

Down Payment LTV PMI Rate Monthly PMI 16.67% 83.33% 0.32% 66.67

Interest, 46.91%



Monthly Payment 1,907.25 Total Payment 686,611.22 Payoff Date Apr 2039



x =



Payments 360



=



Total Payment 686,611.22



Total Principal Paid 250,000.00



+



Total Interest Paid 322,111.22



+



Total PMI Paid 2,000.00



PMI - LTV Table

LTV Range

0.00% 75.01% 85.01% 90.01% 95.01% 75.00% 85.00% 90.00% 95.00% 100.00% PMI Rate >=30 YR 0.00% 0.

By registering with docstoc.com you agree to our
privacy policy and terms of service

Successfully added document to cart!

Successfully added document to cart!