On September 1, 2012, an investor purchases a $10,000 par T-bond that matures in 12 years. The coupon rate is 6 percent and the investor buys the bond 70 days after the last coupon payment (110 days before the next). The ask yield is 7 percent. Find the dirty price of the bond.

please show how to do in excel