Tax Calculator Addin for Excel that allows you to use simple excel functions in any excel spreadsheet to calculate Australian tax.
- Use excel formulas like =totaltax2012(taxableIncome) in any cell in any excel spreadsheet
- Calculate individual income tax, medicare levy & low income rebate.
- Tax Rates for every year from 1985 to 2012
- Calculate optimal tax distributions between individuals, companies and trusts
- Calculate tax savings in negatively geared investment properties and leveraged share investments
- Calculate after tax earnings for personal budgets
- As an excel formula, it automatically updates when you change your assumptions
- Personal Injury Lawyers can use it to quickly calculate after tax earnings and economic loss calculations
- Family Lawyers can use the calculator to quickly calculate the tax payable on the parties earnings.
- Accountants – Use Goal seek and our functions to calculate the optimal tax distributions.
“We have been using this excel addin for over 15 years and it has saved us thousands of hours in time, providing accurate tax calculations in our expert accounting reports for litigation and simplifying the process of optimising our client’s taxable income between their entities.
The excel functions are easy to use and our whole office has the addin loaded into excel making sharing excel documents a breeze”
Arnold Shields, Director - Dolman Bateman - Chartered Accountants
Excel Functions include:
A Full List of Functions is available here
- =TotalTax2012(taxableIncome) - calculates the total tax payable including income tax, medicare levy, low income rebate and flood levy.
- =IncTax2012(taxableIncome) – calculates just the income tax payable
- =Medi2012(taxableIncome) – calculates the medicare levy payable (does not include the medicare surcharge)
- =LowRebate2012(taxableIncome) – calculates the low income levy payable.
- =Flood2012(taxableIncome) – calculate the 2012 Flood Levy (only applies for 2012 year)
- =MarginalRate2012(taxableIncome) – provides the marginal rate of tax
- =AvgTaxRate2012(taxableIncome) – provides the average rate of tax
- =AfterTax2012(taxableIncome) – calculates the net earnings after tax
- =YearEnd(date) – returns the financial year end (30 June) for any date.
- =Weeks(StartDate,EndDate) – returns the number of weeks between any two dates.
- =Years(StartDate,EndDate) - returns the number of years between any two dates.
- =CPI(date) – returns the CPI Index (Australia) for any given date.
Bonus Functions Especially for Lawyers
- Pre-Judgment Interest Function – calculates pre-judgment interest for NSW and Federal Courts. Calculate prejudgment interest on a line by line basis.
- Post-Judgment Interest Function- calculates post-judgment interest for NSW and Federal Courts.
- Discount Table Functions – returns the 3%, 5% or 6% multipliers for personal injury litigation.
One year subscription to DBTaxCalculator.com.au and free updates for 1 year. We update the calculator whenever tax changes have been passed by the Federal Parliament.
- Tax Calculator Addin for Excel – calculate tax in any excel spreadsheet quickly and easily
- Sample Spreadsheet Templates – see easily how the Tax functions are used saving you time and money
- Help Videos – a comprehensive online tutorial library will show you the features and functions of the Tax Addin
Any questions – please email ashields@dolmanbateman.com.au
The Tax Calculator Addin works with Microsoft Excel 2003, 2007 and 2010 for Windows versions only. Office for Mac is not supported.
Microsoft Excel, Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. DBTaxCalculator.com.au is not affiliated with Microsoft