Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
  • Simple Buy to Let Property Excel Model Template
Originally published: 10/02/2019 15:48
Publication number: ELQ-96064-1
View all versions & Certificate
certified

Simple Buy to Let Property Excel Model Template

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

Description
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 business tool includes
1 Excel Model Template Spreadsheet

Nikolaos Giannoulis, CFA, AFM, MSc offers you this business tool for free!

download for free

Add to bookmarks

Discuss

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.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

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

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

please wait...