Free Negative Gearing Calculator

This basic Negative Gearing Calculator will show how much you need to invest weekly and annually as well as how much capital gain you might get if you sell your investment property after certain years.

This free Negative Gearing Calculator is built based on ATO rental property spreadsheet. It automatically calculates the income tax before and after deductions. It in addition shows the gross rental yield of your investment property.

Negative Gearing Calculator Features - Help you to choose the right Negative Gearing Calculator.

Negative Gearing Calculator Excel Spreadsheet

Here is a screen shot that will give you a better idea that what you need to do and what this free property calculator can tell you.

FREE Negative Gearing Calculator

View full size image of FREE Negative Gearing Calculator

Please note that this free property investment calculator DOES NOT automatically populates all the government tax, duties, and the construction cost depreciation. If you would like to save your time from calculating all the government tax, duties, etc, you can purchase the Standard Negative Gearing Calculator or the Professional Negative Gearing Calculator for a value-for-money price for your personal use.

Things You Need to Know

Please note: All the Negative Gearing Calculators (Free version, Standard version, Professional version, or Ultimate version) have the same set of following assumptions.

(1) It is assumed the investor has an interest only (unless otherwise stated) home loan and the interest is deductible for tax purposes.

(2) When calculating the Capital Works Deductions, it assumes that the construction of the property started after 15 September 1987 and therefore the depreciation deduction is claimed for 40 years from the date construction was completed at a rate of 2.5% per year. Please note: You can manually adjust the depreciation deduction values from year to year if this assumption does not suit your situation.

(3) When calculating the tax payables, the tax rates applicable to Australian residents are used and the 1.5% Medicare Levy based on the individual Medicare Levy threshold is included where applicable. The calculator does not incorporate any other factors that might influence the amount of tax payable, such as Medicare levy surcharge, HECS contributions, any rebates, and deductions.

(4) The discount method is used to calculate capital gain tax if you hold the property for at least 12 months. The discount percentage is 50%.

(5) All months are assumed to be of equal length. One year is assumed to contain exactly 52 weeks or 26 fortnights. This implicitly assumes that a year has 364 days rather than the actual 365 or 366.

Download FREE Negative Gearing Calculator Now!


Download Free Negative Gearing Calculator

Personal Use: $0.00 (FREE)
Commercial Use: $59

File Type
.xlsb - Excel Spreadsheet


File Size

Microsoft Excel® 2007 & above for Microsoft Windows®
Microsoft Excel 2011 & above for Mac

Please use the Contact Form if you have questions.

All the calculators are built in Microsoft Excel spreadsheet. You need to have Microsoft Excel 2010 & above and Microsoft Windows to use them.


All the Calculators are built for residential rental properties. Using any calculator from Negative Gearing Calculator for commercial property investment (e.g. retail shop, office etc) is at your own risk. All the information and calculators are for general information and education purposes only. Neither Negative Gearing Calculator nor our partners should be liable for any direct or consequential loss or damages arising to you or any third parties as a result of relying on the information or calculators provided on this website.

By using this website (including downloading or purchasing calculator from this website), you agree to our Terms & Conditions. If you do not agree with our Terms & Conditions, please DO NOT use this website and DO NOT download or purchase calculator from this website.