Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. solve a,b, and c using excel. please provide the

Solve A,B, and C using excel. please provide the excel sheets and formulas used...

60.1K

Verified Solution

Question

Finance

Solve A,B, and C using excel.
please provide the excel sheets and formulas used on excel to solve. image
A firm has borrowed $100m by selling bonds in the US on which it pays a fixed coupon rate. This money was used to build a plant in Germany and all the sales from this plant are in Euros. The firm is facing currency risk because if Euro depreciates then the amount received in $ will go down. So the firm decides to enter into a currency swap with a notional principal of $100m. The swap will be for 2 years with fixed rate payments being exchanged on days 180,360,540 and 720. You also have the following information: So = $1.20/. Term (days) $ Rate (r) Rate (re) 180 3.50% 2.80% 360 3.60% 3.00% 540 3.80% 3.40% 720 3.90% 3.50% a. Calculate the fixed coupon rate for the dollar and Euro. b. Calculate the expected cash flows on days 180, 360, 540 and 720 in dollar terms. c. Calculate the PV of the CFs calculated in b

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students