PLEASE MAKE 3 TABLES, ONE IF DEPOSITS ARE MADE AT BEGINING OF THE YEAR AND ONE IF MADE AT THE END OF THE YEAR AND ONE IF

PART 2: Don anticipates retiring at the end of the 35th year (time 36), and he would like to be getting a quarterly payment (a withdrawal) out of his retirement fund. Starting when he retires, how much will this quarterly payment be if he plans to withdraw the funds over a 30-year period?

[Remember you need to calculate and use a nominal interest rate with quarterly compounding here!]

Using the withdrawal, you calculated in add to this table to show the withdrawals, the interest earned each quarter, and the total amount in the retirement fund until the end of the 30 years of withdrawals.

PART 1:

Don Harrison's current salary is $60,000 per year, and he is planning retirement 35 years from now. He anticipates that his annual salary will increase by $2000 each year (first year: $60,000; second year: $62,000, third year: $64,000; and so on...) and he plans to make an annual deposit in the amount of 8% of his yearly salary into a retirement fund that earns 5.5 % interest (annual) compounded monthly. Assume he deposits at the beginning of each year, starting now and including the last year, year 35. 1. Create a table that shows Don Harrison's salary for each year, his cashflow (the annual deposit) into the retirement fund, the interest earned each year in the retirement fund, and the total in the retirement fund. What will be the amount accumulated at the time of his retirement