Question

In: Finance

Bart is a junior in college. He plans to invest equal, annualamounts starting 5 years...

Bart is a junior in college. He plans to invest equal, annual amounts starting 5 years from now for 7 consecutive years in order to accumulate a total of $49,000 at the end of 15 years. If the funds earn 8% per year, what is the required amount of each deposit?

Solutions

Expert Solution

Bart plans to Invest equal annual payments starting 5 years frm now for 7 consecutive years and accumulate $49,000 at the end of year 15.

first, we will calculate the Present Value at the end of year 12 of the accumulated value:-

Present Value = Future Accumulated Value/(1+r)^n

where, r = interest rate = 8%

n = No of years = 3

Present Value = $49,000/(1+0.08)^3

= $49,000/1.259712

= $38,897.78

Now the value at the end of year 12 is $38,897.78

Now, we will use teh value at the end of year 12 to compute the periodic equal installments:-

Where, C= Periodic Payments

r = Periodic Interest rate = 8%

n= no of periods = 7

C =$4036.45

So, the required amount of each deposit is $4036.45


Related Solutions

A couple plans to pay their child’s college tuition for 4 years starting 18 years from...
A couple plans to pay their child’s college tuition for 4 years starting 18 years from now. The current annual cost of college is C$7,000, and they expect this cost to rise at an annual rate of 5 percent. In their planning, they assume that they can earn 6 percent annually. How much must they put aside each year, starting next year, if they plan to make 17 equal payments?
STATE: Andrew plans to retire in 40 years. He plans to invest part of his retirement...
STATE: Andrew plans to retire in 40 years. He plans to invest part of his retirement funds in stocks, so he seeks out information on past returns. He learns that from 1966 to 2015, the annual returns on S&P 500 had mean 11.0% and standard deviation 17.0% . PLAN: The distribution of annual returns on common stocks is roughly symmetric, so the mean return over even a moderate number of years is close to Normal. We can use the Central...
1. Andrew plans to retire in 38 years. He plans to invest part of his retirement...
1. Andrew plans to retire in 38 years. He plans to invest part of his retirement funds in stocks, so he seeks out information on past returns. He learns that over the entire 20th century, the real (that is, adjusted for inflation) annual returns on U.S. common stocks had mean 8.7% and standard deviation 20.2%. The distribution of annual returns on common stocks is roughly symmetric, so the mean return over even a moderate number of years is close to...
The user plans to invest money in a variable rate CD for the next 5 years....
The user plans to invest money in a variable rate CD for the next 5 years. Have the user input the amount of money that they will invest today. The annual interest rate for the CD can vary from 0% to 10% (whole percentages only). Use the RANDBETWEEN function to predict the annual interest rate for the CD. Calculate how much money the user will have at the end of the five years. Note: This question is from Excel for...
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...
James is a partner in a very successful Boston-based VC firm. He plans to invest $5...
James is a partner in a very successful Boston-based VC firm. He plans to invest $5 million in a start-up biotechnology venture and must decide what share of the company he should demand his investment.    Projections he developed with company management show net income in Year 7 of $20 million. The few profitable biotechnology companies are trading at an average price-earnings (P/E) ratio of 15. The company currently has 500,000 shares outstanding. James believes that a target rate of return...
Dru plans to invest 6,500 dollars in 4 years and 7,300 dollars in 3 year(s). He...
Dru plans to invest 6,500 dollars in 4 years and 7,300 dollars in 3 year(s). He expects to earn 11.98 percent per year. How much money does Dru expect to have in 9 years?
Mr. Lim has $10,000 to invest for a period of 5 years. He has a choice...
Mr. Lim has $10,000 to invest for a period of 5 years. He has a choice of either the bonds or stocks of the Oxley Company. (A) Bond: Oxley’s bond: Face value $1,000, 10% coupon paid annually and 8 years’ life remaining. The bond can be purchased at $1,100 today. B) Common Stock: Oxley’s common stock just paid a dividend $0.80. Its dividend will grow at 4% per year perpetually. The stock can be purchased at $8 today. (a) Calculate...
A client plans to send her child to college starting in the fall of 2038. She...
A client plans to send her child to college starting in the fall of 2038. She estimates that tuition will cost $40,000 per year and that room and board will cost $14,000 per year, with $20,000 payable for tuition and $7,000 payable for room and board on each January 1 and July 1 during the four years in college, starting on July 1, 2038 and ending on January 1, 2042. She can invest in a fund that will pay 6%...
Starting on September 1, 2000 - the day he starts college - and ending on September...
Starting on September 1, 2000 - the day he starts college - and ending on September 1, 2004, Craig borrowed $6500 a year to pay for college expenses (i.e. that's 5 withdrawals total). After graduation, he decided to go to graduate school in mathematics, and his loans were deferred (i.e. they accrued interest, but no payments were due). After finishing graduate school, he began repaying his loans. Beginning on July 1, 2007, he made monthly payments for 8 years. Each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT