How much will you save under the new 2008/2009 financial year taxation changes? As of 1st July 2008, the tax brackets are changing, which means we all pay less income tax! Download our handy new Excel-based tax calculator and find out roughly how much you will save.
Calculating an amount based on tiering tables is a pretty complex formula, and is commonly used in pricing models. There are two types of tiering tables. The simplest version calculates the entire amount at the tier. The more complex table, like the tax tiers, is progressive such that the first number of units at the first tier and the next amount at the next price.
For example, in the tax table, an income of $8,000 would be taxed at zero for the first $6,000 and then the next $2,000 is taxed at 15%, so you would only pay $2,000 x 15% = $300, not 15% on the whole amount.
Want to know more? Learn how to do this as part of our training courses.
"Listening to @Kenny_WJ's Financial Modelling podcasts whilst waiting in the taxi queue at Sydney airport. #fb #li"
Based in Sydney, Australia, Plum Solutions has been providing professional financial modelling solutions since 2004.
I am interested in improving my excel skills and want to take a look at this model and know how it was done. Could I have the password? Thaks
Submitted by Rojeda on Tue, 29/12/2009 - 02:59.
No problems, I will send it to you. Anyone else who is needs the password, simply email info@plumsolutions.com.au to request it.
Submitted by danielle on Tue, 29/12/2009 - 07:26.
I originally wrote this calculator for the purpose of demonstrating the practical application of using a tiering table in a financial model. It has been very popular since I published it and I must make the note that the tax brackets have changed again since then!
Please see the ATO website for the most up to date tax bracket changes and I will update the original calculator soon!
Danielle Stein Fairhurst
Principal
Plum Solutions.
Submitted by danielle on Sun, 16/05/2010 - 18:27.
Post new comment