can you help me step by step. and ao i can enter in Excel

Disabled Links to external workbooks are not supported in Teams and have been disabled. A B D E F G H K -1. Rate of Return. A bond is issued with a coupon of 4% paid annually, a maturity of 30 years, and a yield to maturity of 7%. What rate of return will be carned by an investor who purchases the bond for $627.73 and holds it for 1 year if the bond's yield to maturity at the end of the year is 8%? (L06-3) 5 8 19 20 21 22 23 24 25 26 27 28 29 30 VB-4 VB-10 VB-5 VB-6 VB-7 VS-14 VS-23 VS-24 V5-15 VS-16 Calculation Mode: Automatic MacBook Air 47 F4 F5 96 FI F2