Due to a number of lawsuits related to toxic wastes, a major chemical manufacturer has recently experienced a market reevaluation.The firm has a bond issue outstanding with 10 years to maturity and a coupon rate of 8 percent, with interest paid semiannually.The required nominal rate on this debt has now risen to 16 percent.What is the current value of this bond? (Assume $1000 par value). How do I solve this in Excel?