Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

SUMMARY

This processing document will explain the computation of accrued income for bonds at the position level. It will show information on position accruals for bonds that have been purchased, bonds that are currently held, and bonds that are being sold.

PURCHASE OF A BOND

When purchasing a bond, the buyer must buy the accrued income through the day before settlement date. The bond will then start accruing on settlement date of the trade.

Example

Bond A

  • 9% Coupon Rate
  • Pays Semiannually on 1/15 and 7/15
  • 30/360 Day Count
  • Issue Date = 1/15/2005
  • Maturity Date = 1/15/2025
  • Issue Price = 100

Purchase 4,000,000 Par of Bond A

  • Trade Date = 2/17/2009
  • Settle Date = 2/20/2009
  • Purchase Price = 100

Transaction Details

Trade Date

Settle Date

Par

Price

Principal Amount

Accrued Income

Net Settlement Amount

2/17/2009

2/20/2009

4,000,000

100

4,000,000

35,000

4,035,000

Calculation of Income Purchased

  • 4,000,000 (par) * .09 (coupon) = 360,000 Annual Income Amount
  • 360,000 / 360 = 1,000 Daily Income Accrual
  • Last Payment Date was 1/15/2009: compute number of days in current accrual period (16 in January and 19 in February). There are 16 days in January because the day count begins on pay date 1/15/2009 and ends on 1/30/2009. The 19 days in February are counted from 2/1/2009 through the day before settle date (2/19/2009).

Position Information

Date

Security

Par

Price

Principal Value

Accrued Income

Market Value Income (Total Valuation)

2/17/2009

Bond A

4,000,000

100

4,000,000

35,000

4,035,000

2/18/2009

Bond A

4,000,000

100

4,000,000

35,000

4,035,000

2/19/2009

Bond A

4,000,000

100

4,000,000

35,000

4,035,000

2/20/2009

Bond A

4,000,000

100

4,000,000

36,000

4,036,000

2/23/2009

Bond A

4,000,000

100

4,000,000

39,000

4,039,000

2/24/2009

Bond A

4,000,000

100

4,000,000

40,000

4,040,000

2/25/2009

Bond A

4,000,000

100

4,000,000

41,000

4,041,000

As the bond purchase is processed and generates the bond position, there is a corresponding generation of a cash position for the portfolio. In this example, assume that the portfolio started with 6,000,000 in cash prior to the bond purchase.

Accrued Income at the position level is computed as follows:

  • Accrued Income Earned (in the current period) + Interest Purchased (in the current period) - Interest Sold (pending settlement)

Notes

  • The price of the bond in these examples is held constant at 100, but in actual practice, price fluctuations would be incorporated into the daily market value of the bond and subsequently incorporated into the performance computations.
  • The daily accrued income earned in these examples is 1,000 for ease of understanding.

Position Information for Cash Balance

Date

Security

Traded Balance

Settled Balance

2/16/2009

Cash

6,000,000

6,000,000

2/17/2009

Cash

1,965,000

6,000,000

2/18/2009

Cash

1,965,000

6,000,000

2/19/2009

Cash

1,965,000

6,000,000

2/20/2009

Cash

1,965,000

1,965,000

2/23/2009

Cash

1,965,000

1,965,000

2/24/2009

Cash

1,965,000

1,965,000

2/25/2009

Cash

1,965,000

1,965,000

For the above example, performance calculations are straight forward and returns can be computed for the bond position, cash balance, and the total portfolio. (Note: for simplicity the price of the bond is held constant at 100, but price fluctuations would be incorporated into any return calculation).

Date

Component

Beginning Market Value Income

Negative Cash Flows

Positive Cash Flows

Ending Market Value Income

Rate of Return

2/16/2009

Total Fund

6,000,000



6,000,000

0%

2/16/2009

     Bond A

0



0

0%

2/16/2009

     Cash

6,000,000



6,000,000

0%

2/17/2009

Total Fund

6,000,000

4,035,000

4,035,000

6,000,000

0%

2/17/2009

     Bond A

0


4,035,000

4,035,000

0%

2/17/2009

     Cash

6,000,000

4,035,000


1,965,000

0%

2/18/2009

Total Fund

6,000,000



6,000,000

0%

2/18/2009

     Bond A

4,035,000



4,035,000

0%

2/18/2009

     Cash

1,965,000



1,965,000

0%

2/19/2009

Total Fund

6,000,000



6,000,000

0%

2/19/2009

     Bond A

4,035,000



4,035,000

0%

2/19/2009

     Cash

1,965,000



1,965,000

0%

2/20/2009

Total Fund

6,000,000



6,001,000

0.0167%

2/20/2009

     Bond A

4,035,000



4,036,000

0.0248%

2/20/2009

     Cash

1,965,000



1,965,000

0%

The 0% returns for the bond and total fund until 2/19/2009 are indicative of the fact that the portfolio has pre-paid for interest through 2/19/2009 and does not begin accruing interest until 2/20/2009. On 2/20/2009, the returns reflect the earning of the daily interest accrual of 1,000.

VALUATION

Date

Component

Beginning Market Value Income

Negative Cash Flows

Positive Cash Flows

Ending Market Value Income

Rate of Return

2/20/2009

Total Fund

6,000,000



6,001,000

0.0167%

2/20/2009

     Bond A

4,035,000



4,036,000

0.0248%

2/20/2009

     Cash

1,965,000



1,965,000

0%

2/21/2009

Total Fund

6,001,000



6,002,000

0.0167%

2/21/2009

     Bond A

4,036,000



4,037,000

0.0248%

2/21/2009

     Cash

1,965,000



1,965,000

0%

2/22/2009

Total Fund

6,002,000



6,003,000

0.0167%

2/22/2009

     Bond A

4,037,000



4,038,000

0.0248%

2/22/2009

     Cash

1,965,000



1,965,000

0%

2/23/2009

Total Fund

6,003,000



6,004,000

0.0167%

2/23/2009

     Bond A

4,038,000



4,039,000

0.0248%

2/23/2009

     Cash

1,965,000



1,965,000

0%

SALE OF A BOND

When a bond holding is sold, the accrued interest on the sale transaction is also computed through day before settlement date.

Using the same example as above, we can generate a sale of the entire position.

  • Trade Date = 5/11/2009
  • Settle Date = 5/14/2009
  • Sale price = 100

Transaction Details

Trade Date

Settle Date

Par

Price

Principal Amount

Accrued Income

Net Settlement Amount

5/11/2009

5/14/2009

4,000,000

100

4,000,000

119,000

4,119,000

Calculation of Income Sold

  • 4,000,000 (par) * .09 (coupon) = 360,000 Annual Income Amount
  • 360,000 / 360 = 1,000 Daily Income Accrual
  • Last Payment Date was 1/15/2009: compute number of days in current accrual period (16 in January, 30 in February, 30 in March, 30 in April, and 13 in May).

Position Information on a Traded Basis

Date

Security

Par

Price

Principal Value

Accrued Income

Market Value Income (Total Valuation)

5/10/2009

Bond A

4,000,000

100

4,000,000

116,000

4,116,000

5/11/2009

Bond A

0

100

0

-3,000

-3,000

5/12/2009

Bond A

0

100

0

-2,000

-2,000

5/13/2009

Bond A

0

100

0

-1,000

-1,000

5/14/2009

Bond A

0

100

0

0

0

5/15/2009

Bond A

0

100

0

0

0

The Accrued Income for the Position is computed as follows:

Accrued Income Earned (in the current period) + Interest Purchased (in the current period) - Interest Sold (pending settlement)

As the bond sale is processed and generates the change in the bond position, there is a corresponding generation of a cash position for the portfolio. In this example, the portfolio had 1,965,000 prior to the sale being posted.

Position Information for Cash Balance

Date

Security

Traded Balance

Settled Balance

5/10/2009

Cash

1,965,000

1,965,000

5/11/2009

Cash

6,084,000

1,965,000

5/12/2009

Cash

6,084,000

1,965,000

5/13/2009

Cash

6,084,000

1,965,000

5/14/2009

Cash

6,084,000

6,084,000

5/15/2009

Cash

6,084,000

6,084,000

For the above example, performance calculations for the cash balance remain straight forward and returns can be computed for the cash balance and the total portfolio. However, the returns for the bond position need special logic to compute daily returns at the individual bond level. (Note: for simplicity the price of the bond is held constant at 100, but price fluctuations would be incorporated into any return calculation).

VALUATION

Date

Component

Beginning Market Value Income

Negative Cash Flows

Positive Cash Flows

Ending Market Value Income

Rate of Return

5/10/2009

Total Fund

6,080,000



6,081,000

0.0164%

5/10/2009

     Bond A

4,115,000



4,116,000

0.0243%

5/10/2009

     Cash

1,965,000



1,965,000

0%

5/11/2009

Total Fund

6,081,000



6,082,000

0.0164%

5/11/2009

     Bond A

4,116,000

-4,119,000


-2,000

N/A

5/11/2009

     Cash

1,965,000


4,119,000

6,084,000

0%

5/12/2009

Total Fund

6,082,000



6,083,000

0.0164%

5/12/2009

     Bond A

-2,000



-1,000

N/A

5/12/2009

     Cash

6,084,000



6,084,000

0%

5/13/2009

Total Fund

6,083,000



6,084,000

0.0164%

5/13/2009

     Bond A

-1,000



0

N/A

5/13/2009

     Cash

6,084,000



6,084,000

0%

5/14/2009

Total Fund

6,084,000



6,084,000

0%

5/14/2009

     Bond A

0



0

0%

5/14/2009

     Cash

6,084,000



6,084,000

0%

5/15/2009

Total Fund

6,000,000



6,084,000

0%

5/15/2009

     Bond A

0



0

0%

5/15/2009

     Cash

6,084,000



6,084,000

0%

The positive returns for the total fund from 5/11/2009 through 5/14/2009 are indicative of the fact that the portfolio is still earning interest through 5/13/2009. The negative accrued income at the bond position level reflects the fact that the interest sold is larger than the actual income earned from the period of trade date through settlement date - 1. The movement of this value to 0 shows the daily accrued income earned for each day leading up to the settlement of the sale. While the negative accrued income balance may some intuitively obvious at first glance, the above example shows that the negative balance offsets the income portion of the receivable from the sale. This receivable is already incorporated into the traded cash balance and needs to be offset at the security level until the income is actually earned. This allows for an accurate daily return at the total fund level instead of crediting multiple days' worth of income into one day and overstating that day’s return.

CUSTOM RETURN LOGIC

Custom return logic is required to accurately compute the individual bond return during the settlement period of the sale, and will be defined in a future version of this document.

  • No labels