- 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
- Category:Finance & Accounting
- Document type:Coursework
- Level:Undergraduate
- Page:2
- Words:1053
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
-
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.
-
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 :
Google=-0.38%
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 |
|
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%