# Number crunching

Discussion in 'Property Finance' started by Jack95, 9th May, 2016.

Join Australia's most dynamic and respected property investment community
Tags:
1. ### Jack95Well-Known Member

Joined:
2nd May, 2016
Posts:
54
Location:
Perth
So there are many different ways people use to find out whether they think a property is worth investing in.

But what are some of the formulas people use to help couch the numbers?

Does anyone use Microsoft Excel to do the math?

2. ### thatbumWell-Known Member

Joined:
18th Jun, 2015
Posts:
1,799
Location:
Perth, WA
Can I ask what sort of numbers you are crunching? I have to say, when I try and figure out whether a property is worth investing in, there isn't a particularly big maths component to my decision making.

3. ### Jack95Well-Known Member

Joined:
2nd May, 2016
Posts:
54
Location:
Perth
Anything really, CG potential, yields, increase in interest rates to see how you would go if there were any increases.

4. ### thatbumWell-Known Member

Joined:
18th Jun, 2015
Posts:
1,799
Location:
Perth, WA
To be honest, nearly all the maths I use is only for the purposes of comparison - which only needs really basic calculations such as gross yield and rough costs for holding the property etc.

I find trying to use complex maths to predict things in the future to be quite artificial, and I can't see much value in it.

Joined:
18th Jun, 2015
Posts:
9,182
Location:
Sydney
I just ran some numbers. Our last home went up 650k (87k per year) over the approx. 7.5 years we owned it.

To rent a decent property in Sydney over that time would have cost \$550 per week.
The numbers...
500 x 52 = \$28,600.
\$28,600 x 7.5 = \$214,500.
That's a staggering \$214,500 in rent we didn't pay to a landlord, and instead we had an asset that went up \$650k!

Our interest over that period was only about \$25k per year (but we paid it right down).
And we nearly paid it off over that period.

So we could have flushed over 200k in just rent down the gurgler but what we did was pay down a house that just about doubled.

What can I say... bloody brilliant. Just needed a deposit to get going and a feeling of wanting to buy a home back in 2008, which was a good time to buy. Sydney's market may slow down at some time but i'm so glad to have been on this ride...

wombat777 likes this.

Joined:
18th Jun, 2015
Posts:
2,505
Location:
On a Capital Growth Safari
I just use a simple cashflow spreadsheet formatted to suit my phone. Allows me to run numbers fairly quickly.

Perthguy likes this.
7. ### PerthguyWell-Known Member

Joined:
23rd Jun, 2015
Posts:
9,953
Location:
Perth
Yes, I use Excel to do the math.

EDIT: I have shown so many spreadsheets to my mortgage broker that he calls me "Mr spreadsheet"

8. ### Phase2Well-Known Member

Joined:
14th Jul, 2016
Posts:
1,290
Location:
Perth
Yeah, I would guess that lots of us use it, but modelling will only run scenarios for you.

Excel won't tell you how much you can borrow, or what suburbs to buy, or what strategy/s to use, or how to structure your investments.

Ultimately, it's best use is in tracking cashflow and using it for tax time... Otherwise you're just playing with numbers.