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

Version 1 Next »

Eagle Accounting stores all MBS/ABS factors used for processing in the Corporate Action table. You can input factors for processing using the Final Factor panel. The system stores factor history records for each security, based on the security asset identifier.
The Add Pool Factor panels, in contrast, are used solely for reporting and reference information, and do not base any processing against values stored in that table.

About Factors

For detailed information about how to manually input factors and use Global Process Center to process factors, see "Managing Factor Corporation Actions."
When you use factors, be aware that:

  • The Global and Retrospective Amortization processes only use factor values that have a corporate action status of Released.
  • When processing an MBS/ABS trade, Eagle Accounting, by default, enters the most appropriate Factor and Factor Date (from the Corporate Action table) in the trade panels. If no factors are found, Eagle Accounting uses a default factor of 1. Regardless of whether a factor is found, you can override the default factor.
  • The Trade Date of the paydown transaction is equal to the Effective Date of the factor. Settlement Date is calculated from the Effective Date of the factor, plus the number of Delay that appear in the security master record.
  • Trade Date of the payup transaction is equal to the Effective Date of the factor. The Cost Object Settlement Date is equal to the Effective Date of the factor, to properly facilitate the accrual process; on the Cash Object, the Settlement Date is calculated from the Effective Date of the factor, plus the number of Delay Days that appear in the security master record, to offset the receivable.
  • Income and principal are received as two different receivables.
  • Paydown factors and gain/loss are applied, and calculate at the lot level.
  • Eagle Accounting processes all factor payments based on a pro-ration approach. Pro-ration is the process of taking the percentage of par being reduced, and applying that percentage to the amortized cost, to calculate the gain or loss caused by a paydown.
  • IO Paydown transactions are for zero cash.
  • For Eagle Accounting to calculate the paydown amount, a factor must also exist in Eagle Accounting for the prior month.
  • When earnings are rolled backed past a factor date, Eagle Accounting automatically cancels that factor. You have to manually re-trigger the factor, via factor processing, to replay the corporate action.

Process a Paydown Factor Example

This example uses security 31296TG32. The panel information for this security follows.

Security Information

Value

MBS Identification

 

Issue Name

31296TG32

Issue Description

31296TG32

Ticker

31296TG32

CUSIP/SEDOL Check Digit Control Flag

Validate Check Digit

Primary Asset ID Type

CUSIP

Primary Asset ID

31296TG32

Alt Asset ID Type

 

Alt Asset ID

 

MBS Xreference Identification

 

ISIN

 

Sedol

 

Reuters

 

Bloomberg ID

 

SICOVM

 

Valoren

 

CEDEL

 

INTERNAL

 

CINS

 

XREF Exchange

FED

MBS Details

 

Investment Type

FI

Processing Security Type

DBFBFB (Factor Based Debt Instrument)

Security Type

MBS 30YR (MBS 30yr)

Sub Security Type

 

Quantity Type

PAR

Price Multiplier

0.0100

Quantity Scale

1.00

Country Of Risk

UNITED STATES

Country Of Risk Code

US (UNITED STATES)

Issue Country

UNITED STATES

Issue Country Code

US (UNITED STATES)

Asset Currency

USD

Settlement Currency

USD

Income Currency

USD

Issue Tax Type

STANDARD

Primary Exchange

FEDERAL RESERVE SYSTEM

Primary Exchange Code

FED (FEDERAL RESERVE SYSTEM)

Region

 

Amount Issued

 

Amount Outstanding

 

Collateral Pool Type

 

SIC Code

 

Pool Number

A18318

MBS Debt Coupon Periods

 

Coupon

5.500000

Coupon Type Code

Fixed

Day Count Basis

30/360

Payment Frequency

Monthly

Payment Frequency Code

1_M

Interest Payment Timing

Same Day of Month

MBS Dates

 

Issue Price

100.00000000

Issue Date

20040101

Dated Date

20040101

First Coupon Date

20040201

Last Coupon Date

20311201

Maturity Date

20311201

Maturity Price

100.00

Delay Days

14.00

CMO First Principal Repayment Date

 

MBS Prepay Information

 

WAM Remain Date

20040401

WAM Original Months

244.00

WAM Original Remain Months

244.00

WAC Current

6.94300

WAC Original

6.94300


Trade Details

Security 31296GT32 is purchased in Portfolio MBSDEMOG, with:

    • Trade Date of 20040105
    • Settle Date of 20040106
    • Par of 1,000,000.00
    • Price of 90.00
  1. Eagle Accounting amortizes 241.86 (CY2) for the month of January.
  2. The factor for February 1 is applied at a rate of .90.
  3. You run Factor processing, using the Factor panel in Eagle's Global Process Center.

The following figure shows the Factor panel.

Figure 48: Factor Panel
When you run the factor process, Eagle Accounting creates a Principal Receivable of 100,000.00. The Principal Receivable is created by the following formula:
Current Face - (Original Face * Current Factor) = Paydown Amount
Eagle Accounting creates the principal cost reduction by applying the percentage paydown against the amortized cost. In this example, Current Cost is 900,0000.00 and Amortization Life-to-Date is 241.86. Eagle Accounting applies 10% (paydown amount/original face) to both the cost and amortization life-to-date, to produce a cost reduction of 90,000.00 and 24.19 of close amortization.
Gain/Loss is then Calculated as 100,000.00 - 90,024.19 = 9,975.81
Eagle Accounting posts the following general ledger entries, if:

  • The entity is set up to recognize the gain/loss caused by a paydown as gain/loss; that is, Gain/Loss on Paydowns is set to Yes, and
  • The gain/loss is posted to Income; that is, Paydown Gain/Loss Account is set to Income.


Ledger Account

Ledger Name

Debit Amount

Credit Amount

1002000100

Investment Receivable

100,000.00

0.00

1010000100

Cost Of Investments

0.00

90,024.19

4004000101

Realized Gain On Investments

0.00

9,975.81

Eagle Accounting posts the following general ledger entries, if:

  • The entity is set up to recognize the gain/loss caused by a paydown as gain/loss; that is, Gain/Loss on Paydowns is set to Yes, and
  • The gain/loss is posted to Capital; that is, Paydown Gain/Loss Account is set to Capital.


Ledger Account

Ledger Name

Debit Amount

Credit Amount

1002000100

Investment Receivable

100,000.00

0.00

1010000100

Cost of Investments

0.00

90,024.19

3006000111

Realized Gain on Investments

0.00

9,975.81

Eagle Accounting posts the following general ledger entries, if:

  • You recognize gain/loss on paydowns as Amortization.


Ledger Account

Ledger Name

Debit Amount

Credit Amount

1002000100

Investment Receivable

100,000.00

0.00

1010000100

Cost of Investments

0.00

100,000.00

The 9,975.81 Gain created from the paydown displays in the Income Archive and general ledger when earnings are run.

Process a Payup Example

This example demonstrates payup processing in Eagle Accounting, using the following security information.

Security Information

Value

MBS Identification

 

Issue Name

PAYUP DEMO

Issue Description

PAYUP DEMO

Ticker

 

CUSIP/SEDOL Check Digit Control Flag

Validate Check Digit

Primary Asset ID Type

INTERNAL

Primary Asset ID

PAYUP DEMO

Alt Asset ID Type

 

Alt Asset ID

 

MBS Reference Identification

 

CUSIP

 

ISIN

 

SEDOL

 

Reuters

 

Bloomberg ID

 

SICOVM

 

Valoren

 

CEDEL

 

CINS

 

XREF Exchange

FED

MBS Details

 

Investment Type

FI

Processing Security Type

DBFBFB (Factor Based Debt Instrument)

Security Type

MBS 30YR (MBS 30yr)

Sub Security Type

 

Quantity Type

PAR

Price Multiplier

0.0100

Quantity Scale

1.00

Country Of Risk

 

Country Of Risk Code

 

Issue Country

UNITED STATES

Issue Country Code

US (UNITED STATES)

Asset Currency

USD

Settlement Currency

USD

Income Currency

USD

Issue Tax Type

STANDARD

Primary Exchange

FEDERAL RESERVE SYSTEM

Primary Exchange Code

FED (FEDERAL RESERVE SYSTEM)

Region

 

Amount Issued

 

Amount Outstanding

 

Collateral Pool Type

 

SIC Code

 

Pool Number

 

MBS Debt Coupon Periods

 

Coupon

10.000000

Coupon Type Code

Fixed

Day Count Basis

30/360

Payment Frequency

Monthly

Payment Frequency Code

1_M

Interest Payment Timing

 

MBS Dates

 

Issue Price

100.00000000

Issue Date

19890428

Dated Date

19890415

First Coupon Date

19890515

Last Coupon Date

20190615

Maturity Date

20190615

Maturity Price

100.00

Delay Days

30.

CMO First Principal Repayment Date

 

MBS Prepay Information

 

WAM Remain Date

 

WAM Original Months

359.

WAM Original Remain Months

359.00

WAC Current

10.000000

WAC Original

10.000000


Trade Details

The security PAYUP DEMO is purchased with the following attributes:

Option

Value

Original Face

2,000,000

Current Face

3,982,651.40

Factor

1.9913257000

Trade Date

19950415

Settle Date

19950415

Purchase Price

110.00

  1. The security is then accrued for the period, producing a Receivable of 33,188.76.

The factor process is run for 19950515; the Factor for 19950515 is now 2.007920081. For a list of field definitions for the Factor panel, see "Factors."

  1. Eagle Accounting creates a new lot of 33,188.76 Par vs. a Cost of 33,188.76. The calculation of the payup follows:

(Original face * Current factor) - Current Face
or,
(2,000,000.00 * 2.007920081) - 3982651.40 = 33.188.76.

Note:

Eagle Accounting compares the previous factor with the current factor to determine whether there is a payup or paydown. Depending on the results of this comparison, Eagle Accounting invokes the paydown or payup accounting plan.

After the new lot is created, Eagle Accounting automatically processes an open adjustment transaction, to allocate a portion of the original face from the parent lot, to the new lot created from the payup transaction. Eagle Accounting allocates the original face by dividing the new lot by the current factor:
(33,188.76 / 2.0079200810) = 16,528.92479
of Original Face is Allocated From Parent to new Lot.
By allocating a portion of the original face, each lot is now in sync based upon the current factor. Eagle Accounting allocates the original face to new lots caused by payup because this allocation facilitates disposition processing. Each lot for disposition processing must have the original face.

Use Stale Factor Processing

Stale factor processing automatically corrects trades that are processed with incorrect or stale factors.
An example of a stale factor trade occurs when a security is bought in one month and settled in a future month. Because factors are not known in advance, the trade is set up with the current month's factor. When the factor for Settlement Date becomes available, the factor on record for the trade is now known as "stale." The trade would now have to be cancelled, and rebooked with the current factor.
Eagle Accounting can auto-correct trades that were input with stale factors when running factor processing. Stale factor processing works as follows: when factoring is run against a position with stale factor buys and/or sells, the factor procedure rolls back the stale trade, then replays the trade with the correct amounts, based on the new factor. The original trade is canceled and stored with the original amounts, reflecting the stale factor.
Eagle Accounting does not automatically roll back and replay a trade with a stale factor. If you want Eagle Accounting to automatically roll back and replay stale factor trades when factor processing is invoked, you must set the Stale Factor Processing (tag 8141) field to Yes at the entity level. For details, see "Setting Up Entities for Fixed Income Processing."
When you set the entity's Stale Factor Processing field to:

  • Yes. Stale factor processing occurs when you run factor processing and process paydown/payup transactions. Processing ignores the lot level Stale Factor Processing value but updates it to reflect the current value of the entity level Stale Factor Processing field. The system determines rollback by the Settlement date, orders replay by the Trade date, and creates paydowns with the correct quantity.
  • No. Stale factor processing does not occur when you run factor processing. Processing ignores the lot level Stale Factor Processing value but updates it to reflect the current value of the entity level Stale Factor Processing field. The system determines rollback by the Settlement date and orders replay by the Trade date.

All activity with the Trade date less than the Paydown date and the Settlement date less than the Paydown date created with a stale factor needs to be rebooked. Paydowns that occur when there is a Close with the Trade date less than the Paydown date and the Settlement date greater than or equal to the Paydown date and have a stale factor do not have the correct quantity until the Close is rebooked with the correct factor. If the Close has the current factor at the time of the paydown, the paydown has the correct quantity.
An example of Stale Factor Processing follows.
A trade was bought on 3/8 and settled on 4/4, with a Factor of 1 (a Stale Factor):

Option

Value

Original Face

1,000,000.00

Current Face

1,000,000.00

Factor

1.0

Price

100.00

Principal

1,000,000.00

Coupon

5%`

Accrued Interest Bought

416.67 (1,000,000.00 * 5.00% / 360 * 3 days)

Net Amount

1,000,416.67

You enter a Factor of .9 on 4/1. When the factor process is run, Eagle Accounting automatically rolls back the original trade and replays it with the correct 4/1 factor of .9.
The trade now appears as follows.

Option

Value

Original Face

1,000,000.00

Current Face

900,000.00

Factor

.90

Price

100.00

Principal

900,000.00

Coupon

5%

Accrued Interest Bought

375.00 (900,000.00 * 5.00% / 360 * 3 days)

Net Amount

900,375.00

If the Stale Factor Processing option is not enabled for the entity associated with the trade in Eagle Accounting, you have to manually cancel the original trade when the factor is known, and then manually rebook the new trade using the current factor.

  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.