How do I show a timeline in excel for the bellow question? Please show equations used, do not just use excel formulas. Answer should be $926.65 the following is exactly how the teacher wrote the question

What is the value of a 30 year annual bond that has a coupon of 7.73% in 9 years, the ytm is expected to stay constant over the time period? The face value is $1,000 the current price is $918.25.