Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show all below calculations in Excel. Q2:Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a

Please show all below calculations in Excel.

image text in transcribed

Q2:Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-month, and 11 - month, are 6.5%, 7%, 7.5%, and 8%, respectively. The 3-month LIBOR rate at the last payment date was 6%. Estimate the value of the swap to ABC Bank by estimating the values of the floating leg and the fixed leg. Use the 30/360 day count method. A. The present value of the fixed leg? B. The present value of the floating leg? C. The value of the swap to ABC bank? B PV (fixed leg) PV (floating leg Swap Value to ABC >>>>> Show your calculation below >>>>>>>> Q2:Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-month, and 11 - month, are 6.5%, 7%, 7.5%, and 8%, respectively. The 3-month LIBOR rate at the last payment date was 6%. Estimate the value of the swap to ABC Bank by estimating the values of the floating leg and the fixed leg. Use the 30/360 day count method. A. The present value of the fixed leg? B. The present value of the floating leg? C. The value of the swap to ABC bank? B PV (fixed leg) PV (floating leg Swap Value to ABC >>>>> 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

Quantum Economics And Finance

Authors: David Orrell

3rd Edition

1916081630, 978-1916081635

More Books

Students also viewed these Finance questions