Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please assist with the below including Excel calculations. I've done it myself but I just want to make sure I did it correctly logic-wise. Thanks!

image text in transcribed

Please assist with the below including Excel calculations. I've done it myself but I just want to make sure I did it correctly logic-wise. Thanks!

image text in transcribed
Q4: Currency Swap Value On September 15th, 2013, ABC bank entered into a 2-year currency swap contract with GV Manufacturing, paying Euro fixed 6% and receiving USD floating with notional principal of $133 million and 100m . The semi- annual settlements are on every September 15 and March 15 until maturity. It is now November 15th, 2013, two months after the contract start date. The spot FX rates on 9/15/2013 and 11/15/2013 are $1.33 and $1.30 per E1.00, respectively. The new term structure of interest rates on 11/15/2013 are in the table below. The day count method used is 30/360. The 6-month LIBOR rate at the last payment date was 5%. A. What is the present value of all the cash flows of the floating leg (in USD) on 11/15/2013? B. What is the present value of all the cash flows of the fixed leg (in Euro) on 11/15/2013? C. What is the present value of the swap to ABC bank on 11/15/2013? Notional principal $133,000,000 ( 100,000,000 Swap EURO Fixed Rate 6.00% 6-mo LIBOR (USD) on 15SEP2013 5.00% FX rate $1.30 per E1.00 on 11/15/13 Day count 30 360 Settlement Period 180 Term Structure of Interest Rates 11/15/13 Maturity LIBOR (US $) EURIBOR 3/15/14 6.40% 6.00% 9/15/14 6.40% 3.50% 3/15/15 7.00% 6.50% 9/15/15 7.00% 7.00% ANSWERS A. Value of Floating Leg (in USD) B. Value of Fixed Leg (in Euro) C. Value of the swap (in USD) >>> >> Show your calculation below >>>> > > > >

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

International Financial Management

Authors: Geert Bekaert, Robert Hodrick

3rd edition

1107111820, 110711182X, 978-1107111820

More Books

Students also viewed these Finance questions