MODEL OVERVIEW
 
A buy vs. let analysis compares the financial implications of owning a property versus renting one allowing any potential property owner/renter to make an informed decision before committing themselves in what typically is the largest financial investment they make in their lifetime. The analysis enables individuals to evaluate the long-term financial implications, assess risks, and determine the optimal use of resources, ultimately guiding them towards a housing choice that best suits their needs and circumstances.
 
Our user-friendly Excel model enables the user to compare cash flows and projected asset values from buying or renting a property across a 30-year timeline with 3 scenarios for interest rates, rental rates, repairs and maintenance expenditures, property appreciation percentages and investment returns on unspent cash flows when renting.
 
The model follows good practice financial modelling principles and includes instructions, line-item explanations, checks and input validations
 
 
KEY OUTPUTS
Table showing asset values and cash flows for buy and let options across the 30year timeline.
Key metrics including:
Total cost of ownership
Initial investment
Average ongoing cash flow
Cumulative Cash flow spend
Asset values at end of loan term
 Break-even year
Rental yield
Charts presenting and comparing asset values and cash flows across the 30year timeline for both buy and let options.
 
 
KEY INPUTS
 
General Inputs:
Property Location / Description
Currency;
Starting Month and Year;
Scenario Naming
 
Buy Option Inputs:
Property purchase price
Upfront deposit
Loan period
Interest rates across 3 scenarios
Transaction costs (notary, transfer tax, bank fees plus 5 other types of expenses)
Property appreciation percentages across 3 scenarios
Annual Repairs & Maintenance percentages across 3 scenarios
 
Letting Option Inputs:
Rental Rates per month across 3 scenarios
Deposit assumptions
Initial Expenses (5 categories)
Investment Return on Unspent Cash Flow
 
 
MODEL STRUCTURE
 
The model comprises of 5 tabs split into input ('i_'), calculation ('c_'), output ('o_’) and system tabs. The tabs to be populated by the user are the input tabs ('i_Assumptions'). The calculation tab uses the user-defined inputs to calculate and produce the projection outputs which are presented in ‘o_Results’ tabs.
 
 
KEY FEATURES
 
The model follows best practice financial modelling guidelines and includes instructions, checks and input validations;
The model is not password protected and can be modified as required following download;
The model includes a 30-year timeline and 3 scenarios;
Property and loan details, currency, starting projection period are fully customisable;
The model includes a checks dashboard which summarises all the checks included in the various tabs making it easier to identify any errors. 
 
 
SUPPORT / MODIFICATIONS
 
We are keen to ensure our customers are satisfied and find the models useful for their financial projection needs. Our models are developed with the user in mind and include instructions, line-item explanations, checks and input validations to ensure they are as user-friendly and easy to use as possible without requiring extensive knowledge of Microsoft Excel, finance or accounting. If any questions do arise, we are more than happy to assist. We are also happy to support with any be-spoke modifications you may require to the models to better suit your business needs. To get in touch, please send us a message through the website or contact us on: hello@useprojectify.com