1. (20) Suppose the following information is quoted for a hypothetical Treasury security: Issue Bid Ask Change Yield 5% 4/15/2030-B 120.20 27 6 ? a. What is the bid price per $100 of par value? b. If an investor wanted to purchase $100,000 of par value of this Treasury security, what is the clean price? c. What is the ask price per $100 of par value? d. If an investor wanted to purchase $100,000 of par value of this Treasury security, what is the clean price? e. What does the Change of 6 mean? f. What does the Yield column mean? g. Suppose that instead of a bid of 120.20 it is 120.20+. What would be the clean price per $100 of par value?

Please show with formulas in excel