please do this in excel!

1. You plan to start saving for your retirement next year. You will save $5,000 for the 40 years you will be working. When you retire, you want to withdraw and equal amount of money each year starting in year 41 and continuing for 30 years (years 41 to 70 ). If the interest rate is 8%, how much will be able to withdraw in equal amomts for the 30 years you are retired? 2. Redo problem 1 assuming that once you retire you will adju: uur portfolio so you now hold more bonds, which pay a lower rate of interest. You'll still earn 8% for the 40 years you are working, but only 5% per year for the 30 years you are retired