prepare and submit an Excel spreadsheet. Place the information for John in Sheet 1, Place the information for Jane in Sheet 2. When done, upload the spreadsheet using the provided links. If uncertain that the link worked properly, send a copy to the instructor by email, as a backup.

Sheet 1. John Q. One, a life-long NY resident, earned the minimum wage working for a small employer. He consistently worked 40 hours per week in each year. Assemble the data to compute John's Social Security benefit at when he reaches age 62 on 12/31/2015. This person had no wage income before taking this job in 1971.

• Assuming John continued to work to each identified age (62, FRA, 70), report and show work for his benefits at (1) age 62, (2) FRA, and (3) age 70. Think carefully about age 62 and 70.

Sheet 2. Jane I.S. Two, paid into social security at the maximum taxable amount for each year from the start of her employment in 1980. Assemble the data and compute the social security benefit for a person reaching age 62 in 2015. Ms. Two had no wage income before this job.

• Assuming Jane continued to work to each identified age (62, FRA, 70), report and show work for her benefits at (1) age 62, (2) FRA, and (3) age 70. Think carefully about age 62 and 70.

AID: New York Minimum Wage History

The table below provides the history of New Yorks minimum wage over the years since 1983. New Yorks minimum wage is unique when compared with most other states, the wage differs depending on the location of the business you own or work for. It also depends on the number of the businesss employees. (Source: https://dol.ny.gov/history-minimum-wage-new-york-state (Links to an external site.))

Year	Min. Wage		Year	Min. Wage		Year	Min. Wage		Year	Min. Wage
2022	13.20		2012	7.25		2002	5.15		1992	4.25
2021	12.50		2011	7.25		2001	5.15		1991	4.25
2020	11.80		2010	7.25		2000	5.15		1990	3.80
2019	11.10		2009	7.25		1999	4.25		1989	3.35
2018	10.40		2008	7.15		1998	4.25		1988	3.35
2017	9.70		2007	7.15		1997	4.25		1987	3.35
2016	9.00		2006	6.75		1996	4.25		1986	3.35
2015	8.75		2005	6.00		1995	4.25		1985	3.35
2014	8.00		2004	5.15		1994	4.25		1984	3.35
2013	7.25		2003	5.15		1993	4.25		1983	3.35