Calculate the current yield of both bonds

Assignment Help Finance Basics

Reference no: EM131368366

After recently receiving a bonus, you have decided to add some bonds to your investment portfolio. You have narrowed your choice down to the following bonds (assume semiannual payments):

a. Using the PRICE function, calculate the intrinsic value of each bond. Is either bond currently undervalued? How much accrued interest would you have to pay for each bond?

b. Calculate the current yield of both bonds.

c. Using the YIELD function, calculate the yield to maturity of each bond using the current market prices. How do the YTMs compare to the current yields of the bonds?

d. Calculate the duration and modified duration of each bond.

e. Which bond would you rather own if you expect market rates to fall by 2% across the maturity spectrum? What if rates will rise by 2%? Why?

Reference no: EM131368366

Questions Cloud

Annualize the quarterly dividend growth rate : Because LLY pays dividends quarterly, calculate the quarterly percentage change in the dividends. Now, calculate the compound quarterly growth rate of the dividends using the GEOMEAN function.

Cite the given in apa edition : Cite the given in APA edition- Arnold, J. L., Levine, B. N., Manmatha, R., Lee, F., Shenoy, P., Tsai, M. C., Ibrahim, T. K., O'Brien, D. J. % Walsh, D. A. (2004) Information sharing in and out-of-hospital disaster response: The future role of inf..

What is the current yield of these bonds : If the bonds can be called in three years with a call premium of 4% of the face value, what is the yield to call on these bonds? (Note: use the RATE function.)

Re write the given assignment below : This assignment re- introduces you to the framework of 21st Century Skills that you will consider each week as you work to redesign prior coursework for your ePortfolio. Note that a similar format is followed for each of the assignments in this co..

Calculate the current yield of both bonds : Which bond would you rather own if you expect market rates to fall by 2% across the maturity spectrum? What if rates will rise by 2%? Why?

What are the advantages and disadvantages of each option : What are the options? What is the cost of each option - What are the advantages and disadvantages of each option and what completion date would you recommend? Why?

Include 5 scholarly sources as well as government documents : In the paper you should include 5 scholarly sources as well as government documents.- This means that you will need to cut and paste and do some redrafting from your earlier papers.

What are the characteristics of traditional folk literature : What are the characteristics of TRADITIONAL (FOLK) LITERATURE? (2-3 sentences). Among the types of traditional literature, which one is best suited for an older child and why? (2-3 sentences).

Calculate the value of the bond using the price function : Calculate the duration of the bond using the DURATION function, and the modified duration using MDURATION. If interest rates rise by 1%, how much will the price change?

User Account

All Pages