Financial Modelling

Financial Modelling

Coursework c1 (50%

Don't use plagiarized sources. Get Your Custom Essay on
Financial Modelling
Just from $13/Page
Order Essay

 

Q1.  Bond price, yield and duration exercises

Go to the London Stock Exchange’s bonds’ website

http://www.londonstockexchange.com/exchange/prices-and-markets/retail-bonds/retail-bonds-search.html

Choose 3-4 bonds. Fixed coupon rate bonds only.

(35 marks)

Required:

 

  • Work out the yield with the given coupon and price.

 

  • Calculate their durations.

 

  • Using your cases to support the statements that:

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.

 

  • Verify that:

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.

 

Note:

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.

(40 marks)

Required:

 

  • Estimate the expected returns on the two stocks or stock indices.

 

  • Estimate the variances and standard deviations of the two returns.

 

  • What is the covariance between the two returns?

 

  • What is the correlation coefficient between the two returns?

 

  • Plot the efficient frontier of the portfolios constructed with these two stocks or stock indices.

 

  • Find out the minimum variance portfolio constructed with these two stocks or stock indices, solving for the weights of the two stocks or stock indices in the portfolio.

 

  • What are the expected return and risk of this minimum variance portfolio?

 

  • Construct an “optimal portfolio” with these two stocks or stock indices and solve for the weights of the two stocks in the portfolio.

 

  • What are the expected return and risk of the “optimal portfolio”?

 

Q3.  VaR exercises

Download returns on two or more stocks from yahoo finance or other sources. The data can be from any markets.

(25 marks)

 

Required:

 

  • Estimate their VaR with different criteria and different investment horizons.

 

  • Using your cases to verify that:

Higher VaR losses with higher volatilities, other things being equal;

Higher VaR losses with tighter criteria, other things being equal.

 

 

Requirements:

 

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.

(15 marks)

 

Q5.  A basic model is shown by the equation: Y = α + β*X. Explain what α and β are, what happens when β = 0?

(10 marks)

 

Q6. What are confidence intervals in statistics? What does it mean if a variable is significant at the 5% level?

(10 marks)                                                                                                              

 

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.

(10 marks)

 

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?

(10 marks)

 

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?

(10 marks)

 

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.

(10 marks)

 

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.

(10 marks)

 

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.

 

15 marks)

 

 

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:

  • All relevant parts of the question covered
  • Logically organised
  • Good presentation that is easily understandable

 

 

 

 

 

The deadline for submission of this coursework on Moodle is 12.00 noon on Monday 10th May 2021.

 

 

Plagiarism

 

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:

 

https://www.plymouth.ac.uk/student-life/your-studies/essential-information/regulations/plagiarism

 

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Home Work Stand
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Nursing
Very professional and easy to work with. I highly recommend!
Customer 452445, December 12th, 2021
Psychology
You have done a fantastic job ???? thank you.????
Customer 452445, January 14th, 2022
Human Resources Management (HRM)
Great work. Always deliver before the deadline.
Customer 452445, March 24th, 2022
Human Resources Management (HRM)
very professional work. on time, highly recommended thanks
Customer 452445, March 7th, 2022
Human Resources Management (HRM)
Awesome work! Writer articulates points well which makes it easy to read the essay!
Customer 452445, December 15th, 2021
Computer science
Great individual to work with. Always come through to provide the best services. Thank you.
Customer 452445, June 10th, 2022
Criminal law
I got an A. I recommend homeworkstand.
Customer 452445, October 31st, 2021
Classic English Literature
Wonderful writer. Pay attention to detail. Does not plagiarize. Always completes work on time!
Customer 452445, March 3rd, 2022
Social Sciences
The write was very patient with my instructions and did their best to provide quality work according to my request.
Customer 452445, November 2nd, 2021
Communications
It was a very long paper, but she followed all the instructions, and she even finished the paper 3 days before the due date
Customer 452445, June 8th, 2022
Business Studies
Remarkable work!! Always helpful and amazing communication!!
Customer 452445, January 4th, 2022
Business Studies
Amazing job on a tight deadline. Met all requirements and some. Will hire again if needed.
Customer 452445, March 3rd, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Order your essay today and save 15% with the discount code ESSAYHELP