Jump to content
cdenman

BTL ROI Calculator

Recommended Posts

Hi guys

 

Slow day at work so tried to whip this up in between meetings.

 

Hope it helps and makes sense. I've tried to provide an example and notes on what to but if you have any queries, give us a shout. There's a few assumptions such as 25% deposit and extra 3% stamp duty, but feel free to amend where needed.

 

If you spot any other mistakes, let me know as well. Good luck.

PropCalcs.xlsx


Blog: https://abcdad.co.uk Insta: @abc.dad

Share this post


Link to post

Hi Guys,

 

New to property investing just looking for my first buy to let now. So this spread sheet Derek has provided is perfect and something I've been looking for myself. Thanks Derek

Share this post


Link to post

Hi Matty

I've moved the spreadsheet to Google sheets. Try:

https://docs.google.com/spreadsheets/d/1ewDWbNsp5E-oj6VNvQ52udVmvy3qAu3vu6R0HEY2S3A/edit?usp=sharing

It may ask you to request access, so I'll add you when it comes through. Then you should be able to save a copy of it to punch your numbers in. 


Blog: https://abcdad.co.uk Insta: @abc.dad

Share this post


Link to post

Thanks for checking. It may have been updated by someone as I don't recall having voids there and I haven't bothered protecting that sheet.

In any case, I've updated the formula to remove the double % calc so should be good now. 

If you've downloaded a version already, you can just delete the extra "/100". 

Let me know if you spot anything else. 


Blog: https://abcdad.co.uk Insta: @abc.dad

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

×