$12.99
Document provided by...
pagosspreadsheetzone
www.spreadsheetzone.com
About This Document
This file is prepared for simulating a mortgage. Home value, loan amount, interest rate, loan term and property tax rate are entered as inputs. All payments that will be made with the entered inputs are calculated. Distribution of payments for tax, PMI, principal and interest are displayed on a pie chart. Changing the inputs, one may simulate the payments for each category.
Stats
Type:
Excel Spreadsheet
Size:
41 kb
Pages:
5
Views:
540
Posted:
08/02/09
Categories
DocStore > Templates > Spreadsheets
Tags
mortgage calculator, mortgage payment calculator, home mortgage calculator, mortgage calculators, loan mortgage calculator, mortgage loan calculator, calculator for mortgage payment, mortgage rate calculator

Mortgage Calculator

View, download, and print this entire document by purchasing it for only $12.99
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.32% 0.52% 0.78% 0.90% PMI Rate for <30 YR 0.00% 0.19% 0.23% 0.26% 0.79% OR PMI, 0.29% Principal, 36.41% FALSE TRUE FALSE FALSE FALSE FALSE FALSE #### #### #### #### #### #### #### #### #### Abbreviations Total PMI Paid 2,00