Challenge #362: Capital Gains Tax when Selling a Home

[AYXAcademy]

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). 

Your challenge is to answer two questions: 

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. 

• Source: https://www.homelight.com/blog/tax-write-offs-for-sellers/#:~:text=Page%209%20of%20IRS%20Publication... 

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

[benjimoser]

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

Spoiler

[mmontgomery]

Watch that overage!

Spoiler

[Flo_P]

Spoiler

Includes the automatic transformation of the tax rates input

[Luke_C]

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

[Kenda]

Spoiler

[Kenda]

@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. 

[acarter881]

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

[dougbaron]

Spoiler

[samihamaipady]

My Answer