NEED ASAP PLEASE

Assume Graduation Age is 20

Determine your age at graduation. After graduation, you will be offered a position making $ 57,000 per year. The company you will work for offers a 401k where the company matches your contribution to this plan of 4% per year at 75%. You will contribute 3 percent per year. What this means is for each dollar you put in, the company will match it with 75 cents. For the purpose of this assignment, you will not receive a raise between graduation day and retirement. 1. You must build a spreadsheet using formulas to show how much you will contribute on a biweekly basis, and how much your employer will contribute. You need to calculate quarterly contributions once you determine the biweekly amount. Label this sheet of the workbook Investment. You must assume you will be contributing this amount until you turn 65 years of age, the growth on your account will 6% over your working life, and growth is applied to your account on a quarterly basis. In the spreadsheet, you must develop multiple formulas from financial functions relating to present value and future value to show the following: 65th How much will be in your account on your birthday How much cash you contributed to this balance How much cash your employer contributed to this balance How much cash was earned from your investment