You purchase a 10-year bond at face value for $1000. It pays a semi-annual coupon payment of $50. You expect to sell the bond in 3 years. You estimate that similar bonds will be priced to yield 12% at the time of the sale. If you can reinvest the coupon payments at 8% annually, what is your expected total return for the 3-year holding period?

Please solve using Excel and show what functions are used. I have a lot of problems like this so I would like to be able to use the same Excel functions to solve them. Thank you.