Ask Experts Questions for FREE Help !
Ask
    bookidd's Avatar
    bookidd Posts: 1, Reputation: 1
    New Member
     
    #1

    May 18, 2011, 11:19 AM
    Finace must be done in excel
    You purchased a $1,000 five percent coupon bond that matures in 10 years.



    How much would your bond be worth if interest rates fall to 4% the day after you purchase the bond? What would the bond be worth in one year if interest rates fell to 4% at that point?

    Done in excel
    pready's Avatar
    pready Posts: 3,197, Reputation: 207
    Ultra Member
     
    #2

    May 18, 2011, 04:06 PM

    You need to do this in Excel.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Finace business [ 1 Answers ]

In what sense is a reinvestment rate assumption embodied in the NPV, IRR, and MIRR methods?

Business finace [ 1 Answers ]

As a financial officer, you must determine which project your company should accept. The projects are mutually exclusive and the net present value (NPV) calculations for each take into account the project?s risk. Indicate which project (A or B) you would recommend and explain your reasons for this...

Finace [ 1 Answers ]

What is the formula to find the coupon rate of a bond?

Finace question [ 1 Answers ]

Mark and Ellot are friends. Mark wants to buy a new computer but does not have the money right now. Mark will pay Elliot $2,000 in five years if Mark will give him $1600 today. Elliot figures that there's an interest rate of 6% if he were to put the money in a bank instead of lending it to...


View more questions Search