BTL Calculator Spreadsheet

[MDavies]

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

[dwayne92]

Did you ever get the spreadheet? 

[DezzaT]

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

[dwayne92]

Amazing, thanks Derek!

[khuram]

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.

[DezzaT]

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!

[steveng]

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. 

[jason_h]

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

Thank You!

[amasonestates]

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/

[Rokas S]

Hi Derek,

Thank you very much for the spreadsheet.

 

[Darren McNeill]

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

 

      BTS -- BTL -- Lettings -- Sourcing

          www.fmp-investments.com   

                 

[dc]

Has anyone tried the free profit calculator on PATMA website it seems quite good and very quick and easy ?

[stonedswan]

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