Response to the following problem:
Part 1: Determine the taxpayer's current-year (1) economic income and (2) gross income for tax purposes from the following events:
Curtis, age 18, has income as follows: $700 interest from a certificate of deposit and $6,000 from repairing cars.
Mattie, age 18, has income as follows: $600 cash dividends from a stock investment and $4,700 from handling a paper route.
Mel, age 16, has income as follows: $800 interest on a bank savings account and $700 for painting a neighbor's fence.
Lucy, age 15, has income as follows: $400 cash dividends from a stock investment and $500 from grooming pets.
Sarah, age 67 and a widow, has income as follows: $500 from a bank savings account and $3,200 from babysitting.
Part 2: or each of the following, determine the amount that should be included in gross income:
Peyton was selected the most valuable player in the Super Bowl. In recognition of this, he was awarded an automobile with a value of $60,000. Peyton did not need the automobile, so he asked that the title be put in his parents' names.
Jacob was awarded the Nobel Peace Prize. When he was presented the check for $1.4 million, Jacob said, "I do not need the money. Give it to the United Nations to use toward the goal of world peace."
c. Linda won the Craig County Fair beauty pageant. She received a $10,000 scholarship that paid her $6,000 for tuition and $4,000 for meals and housing for the academic year.
Requirements:
Clearly identify the requirements being addressed. Show all calculations within the cells of the provided Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file .