Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / solve problems using excel formula   1

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. 

View CommentsFlag Question

Option 1

Low Cost Option
Download this past answer in few clicks

4.94 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 9 times

Completion Status 100%

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.8)

Google (5.0)