Please solve this in Excel and show the process.

Bond Z, which is an annual coupon bond, has one year left to maturity. The coupon rate is 6% and the face value is $1,000. The issuer has a 12% probability of default. If the expected return is 8% and the default risk premium is 3.70%, what is the expected recovery (dollar) amount in case of default? \begin{tabular}{c} $786.10 \\ \hline$806.20 \\ \hline$739.60 \\ \hline$767.40 \\ \hline$753.20 \end{tabular}