- Created by Nancy Cohn (Deactivated), last modified on Jan 12, 2024
You are viewing an old version of this page. View the current version.
Compare with Current View Page History
« Previous Version 12 Next »
Eagle Accounting stores all MBS/ABS factors used for processing in the Corporate Action table. You can input factors for processing using the Create Final Factor panel in Reference Data Center. 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.
For detailed information about how to manually input factors and use Global Processes to process factors, see Manage Factor Corporate Actions.
About Factors
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
You purchase Security 31296GT32 in Portfolio MBSDEMO2, with:
Trade Date of 20040105
Settle Date of 20040106
Par of 1,000,000.00
Price of 90.00
The following activity occurs:
Eagle Accounting amortizes 241.86 (CY2) for the month of January.
The factor for February 1 is applied at a rate of .90.
You run Factor processing, using the Factor Processing panel in the Global Process workspace.
The following figure shows the Factor Processing 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
You purchase the security PAYUP DEMO 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 |
The following occurs:
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 Processing panel, see Factor Processing Panel Options.Eagle Accounting creates a new lot of 33,188.76 Par versus 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.
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.
On this page
- No labels
Add Comment