Coursework c1 (50%
Q1. Bond price, yield and duration exercises
Go to the London Stock Exchange’s bonds’ website
Choose 3-4 bonds. Fixed coupon rate bonds only.
Bonds with the coupon rate < YTM will be priced at a discount;
Bonds with the coupon rate > YTM will be priced at a premium;
Bonds with the coupon rate = YTM will be priced at the face value.
Other things being equal, bonds with a higher coupon rate have a shorter duration;
Other things being equal, bonds with a higher YTM have a shorter duration;
Other things being equal, bonds with a longer time to maturity have a longer duration.
If you have difficulties in finding a pair of two bonds that are equal in maturity and YTM or coupon rate, it is acceptable that one of the bonds is real while the other is hypothetical.
Q2. You are required to construct stock portfolios with returns on two stocks or two stock market indices. You can download stock return data from yahoo finance or other sources. The data can be of any frequencies and from any markets. Additionally, you need to find out a risk-free interest rate appropriate for the market you have chosen.
Q3. VaR exercises
Download returns on two or more stocks from yahoo finance or other sources. The data can be from any markets.
Higher VaR losses with higher volatilities, other things being equal;
Higher VaR losses with tighter criteria, other things being equal.
Provide all data and workings on excel. Write in word a narrative for each of the questions that summarises your results with pertinent analysis. The guideline for the length of a narrative is 200 words 25%. Printing/reporting numbers only without analysis, interpretation and explanation will earn no marks.
Submit both excel and word documents on Moodle.
Coursework c2 (50%)
Q4. What are financial models? Explain the concept of parsimony when building a model.
Q5. A basic model is shown by the equation: Y = α + β*X. Explain what α and β are, what happens when β = 0?
Q6. What are confidence intervals in statistics? What does it mean if a variable is significant at the 5% level?
One of the reasons students go to university is in order to earn higher wages in their future career. Questions 7 to 12 are an investigation of the ‘return to education’, the causes of wage differentials in general and the important factors in designing a good financial model. Use the excel file on Moodle called ‘Wages in the USA’; a sample of 534 real people giving details of their hourly wages and other variables.
Q7. Prepare a table of ‘descriptive statistics’. This will include the minimum, maximum, mean and standard deviation of each of the variables.
Q8. Regression model 1 is:
Run regression model 1 and prepare a table of the most important results including coefficients, significance and model fit. Prepare a scatter chart showing the line of best fit. How much on average do wages rise for each additional year of education?
Q9. Regression model 2 is:
Run regression model 2 and prepare a table of the most important results including the coefficients, significance and model fit. How much on average do wages rise for an additional year of education or experience in this model? Why are these results different to model 1?
Q10. Regression model 3 is:
Run regression model 3 and prepare a table of the most important results including the coefficients, significance and model fit. Gender is a dummy variable; explain dummy variables and discuss the differences in wages between men and women using these results.
Q11. Prepare a correlation matrix of all of the variables. Use the matrix to discuss the importance of each variable for wages as well as the relationships between the variables.
Q12. Regression model 4 is:
Run regression model 4 and prepare a table of the most important results including the coefficients, significance and model fit. Discuss these results and possible problems with this model. Suggest ways the model could be improved.
Guidance for coursework part C2
Read each part carefully. Ensure that your answer is focussed on directly answering each question. Number your answers.
Use Arial 12 – point font with 1.5 line spacing. Coursework part 2 is expected to have between 1,400 and 1,800 words.
The section will be marked on the following criteria:
The deadline for submission of this coursework on Moodle is 12.00 noon on Monday 10th May 2021.
Academic offences, including plagiarism, are treated very seriously in the Plymouth Business School. You may be asked to attend a meeting to discuss the originality of your assignment.
A student who is proven to have committed an academic offence may be placing his or her degree in jeopardy. It is your responsibility as a student to make sure that you understand what constitutes an academic offence, in particular, what plagiarism is and how to avoid it. Please read the guidance on the university intranet:
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more