Property Investment Forecast Excel Template

Description
Have you found a Buy-to-Let property and you want to know if it's worth investing? Or planning to invest using a mortgage but not sure what the right Loan-to-value, period length, interest rates is? Or maybe you aren't sure how those will influence your return? Perhaps you want to see how the return different properties will have?

If you want to know the answer to any of these questions simply and easily then this is the right property valuation tool for you.

This Buy-to-Let property 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 your inputs.

Outputs include:
1 )Net Present Value (NPV)
2 )Internal Rate of Return (IRR)
3) Payback Period
4) Net Profit
5) Mortgage Payment Cover
6) Price to Rent Ratio
7) Gross and Net Rental Yield
8) Capitalization ratio
9) Cash-on-Cash Return
10) Amount of interest paid in each year over the life of the mortgage term
11) Amount of principal paid in each year over the life of the mortgage term
12) Mortgage balance over the life of the mortgage term


Inputs include:
1) Purchase Price
2) Loan to Value Ratio
3) Product fee and option to add it in the mortgage
4) Full mortgage term in years
5) Initial interest rate
6) Year of sale
7) Sale Price
8) Buying and Selling Fees
9) Discount rate
10) Tax Rate
11) Forecasted rent and growth
12) Maintenance costs
13) Occupancy rate
14) 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 a mortgage, annual rent growth (increases and decreases) and the discount rate.

The model runs for 30+1 Years.
We assume that remortgaging takes place every 5 years and interest rates are fixed.
Initial Mortgage product fee can be added in the mortgage balance and the future fees are added as expenses.
Only cost (not interest) is included in the after-tax cash flow. Interest is considered cash as being tax-deductible.
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