ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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.

SUBMIT YOUR IDEA

Challenge #362: Capital Gains Tax when Selling a Home

mattbov92
8 - Asteroid

Spoiler

Louie-Horn
7 - Meteor
Spoiler
Screenshot 2025-05-27 155701.png

Erin
11 - Bolide

I admit, I had to get help from the posted solution for this. Taxes are hard.

Spoiler
362.png
mkeiffer
11 - Bolide
11 - Bolide

Here is my solution! 

Alesson_Oliveira
8 - Asteroid

my solution

Spoiler
Alesson_Oliveira_0-1752856622959.png

 

Salum0405
8 - Asteroid

Here's my solution

Spoiler
Salum0405_0-1753899250209.png

 

Will_Condon
8 - Asteroid

I'm not paying the solution amounts because they do not subtract the exclusion of Gains ($250k or $500k) from the taxable figure.  My accountant came up with a way to save on taxes.  I have Janet and Jerry White paying $136,000. Tell me where I went wrong.

 

If ever there is a reason to use a spreadsheet for this calculation, this is it.

 

Workflow:

Spoiler
Challenge 362 Solution WC Spoiler.jpg

 

Nicholas_14
8 - Asteroid


This is what I came up with; there's definitely a more efficient way to do this.

 

Nicholas_14_0-1758967407799.png

 

calvingao
7 - Meteor

Challenge 362 Solution (Not accounting for exclusions)

aiahwieder
9 - Comet

It has been a solid decade since my Individual Tax class, but I am solidly certain that the taxable portion of the capital gains is the amount in excess of the exclusion.

 

Nonetheless, a solid puzzle!