Show/Hide Navigation
Call us on 020-8226-6901

The Property Investor' Blog

Buy-to-Let Property Investor´s Financial Calculator

Contents (ShowHide)

Buy to Let Financial Calculator

Particularly given the changing economics of the buy-to-let sector, and what we feel is the need to adopt a judicious approach to the relative merits of a given deal, the financial calculator has been developed to facilitate a more detailed analysis.  Please click here or fill your details in the short “JOIN OUR E-MAIL LIST” form to receive the file (as well as the accompanying notes and our professional property investor’s e-book).

Built in Microsoft Excel, the calculator has been split into 7 sections:

  • Headline Figures: provide users with a cursory glance (using data extracted from the following section).  Note that this particular spreadsheet caters only to single-let residential property analysis (not Houses of Multiple Occupation, multiple units, developments, refurbishments etc.);
  • Detailed Figures / Information: a breakdown of 46 fundamental metrics and essential data sources based on inputting a handful of key numbers pertaining to the property in question. Via seven alterable cells, users can view a range of figures including the monthly mortgage payment (based on the adjusted loan to value and pay rate), estimated gross / net yield, return on capital employed (ROCE), the estimated debt service coverage ratio (DSCR), monthly net operating profit after (corporation) tax (NOPAT) and capital growth forecasts;
  • Stress-Testing: users can adjust 10 specific best and worse-case scenarios (i.e. increasing and decreasing the default parameters), namely: purchase price, acquisition costs, open market value (OMV), deposit (equity injection), monthly rental, interest only mortgage figures, void period, new tenancy costs, monthly holding / recurring costs (including mortgage payments) and changes to the liquidity (contingency) fund;
  • Acquisition Costs: Pooling a range of costs including the Stamp Duty Land Tax (SDLT) surcharge for second properties (from April 2016) as well as legal costs, valuation / condition reports, mortgage arrangement / brokerage fees, Special Purpose Vehicle (SPV) creation costs (set-up fee, debenture, transfers and accountancy advice etc.) amongst others;
  • Refurbishment Costs: given the regional variabilities in labour expenses and often unpredictable nature of such works, accurately estimating refurbishment values is a relatively subjective task – even with so-called “vanilla” and relatively simple redecoration / cosmetic updating projects. For this reason, this section of the spreadsheet broadly lists the most common expenditure items when renovating properties for the rental market (without going into specific detail).  We expect to develop specific “buy to sell” financial models in the near future;
  • New Tenancy Costs: a list of the most common expenses involved when initially letting a residential property including tenant finding, reference checking, inventory, tenancy agreement drafting, legal compliance and deposit administration.  These figures can be adjusted according to requirements;
  • Holding / Recurring Costs: perhaps the most important consideration prior to making any buy-to-let acquisition to assure a durable return on investment, we have listed a broad array ongoing overheads (including repairs, maintenance, management costs, insurance, gas / electrical safety certificates, legal / accountancy costs and an adjustable liquidity fund allocation).

Access the buy-to-let property investor’s report by clicking here or completing the “JOIN OUR E-MAIL LIST” form (confirmation will be required).  Note that you will also receive our accompanying notes, an 8-page document which explains how to maximise the use of the calculator.  If you have previously subscribed to our newsletter and have not received the files in our “buy-to-let toolkit”, feel free to email us at info@psinvestors.co.uk. Please also use this email address to forward us your comments and feedback or to discuss your individual investment objectives.

Join Our E-Mail List

Receive our latest report, financial calculator, monthly e-bulletin and exclusive access to property investment opportunities.
Property Expert Market Forecasts 2020 Selling Your Tenanted Property - Tax Implications - Simon Misiewicz Best Property Podcasts 2019 Modern Property Joint Venturing - Lisa Orme Blockchain and Property Birmingham Midshires - Current Buy-to-Let Lending - Phil Rickards Section 24 Finance Act - 22 Expert Insights Land Registry Digital Street - Laura Tombs The Future of the Private Rented Sector (PRS) - David Bond
National Landlords Association The Property Ombudsman Approved Code
Information Commissioner's Office The National Association Of Property Buyers Money Laundering Regulations