$**$CAN SOMEONE PLEASE PROVIDE THE ANSWER WITH THE CORRECT EXCEL FORMULA... THANK YOU$**$

A $6$ percent corporate coupon bond is callable in five years for a call premium of one year of coupon payments. Assuming a par value of $$1,000,$ what is the price paid to the bondholder if the issuer calls the bond?

You must use the built$-$in Excel function to answer this question. All answers should be displayed as positive numbers.

Input area:

$\backslash$table$[[$Corporate bond rate,$6\mathrm{.}00\%$