An investor purchases a treasury bond with a quoted price of 95 and a settlement date of 7/25 (non-leap year). The bonds have a coupon rate of 4%, and a maturity date of 5/15/2040.

How much did the investor spend for this one bond?

Please show your work in excel, I'm stuck and trying to see where I went wrong. Thank you!