Simple Buy to Let Property Excel Model Template

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