Question

In: Finance

Go to treasury.gov and download the daily yield rates as of June 15, 2020.

 

Go to treasury.gov and download the daily yield rates as of June 15, 2020. Calculate the yield spread between the securities with 30-year and 1-year maturities.

Solutions

Expert Solution

I have taken a screenshot of the Daily yield rates as of June 15, 2020 from treasury.gov and shared the same below for your reference.

Yield for 1-year security as of June 15, 2020 = 0.17%

Yield for 30-year security as of June 15, 2020 = 1.45%

Thus, Yield spread = 1.45% - 0.17% = 1.28%


Related Solutions

Find the current Daily Yield Curve Rates published by the Treasury. Plot the Yield curve using...
Find the current Daily Yield Curve Rates published by the Treasury. Plot the Yield curve using a line chart in Excel. Be sure to label both axes. Based upon your plot, what do you believe likely to happen to interest rates in the future?
Examine yield curve shapes using daily yield curve rates provided by U.S. department of treasury ....
Examine yield curve shapes using daily yield curve rates provided by U.S. department of treasury . a) Report treasure yield rates (1 month, 3 month, 6 month, 1 year, 2 year, 3 year, 5 year, 7 year, 10 year, 20 year, 30 year) on Jan. 02, 2014, Jan. 02, 2015, Jan. 04, 2016, Jan. 03, 2017, Jan. 02, 2018, Jan. 02, 2019, and Sep. 02, 2019. b) Compute each term spreads for seven term structures. c) Plot seven yield curves...
Choose a stock and gather 5 years of daily adjustedstock price data and download to be...
Choose a stock and gather 5 years of daily adjustedstock price data and download to be opened in Excel. Calculate the mean, median, mode, range and standard deviation of the adjusted daily closing price for this stock. Interpret these statistics and discuss relevance is the mode useful? Produce a histogram for the adjusted daily closing price Produce a time plot (scatter plot) of the closing date versus the stock price. How has the stock trended over time? Are there patterns?...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2 = 18.6% p.a. Coupons can be reinvested at j2 = 14.0% p.a. The bond will be redeemed at par on the maturity date (face value $100). a. [2 marks]Calculate the total accumulated value at maturity generated by this bond if Mordecai holds it to maturity and reinvests all coupon payments received at the available rate. b. [2 marks]Calculate the total realised compound yield (TRCY)...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2 = 18.6% p.a. Coupons can be reinvested at j2 = 14.0% p.a. The bond will be redeemed at par on the maturity date (face value $100). a. Calculate the total accumulated value at maturity generated by this bond if Mordecai holds it to maturity and reinvests all coupon payments received at the available rate. b. Calculate the total realised compound yield (TRCY) of this...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2...
Mordecai bought a 3-year 15% Treasury bond on 8 May 2020 at a yield of j2 = 18.6% p.a. Coupons can be reinvested at j2 = 14.0% p.a. The bond will be redeemed at par on the maturity date (face value $100). a. Calculate the total accumulated value at maturity generated by this bond if Mordecai holds it to maturity and reinvests all coupon payments received at the available rate. b. Calculate the total realised compound yield (TRCY) of this...
v Today is 15 June 2020. A forward contract maturing on 10 January 2021 is written...
v Today is 15 June 2020. A forward contract maturing on 10 January 2021 is written on a bond paying coupon rate 3.00% maturing on 19 October 2030, with current price 99.12. The bond pays semi-annual coupons. The OIS curve is flat at 3.10% (with continuous compounding). What is an appropriate price for the forward contract? 102.20 99.11 99.38 99.18
On 15 June 2020 Great Hall Pty Ltd reestablishes the account of one customer and records...
On 15 June 2020 Great Hall Pty Ltd reestablishes the account of one customer and records the collection of $2,200 in full payment of the account that had previously been written off. The present balance of the allowance for doubtful debts account is $1,000 CR. After the above adjustment, Great Hall Pty Ltd assigns the following probability of uncollectible to each age group of receivables as at 30 June 2020 in the below table. Age category Amount as at 30...
Tommy Shelby lives in Mahebourg. On 15 June 2020, he lost his job as bartender in...
Tommy Shelby lives in Mahebourg. On 15 June 2020, he lost his job as bartender in a hotel in the southern part of Mauritius, due to the COVID-19 pandemic. He was offered Rs200,000 as severance allowance, for his 5 years of loyal service to the hotel. Taking into consideration the craze which online purchases took during the national confinement period, he is now thinking of investing the severance allowance money, to launch an e-commerce website for the sales of products....
Required: Complete the following worksheet for Appliance Repair for the year ended 30 June 2020. (15...
Required: Complete the following worksheet for Appliance Repair for the year ended 30 June 2020. Additional information to complete the worksheet: The equipment of $67,500 was purchased on 1 March 2020. The straight-line depreciation method is used with a useful life of 3 years and a scrap value of $2,700. No depreciation is ever recorded. The $75,000 bank loan was borrowed on 1 May 2020. It is an interest only loan. The interest rate is 0.8% per month. No interest...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT