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

Share this post


Link to post
Share on other sites

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
Share on other sites

Derek,

Thank you for uploading this again.

On quick inspection, you need to change how cell AK3 works.

It doesn't calculate the Annual repairs correctly.

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

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

×