I need hand writing detalied calculations as well.
Th is assignment involves developing a spreadsheet to determine how much will need to be deposited into an account to meet retirement income objectives. Create an input sheet that will input the following information. Current salary Money desired per year if retirement took place now Rate of salary growth as a decimal (ie, .025 for 2.5%/yr) Rate of inflation per year as a decimal Rate of investment growth as a decimal D10 D11 D12 D13 D14 On a second sheet, solve parts A-D. This assignment will assume that you will work for 40 years, and are retired for 25 years. The first retirement withdrawal will be at the end of year 41. Deposits will be made at the end of each year from years 1-40. Withdrawals need to increase at the rate of inflation. Part A. Determine the annual deposit required for years 1-40 if each deposit is the same Complete the following table for years 1 through 65 Yr Beg Balance Interest Deposit Withdrawal Salary% Salary End Balance Part B. Determine the annual deposit required for years 1 - 40 if the amount deposited each year will increase at the same rate as the increase in salary. Complete a second table with the same columns as in part a. Part C. Assume that the salary annual salary growth rate, the annual inflation rate, and the annual investment rate are now normally distributed random variables, with a mean as given and a standard deviation equal to 1 5% of the mean. These variables will now change each year. Redo part A. Determine how much extra will be needed to deposit each year to be 90% sure you will meet your retirement objective. Complete a new table for this part Part E. Using the same random variables as in part C, determine the % of salary necessary to be 90% sure you will meet the objective in cell D11 for the Part B assumption of the deposit being the same % of salary each year. Complete a new table for this part The information in cells D10-D14 will be put into the spreadsheet only once and will need to carry through to the second sheet. Use only two sheets. This assignment is to be done using Excel functions. No macros are allowed. Use of Solver/Goal Seek is not allowed. Th is assignment involves developing a spreadsheet to determine how much will need to be deposited into an account to meet retirement income objectives. Create an input sheet that will input the following information. Current salary Money desired per year if retirement took place now Rate of salary growth as a decimal (ie, .025 for 2.5%/yr) Rate of inflation per year as a decimal Rate of investment growth as a decimal D10 D11 D12 D13 D14 On a second sheet, solve parts A-D. This assignment will assume that you will work for 40 years, and are retired for 25 years. The first retirement withdrawal will be at the end of year 41. Deposits will be made at the end of each year from years 1-40. Withdrawals need to increase at the rate of inflation. Part A. Determine the annual deposit required for years 1-40 if each deposit is the same Complete the following table for years 1 through 65 Yr Beg Balance Interest Deposit Withdrawal Salary% Salary End Balance Part B. Determine the annual deposit required for years 1 - 40 if the amount deposited each year will increase at the same rate as the increase in salary. Complete a second table with the same columns as in part a. Part C. Assume that the salary annual salary growth rate, the annual inflation rate, and the annual investment rate are now normally distributed random variables, with a mean as given and a standard deviation equal to 1 5% of the mean. These variables will now change each year. Redo part A. Determine how much extra will be needed to deposit each year to be 90% sure you will meet your retirement objective. Complete a new table for this part Part E. Using the same random variables as in part C, determine the % of salary necessary to be 90% sure you will meet the objective in cell D11 for the Part B assumption of the deposit being the same % of salary each year. Complete a new table for this part The information in cells D10-D14 will be put into the spreadsheet only once and will need to carry through to the second sheet. Use only two sheets. This assignment is to be done using Excel functions. No macros are allowed. Use of Solver/Goal Seek is not allowed
