date and bond calculations
 

Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE function?
If I am not looking at an actual bond with a stated maturity date but I want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for example,
is there a way of using s'thing similar to today()+10 years or today +
(360*10), etc. and how would one actually enter it in the formula (price for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126

"saturnin02" <saturnin02_at_hotmail.com wrote in message
...
Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE function?
If I am not looking at an actual bond with a stated maturity date but I
want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for example,
is there a way of using s'thing similar to today()+10 years or today +
(360*10), etc. and how would one actually enter it in the formula (price
for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126


"saturnin02" <saturnin02_at_hotmail.com wrote in message
...
Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE function?
If I am not looking at an actual bond with a stated maturity date but I
want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for example,
is there a way of using s'thing similar to today()+10 years or today +
(360*10), etc. and how would one actually enter it in the formula (price
for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126


"saturnin02" wrote:

Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE function?
If I am not looking at an actual bond with a stated maturity date but I want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for example,
is there a way of using s'thing similar to today()+10 years or today +
(360*10), etc. and how would one actually enter it in the formula (price for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S

Thanks for the EDATE. Seems good.
S
N Harkawat wrote:
using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126

"saturnin02" <saturnin02_at_hotmail.com wrote in message
...
Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE
function? If I am not looking at an actual bond with a stated maturity
date but I want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for
example, is there a way of using s'thing similar to today()+10 years or
today + (360*10), etc. and how would one actually enter it in the
formula (price for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S