MORTGAGE CALCULATOR
Home Value Loan Amount Interest Rate Loan Term Property Tax Rate Start Date 300,000.00 250,000.00 6.50 30 1.25 Feb 2009
% years %
Mortgage Repayment Summary
Down Payment PMI Rate Monthly PMI 16.67% 0.00% 0.00
Monthly Payment 1,840.59 Total Payment 662,611.22 Payoff Date Jan 2039
X
Payments 360
=
Total Payment 662,611.22
=
Total Principal Paid 250,000.00
+
Total Interest Paid 300,111.22
+
Total PMI Paid 0.00
OR
PMI, 0.00% Tax, 16.98%
Principal, 37.73%
Interest, 45.29%
Total PMI Paid 0.00
+
Total Tax Paid 112,500.00
Follow the steps to enable your online Mortgage Calculator.
1) PMI Rates are calculated as below. Update the values if necessary.
LTV 0.00% 85.00% 85.01% 85.00% 85.01% 90.00% 90.01% 95.00% 95.01% 100.00%
>> 2)
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%
3)
4) >> >>
Your Mortgage Calculator is ready to use. Further steps are for online use. Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your online calculator. Visit the site below: https://www4.spreadsheetweb.com/SpreadsheetWEB// Login to page with your new account information. Click "Add Web Application" to upload this file. Your online calculator will be created automatically. You can simply use the calculator from that link or place it on your website. Your online calculator will look like: https://www4.spreadsheetweb.com/SpreadSheetWEB/Output.aspx?ApplicationId=406300a8-22b4-40a5-a93d-510f15a47 In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm
22b4-40a5-a93d-510f15a478c8
List1 Jan Dec Feb Jan Mar Feb Apr Mar May Apr Jun May Jul Jun Aug Jul Sep Aug Oct Sep Nov Oct Dec Nov
0 1 1 1 1 1 1 1 1 1 1 1
List2 Chart1 2000 Principal 2001 Interest 2002 Tax 2003 PMI 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015
37.73% 45.29% 16.98% 0.00%