$1.)$ A bond pays $ $80$ per year in interest $(8\%$ coupon$).$ The bond has $5$ years before it matures, at which time it will pay $ $1000.$ Assuming a discount rate of $10\%$ and annual payments, what should be the price of the bond?

$2.)$ A $$1,000$ par value bond sells for $$1,092.$ It matures in $20$ years, has a $10$ percent coupon rate, and pays interest semi$-$annually. What is the bond$$s yield to maturity?

$3.)$ A $$1,000$ par value bond has coupon rate of $7\%$ and the coupon is paid semi$-$annually. The bond matures in $20$ years and has a required rate of return of $10\%.$ Compute the current price of this bond.

$4.)$ EEE has $10$ percent coupon bonds on the market with $7$ years to maturity. The bonds make semiannual payments and currently sell for $104$ percent of par. What is the YTM$?$

$5.)$ CCC$.$ issued $12-$year bonds $2$ years ago at a coupon rate of $8$ percent. The bonds make semiannual payments. If these bonds currently sell for $108$ percent of par value, what is the YTM$?$

$6.)$ Bond sells for $$950,$ pays an annual coupon of $$70,$ and it matures in $8$ years. It has a face value of $$1000.$ What are its coupon rate, current yield, and yield to maturity $($YTM$)?$

All $6$ task must be solved with detailed explanation of using formulas in Excel sheet how it must formatted in Excel in proper way