Property management,

it's all about cash flow

 

 

Professional independent advice

If you need help and advise with regard to property surveys, building surveys, structural reports, engineers reports, defects surveys and structural surveys matters , home buyers reports, etc, please phone our free phone number 0800 298 5424 for a chat with a professional.

We are surveyors and we have looked at how best to manage a property portfolio, and here are a few of our thoughts.

 

Property and cash flow

We recently put together a course on cash flow and profit in the property industry and, whilst it is aimed at property investors, it could also be of use to businesses in general, who want to understand how to utilise spreadsheets, we have used Excel spreadsheets, and also how to develop cash flow charts to manage the money, because if you are proposing to buy property as an investment you will soon understand that, whilst there may be long term capital growth, you do need to have cash flow to survive until you get to the point where the long term capital growth has occurred!

 

The difference between cash and profit, or should we more correctly say cash flow?

Cash flow is the difference between cash and profit

As the name implies, this is the cash that is flowing in and out of your business, but as you will soon discover it is also what we would term as real money, as you can spend it. Whereas, profit is more of an accountancy term, as looked at on the balance sheet, and may well not be visible at all, or at least until the end of the year or, in many cases, to the end of years.

You could, for example, be refurbishing a property this year that won't actually then become profitable for three to five years, as it has to pay back the cost of the refurbishment and then also the cost of the interest on the money.


The importance of cash: the term 'cash is king'

 

The importance of cash 'cash is king'The term 'cash is king', which we heard some years ago but it you've never truly understood what it means we will put it this way. It means that you will need to have some cash and cash flow to run your business. To put it into property investment terms - you have a property portfolio to manage, this could mean having the cash flow to pay your finance or funding and, as has been commented, if you have cash flow and can keep paying your mortgage then you will keep the property. If you don't have cash flow you won't be able to pay your mortgage.

 

 

The Excel spreadsheet example

We are going to consider a year's income on a property; one of many, hopefully, in your property portfolio!

Going to your Excel spreadsheet. Put January and February into two cells and then drag across the top of the screen Excel, assuming it is a reasonably new version, will understand that you mean to have the months and will put them in for you.

On the left hand column, just before January, you can type Property 1, and underneath that you can type income. The rent in this case is £600, so in each of the boxes if you type £600 and at the end you put the word Total and then press the Sum Key (which looks like a strange shape capital E). This will total up all of the rental incomes for you.

Underneath that if you put a heading of Funding and put £400 in each column that will be your costs. Again, use the Sum Key at the end. You will therefore have £7,200 in the rental income column and £4,800 in the outgoings column. You will be able to see that in each of the months you will have a cash flow of £200 and if you add up all the £200 you will have £2,400 profit for the year. That will all be well and good if we could buy properties without putting any money in. Incidentally, this is known as buying with no money down, which is possible (although it seems impossible).

We need to add the cost of buying the property, using the nominal sum of £10,000, you will see that at the end of the year there will in fact be a loss. The great thing about spreadsheets is you can project into the future, so if you simply copy and paste the years and add in the cumulative total for each year you will see how long it takes for you to return the cost of your initial investment.

Cash flow

Of course, this is a very simple example because it doesn't make allowances for the value of money changing and the value of the property changing, be it up or down. However, it does demonstrate how having a good cash flow forecast can mean you are very pro-active in how you spend your money. The cash flow forecast also allows you to budget how you are going to spend your money for the year and, what is known as, manage against that budget. Depending upon how accurate your budgets are it can be a depressing or an enjoyable experience!

 

Cash flow forecast spreadsheet

We have devised a cash flow forecast spreadsheet for property that we are more than happy to share with you, although it's not free it's a free property spreadsheet if you go on the course, which will be of great benefit for you as you will learn how to use it.

 

The problems we looked at when carrying out the cash flow forecast were as follows:-

 

Simplicity -v- efficiency. There's a very fine balance between not spending too much time filling out the spreadsheet and it being accurate enough. We have got round this problem by having a top level information sheet, that can be filled in across all of the properties in the portfolio, or you can go through the individual sheets within the Excel spreadsheets and fill them in. There are over 20, so I think we have covered every eventuality!

 

Build your own Excel spreadsheet for your properties for freeBuild your own free Excel spreadsheet for your properties

We thought it would be a good idea to give a free Excel property spreadsheet that you can make at home, so to speak, as for many people with just a few properties this will be sufficient, and also it will be good practice, because you do need a basic understanding of Excel spreadsheet to use our spreadsheet.

 

Starting the Excel spreadsheet

We are assuming you are going to be using a relatively recent version: last three years. If you put January, February in the two cells going across and drag, as mentioned previously, it will then give you all the calendar months. Down the left hand side you put income and then you put rent, applications fees and percentage of utility bills, as these will be your typical income streams, and it's a shame there aren't more of them!

 

Application Fees

Many property investors don't have an application fee, but there is certainly a time and cost implication in processing new applications for the rental of a property if it is to be done properly and the searches are going to be done on their credit history, etc.

Then you put a column along the bottom: total cash in, and you use the Sum Key, or the word Sum. If we stick with £600 per month rent and a £250 application fee in January then we can't go far wrong.

 

Expenses

Expenses will be things like mortgages, repairs, insurance, court costs, gas and boiler check etc

Unfortunately there are a lot more expenses than there are incomes:

 

Mortgages, repairs, insurance, court costs, gas and boiler check. Again, use £400 as the mortgage fees and let's assume an annual bill of £300 on repairs and a bill of £100 for a gas and boiler check.

If you copy this x 10 for ten years, you will start to see how the profits and losses look over that time.

What we are going to add in to make it more realistic is a column along the left hand side called purchase costs. The first bit we will put is assumed no money in a deal. Then we will just have solicitors fees (£500), mortgage arrangement fees (included) and valuation fees (£300).

Now, we are starting to build quite a nice spreadsheet. A couple of things that will make it look even better are adding borders around it, for example, if you go to the toolbar on the right hand side there is a box with squares in it and it is highlighted at the bottom. This allows you to underline it or box around, the rental section, for example. You will also notice in the same toolbar that there is a decreased decimal point section, which you can amend as appropriate, and also you can justify right or left, whichever suits you best.

 

Calculations

 

Calculations in ExcelThe Sum Key on the top toolbar, which you will remember looks like a strange shape capital E, makes the adding up of columns relatively easy. You just highlight them if you don't wish to add them up, you just change the signs within the Sum Key. We also noticed a nice feature where you have quite complex mathematical equations, the Sum Key will change into different colours to highlight where they have come from.

 

 

Triangular Boxes

Equally, we like triangular boxes, where you can add comments, where you can double click and leave a comment for someone else. They also advise where the calculations are wrong, or possibly wrong, Excel just warns you about it.

 

Working on another sheet

You will notice that it is opened up as three sheets along the bottom tab. If you want to transfer the data to another sheet then this is possible. Just be aware of the Dollar sign. This means that the numbers are fixed. To unfix the numbers you simply have to remove the Dollar sign.

 

Freeze pane, or window splitting

This is something we think is great. If you go up onto the top toolbar and on the left hand side is a cell with Windows in. It has freeze pane and you just click on the section that you want.

 

Property portfolio management by surveyors

We hope this has given you an idea of a very basic spreadsheet for your property portfolio or business. We have developed a much more specialist one. If you are interested in coming on a course on this and talking with surveyors that not only manage other people's property but also manage their own and who have done this through several recessions and several booms! Please free phone us on 0800 298 5424.

 

Independent professional property advice

If you truly do want an independent expert opinion from a surveyor with regard to rising damp, lateral damp, condensation or other dampness issues as well as surveys, building surveys, structural reports, engineers reports, specific defects reports, structural surveys, home buyers reports or any other property matters please contact 0800 298 5424 for a free chat with a surveyor.

 

Independent professional commercial property advice

If you have a commercial property, be it leasehold or freehold, then you may wish to look at our Dilapidations Website at www.DilapsHelp.com and for Disputes go to our Disputes Help site www.DisputesHelp.com .

 

Useful articles

We hope you found the article of use and if you have any experiences that you feel should be added to this article that would benefit others, or you feel that some of the information that we have put is wrong then please do not hesitate to contact us (we are only human).

The contents of the web site are for general information only and is not intended to be relied upon for specific or general decisions. Appropriate independent professional advice should be paid for before making such a decision.

All rights are reserved the contents of the web site is not to be reproduced or transmitted in any form in whole or part without the express written permission of www.1stAssociated.co.uk.

Other articles that may interest you:

Mortgage Valuations

Mortgages Aren't they interesting?

Financial Advisers

Independant Financial Advisors pt1

Independant Financial Advisors pt2

Independant Financial Advisers - Are they Independent?

How to Buy a Property at Auction, FAQs

building engineers

Home Buyers Reports Property Surveys - why we're the best. Engineers Reports
© Copyright 1stassociated.co.uk

1stassociated-logo-for-footer IVSA-badge IVSA-putting-client-first call-us-for-footer

New Survey Software for more information click here Survey Software 1st | Modern Methods of Surveying

We have thousands of free property articles to help you - or call us freephone on 0800 298 5424

We have been working in the property industry for many years and have been
providing free property articles for over ten years. All for free and to help you with buying your next property.

House and Home Surveys and Useful Information

All you need to know about Building Surveys

Building Control, what do they do?

Designers and Architects will they save me money or will they cost me money

Enviroment, Your Building and Garden Gnomes

Estate Agents help sell houses and work for the vendors

Have a Structural Survey to protect you against structural problems

Home improvements, builder problems and ideas for you on how to solve them

How a Surveyor values a property, Chartered Surveyors and Regulated Valuers

How Chartered Engineers and Building Engineers can help you

Listed Buildings and Conservation Areas

NHBC National House Building Council

Structural Surveys and How We Can Help You

Traditional and Non-Traditional Houses and Mortgage Problems

Valuations and how much is the building worth?

Whats the difference between a Chartered Building Surveyor, Chartered Surveyor and an Independent Surveyor

Useful property problem articles by Chartered Surveyors explaining building issues to avoid

External - Helpful information on building problems on the outside of the property

Chimney issues and problems

Cracking and Movement Problems and Surveying Solutions

Flat Roof Problems, how we can solve them

Foundations and Structures and Settlement and Subsidence and Underpinning

Pitched Roofs Problems and Solutions

Roof Problems

Wall Problems

Windows and Doors and Fascias and Soffits and Wet Rot and Dry Rot and other problems

Internal - House problems we have investigated inside

All you ever need to know about floors

Asbestos in your home, what you need to know

Ceiling Cracks and Structural Problems

Condensation, Damp and Black Mould Problems

Cracking and Movement Problems and Surveying Solutions

Windows and Doors and Fascias and Soffits and Wet Rot and Dry Rot and other problems

Woodworm is it a problem or not? Is it active or not?

Services - Building help and advice on costly services

Drainage, what's underground can affect what's above ground

Heating; I just can't get my house warm enough or alternatively I just can't get my house cool enough

You can't mess around with the electric, you need an expert

 

Commercial Property Services

Building Terms Explained and Directories

Commercial Property Surveys

Commercial Structural Surveys

Leisure Facilites

Offices Large and Small

Shops and Retail

Warehouse and Industrial Buildings

Dilapidations Help and Advice What is a Dilapidations Notice?

A Beginner's Guide to Dilaps

Damp Mould and Condensation

Dampness Rising Damp Mould Black Mould Condensation

Dilapidations and Negotiations

Dilapidations Claim by a Landlord

Energy Saving what can I do?

Finance what is a Financial Adviser (We are not Financial Advisors)

Fire Risk and Help

Health and Safety Risks

Insurance how do I get the correct property insurance?

Landlords Surveying Advice

Property Investment how can I invest in property?

Property TV Reviews by an Independent Surveyor

Schedules of Condition Leasing a Commercial Property

Scotts Schedule and Section 18 Valuation

Tenants Surveying Advice

Weather how does weather affect my property?

Flooding

Rain

Snow and Ice

Strong Winds

Reviews from clients on Commercial Building Surveys

Churches and Charities, helpful reviews from our clients

Industrial Buildings and Warehouses and what our clients say about us

Offices Large and Small, reviews and feedback from our clients

Pubs, Restaurants, Hotels and other Leisure facilities we have surveyed over the years

Shops and Retail, helpful reviews from our clients

 

First Time Buyers

Buying a Leasehold or Shared Freehold Home

Buying and Selling Houses for the experienced house and home purchaser

First Time Buyers how do I go about buying my first house and home?

Improve your property knowledge with our presentations on house, homes and commercial property

Building Surveys

Building Surveying Useful Information

Dilapidations

Dilapidations Presentations in Detail

Final Year Building Surveying Exams for University Students or those that would like to know more

How old is your Building? Which era was it built in?

Party Walls

Surveyors and Design Tools

Disputes and Party Walls

Boundary Disputes

Building and Property Disputes

Party Wall Book Reviews

Party Walls Your Rights and Responsibilities

1stAssociated Surveyors Review for Structural Surveys and Building Surveys

Building Surveys, reviews and feedback from satisfied customers

Buy to let property clients, what they say about our structural surveys

Buying at auction, review of the survey

Buying bungalows and retirement properties and how our surveyors can help

Both at work / busy couples, how we can help and some 1stAssociated client reviews

Families with a young person flying the nest, reviews and feedback

First Time Buyers, what they say about us

Listed buildings, structural surveys

Older buildings, a review of buying an older house

Families with children looking for a new home, feedback and reviews

Buying a Non-Traditional Property

Residential Surveys

House and Home Surveys

Commercial Building Surveys

Commercial Surveys

1st Associated Surveyors Are Also Available in the Following Areas:

East Anglia and East

South and South East

West Country and South West

Midlands

North and North East

 

London

London Markets

London Parks

 

Wales

Areas of Britain

1stAssociated Independent Expert Property Surveyors

Specialists in Home Buyers Reports, Building Surveys and Structural Surveys and Schedules of Condition

All Surveyors are Royal Institution of Chartered Surveyors qualified and RICS regulated

and are Members of the Independent Surveyors and Valuers Association

Putting the Client First

We do not accept service of documents by email or fax