Question $5$

As with most bonds, consider a bond with a face value of $$1,000.$ The bond's

maturity is $11$ years, the coupon rate is $3\%$ paid annually, and the market yield

$($discount rate$)$ is $17\%.$

What should be the estimated value of this bond in one year? Assume the

market yield remains unchanged.

Enter your answer in terms of dollars and cents, rounded to $2$ decimals, and

without the dollar sign. That means, for example, that if your answer is

$$127\mathrm{.}5678,$ you must enter $127\mathrm{.}57$ CAN YOU SHOW HOW TO SOLVE IN EXCEL? I GOT THE ANSWER SLIGHTLY WRONG