Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the answer in excel please thank you 24a) You see the following Treasury Bill and Treasury Note rates in WSJ on 2/10/2020 a.

I need the answer in excel please thank you
image text in transcribed
24a) You see the following Treasury Bill and Treasury Note rates in WSJ on 2/10/2020 a. Calculate the 2-year and 3-year spot rates b. Graph the yield curve up to 3-years c. Calculate the forward interest rates for the 6 month and the second year. Coupon Yield to Maturity Bond 1m Treasury bill 0 0.09% 3m Treasury bill 0 0.094% 0 0.1% 6m Treasury bill 0 1% 1y Treasury bill 2y Treasury Note 1 2.5% 3 2.9% 3y Treasury Note b) Assuming that the risk-free zero rates are calculated annually with continuous compounding from the above table. Calculate the price of a 2-year bond with face value of 1000, that pays 10% coupon semi- annually Focus 24a) You see the following Treasury Bill and Treasury Note rates in WSJ on 2/10/2020 a. Calculate the 2-year and 3-year spot rates b. Graph the yield curve up to 3-years c. Calculate the forward interest rates for the 6 month and the second year. Coupon Yield to Maturity Bond 1m Treasury bill 0 0.09% 3m Treasury bill 0 0.094% 0 0.1% 6m Treasury bill 0 1% 1y Treasury bill 2y Treasury Note 1 2.5% 3 2.9% 3y Treasury Note b) Assuming that the risk-free zero rates are calculated annually with continuous compounding from the above table. Calculate the price of a 2-year bond with face value of 1000, that pays 10% coupon semi- annually Focus

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance And Financial Markets

Authors: Keith Pilbeam

3rd Edition

023023321X, 978-0230233218

More Books

Students also viewed these Finance questions