Introducing Our Open Source Rent v. Buy Model

11 Jun

Ladies & Gentlemen, today Stone Street Advisors is officially unveiling the start of our commitment to help the Public make informed financial decisions, namely when it comes to finding a place to call home.  In the immortal words of Taste_arbitrage:

One of the things that puts a huge smile on my face is listening to people talk about this particular trade they are getting into, because its one they really get excited about.

Imagine if you will, you are an analyst trying to pitch this to your PM. ”So I have this trade.  We have got to put this on, I love it!  The underlying is largely illiquid, even at the highest volume ever recorded, comparable securities only trade once ever 17.6 years.  We are going to put it on at 400% leverage, and just lever down over the course of trade.  I have not looked at the carrying cost of the position but I just assume they are negligible, because that makes it sound better to me.  I have done zero top down analysis on the macro themes that could affect the trade.  I have done zero bottom up analysis on what the security is worth based on cash flows or liquidation value.  I have however looked at comparable securities in the sector and based entirely on that I think it’s cheap.  Oh and here is the best part!  The value of the underlying is roughly 2.3 times our firm wide revenue so if it goes against us or we are cash strapped we will have no choice but to file for bankruptcy.”

If this sounds like one of the worst ideas ever put together that’s because frequently it is.  Welcome to the fund creating real systemic risk: American Dream Capital.

Sadly, that’s exactly how most people approach deciding whether to rent or buy, and how much they can afford to spend on each.  With the internet, literally more information than 99% of people can comprehend is at your fingertips, and there’s absolutely NO REASON for anyone to be able to claim they bit off more (mortgage) than they could chew because they didn’t know the rate was going to jump or whatever other bullsh*t excuse they may try to use.  If you know how to read, and you have access to a computer (i.e. anyone who’s buying a home or signing a rental lease), there’s several calculators online to figure out what you’re getting into.  I didn’t love any of the tools I found online, for example this overly-simplistic one – in my opinion – from 2 months back in the NY Times, so I decided that we’d build our own.

Thus, I present to you version 1.1 of our Open Source Rent v. Buy Model (note: for some reason WordPress won’t allow us to upload the Excel file here so that’s why its hosted @1-2 Knockout on typepad).  This model takes (or will take, in certain situations) into account every expense we could think one might encounter when renting or buying a home.  Certain figures are hard-coded based on our research.  Others can be modified by the user (potential buyer/renter) based on their estimates (which themselves SHOULD be based-upon solid research) to help them decide to rent or buy, and how much they can afford to spend on each.  Just to make this as clear as possible before anyone jumps down my neck: I did this model quick & dirty, that is, don’t be surprised if there’s a few screwed-up formulas/typos/etc.  Part of the motivation for making this Open Source is so you CAN find any mistakes and fix and/or improve them!  Basically what I’m saying is that it’s a team effort, and that was our intention right from the start.

So, while this is a work-in-progress, i.e. we know the Model isn’t complete, however, because the basic structure and functionality is in-place, we’ve decided to publish it and make it publicly available to view and modify in/from its current form.  Anyone is welcome to download the Model and play around with it or use it for their own purposes, however, we request that it not be used for any sales/marketing purposes, and assume zero liability for any decisions made as a result of using the Model, nor any responsibility for the accuracy of any of the figures or calculations contained therein.

Beyond that, we hope to be able to work from here and develop a robust decision tool to help people make informed financial choices.  Any/all constructive commentary is welcomed, nay, encouraged!  Let’s all put our skills and effort together to do something that’d help everyone, financial professional or not, avoid being the dumb money.

UPDATE:

Thanks to @zerobeta, I’ve uploaded the document to Google Docs.  Email me to get permission to view, or just download the .xls, edit and email me the doc with your updates and I’ll share it with the world!

Advertisements

5 Responses to “Introducing Our Open Source Rent v. Buy Model”

  1. Byrne June 11, 2010 at 8:23 pm #

    Taste_Arbitrage’s comment omits my favorite part of the home buying equation: the value of the asset is almost entirely dependent on the labor market, and the local labor market determines the NPV of the buyer’s wages, which are (for most of their career) by far the largest component of their net worth.

    “Hey, boss. We found an illiquid way to double-down on your least diversified investment.”

  2. Nicola June 12, 2010 at 9:18 am #

    Well done and very timely …
    http://www.nytimes.com/2010/06/12/business/12nocera.html

  3. hoser June 13, 2010 at 6:06 pm #

    Nice work. Don’t forget that there are recurring expenses that a landlord likely covers – repairs and maintenance as well as some utilities. These should be added costs of owning.

  4. Melisa Finwall July 16, 2010 at 8:32 pm #

    make money at home with google

Trackbacks/Pingbacks

  1. Sunday links: hope and fear Abnormal Returns - June 13, 2010

    […] buy vs. rent model spreadsheet.  (Stone Street Advisors also […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: