Rent or Buy Decision Calculator
On-Line Spreadsheet to help people decide if they should rent or own their housing.
Input Your Assumptions in Yellow Fields
Increasing Value Benefit
1
How Many Years will you own?
10
First Year's Appreciation
2
Purchase Price
First Year's Monthly Appreciation
3
Estimated % Value Change (+ -)
-3%
-2%
-1%
0%
1%
2%
3%
4%
5%
6%
7%
4
Percentage - Down Payment in Cash
3%
5%
10%
15%
20%
Savings on Income Tax Benefit*
5
Lost interest % on your down payment
0%
1%
2%
3%
4%
5%
6%
7%
Deductible Annual Interest*
6
Approx. Closing Costs as % of Mortgage
0%
1%
2%
3%
4%
5%
6%
7%
Deductible Annual Property Taxes*
7
Plus Annual Property Taxes
Deductible Annual Mortgage Insuance*
8
Annual Property Insurance
Total Annual Deductible Amounts*
9
Interest rate
5.50%
5.75%
6.00%
6.25%
6.50%
6.75%
7.00%
7.25%
7.50%
7.75%
8.00%
Multiply by Marginal Tax Bracket*
10
Mortgage Amortization Years
15
20
30
40
First Year's Tax Savings*
11
Your Marginal Tax Bracket
10%
15%
25%
28%
33%
35%
13
Home Owner Association Fee (if any)
Paying Down Your Mortgage Loan Benefit
13
What you pay for rent now:
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
2500
2600
2700
2800
2900
3000
Unpaid Balance after 1 year
14
What was last years rental tax refund?
$
514.00
Principal Reduction after 1 year
15
Mortgage Amount
Monthly Principal Reduction
MONTHLY PAYMENT
Net Monthly Cost of Buying
16
Principal and Interest
Total Monthly Payment
Call Us For more Personalized
17
Monthly Tax and Insurance
Less Monthly Appreciation Rate
information.
We would like to
18
Mortgage Insurance Premium
Less Monthly Principal Reduction
meet with you, give you our new
19
Home Owner Association Fee
Less Monthly Tax Savings
book on purchasing a home, &
20
Total Monthly Payment (PITI + HOA)
Loss of interest earned on down payment
advise you on whether buying or
21
Closing Costs amortized over ownership
continuing to rent is your best
22
What you pay for rent now:
Net Monthly Cost of Owning
course of action.
Buying is not
23
Monthly rent paid less renters tax refund
for everyone!!!
24
Monthly Adjusted Cost of Renting
Monthly Adjusted Benefit of Buying
25
Annual Cost of Renting instead of Buying
1st year Benefit times Years Owned
Linda
(952) 931-9008
26
Are you a FIRST TIME homebuyer?
YES
NO
You May Qualify for Income Tax Credit:
Chuck (952) 239-1311
Adjusted 1st Year Tax Savings
Copyright 2008 Chuck & Linda Heubach Used by Permission
* Notes on Taxes:
Tax Laws are complex and these benefits are outlined in only general terms.
Consult your tax
professional on all matters of taxation.
Your State and Local Tax Law may offer additional benefits.
All Calculations are Estimates Only. Your Actual Results Will Vary.
Appreciation and principal reduction are balance sheet benefits.
While these will not help your cash flow, they are
elements of building wealth. Compare Total Monthly Payment to Rent to estimate the cash flow difference.
The browser does not support JavaScript. The calculations will not work. Please access the web page using another browser.