Calculate the efv ee and pfe for this trade

Assignment Help Finance Basics
Reference no: EM131200543

Q1. Consider the data in the Microsoft Excel workbook YieldeurveData.xlsx. It contains the United States Treasury's "Daily Yield Curve" data (sourced from www.treasury.goy) for the years 2007 and 2015. These rates are what the US Treasury calls "CMT rates"

(see https://www.treasury.gov/resource-center/faqs/Interest-Rates/Pages/faq_aspx).

(a) Convert these rates into continuously compounded yields.

(b) Assuming a one-factor Gauss/Markov HJM model with mean reversion fixed at a = 0.1, use the data for the six-month yields to determine an appropriate choice of the volatility level σ. Do this separately for 2007 and 2015.

(c) Assuming a one-factor Gauss/Markov HJM model, use the data for the one-month and thirty-year yields to determine an appropriate choice of the mean reversion parameter a and volatility level σ. Do this separately for 2007 and 2015. Discuss the results in comparison with your results for (b) above.

(d) Suppose that at the beginning of January 2007 you have sold an at-the-money caplet covering a three-month accrual period beginning in three months' time. If you hedge this caplet with daily rebalancing using the natural hedge instruments, what would be your profit/loss when this option matures? Assume that caplet price and hedges are calculated using a one-factor Gauss/Markov HJM model with the parameters determined in (c). Assume that any profit/loss is invested/borrowed by buying/selling the zero coupon bond maturing at the same time as the option. Repeat this for a caplet sold at the end of, respectively, March 2007, June 2007, September 2007, March 2015, June 2015, and September 2015. Discuss the possible causes of profit/loss.

(e) Repeat (d) for 2015 caplets, but using the 2007 model parameters. Discuss the result.

(f) Repeat (d) for all caplets, but using as hedge instruments two zero coupon bonds, one of which initially has a time to maturity of six months, and another which initially has a. time to maturity of thirty years. Discuss the result.

Q2. Suppose that the dynamics of the default-free interest rate term structure are given by a lognormal LIBOR Market Model (i.e., assume that LIBOR. is an approximately default-free interest rate) driven by a one-dimensional Brownian motion, where the relative volatility of forward LIBOR is given by the deterministic function

λ(t, T) = ξe-α(T-t)

with ξ = 0.15 and α = 0.05.

The current term structure is flat at 5% continuously compounded for all maturities. Sup¬pose further that the CDS spreads (annual, in arrears, in basis points) for a corporate entity A are deterministic and given by:

Maturity

1 yr        

2 yrs

3 yrs

5 yrs

10 yrs

Spread

180

190

220

250

270

Assume that default, recovery in default, and default-free interest rates are mutually independent. Expected recovery is 40%. You may ignore accrued interest in the case of default. Entity A approaches a bank of negligible default risk, with the wish of A to enter into a 10-year interest swap, where A pays floating and receives fixed annually, with simple compounding. Where necessary, you may use the "frozen coefficient" approximation discussed in class.

(a) In a manner analogous to the case of counterparty credit risk in a Gauss/Markov HJM model covered in the spreadsheet discussed in class, calculate the EFV, EE and PFE for this trade.

(b) Taking into account counterparty credit risk, what is the level of the fixed coupon on this swap, which results in a zero initial mark-to-market value of the swap? If some of the above assumptions are relaxed, in which case would the bank be exposed to "wrong-way risk" in this transaction?

(c) Suppose the bank has an existing swap with the same counterparty, where the bank pays floating and receives fixed annually, with simple compounding. This swap has exactly three years left to run, and the fixed leg was set at 4.75% (simple compounding). In this situation, what is the answer to (b) if there is no netting agreement in place? If there is a. netting agreement in place?

Attachment:- Yield Curve Data.rar

Verified Expert

The data in the Microsoft Excel workbook YieldeurveData.xlsx. It contains the United States Treasury's "Daily Yield Curve" data for the years 2007 and 2015. These rates are what the US Treasury calls "CMT rates". First we convert these rates into continuously compounded yields. And then assuming a one-factor Gauss/Markov HJM model with mean reversion fixed at a = 0.1, use the data for the six-month yields to determine an appropriate choice of the volatility level s. did this separately for 2007 and 2015. In same rules we follows and completed the all task.

Reference no: EM131200543

Questions Cloud

How does he get a single pint in either glass : A bartender has a three-pint glass and a five-pint glass. A customer walks in and orders four pints of beer. Without a measuring cup but with an unlimited supply of beer how does he get a single pint in either glass?
Various capital budgeting methods : Define the various capital budgeting methods such as net present value (NPV), internal rate of return (IRR), and so on, and explain how they differ from one another. Identify which, if any, of the methods discussed might be superior to the others ..
Investor to factor into the decision-making process : Identify and define up to three concepts associated with making capital investment decisions such as cash flows, sunk costs, opportunity costs, or others. Discuss why your selected concepts are important for the investor to factor into the decisio..
Provide the journal entries for the given purchases : If required please provide me with the journal entries for the following purchases; and net income and dividends paid.
Calculate the efv ee and pfe for this trade : In a manner analogous to the case of counterparty credit risk in a Gauss/Markov HJM model covered in the spreadsheet discussed in class, calculate the EFV, EE and PFE for this trade
Method available for resolving construction contract dispute : What alternate dispute resolution (ADR) methods arc available for resolving construction contract disputes?- What advantages do these methods have over cou proceedings?
What is the balance in the account : a. What is the balance in the account after 3years? How much of this balance corresponds to"interest on interest"? b. What is the balance in the account after 27years? How much of this balance corresponds to"interest on interest"?
Prepare the required journal entries for restin company : Prepare the required journal entries for Restin Co. Prepare the December 31, 2014, journal entry to record bad debt expense. Prepare the journal entry for Arness to record the sale.
Create the first page using a word processor : Prepare a two-page report on why you selected engineering, what discipline you wish to enter, the possible career paths you might follow, and why. Create the first page using a word processor. Create the second page using a different word processo..

Reviews

len1200543

9/9/2016 7:11:50 AM

Your assignment must be submitted electronically (Microsoft Excel or Open. Of workbook and a text document — Microsoft Word or PDF). The text document must be typeset (using for example Microsoft Word or BTEX). On all tasks, implement your calculations in a Microsoft Excel or Open Office workbook (you may use VBA if you wish) and in an accompanying document (PDT', RTF or Microsoft Word) supply a brief explanatory text, providing where appropriate a mathematical justification for your calculations and an interpretation of your results. Any sources used in the preparation of the assignment must be properly cited.

len1200543

9/9/2016 7:11:42 AM

Need it perfect and accurate, this is 50% weightage and I want HD marks anyhow to clear this semester, please do your best and as explained in the introduction of the assignment, the calculations should be in the excel sheet and the explanations should be in word, Calculation in the spreadsheet provided and explanation in word.

Write a Review

 

Finance Basics Questions & Answers

  You notice that dell computers has a stock price of 2785

you notice that dell computers has a stock price of 27.85 and eps of 1.26. its competitor hewlett-packard has eps of

  What are the three rules in the gold standard foreign

question 1. what are the three rules in the gold standard foreign exchange rate system? briefly describe the gold

  Will security prices increase decrease or stay the same

Will security prices increase, decrease, or stay the same following this announcement? Does it make any difference whether the 2 percent figure was anticipated by the market? Explain.

  What is the amount of cash received

Buehler Company on June 15 sells merchandise on account to Chaz Co. for $1,000, terms 2/10, n/30. On June 20, Chaz Co. returns merchandise worth $300 to Buehler Company. On June 24, payment is received from Chaz Co. for the balance due. What is t..

  Kingrsquos mfg inc has 12000 bonds outstanding that have a

kingrsquos mfg. inc. has 12000 bonds outstanding that have a 6 coupon rate. the bonds are selling at 98 of face value

  What is the dollar amount of interest paid

Horizon Telecom sold $300,000 worth of 120-day commercial paper for $298,000. What is the dollar amount of interest paid on the commercial paper? What is the effective 120-day rate on the paper?

  Breckenridge skicompany has total assets of 422235811 and

breckenridge skicompany has total assets of 422235811 and a debt ratio of 29.5 percent. calculate the companys

  What is the effective annual interest rate

The interest rate is 0.574 percent per month. In addition, 5 percent of the amount that you borrow must be deposited in a noninterest-bearing account. Assume that your bank uses compound interest on its line-of-credit loans.

  Calculate datametrix enterprise value as of the end

Because Datametrix is in its startup stage, management and venture investors believe that 35 percent is an appropriate weighted average cost of capital (WACC) discount rate until the firm reaches its long-run or perpetuity growth rate. At that time, ..

  Provide any analysis to justify your decisions

You do not have to provide any analysis to justify your decisions. You must only provide some reason for picking that company.

  Question regarding the black-scholes model

The interest rate is 8.33 percent per year, continuously compounded. Assume that Black-Scholes model accurately determines the current market price of the option.

  Suppose the company just paid dividend of 1 the dividends

1 suppose the company just paid dividend of 1. the dividends are expected to grow at 20 in year 1 and 15 in year 2.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd