Analysis of yields derived from uk government bonds

Reference no: EM131394003

OVERVIEW

The project's aim is to perform an analysis of yields derived from UK government bonds, and evaluate the ability of specific bonds to hedge a hypothetical liability.

DELIVERABLES

Once you have completed your empirical analysis, you need to submit

an Excel workbook containing all your calculations
a short report (max 1,500 words) explaining and discussing your findings

The workbook needs to be submitted in .xlsx format. Please make sure that the workbook is as reader-friendly as possible. I would suggest that the calculations for each individual objective (see below) are presented in separate worksheets of the workbook.

The report should briefly discuss the findings that you present in the workbook. It should include tables and graphs where relevant, and should clearly indicate what you have done and what your results mean. You should focus on providing an intuitive discussion rather than reproducing chunks of theory or merely presenting statistics. The report should not exceed 1,500 words (plus tables and graphs). Any tables and graphs should be clearly labelled and referenced in the main text. The report should be divided into sections and sub-sections, including a short Introduction and a Conclusion.

DATA

The data that will be required for the empirical analysis is in the spreadsheet "Coursework_01_UK_Yields.xlsx". This file contains the daily time-series of UK yields. Maturities range from 1 month to 25 years, covering the entire term structure of UK interest rates. The sample period spans 13 years, from January 2000 to December 2012.

Attachment:- Data.rar

Reference no: EM131394003

Questions Cloud

Resolve the given dispute using steps in mediation process : Resolve this dispute using the Steps in the Mediation Process and the Mediator's guide which follows the role information. Detail what takes place at each step. In the end, describe the outcome for all parties.

How do state and local health departments interface : Which federal department in the United States is the government's principal agency for protecting the health of all Americans and for providing essential human services, especially to those who are least able to help themselves? What major service..

Discuss how the flipped classroom idea can be used : Educators strive to create a classroom that instills creativity and innovation. In this discussion, you will think about the creative and innovative instructional approach known as the flipped classroom while making direct connections to the Commo..

Discuss about the learning and innovation skills : For example, you may redesign an instructional plan with assessment plans embedded throughout or a full assessment plan including a summative assessment you may have constructed. These are just two ideas out of numerous possibilities. If you do no..

Analysis of yields derived from uk government bonds : The project's aim is to perform an analysis of yields derived from UK government bonds, and evaluate the ability of specific bonds to hedge a hypothetical liability

Identify potential risks and mitigation plans : Identify potential risks and mitigation plans. Analyze a stakeholder and include mitigation and contingency strategies. Develop a metric and target for each strategic objective using a balanced scorecard format.

What clarification do you need regarding the posting : What clarification do you need regarding the posting? What differences or similarities do you see between your posting and other classmates' postings?

How profitable are the players in the industry : How profitable are the players in the industry? What trends are occurring in the industry? What competition is in the marketplace, and what are they doing?

Explain the effects of changes in the economic environment : Explain the effects, of changes in the economic environment on a selected business. Identify how government policies impact on a selected business

Reviews

len1394003

2/14/2017 5:28:48 AM

First one is instructions and 2nd is data. There is an excel calculation and report writing. The report should briefly discuss the findings that you present in the workbook. It should include tables and graphs where relevant, and should clearly indicate what you have done and what your results mean. You should focus on providing an intuitive discussion rather than reproducing chunks of theory or merely presenting statistics. The report should not exceed 1,500 words (plus tables and graphs). Any tables and graphs should be clearly labelled and referenced in the main text. The report should be divided into sections and sub-sections, including a short Introduction and a Conclusion.

Write a Review

Required(*) Message

User Account

All Pages