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

  What factors influence a u.s. business firm to go overseas

What factors would influence a U.S. business firm to go overseas? Prepare a 250- to 300-word analysis and feel free to incorporate your consideration for non-financial factors.

  Function of the job description paper

The primary function of the job description paper is to increase students understanding of their current or prospective job position. The following areas of the job description should be considered:

  Compute-net worth per share

Hoover Inc. has current assets of $360,000 and fixed assets of $640,000. Current liabilities are $90,000 and long-term liabilities are $160,000.

  Assume that the defaults of bank a bank b and company r are

bank a has exposure to usd 100 million of debt issued by company r. bank a enters into a credit default swap

  The relationship between sales and supportive employment

Describe the relationship between sales and supportive employment

  What effect would the use of straight line depreciation

What effect would the use of straight-line depreciation have on the lease-buy decision? If, at the end of six years, the computer system is expected to have an actual salvage value of $5,000, what would be the impact on the net advantage of leasing?

  Is he liable as an indorser why or why not

He contended that the check had not been dishonored within the time allowed by law. Is he liable as an indorser? Why or why not? Can you please go into detail as the wording of this question throws me off a little bit.

  What is the closing spot rate in dollars per yen

What is the closing spot rate in dollars per yen S1$/¥? By what percentage does the dollar depreciate against the yen?

  Tests of significance

Throughout this assignment you will review mock studies.  You will needs to follow the directions outlined in the section using SPSS and decide whether there is significance between the variables.

  How many of your shares of stock in m and s

How many of your shares of stock in M and S must you sell to offset the leverage that the firm is assuming? Assume that you loan out all of the funds you receive from the sale of your stock.

  How you intend to ensure the organizations vision mission

write a proposal of no more than 750 words outlining the research approach you will use for your strategic plan due in

  Suppose that the federal reserves balance sheet contains in

suppose that the federal reserves balance sheet containstotal assets with float appearing as an asset 600treasury

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