Question: A corporation issued new bonds 23 years ago. The bonds have a coupon rate of 12%, semi-annual payments, and were sold at their par value of $1,000. the 30-year bonds have 7 years remaining to maturity and the level of interest rates has declined. If the required rate of return for this bond is 10%, what is the intrinsic value of the bond? Need calculations in excel and/or financial calculator.