Overview

This basic investment property 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.

Here is a screenshot that will give you a better idea that what you need to do and what this basic Investment Property Calculator can do for you.

Things You Need to Know

Please note that this basic 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 Investment Property Calculator or the Professional Investment Property Calculator for a value-for-money price for your personal use.

If you are unsure if the Basic Investment Property Calculator suits your needs best, please click the button below for a detailed comparison across the Basic version, Standard version, Professional version, and Ultimate version:

Help me to choose the right Investment Property Calculator

This calculator is built in Microsoft Excel worksheet. You need to have Microsoft Excel® 2007 & Above for Microsoft Windows® OR Microsoft Excel 2011 & Above for Mac® to use it.

All the calculators (paid and free ones) on this website are password protected. If you need the unprotected version of any calculator a fee will apply. The advantage of the unprotected version is that you can freely edit the tool without any limit although we still own the copyright of the unprotected calculator. Please note you cannot re-distribute our calculators without a written approval from us even for the ones with your modification or customization. In addition we are not going to provide any support on unprotected calculators with any modification or customization.

You might want to check out the Free Mortgage Home Loan Repayments Calculator and the Free Mortgage Home Loan Amortization Calculator. They should be useful for your property investment.

Important Assumptions

Please note: All the investment property calculators (Basic 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 Basic Investment Property Calculator

Sole investor or just one investor? You can use this Basic Investment Property Calculator by changing the "Deductions Investor 1 (%)" to 100% and the "Annual Gross Income Investor 2" to $0. Alternatively, you can download the even simpler Basic Investment Property Calculator for One Investor!

If you consider buying an investment property through self-managed super fund (SMSF), you may want to try the Free SMSF Investment Property Calculator.