Question

In: Accounting

4. Now assume that your wealthy grandfather wants to invest some money in your behalf. He...

4. Now assume that your wealthy grandfather wants to invest some money in your behalf. He wants the money to be worth $65,000 on December 31, 2025. How much money will he need to invest on a one-time basis on December 31, 2020 in order to earn enough interest to accumulate to $65,000 by December 31, 2025? Assume a 5% interest rate. (Hint: I recommend that you use the PV formula in Excel to solve this problem.)
Use the information from Question 4 except assume that the interest rate is 3% per year. How much will he have to invest on a one-time basis on December 31, 2020 to have $65,000 by December 31, 2025? Please use excel and show the formula and screenshot

Solutions

Expert Solution

A B C
1 Excel formula terms Explanation
2 Rate Interest rate 5%
3 nper No. of payment periods 5
4 pmt Payment made each period 0
5 FV Amount of payment $                           (65,000)
6 Type Type 0
7 Formula PV(C2,C3,C4,C5,0)
8 I.e., PV(5%,5,0,-65000,0)
9 Present value of investment $50,929.20
10
11
12 Excel formula terms Explanation
13 Rate Interest rate 3%
14 nper No. of payment periods 5
15 pmt Payment made each period 0
16 FV Amount of payment $                           (65,000)
17 Type Type 0
18 Formula PV(C13,C14,C15,C16,0)
19 I.e., PV(3%,5,0,-65000,0)
20 Present value of investment $56,069.57
Types Meaning
0 Due at end of the period
1 Due at beginning of the period

Screen Shot

Thank you.


Related Solutions

Your grandfather gives your $10,000 to invest and you must invest every penny. He wants you...
Your grandfather gives your $10,000 to invest and you must invest every penny. He wants you to have an expected return of 12.40% for your portfolio. You can chose between stock J with an expected return of 13% and stock L with an expected return of 8%. How much should you invest in stock J to achieve these results?
Your uncle has $300,000 today. Assume he can earn 9.18% on his investments. He now wants...
Your uncle has $300,000 today. Assume he can earn 9.18% on his investments. He now wants to retire in 10 years. Here is his situation: a. He wants to withdraw $35,000 every two years, beginning 12 years from today for 10 equal, every two-year (i.e. every other year) withdrawals. b. He has to pay for his daughter’s college beginning in 5 years at $20,000 for four years (i.e. he has to make a payment in year 5, 6, 7, and...
   Your uncle has $320,000 invested at 7.5%, and he now wants to retire. He wants...
   Your uncle has $320,000 invested at 7.5%, and he now wants to retire. He wants to withdraw $35,000 at the end of each year, starting at the end of this year. He also wants to have $25,000 left to give you when he ceases to withdraw funds from the account. For how many years can he make the $35,000 withdrawals and still have $25,000 left in the end? a. 12 years b. 16 years c. 15 years d. 17...
4. Assume that a wealthy woman comes to you looking for some investment advice. She is...
4. Assume that a wealthy woman comes to you looking for some investment advice. She is in her early forties and has $250,000 to put into stocks. She wants to build up as much capital as she can over a 15-year period and is willing to tolerate a “fair amount” of risk. What types of stocks do you think would be most suitable for this investor? Come up with at least three types of stocks, and briefly explain the rationale...
Assume your local congressman calls you for some economic advice. He wants to sponsor legislation to...
Assume your local congressman calls you for some economic advice. He wants to sponsor legislation to increase public spending on such common medical interventions as because he’s been told early detection saves money: Getting all children the right immunizations at the right time, before they turn 24 months, Screening for hypertension Screening for cervical cancer Smoking cessation classes How would you advise him?
Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to...
Your uncle has 431,000 invested at 6.8% and he now wants to retire. He plans to withdraw $40,000 at the end of each​ year, beginning this year. How many years will it take to exhaust his​ funds, i.e., run the account down to​ zero?
How much money do you need to invest now, to have $50,000 in 10 years?  Assume an...
How much money do you need to invest now, to have $50,000 in 10 years?  Assume an APR of 4.5%.
Parker has $10,000 to invest. He wants to put his money in a one-year investment earning...
Parker has $10,000 to invest. He wants to put his money in a one-year investment earning an annual interest rate of 12%. Parker is in a 42% tax bracket. Required: a) Calculate the total value of Parker's investment, after-tax, at the end of the year. b) Calculate the amount of tax Parker will pay on his investment.
Pierre Dupont just received a cash gift from his grandfather. He plans to invest in a...
Pierre Dupont just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Venice Corp. that pays an annual coupon of 4.65 percent. If the current market rate is 8.79 percent, what is the maximum amount Pierre should be willing to pay for this bond? (Round answer to 2 decimal places, e.g. 15.25.) Pierre should pay $
Kevin Hall just received a cash gift from his grandfather. He plans to invest in a...
Kevin Hall just received a cash gift from his grandfather. He plans to invest in a five-year bond issued by Wildhorse Corp. that pays an annual coupon rate of 4.5 percent. If the current market rate is 8.50 percent, what is the maximum amount Kevin should be willing to pay for this bond?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT