PLEASE SOLVE IN EXCEL WITH FORMULAS Find the value today of a 7 year old swap with 3 years remaining maturity The swap calls for exchanging interest only on 10m at 5 percent for $15m at 3 percent SEMIANNUAL payments The last payment was yesterday Todays exchange rate is $1 30 and the AAA rate in the U S is 2 0 and 2 5 in the euro zone USD Amount $15,000,000 00 USD Interest Rate 3 00 EUR Amount 10,000,000 00 EUR Interest Rate 5 00 Spot Exchange Rate Inflation $0 125000 Term Years 10 00 Payments yr (choose) Semi Annually Payments yr (calculated) 2 USD level interest payment $300,000 00 EUR level interest payment 250,000 00 Intermediate Time (less than initial swap maturity) 7 Remaining payments (calculated) 6 New Spot Exchange Rate $1 30000 New USD interest rate 2 00 New EUR interest rate 2 50 PV remaining USD payments PV remaining EUR payments USD value PV remaining EUR payments USD swap value (to party paying USD)

The Answer is in the image, click to view ...

Question: PLEASE SOLVE IN EXCEL WITH FORMULAS: Find the value today of a 7-year old swap with 3 years remaining maturity. The swap calls for exchanging

PLEASE SOLVE IN EXCEL WITH FORMULAS:

Find the value today of a 7-year old swap with 3 years remaining maturity. The swap calls for exchanging interest only on 10m at 5 percent for $15m at 3 percent. SEMIANNUAL payments. The last payment was yesterday. Todays exchange rate is $1.30/ and the AAA rate in the U.S. is 2.0% and 2.5% in the euro zone.

USD Amount	$15,000,000.00
USD Interest Rate	3.00%
EUR Amount	10,000,000.00
EUR Interest Rate	5.00%
Spot Exchange Rate @ Inflation	$0.125000
Term
Years	10.00
Payments/yr (choose)	Semi Annually
Payments/yr (calculated)	2
USD level interest payment	$300,000.00
EUR level interest payment	250,000.00

Intermediate Time (less than initial swap maturity)	7
Remaining payments (calculated)	6
New Spot Exchange Rate	$1.30000
New USD interest rate	2.00%
New EUR interest rate	2.50%

PV remaining USD payments
PV remaining EUR payments
USD value PV remaining EUR payments
USD swap value (to party paying USD)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

For each item listed in the table below, input the balance for the date range 10/1/20XX to 12/1/20XX. For the Journal, input the balance for the date range 11/13/20XX to 12/1/20XX. Note: Enter your...

PLEASE SOLVE IN EXCEL WITH FORMULAS: Find the value today of a 7-year old swap with 3 years remaining maturity. The swap calls for exchanging interest only on 10m at 5 percent for $15m at 3 percent....

International Finance FINAL EXAM 2015 NAME Please print your name neatly 1. A British businessman has just completed transactions in America and Italy. He is now holding $250,000 and 250,000 and...

Find the value today, in euro, to the party paying euro of an 8-year old swap with 2 years remaining until maturity. At initiation of the swap, spot exchange rates were S 0 ($/) = $1.16/, S 0 ($/) =...

Find the value today in euro to the party paying euro of an 8-year old swap with 2 years remaining maturity. At initiation of the swap, spot exchange rates were S 0 ($/) = $1.16/, S 0 ($/) = $1.45/,...

A swap established 4 years ago has 3 years remaining maturity. The swap calls for exchanging interest only on euro10m at 5% for 15m at 3%. Assume semiannual payments and the last payments were...

please provide step by step explanation about how to do this problem. Question 1 0 / 10 pts Calculate the value today in Great British Pounds to the party paying pounds of an 8- year old swap with 2...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

ABC Enterprises began business on October 1, 2019. Below is the monthly payroll for ABC Enterprises, Inc. All employees are on salary and receive the same amount each month. Last First Name Name...

The demand for personal loans has increased and so M/s MNC, a leading bank, has launched a new application Insta loan and wants to leverage the emerging technologies to drive business growth. The...

IM Enterprises sells two products, Crunchies and Munchies. Crunchies have a 32 percent contribution margin and Munchies have a 35 percent contribution margin. Profit earned from each box of Crunchies...

Calculate the child tax credit for the following taxpayers. a. Jeremy is a single (head of household) father with $80,100 of AGI and has a dependent 8-year-old son: b. Jerry and Ann have $100,000 of...

Find the Volume of Solid of Revolution about y, y = 2 + cos(x), x = T, x = 27, x

Find the Volume of Solid of Revolution 1 about y, y = x = 1, y = -1, y (1+ a2)2

Assume all capacitors 10 F. Find the total capacitance. H.

Maria Young is the sole stockholder of Purl of Great Price Company (POGP Company), which produces high-end knitted sweaters and sweater vests for sale to retail outlets. The company started in...

Realiza un cuadro comparativo donde analices y expliques: Las diferencias y semejanzas entre los diferentes tipos de auditora incluyendo la auditoria adminstrativa

1 What are the advantages and disadvantages of using social media to recruit candidates? United Parcel Service (UPS) is the worlds largest package delivery company with operations in over 200...

1 Do you think that web- based recruitment and selection will eventually supplant all other methods? To what extent would this be a good thing? The use of online recruitment methods is now widespread...

7 What are the implications of the demographics in the UK for the future supply of labour?