need 7&8 done on excel using TVM functions

6) What is the present value of twenty (20) anmial payments of $9,000, starting today if the interest rate is 4% * The Nixon administration felt that 70 cents was too high and routinely threatened McDonalds using the Federal Price Commission 7) Consider an investment which pays $29,000 at the end of year 1, year 2, and year 3. In year 4, the investment will pay $90,000 and this payment will grow by 1% cach year forever. If the appropriate interest rate is 6%, what is this investment worth today? 8) You plan on retiring in 40 years. You will open a retirement account today with an initial deposit of $3000. You will then begin saving in 40 equal annual payments starting at the end of the first year (starting at tol) with the last deposit being made at retirement, at t-40. Additionally, your employer will pay you a bonus of $50,000 at year t-20 rewarding your 20 years of service, you will put this bonus into your retirement account. Additionally, you want to take a vacation to Hawaii at year t-15, which will cost you $10,000 and come from your retirement account as an early withdrawal. At retirement you would like to make 30 withdrawals of $150,000 per year for the next 30 years starting at 141 Finally, at the end of your 30 year retirement (t-70), you would like to donate $10,000,000 to your alma mater so that they will name a door on a classroom for you. If your retirement account will pay you 6% interest per year, what do your annual deposits into the account need to be