Simple Buy to Let Property Excel Model Template
Originally published: 10/02/2019 15:48
Last version published: 28/01/2020 09:11
Publication number: ELQ-96064-2
View all versions & Certificate

Simple Buy to Let Property Excel Model Template

A simple Buy to Let (BTL) Property Model with simple assumptions, calculations and valuation.

This simple 1-sheet model is ideal to quickly calculate the rental yields (Gross or Net) , Payback period, Net Present Value and the Internal Rate of Return (IRR) of a Buy to Let property investment based on certain assumptions.

You can control the inputs such as the selling Price of the property, Loan to Value ratio, Mortgage and advisor fees, Stump duty/tax, Costs/Expenses, Interest Rates and mortgage duration, selling price, discount rates, tax rate, Forecasted rent, maintenance costs, annual growth in rent amounts. Occupancy rate, Letting fees.

The model also includes sensitivity analysis to check how the NPV changes when certain inputs change which ideal to perform a stress test on your assumptions. We check the sensitivity of Net Present Value (NPV) to inputs such as Sale Price, Interest rates on mortgage, annual rent growth (increases and decreases) and the discount rate.

Please note that this model is not ideal for input in the decision making process and it doesn't incorporate detailed analysis. A very comprehensive model (available on request) should be used instead for detailed calculations and precice valuation.

Only cost (not interest) are included in the after tax cashflow. Interest is not considered cash deductable. The tax regime differs from one country to the other so please contact us if you need a model for any specific country.

City Research 2019

This Best Practice includes
1 Excel Model Template Spreadsheet

Acquire business license for $15.00

Add to cart

Add to bookmarks


Further information

Get a quick look of valuation and yields based on the publicly available pricing info of a Buy to Let Property.

Ideal for a quick check of rental yields and sensitivities

Not ideal for decision making and detailed analysis. A very comprehensive model (available on request) should be used instead for detailed calculations.


  • Rate this Downloadable Best Practice

    Write a review

  • thomas shelby(last updated: 13/11/2019 11:42)
    Great but missing one thing
    It would be 5 star review if the model incorporated an option for an interest only loan with final redemption in x number of years.
  • Arief Ayumi(last updated: 27/10/2019 10:08)
  • sanjay patidar(last updated: 21/09/2019 17:10)
  • Protasius Ayung(last updated: 29/07/2019 06:16)

People using this Best Practice also downloaded


More Best Practices from Nikolaos Giannoulis, CFA, AFM, CFM, MSc


Any questions on Simple Buy To Let Property Excel Model Template?

The user community and author are here to help. Go ahead!

4.5 / 5 (4 votes)

please wait...