Free Excel templates

A free net investment income tax calculator in Excel

Form 8960 (2025) line by line: investment income, properly allocable deductions, MAGI over the threshold of your filing status, the smaller of the two and the 3.8% tax. For individuals, estates and trusts.

The example is a joint return with modified adjusted gross income of $410,000. Interest of $8,000, dividends of $22,000, passive net rental income of $30,000 and a net capital gain of $41,000 give total investment income of $101,000; state income tax of $6,000 allocated to that income leaves net investment income of $95,000. MAGI exceeds the $250,000 threshold by $160,000, so net investment income is the smaller amount and the tax is $3,610.00. Replace the blue cells with your own figures.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Net_Investment_Income_Tax_Calculator.xlsx (10 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

The calculator is the lesser-of computation of The Net Investment Income Tax Handbook. The book follows one household through a 2025 Form 8960: an S corporation the owner works in, a self-rental building, duplexes, self-charged interest and a sale of S corporation stock adjusted on line 5c, then trusts on lines 18a to 21.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Two tabs. Blue cells are inputs; every result is a formula, and each tab ends with check rows.

Calculator
Filing status, then lines 1 to 8 of Form 8960 (interest, dividends, annuities, rents and pass-through income with the line 4b adjustment, gains with lines 5b and 5c, line 6 and line 7), lines 9a to 11 for the properly allocable deductions, and lines 12 to 17: net investment income, MAGI, the threshold, the excess, the smaller amount and the tax.
Estate or trust
Lines 18a to 21: net investment income, the deduction for distributions, undistributed net investment income, adjusted gross income under section 67(e), the amount at which the highest bracket begins ($15,650 for 2025), the smaller amount and the tax.

Three things to try

Change the filing status. Single or head of household moves the threshold to $200,000; married filing separately moves it to $125,000. The thresholds are set by section 1411(b) and are not indexed for inflation.

Lower MAGI. Bring MAGI down until the excess over the threshold falls below net investment income: from that point line 16 takes the excess, and the tax follows MAGI rather than the investment income.

Enter a line 4b adjustment. If the rent in line 4a came from a building leased to a company you work in, the self-rental rule can remove it on line 4b. Enter it as a negative figure and watch line 12 fall.

Questions

What does the calculator return for the example?

Total investment income of $101,000, net investment income of $95,000, MAGI over the threshold of $160,000, and a tax of $3,610.00. On the trust tab, the example trust owes $773.30.

Does it say whether an item is net investment income?

No. Whether a business is passive for you, whether rent is derived in a trade or business, and how a sale of S corporation stock is adjusted are readings of the facts that belong to a CPA. The calculator does the arithmetic once that reading is made.

Does it compute the regular income tax?

No. It stops where Form 8960 stops, at the 3.8% tax carried to Schedule 2 of Form 1040.

Related reading