Mortgage Calculator
Here is how this works: the BLUE cells are figures we can control. The GREEN cells are flexible but out of our control. The yel Down Payment $100,000 $200,000 $150,000
(principle) Purchase Price Mortgage Rate (% down) Loan Term (term in months) Mortgage Payments Total Expected Monthly Payments Annual Heating (monthly heat) Annual Insurance (monthly insurance) Annual Water (monthly water) Property Tax (monthly taxes) Total Monthly NonMortgage Expenses Rental Units: Likely Rent Potential Rental Income* Difference Total Expected Monthly Payments
$600,000 $700,000 6% 14.29% 30 360 $3,597.30 1,859.80 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
$500,000 $700,000 6% 28.57% 30 360 $2,997.75 1,260.25 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
$550,000 $700,000 6% 21.43% 30 360 $3,297.53 1,560.03 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
1,859.80
1,260.25
1,560.03
* Standard Lending practice is that you only get to count on 75% of the
Page 1
Mortgage Calculator
s are flexible but out of our control. The yellow is what it comes down to. (The $50,000 $50,000 $50,000
$650,000 $700,000 6% 7.14% 30 360 $3,897.08 2,159.58 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
$650,000 $700,000 6% 7.14% 30 360 $3,897.08 2,159.58 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
$650,000 $700,000 6% 7.14% 30 360 $3,897.08 2,159.58 3,000.00 250.00 2,500.00 208.33 1,200.00 100 3500 291.666666666667 850.00 3 1150 2587.5 -1,737.50
2,159.58
2,159.58
2,159.58
Page 2
Mortgage Calculator
Page 3