Cemex, a large cement provider, issued a 10 percent coupon interest rate, 10-year bond with a $1,000 par value. The market rate (YTM) for a bond like this is 11 percent.

a.) How much should this bond sell for in the marketplace?

b.) If Cemex is issuing 100,000 bonds, how much should the company raise exclusive of any investment banking fees?

**Please demonstrate how to calculate this in Microsoft excel**