ABCDEF
1
Buy A House Or Rent?
2
3
If you want to edit this, CLICK FILE THEN MAKE A COPY!
4
DO NOT REQUEST ACCESS TO EDIT THIS DOCUMENT!!
5
6
This spreadsheet will help you answer the question that many Americans ask, should I keep renting or buy a home? Buying a home can have financial advantages, but many times these are overstated, and hard to figure out exactly how much these savings are.
7
8
Instructions:
9
First, make a copy of this in your own Drive. Click File... then Make A Copy, and give it a name. This will put it in your own Drive so you can edit. Once you do that, then enter numbers or estimates in each cell that is yellow. Once you enter everything in, the section on the right will tell you whether it makes more sense financially to rent or buy, and how much money you'll save by buying or renting. This only considers the time from now until you would sell the house that you are considering buying. Please read the disclaimer at the bottom.
10
11
Note that the accuracy of this all depends on a good estimate from you on how long you think it will be before you sell the house you're looking to buy, and how much you think it will sell for. Be realistic. The younger you are, the less secure your career is, and the more your income will change from year to year (both up and down), the more likely you are to sell within 5 years.
12
13
Home Purchase
14
Is an FHA Mortgage?
15
Estimated New Home Price:$450,000Current monthly rent:$2,100(A rough annual increase of 3.5% is applied to these to calculate the total rent paid)
16
Down Payment %:5.00%Monthly renters insurance:$20
17
Down Payment:$22,500Total cost of renting:$136,358
18
Mortgage Amount:$427,500
19
Interest Rate:5.500%Monthly payments from owning that you don't get back:$163,196
20
1.25% FHA Insurance Premium (MIP):$5,625(interest, taxes, etc.)
21
(fee for an FHA mortgage)Profit from owning:$7,247
22
Other Closing Costs:$6,000Total cost of owning:$155,949
23
(closing costs are difficult to estimate, they vary widely by county/city, $6000 is a good guess)
24
Money required upfront:$34,125It makes more financial sense toRENT!
25
(you need this much money upfront to buy the house)
26
You will have saved$19,591
27
Mortgage, other monthly costsin 5 years by RENTING instead of owning
28
(these costs are how much you'll pay every month)
29
Principal:$468If you want to buy a home, see my other spreadsheet template for whether you can afford the house or not:
30
Interest:$1,959https://docs.google.com/spreadsheet/ccc?key=0Al_XAoAHsV3edDFnZ09YMWg5WS1TOEt4U05QUWxmalE
31
Yearly Property Tax rate: 1.04%
32
(varies by county/city)
33
Property Tax:$390
34
PMI %:0.85%(this can vary based on type of mortgage and your credit score. Don't change this unless you know a specific rate you'll get)
35
Monthly PMI:$303(required for FHA loans where down payment is less than 22%, or non-FHA loans with less than 20% down payment.)
36
Homeowners insurance estimate:$50
37
Homeowners Association/Condo Fees:$87
38
Monthly Cost:$3,257
39
40
Selling the house
41
In how many years5(be real, how long before you want something bigger, something nicer, etc. Don't go higher than 15, the spreadsheet will break. If you're going to be there more than 15 years you don't need this)
42
Selling price:$500,000(be real here, it's not 2004 any more, if the value goes up it won't go up by much)
43
Closing Costs:$4,000(difficult to estimate, leave at $4000 unless you know otherwise)
44
Realtor fees (6%):$30,000(in case you didn't know it, the buying and selling realtors each take 3% of the sale)
45
Mortgage Owed:$395,269
46
Total amount left with after sale:$70,731(how much money you'll have to put in to a second house down payment)
47
48
Total monthly payments while owning
49
Total principal paid:$32,231
50
Total Interest Paid:$113,407
51
Total other payments:$49,789
52
Total of monthly payments:$195,427
53
54
Tax deductions while owning
55
(being able to deduct mortgage interest from taxes is often cited as a big reason to buy a home, this will show how much this deduction will actually be worth to you. It's probably not as much as what you think)
56
Married filing jointly?(if you are married and filing your taxes jointly)
57
Mortgage deductable expenses in a year$28,193(interest and property taxes)
58
Other itemized deductions per year$5,000(hard to estimate here, just guess what your state income taxes are + charity)
59
minus standard deduction$12,400(what you can deduct while renting, if you don't itemize, which you probably don't)
60
Extra deductions per year from owning:$20,793
61
Your Federal Tax Bracket:22.00%http://www.moneychimp.com/features/tax_brackets.htm
62
Value of extra deductions per year$4,574(if this is $0, then it will be better to keep doing the standard deduction, so you get no tax benefit from the mortgage)
63
64
Profit from owning
65
Home value appreciation:$50,000
66
Buying and selling fees (closing, realtor, etc):$45,625
67
Average Annual Maintenance/Repair Expenses:$4,000(big guess here, don't underestimate this. You can expect at least one major expense every few years, plus lots of routine costs and periodic appliance replacement)
68
Total maintenance/repair expenses:$20,000
69
Total value of tax deductions:$22,872
70
Total profit:$7,247
71
72
73
Known Problems with this spreadsheet:
74
There are a lot of complications with FHA mortgages, and I don't personally have an FHA mortgage, so I'm going by what I read here. I don't believe that FHA monthly PMI is tax deductible but I'm not 100% sure, I didn't include this in tax deductions for this spreadsheet
75
76
Disclaimer:
77
I'm not a financial consultant or in the finance industry. While I've made every attempt to make sure that these numbers are accurate, I can not be held responsible if these calcuations are not correct.
78
79
80
81
82
83