alteryx Community

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

Challenge #362: Capital Gains Tax when Selling a Home

Alteryx

A solution to last week’s challenge can be found here.

To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.

If you are currently selling your home, you may not be happy to learn that capital gains (profit from the sale of the home) are taxable in the United States. One way to reduce the amount of capital gains taxes you pay is to use deductions.

For this challenge, we will use two possible deductions, the Exclusion of Gain (you may qualify to exclude up to \$250,000 of the capital gain from your income as a single filer, or up to \$500,000 of that gain if you file a joint return with your spouse); and Capital Improvements (when home sale profits exceed the exclusion of gain threshold, consider deducting any capital improvements you made to the home while you owned it).

1. Identify which home sellers will have to pay taxes on the profit made from the sale of their home.
2. Determine how much those sellers have to pay.

Use the information below to calculate and determine who should pay taxes.

DISCLAIMER: This challenge is meant for educational purposes only and is not intended to be construed as financial, tax, or legal advice.

9 - Comet

My Solution. But would the "overage" not only be the part of the "capital gain" which is above the "exclusion of gains" value?

Spoiler

11 - Bolide

Watch that overage!

Spoiler

9 - Comet
Spoiler
Includes the automatic transformation of the tax rates input

17 - Castor

I don't think the gain exclusion is included in the solution (though speaking as a CPA there's not enough information to say if it technically should be 😂).

Spoiler

16 - Nebula
Spoiler

16 - Nebula

@Luke_C I thought the same thing at first after reading just the directions. If you look at the image included in the workflow, though, it suggests a bit of a different calculation.

12 - Quasar

Here's my solution. I tested my multi-row formula that allocates the percentage to pay with varying amounts. I believe that isn't the intention of the challenge, but it is a bit more dynamic as a result.

Spoiler

8 - Asteroid
Spoiler

7 - Meteor