Buy versus Rent, Play with Your Own Numbers

| | Comments (0)

A few years ago, I wrote up a spreadsheet for buying versus renting a home.

I got reminded of it a couple days ago with a nonsense article out of an alleged financial paper, so I went back and found that, yes, indeed, I did still have a copy.

I just uploaded it for those who might want to play with the numbers themselves.

BuyHomevsRent.xls

It's in Excel 97. I suppose I could convert it forward, but my current copy of Excel had no problems with it.

It compares cost of renting and investing the difference versus a home purchase. I wrote three different scenarios into the spreadsheet: Never refinance, refinance every five years but keep making payments with an eye towards having zero balance thirty years after you originally bought, and refinance every five years and make the minimum payment on the new thirty year loan.

The sheet "Front" should be where you start, in case one of the others comes up. You enter your own values for the numbers down the left side of the sheet.

Purchase Price and down payment should be self explanatory
value adjustment was a feature I put in to adjust to what other, equivalent properties might sell for
assumed appreciation of the property
interest rate of the first mortgage (TD=Trust Deed)

interest rate of the second mortgage: given the market at the time, I assumed anything over 80% of value (Lesser of Cost or Market, i.e. lower of appraisal or purchase price) would be on a second trust deed. These days, second mortgages over 90% CLTV are not available.

property tax
yearly property tax increase

monthly cost of Homeowner's Association dues plus insurance (add in things like Mello-Roos payments here too),
Assumed rate of inflation
what it would cost to rent an equivalent property instead

the cost of refinances I wrote about earlier (I assumed a standard closing cost figure - no points, no rebate from yield spread)

your standard deduction on federal taxes based on your filing status. The year I wrote this, the standard deduction for married filing jointly was $10,100. For 2014, if I recall correctly, it's $13,200. If your status is something else, you can look up your standard deduction any number of places. The point is, you get this much of a deduction anyway - it's not accurate giving benefits from the home ownership deduction until you have actually exceeded the deduction everyone gets.

Value of your other federal income tax deductions. Just as it's not accurate giving benefits until you exceed the standard deduction, it's not an accurate comparison to withhold other deductions over the standard amount that you'd get.

Your marginal federal income tax rate - what you paid on your final dollar of income for the year. The spreadsheet does lose accuracy if your marginal rate changes due to the deduction - or would change without it - but that's a small effect and trying to compensate would have been extremely speculative, especially given how much playing with where certain deductions and credits peter out on the income scale.

Finally, the assumed rate of return of an alternative investment into which you would put 100% of the difference between the monthly payments of buying versus renting (as well as the down payment money). Speaking as someone who still had financial planning clients at that point, that's a ridiculously generous assumption, but you might be one of the exceptions.

Caveat Emptor

Delicious Bookmark this on Delicious StumbleUpon Toolbar Stumble It!
Please be civil. Avoid profanity - I will delete the vast majority of it, usually by deleting the entire comment. To avoid comment spam, a comments account is required. They are freely available, and you can post comments immediately. Alternatively, you may use your Type Key registration, or sign up for one (They work at most Movable Type sites) All comments made are licensed to the site, but the fact that a comment has been allowed to remain should not be taken as an endorsement from me or the site. There is no point in attempting to foster discussion if only my own viewpoint is to be permitted. If you believe you see something damaging to you or some third party, I will most likely delete it upon request.
Logical failures (straw man, ad hominem, red herring, etcetera) will be pointed out - and I hope you'll point out any such errors I make as well. If there's something you don't understand, ask.
Nonetheless, the idea of comments should be constructive. Aim them at the issue, not the individual. Consider it a challenge to make your criticism constructive. Try to be respectful. Those who make a habit of trollish behavior will be banned.

Leave a comment

Copyright 2005-2024 Dan Melson All Rights Reserved

Search my sites or the web!
 
Web www.searchlightcrusade.net
www.danmelson.com


The Book on Mortgages Everyone Should Have
What Consumers Need To Know About Mortgages
What Consumers Need To Know About Mortgages Cover

The Book on Buying Real Estate Everyone Should Have
What Consumers Need To Know About Buying Real Estate
What Consumers Need To Know About Buying Real Estate Cover

Buy My Science Fiction and Fantasy Novels!
Dan Melson Amazon Author Page
Dan Melson Author Page Books2Read

Links to free samples here

The Man From Empire
Man From Empire Cover
Man From Empire Books2Read link

A Guardian From Earth
Guardian From Earth Cover
Guardian From Earth Books2Read link

Empire and Earth
Empire and Earth Cover
Empire and Earth Books2Read link

Working The Trenches
Working The Trenches Cover
Working the Trenches Books2Read link

Rediscovery 4 novel set
Rediscovery set cover
Rediscovery 4 novel set Books2Read link

Preparing The Ground
Preparing the Ground Cover
Preparing the Ground Books2Read link

Building the People
Building the People Cover
Building the People Books2Read link
Setting The Board

Setting The Board Cover

Setting The Board Books2Read link



Moving The Pieces

Moving The Pieces Cover
Moving The Pieces Books2Read link

The Invention of Motherhood
Invention of Motherhood Cover
Invention of Motherhood Books2Read link



The Price of Power
Price of Power Cover
Price of Power Books2Read link

The End Of Childhood
End Of Childhood cover
The End of Childhood Books2Read link

The Fountains of Aescalon
Fountains of Aescalon Cover
The Fountains of Aescalon Books2Read link



The Monad Trap
Monad Trap Cover
The Monad Trap Books2Read link

The Gates To Faerie
Gates To Faerie cover
The Gates To Faerie Books2Read link

Gifts Of The Mother
Gifts Of The Mother cover
Gifts Of The Mother Books2Read link
**********


C'mon! I need to pay for this website! If you want to buy or sell Real Estate in San Diego County, or get a loan anywhere in California, contact me! I cover San Diego County in person and all of California via internet, phone, fax, and overnight mail. If you want a loan or need a real estate agent
Professional Contact Information

Questions regarding this website:
Contact me!
dm (at) searchlight crusade (dot) net

(Eliminate the spaces and change parentheticals to the symbols, of course)

Essay Requests

Yes, I do topic requests and questions!

If you don't see an answer to your question, please consider asking me via email. I'll bet money you're not the only one who wants to know!

Requests for reprint rights, same email: dm (at) searchlight crusade (dot) net!
-----------------
Learn something that will save you money?
Want to motivate me to write more articles?
Just want to say "Thank You"?

Aggregators

Add this site to Technorati Favorites
Blogroll Me!
Subscribe with Bloglines



Powered by FeedBlitz


Most Recent Posts
Subscribe to Searchlight Crusade
http://www.wikio.com

About this Entry

This page contains a single entry by Dan Melson published on May 3, 2014 8:00 AM.

Thank You was the previous entry in this blog.

The FHA Secure Program: Not Helping Many But Does Help The People Eligible is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

-----------------
Advertisement
-----------------

My Links