Question

In: Finance

Shelby currently has 13,800 dollars saved and plans to make annual savings contributions of 12,200 dollars....

Shelby currently has 13,800 dollars saved and plans to make annual savings contributions of 12,200 dollars. Her first annual savings contribution is expected in 1 year. Shelby expects to earn 3.06 percent per year. How many contributions of 12,200 dollars does Shelby need to make in order to have 122,497 dollars?

Please show your work

Solutions

Expert Solution

Current Savings                       13,800
Annual Deposits                       12,200
Rate                     0.03060
No. of Years                                  8
Final Wanted Amount                     122,497

Using Goal Seek Formula in Excel, We find that it will take 8 years for Shelby to get to 122497 dollars.


Related Solutions

Mary plans to make the following contributions to her retirement account: $10,000 for each of the...
Mary plans to make the following contributions to her retirement account: $10,000 for each of the next ten years, and $12,000 for each of the ten years after that. If her savings earn 5%, how much will she have at the end of the 20 years. Ignore taxes and assume that the contributions are made at the end of the year.
For his retirement in 30 years, a man plans to make monthly contributions of $25 to...
For his retirement in 30 years, a man plans to make monthly contributions of $25 to an ordinary annuity paying 8% annually, compounded monthly at a. Find the total amount of his contributions. b. Find the single deposit now that will provide the same retirement benefit.
Bodie Bonds is making his retirement plans. He currently has savings of $125,000. He hopes to...
Bodie Bonds is making his retirement plans. He currently has savings of $125,000. He hopes to retire in 15 years. His retirement expenses are expected to be $60,000 during the first year of retirement; Bodie expects these expenses to grow by 2% a year to keep up with inflation. Bodie wishes to provide for 30 years of retirement. Assume that all cash flows arise at year end (not year beginning) and that the rate of return (interest rate or discount...
XYZ wants to have $192,000 in 8 years. He plants to make regular savings contributions of...
XYZ wants to have $192,000 in 8 years. He plants to make regular savings contributions of $9,400 per year for 8 years, with the first of these regular savings contributions made later today. In addition, XYZ expects to make a special savings contribution of X in 2 years. He expects to earn 13.6 percent per year. What is X, the amount fo the special savings contribution that XYZ will make in 2 years?
Jack is currently 20 years old and has 1000 dollars in his 401 k. He plans...
Jack is currently 20 years old and has 1000 dollars in his 401 k. He plans to put in additional 1000 dollars every year. He is not sure about the allocation so decides to put 50 % in a stock fund and 50 % in the bond fund. If the future fund growth performance is same as the historical growth; Forecast how much   will Jack have in each fund and calculate his asset allocation percentage based the forecasted amount at...
Warren plans to retire in 16 years. He will make 192 equal montly contributions to his...
Warren plans to retire in 16 years. He will make 192 equal montly contributions to his retirement account. One month after his last contribution, he will begin the first of 240 equal monthly withdrawals from the account. He expects to withdraw $2800 per month. How large must his monthly contributions be in order to accompish his goal if his account is assumed to earn interest at the APR of 6 %, compounded monthly througout the life of this problem? Round...
Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars)...
Question 5 The data in the incomplete table below represent annual Savings (in thousands of dollars) and annual Income (in thousands of dollars) for a sample of 7 families in Brisbane: Annual Income X ('000 dollars) Annual Saving Y ('000 dollars) X2 Y2 XY 60 10 80 40 100 30 120 49 140 57 180 50 200 70 Total= Total= Total= .    Total= Total=    a. Complete the necessary additional columns on the above table to calculate the required...
1. Mel plans to save 13,900 dollars per year for 3 years. His first savings contribution...
1. Mel plans to save 13,900 dollars per year for 3 years. His first savings contribution is expected in 1 year. He then plans to withdraw 19,200 dollars per year for as long as he can. Mel expects to earn 4.42 percent per year. How many payments of 19,200 dollars can Mel expect to receive if his first annual payment of 19,200 dollars is received in 3 years?  Round your answer to 2 decimal places (for example, 2.89, 14.70, or 6.00).
1. Chen plans to save 23,300 dollars per year for 6 years. His first savings contribution...
1. Chen plans to save 23,300 dollars per year for 6 years. His first savings contribution is expected later today. He then plans to make withdrawals for 6 years. How much can Chen expect to withdraw each year if he expects to earn 10.07 percent per year, he makes equal annual withdrawals, and his first withdrawal is made in 7 years?
A) Assume that you wish to make annual deposits into a savings account. The interest rate...
A) Assume that you wish to make annual deposits into a savings account. The interest rate offered by the bank is 11%, and you plan to save for the next 12 years. If your goal is for the present value of your savings to be equal to $4,058, how much money must you deposit every year? B) Assume you've just received a bonus at work of $3,812. You deposit that money in the bank today, where it will earn interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT