Your client turned 22 years old today and expects to start working today. Your client expects to be paid once a year, at the end of each year. Your client expects to be paid $50,000 at the end of the first year and for this amount to grow each year by five percent. Your client expects to earn eight percent per year on all investments forever. Your clients pays a Social Security tax of 6.2% on all income at or below the Social Security taxable income limit. If your clients income is above the threshold then your clients tax is capped, i.e., your client would pay 6.2% of the threshold. The current Social Security taxable income limit is $160,200 and this threshold is expected to grow by 4% each year forever. Your client can either retire at 62, 65, or 70 years. Once your client retires, this individual expects to receive Social Security disbursements once per year, with the first payment one year after the retirement date, and continuing in annual increments. So, if an individual retires at 62, the first Social Security disbursement would be at 63. Today, Social Security paid $13,236 to individuals that retired at 62 years of age, $16,809.72 to individuals that retired at 65 years of age, and $23,427.72 to individuals that retired at 70 years of age. In one year, these disbursements will be $13,765.44 to individuals that retired at 62 years of age, $17,482.11 to individuals that retired at 65 years of age, and $24,364.83 to individuals that retired at 70 years of age. After one year, these disbursements are expected to continue to grow each year by four percent forever. You should assume that your client receives a salary in the year your client retires and starts receiving social security one year after the retirement date. NEED FULL EXCELL WORK SHOWING FORMULA HOW DO I PUT IT IN EXCEL