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 is the current value of the swap

The 6-month LIBOR rate at the last payment date was 10.2% (with semiannual compounding). What is the current value of the swap?

  Manage risk and enhance returns in stock portfolio

So far, things have gone well with Dr. Bueller. Before you wrap up your meetings and he begins investing, you decide to spend a little time sharing information with him about using derivatives to manage risk and enhance returns in his stock portfo..

  A critic of state unemployment insurance programs

A critic of state unemployment insurance programs stated that "unemployment insurance programs are designed to maintain economic security for unemployed workers, but several critical problems must be resolved."

  Calculate the sales mix variance

In addition, the company expects to sell 400 ink pens, with the a contribution margin of $6, but the actual sales is 500 units. Calculate the sales mix variance. Show your calculations in steps.

  How much do you need to save each month for this purpose

How much do you need to save each month for this purpose assuming that you have no money saved as of today ?

  What is the value of the stock to an investor

An Allied Northern preferred stock pays a $3.84 annual dividend. What is the value of the stock to an investor who requires a 9.5% return?

  Long-term debt position of two firms

Jones Company has long-term debt of $1,000,000, whereas Smith Company, Jones' competitor, has long-term debt of $200,000. Which of the following statements best represents an analysis of the long-term debt position of these two firms?

  What effective interest rate per month compounded

what effective interest rate per month compounded continuously would be required for a single deposit to triple in

  What is a firms fundamental or intrinsic value what might

what is a firms fundamental or intrinsic value? what might cause a firms intrinsic value to be different than its

  Compute a more correct estimate of portfolio risk

Compute a more correct estimate of portfolio risk

  Suppose interest rate differential in dollar and swiss

suppose interest rate differential in dollar and swiss francs is 4 percent per annum u.s. and swiss interest rates are

  The acquisition was successful home depot company

The acquisition was successful Home Depot Company

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