I need some help with these problems using EXCEL
1. A Treasury STRIPS matures in 7.5 years and has a yield to maturity of 6.9 percent. If the par value is $100,000, what is the price of the STRIPS? What is the price quoted?
2. What is the yield to maturity on Treasury STRIPS with 10 years to maturity and a quoted price of 54:27?
Please find my response attached in an excel file. If you look at ...
The solution answers the question below.