Please answer the below questions, the formula to be shown in an Excel Spreadsheet

Q-1

Calculate the value of bond that matures in 10 years and 1,000 SAR par value. The coupon rate is 8% and the market's required yield to maturity is 12%.

Q-2

A bond's market price is 850 SAR. It has a 1000 par value, will be mature in 8 years, and the coupon rate 8 percent annually. What is the bond's yield to maturity? What happens to the bond's yield to maturity if the bond matures in 16 years? What is mature in 5 years?

Q-3

A bond matures in 10 years with 1,000 SAR par value. The coupon rate is 8% and the market's required yield to maturity is 12%. What would be the value of this bond if it pays the coupon payment semiannually?

Q-4

A zero-coupon bond matures in 10 years with 1,000 SAR par value. The market's required yield to maturity is 12%. What would be the value of this bond?

Q-5

A bond matures in 15 years with 1,000 SAR par value. The coupon rate is 9% and the market price is 1250 SAR. What would be the expected rate of this bond?