Please show me how you do it on excel as well.

6. What is Yield to Maturity? What does it mean? What does it represent? How do we determine YTM based on one bond, or based on the market? 7. How often does the coupon rate of a bond change? 8. If a company goes into bankruptcy, who gets access to the company's resources first: bondholders or stockholders? 9. What two factors are the key determinants of a bond's rating (eg. High-Grade vs. Junk)? 10. A premium bond is priced at $1,100 (versus $1,000 par). If one year passes and market interest rates do not change at all, what will happen to the price of this bond, and why? 6. What is Yield to Maturity? What does it mean? What does it represent? How do we determine YTM based on one bond, or based on the market? 7. How often does the coupon rate of a bond change? 8. If a company goes into bankruptcy, who gets access to the company's resources first: bondholders or stockholders? 9. What two factors are the key determinants of a bond's rating (eg. High-Grade vs. Junk)? 10. A premium bond is priced at $1,100 (versus $1,000 par). If one year passes and market interest rates do not change at all, what will happen to the price of this bond, and why