Fill This Form To Receive Instant Help

#### solve problems using excel formula   1

###### Finance

solve problems using excel formula

1. Compute the price of a 3.8 percent coupon bond with 18 years left to maturity and a market interest rate of 7 percent. Compute the price again if interest payments are paid semi-annually (solve using semi-annual compounding). Par value is \$1000. determine semi and annual compounding need both answers.

2. A 6.50 percent coupon bond with 18 years left to maturity is offered for sale at \$1,035.25. What yield to maturity [interest rate] is the bond offering? Assume interest payments are paid semi-annually, and solve using semi-annual compounding. Par value is \$1000. determine semi and annual compounding need both answers.

3. You have just paid \$1,135.90 for a bond, which has 10 years before it, matures. It pays interest every six months. If you require an 8 percent return from this bond, what is the coupon rate on this bond? Par value is \$1000.

## 4.94 USD

### Option 2

#### rated 5 stars

Purchased 9 times

Completion Status 100%