: What is the taxpayer's gross income in each of the following situations?

Darrin received a salary of $50,000 in 2017 from his employer, Green Construction.
In July 2017, Green gave Darrin an all-expenses-paid trip to Las Vegas (value of $3,000) for exceeding his sales quota.
Megan received $10,000 from her employer to help her pay medical expenses not covered by insurance.
Blake received $15,000 from his deceased wife's employer "to help him in his time of greatest need."
Clint collected $50,000 as the beneficiary of a group term life insurance policy when his wife died. The premiums on the policy were paid by his deceased wife's employer.
Peggy won $4,000 in the state lottery.

Part 2: Sally was an all-state soccer player during her junior and senior years in high school. She accepted an athletic scholarship from State University. The scholarship provided the following:

Tuition and fees $15,000
Housing and meals 6,000
Books and supplies 1,500
Transportation 1,200
Determine the effect of the scholarship on Sally's gross income.
Sally's brother, Willy, was not a gifted athlete, but he received $8,000 from their father's employer as a scholarship during the year. The employer grants the children of all executives a scholarship equal to one-half of annual tuition, fees, books, and supplies. Willy also received a $6,000 scholarship (to be used for tuition) as the winner of an essay contest related to bioengineering, his intended field of study.

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 your 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 for grading.

Review the grading rubric to understand how you will be graded on this assignment. Reach out to your instructor if you have questions about the assignment.