MGT201 Assignment 1 Solution and Discussion

Re: MGT201 Assignment 1 Solution and Discussion
Assignment#01
Marks 20
Stock valuation and Bond Valuation
Bonds and stocks are two primary securities traded on approximately all stock exchanges of the world because of its potential, reliability, and better trade volume. Besides all these pro, risk taking behavior of different investors and the features associated with each class of security are vital ones that attract investors for earning a handsome return. Stocks are considered more risky with higher return, whereas bonds accounted low risk investment with guaranteed return. However, most investors formulate a portfolio of their investment with combination of bonds and stocks for optimal return with a lesser degree of risk due to diversification edge involved in it.
The formulation of such portfolio lies upon market factors and company specific factors. The optimal return only can be achieved by better judgment of both factors and evaluation of intrinsic prices of securities by some fundamental methods.
Required:
A new investor wants to add bonds and shares in his portfolio and he has two options available with the following information.
I. Company ABC issued a fiveyear bond with face value of Rs.1,000. The bond offers 12% semiannual coupon payment. The market interest rate for such type of investment is 14% per annum while current market price of bond is Rs.940.
II. The stock of company XYZ is being sold at Rs.54 per share while the forecasted dividend is Rs.6 for first year and Rs.7 for the second year. The price of the stock after year 2 is expected to be Rs.55. The Company paid most recent dividend as Rs.5 whereas the rate of return for such type of investment is 14% per annum.
You are required to help the investor in valuation of both investment options by calculating: Intrinsic value of the bond. (8 marks)
 Intrinsic Value of stock today. (8 marks)
 Identify either bond and stocks are overvalued or undervalued. Justify your answer with proper calculation and reasoning. (4 Marks)
NOTE: Formula and complete working is mandatory in each part, provide complete
calculations in order to avoid marks deduction.
IMPORTANT NOTE:
24 hours extra / grace period after the due date is usually available to overcome uploading difficulties. This extra time should only be used to meet the emergencies and above mentioned due dates should always be treated as final to avoid any inconvenience.
IMPORTANT INSTRUCTIONS/ SOLUTION GUIDELINES/ SPECIAL INSTRUCTIONS DEADLINE:
• Make sure to upload the solution file before the due date on VULMS
• Any submission made via email after the due date will not be accepted FORMATTING GUIDELINES:
• Use the font style “Times New Roman” or “Arial” and font size “12”
• It is advised to compose your document in MSWord format
• You may also compose your assignment in Open Office format
• Use black and blue font colour only RULES FOR MARKING
• Please note that your assignment will not be graded or graded as Zero (0), if:
• It is submitted after the due date.
• The file you uploaded does not open or is corrupt.
• It is in any format other than MSWord or Open Office; e.g. Excel, PowerPoint, PDF etc.
• Not submitted as per given format
• It is cheated or copied from other students, internet, books, journals etc.
Note related to load shedding:
Dear students,
As you know that semester activities have started and load shedding problem is also prevailing in our country. Keeping in view the fact, you all are advised to post your activities as early as possible without waiting for the due date. For your convenience; activity schedule has already been uploaded on VULMS for the current semester, therefore no excuse will be entertained after due date of assignments or GDBs.
Best of Luck!!

@FouziaSuleman said in MGT201 Assignment 1 Solution and Discussion:
IA new investor wants to add bonds and shares in his portfolio and he has two options available with the following information.
I. Company ABC issued a fiveyear bond with face value of Rs.1,000. The bond offers 12% semiannual coupon payment. The market interest rate for such type of investment is 14% per annum while current market price of bond is Rs.940.
II. The stock of company XYZ is being sold at Rs.54 per share while the forecasted dividend is Rs.6 for first year and Rs.7 for the second year. The price of the stock after year 2 is expected to be Rs.55. The Company paid most recent dividend as Rs.5 whereas the rate of return for such type of investment is 14% per annum.
You are required to help the investor in valuation of both investment options by calculating:Intrinsic value of the bond. (8 marks)
Intrinsic Value of stock today. (8 marks)
Identify either bond and stocks are overvalued or undervalued. Justify your answer with proper calculation and reasoning. (4 Marks)Assignment#01
Marks 20
Intrinsic value of the bond
Po=Σ Ct/ (1+r/2)n + Par/1+r/2)n
C = coupon payments = 100012/100 = 120/2 = Rs.60
No. of coupon payments = 52 = 10 (semiannual) Required rate of return: 14/2 = 7% (semiannual)
= 60Annuity factor (7%,10) + 1,000 * PV factor (7%, 10) = 60{11/ (1+0.14/2) 52) / (0.14/2)} + 1,000/ (1+ (0.14/2)5*2 = 60{11/ (1+0.07)10 /0.07} + 1,000/ (1+0.07)10
= 421.41+ 508.35
= Rs. 929.76 
Intrinsic value of the stock
Do = Current dividend = Rs.5 D1 = Rs.6
D2 = Rs.7
Value of Stock:
Po = D1/ (1+i)n + D2/ (1+i)n + P2/(1+i)n Po = 6/ (1.14)1+ 7/ (1.14)2 + 55/ (1.14)2 Po = 5.26+5.39+42.32
Po = Rs.52.97
Bond and Stock valuation Solution 
Overvaluation or undervaluation of securities
For Bond
Bond is overvalued because market price is more than intrinsic value i.e. Market price > Intrinsic value
940 > 929.76
For Stock
Stick is also overvalued as its market price is more than its intrinsic value i.e. Market price > Intrinsic value
54 > 52.97


@FouziaSuleman said in MGT201 Assignment 1 Solution and Discussion:
IA new investor wants to add bonds and shares in his portfolio and he has two options available with the following information.
I. Company ABC issued a fiveyear bond with face value of Rs.1,000. The bond offers 12% semiannual coupon payment. The market interest rate for such type of investment is 14% per annum while current market price of bond is Rs.940.
II. The stock of company XYZ is being sold at Rs.54 per share while the forecasted dividend is Rs.6 for first year and Rs.7 for the second year. The price of the stock after year 2 is expected to be Rs.55. The Company paid most recent dividend as Rs.5 whereas the rate of return for such type of investment is 14% per annum.
You are required to help the investor in valuation of both investment options by calculating:Intrinsic value of the bond. (8 marks)
Intrinsic Value of stock today. (8 marks)
Identify either bond and stocks are overvalued or undervalued. Justify your answer with proper calculation and reasoning. (4 Marks)Assignment#01
Marks 20
Intrinsic value of the bond
Po=Σ Ct/ (1+r/2)n + Par/1+r/2)n
C = coupon payments = 100012/100 = 120/2 = Rs.60
No. of coupon payments = 52 = 10 (semiannual) Required rate of return: 14/2 = 7% (semiannual)
= 60Annuity factor (7%,10) + 1,000 * PV factor (7%, 10) = 60{11/ (1+0.14/2) 52) / (0.14/2)} + 1,000/ (1+ (0.14/2)5*2 = 60{11/ (1+0.07)10 /0.07} + 1,000/ (1+0.07)10
= 421.41+ 508.35
= Rs. 929.76 
Intrinsic value of the stock
Do = Current dividend = Rs.5 D1 = Rs.6
D2 = Rs.7
Value of Stock:
Po = D1/ (1+i)n + D2/ (1+i)n + P2/(1+i)n Po = 6/ (1.14)1+ 7/ (1.14)2 + 55/ (1.14)2 Po = 5.26+5.39+42.32
Po = Rs.52.97
Bond and Stock valuation Solution 
Overvaluation or undervaluation of securities
For Bond
Bond is overvalued because market price is more than intrinsic value i.e. Market price > Intrinsic value
940 > 929.76
For Stock
Stick is also overvalued as its market price is more than its intrinsic value i.e. Market price > Intrinsic value
54 > 52.97


@FouziaSuleman said in MGT201 Assignment 1 Solution and Discussion:
II. The stock of company XYZ is being sold at Rs.54 per share while the forecasted dividend is Rs.6 for first year and Rs.7 for the second year. The price of the stock after year 2 is expected to be Rs.55. The Company paid most recent dividend as Rs.5 whereas the rate of return for such type of investment is 14% per annum.
Dividend year 1= Rs 6
Dividend year 1= Rs 7
Price of stock after 2 years = Rs 55
Rate of return = 14% per annum.
PV = 6/1.14 + 7/(1.14)2 + 55/(1.14)2
= 5.26 + 5.39 + 42.32 = Rs 52.97

@FouziaSuleman said in MGT201 Assignment 1 Solution and Discussion:
I. Company ABC issued a fiveyear bond with face value of Rs.1,000. The bond offers 12% semiannual coupon payment. The market interest rate for such type of investment is 14% per annum while current market price of bond is Rs.940.
Solution
Face value of bond= Rs 1000
Interest rate(rD)=12% semi annually
Market price of Bond= Rs 940
Market Interest Rate=14% per annum
CF = Cash Flow = Coupon Value
= Coupon Rate x Par Value
=0.1221000= Rs 240PV=240/1.14 + 240/(1.14)2 + 240/(1.14)3 + 240/(1.14)4 + 240/(1.14)5 + 1000/(1.14)5