Jump to content
House Price Crash Forum
Sign in to follow this  

Buy Vs Rent Speadsheet - Crunch Your Numbers

Recommended Posts

This is a really well built spreadsheet for calculating the real costs of renting vs buying. As Stone Street Advisors say on their blog:

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.”

Get the spreadsheet here to fill in your numbers:

Rent v Buy Open Source Spreadsheet

It includes all sorts of stuff that is easy to overlook, inflation, discount rates etc.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • 399 Brexit, House prices and Summer 2020

    1. 1. Including the effects Brexit, where do you think average UK house prices will be relative to now in June 2020?

      • down 5% +
      • down 2.5%
      • Even
      • up 2.5%
      • up 5%

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.