needs to be done on excel

1. You have just turned 30 years old, you finished a two year graduate program in finance and have accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows:--Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your sixty-fifth birthday. After that point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65. You estimate that to live comfortably in retirement, you will need $100,000 per year starting at the end of the first year of retirement and ending on your 100th birthday. You will contribute the same amount to the plan at the end of every year that you work. How much do you need to contribute each year to fund your retirement? Use an excel function and also workout with formulas as a way to check your results. Once you finished, briefly describe what was your train of thought for solving this problem. Show an amortization table. Note: The amortization table can be divided into two parts: one where deposits are made (payments are positive) and the other where withdrawals are made (payments are negative). At the end, the balance should be zero as in any amortization table. This problem combines two familiar problems into one. mimic the S&P 500 1. You have just turned 30 years old, you finished a two year graduate program in finance and have accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows:--Every dollar in the plan earns 7% per year. You cannot make withdrawals until you retire on your sixty-fifth birthday. After that point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65. You estimate that to live comfortably in retirement, you will need $100,000 per year starting at the end of the first year of retirement and ending on your 100th birthday. You will contribute the same amount to the plan at the end of every year that you work. How much do you need to contribute each year to fund your retirement? Use an excel function and also workout with formulas as a way to check your results. Once you finished, briefly describe what was your train of thought for solving this problem. Show an amortization table. Note: The amortization table can be divided into two parts: one where deposits are made (payments are positive) and the other where withdrawals are made (payments are negative). At the end, the balance should be zero as in any amortization table. This problem combines two familiar problems into one. mimic the S&P 500