In: Finance
Investment is the purchase or creation of assets to to make gains in the future. Typically investment involves using financial resources to purchase a machine or building or securities or other assets, which will then yield returns to an organization or individual over a period of time.
Last year, Gary graduated with a Foundation in Arts from Quest International University Ipoh and received RM5,000 from his father as a graduation gift. Gary, now in his first year of a degree program, recently heard from a friend who earns a profit from investing in the bond market during this pandemic time.
Gary does not know much about investing or how people actually “make money by investing”. He asked you to help him in making a wise investment plan.
Need help for a, b, c, d and e
a. Some of the risks involved in inesting in the bonds are as follows:
b. The Expected Rate of Return is 5% as computed below:
Formula Used in excel "=IRR(range of cells)"
Year | Cash Flow |
0 | -1085 |
1 | 55 |
2 | 55 |
3 | 55 |
4 | 55 |
5 | 55 |
6 | 55 |
7 | 55 |
8 | 55 |
9 | 55 |
10 | 55 |
11 | 55 |
12 | 55 |
13 | 55 |
14 | 55 |
15 | 1055 |
c. The Present Value of RM1,000 that Gary would receive after 15 years @7% comes to RM362 (1000*.362)
The Present Value of RM55 that Gary would receive each year for 15 years discounted @7% comes to RM500.94 (55*9.10791)
Hence, Value of the Bond for Gary = RM862.94
d. Since, value of the bond for Gary is RM862.94 and actual market value of the bond is RM1,085, it is not advisable for Gary to invest in this bond.
e. The value of the investment to Mr. Xi @ 11% annual discount rates comes to RM76,282 as computed below:
Year | Cash Flow | PV @ 11% | PV |
1 | 12000 | 0.901 | 10812 |
2 | 14000 | 0.812 | 11368 |
3 | 17000 | 0.731 | 12427 |
4 | 19000 | 0.659 | 12521 |
5 | 23000 | 0.593 | 13639 |
6 | 29000 | 0.535 | 15515 |
76282 |