Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Internal rate of return


From   Gao LIU <[email protected]>
To   <[email protected]>
Subject   st: Internal rate of return
Date   Fri, 14 Mar 2008 02:16:16 -0400

Dear Statalisters:

I am struggling with calculating internal rate of return (IRR) of series
bonds. I would really appreciate if someone can help me out.

The dataset is as following:

Series��� Issue_date�������� maturity�������������� par_amount ����� coupon
��������������� Issue_price
1���������06/15/00�����������06/15/05������������� 	7275������
�����5������������� �������100.75
2���������06/15/00�����������06/15/06������������� 	7265������
�����5������������� �������100.05
��.
14��������06/15/00�����������06/15/15������������� 	6480������
�����4.5��������� ����������96


Observations in the dataset are different series of one bond issue, so they
all have the same issue date but different maturity dates. ��I need to
calculate the internal rate of return of the whole issue by pooling the cash
flows of different series together. In other words, I need to generate only
one IRR based on the cash flow of all these series.

I was not able to find a stata function for IRR calculation, although I did
find an ado file (finirr). The ado file seems to calculate it with a ml
command and requires a data structure as follows:

Time����� Cash_flow
Year_1� 100
Year_2 -105

Any input on how to transform my dataset to fit the finirr format would also
be appreciated.

Thank you.

Best

Gao



*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index