Question

King Solomon is a rich farmer in Tetebia, a town in the Asou Municipal Assembly. He owns over 100,000 hectares of farmlands. However, he fears the worst might happen and wants to do some investments to secure his future and that of his children. He is contemplating some long term investments he could undertake to secure his future and that if his children. He is now 50 years old and he plans to retire in 10 years from active farm work. He expects to live for another 25 years after he retires –that is, until age 85. He was advised by a friend that an investment in the financial market will help him plan his retirement well. He has no idea about financial markets and how they operate. You recently graduated and have just reported to work as an investment advisor at the brokerage firm of Cenden Ltd. King Solomon has approached your company for advice. Your boss after a discussion with King Solomon could gather the following information. King Solomon wants his first retirement payment to have the same purchasing power at the time he retires as GHȼ 40,000 has today. He wants all of his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: King Solomon realizes that the real value of his retirement income will decline year by year after he retires.) His retirement income will begin the day he retires, 10 years from today, and he will then receive 24 additional annual payments. Inflation is expected to be 5% per year from today forward. He currently has GHȼ 100,000 saved up, and he expects to earn a return on his savings of 8% per year with annual compounding.

Again, he wants to have a secure university education for his lovely daughter Daisy. His daughter is now 13 years old. She plans to enroll at the University of Professional Studies, Accra in 5 years, and it should take her 4 years to complete her education. Currently, the cost per year (for everything – her food, clothing, tuition, books, transportation, and so forth) is GH¢ 12,000 per year. This cost is expected to remain constant throughout the four-year university education. The daughter recently received GH¢ 7,500 from her grandfather’s (King David’s) estate; this money will be invested at a rate of 8% to help meet the costs of Daisy’s education. The rest of the costs will be met by money King Solomon will deposit in a savings account which also earns 8 percent compound interest per year. He will make 5 equal deposits into the account, one deposit per annum starting one year from now until his daughter starts university. These deposits will begin one year from now. (Assume that school fees are paid at the beginning of the year).

Again, King Solomon is interested in buying a bond issued by Zenzo Pharma Ltd. Zenzo Pharma intends to use the proceeds of the bonds to finance the production of its new vaccine for COVID 19. The bond has a face value of GH¢10,000 at a coupon rate of 12% and a term to maturity of 10 years. The bond expects to pay coupons annually. Included in the bond indenture are call and sinking fund provisions. The required rate of return on the market for bonds with similar features is 18% per annum. Your boss had asked you to advice King Solomon based on the information he provided

Required
a. Explain to King Solomon what financial markets mean and which three (3) financial instruments he can invest in.                                                                                   
b. To the nearest cedi, how much must he save during each of the next 10 years (with equal deposits being made at the end of each year, beginning a year from today) to meet his retirement goal? (Note: Neither the amount he saves nor the amount he withdraws upon
retirement is a growing annuity.)                                                                           

c. What will be the present value of the cost of 4 years of education at the time the daughter
Daisy turns 18?                                                                                                          
d. What will be the value of the GH¢ 7,500 that Daisy received from her grandfather’s estate
when she starts college at 18?                                                                                   
e. If King Solomon is planning to make the first of 5 deposits one year from now, how large must each deposit be for him to able to put his daughter through college?            

Answer 1

Money related Market alludes to a commercial center, where creation and exchanging of budgetary resources, for example, shares, debentures, securities, subordinates, monetary forms, and so forth happen. It assumes a pivotal job in allotting restricted assets, in the nation's economy. It goes about as a delegate between the savers and financial specialists by assembling assets between them.

A	B	C	D
2	King Solomon
3	Present Age	50	50
4	Present Income	40000	40000
5	Present Fund	100000	100000
6	Inflation	0.05	0.05
7	Rate of Return	0.08	0.08
8	Death Age	85	85
9	Retirement Age	60	60
10	Income @60 Years	=$C$4*(1+$C$6)^(C9-$C$3)	65155.7850710977
11	PV of Post retirement Fund required (60 to 85)	=PV(C7,C8-C9,-C10,0,1)	751165.296867809
12	Value of Present Fund @60th Year	=$C$5*(1+C7)^(C9-$C$3)	215892.499727279
13	Further Fund requied to met PV of Post retirement Fund	=C11-C12	535272.79714053
14	Contrbution Required (END of the Year)	=PMT(C7,C9-C3,0,-C13,0)	36949.6075000641	Answer 2
15	Contrbution Required (Beginning of the Year)	=PMT(C7,C9-C3,0,-C13,1)	34212.5995370964	Answer 2
16
17
18	Daisy
19	Present Age	13	13
20	Present Fund	7500	7500
21	Inflation	0.05	0.05
22	Rate of Return	0.08	0.08
23	Admission Age	18	18
24	Amount Required during every Year of Education	12000	12000
25	PV of fees required @AGE OF 18 YEAR	=PV(C22,4,-C24,0,1)	42925.1638469746	Answer 3
26	Value of Present Fund @18th Year	=C20*(1+C22)^(C23-C19)	11019.960576	Answer 4
27	Further Fund requied to met PV of Post retirement Fund	=C25-C26	31905.2032709745
28	Contrbution Required (END of the Year)	=PMT(C22,C23-C19,0,-C27,0)	5438.44783180456	Answer 5
29	Contrbution Required (Beginning of the Year)	=PMT(C22,C23-C19,0,-C27,1)	5035.59984426348