The NAIC Annual Schedules involve the following types of schedules:

• Summary Schedules
• BA Schedules
• D Schedules
• DA Schedules
• DB Schedules
• DL Schedules
• E Schedules
• Footnotes

Access Annual Schedules

To access Eagle Insurance for the creation of NAIC Schedules:

In Accounting Center, in the left navigation pane, click Insurance > Annual Schedules. 

The following table lists the left navigation options in the Annual Schedules area that create NAIC schedules, supplemental schedules, and vendor extracts.

Summary Schedules

Asset Valuation Reserve (Worksheet)

The Asset Valuation Reserve (AVR) Worksheet addresses the credit-related (default) and equity risks of a company's assets by calculating a basic contribution, a reserve objective, and a maximum reserve amount. The AVR Worksheet combines prior year reserve values, current year capital gains, and values from the supporting AVC schedules below, the AVR – Default Component and the AVR – Equity Component, for various asset classes. Eagle STAR provides the Basic, Reserve, and Maximum factors for all lines and values on the Default and Equity schedules, and values display for securities supported by ISTAR.
If supplied, the AVR process applies a Client Level tax rate to the gains/losses when determining the reserve values. Information on the worksheet includes:

• Basic Contribution
• Reserve Objective
• Maximum Reserve

See "Create Asset Valuation Reserves (AVR) Schedules" in Chapter 4: Set Up and Create Schedules for information about the steps for creating AVR schedules.

AVR – Default Component

AVR – Default Component is the Basic Contribution, Reserve Objective and Maximum Reserve Calculations – Default Component schedule. The schedule covers the bond, preferred stock, and derivative instrument sub-components of the default component of the AVR. The basic contribution factors, on average, approximates the expected annual losses. The reserve objective factors provide an accumulation level estimated to cover, in the aggregate, about 85% of the distribution of losses for each asset category. The maximum reserve factors define the largest amount that may be accumulated in the AVR.
See "Create Asset Valuation Reserves (AVR) Schedules" in Chapter 4: Set Up and Create Schedules for information about the steps for creating AVR schedules.

AVR – Equity Component

AVR – Equity Component is the Basic Contribution, Reserve Objective and Maximum Reserve Calculations – Equity and Other Invested Asset Component schedule. The schedule covers the common stock sub-component of the equity component of the AVR. The basic contribution factors, on average, will provide an amount that approximates expected annual losses. The reserve objective factors provide an accumulation level estimated to cover, in the aggregate, about 85% of the distribution of losses for each asset category. The maximum reserve factors define the largest amount that may be accumulated in the AVR.
See "Create Asset Valuation Reserves (AVR) Schedules" in Chapter 4: Set Up and Create Schedules for information about the steps for creating AVR schedules.

D – Summary by Country & Verification

Schedule D – Summary by Country & Verification provides two schedule views: Summary by Country and Verification Between Years.
Schedule D – Summary by Country
Displays long term bonds and stocks owned as of the end of the current year period, with a footnote identifying the aggregate value of bonds that are valued at other than the actual fair value in the Fair Value column. The schedule provides totals by major category and country (United States, Canada, or Other Countries) for:

• Book/Adjusted Carrying Values
• Fair Value
• Actual Cost
• Par Value of Bonds

Schedule D – Verification Between Years
Summarizes the column totals from Schedule D that represent various increases and decreases in Book/Adjusted Carrying Value, from prior year end to the end of the current year. Total non-admitted assets and/or valuation allowances (if applicable) are reflected in the verification schedule, to determine the statement value of long term bonds and stocks, as of the end of the current year period.

Schedule DA – Verification

Schedule DA – Verification is the Verification Between Years – Short-Term Invested Assets schedule. The schedule summarizes the various increases and decreases in Book/Adjusted Carrying Value for short-term invested assets, from prior year end to the end of the current year period. Total non-admitted assets and/or valuation allowances, if applicable, are reflected in the verification schedule to determine the statement value of short-term invested assets as of the end of the current year period.

DB – Part A – Verification

The Schedule DB – Part A – Verification is the Verification Between Years – Futures Contracts schedule. The schedule provides a summary of column totals from Schedule DB – Part A for Sections 1 and 2, that represents various increases and decreases in Book/Adjusted Carrying Value from prior year end to the end of the current year.

DB – Part B – Verification

The Schedule DB – Part B – Verification is the Verification Between Years – Futures Contracts schedule. The schedule provides a summary of column totals from Schedule DB – Part B for Sections 1 and 2, that represents various increases and decreases in Book/Adjusted Carrying Value from prior year end to the end of the current year.

Schedule DB – Verification

Schedule DB – Verification is the Verification of Book/Adjusted Carrying Value, Fair Value and Potential Exposure of all Open Derivative Contracts schedule. The schedule verifies the amounts reported in each individual derivative schedule (Schedule D – Part A – Section 1 and Schedule D – Part B – Section 1) against those reported in the Counterparty Exposure schedule (Schedule DB – Part D – Section 1).

Schedule BA – Verification

Schedule BA – Verification is the Verification Between Years – Long-Term Invested Assets schedule. The schedule summarizes the various increases and decreases in Book/Adjusted Carrying Value for long term invested assets, from prior year end to the end of the current year period. Total non-admitted assets and/or valuation allowances, if applicable, are reflected in the verification schedule to determine the statement value of long term invested assets as of the end of the current year period.

Schedule E – Part 2 – Verification

Schedule E – Verification is the Verification Between Years – Cash Equivalents schedule. The schedule summarizes the various increases and decreases in Book/Adjusted Carrying Value for cash equivalent securities, from prior year end to the end of the current year period. Total non-admitted assets and/or valuation allowances, if applicable, are reflected in the verification schedule to determine the statement value of cash equivalents as of the end of the current year period.

General Interrogatory 28 (Schedule DM)

General Interrogatory 28 (Schedule DM) is the General Interrogatory informational schedule. The schedule provides line totals for bonds (long term and short-term) and preferred stocks for:

• Statement value
• Fair Value
• Differences between Statement value and Fair Value

D1A1 – Maturity Distribution by Designation

Schedule D – Part 1A – Section 1 is the Quality and Maturity Distribution of all Bonds Owned December 31 at Book/Adjusted Carrying Values by NAIC Designations NAIC schedule. The schedule summarizes the Book/Adjusted Carrying Value of long term and short-term bonds by quality per NAIC designation, maturity, and major categories.

D1A2 – Maturity Distribution by Major Type

Schedule D – Part 1A – Section 2 is the Maturity Distribution of all Bonds Owned December 31 at Book/Adjusted Carrying Values by Major Type NAIC schedule. The schedule summarizes the Book/Adjusted Carrying Value of long term and short-term bonds by maturity, major categories, and sub categories.

Exhibits of NII and Capital Gains (Losses)

The Exhibits of NII and Capital Gains (Losses) are Net Investment Income and Capital Gains (Losses).
Exhibit of Net Investment Income
Provides the amount, by investment categories, for investment income collected and earned during the current year, with footnotes to support amortization of premiums, accretion of discounts, and paid for accrued interest on purchases.
Exhibit of Capital Gains (Losses)
Provides the amount by investment categories for:

• Realized Gains and Losses, Other Than Temporary Impairments
• Realized Foreign Currency Gains And Losses
• Current Year Changes in Unrealized Market Gains and Losses (if required)
• Unrealized Foreign Currency Gains and Losses During the Current Year

Interest Maintenance Reserve

Captures the Realized Capital Gains/(Losses) that result from changes in the overall level of interest rates and amortizes them into income over the approximate remaining life of the investments sold. The approximate remaining life will be estimated using security attributes such as: Asset Type, Maturity Date, and conversion Sink, Call and Put schedules. Additionally, investments will be included or excluded from the IMR based on the maximum NAIC Rating and the change in NAIC Rating over the holding-period in the portfolio.
See "Create Interest Maintenance Reserve (IMR) Schedules" in Chapter 4: Set Up and Create Schedules for information about this schedule.

Summary Investment Schedule

The Summary Investment Schedule provides the Gross Investment Holdings and related percentages, grouping securities with common risk characteristics.

BA Schedules

Schedule BA – Part 1

Schedule BA – Part 1 is the Other Long-Term Invested Assets Owned December 31 of Current Year NAIC schedule. The schedule lists the other long term invested assets owned as of the end of the reporting period.

Schedule BA – Part 2

Schedule BA – Part 2 is the Other Long-Term Invested Assets Acquired and Additions Made During the Year NAIC schedule. The schedule lists the other long term invested assets acquired during the reporting period.

Schedule BA – Part 3

Schedule BA – Part 2 is the Other Long-Term Invested Assets Disposed, Transferred or Repaid During the Year NAIC schedule. The schedule lists the other long term invested assets disposed during the reporting period.

D Schedules

Schedule D – Part 1

Schedule D – Part 1 is the Long-Term BONDS Owned December 31 of Current Year NAIC schedule. The schedule lists the long term bonds owned as of the end of the reporting period.

Schedule D – Part 2 – Section 1

Schedule D – Part 2 – Section 1 is the Preferred Stocks Owned December 31 of Current Yea NAIC schedule. The schedule lists the preferred stocks owned as of the end of the reporting period .

Schedule D – Part 2 – Section 2

Schedule D – Part 2 – Section 2 is the Common Stocks Owned December 31 of Current Year NAIC schedule. The schedule lists the common stock owned as of the end of the reporting period. The schedule displays a total line for common stocks and a total line for preferred and common stocks.

Schedule D – Part 3

Schedule D – Part 3 is the Long-Term Bonds and Stocks ACQUIRED During Current Year NAIC schedule. The schedule lists the long term bonds and preferred and common stock acquired during the current year that are still owned as of the end of the current reporting year.
Bonds, preferred stocks, and common stocks are grouped separately, showing a subtotal for each category.
There are other considerations, when using this schedule:

• If long term bonds or stocks (at a lot level) were acquired and sold during the current year, security level detail is not included on this schedule. These lots are included in summary total amounts carried over to this schedule from Schedule D – Part 5 for bonds, preferred stocks, and common stocks.

Schedule D – Part 4

Schedule D – Part 4 is the Long-Term Bonds and Stocks SOLD, REDEEMED or Otherwise DISPOSED OF During Current Year NAIC schedule. The schedule lists the long term bonds and stocks sold, redeemed, or otherwise disposed of during the current year.
Bonds, preferred stocks, and common stocks are grouped separately, showing a subtotal for each category.
There are other considerations, when using this schedule:

• Security lots acquired during the current year and fully disposed of during the current year are not listed in the schedule. These lots are included in summary total amounts carried over to this schedule from Schedule D – Part 5 for bonds, preferred stocks, and common stocks.

Schedule D – Part 5

Schedule D – Part 5 is the Long-Term Bonds and Stocks ACQUIRED During Year and Fully DISPOSED OF During Current Year NAIC schedule. The schedule lists the long term bonds and stocks acquired during the current year and fully disposed of during the current year. Security information on the schedule includes:
Bonds, preferred stocks, and common stocks are grouped separately, showing a subtotal for each category.
Subtotals from Schedule D – Part 5 are reflected in Schedule D – Part 3 for acquisitions, and Schedule D – Part 4 for disposals.

Schedule D – Part 6 – Section 1

Schedule D – Part 6 – Section 1 is the Valuation of Shares of Subsidiary, Controlled or Affiliated Companies schedule. The schedule lists the common and preferred stocks for affiliated companies owned as of the end of the reporting period.

Schedule D – Part 6 – Section 2

Schedule D – Part 6 lists the lower-tier company information for common and preferred stock reported on Schedule D – Part 6 – Section 1 as of the end of the reporting period.

DA Schedules

Schedule DA – Part 1

Schedule DA – Part 1 is the Short-Term Investments Owned December 31 of Current Year NAIC schedule where the maturity date at the time of acquisition was one year or less and greater than three months from acquisition date.

Schedule DA – Part 3 – Supplement

Schedule DA – Part 3 – Supplement is the Supplement Short-Term Investments ACQUIRED During Current Year informational schedule. The report lists the short-term investments acquired during the current year and owned as of the end of the reporting period.

Schedule DA – Part 4 – Supplement

Schedule DA – Part 4 – Supplement is the Supplement Short-Term Investments SOLD, REDEEMED or Otherwise DISPOSED OF During Current Year informational schedule. The report lists the short-term investments disposed of during the current year that were owned on December 31^st of the previous year.

Schedule DA – Part 5 – Supplement

Schedule DA – Part 5 – Supplement is the Supplement Short-Term Investments ACQUIRED During Year and Fully DISPOSED OF During Current Year informational schedule. The report lists the short-term investments acquired during current year and disposed of during the current year.

DB Schedules

Schedule DB – Part A – Section 1

Schedule DB – Part A – Section 1 is the Options, Caps, Floors, Collars, Swaps and Forwards Open as of December 31 of Current Year NAIC schedule. The report includes call options, warrants, put options, caps, floors, collars, forwards, and swaps owned as of the end of the scheduling period.

Schedule DB – Part A – Section 2

Schedule DB – Part A – Section 2 is the Options, Caps, Floors, Collars, Swaps and Forwards Terminated During Current Year NAIC schedule. The report includes call options, warrants, put options, caps, floors, collars, forwards, and swaps disposed of during the reporting period.

Schedule DB – Part B – Section 1

Schedule DB – Part B – Section 1 is the Future Contracts Open December 31 of Current Year NAIC schedule. The schedule includes all future contract positions open as of the end of the reporting period.

Schedule DB – Part B – Section 2

Schedule DB – Part B – Section 2 is the Future Contracts Terminated December 31 of Current Year NAIC schedule. The schedule includes all future contracts that were terminated during the current reporting year.

Schedule DB – Part D – Section 1

Schedule DB – Part D – Section 1 is the Counterparty Exposure for Derivative Instruments Open December 31 of Current Year NAIC schedule. The schedule includes the Book/Adjusted Carrying Value exposure and Fair Value exposure to each counterparty. The schedule also includes the total potential exposure for each counterparty for Schedule DB, Part A and Schedule DB, Part B. The schedule displays information by counterparty NAIC Designation, such as, Fair Value of Acceptable Collateral, Book/Adjusted Carrying Value, and Exposure.

Schedule DB – Part D – Section 2

Schedule DB-Part D – Section 2 is the Collateral for Derivative Instruments Open December 31 of Current Year NAIC Schedule. The schedule reports all collateral for derivative instruments that is pledged to exchanges, counterparties, and central clearinghouses by the reporting entity, or pledged to the reporting entity. You can use the Investment Disclosure Info option on the Create Investment Disclosures panel to enter Derivative Collateral pledges to display on this report. See "Manage Investment Disclosures" for more information.

DL Schedules

Schedule DL – Part 1

Schedule DL – Part 1 is the SECURITIES LENDING COLLATERAL ASSETS Reinvested Collateral Assets Owned December 31 Current Year NAIC schedule. The schedule includes a detailed listing of reinvested collateral assets that were owned as of the end of the reporting period.

Schedule DL – Part 2

Schedule DL – Part 2 is the SECURITIES LENDING COLLATERAL ASSETS Reinvested Collateral Assets Owned December 31 Current Year NAIC schedule. The schedule includes a detailed listing of reinvested collateral assets that were owned as of the end of the reporting period.

E Schedules

Schedule E – Part 1 – Cash

Schedule E – Part 1 – Cash is the Part 1 – Cash NAIC schedule. The schedule includes Certificates of Deposit (when not reported as cash equivalents on Schedule E – Part 2) with maturity dates greater than 3 months and less than or equal to one year from the acquisition date.

Schedule E – Part 2 – Cash Equivalents

Schedule E – Part 2 – Cash Equivalents is Part 2 – Cash Equivalents – Investments Owned December 31 of Current Year NAIC schedule. The schedule includes all assets with maturity date less than or equal to three months from the acquisition date.

Schedule E – Part 3 – Special Deposits

Schedule E – Part 3 – Special Deposits is the Part 3 – Special Deposits NAIC schedule. The schedule includes all assets designated as Special Deposits.

Schedule E – Part 3 – Supplement

Schedule E – Part 3 – Supplement is the Short – Term Investments ACQUIRED During Current Year informational schedule. The report lists the cash and cash-equivalent investments from the Schedule E – Part 1 and Schedule E – Part 2 schedules, acquired during the current year and owned as of the end of the reporting period.

Schedule E – Part 4 – Supplement

Schedule E – Part 4 – Supplement is the Supplement Short-Term Investments SOLD, REDEEMED or Otherwise DISPOSED OF During Current Year informational schedule. Lists the cash and cash-equivalent investments from the Schedule E – Part 1 and Schedule E – Part 2 schedules, disposed of during the current year that were owned on December 31^st of the previous year.

Schedule E – Part 5 – Supplement

Schedule E – Part 5 – Supplement is the Supplement Short-Term Investments ACQUIRED During Year and Fully DISPOSED OF During Current Year informational schedule. The report lists the cash and cash-equivalent investments from the Schedule E – Part 1 and Schedule E – Part 2 schedules, acquired during current year and disposed of during the current year.

Disclosures

5* Securities

The 5* Securities disclosure report provides a count and valuation of all holdings with a designation of 5 and a suffix that includes an asterisk by security group – Bonds, Loan-Backed and Structured Securities, Preferred Stock.

AM Best Supplemental Rating Question (SRQ)

The AM Best SRQ report lists the top ten holdings by issuer for bonds, and preferred and common stocks. The report includes the statement value, market value, SVO category, and industry for each of the top ten issuers.

Fair Value Measurement Footnotes

The NAIC Fair Value Measurement Footnotes report displays the aggregate fair value for a quarterly or annual period. You can display details by fair value hierarchy, level 1, 2, 3, or details for the aggregate carrying value by type of financial instrument. You can use the Footnote Selection (tag 7051) option on the report panel to select either the type of footnote report:

• Fair Value Measurements – Footnote 20D. This footnote report displays an aggregate fair value total by hierarchy level – 1, 2, 3 or the carrying value of "Not Practicable" for each Type of Financial Instrument.
• Fair Value Measurements – Footnote 20E. This footnote report details holdings where the security is deemed as "not practicable" to estimate the fair value of the financial instrument by the reporting entity. The report subtotals the carrying value of these "not practicable" assets by Type of Financial Instruments. You can use the Not Practicable Explanation option on the Create Insurance Overlay panel to assign an asset as "not practicable" at a client level. See "Manage Insurance Overlays" for more information.

Impairment Disclosures – Loan-Backed

The Additional Impairment Disclosures report displays the impact on cost of impairments identified as Not Recovering Amortized Cost (NRAC) for loan-backed securities. The impairment activity included on the report is grouped by security and month-end date.

Prepayment Penalty and Acceleration Fee

The Prepayment Penalty and Acceleration Fee disclosure displays a count of the number of positions and the aggregate amount of income for securities sold, redeemed or otherwise disposed of, which generate investment income as a result of a prepayment penalty and/or acceleration fee.

Risk Based Capital (RBC) Asset Concentration Report

The RBC Asset Concentration report lists the Risk Based Capital requirement for different asset classes of securities. The RBC factors used in the report are specific to the reporting company type.

Risk Based Capital (RBC) Size Factor Report

The RBC Size Factor report displays the Number of Issuers and the Weighted Number of Issuers for a portfolio. The size factor reflects the higher risk of a bond portfolio that contains relatively fewer bonds. The overall factor decreases as the portfolio increases in size. The size factor is based on the weighted number of issuers held by the portfolio.

Statutory Disclosure Summary

The report details the various realized and unrealized gains and losses at the asset level for a client or entity, grouped by SVO Code, Security Type, time to maturity, and time in a loss position. The report reconciles the costs related to impairments, grouped based on the impairment reason.

Supplemental Investment Risks Interrogatories

The Supplemental Investment Risks Interrogatories report includes information designed to assist regulators in identifying and analyzing the risks inherent in an investment portfolio. The Interrogatories apply only to general account assets. Holdings are grouped based on criteria, such as issuer and country, with the top holding displayed as a percentage of total invested assets. Because not all assets held by the client are necessarily present in Eagle STAR, the total invested assets for the client/month end date is required to generate the schedule, and must be entered on the report panel. The value is used as the denominator in the calculation of the various "percentage of total assets" values reported on the schedule. NAIC Designations for issuers and sovereign countries are required to support the values included on the report. See "Maintain the NAIC Designations for a Client" in Chapter 2: Set Up Eagle STAR for Insurance, for more information about this supporting data.

Wash Sales – Footnote 17c Report

The report displays a summary of the potential statutory wash sales by security, for a reporting period. The report is grouped by security types of Bonds and Preferred Stocks and by NAIC Designation within those groupings. You can only create the report at the client level for quarterly and annual periods. See "Generating Wash Sales – Footnote 17c Schedules" in Chapter 4: Setting up and Creating Schedules, for more information about this report.