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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Gary" <(E-Mail Removed)> wrote in message
news:8E31BF99-1BF8-420C-8A08-(E-Mail Removed)...
>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?

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
> (E-Mail Removed)
> "Gary" <(E-Mail Removed)> wrote in message
> news:8E31BF99-1BF8-420C-8A08-(E-Mail Removed)...
> >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?
>
>