For all you people out there who have read my “a different approach” topic which had quite a strong response,(37replies)you will see on the last post i had a plan in mind.
Anyway related to that I have made a spreadsheet that calculates everything i need to know, it took me around 2 hours to make, i reckon for a young fella like me i think i did a pretty good job.
The only problem with it is that is restricted to my strategy, which is paying properties off quickly.
Still, if anyone is interested in seeing my spreadsheet i made i am more than happy to send it to you via email, i would love to get some comments on it!
I think that you should add the cost of your interest on the loan into your ‘costs’ section, and not have it calculated separately for a tax deduction, and then added back.
When you talk to the taxman, he wants to know if you made profit or loss, THEN he looks at your tax situation, not before.
Also, a realistic figure in the Income Needed box would need to take into account what the two of you need to ‘earn’. Remember to subtract taxes, Super, some living expenses – you do need to have some sort of a life!!
Other than that, I think it’s a good plan, as I said to you, but also consider starting off with a cheaper property which requires less initial capital.
Well, i’ve sent my spreadsheet to over 55 people, but only around 10-15 have the new version.
From now on i will only be sending it to people who email me directly, if you reply to this thread, i will not send it, so please email me to get your copy
Hi Fudge111. I would love to see your spreadsheet. I am just starting out and have a real thirst for any info I can get my hands on. (I am a statistician so am into numbers in general – drab i know!). Will be in touch. Thank you.[]
Looks like people didn’t get the idea NOT to post their emails but to email you directly… YET! []
***Please email Fudge111 at fudgetc(@)hotmail.com to receive your copy of the spreadsheet***
Hope this works []
I found the spreadsheet easy to use, but I’d have liked to see a ‘help’ guide or a ‘how to use’ section. Otherwise it’s very easy to use…just plug in the numbers.
Fudge111 Well done!
Cheers
Soosh []
When a problem is created the solution is created simultaneously
Thanks Sooshie, I am quite happy with it too, considering how little i knew about this stuff like 4 months ago.[]
Melbear, can’t put the interest in with the other cash flows as it is different over the 3 years ie you pay more interest in the first year than in the 3rd, that’s why i have the proration vlookup table.
I could do it that way if i just took the average, as i have done in my new worksheets, but it is not as accurate.
Still, at least now you can any loan term, i also did take into account about tax in the income used, you just have to work out your net salary after tax and see how much of it you can save.
Hey, Blokes,
with all the requests you’re getting, I better have a look as well. I’d hate to miss out on a good thing. [8D]i promise to give you some feed back once I amputate the kids from the PC[:0)] and spend some time checking it out.