Negative Gearing Calculator

A negative gearing calculator can help demonstrate why investment decisions should never be driven solely by tax considerations, even though income tax and capital gains taxes form a significant component of investment performance.

This is especially so when an investment is financed by a loan, with the increase in risk that that involves. Hence the importance of measuring the tax and cash flow outcomes of investment decisions.

Despite the offsetting tax benefits, negative gearing has never been the automatic road to riches some would have us believe. And since the more volatile investment markets in recent years, inflation doesn’t so easily hide investment mistakes any more; there’s much less room for error.

Smart investing is all about the balancing of risk and return. When you make an investment, you are guessing the future returns, with a risk of getting it wrong.

Sponsored link

Simple spreadsheet negative gearing calculator – cut to the chase

Investment proposals which have a loan element can be compared by entering different sets of assumptions into the negative gearing calculator spreadsheet, to project results. Risk and return assumptions can be manipulated to find a level of comfort, before spending hard-earned dollars.

This is a smart back-of the-envelope decision tool, useful as a fast guide to the financial arithmetic involved in a geared investment decision, where we assume that the investment costs are tax deductible.

The spreadsheet is deliberately simple, so that the cause, effect and projected results can be very clearly understood, without clouding the issue with technical fine tuning, or minute analysis of arcane tax provisions which don’t have a major impact on the outcome.

And you see the full picture is captured on a single page.

This spreadsheet can be useful to evaluate the effect of any tax-effective leveraged investment, such as shares, property, rental property etc.

  • The calculator assumes you have a reasonably well-informed idea of income and expense profiles, and prefer a fast-but-good estimate over a slow-but-highly-accurate kind of analysis.
  • The spreadsheet is basically a single investor, single investment model
  • it works on currently legislated tax rates, and doesn’t take into account future tax changes or changing inflation levels
  • the effect of CGT is simplified by entering a single percentage rate assumption; there is no detailed breakdown of potential CGT outcomes.
  • loan funding is factored on an interest-only basis

For advisors, the simple one-page colour report which can be handed to a client or filed as a working paper.

This simple Negative Gearing Spreadsheet calculator is a convenient way to assess risk and return, because all the important assumptions can be entered quickly. Loan funding can be easily manipulated to estimate outcomes – positive, neutral or negative.

The calculator is uses current tax rates which apply to 30 June 2022. 

The spreadsheet is built in MS Excel versions 1997-2003 or later, PC/Windows versions.

Calculator download

Get the spreadsheet Negative Gearing Calculator here ($5.97)

Buy Now Button

Immediate download: On completion of your payment your browser will be sent to a download link, and an email containing the link will be sent to your payment address. Any problems please contact us here for prompt attention.


More about negative gearing



This page was last modified 2019-07-04