Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be highly appreciated.
We try DIN UTRAJ Sints A Treasury bill that settles on May 18, 2016, pays $100,000...
A Treasury bill that settles on May 18, 2016, pays $100,000 on August 21, 2016. Assuming a discount rate of 3.87 percent, what are the price and bond equivalent yield? Use Excel to answer this question. (Round your price answer to 2 decimal places, Enter your yield answer as a percent rounded to 3 decimal places.) Price Bond equivalent yield rences
A Treasury bill that settles on May 18, 2016, pays $100,000 on August 21, 2016. Assuming a discount rate of 1.87 percent, what are the price and bond equivalent yield? Use Excel to answer this question. (Round your price answer to 2 decimal places. Enter your yield answer as a percent rounded to 3 decimal places.) Price Bond equivalent yield
A Treasury bill that settles on May 18, 2016, pays $100,000 on August 21, 2016. Assuming a discount rate of 3.23 percent, what are the price and bond equivalent yield? Use Excel to answer this question. (Round your price answer to 2 decimal places. Enter your yield answer as a percent rounded to 3 decimal places.) Price ____ Bond equivelent yield _____
A Treasury bill that settles on May 18, 2016, pays $100,000 on August 21, 2016. Assuming a discount rate of .64 percent, what are the price and bond equivalent yield? Use Excel to answer this question. (Round your price answer to 2 decimal places. Enter your yield answer as a percent rounded to 3 decimal places.) X Answer is complete but not entirely correct. 83,466.67 X Price Bond equivalent yield 77.742 X %
A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.30 percent and the bond has a yield to maturity of 5.85 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
porte A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 5.75 percent and the bond has a yield to maturity of 5.08 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not found intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
Problem 10-35 Duration (LO4, CFA6) A Treasury bond that settles on October 18, 2016, matures on March 30, 2035. The coupon rate is 6.15 percent and the bond has a yield to maturity of 5.64 percent. What are the Macaulay duration and modified duration? (Use the duration function in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Answer is complete but not entirely correct. 11.3694 Macaulay duration Modified duration 10.7624
A U.S. Treasury bill with 56 days to maturity is quoted at a discount yield of 1.20 percent. Assume a $1 million face value. What is the bond equivalent yield? (Do not round intermediate calculations. Enter your answer as a percent rounded to 3 decimal places.) Bond equivalent yield 18.400 % 3 decimal places
A U.S. Treasury bill with 79 days to maturity is quoted at a discount yield of 1.55 percent. Assume a $1 million face value. What is the bond equivalent yield? (Do not round intermediate calculations. Enter your answer as a percent rounded to 3 decimal places.) Bond equivalent yield
six-month Treasury bill and a nine-month bill both sell at a discount of 8%. a-1. Calculate the annual yield of the six-month Treasury bill. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Annual yield % a-2. Calculate the annual yield of the nine-month Treasury bill. (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Annual yield % Answers are NOT 8.16 or 8.08 respectively.