Feedback
Hello Guest, (login)
ask sarah a question

related articles

What Furniture Packs Can Do for your Buy To Let Business?

What Furniture Packs Can Do for your Buy To Let Business?

» more

If you’re selling your house online and it’s not on video, think again.

If you’re selling your house online and it’s not on video, think again.

» more

Emergency Budget at a glance

Emergency Budget at a glance

» more

How to beat the budget cuts

How to beat the budget cuts

» more

Photography to sell houses - The perfect photos

Photography to sell houses - The perfect photos

» more

Thinking of building an summer house - Size matters!

Thinking of building an summer house - Size matters!

» more

A guide to home staging

A guide to home staging

» more

Being Ruthless in your Garden

Being Ruthless in your Garden

» more

Relocation Tips

Relocation Tips

» more

Show Time

Show Time

» more

‘Rent Now, Buy Later’ How to get onto the property ladder today!

‘Rent Now, Buy Later’ How to get onto the property ladder today!

» more

"Renewables as a sound financial investment? Surely not!?"

» more

Window Dressings with a Difference

Window Dressings with a Difference

» more

A home-seller’s guide to steam cleaning your carpets for extra saleability…

A home-seller’s guide to steam cleaning your carpets for extra saleability…

» more

Elevated Photography a “Marketing Edge on the Website”

Elevated Photography a “Marketing Edge on the Website”

» more

3D Visualisation - The art of selling a property that does not yet exist

3D Visualisation - The art of selling a property that does not yet exist

» more

Ashlar block render.. still looking good?

Ashlar block render.. still looking good?

» more

What a transformation!

What a transformation!

» more

Home buying advice: Live webcast (28 Jan 2010  13:00 UK time)

Home buying advice: Live webcast (28 Jan 2010 13:00 UK time)

» more

The Evictions Expert’s Top 5 Tips for Landlords

The Evictions Expert’s Top 5 Tips for Landlords

» more

Spend a little - Save Thousands

Spend a little - Save Thousands

» more

The UK property market effect on the UK economy

The UK property market effect on the UK economy

» more

Trials and Tribulations of a Home-Seller (8)

Trials and Tribulations of a Home-Seller (8)

» more

Trials and Tribulations of a Home-Seller (7)

Trials and Tribulations of a Home-Seller (7)

» more

Trials and Tribulations of a Home-Seller (6)

Trials and Tribulations of a Home-Seller (6)

» more

Trials and Tribulations of a Home-Seller (5)

Trials and Tribulations of a Home-Seller (5)

» more

Update: Where am I on my journey?

Update: Where am I on my journey?

» more

Trials and Tribulations of a Home-Seller (4)

Trials and Tribulations of a Home-Seller (4)

» more

Direct property investment options:

Direct property investment options: "Buy-to-let"

» more

Different ways to invest in property...which to choose?

Different ways to invest in property...which to choose?

» more

Trials and Tribulations of a Home-Seller (3)

Trials and Tribulations of a Home-Seller (3)

» more

Rural house prices in the UK have managed to hold their value better than those in urban areas

Rural house prices in the UK have managed to hold their value better than those in urban areas

» more

First-Time Buyers Need £32,000 Deposit

First-Time Buyers Need £32,000 Deposit

» more

Act Fast To Secure The Right Mortgage For You

Act Fast To Secure The Right Mortgage For You

» more

Second-Home Renters Should Maximise Tax Breaks

Second-Home Renters Should Maximise Tax Breaks

» more

Trials and Tribulations of a Home-Seller (2)

Trials and Tribulations of a Home-Seller (2)

» more

Trials and Tribulations of a Home-Seller (1)

Trials and Tribulations of a Home-Seller (1)

» more

Choosing the right insurance for student digs

Choosing the right insurance for student digs

» more

25 simple steps that could save you £10,000

25 simple steps that could save you £10,000

» more

What you should know if you're a landlord

What you should know if you're a landlord

» more

Buying for enjoyment or profit?

Buying for enjoyment or profit?

» more

Wow, there's a lot to learn...

Wow, there's a lot to learn...

» more

Journey Update

Journey Update

» more

The perils of leasehold property

The perils of leasehold property

» more

Housing Crisis Over?

Housing Crisis Over?

» more

Day 0.5 - The story so far

Day 0.5 - The story so far

» more

Day 0 - The start of the journey

Day 0 - The start of the journey

» more

Why am I doing this blog?

Why am I doing this blog?

» more

Who am I?

Who am I?

» more

What is Property Journey?

What is Property Journey?

» more

Guest Bloggers

Guest Bloggers

» more

Property Decision Spreadsheet

Posted: Thursday, 24 September 2009

I’ve put together a very rough and ready “Property Decision Sheet” and you can download it for free here.

Click here to download

It allows you to stick in the details of each BTL mortgage you’re currently considering for a potential property purchase - you then enter the relevant costs and charges and it will tell you what the yield, ROCE etc is. Any box that is Yellow is editable - don’t edit the other boxes in grey as I’ve left these unlocked so you can check my formulae!

Like I say, it’s very rough and ready but it has really helped me get an understanding of what’s going on.

One thing to point out is that it doesn’t take into account of the possibility of increasing interest rates after the term of the mortgage is up. Also, please do not use this sheet to make any financial decisions - there could very well be mistakes in it. By downloading it you agree that you are using it merely for reference and open it at your own risk! Phew.

The main thing it has highlighted for me is the importance of buying below market value! In fact, it has put a bit of a dampener on my enthusiasm as it just looks too expensive to get a BTL at the moment.

Any questions, let me know via twitter @propertyjourney.

I’m expecting some clever people to help me refine this sheet - so please get in touch!

 

With thanks to Pete from his Property Journey website, where he's sharing every success and failure on his ongoing journey from property amateur to buy-to-let entrepreneur. Follow him at http://propertyjourney.tumblr.com, Twitter: @propertyjourney and find him on Facebook"

 

 

Bookmark and Share

Comments (0)

There are currently no comments for this article.

Post a comment

You need to login to post a comment
Ask sarah a question

Got a question?

Have you got a question about something that's not here? Why not ask Sarah?