To better understand the rules for offsetting capital losses and how to treat capital losses carried forward, analyze the following data for an unmarried individual for the period 2007 through 2010. No capital loss carry forwards are included in the figures.

For each year, determine AGI and the capital losses to be carried forward to later tax year.

Please use the attached Excel spreadsheet.