BU232 Homework 1.1 – T-bond Prices and Yields
To Buy this Class Copy & paste below link in your Brower
http://homeworkregency.com/downloads/bu232-homework-1-1-t-bond-prices-and-yields/
Or Visit Our Website
Visit : http://www.homeworkregency.com
Email Us : homeworkregency@gmail.com
BU232 Homework 1.1 – T-bond Prices and Yields
Homework 1.1 – T-bond Prices and Yields
I.
Consider the Treasury bonds below with principal of $1,000,000, where “today” is
13 January 2016:
1. Find the bid and asked prices and the bid-asked spread for Bond 1
Bid price = $______1030703_________
Asked price = $______1031016_________
Bid¬Asked spread = $____313______
2. Using Excel’s date function find the remaining maturity in years for Bond 1
Maturity = ___28.84__ years
3. If Bond 1 is sold “today” find the bond’s invoice price
AI = $____4862.64______, Invoice price = $___1035253.64____________
II.
Using Excel’s function complete the following calculations
1. Using Excel’s price function find the asked price for Bond 2
Price = $__1190938_____________
2. Using Excel’s yield function find the asked YTM for Bond 3
YTM = __2.819___ %
Prof. R. Philip Giles
BU232.720 Fixed Income
BU232 Homework 1.1 – T-bond Prices and Yields
To Buy this Class Copy & paste below link in your Brower
http://homeworkregency.com/downloads/bu232-homework-1-1-t-bond-prices-and-yields/
Or Visit Our Website
Visit : http://www.homeworkregency.com
Email Us : homeworkregency@gmail.com
BU232 Homework 1.1 – T-bond Prices and Yields
Homework 1.1 – T-bond Prices and Yields
I.
Consider the Treasury bonds below with principal of $1,000,000, where “today” is
13 January 2016:
1. Find the bid and asked prices and the bid-asked spread for Bond 1
Bid price = $______1030703_________
Asked price = $______1031016_________
Bid¬Asked spread = $____313______
2. Using Excel’s date function find the remaining maturity in years for Bond 1
Maturity = ___28.84__ years
3. If Bond...