Question

In: Finance

You just celebrated your 25th birthday today. You plan to invest $2000 annually, with the first...

You just celebrated your 25th birthday today. You plan to invest $2000 annually, with the first $2000 invested on your 26th birthday and the last invested on your 60th birthday.

What is the value of this investment on your 61st birthday if all invested funds earn 6 percent annually?

Solutions

Expert Solution

Ans: $ 222,869.55

Years Annuity payment(A) future value factor(B) future value factor Future value(A*B)
1 26 2000 7.251025276 (1.06)^34 14502.05055
2 27 2000 6.840589883 (1.06)^33 13681.17977
3 28 2000 6.453386682 (1.06)^32 12906.77336
4 29 2000 6.088100643 (1.06)^31 12176.20129
5 30 2000 5.743491173 (1.06)^30 11486.98235
6 31 2000 5.418387899 (1.06)^29 10836.7758
7 32 2000 5.111686697 (1.06)^28 10223.37339
8 33 2000 4.822345941 (1.06)^27 9644.691881
9 34 2000 4.549382963 (1.06)^26 9098.765926
10 35 2000 4.29187072 (1.06)^25 8583.741439
11 36 2000 4.048934641 (1.06)^24 8097.869283
12 37 2000 3.819749662 (1.06)^23 7639.499323
13 38 2000 3.603537417 (1.06)^22 7207.074833
14 39 2000 3.399563601 (1.06)^21 6799.127201
15 40 2000 3.207135472 (1.06)^20 6414.270944
16 41 2000 3.025599502 (1.06)^19 6051.199004
17 42 2000 2.854339153 (1.06)^18 5708.678306
18 43 2000 2.692772786 (1.06)^17 5385.545572
19 44 2000 2.540351685 (1.06)^16 5080.703369
20 45 2000 2.396558193 (1.06)^15 4793.116386
21 46 2000 2.260903956 (1.06)^14 4521.807912
22 47 2000 2.13292826 (1.06)^13 4265.85652
23 48 2000 2.012196472 (1.06)^12 4024.392944
24 49 2000 1.898298558 (1.06)^11 3796.597117
25 50 2000 1.790847697 (1.06)^10 3581.695393
26 51 2000 1.689478959 (1.06)^9 3378.957918
27 52 2000 1.593848075 (1.06)^8 3187.696149
28 53 2000 1.503630259 (1.06)^7 3007.260518
29 54 2000 1.418519112 (1.06)^6 2837.038225
30 55 2000 1.338225578 (1.06)^5 2676.451155
31 56 2000 1.26247696 (1.06)^4 2524.95392
32 57 2000 1.191016 (1.06)^3 2382.032
33 58 2000 1.1236 (1.06)^2 2247.2
34 59 2000 1.06 (1.06)^1 2120
35 60 2000 1 1 2000
222869.5597

Related Solutions

Today is your 25th birthday, and you want to save $2.4 Million by your birthday at...
Today is your 25th birthday, and you want to save $2.4 Million by your birthday at age 70. If you expect to earn 7% APR compounded monthly in your retirement account, what constant payment at the end of each month must you deposit into the account through your 70th birthday in order to reach your retirement savings goal on your 70th birthday? (Answer to the nearest penny.)
2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to...
2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to your excellent education at BW. The new firm provides you a 401-k plan, and you decide to deposit $400 every month for first 20 years. After that (since your kids are out in college and your living expenses are lower) you increase your contribution by $200/month, that results in a total contribution of $600/month. The firm matches it at 100% and deposits the money...
Sam has just celebrated her 25th birthday. On her way home from the Easter Holiday celebrations...
Sam has just celebrated her 25th birthday. On her way home from the Easter Holiday celebrations in Portugal, she was nearly involved in an accident. It was at this point that she realised that she needs to save up for her retirement at the age of 55. She currently has no savings available. When Sam retires, she wants to buy a cattle farm in Portugal that will be valued at R3 500 000 in 30 years. She also wants to...
You and your cousin Kristin were born on the same day. Today is your 25th birthday....
You and your cousin Kristin were born on the same day. Today is your 25th birthday. Five years ago (when you turned 20) your aunt started depositing $2,500 into Kristin's account. She did this every year and she just made a sixth deposit. Your aunt will make forty more $2,500 payments until a 46th and final payment is made on Kristin's sixty fifth birthday. Your aunt has had a change of heart and now wants to make an equivalent provision...
Today is your 25th birthday, and you have calculated that you need to accumulate $2.1 Million...
Today is your 25th birthday, and you have calculated that you need to accumulate $2.1 Million by your 70th birthday in order to retire in a manner in which you are accustomed to living. If your retirement account earns 7.1% per year simple interest, how much must you deposit on each of your birthdays (from 26 to 70) in order to reach your target retirement savings on your 70th birthday? (Answer to the nearest dollar.)
Today is your 25th birthday. Your goal is to retire when you turn 70 years old...
Today is your 25th birthday. Your goal is to retire when you turn 70 years old and have sufficient monthly income until your expected demise on your 99th birthday. In order to realize your goal, you are planning to make deposits into a target-date retirement fund that is expected to generate 7.8% annual return, compounded monthly. You want to be able to make monthly withdrawals from this fund starting one month after your retirement until your expected demise. These monthly...
Could you show your work in Excel Please. Today is your 25th birthday. You have decided...
Could you show your work in Excel Please. Today is your 25th birthday. You have decided that it is necessary to plan your own retirement since you are not confident that government benefits will be available when you retire. You will make annual payments into an account earning 5% APY starting on your next birthday (26th) a year from now. Your last payment will occur on your 70th birthday. You have decided that you need to plan for payments of...
Ryan Ripley is celebrating his 25th birthday today by accepting his first job offer as a...
Ryan Ripley is celebrating his 25th birthday today by accepting his first job offer as a software engineer with a local manufacturing firm since graduating college about 6 months ago. Ryan will be paid a starting salary of $30,655.68. His salary will be paid in annual installments with his first payment coming 1 year from today. Ryan plans to stay in this job for 41 years, such that he will receive his 41st and final salary payment on his 66th...
Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making...
Today is your 22nd birthday. You plan to retire on your 60th birthday, immediately after making your last savings deposit, and begin collecting your retirement payments on your 61st birthday. You decide that your retirement payment will be $80,000 at age 61, growing at 1.5% per year afterwards, and you expect to collect a total of 35 payments. Starting on your 23rd birthday, and on every birthday before you retire, you will make a deposit into your retirement savings account....
You plan to invest Rs. 2000 in a fixed deposit today that pays a stated annual...
You plan to invest Rs. 2000 in a fixed deposit today that pays a stated annual interest rate of 8 percent which is expected to apply to all future years. a) How much will you have in the account at the end of 10 years if interest is compounded as follows i) Annually ii) Semiannually iii)Monthly b) What is the effective annual rate (EAR) for each compounding frequency in part a ?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT