Could this be solved without excel?

Acme Chemical, Inc. is a major manufacturer of chemical products for the agricultural industry, including pesticides, herbicides and other compounds. Due to a number of law suits related to toxic wastes, Acme Chemical has recently experienced a market re-evaluation of its common stock. The firm also has a bond issue outstanding with 10 years to maturity and an annual coupon rate of 5 percent, with interest paid semi annually. The required nominal market annual interest rate on this bond has now risen to 10 percent due to the high risk level associated with this firm. The bonds have a par or face value of $1,000.

1. Label each of the variables that you would use to determine the value of this bond in the market today:

N (time periods until maturity) =

PMT (periodic interest payment) =

I per (periodic market interest rate) =

FV (future value to be received when the bond matures) =

2. Based on the variables that you have identified in Question #1, what is the market value today (the present value or PV) of one of Acme Chemicals bonds?

3. After five years of judicial appeals, Acme Chemical emerges victorious in the toxic waste law suits. This provides a positive signal to the market and the market rate of interest (r d ) applicable to Acme Chemicals bonds declines to 6 percent. Assume that there are now 5 years remaining until maturity.

a. Label each of the variables that you would use to determine the new value of this bond in the market:

N (time periods until maturity) =

PMT (periodic interest payment) =

I per (periodic market interest rate) =

FV (future value to be received when the bonds mature) =

b. Based on the variables that you have identified in Question #3.a., what is the new market value (the present value or PV) of one of Acme Chemicals bonds, following their victory in appeals court?

4. Why do you suppose that the market value of Acme Chemicals bonds has risen following the firms victory in appeals court?