Question

In: Finance

Question: You recently received a bonus of $8,000 and are thinking of investing this sum of...

Question:

You recently received a bonus of $8,000 and are thinking of investing this sum of money for your retirement 20 years later. Sandy Chen, your financial planner, approached you recently an offered two investment products. Product Aee will earn an annual return of 5% per year for the first 5 years. If there is no recession in Singapore during the first 5 years, all amounts invested will earn an annual return of 7% for the next 10 years, otherwise, returns will be 3% per year. Alternatively, Product Bee allows you to invest $800 per year (at the beginning of each year) for the next 10 years. It will earn a return of 5% per year. This product will mature 20 years later. Over the next two decades, the deposit rate offered by local banks is expected to be 2% per year, which is compounded daily. Whereas, lending rates are expected to be 6% per year (compounded monthly). Based on a recent article you read from Business Times, economists have predicted that there will be a 70% chance of a recession happening over the next several years.

(a) Calculate the amount you expect to receive at the end of 15 years for Product Aee if there is no recession during the first 5 years.

(b) Calculate the amount you expect to receive at the end of 15 years for Product Aee if there is a recession during the first 5 years.

(c) Calculate the value of Product Bee on maturity. (d) Calculate the effective interest rate of both deposit and lending rates.

(d) Calculate the effective interest rate of both deposit and lending rates.

(e) Determine and justify which investment product you should choose. State any assumptions made.

Solutions

Expert Solution

(a) Amount to be received after 15 years for Aee if there is no recession during first 5 years
For first 5 years
Pv Deposit in the beginning $8,000
Rate Interest rate 5%
Nper Number of years                     5
FV Amount accumulated at end of 5 years $10,210.25 (using excel FV function with Rate=5%, Nper=5, Pv=-8000)
Next 10 years
Pv Amount available in the beginning $10,210.25
Rate Interest rate if there was no recession 7%
Nper Number of years 10
FV Amount accumulated at end of 15 years $20,085.11 (using excel FV function with Rate=7%, Nper=10, Pv=-10210.25)
(b) Amount to be received after 15 years for Aee if there is recession during first 5 years
Next 10 years
Pv Amount available in the beginning $10,210.25
Rate Interest rate if there was recession 3%
Nper Number of years 10
FV Amount accumulated at end of 15 years $13,721.73 (using excel FV function with Rate=3%, Nper=10, Pv=-10210.25)
.(c) Value of product Bee on maturity
Pmt Amount invested per year $800
Rate Interest Rate 5%
Nper Number of years 10
FV Amount accumulated at end of 10 years $10,565.43 (using excel FV function with Rate=5%, Nper=10, Pmt=-800,Type=1(Beginning of year deposit)
Next 20years:
Interest rate =2% compounded daily
Rate Annual effective rate=((1+(0.02/365))^365)-1 0.02020078
PV Amount available in the beginning of 20 year period $10,565.43
Nper Number of years                   20
Fv Value of product Bee on maturity $15,761.60 (using excel FV function with Rate=0.02020078, Nper=20,Pv=-10565.43)
Effective deposit Rate 0.02020078
Effective deposit Rate(Percentage) 2.020078%
Lending rate 6% compounded Monthly
Effective Lending rate=((1+(0.06/12))^12)-1= 0.06167781
Effective Lending rate(Percentage)= 6.17%

Related Solutions

a) You are currently thinking about investing in an ordinary share The share recently paid a...
a) You are currently thinking about investing in an ordinary share The share recently paid a dividend of $2.25 and the dividend is expected to grow at a constant rate of 5 per cent p.a. You normally require a return of 14 % p.a. on shares of similar risk.Calculate the value of the share using the Dividend Discount Model (DDM). (b) Ambrose Ltd expects to pay a dividend of $5.90 per share next year. The dividend is then expected to...
Joseph York has been investing his annual $5,000 bonus received at the end of each year...
Joseph York has been investing his annual $5,000 bonus received at the end of each year for 15 years. He was very conscientious about making his deposits in his 9% account but because of the poor economic conditions that year, he did not receive a bonus to invest in year 10. How much does he have saved up at the end of the 15 years?
3. Suppose you are thinking of investing $100,000 in stock indexes. You are currently considering investing...
3. Suppose you are thinking of investing $100,000 in stock indexes. You are currently considering investing either in the financial sector or the technolgy sector but the returns will depend on the state of the economy. The following table summarizes the estimated net profts that would be realized during the next two years for each of the two investment alternatives you are considering. State of the Economy Good Economy Poor Economy Healthcare $60,000 $-10,000 Decision Alternative Technology $90,000 $-50,000 Probability...
You just received a bonus of ​$ 3, 000. a.  Calculate the future value of ​$...
You just received a bonus of ​$ 3, 000. a.  Calculate the future value of ​$ 3, 000​, given that it will be held in the bank for 10 years and earn an annual interest rate of 6 percent. b.  Recalculate part ​(a​) using a compounding period that is​ (1) semiannual and​ (2) bimonthly. c.  Recalculate parts ​(a​) and ​(b​) using an annual interest rate of 12 percent. d.  Recalculate part ​(a​) using a time horizon of 20 years at...
You have received a year-end bonus of $5000. You decide to invest the money in the...
You have received a year-end bonus of $5000. You decide to invest the money in the stock market and have narrowed down your options to two mutual funds. This data represent the historical quarterly rates of return for each mutual fund for the last five years. Describe each data set using words related to shape, center, and spread. Which mutual fund would you choose to invest in, and why? Mutual Fund A Mutual Fund B 1.3 -5.2 -0.3 6.7 0.6...
Calculate the future sum of ​$8,000​, given that it will be held in the bank for...
Calculate the future sum of ​$8,000​, given that it will be held in the bank for 9 years at an APR of 4 percent. Recalculate part a using compounding periods that are​ (1) semiannual and​ (2) bimonthly​ (every two​ months). Recalculate parts a and b for an APR of 8 percent. Recalculate part a using a time horizon of 18 years​ (the APR is still 4 ​percent). With respect to the effect of changes in the stated interest rate and...
a. Calculate the future sum of 8,000​, given that it will be held in the bank...
a. Calculate the future sum of 8,000​, given that it will be held in the bank for 77 years at an APR of 66 percent. ​b. Recalculate part (a) using compounding periods that are​ (1) semiannual and​ (2) bimonthly​ (every two​ months). c. Recalculate parts (a​) and (b​) for an APR of 12percent. d. Recalculate part (a​) using a time horizon of 14 years​ (the APR is still 66 percent). e. With respect to the effect of changes in the...
You just received a bonus of ?$1000. a. Calculate the future value of ?$1000?, given that...
You just received a bonus of ?$1000. a. Calculate the future value of ?$1000?, given that it will be held in the bank for 8 years and earn an annual interest rate of 7 percent. What is the future value of ?$1000 in a bank account for 8 years at an annual interest rate of 7 ?percent? $________?(Round to the nearest? cent.) b. Recalculate part ?(a?) using a compounding period that is? (1) semiannual and? (2) bimonthly. c. Recalculate parts...
You just received a bonus of $4,000. a. Calculate the future value of $4,000​ given that...
You just received a bonus of $4,000. a. Calculate the future value of $4,000​ given that it will be held in the bank for 5 years and earn an annual interest rate of 7 percent. b. Recalculate part (a​) using a compounding period that is​ (1) semiannual and​ (2) bimonthly. c. Recalculate parts (a​) and (b​) using an annual interest rate of 14 percent. d. Recalculate part (a​) using a time horizon of 10 years at an annual interest rate...
(Compound interest with? non-annual periods?) You just received a bonus of ?$4,000.
(Compound interest with? non-annual periods?) You just received a bonus of ?$4,000. a. Calculate the future value of $1,000, given that it will be held in the bank for 8 years and earn an annual interest rate of 7 percent. b.Recalculate part (a) using a compounding period that is (1) semiannual and? (2) bimonthly. c.Recalculate parts (a) and (b) using an annual interest rate of 14 percent. d.Recalculate part (a) using a time horizon of 16 years at an annual...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT