I need a USA tutor who is aware of Retirement planning and employee benefits.
Caidenindividualretire-fin753.xls
Sheet1
PLANNING FOR RETIREMENT NEEDS | ||||||||||
Retirement Planning Project | ||||||||||
Name: | UJJAL DAS | |||||||||
ID: | S0260492 | |||||||||
Where a cell is highlighted in yellow, you must set up the relationships--that is, equations or spreadsheet functions--to compute the required value. For instance, you can use the PV function that is built into the spreadsheet to compute present value where it is required, or you can input the appropriate equation to complete the computation. Do not enter values (amounts) in these cells. The computations should be based on information provided in other cells; and, you should refer to the locations of the cells that contain the appropriate information when creating the computational relationships. Instructions as to what needs to be computed in the yellow-highlighted cells are given in the cells highlighted in blue. | ||||||||||
Section I: | Salary Expectations | |||||||||
Period (Years) After Starting Your Career | ||||||||||
0- 5 | 6-10 | 11-15 | 16-20 | 21-25 | 26-30 | 31-35 | 36-40 | 41-45 | 46-50 | |
Salary: | ||||||||||
% Change: | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Enter the salaries you expect to earn during each five-year period that is applicable to your career expectations. Then, create the relationship (equation) necessary to compute the percentage change in salary from one period to the next for each five-year period. | ||||||||||
Section II: | Life Expectancy | |||||||||
Current age: | Years to retirement: | 0 | ||||||||
Retirement age: | Years of retirement: | 0 | ||||||||
Life expectancy age: | ||||||||||
Set up the appropriate relationships (equations) to compute the values requested in the cells highlighted in yellow. | ||||||||||
Section III: | Risk Preferences | |||||||||
Percent | ||||||||||
(Weight) | ||||||||||
Bonds (short-term): | ||||||||||
Bonds (bond-term): | ||||||||||
Large company stocks: | ||||||||||
Small company stocks: | ||||||||||
International stocks: | ||||||||||
Total: | 0.00% | If the total is not equal to 100.0%, change the weights until it is. | ||||||||
Section IV: | Retirement Goals | |||||||||
The expected returns for the investments that will be included your retirement fund are: | ||||||||||
Percent | Expected Rate | Portfolio Rate | ||||||||
(Weight) | ||||||||||
Bonds (short-term): | 0.00% | 4.0% | 0.0000% | |||||||
Bonds (bond-term): | 0.00% | 6.0% | 0.0000% | |||||||
Large company stocks: | 0.00% | 12.0% | 0.0000% | |||||||
Small company stocks: | 0.00% | 15.0% | 0.0000% | |||||||
International stocks: | 0.00% | 12.0% | 0.0000% | |||||||
Total: | 0.00% | 0.00 | ||||||||
Set up the relationships required to determine the weighted average expected rate of return for the portfolio. | ||||||||||
A. | Retirement income | |||||||||
Average annual income during retirement--stated in today's dollars: | ||||||||||
Average annual inflation rate during your career: | 0.025 | |||||||||
Years to retirement: | 0 | |||||||||
Average annual income during retirement--stated in inflation-adjusted dollars: | ||||||||||
Set up the relationship required to determine the inflation-adjusted average annual income you wish to receive during your retirement years. You can use the FV function built into the spreadsheet for this computation. The value in cell J57 will be the same as the value shown in cell G25 in Section II. This value will automatically be entered by the spreadsheet when you set up the compuation for the cell G25. The values in cells J55-J57 must be used to compute the answer in cell J58. | ||||||||||
B. | Amount needed in your retirement fund when you retire | |||||||||
Average annual income during retirement--stated in inflation-adjusted dollars: | $0.00 | |||||||||
Weighted average expected rate of return on your retirement fund: | 0.00% | |||||||||
Years of retirement (how long you expect to be retired): | 0 | |||||||||
Total amount neeeded at retirement (in the fund): | ||||||||||
Set up the relationship required to determine the total amount to which your retirement fund must grow during the years you expect to make contributions (work). You can use the PV function built into the spreadsheet for this computation. The values in cells J67-J69 will automatically be entered by the spreadsheet from the relationships you created earlier. These values must be used to compute the answer in cell J70 | ||||||||||
C. | Required annual contributions to your retirement fund | |||||||||
Total amount neeeded at retirement (in the fund): | $0.00 | |||||||||
Years to retirement: | 0 | |||||||||
Average market conditions | ||||||||||
Expected rate of return on your retirement fund in an average market: | 0.00% | |||||||||
Annual contributions required to accumulate amount needed at retirement: | ||||||||||
Set up the relationship required to determine the amount that needs to be contributed to your retirement fund each year to accumulate the total amount that is needed in the fund when you retire. You can use the PMT function built into the spreadsheet for this computation. The values in cells J79-J80 and J83 will automatically be entered by the spreadsheet from the relationships you created earlier. These values must be used to compute the answer in cell J84. | ||||||||||
Above-average market conditions | ||||||||||
Expected rate of return on your retirement fund in an above-average market: | ||||||||||
Annual contributions required to accumulate amount needed at retirement: | ||||||||||
Follow the same procedure as above, except enter a rate of return in cell J93 that you might reasonably expect your retirement fund will earn in an above-average market.The values in cells J79-J80 and J93 must now be used to compute the answer in cell J94. | ||||||||||
Below-average market conditions | ||||||||||
Expected rate of return on your retirement fund in a below-average market: | ||||||||||
Annual contributions required to accumulate amount needed at retirement: | ||||||||||
Follow the same procedure as above, except enter a rate of return in cell J101 that you might reasonably expect your retirement fund will earn in a below-average market. The values in cells J79-J80 and J100 must now be used to compute the answer in cell J101. | ||||||||||
D. | Re-compute the contributions that are needed to accumulate the amount of funds required at retirement assuming that you wait to make payments to the retirement fund until you have 5 LESS years remaining until you retire. | |||||||||
In this section, you must perform the same computations as you did in Part C, except the contributions to the retirement fund will be for a different number of years. You must set up the spreadsheet format for these computations yourself. To set up the format, you can use the copy command to copy the relationships you created in Part C. But, be careful to ensure that all the cell references are correct after you copy the relationships. | ||||||||||
Required annual contributions to your retirement fund | ||||||||||
Total amount neeeded at retirement (in the fund): | $0.00 | |||||||||
Years to retirement: | ||||||||||
Average market conditions | ||||||||||
Expected rate of return on your retirement fund in an average market: | 0.00% | |||||||||
Annual contributions required to accumulate amount needed at retirement: | ||||||||||
Set up the relationship required to determine the amount that needs to be contributed to your retirement fund each year to accumulate the total amount that is needed in the fund when you retire. You can use the FV function built into the spreadsheet for this computation. The values in cells J79-J80 and J83 will automatically be entered by the spreadsheet from the relationships you created earlier. These values must be used to compute the answer in cell J84. | ||||||||||
Above-average market conditions | ||||||||||
Expected rate of return on your retirement fund in an above-average market: | ||||||||||
Annual contributions required to accumulate amount needed at retirement: | ||||||||||
Follow the same procedure as above, except enter a rate of return in cell J93 that you might reasonably expect your retirement fund will earn in an above-average market.The values in cells J79-J80 and J93 must now be used to compute the answer in cell J94. | ||||||||||
Below-average market conditions | ||||||||||
Expected rate of return on your retirement fund in a below-average market: | ||||||||||
Annual contributions required to accumulate amount needed at retirement: |