Somersoft Spreadsheet Collection
- Thread starter JamesGG
- Start date
This is a Margin Loan Worksheet where MER, Interest and Monthly Fees are paid each month.
Interest is only calculated on an average basis (not takingin to account for days in the month), or where the portfolio is rebalanced. LVR is only new equity to loan borrowed and doesnt included capatial growth, or the loan value to the actual portfolio, only the lending.
If mods feel this isnt complex enough for this section please feel free to delete it...
pm me for any questions
Interest is only calculated on an average basis (not takingin to account for days in the month), or where the portfolio is rebalanced. LVR is only new equity to loan borrowed and doesnt included capatial growth, or the loan value to the actual portfolio, only the lending.
If mods feel this isnt complex enough for this section please feel free to delete it...
pm me for any questions
just keeping this one fresh....it is an awesome thread.
Hi Andy,
Which Excel spreadsheet are you referring to? I may be able to update the tax brackets but there are a few different spreadsheets in this thread.
Which Excel spreadsheet are you referring to? I may be able to update the tax brackets but there are a few different spreadsheets in this thread.
Hi,
it was one by DaveA I think.
http://rapidshare.com/files/51500272/IP_Holding_Costs_v13_final.zip.html
I've uploaded a copy here, cause i can't see it in this thread
it was one by DaveA I think.
http://rapidshare.com/files/51500272/IP_Holding_Costs_v13_final.zip.html
I've uploaded a copy here, cause i can't see it in this thread
Hi Andy,
I've updated the spreadsheet with the 2007/2008 tax rates. This was only a minor change with the $6,000 - $25,000 bracket in 2006/2007 moving to $6,000 - $30,000 in 2007/2008. Hope this helps. Let me know if there are any problems.
Ben
I've updated the spreadsheet with the 2007/2008 tax rates. This was only a minor change with the $6,000 - $25,000 bracket in 2006/2007 moving to $6,000 - $30,000 in 2007/2008. Hope this helps. Let me know if there are any problems.
Ben
This is undoubtly the best thread. can it be made a sticky post please ?
I am looking for a tax calculator for FY 2007-08.
Cheers
I am looking for a tax calculator for FY 2007-08.
Cheers
Hi firstmillion,
I've created a tax calculator on my website http://www.themoneyorb.com/taxcalculator.aspx. Hope this helps.
Ben
I've created a tax calculator on my website http://www.themoneyorb.com/taxcalculator.aspx. Hope this helps.
Ben
It is a sticky, has been for a long time.
First Home or IP?
Here's a spreadsheet that analyses buying one's first property as a first home or IP (uses Qld stamp duty).
Seems at the end of the first year, one is better off buying as a PPR.
If you want to turn it into an IP, better to do so after 12 mths as PPR.
Note that all levels of govt are looking at making it easier for FHBs, so the calculations in the spreadsheet may be out of date after the 2007 fed election.
Here's a spreadsheet that analyses buying one's first property as a first home or IP (uses Qld stamp duty).
Seems at the end of the first year, one is better off buying as a PPR.
If you want to turn it into an IP, better to do so after 12 mths as PPR.
Note that all levels of govt are looking at making it easier for FHBs, so the calculations in the spreadsheet may be out of date after the 2007 fed election.
It is a sticky, has been for a long time.
Thanks Ruby. Been too occupied with work lately
Cheers
Here is a little development one i did. Most cells are locked and some take you too certain web sites that can help you define building costs. It was done for a duplex development, mainly looking at whether or not you would be better off as a company or personal for tax purposes.
hope this worked
Wayne
Wayne
Has anyone found software that is anywhere near as good as what Kitdoctor was dreaming of in his earlier post (post 8)??
Kitdoctor said,
"I dream of a super model that would:
1) predict how a portfolio of multiple properties will grow in value
2) examines my serviceability and predicts when I can afford the next property
3) works out my expected income tax liability from year to year
This super model would cater for such variables as:
1) properties bought in different years (in the past and expected in the future) bought on specific dates
2) variations in income tax scales from year to year
3) P&I loans and I/O loans and switching between them, fixed interest loans, variable interest loans
4) adjusting loan interest rates from year to year
5) multiple loans for each property
6) adjusting salary percentage increases from year to year
7) adjusting rent percentage increases from year to year
8) adjusting superannuation contribution rates from year to year
9) adjusting cost increases from year to year
10) works out purchase costs (both property and loan depending on the state)
11) allows for initial cash deposits on propertiews
12) allows for entry of real information (eg from depreciation schedules, tax returns etc which overrides derived or predicted data
13) income from different sources (wages, rents, shares etc)
14) variable capital growth rates for different properties and the ability to vary the capital growth rate from year to year to allow for cycles
Now that's a challenge
Ciao
Kitdoctor"
Would love to know if there is anything that good out there?
MF35
Kitdoctor said,
"I dream of a super model that would:
1) predict how a portfolio of multiple properties will grow in value
2) examines my serviceability and predicts when I can afford the next property
3) works out my expected income tax liability from year to year
This super model would cater for such variables as:
1) properties bought in different years (in the past and expected in the future) bought on specific dates
2) variations in income tax scales from year to year
3) P&I loans and I/O loans and switching between them, fixed interest loans, variable interest loans
4) adjusting loan interest rates from year to year
5) multiple loans for each property
6) adjusting salary percentage increases from year to year
7) adjusting rent percentage increases from year to year
8) adjusting superannuation contribution rates from year to year
9) adjusting cost increases from year to year
10) works out purchase costs (both property and loan depending on the state)
11) allows for initial cash deposits on propertiews
12) allows for entry of real information (eg from depreciation schedules, tax returns etc which overrides derived or predicted data
13) income from different sources (wages, rents, shares etc)
14) variable capital growth rates for different properties and the ability to vary the capital growth rate from year to year to allow for cycles
Now that's a challenge
Ciao
Kitdoctor"
Would love to know if there is anything that good out there?
MF35
Here's a simple pretty Budget Planner with pie chart.
Allows 'what if' messing with tax deductible investment expenditure.
Allows 'what if' messing with tax deductible investment expenditure.
