Calculating Your Profit And Loss

Buy To Let is a business, period.

Anyone that has a property on the rental market is running a business, regardless of how dislocated they are from the project. I know a lot of Landlords don’t see it as a business, but rather a long term investment which just ‘works’ on its own accord. While that maybe the case, the fact still remains that your investment required capital investment; in the short and/or long term you expect a good return, which is essentially the whole concept of any financial business. No one is in this game to come out at the other end poorer.

In order to measure the success rate of a financial business profit and loss needs to be measured. It’s extremely important for landlords to measure how much they are putting into the pot and how much they’re getting in return. If the business is running at a loss, what is the point of running at all?

How many landlords can tell me how much they spent on their investment in 2006? How many landlords can tell me how much they spent on maintenance over 5 years? I’m sure the numbers would be limited.

The extent of how deep you want to go with your analyse is dependent on how far you want to dig- the limit is endless. I try to monitor my investments to the level where I know what is going on e.g where my money is going. A lot of landlords don’t even track basic payments like rental income and mortgage payments. Tracking the basics is the bread and butter work every landlord should be doing; simply collecting the rent and making mortgage payments is only half of the work. It’s all good collecting rent and paying the bills, but it makes no sense if you’re doing it at a loss.

When I started letting a property, I wasn’t keeping on top of things, consequently I soon learned it was becoming increasingly difficult to track my expenditures off the top of my head. I would get so confused that I couldn’t even remember when or if my tenant paid her rent, and she was only paying on a monthly basis. It’s extremely easy to lose track of even the most basic payments. As a solution I constructed a very simple Excel sheet that calculated everything I wanted to know.

Here’s a snap shot of it (click to see full-size):

Like I said, it’s extremely simple. It basically holds basic information about the tenant and property (useful for those with multiple properties), and most importantly, calculates all my incoming and outgoing expenses, which ultimately allows me to get a net income. Everything automatically updates as I enter new costs. It doesn’t cover anywhere near as much detail as a real property geek would love to indulge in, but it suffices for the average Joe that just wants to look good and know the basics.

I’m going to make the spreadsheet downloadable so you can use it, or perhaps get inspiration from it. Anyone with Microsoft Excel can access the download. If anyone has any suggestions or modifications they would like to see in the spreadsheet, please let me know.

CLICK TO DOWNLOAD

I’ve since developed more elaborate and complicated spreadsheets; once I’ve made them more userfriendly I’ll make them available to download.

Do you measure your success? If not, it’s about time you did.

Attention! If you're new here, you may want to subscribe to my RSS feed so you're notified of all new blog entries.

What To Do Next?

Leave A Comment On This Article Send Article To Friend Email Me (the admin)

Printable Version Suscribe To My RSS Feed Digg it

Fiona wrote, on Nov 6th, 2007

	It looks really good …… its abit scary when I see how someone is so organised because you just have to be .. I started one and then i got abit side tracked :/ maybe this will motivate my lazy arse , or not
1

The Property Amateur wrote, on Nov 6th, 2007

	Thanks, Fiona. Although i’m not really THAT organised; i’m pretty lazy also. Putting in a new entry takes about 1min, anyone can do it. It’s designed for lazy people such as myself that don’t want to monitor too much, but is up to date with the basics
2

Just saying wrote, on Nov 6th, 2007

	Thats pretty cool mate. i’m going to use your spreadsheet because its simple to use and im a simple person lol. many thanks
3

Add Comment

Name (required):

E-mail (required - never shown publicly):

Notify me via email when someone else leaves a comment

Your Comment: