How to calculate bond value and current yield

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A bond has a $1,000 par value, 12% coupon rate, interest on the bond is paid
annually, the current yield to maturity on the bond is 6%, and the maturity
of the bond is 10 years.
I'm having problems with the formula to compute the following:
1. What is the value of the bond?

2. What is the current yield on the bond?
 
look in the help index for
FINANCIAL FUNCTIONS
One you will find is PV
 
In addition, have a look at the the functions available through Analysis
Toolpak, an Excel add-in.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bond premium amortization using the constant yield method 1
Current Yield vs. Yield to Maturity at low prices 1
Finance Formula Help 3
Excel PRICE function: How does it compute Issue Date of the Security 5
how do you calculate the coupon rate of a bond in excel? 1
Reverse PRICE function 32
finding a bond coupon rate 2
Excel Calculation of After tax Cost of debt Plz Help 0

Back
Top