Mortgage Calculator - Excel

Document Sample
Mortgage Calculator - Excel Powered By Docstoc
					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
				
DOCUMENT INFO
Description: 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.
BUY THIS DOCUMENT NOW PRICE: $12.99 100% MONEY BACK GUARANTEED
PARTNER SpreadsheetZone
SpreadsheetZONE features one of the biggest Microsoft Excel template repositories on the web. Supported by an active community and Excel Pros SpreadsheetZONE grows rapidly, delivering new templates everyday. Find the template you need now!