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:
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!1. Find the bid and asked prices and the bid-asked spread for Bond 1
Bid price = $______1030703_________
Asked price = $______1031016_________
BidAsked 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
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
