Levels for Defining Amortization Rules
Eagle Accounting provides the flexibility for you to define amortization rules at the following levels based upon the taxability of the security, giving you a hierarchical approach to apply the amortization rules:
- Accounting Basis level
- Processing Security Type level
- Amortization Accretion Rule Type level
- Security ID level
- Tax Lot level
Eagle Accounting also allows you to establish separate amortization rules for Market Premium and Market Discount Premium at an Accounting Basis level, at a Processing Security Type level, and/or at a Security ID level. Additionally Eagle Accounting allows you to even further establish separate amortization rules based on whether the security is taxable or non-taxable. For example, you can establish an amortization rule for all taxable bonds bought at market premium in an accounting basis to behave in a certain way.
About Average Cost Amortization
Highlight |
---|
WRITERS NOTE: discuss ACEY enhancement and user doc impact BT 112315 change to Cost Method and LSM thruout panels? Where does guide need updates? We talk about lot level in the next paragraph, for example. |
When you elect Average Cost as the Cost Method, you are also selecting Average Cost Amortization for your fixed income securities. Average Cost Amortization is defined as calculating amortization at the position level of a Primary Asset ID, and then applying the calculated amortization at the Lot level, based on the percentage of total par.
When processing average cost amortization, Eagle supports only the following amortization methods:
- Straight Line
- Straight Line/Actual
- Constant Yield 1 (CY1)
- Constant Yield 2 (CY2 with smoothing)
- Level Yield 1 (LY1)
- Level Yield 2 (LY2 with smoothing)
- None
Also, because amortization is calculated at a position level (rather than at a lot level) as identified cost, the following options are not available for average cost portfolios: Retrospective Amortization, Amortization Schedule Override, and Lot Level Amortization Rule Override. And the following amortization rule options are not available:
- Premium Proportional
- DeMinimis Test Application
- Amortization Cap/Floor Method
- Amortization / Accretion Election
- Recognize OID
- Premium Proportional
- Amortization at Disposition
- Use User Defined Amortization Schedule
Therefore, when setting up an amortization rule for an Average Cost portfolio, you should set the rule as follows:
- Amortization Methodology should be set to Default or Prospective. Retrospective and PAC NPV method are not eligible for average cost amortization.
- Amortization Method should be set to a viable method if you wish to amortize, or None if you do not wish to amortize
- Amortization/Accretion Election should be set to Both if the Entity/Accounting Basis will amortize, None if the Entity/Accounting Basis will not amortize
- Amortization Cap/Floor Method should be set to No Restriction
- Recognize OID should be set to No
- DeMinimis Test Application should be set to None
- Amortization at Disposition should be set to No
- Use User Defined Amortization Schedule should be set to No
Average Cost Amortization Example
For example, if three lots are purchased with the following security Information:
Coupon Rate
Issue Date
Dated Date
First Coupon Date
Last Coupon Date
- Last Coupon Date
Coupon Rate
Issue Date
- Dated Date
Maturity Date
5%
01/01/2002
01/01/2002
07/01/2002
07/01/200607
01/01/20062007
Lot 1
Trade Date
Settle Date
Par
Price
01/01/2003
01/01/2003
1,000,000
97
Lot 2
Trade Date
Settle Date
Par
Price
01/01/2003
01/01/2003
3,000,000
100.875
Lot 3
Trade Date
Settle Date
Par
Price
01/01/2003
01/01/2003
50,000
95
Additional Details
Total Par:
Total Cost:
Total Discount:
Days from Settlement to Maturity:
Daily Amortization:
4,050,000.00
4,043,750.00
6,250.00 (Total Par - Total Cost)
1,461.00
4.28 (4.277891854) (Total Discount/Days from Settlement to Maturity)
Lot Break Down
Lot 1
1,000,000 / 4050000
0.24691358 * 4.28
= 0.24691358
= 1.06 rounded to 2 decimal places
Lot 2
3,000,000 / 4,050,000
0.740740741 * 4.28
= 0.740740741
= 3.17
Lot 3
50,000 / 4,050,000
0.042222222 * 4.28
= 0.042222222
= 0.05 + .01 to facilitate rounding of the multiple lots