Mortgage Spreadsheet Builder (Beta version)

This page helps you generate an Excel spreadsheet to compare several loan options. Unlike most online "mortgage calculators" this one gives you a real Excel spreadsheet you can play with offline.

	Example	Scenario 1	Scenario 2	Scenario 3
Scenario Name	$900,000 with In-law
Purchase Price	900000
Down Payment %	10	%	%	%
Maximum Size of 1st Mortgage	650000
Loan Program (1st)	5/1 ARM, Interest Only
Interest Rate (1st)	5.875	%	%	%
Loan Program (2nd)	15 Yr. Fixed
Interest Rate (2nd)	6.375	%	%	%
Points	.5
Monthly Rental Income	875.50
Expected Credit from Seller	23000
Marginal Tax Rate (%)	28	%	%	%