Jump to content

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

Link to post
  • 4 months later...

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
Property Spreadsheet and Deal Analyser: https://abcdad.co.uk/property-spreadsheet
Looking to read some Property books? https://abcdad.co.uk/books/property-books
Follow on Instagram: @abc.dad

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.

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
Property Spreadsheet and Deal Analyser: https://abcdad.co.uk/property-spreadsheet
Looking to read some Property books? https://abcdad.co.uk/books/property-books
Follow on Instagram: @abc.dad

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. 

Link to post
  • 2 months later...

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/

Link to post

I have a basic one available.  I still use it to this day and have done over 20+ flips/personal BTL's, works well for me.  I find keeping it fairly simple is best as you can certainly overthink things!

https://fmp-investments.com/free-planner

Darren

 

701670177_HighQualityPNGfileSMALLER.png.5f70ca4cb0d136ae226eb81e0e3e2155.png

      BTS -- BTL -- Lettings -- Sourcing

          www.fmp-investments.com   

             image.png.9da6b48b22099e71e6b38c5c9da690c3.png  image.png.316a3d05478f9de07be32739d4fe4c03.png  image.png.d47c317e14dca0e4c4944a92e2a8e35b.png

Link to post
  • 1 year later...

Hello there

I used the google sheets and https://app.lendlord.io/dealAnalyzer to calculate ROI, all of them are coming up with negative equity. Where am I going wrong?

Here  are my numbers 

BASIC PURCHASE INFORMATION
   
FINANCIAL PERFORMANCE SUMMARY
 
Property Value (est.) £265,000.00   Capitalization Rate 3.6%
Purchase Price £265,000.00   Cash-on-Cash Return -5.1%
Down Payment £79,500.00   Total Equity (Year 5) (1,859,900,013.21)
Equity at Purchase £265,000.00      
         
         
MORTGAGE CALCULATION
   
CALCULATION ASSUMPTIONS
 
Interest Rate £2.00   Rental Income (mo.) £1,100.00
Down Payment £0.30   Vacancy Allowance 5%
Loan Term (Fixed) £30.00   Maintenance Reserve 3%
Loan Amount £185,500.00   Management Fee 12%
Annual Payment £13,080.00   Property Taxes £100.00
Monthly Payment £1,090.00   Insurance £50.00
      Homeowners Assoc. £0.00
      Utilities £200.00
      Electricity £0.00
      Fuel Oil £0.00
      Gas £0.00
      Sewer £0.00
      Telephone £0.00
      Water £0.00
      Other £0.00
      Misc Expenses £300.00
      Accounting $0
      Advertising $0
      Janitorial Services $0
      Lawn/Snow $0
      Legal $0
      Licenses $0
      Miscellaneous $0
      Resident Superintendent $0
      Supplies $0
      Trash Removal $0
      Rental Income Increase 3%
      Property Tax Increase 1%
      Utilities Increase 1%
      Misc Expenses Increase 4%
CASH TO PURCHASE
    Building to Land Value Ratio 75%
Down Payment 79,500.00   Appreciation Rate 4%
Closing Costs 5,565.00   Closing Costs (Buy) 3%
Total Cash Required 85,065.00   Closing Costs (Sell) 8%

 

Hamsa

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
×
×
  • Create New...