Please show all work for part b using a financial calculator and excel if possible.

Suppose you purchase a 10-year bond with 6.9% annual coupons. You hold the bond for four years, and sell it immediately after receiving the fourth coupon. If the bond's yield to maturity was 4.7% when you purchased and sold the bond, a. What cash flows will you pay and receive from your investment in the bond per $100 face value? b. What is the annual rate of return of your investment? O A. Year 0 1 2 3 1 Cash Flows - $118.17 $6.90 $6.90 $6.90 $111.27 N OB. Year 0 2 + $6.90 3 + $6.90 Cash Flows $111.27 $6.90 $118.17 C. Year 0 2 2 3 Cash Flows - $117.24 $6.90 $6.90 $6.90 $118.17 OD. Year $118.17 You answered: 1.3 Cash Flows $117.24 $6.90 Correct answer: 4.7 + 0.2 Get answer feedback b. What is the annual rate of return of your inve The annual rate of return of your investment is 4.7%. (Round to one decimal place.) Question is complete. Tap on the red indicators to see incorrect answers