MAngeles2013
New member
- Joined
- Jun 11, 2013
- Messages
- 1
I have an excel assignment that i'm struggling with. A little help with the functions I need to use would be greatly appreciated. The investment funds are what is throwing me off the most.
let's say i decided to invest $2000 per year from now until iam age 65 into a retirement plan. i have decided to place one-half of the funds into a stock index fun that roughly tracks the return on the Standard and Poors Index. The other half of the funds will be place in a mutual fund containing bonds. i want to use the PV, FV and annuity functions within excel to complete the schedule.
a. Assume that the stock fund averages 12 % per year compounded annually and you bond fund averages 8% per year compounded annually.
b. 3% annual inflation rate
c. How do I find the annual income I need to receive at age 65 so that you can keep the same purchasing power that I have today starting with $30,000 as my base salary?
d. Once I retire at age 65, I want fund your retirement for 20 years, until I am age 85. How do i find the present value at my retirement, age 65, using the annual income?
e. How do i find the expected savings for each year in order to afford my retirement?
Thanks
let's say i decided to invest $2000 per year from now until iam age 65 into a retirement plan. i have decided to place one-half of the funds into a stock index fun that roughly tracks the return on the Standard and Poors Index. The other half of the funds will be place in a mutual fund containing bonds. i want to use the PV, FV and annuity functions within excel to complete the schedule.
a. Assume that the stock fund averages 12 % per year compounded annually and you bond fund averages 8% per year compounded annually.
b. 3% annual inflation rate
c. How do I find the annual income I need to receive at age 65 so that you can keep the same purchasing power that I have today starting with $30,000 as my base salary?
d. Once I retire at age 65, I want fund your retirement for 20 years, until I am age 85. How do i find the present value at my retirement, age 65, using the annual income?
e. How do i find the expected savings for each year in order to afford my retirement?
Thanks