Spring Finance Assingment Help With Solution

Part I:
You have Treasury bond quotes on February 15, 2015. The dataset is at the course homepage
named the. hw1data spring15xls. There are three sets of the data: First set has 5 Treasury
securities, second part has 2 Treasuries and third set has 1 Treasuries. Note that quoted
prices are full prices.
A. For all Treasuries in the data (i.e. both first, second and third set Treasuries):
1. Find the bid and ask prices of the Treasury bill for a $100 face value. Use ask prices
for below questions.
B. For this part, use only the 5 bonds in the first set.
2. Using bootstrap method long way, extract zero coupon bonds
3.
a) Using short way of matrix inversion extract zero coupon bonds
b) Calculate spot rates of every six months up to 3.5 years
c) Plot the spot rate curve
C. For this part, use first and second set, i.e. total of 7 Treasuries
4.
a) Using regression methods, extract zero coupon bonds. (Note: Force the
intercept to zero in the regression).
b) Calculate 6 month spot rates
c) Plot the spot rate curve
d) Compare the spot rates with the ones you found by bootstrapping. Are
they different? Why? Why not?
Şenay Ağca, George Washington University
2
D. For this part, use all 8 Treasuries, i.e. first, second, and third sets.
5. Using regression methods, find zeros semiannually until year 3 and the annually until
year 4. (Note: Force the intercept to zero in the regression).
6. Using polynomial spline method of order 3
a) Fit the zero curve to find the zero for year 3.5.
b) Calculate 6 month spot rates for 4 years and plot the spot rate curve
7. Using exponential spline method of order 3
a) Fit the zero curve to find the zero for year 3.5. Take initial values of ,
1, 2, 3, and  as 0.01 while using the Solver.
b) Calculate 6 month spot rate for 4 years and plot the spot rate curve
c) Using the zeros, find 6 month forward rates after 6 months, 1 year, 1.5
years, .. up to 3 years.
8. Using Nelson-Siegel method
a) Fit the spot curve to find the spot rate for year 3.5. Take initial values of
, 1, 2, and  as 1 while using the Solver.
b) What are the 6 month spot rates for 4 years? What are the 6 months
zeros? Plot the spot rate curve.
9.
a) Using the zero coupons you have extracted by polynomial method, find
the price of a coupon bond X that pays 1% coupon semiannually and
that has time to maturity of 4 years. Take the face value of the bond as
$1000.
b) Using the zeros you have extracted and fit in using expoenential spline
method, find the Fisher-Weil duration.
– If the yield curve shifts up by 1 percent, what is the new price of
Bond X? using only duration measure?
(Hint: Use spot rate of 4 year as the yield.)

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id support@assignmentconsultancy.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id assignmentconsultancy.help@gmail.com and support@assignmentconcultancy.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Features

Features for Assignment Help

Zero Plagiarism
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.

Relevancy
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.

Three Stage Quality Check
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.

100% Confidential
All our works are kept as confidential as we respect the integrity and privacy of our clients.

Related Services

Part II:
Suppose on 12/31/2014, you are expecting that the yield curve will steepen. You want to enter
into a spread trade using $100 million face value of 2-year bond and a corresponding amount of
20-year bond. The quotes related to these bonds on 12/31/2014 are below. Note that quoted bid
and ask prices are full prices. Take one year as 360 days. Also note that you ARE NOT a bond
dealer, so buy at the ask and sell at the bid.
Quote Date Maturity date Coupon rate Bid Ask Pvbp
12/31/2014 12/31/2016 3.00% 99.87 99.92 0.0122
12/31/2014 12/31/2034 4.50% 113.62 113.71 0.134
10. How much will you buy or sell of 2-year bond on 12/31/2014 for the spread trade? Will you
buy or sell $20 million face value of 20-year bond? Why did you buy/sell of each bond? (Use
mid dirty prices to find the amounts)
To finance this transaction you decided to enter into a 2-day repo transaction. The repo dealer
offers 1.00% on reverse repo and 1.25% on repo transaction. Also, the repo dealer gets 0.5%
haircut. After 2 days the quotes are as follows:
Quote Date Maturity date Coupon rate Bid Ask Pvbp
1/3/2008 12/31/2009 3.00% 99.93 99.95 0.0124
1/3/2008 12/31/2027 4.50% 113.71 113.75 0.132
11.
a) Show the details of the repo transaction. What is the profit (loss) on repo
transaction?
b) Show the details of the reverse repo transaction. What is the profit (loss)
of the reverse repo transaction?
c) What is the total profit (loss) of these two transactions?
d) What is the return on your own capital from these transactions?
e) If you haven’t used repo and reverse repo market, what would be your
return on profit? Why is it different than (d)? Where does the difference
come from?
f) Were you correct at predicting steepening of yield curve? Why? Why
not? Be specific.

Product Code :Fin270

To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)

You can also email us at assignmentconsultancy.help@gmail.com but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.

Summary