Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Finance Calculators / Free Excluded Value Calculator – Determine Taxable Amount
Percentage Calculators

Free Excluded Value Calculator – Determine Taxable Amount

Published onSeptember 27, 2025 Updated onNovember 3, 2026 11:10 am

How much of a total is carved out, and how much is left? Enter the total value and the excluded percentage to get the excluded amount and the remaining value, or flip the mode: enter the excluded amount and the total to find the exclusion percentage. The same split runs through tax exclusions, insurance carve-outs and budget set-asides, and this tool does the arithmetic for all of them without deciding whether any exclusion legally applies to you.

Excluded Value Calculator
The excluded amount, the remaining value, and the percentage, both ways

Arithmetic only: it does not determine whether an exclusion legally applies. Tax treatment depends on your jurisdiction and the specific rule.

Quick Answer

On a total of $500,000 with a 20% exclusion, the excluded value is $100,000.00 and the remaining value is $400,000.00. Run it the other way and the same split reads as a percentage: $100,000 excluded from $500,000 is a 20.00% exclusion.

$250,000
US home-sale gain exclusion, single filer, if the ownership and use tests are met
$500,000
US home-sale gain exclusion, married filing jointly, same tests
Up to 100%
Of gain on qualified small business stock under Section 1202, within its caps and holding rules
$130,000
Foreign earned income exclusion ceiling for 2025, before the housing amount

Key takeaways

  • Every exclusion is the same split: excluded plus remaining always equals the total. If your two numbers do not add back up, one of them is wrong.
  • The tool runs both directions, because real questions arrive both ways: a rule states a percentage, or a statement shows an amount and you need its percentage.
  • An exclusion is not a deduction and not a credit. It keeps income out of the tax base entirely, which is why the remaining value, not the tax saved, is the number this tool returns. For the deduction side of a bill, the deduction percentage calculator covers that split.
  • The arithmetic never decides eligibility. Caps, holding periods and ownership tests sit in the rule itself, and several of them are in the table below.
On this page
  • Quick Answer
  • How to use the excluded value calculator
  • The excluded value formulas
  • Worked example: $500,000 with a 20% exclusion
  • Where exclusions show up in real rules
  • The stacking caveat: excluded income can still set your rates
  • What this calculator covers, and why each part matters
  • Frequently asked questions
  • Add This Calculator to Your Website
  • References

How to use the excluded value calculator

Choose a mode, enter two numbers, then click Calculate. The results stay hidden until you do.

  1. Excluded value from percentage: enter the total value and the excluded percentage. The tool returns the excluded amount and the remaining value in dollars.
  2. Exclusion percentage from values: the second field changes its label to Excluded amount. Enter the total and the amount that was carved out, and the tool returns the exclusion percentage plus the remaining value.
  3. Read the split bar: amber is the excluded share of the total, dark is what remains. The two shares always sum to the whole total.

Validation is strict in the ways that matter: the total must be greater than zero, a percentage must sit between 0 and 100, and an excluded amount cannot exceed its total. Each failure names the field and the problem instead of returning a silent wrong answer.

The excluded value formulas

Two formulas cover both modes, and each is the other one rearranged.

Excluded = Total × Percent ÷ 100
Remaining = Total − Excluded
Percent = Excluded ÷ Total × 100

That is the whole method, and it is worth naming what it is not. This tool computes the general exclusion split used across tax, insurance and budgeting. It does not compute the annuity exclusion ratio, which divides your investment in the contract by the expected return to set a non-taxable share of each payment, and it does not apply any specific tax rule. Where a term has a specialised meaning in one field, the sections below say so rather than letting the simple formula borrow authority it has not earned.

Worked example: $500,000 with a 20% exclusion

A gain of $500,000 faces a 20% exclusion. Here is the full run, exactly as the tool performs it:

1. Excluded: $500,000 × 20% = $100,000→
2. Remaining: $500,000 − $100,000 = $400,000→
3. Reverse check: $100,000 ÷ $500,000 = 20.00%
Check runExcludedRemaining / Percentage
$250,000 at 12.5%$31,250.00$218,750.00 remaining
$999.99 at 33.33%$333.30$666.69 remaining
Percentage mode: $75 excluded from $30025.00%$225.00 remaining
Percentage mode: $111.11 excluded from $888.8812.50%$777.77 remaining

Each row is a real run of this calculator. The second row is the honest one to study: 33.33% of $999.99 is $333.2966 before rounding, and the tool rounds the excluded and remaining figures independently to cents, so the pair still sums to the total.

Where exclusions show up in real rules

The same split appears in very different rules, each with its own cap and conditions. The tool supplies the arithmetic for any of them; the conditions are yours to check.

ContextWhat is excludedThe limit that decides the split
Home sale (US, Section 121)Gain on a primary residenceUp to $250,000, or $500,000 married filing jointly, with ownership and use tests over the five years before the sale
Qualified small business stock (Section 1202)Gain on qualifying stock held more than five yearsUp to 100% of the gain, subject to per-issuer caps; stock acquired in different years can carry different exclusion percentages
Foreign earned income (Section 911)Foreign earned income of qualifying US taxpayers abroadAn annual ceiling, $130,000 for 2025, prorated for part-year qualification, plus a separate housing amount
Insurance policiesLosses from excluded perils or excluded propertyNo percentage cap in the arithmetic; the policy wording decides what sits outside coverage, and the split shows how much of a loss stays with you
Budgets and datasetsEarmarked funds set aside, or records filtered out of a totalYour own rule: the percentage mode reports the excluded share, which is the figure audits and screening reports usually ask for

One related figure is worth separating while you are here: when a fund pays out a distribution that is partly a return of capital, the taxable and non-taxable shares follow their own reporting, and the capital gains distribution calculator handles that case directly.

The stacking caveat: excluded income can still set your rates

Excluding income does not always lower your tax the way the subtraction suggests. Under the foreign earned income exclusion, the remaining income is taxed at the rates that would have applied if the excluded income were still in the pile: the exclusion removes dollars from the base but not from the rate calculation. The IRS calls this the tax computation worksheet approach, and it means the remaining value this tool returns is the right base figure, while the tax on it can be higher than a naive bracket reading implies.

The practical lesson generalises beyond that one rule. Run this split first to get the excluded and remaining amounts right, then run the actual worksheet for your rule before treating the difference as savings. A discount works the same way in miniature: the share taken off a price is this same percentage split, which is why the discount percent calculator and this page return matching numbers on matching inputs.

What this calculator covers, and why each part matters

This calculator runs the exclusion split in both directions, always shows the remaining value next to the excluded figure, and keeps the real caps and caveats on the same page as the number they qualify.

  • Both directions in one tool. A rule states a percentage, or a statement shows an amount and you need its percentage – real questions arrive both ways. On a total of $500,000 with a 20% exclusion, the excluded value is $100,000.00 and the remaining value is $400,000.00. Run it the other way and the same split reads as a percentage: $100,000 excluded from $500,000 is a 20.00% exclusion.
  • Every exclusion is the same split. Excluded plus remaining always equals the total. If your two numbers do not add back up, one of them is wrong. The split is drawn as a bar, so the two parts and the whole are visible at once.
  • An exclusion is not a deduction and not a credit. It keeps income out of the tax base entirely, which is why the remaining value, not the tax saved, is the number this tool returns. The result is a base figure, not a tax saving.
  • Do not confuse this with the annuity exclusion ratio. That is a different calculation wearing a similar name: it divides investment in the contract by expected return to split each payment into taxable and non-taxable parts. Correct for annuities, wrong as a general exclusion tool.
  • The real caps, on the same page as the number they qualify. $250,000 US home-sale gain exclusion, single filer, if the ownership and use tests are met; $500,000 married filing jointly, same tests. Up to 100% of gain on qualified small business stock under Section 1202, within its caps and holding rules. $130,000 foreign earned income exclusion ceiling for 2025, before the housing amount.
  • The stacking caveat. Excluded income can still set your rates – the exclusion changes the base, and the remaining figure still sits inside the rate structure. This tool does not give tax advice.

Frequently asked questions

Multiply the total by the exclusion percentage and divide by 100. On a total of $500,000 with a 20 percent exclusion, the excluded value is $500,000 times 20 divided by 100, which is $100,000. The remaining value is the total minus the excluded value, $400,000.

Divide the excluded amount by the total and multiply by 100. An excluded amount of $100,000 on a total of $500,000 gives 20 percent. Use the second mode of this calculator, enter the total and the excluded amount, and it returns the percentage and the remaining value together.

The remaining value is whatever is left of the total once the excluded part is carved out: total minus excluded. It is the figure the rest of the calculation works on, for example the taxable part of a gain or the spendable part of a budget after a set-aside.

A tax exclusion is an amount the tax code lets you leave out of taxable income entirely, rather than deducting it later or crediting it against tax. Common examples are part of the gain on a home sale, foreign earned income up to an annual ceiling, and gain on qualified small business stock. This calculator does the split; whether an exclusion applies to you is set by the rule itself.

No. An exclusion is a share of a total, so it runs from 0 to 100 percent, and the excluded amount cannot exceed the total it is carved from. This calculator rejects a percentage above 100 and an excluded amount larger than the total, because both would leave a negative remainder.

Not always in the way you would expect. Some rules, including the foreign earned income exclusion, tax the remaining income at the rates that would have applied if the excluded income were still included, a method often called stacking. The remaining value is still the right base figure, but the tax on it can be higher than a simple bracket reading suggests, so check the worksheet for your rule.

In the US, a qualifying sale of a primary residence can exclude up to $250,000 of gain, or $500,000 for a married couple filing jointly, under Section 121. You generally must have owned and used the home for at least two of the five years before the sale. Enter your gain as the total here, and the excluded share shows what stays taxable.

Section 1202 lets eligible shareholders exclude a large share, up to 100 percent for qualifying stock, of the gain on qualified small business stock held for more than five years, subject to per-issuer caps and acquisition-date rules. Compute the excluded and remaining gain here once you know the percentage your shares qualify for.

No. The annuity exclusion ratio divides your investment in the contract by the expected return, and uses that ratio to split each annuity payment into a non-taxable return of your money and a taxable part. This calculator performs the general exclusion split, a percentage or amount carved out of a total, which is a different calculation that happens to share vocabulary.

No. It performs arithmetic only and cannot determine whether an exclusion applies to your situation, which cap governs it, or how your jurisdiction treats it. Use the result as the base figure for the actual rule, worksheet or adviser conversation that decides your case.

Add This Calculator to Your Website

Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. Internal Revenue Service. Topic No. 701, Sale of Your Home. Accessed October 21, 2026.
  2. Internal Revenue Service. Publication 523, Selling Your Home. Accessed October 21, 2026.
  3. Internal Revenue Service. Foreign Earned Income Exclusion. Accessed October 21, 2026.
  4. Internal Revenue Service. Publication 550, Investment Income and Expenses (capital gains and Section 1202). Accessed October 21, 2026.
  5. Internal Revenue Service. Publication 575, Pension and Annuity Income (exclusion ratio method). Accessed October 21, 2026.
  6. Internal Revenue Service. Topic No. 409, Capital Gains and Losses. Accessed October 21, 2026.
  7. Cornell Law Institute, Legal Information Institute. 26 U.S. Code Section 121, Exclusion of gain from sale of principal residence. Accessed October 21, 2026.
  8. Cornell Law Institute, Legal Information Institute. 26 U.S. Code Section 1202, Partial exclusion for gain from certain small business stock. Accessed October 21, 2026.
  9. Cornell Law Institute, Legal Information Institute. 26 U.S. Code Section 911, Citizens or residents of the United States living abroad. Accessed October 21, 2026.
  10. Internal Revenue Service. Frequently asked questions on gift taxes (annual exclusion). Accessed October 21, 2026.

Related calculators

Percentage CalculatorsReduction Percentage CalculatorA price drops from $500 to $350. A project timeline shrinks from 40 days to 28.Percentage CalculatorsPercent Less CalculatorWork a percentage decrease in either direction.Percentage CalculatorsAverage of Percentages CalculatorAveraging percentages looks trivial until the groups behind them are different sizes.Percentage CalculatorsBPS CalculatorBasis points are finance's way of talking about small changes without tripping over decimals.Percentage CalculatorsPercent Growth CalculatorPercent growth answers one clean question: by what percentage did a value change between a starting point and an ending point?Percentage CalculatorsReverse Percentage CalculatorThree different questions hide behind the phrase "reverse percentage", and answering the wrong one gives a wrong number.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search