Consider the four independent situations below for an unmarried individual, and analyze the effects of the capital gains and losses on the individual's AGI.

Situation 1 Situation 2 Situation 3 Situation 4
AGI excluding property transactions 40000 50000 60000 70000
STCG 6000 2000 5000 6000
STCL 2000 5000 4000 15000
LTCG 3500 15000 10000 9000
LTCL 2500 4000 12000 4000

For each case, determine the net short-term capital gain (NSTCG) or net short-term capital loss (NSTCL), the net long-term capital gain (NLTCG) or net long-term capital loss (NLTCL), and then the AGI after considering the capital gains and losses