Captools/net Documentation

Cash/Cash Equiv. Accruals

Cash/Cash Equiv. Accruals

Previous topic Next topic  

Cash/Cash Equiv. Accruals

Previous topic Next topic  

Some users (Level 3/higher) may want performance results to reflect accrued income on cash and cash-equivalents.  To obtain this the following setup is required:

1) In the security record, in the Security ID record of the "(CASH)" or cash equivalent security (e.g. money market funds) the Accrual Method field must be set to the "Cash Equiv" option.

2) You must also specify the Payment Dates field for such securities in the Security ID record. If the security pays on the 15th of the month, specify "01/15x12" (for 12 times/yr).

3) For each cash equivalent security, make an entry in the "Histories/Distribution" records for the rate that they are currently paying. Thus if a cash equiv paid 4.5% last month on the 25th, you would enter a record for 09/25/06 with "4.5" in the Amount/Share field. Captools/net will know this is a rate because of the Cash Equiv. specification in the security record. If you know the rates for all of the prior months going back to the beginning, enter the applicable records. If you skip a record Captools/net will carry the rate forward.  The TAC code for the distribution record is not important because this is simply to specify the accrual rate and not to insert a transaction.  Thus any of IOB, IRI, IN+, DV+, DRI, NQD, and NQR can be used for this.

4) Recompute your batch valuations for all dates that you want a cash equivalent accrual. You will see it appear in the "accrued" field for that security, but note that it is not added to the value. This is to ensure matching with custodian statements. However when you run the performance report the accrued amount will be factored in.