• Home
• Finance & Accounting
• Qn1a. See the excel sheet for the companies. The companies were selected in accordance with the need for discounted, premium rated and those priced at the Face Value.

Qn1a. See the excel sheet for the companies. The companies were selected in accordance with the need for discounted, premium rated and those priced at the Face Value. Essay Example

Lecturer:

Qn1a. See the excel sheet for the companies. The companies were selected in accordance with the need for discounted, premium rated and those priced at the Face Value.

Qn1. b. See the excel sheet for the results of the yields. They are as shown below

 Face value Annual Coupon Rate Bond Value (P0) Eastern Group Anglian Water services Alpha Plus Holdings CLS Holding Ladbrokes Group Coventry Intl Personal Finance Eros Intl

c. As can be seen from the table in Qn 1b above, as long as the coupon rate >YTM, the bonds are valued at a premium (Ii.e prices are higher than the face value). This can be seen throughout the first 5 companies. From the table, it can also be seen that as long as the coupon rate is <YTM, the bonds are sold at a discount (i.e prices/bond value is less than the face value). This can be seen for the last 4 companies. Looking at the table, it can be concluded that as the difference between the coupon rate and the YTM becomes infinitesimally small, the difference between the face value and the bond price gets infinitesimally small too. On a mathematical basis, as long as the coupon rate=YTM, the face value= present value. This therefore confirms the statements as asked in this question.

Qn1d. Calculated duration

 Annual Coupon Rate time to maturity Duration time Eastern Group Anglian Water services Alpha Plus Holdings CLS Holding Ladbrokes Group Coventry 15.68436 Intl Personal Finance Eros Intl

Qn1 d. In order to achieve the results for the results sought in this section, the constant factors were held so and the test factor altered in a manner that could give out a more vivid impression.

The table below can be used to verify that other things being equal, bonds with a higher coupon rate have a shorter duration.

 Annual Coupon Rate maturity date Settlement date Duration Eastern Group 31/03/2025 20/10/2020 2.8574607 Anglian Water services 31/03/2025 20/10/2020 2.9160564 Alpha Plus Holdings 31/03/2025 20/10/2020 3.1193945 CLS Holding 31/03/2025 20/10/2020 3.2097450 Ladbrokes Group 31/03/2025 20/10/2020 3.3226315 Coventry 31/03/2025 20/10/2020 3.4676874 Intl Personal Finance 31/03/2025 20/10/2020 3.6609484 Eros Intl 31/03/2025 20/10/2020 3.9312322 31/03/2025 20/10/2020 4.3360434

From the table below, other things being equal, bonds with a higher YTM have a shorter duration.

 Annual Coupon Rate maturity date Payment Frequency Settlememnt date Duration Eastern Group 31/03/2025 31/03/2016 6.9316526 Anglian Water services 31/03/2025 31/03/2016 6.2930411 Alpha Plus Holdings 31/03/2025 31/03/2016 5.6846703 CLS Holding 31/03/2025 31/03/2016 5.1112132 Ladbrokes Group 31/03/2025 31/03/2016 4.5776764 Coventry 31/03/2025 31/03/2016 4.0882816 Intl Personal Finance 31/03/2025 31/03/2016 3.6456811 Eros Intl 31/03/2025 31/03/2016 3.2506123 31/03/2025 31/03/2016 2.9019598

Below is a table that can be used to verify that other things being equal, bonds with a longer time to maturity have a longer duration

 Annual Coupon Rate maturity date Payment Frequency Settlememnt date Duration Eastern Group 31/03/2020 31/03/2016 3.5040672 Anglian Water services 31/03/2030 31/03/2016 9.5829404 Alpha Plus Holdings 31/03/2040 31/03/2016 13.3050066 CLS Holding 31/03/2050 31/03/2016 15.6624977 Ladbrokes Group 31/03/2060 31/03/2016 17.1812359 Coventry 31/03/2070 31/03/2016 18.1674382 Intl Personal Finance 31/03/2080 31/03/2016 18.8097703 Eros Intl 31/03/2090 31/03/2016 19.2282690 31/03/2100 31/03/2016 19.5006290

QN2. Mortgages

1. Taking a £500000 payable 5 years.

He should take a mortgage plan that covers most of the project and with a reduced overall cost. In the case of Barclays, a mortgage plan of 3.9% total cost that covers 85% of his project and with a smaller initial interest rate of 3.49 is more convenient.

Taking the overall cost rate and without amortization, the monthly payment is £9,185.71 achieved using excel as shown in the excel sheet.

1. Taking £500000 payable 25 years.

It is a wise decision to take a mortgage that will cover the highest percentage of the job even if the costs are a bit higher. This is because the costs will be spread over very longer period of time such that they may be easily manageable. In this case, a loan which covers 90% of the project is available at 4.1% overall cost and it is the best. Although it’s initial interest rate is higher by percentage, it is lower by actual value. The monthly payment for the said mortgage is £2,666.87 as computed from excel.

C. In this assignment, without any procedure in selecting the bank, the bank chosen is the Bank of Scotland. It is then subject to the selection criterion for a 5 year and 25 year mortgages similar to those of Barclays. It includes the deposit (Opposite of loan to value for Barclays), and the total cost for the loan. The selected conditions are then computed for the monthly payments just like for Barclays as seen in the excel sheet.

D. Below is the comparison of the Bank of Scotland and Barclays.

 Annual rate Monthly payments Barclays £500,000.00 -£9,185.71 £500,000.00 -£2,666.87 Bank of Scotland £500,000.00 -£9,253.46 £500,000.00 -£2,694.71

In both the cases, the Barclays Mortgage is cheaper. However, the difference between the 5 year plan is bigger compared to the difference between 25 year plan. On a general assessment, the difference may not be significantly big.

E. For both cases, based on the monthly payments, I would choose Barclays.

Qn.3. Stock Portfolios

The stocks selected are for Google and Microsoft. The workout is as shown in excel sheet

3a. Expected returns.

The average daily expected returns for the month of February is as follows :

Microsoft= -0.33%

3b. See the excel sheet

3c. Variances and std deviations of Microsoft and google for the Feb

variance

Std deviation

0.000316

Microsoft

 0.000291

3d. Covariance between Microsoft and Google is 0.00016509 as can be seen from the excel sheet results.

3.e Correlation coefficient between the two returns is 54.46% and is a positive correlation

3.f The following is the constructed portfolio and the efficient frontier curve

Table a: Constructed portfolio

 Microsoft mean return Variance

Figure: The efficient Frontier plot

3.g The minimum variance portfolio

The minimum variance portfolio occurs at the most efficient point as located on the graph. This is at the point where the mean return is -0.353%. At this point he variance is 0.00023

3.h There are two points when there is minimum variance of 0.00023. At risk is 1.53% for both the returns of -0.353% and -0.348%. Based on the efficiency theory, the point that is taken as the minimum point is when portfolio returns are highest. i.e -0.348%