Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you show me how to do this question? I can't fit the full data sheet onto here as it is too long but can

Can you show me how to do this question? I can't fit the full data sheet onto here as it is too long but can you show me the working out of how to do this question on Excel, thank you!

image text in transcribed

Daily USD/GBP Spot and Forward Rates
1GBP=USD
Spot Forwards
ON 1 Week
GBP= GBPONV= GBPSWV=
Bid Price Bid Price Bid Price
01/01/2016 1,4743 1,477952 1,474311
04/01/2016 1,4715 1,472285 1,472318
05/01/2016 1,4671 1,466784 1,466799
06/01/2016 1,4626 1,462791 1,462795
07/01/2016 1,4615 1,461897 1,461893
08/01/2016 1,4517 1,452493 1,45249
11/01/2016 1,4538 1,453695 1,453696
12/01/2016 1,4443 1,443894 1,443897
13/01/2016 1,4406 1,443191 1,443202
14/01/2016 1,4413 1,440493 1,440501
15/01/2016 1,4254 1,425696 1,425698
18/01/2016 1,4241 1,423581 1,423602
19/01/2016 1,4155 1,416992 1,417005
20/01/2016 1,419 1,417393 1,417405
21/01/2016 1,4217 1,422698 1,422695
22/01/2016 1,4263 1,426997 1,426992
25/01/2016 1,4247 1,425103 1,425093
26/01/2016 1,435 1,434894 1,434897
27/01/2016 1,4229 1,424388 1,424395
28/01/2016 1,4357 1,435293 1,435302
29/01/2016 1,4245 1,424484 1,424495
On Thursday, June 23,2016 , electorate in the United Kingdom and Gibraltar voted in the referendum on whether to Remain or Leave the European Union. Voting started at 0700BST and finished at 2200BST. The final result was announced at 0720BST, June 24, 2016. We will take a look at the exchange rate movements during this period. Sheet "Part IIIA" includes daily data in 2016 (Jan 1 Dec 30) covering the spot, overnight (ON) and one-week forward rates for GBP-USD pair. Sheet "Part IIB" includes the daily LIBOR rates for GBP and USD in per annum terms (the day count per year for GBP and USD are 365 and 360 days respectively) 2. 1. Find the rate of change of the spot rate St:et+1=St+1/St. Plot the time-series of et+1. Report the mean, standard deviation, max and min of e. Find out the dates for the max, min. (15 marks) On Thursday, June 23,2016 , electorate in the United Kingdom and Gibraltar voted in the referendum on whether to Remain or Leave the European Union. Voting started at 0700BST and finished at 2200BST. The final result was announced at 0720BST, June 24, 2016. We will take a look at the exchange rate movements during this period. Sheet "Part IIIA" includes daily data in 2016 (Jan 1 Dec 30) covering the spot, overnight (ON) and one-week forward rates for GBP-USD pair. Sheet "Part IIB" includes the daily LIBOR rates for GBP and USD in per annum terms (the day count per year for GBP and USD are 365 and 360 days respectively) 2. 1. Find the rate of change of the spot rate St:et+1=St+1/St. Plot the time-series of et+1. Report the mean, standard deviation, max and min of e. Find out the dates for the max, min. (15 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Real Estate Finance

Authors: Wolfgang Breuer, Claudia Nadler

2012th Edition

3834934496, 978-3834934499

More Books

Students also viewed these Finance questions

Question

Have I incorporated my research into my outline effectively?

Answered: 1 week ago