Problem $7-18$ Bond Price Movements $[$LO$2]$

Bond X is a premium bond making semiannual payments. The bond pays a coupon rate of $12$ percent, has a YTM of $10$ percent, and has $18$ years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a coupon rate of $10$ percent, has a YTM of $12$ percent, and also has $18$ years to maturity. The bonds have a $$1,000$ par value. What is the price of each bond today? If interest rates remain unchanged, what do you expect the price of these bonds to be one year from now? In $10$ years? In $14$ years? In $15$ years? In $18$ years? $($Do not round intermediate calculations and round your answers to $2$ decimal places, e$.$g$.,32\mathrm{.}16.)$ Please solve it on excel and show the work step by step