$***$ Need to know how to do in excel Using Excel Functions $****$

IBC company has a bond issue on the market with a $$1,000$ face value, which pays a

$13\mathrm{.}5\%$ annual coupon that will mature on this date $20$ years from now. If the current

required rate of return on debt such as IBC's is $11\%,$ what is the market value of IBC's

bond? $(5$ Points$)$