Jump to content
mdavies

BTL Calculator Spreadsheet

Recommended Posts

Hi Guys,

I'm looking for a spreadsheet to use when working out the figures for a new deal. I notice Rob had one on the property geek website https://www.propertygeek.net/complete-guide-extras/?utm_source=drip&utm_medium=email&utm_campaign=Your+"Complete+Guide"+extras BUT I don't think it's available to use or download. Does anyone have one available as I wouldn't know where to start on excel. TIA

Share this post


Link to post

Evening

I have this one saved on Google Sheets that was based off of Rob's version, and then modified to include other details if it helps?

Google Sheets - Property Calculator


Personal Blog: https://abcdad.co.uk.
Looking to read some Property books? https://abcdad.co.uk/books/property-books
Follow on Instagram: @abc.dad

Share this post


Link to post
On 4/24/2020 at 9:49 PM, DerekT said:

Evening

I have this one saved on Google Sheets that was based off of Rob's version, and then modified to include other details if it helps?

Google Sheets - Property Calculator

Hi @DerekT love this spread sheet!

Quick (newbie) query - where is the cell showing how much our mortgage repayment is/would be?

Also what does Stressed Test mean - is this if market situation changes? Sorry if the answers are obvious.

Share this post


Link to post

Hi khuram

Thanks for the feedback! 

The spreadsheet assumes it's interest-only, with the annual mortgage interest is shown in column AG (so just need to divide by 12 to find the monthly).

And yes, stress test is if the market moves and interest rates were increased. Not likely at the moment, but you can tweak it to test whether the investment is viable if rates were to increase to x%. For example, if a single let is still generating a positive cash flow based on a 7% stress test rate, then you know you'll be to cover the outgoings without having to dip into your reserves should rates get that high. 

Any other queries, feel free to ask!


Personal Blog: https://abcdad.co.uk.
Looking to read some Property books? https://abcdad.co.uk/books/property-books
Follow on Instagram: @abc.dad

Share this post


Link to post
On 4/27/2020 at 4:39 PM, DerekT said:

Hi khuram

Thanks for the feedback! 

The spreadsheet assumes it's interest-only, with the annual mortgage interest is shown in column AG (so just need to divide by 12 to find the monthly).

And yes, stress test is if the market moves and interest rates were increased. Not likely at the moment, but you can tweak it to test whether the investment is viable if rates were to increase to x%. For example, if a single let is still generating a positive cash flow based on a 7% stress test rate, then you know you'll be to cover the outgoings without having to dip into your reserves should rates get that high. 

Any other queries, feel free to ask!

This is super helpful and I will certainly use it going forwards. Thanks again for sharing. 

Share this post


Link to post

there is a free app out there called Lendlord, it has a deal analysis section which works well. I recently started using it and have added my properties and some history.

Company is committed to keeping it free and they are updating functionality all the time based on feedback, personally i think the product is excellent but try it for yourselves https://www.lendlord.io/

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×