What is the value of a $30-$year semiannual coupon bond given that the coupon rate $=$

$11\%,$ the face value $=$ $$1000,$ the required return $=15\%,$ and there are $15$ years

remaining until maturity? $($Do not use the dollar sign in your answer$)$ ANSWER WITH EXCEL