SPECIALISTS IN FINANCIAL MODELLING
0 item(s) $0.00 AUD + GST

2008/2009 Excel Income tax calculator

21 July, 2008

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.

About Tiering Tables

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.

Comments

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 - 03: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 - 08: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 - 19:27.

Hi, Could you please email me the password as I would like to see how you structured your formulas for the tax tiers. Cheers.

Submitted by kismet88 on Tue, 17/09/2013 - 00:18.

Post new comment

  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.