How to calculate bond value and current yield
 

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?

How to calculate bond value and current yield
 

look in the help index for
FINANCIAL FUNCTIONS
One you will find is PV

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
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?

How to calculate bond value and current yield
 

In addition, have a look at the the functions available through Analysis
Toolpak, an Excel add-in.

--
http://www.wimgielis.be = Excel/VBA, soccer and music


"Don Guillett" wrote:

look in the help index for
FINANCIAL FUNCTIONS
One you will find is PV

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
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?