Suppose you wish to retire forty years from today. You determined that oyu need $50,000 per year once you retire, with the first retirement funds withdrawn one year from the day you retire. You estimate that you will earn 6% per year on your retirement funds and that you will need funds up to and including your 25th birthday after retirement (a total of 25 withdrawals).

a) How much must you deposit in an account today (lump sum), so that you have enough funds for retirement?

b) If you cannot afford to make a single deposit, today, to support your retirement. How much must you deposit each year in an account, starting one year from today (annuity), so that you have enough funds for retirement?

c) How much must you deposit each year in an account, starting today, so that you have enough funds for retirement?

d) After your 20th withdrawal, how much will be left in the account?

please show work on either finance calculator or excel functions.