Home

2015 User`s Manual - National Association of Insurance

1. A private placement number is a number assigned by Standard amp Poor s CUSIP Service Bureau that is issued for a security that is not traded on the public markets PPNs can be recognized by the existence of a or in the 6th 7th or 8th position of the CUSIP number If the issuer is a private company the or will appear in the 6th position of the PPN For privately traded issues of public entities the or will appear in either the 7th or 8th position of the PPN For example 00800 AA7 is the full 9 character PPN 00800 the issuer e g Private Co AA the issue e g Senior note 7 Check digit N A Ji C National Association of Insurance Commissioners Page 46 2015 AVS User s Guide Last Updated April 4 2015 CUSIP International Numbering System CINS CINS numbers are used to identify securities issued in foreign markets They can be recognized by the presence of a letter in the first position of the CINS number These letters identify the domiciliary country of the issuer A Austria N Netherlands B Belgium P South America C Canada Q Australia D Germany R Norway E Spain S South Africa F France T Italy G United Kingdom U USA H Switzerland V Africa Other J Japan W Sweden K Denmark X Europe Other L Luxembourg Y Asia M Mid East c Market Indicator Required for schedule D filing this field indicates where the market value for a stock wa
2. CSG SYS INTL INC CAPMARK MILITARY HSG TR XXX CENTENE PLAZA TRANSN DEV DISTMO TRANSN SPL ASSMT amp PKG FEEREV 1 Welcome Test Account Help Log Off Search results will display under the Group Code 99 Search Results label A record count of the results will also display Welcome Test Account i _ A pro If there are no search results no Group Code 99 Search Criteria Group Code 99 Search Results results will display Year 20m1 Period a1 x EE Mas i Search 2012 5 National Association of NA IG Insurance Commissioners Page 27 2015 AVS User s Guide Last Updated April 4 2015 o Schedule BA PC er ER RR EE RR RE ER EE EE ER EER RR ER RR EE RR Re Specify the Year and Period Select the Search button To change the Year or Period select a different value from the drop down menu i Welcome Test Account Automated Valuation Service A prod Home Searches Portfolios My Account New Window Help Log Off Schedule BA Search Criteria Schedule BA Search Results 295 results i Year mE Period ar CUSIP issuer Name Security D f 00219 AA APX ALARM SEC SOLUTIONS INC 214811 00219 AB APX ALARM SEC SOLUTIONS INC 214812 H sat primase nr d 00289 AB ABEO MGMT CORP 214846 00384 10 ABRY SR EQUITY BLP 214854 i 00673 AA ADVANTAGE CAP STATE TAX CRINVESTOR IIL L C 215013 i 00739 AA ADVANTAGE CAP STATE TAX CRINVESTOR I L L C 215084 i
3. you will exit the AVS d application 1 National Association of NA I C Insurance Commissioners Page 12 2015 AVS User s Guide Last Updated April 4 2015 c After Selecting Agree to Terms Attestation Window The Attestation window will display the system access information User Name Account and date a S Welcome Test Account Select the Next button to continue i Attestation If you select the Cancel button you will exit the AVS application Accepted by testacct on behalf of Test Account on 12 26 2012 d Standard Terms Standard Terms PDF Window The AVS License Agreement will display Welcome Test Account The AVS License Agreement for Insurers PDF displays Read the content and select the checkbox beside the have read the Standard Terms Select the Next button BB T IEIMNIMIELIE 3UIN EB it NE NE N G ci NATIONAL ASSOCIATION OF INSURANCE COMMISSIONERS If you se ect th e Can cel b utton AUTOMATED VALUATION SERVICE PLUS AVS 6 LICENSE AGREEMENT FOR INSURERS you will exit the AVS application THIS AGREEMENT IS MADE THIS _ day of 2012 by and between the National Association of Insurance Commissioners a Delaware nonprofit corporation with its principal place of business located in Kansas City Missouri Licensor and sometimes referred to as the NAIC or SVO and the Licensee hereafter defined as located at This Licens
4. Contents 1 Introduction to the Automated Valuation Service ese ee Ed ee AR ee ee 5 a Contact IANO Wil dle AE EE EE EO 6 D SvstenmRer diese ES se EG Ge ee ee ee ene 6 C oe ar AE AL EE OE GE N OE N EL OE ET 7 d Third Party Administrator Service esse sesse ee EE ee EE ee ee ee ee RE ee ee AR Ee ee ee ee ee ee ee Ee ee ee ee ee ee ee ee AR ee ee 7 m i FON ele EE OE OE OE EE EO EE EE 8 tT QOtional Companion ProdtCts ESE RI OE Se EG EO Se GR EE DE Ge Ge oe eo RR Ee Ee EG Ee 9 2 AVS Home Page amp Logging IN sesse sesse ees see se ee ee ee ee Ee ee RE ee ee GR ee ee ee ee AE ee Re ee ee ee Ee ee Ge ee ee 10 a ARETO TERS ie EERDER GE EE Ge DO EE ED ee ER Re GR EER RO ee Ge ee Ee EG ee 12 Bb Pastorie Afreanjer baas SE Ee Ee RE VG GE N GR EG n Ee RGN ee Ge ee Ee Da Ee Ee Ee ON 12 ce After Seleciing Agree 1o Terms ask EE EE SE Ge EG Ed DR Oe GR Ee Ge Ge GE Ge Ge Ge Ge 13 de SEUNG Ee En RE RE EE AE ER EE OE EE N 13 N SE OE EE ER RE EE EL OE ER 14 Die WV PC COI ER OE OE ER EE EE N ER EE EE EN 14 Ad AVE EOuEFasEPOSLEOR IN ooie vanes date pode oe ee en DER GO DER ee anes beau oo Re ee ee DER Po EE DE EE DERE 16 ie EE EE OR EO EE ORE EE 17 a Searches VOS did EE se ee EE EE ER in WE GE pe ee ie ee ee ee pe E 18 b Specify Advanced VOS FE Search Criteria sesse sies ede ese deed ed ede deed ede se se ee Gede ee as iaoiai aaa 19 VOS EE CUSIP HISTON CAN sides tee Ee Ge GE oie ee ee Ge ee ee oe ee Ge EG 20 d WVOS FE Cu
5. To access the NAIC Store select the AVS Homepage hyperlink The NAIC Store displays ttp www naic org store_avs htm National Association of NA I C Insurance Commissioners ages ublic home jsf Structure Coming Soon Structured securities results will be incorporated into AVS in early Fall 2013 Until then the structured securities Web based application can be accessed at https Wisis naic org The structured securities application makes the modeled data for residential mortgage backed securities RMBS and commercial mortgage backed securities CMBS more easily accessible This information helps to determine the risk based capital RBC requirements for the non agency RMBS CMBS securities owned by U S insurers Beginning in early Fall 2013 the AVS system will allow users to e Review RMBS CMBS modeled data for CUSIPs held as reported by the end of the second quarter e Get CUSIP prices based on expected losses for each NAIC designation e Purchase modeled data year round for additional securities acquired e Download modeled data for companies in a group into one convenient CSV file For more information visit the Structured Securities homepage Or contact the ANS Administrator at avsisis naic org or 816 783 8707 To Log In to AVS select Log In The NAIC AVS Log In window displays Page 10 2015 AVS User s Guide Last Updated April 4 2015 NAIC Log In Window N
6. Valuation File follow the steps Please be aware that files will be retained for 90 days before being deleted on the next page National Association of NA IC Insurance Commissioners Page 35 2015 AVS User s Guide Last Updated April 4 2015 c Submit Valuation Request Valuation Type The Valuation file contains all of the securities in your portfolio If you have submitted an upload file at the same time as requesting a Valuation the file will be created after the upload is successfully processed This ensures provision of the most up to date information AS Automated Valuation Service A product of Home Searches Portfolios My Account New Window Welcome Test Account ad Help Log Off Portfolio reguest submitted successfully Portfolio Upload amp Valuation Requests Period End Management Portfolio Name 00000A NAIC Test Company Download portfolo Create Portfolio Request Select the portfolio file to upload to the AVS System and or the valuation type to request and click Submit to continue File to Upload Saar Action to Take Update A Replacement Valuation Type 7 au VOS Securities In Portfolio ia M VOS Securities That Have Been Reviewed This Year M VOS Securities That Have NOT Been Reviewed This Year IV Filing Exempt Securities In Portfolio weeny Specify one or more Valuation Type s and select the Submit button Once the Valuation Request s is complete a confi
7. 8 075 00 1 000 000 000 7 070 00 750 000 000 5 935 00 500 000 000 4 865 00 250 000 000 3 795 00 10 000 000 250 000 000 2 750 00 10 000 000 00 2 225 00 AVSPlus Non Insurer 10 000 00 AVSPlus TPA 4 150 00 N A IG National Association of Insurance Commissioners Page 8 2015 AVS User s Guide Last Updated April 4 2015 f Optional Companion Products Purposes and Procedures Manual of the NAIC Investment Analysis Office This publication is the primary source for insurers to comply with the NAIC s reporting requirements Contains the NAIC s credit assessment methodologies and valuation policies and takes precedence over other SVO publications covering a number of categories The purchaser will also receive periodic e mail alerts relating to regulatory developments concerning securities These alerts will be sent directly from the NAIC s NAIC Investment Analysis Office This Purposes and Procedures Manual is updated bi annually Mutual Fund List and Bank List The mutual funds and bond list meet conditions in the Purposes and Procedures Manual of the NAIC Investment Analysis Office qualifying them for more favorable reserve treatment The Bank List meets credit standards specified for a variety of NAIC approved purposes The Mutual Fund and Bank List are updated monthly Publications Ordering and Shipping Information Online Contact a customer service representative at 816 783 8300 to create your account a
8. X11111AE Classification Bond Group Code 95 Group Code Ext Market Indicator Price Price Origin Price Review Date Issue Description NAIC Test Description Country Name UNITED Guar Issuer Code Source VOS Designation 1 Designation Indicator Designation Review May 03 2011 Rate Maturity Date Dec 20 2012 Dated Date AE Welcome Test Account Review the CUSIP details To add the security to a portfolio select _ the Add to Portfolio button Select Print to print _ the CUSIP detail Select the Back button to return to the AVS Home Page 1 National Association of NA I C Insurance Commissioners Page 21 2015 AVS User s Guide Last Updated April 4 2015 g Added Removed to from Portfolio AvS Automated Valuation Service Welcome Test Account The CUSIP added to Portfolio message displays X11111AE added to Portfolio To remove the CUSIP Issuer Name NAIC Test issuer CUSIP x11111AE1 sic select the Remove Classification Sond Source VOS from Portfolio Group Code 95 Designation 1 b utton Designation Indicator i Group Code Ext i Market Indicator Designation Review Way 03 2011 Select the Back me button to return to i Price Maturity Date Dec 20 2012 Price Origin the AVS Home Price Review Date Dated Date Page Issue Description NAIC Test Description AE Country Nam
9. state officials may incorporate the research produced by the staff of their Association as official regulatory policy However state regulators have statutory duties that may require them to incorporate a variety of factors in addition to or in lieu of the research produced by the staff of their voluntary Association The VOS publication is designated as the official NAIC source for publication of Association Values assigned by the SVO to the securities reported by insurance companies To the extent that an NAIC member acting in its capacity as a state official instructs an insurance company to incorporate Association Values in the filings made by that company to the state insurance department the NAIC member is advised that only NAIC Designations and Unit Prices obtained from the most recently published VOS Products should be used by an insurance company to report an NAIC Designation and or a Unit Price on an NAIC Financial Statement Blank prepared in accordance with SAP Section 9 Statement of Practice The SVO routinely receives financial information legal documents and other data from reporting insurance companies so that it may assess the reported investment for the NAIC While the NAIC is not a guarantor of the confidentiality of information submitted to the SVO the SVO does not redistribute documents obtained in the course of its work for other than regulatory purposes or as may be required by law The NAIC does however respect copyright an
10. ver ETE Perio aT Name Location swere Search results will i 2011 ABN Amro Bank N V Chicago Branch Chicago IL oTc 1 display under the AIG Financial Products Corp Westport CT oTc 1 Counter pa rty ur Melbourne Austral OTC 1 z 3 T BNP Paribas Paris France oTc 1 Designation Search Bank One N A Chicago IL otc 1 lt Results label Bank of America N A San Francisco CA OTC 1 i Bank of Montreal Montreal Canada OTC 1 A reco rd cou nt of t h e Bank of New York New York NY oTc 1 z Bank of Nova Scotia Toronto Canada OTC 1 resu Its WI a Iso Bank of Tokyo Mitsubishi UFJ Ltd NY Br New York NY otc 1 dis p ay Banque AIG SA London UK oTc 1 a Barclays Bank PLC London UK OTC 1 Barclays Capital inc New York NY OTC 1 Calyon New York NY OTC 1 Calyon NY Branch New York NY OTC 1 Canadian Imperial Bank of Commerce Toronto Canada OTC 1 Caibank NA New York NY OTC 1 Citigroup Global Markets Ltd London UK OTC 1 Citigroup Global Markets Inc New York NY OTC 1 Commerzbank AG Frankfurt Germany OTC 1 L National Association of NAIC Insurance Commissioners Page 25 2015 AVS User s Guide Last Updated April 4 2015 Welcome Test Account Automated Valuation Service A prod Home Searches Portfolios My Account New Window Help Log Off Counterparty Designation Search Criteria Counterparty Designation Search Results Year 2011 Perioda a1 lt Namo Location EE If there are no sea
11. 00011A 2 010397DX2 Test 00011A 2 701094104 00011A 1 783760HQ7 Delete 00011A 1 78462M306 Delete 00011A 3 796236FN2 Changed Portfolio Update Replacement Record Layout Starting position 1 8 10 20 Length Field Description 6 AVS Portfolio Number 1 Action Code 9 CUSIP PPN CINS 14 Security ID Your 6 digit AVS Portfolio Code assigned by the AVS Administrator Note this will consist of a letter in the sixth position see examples below During the set up of the new system the majority of the portfolio codes will have an A appended to the end of the current five digits If your portfolio code needs to change to a different number you will be notified prior to the implementation of the new system Action Code 1 Delete 2 Add 3 Change The 9 digit CUSIP PPN CINS number Optional User Security ID field 14 digits this field can be used as an internal security identifier and is for your company s purposes You can enter any text in this field or leave it blank NAIC National Association of Insurance Commissioners COBOL Data Type X 06 X 01 X 09 X 14 Page 33 2015 AVS User s Guide Last Updated April 4 2015 B J Welcome Test Account Verify the correct company name displays W Automated Valuation Service A product of aisi paunaa ae Select the Choose file for upload button to select the file Portfolio Upload amp Valuation Requests Period End Management eennantnnnntanmn
12. 1 National Association of NA I C Insurance Commissioners Page 38 2015 AVS User s Guide Last Updated April 4 2015 f Transaction Report Record Layout HEADER LINE 1 Header Title 51 Page Number 126 LINE 2 Date 1 Header Title 50 Time 128 Line 3 is blank Line 4 Heading 1 3 Heading 2 16 Heading 3 29 Heading 4 40 Heading 5 54 Heading 6 71 Line 5 Underline 1 3 Underline 2 16 Underline 3 29 Underline 4 40 Underline 5 54 Underline 6 71 DATA Portfolio Number 5 Action Code 21 Cusip 29 Check Digit 44 Security ID 54 Status 71 Insurance Commissioners 2015 AVS User s Guide Last Updated April 4 2015 g Downloading a Valuation Report Go AYS Plus Windows Internet Explorer iota DT Ele Edt Yew Favortes Took Heb x Eyconvert PP Select ig Favorkes ii E Orade PeopleSoft Erterpris New Tab Pstsman EA wii P pandoraRado PA IRA RU AVS Plus Home Searches Portfolios My Account Porttolo Upload amp Valuaton Requests Portfolio Name 00000A NAIC Test Company Download ponttoto Create Portfolio Request Select the portfollo fie to upload to the AVS System andor the valuation type to request and click Submit to continue Action to Take Update C Replacement Period End Management Valuation Type an VOS Securities In Portfolio T VOS Securities That Have Been Reviewed This Year I VOS Securities That Have
13. A IC National Association of die ET AE ID ed Insurance Commissioners _ Name and Password The password is case sensitive and will appear as asterisks when entered After the User Name and Password are successfully TEER Enie your username EE ee entered read and agree to all terms and conditions by selecting TES Ahem Enie your password the check box beside the By Checking the box to the left your agree to all Login terms and conditions label Forgot your password Click Here Select the Login Button Need assistance with logging in SEE EER MS Email Support Call Support 816 783 8500 Terms and Conditions National Association of Insurance Commissioners 2015 First Time Logging In The first time you log in the system will prompt you to select challenge questions and provide answers After established if you forget your password and select the Forget Your Password hyperlink the system will prompt you to enter the case sensitive answers to the challenge questions you previously selected If you provide the correct case sensitive answers the system will display the change password prompts If you are not able to provide the cases sensitive answers contact the NAIC Help Desk by email help naic org or phone 816 783 8500 for additional assistance National Association of NA I C Insurance Commissioners Page 11 2015 AVS User s Guide Last Updated April 4 2015 a Agre
14. DELETE ERROR SECURITY ALREADY EXISTS IN PORTFOLIO UNABLE TO ADD ERROR INVALID CUSIP PPN SECURITY NOT ADDED ERROR SECURITY NOT LISTED WITH SVO SECURITY NOT ADDED ERROR SECURITY GROUP CODE IS 99 RECORD NOT CHANGED DEFINITION The security was successfully added to your portfolio The security was successfully deleted from your portfolio The User Security ID was changed for the security A request to delete a transaction was submitted on a security not currently in your portfolio A request to add a transaction was submitted on a security currently in your portfolio Either the CUSIP PPN number is not a valid CUSIP PPN or the CUSIP PPN number has not been added to our master CUSIP PPN database Sometimes this is an indication that you need to obtain the correct CUSIP PPN however if the security is a valid CUSIP PPN number and not in our CUSIP PPN database resubmit the security the following week The CUSIP PPN is valid but has yet to be listed in the VOS Database Either an SAR has not been filed for the security or one has been filed but not processed and as a result the security has not been added to the VOS database Securities with a group code of 99 cannot be added to the user s portfolio This group code may be used by analysts to track securities whose review is in progress Once a designation is assigned this field will be changed to a valid group code and the security can be added
15. Dow Jones CDX Emerging Markets CDS index Dow Jones COX North American High Yield 100 CDS Index Dow Jones CDX North American High Yieki B CDS Index Dow Jones CDX North American High Yield BB CDS Index Dow Jones CDX North American investment Grade CDS Index Dow Jones CDX North American investment Grade High Volatity CDS Lehman Brothers CMBS ERISA Index Lehman Brothers CMBS High Veld index Lehman Brothers CMBS investment Grade Index Lehman Brothers U S Floating Rate Auto Loan index 1 National Association of NA I C Insurance Commissioners Page 30 2015 AVS User s Guide Last Updated April 4 2015 Welcome Test Account Home Searches Portfolios My Account New Window Help Log Off RSAT Index Search Criteria RSAT Index Search Results Year 2011 Period Q1 X index Name If there are no search results no i results will display s Industry Experience Factor Memo Specify the Year and Period Select the Search button To change the Year or Period select a different value from the drop down menu t Welcome TestAccount Home Searches Portfolios My Account New Window Help Log Off i Industry Experience Factor Memo Search Industry Experience Factor Memo Search Results 1 result E Filename Year 2011 v Period far 2011 Q1 industryExperienceF actor pdf vd EE EE EE Ee EE ee EE OE EL DEE EE EE DERE EED EDE GE EE EE OE EE EG rt ad od 20
16. Exempt Securities In Portfolio V Fing Exempt Securities In Portfolio V Meeste DAE P at Securtioe in Pontot r When the selections are l complete select the Finish Please be aware that files will be retained for 90 days before being deleted EE DE EO OE OE OE EE Oe EE DEEL EL Multiple AVS accounts or TPA view ee dt eee ok N vew vvi wv Home Searches Portfolios New Window Help Log Off Portfolio Upload amp Valuation Requests Period End Management Account Code Account Name Account Code Account Name Please select a portfolio Toggle Fitter View 55026A BCBSM Inc S 19 West Virginia Mut ins Co Gear Piters Portfolio Name Please update the information below and click Finish to save Month End Quarter End AI VOS Securities In Portfolio C ABVOS Securities In Portfolio E F ng Exempt Securities In Portfolio Filing Exempt Securities In Portfolio 7 AI Securities In Portfolio CAN Securities In Portfolio Ci Year End Addendum AIVOS Securities In Portfolio T ANVOS Securities In Portfolio E F ng Exempt Securities In Portfolio Fing Exempt Securities in Portfolio 7 All Securities In Portfolio All Securities In Portfolio E Fanish Please be aware that files will be retained for 90 days before being deleted National Association of NA i C Insurance Commissioners Page 42 2015 AVS User s Guide Last Updated April 4 2015 g Home Searches Portfolios My Account New Window Welcome
17. Foreign Exchange Rate Search Results 15 results Year 2011 9 Period far Z 2011 Australa AU DOLLAR Belguim BE FRANC EN Germany DEUTSCHMRK Euro EURODOLLAR France FR FRANC Switzerland FRANC Netherlands GUILDER Hong Kong HK DOLLAR taly LIRA Finland MARKKA Spain PESETA Mexico PESO Great Britain POUND Japan YEN his Automated Valuation Service Home Searches Portfolios My Account Foreign Exchange Rate Search Criteria Foreign Exchange Rate Search Results ss Name Year Period Q1 v National Association of NA I C Insurance Commissioners New Window Currency Name Welcome Test Account 1 0311 0 0350 1 0286 0 7208 1 4099 0 2149 1 0852 0 6397 0 1284 0 0007 0 2371 0 0085 0 0838 1 6034 0 0121 Help and Period and Home Searches Portfolios My Account New Window Help Log Off Search results will enter the CUSIP 2 display under the Ex and or Issuer Ex Dividend Search Criteria Ex Dividend Search No results found Dividend Search label A Name E liia nE Period az jp OSPA CompanyNames Descrpfon PaymentMetode Rae ExDividendDalee Pay Date record count of the results will also display Select the Search ali TTT lt button dae If there are no search Issuer Name results the No Results To clear the Found message will information display entered select the Clear hyperlink j Foreign Exchange Rate Search Welcome Test Account Log Off
18. NAIC Test Description AJ pad lt a o X11111C01 NAIC Test issuer NAIC Test Description CD Adc hyperlink to VIEW Select the Search EED NAIC Test issuer naas vars additional button XT1111CF6 NAIC Test Issuer NAIC Test Description CF Add information X11111CG4 NAIC Test issver NAIC Test Description CG Add 3 p X11111CH2 NAIC Test Issuer NAIC Test Description CH Add Select the Clear ma pane Ee Select the single 5 X11111063 NAIC Test issuer NAIC Test Description DG Add A i hyperlink to remove N er MAC Teal Dancin DP ti arrow to view the data entered XLLOQI NAC Tost auer nen aE next page of search To conduct and X111110R9 NAIC Test issver NAIC Test Description OR Age l h H X11111057 NAIC Test Issuer NAIC Test Description OS Add resu ES or t e Advanced Search XIIMOTS NAIC Test issuer NAIC Test Descroton DT double arrow to view select the Advance en EE the last page 3 A 2 K11111DVO NAIC Test issuer NAIC Test Description OV Add 3 Criteria hyperlink X1111108 WAC Test issuer NAIC Test Descrpton OW maa di If there are no The Specify search results the No Advanced VOS FE Results Found Criteria window message will display displays SRR EER RRR ERE REET ER ER ER ER ER ER ER ER ER ER ER ER ER EER EERE EE ER EE RR ER ER RE N A I C National Association of Insurance Commissioners Page 18 2015 AVS User s Guide Last Updated April 4 2015 b Specify Advanced VOS FE Search Criteria An Ad
19. NAIC Test issuer NAIC Test Description DR Add arrow to view the last X11111DS7 NAK Test issuer NAIC Test Description DS Atd pa ge X111110TS NAK Test Issuer NAIC Test Description OT Add X111110U2 NAIC Test Issuer NAIC Test Description DU Add XI11110V0 NAIC Test issuer NAIC Test Description DV Ag If there are no search X11111DW8 NAK Test Issuer oo NAIC Test Description DW Add results the No Results 1 gt Found message will display d VOS FE Current Issuer Search Search results will Welcome TestAccount display under the VOS FE Search ee label A record Tie A Automated Valuation Service Select the Current Search button as sed Wi id Was kke ee t9 i count of the i VOS FE Search Criteria VOS FE Search 1 result results will also Enter the Issuer Aai EER Ee display Number and or the i xmn NAIC Test suer Issuer Name i ops wers Select any blue Issuer Number X11111 hyperlink to view Select the Search Issuer lame NAIC Test issuer additional button information If there are no search results the No Results Found To clear information entered select the Clear hyperlink ieee ne err ee message will display 1 National Association of NA I C Insurance Commissioners Page 20 2015 AVS User s Guide Last Updated April 4 2015 e VOS FE Historical Issuer Search EER EE EE EE EE EE ER EE EE EE EE EE EE RE EE ER EE EE EE ER EE EE EE ER EE EE EE ER ER EE EE ER EE
20. National Association of Insurance Commissioners Page 50 2015 AVS User s Guide Last Updated April 4 2015 D indicates that the value claimed by the reporting insurance company in its SUB 2 filing was disapproved the value entered in the status field of the VOS Database screen was determined by the SCA Companies Group and the two values differ materially R indicates that the information submitted in support of a SUB 1 or SUB 2 filing is incomplete and the SVO SCA Companies Group has issued an InfoRed reduest for the missing information ii When entered in the comment field of the VOS Database screen a indicates that the value claimed by the reporting insurance company in its SUB 2 filing was disapproved the value entered into the comment field of the VOS Database screen was determined by the SVO SCA Companies Group and the two values differ slightly e indicates that the value entered in the comment field of the VOS Database screen differs materially from the value claimed by the reporting insurance company for the SCA investment This administrative symbol is only used with the status field administrative symbol D discussed above i indicates that the value entered in the comment field of the VOS Database was not calculated on the basis of 12 31 financial statements iii When entered by an insurance company in its annual financial statement blank J means when used in context of SCA Companies Group that the valuation reporte
21. Search Criteria Letter of Credit Banks Search Results EzE Bank Name Bank Branch Sovereign ne N oi N If there are no gered 2012 search results no results will display 3 H EER EE EIER RR RR R RI ER RE REISE RISES SERRE RISER R ERIE RRB RR N National Association of NA I C Insurance Commissioners ce 2015 AVS User s Guide Last Updated April 4 2015 n Group Code 99 Specify the Year and Period Select the Search button To change the Year or Period select a different value from the drop down menu i Automated Valuation Service A prod Group Code 99 Search Criteria 2011 x 4a Period A A y y Automated Valuation Service Q1 vv i Home Searches Portfolios My Account Group Code 9 Search Results 343 results CUSIP 00788 AAS 0082514 03201 AC1 034468AE2 034468AF9 067387AR1 06740LBDS 092833GT3 10059 ABS 10059 AC3 10120SA 3 12495RAAS 12548 AA0 12548 AB8 12548 ACB 126349AC3 14066EAA9 1S136EAA2 AEGIS ALABAMA VENTURE FD LP AFFILIATED LN PROGRAM FORSTUDENTS FDG TR 2009 1 AMPAC HLDGS LLC ANDREWS INTL INC ANDREWS INTL INC BARCLAYS FINL LLC BARCLAYS BK PLC BLAIR CNTY PA BOSTON CMNTY LN FD INC BOSTON CMNTY LN FD INC BOSWELL J G CO ATIVE INS HLDGS INC TRANSMISSION CO LLC issuer Name C BASS CBO IV RESECURITIZATIONTRUST CHP NEW MKTS INVT FD LLC CHP NEW MKTS INVT FD LLC CHP NEW MKTS INVT FD LLC
22. Search results will display under the Foreign Exchange Rate Search Results label A record count of the results will also display New Window Help Log Off If there are no search results no results will display Page 24 2015 AVS User s Guide Last Updated April 4 2015 tar A k Mutual Fund Search PO Specify the Year and Period Enter a CUSIP Complex Name and or Fund as Home Searches Portfolios My Account Name i gt Mutual Fund Search Criteria Select the Search Year 2011 button CUSIP X11111 Period To change the Year or Period re select a value from the drop down und name menu Complex Name enter information Mutual Fund Search CUSP Complex Name Fund Name Welcome Test Account Sa gis aa Search results will display under the Mutual Fund Search label A record count of the results will also display Classification If there are no search results no results will Specify the Year and Period button To change the Year or Period select a different value from the drop down menu ETE EE EE ED EE ee DE ORE EL display Select Clear to re EE EO MA 4 l Counterparty Designation Search u i Welcome Test Account Home Searches Portfolios My Account Help Log Off z Ss a ER A S EE EE i Select the Search p
23. Test Account AVYS aa Automated Valuation Service A product Ee mm j A message will display Portfolio Upload amp Valuation Requests Period End Management Portfolio Name 00000A NAIC Test Company Piease update the information below and click Finish to save Month End Quarter End All VOS Securties In Portfolio MF All VOS Securties In Portfolio Cj Filing Exempt Securities In Portfolio Filing Exempt Securities In Portfolio 7 All Securities in Portfolio T All Securities In Portfolio Cj Year End Addendum All VOS Securties In Portfolio T All VOS Secur ies In Portfolio E Filing Exempt Securities In Portfolio V Filing Exempt Securities In Portfolio V All Securities In Portfolio Ci Please be aware that files will be retained for 90 days before being deleted All Securities In Portfolio N 7 Alert Notification Settings indicating that the Period end information updated successfully The Alert Notification Settings enable email notifications anytime there is a change to any security in your portfolio AvS Automated Valuation Service A prod Home Searches Portfolios My Account EE EE EE EE EE EE EE EE EE EE De Ee TE ee Welcome Test Account To set Alert Notification settings select the Alert ede IN ma Bulletin Board Lates Portfolio Upload amp Valuation Requests anne Notification Settings option Sp otodDd wa a from the Portfolios menu All intere
24. change in circumstances or economic financial or business conditions would create an uncertainty about the issuer s capacity to make timely payments An NAIC 3 obligation should be eligible for less favorable treatment under the NAIC Financial Conditions Framework NAIC 4 is assigned to obligations of low quality Credit risk is high and the issuer s credit profile is volatile These obligations are highly speculative but currently the issuer has the capacity to meet its obligations This means that the likelihood that interest principal or both will be paid in accordance with the contractual agreement is low and that an adverse change in circumstances or business financial or economic conditions would accelerate credit risk leading to a significant impairment in the issuer s capacity to make timely payments An NAIC 4 obligation should be accorded stringent treatment under the NAIC Financial Conditions Framework NAIC 5 is assigned to obligations of the lowest credit quality which are not in or near default Credit risk is at its highest and the issuer s credit profile is highly volatile but currently the issuer has the capacity to meet its obligations This means that the likelihood that interest principal or both will be paid in accordance with the contractual agreement is significantly impaired given any adverse business financial or economic conditions An NAIC 5 Designation suggests a very high probability of default An NAIC 5 obligation sh
25. gt or reus GE issuer Name Search results will O m American United Life display under the To change the mae Aen er company Surplus Notes NAIC1 Year or Period Search Results label selecta different i i F General American Life F value from the l RR OE Arecord count ofthe drop down menu Jackson National Lite results also displays John Hancock Mutual Life ins Co Massachusetts Mutual Life Ins Co an AAA AAAAARARAASRAAAAAAOnARAnAAsnnannanonansnnaenaannansnsal Automated Valuation Service A prod Surplus Notes NAIC1 Search Criteria Surplus Notes NAIC1 Search Results Year 2011 Period 101 v issuer Name Metropolitan Life Ins Co Minnesota Life Ins Co Mutual of Omaha Nationwide Mutual ins Co New England Mutual Life ins Co New York Life ins Co Ohio National Life Ins Co Pacific Mutual Life ins Co Penn Mutual Life Principal Mutual Life ins Co Prudential insurance Company of America 4 Home Searches Portfolios My Account If there are no search results no results will display National Association of NA I C Insurance Commissioners Page 29 2015 AVS User s Guide Last Updated April 4 2015 q Surplus Notes NAIC2 NAIC6 gee EER RE RR Welepine TEST ACCOURt Specify the ean AS and Period Automated Valuation Service A product ol Sea rch results will Ho
26. 00749 AA ADVANTAGE CAP HAWAN INVS L P 215085 00749 AB ADVANTAGE CAP HAWAII INVS L P 215086 00750 AA ADVANTAGE CAP ALA PARTNERS ILP 215087 OO7SZAA ADVANTAGE CAP NEW YORKPARTNERS IL P 215088 00752 AB ADVANTAGE CAP NEW YORKPARTNERS IL P 215089 OO7SKFAA ADVANTAGE CAP FLA ST TAX CRINV ILLC 215092 OO7SK AA ADVANTAGE CAP MO STATE TAX CRINV ILLC 215093 00769 AA ADVANTAGE CAP PARTNERS V LP 215137 00769 AG ADVANTAGE CAP PARTNERS V LP 215138 O0780 AA ADVANTAGE CAP COLO PARTNERS I 215139 00780 AS ADVANTAGE CAP COLO PARTNERS I 215140 00781 A4 ADVANTAGE CAP PARTNERS XIL P 215141 00781 AB ADVANTAGE CAP PARTNERS XIL P 215142 ET gt Welcome Test Account sd A pre Automated Valuation Service Home Searches Portfolios My Account New Window Help Log Off Schedule BA Search Criteria Schedule BA Search Resuits Year 2011 Period a1 7 CUSP issuer Name Security D Search results will display under the Schedule BA Search Results label A record count of the results also displays If there are no search results no results will display NAIC National Association of Insurance Commissioners Page 28 2015 AVS User s Guide Last Updated April 4 2015 p Surplus Notes NAIC1 Welcome Test Account and Period l Automated Valuation Service A prod Select the Search Surplus Notes NAIC1 Search Criteria Surplus Notes NAIC1 Search Results 20 results button
27. 011 0 6666 2 260 794 682 00 335 877 881 00 58 378 469 00 2 655 051 032 2011 99999 6666 1 226 079 468 00 133 587 788 00 15 837 846 00 1 375 505 102 Asset Totals 4 030 556 134 TPAs No TPAs have been assigned to this Subscription i PG Ge Ge Nnt ese The My Subscriptions window displays a current snapshot of your account License Agreement System Users Assets Annual Fee and TPAS Select the Print button to print a copy of the My Subscriptions window National Association of NA I C Insurance Commissioners Page 15 2015 AVS User s Guide Last Updated April 4 2015 4 AVS Home Page Post Login AVS Home Page Post successful login and agreement to all terms and conditions the AVS Home page displays From the AVS Home page a variety of actions uploads searches can be completed as well as viewing the lates Bulletin Board posts MERE EIER EIER EIER RI RR EIE ERIE RR RR RRR RR ER JSE EE EE EER EER RR EER EER EER RE EE RR EE ER EE ER ER ER Ee asrnanssssi Biome Log Off View Al Posts Searches Portfolios Bulletin Board Latest Posts To Subject AVS Users AVS Users 1st Qtr Exchange Rates AVS Users System Maintenance AVS Users Quarter End Processing AVS Search VOS and FE Quick Search ps aamaamasman Y VOS and FE Advanced Search Ex Dividend Foreign Exchange Rates Mutual Funds Counterparty Designations Letter of Credit Banks 1 Qtr End Processing Compl
28. 1 55 10 2012 12 31 4841 000000096 357 11111 CF 8 1BVI 2 2012 12 31 55 10 2012 12 31 4841 000000093 332 1111 CY 9 1BFE 1FE 2012 12 31 8000 000000137 409 11111 DL 7 1BFE 1FE 2012 12 31 8731 000000107 982 11111 ONS 1BFE 2FE 2012 12 31 5112 000000115 484 11111 Q 3 1BFE 2FE 2012 12 31 4924 000000127 929 1111 DY 5 1BFE 2FE 2012 12 31 4924 000000119 830 11111 EB 4 1BFE 2FE 2012 12 31 4924 000000130 119 Once you have opened your file 11111 EF 3 OBF 2FE so 491 11111 EL 8 OBF 2FE 2010 01 ae 11111 EP 6 1BFE 3FE 2012 12 31 4911 000000115 500 this is what you will see x11111 E92 OO BF 1FE 6199 1111 FM1 OBF AFE 4833 11111 FNS 1BFE 1FE 2012 12 31 4900 000000134 953 11111 FP 6 1BFE 1FE 2012 12 31 4900 000000155 083 If you have a software program aut Er Ler 2FE 2012 12 31 4800 000000137 359 11111 FY8 1BFE 1FE 2012 12 31 4813 000000163 795 11111 G01 1BFE 2FE 2012 12 31 4841 000000101 659 that works with AVS you will asi iit i aE wese EN 11111 GN 4 1BFE FE 12 31 2834 11111 GP 3 ISFE 2FE 2012 12 31 2834 000000101 848 NPIV IMPONE EDE ME 11111 Ga 1 1BFE 2FE 2012 12 31 2834 000000105 580 x11111 GX 6 OBF 3FE 11111 HA 7 1BFE 1FE 2012 12 31 6100 000000117 138 1111 HK 2 1BFE 2FE 2012 12 31 6300 000000132 261 If you do not we suggest that 11111 HPS 1BFE 2FE 2012 12 31 3800 000000114 606 x11111 HS 3 1BFE 2FE 2012 12 31 3800 000000100 858 you save the file 1111 Hz 6 1BVI 2 2012 08 07 10 2012 12 19 1040 000000110 000 1111
29. 11 F 2012 i i Search results will display under the Industry Experience Factor Memo Search Results label A record count of the results also displays Select the Filename blue hyperlink to view details NAIC National Association of Insurance Commissioners Page 31 2015 AVS User s Guide Last Updated April 4 2015 6 Portfolio Upload amp Valuation Request Portfolios The Portfolios option is where you will perform most portfolio maintenance To upload your portfolio file or submit valuation requests select the Portfolio button on the AVS tool bar The Portfolios dropdown displays Select the Portfolio Upload amp Valuation Requests Welcome Test Account i ETE EE EE EE EE OE EE GE EE EE EE EE Pe ee Ee DE Oe EE OE EE EE EE ee EE z On the AVS Tool Bar select Portfolios The Portfolios drop Help Log Off j eeg down menu displays To Si Period End Update Date Allinterested Parties 2 Aert Notification Settings Dec 18 2012 Select the Portfolio Upload amp Meee Partos e ese Valuation Requests option AI AVS Subscribers November Month End Dec 18 2012 The Create Portfolio Request AVS Search AVS Portfolio urities qi q YOS end FE Gan eee ote Woot amp Vato Renuesis Conn Soon O displays CUSIP EE Structured securities results will be incorporated Period End Update VOS and FE Advanced Search ord into AVS in early Fall 2013 Until then the sea i Alert Notific
30. All interested Parties 2012 Year End Schedule All AVS Subscribers November Month End AVS Search VOS and FE Quick Search CUSIP VOS and FE Advanced Search Ex Dividend Foreign Exchange Rates Mutual Funds Counterparty Designations Letter of Credit Banks Group Code 99 Schedule BA Surplus Notes NAIC1 Surplus Notes NAIC2 NAIC6 RSAT index List Industry Memo Interested Parties Mortgage Loan industry Experience Factor for 12 31 12 AVS Portfolio Portfolio Upload amp Valuation Requests J DIe FOTINO Jpoag Period End Update Alert Notification Settings Alert Notification Report Purposes and Procedures Manual Date Dec 18 2012 Dec 18 2012 Dec 18 2012 Coming Soon Structured securities results will be incorporated into AVS in early Fall 2013 Until then the structured securities Web based application can be accessed at hitps isis naic org yehe Structured securities application makes the backed securities CMBS more easily accessible This information helps to determine the risk based capital RBC requirements for the non agency RMBS CMBS securities owned by U S insurers More Welcome Test Account The AVS License Agreement for Insurer subscription information displays Review the License Agreement for Insurer Exhibit A select the checkbox beside the have read Exhibit A and select the Next button If you select the Cancel button you will exit the A
31. As must complete their own AVS License Agreement including the Designated Third Party Administrator Authorization form specifying the TPA to which they are granting access N A IG National Association of Insurance Commissioners Page 7 2015 AVS User s Guide Last Updated April 4 2015 e Billing Information Insurer Annual Access Fee The AVS annual fee shall be determined for each licensee separately Licensees must fully disclose all information required by Exhibit A of this agreement The AVS annual fee will be determined by identifying the appropriate fee from the table below for the total of the combined columns for all companies listed on Exhibit A Third Party Administrator Fees The schedule of fees that applies to the AVS Third Party Administrator Service is 4 150 regardless of the number of insurers covered However this fee does not include the agreement or fees for each insurer that is administered As mentioned above each insurer must have a separate agreement for AVS whose fees will be that of any other insurer Non Insurer Banks Financial Institutions Investment Firms and other interested parties are able to obtain access to AVS for an annual fee of 10 000 Annual AVS Fee Value of Schedule D Securities Lower Range Higher Range AVS Fee 200 000 000 000 32 450 00 100 000 000 000 200 000 000 000 00 27 050 00 50 000 000 000 21 550 00 25 000 000 000 16 250 00 10 000 000 000 10 800 00 3 000 000 000
32. EE LE RE AE ER EE 47 INF Des al RE OE RD AR GN GR ee Ge WO GR ee ER Ge ae ee Di 47 Ms Weel dle Ao olie ide ER RE EE EE EE ET EE EE EE EE N 49 g SVOAdministrative SYDE ie ect rata sate OE DE GR sale tented Ed EG NEn 49 HOV AOU CS AA AE AE EE ER EE ER OE ER N AE 52 i SVO Group Code Extensions EXtensiOf ese ee Ee Ee N a oe EE Re ee E ae Ge se eo ER ee 53 j MEER EE N N EA AE EE oats acee cosas 53 k Prce Review Datt RE EE N OE EE EE EE OE EE N 54 MEE ss EN EE EE EE OE N EE HE EE OE 54 2015 AVS User s Guide Last Updated April 4 2015 Statement of Confidentiality The information in the NAIC s Valuation of Securities VOS Database made available through the Automated Valuation Service AVS is confidential and is maintained for the benefit of NAIC members who are the chief insurance regulatory officials in the states and territories of the United States Access to AVS is provided only on the basis of a signed License Agreement which limits the use of the information obtained to defined regulatory purposes It is inappropriate and inadvisable for unauthorized users to seek access to or use the information contained in the VOS Database provided through AVS The following relevant material is reprinted from the Purposes and Procedures Manual of the NAIC Securities Valuation Office For NAIC Members Only Official Source Association Values are produced solely for the benefit of NAIC members NAIC members acting in their capacity as
33. EE n Select the Historical Search button Automated Valuation Service Home Searches Portfolios My Account Specify the Year and Period and VOS FE Search Criteria de C Current Historical VOS FE Search 1 result issuer Number enter the Issuer ver ons Perio or Number and or Issuer a Q3 Name Issuer Number X11111 Year End Addendum Issuer Name NAIC Test issuer Select the Search button ms Ta To clear the information entered select the Clear hyperlink issuer Name NAIC Test issuer f CUSIP Detail amp Adding Security to Portfolio RIERA RRR ERIE ER E ER E R EIE ER EER RI SERIES TERRIER RI RETR RETR Search results will display under the VOS FE Search label A record count of the results will also display Welcome Test Account Select any blue hyperlink to view additional information 2 Select the single arrow to view the next page of search results or the double arrow to view the last page If there are no search results the No Results Found message will display See ee eee et ee ee rere errors A security that is not currently in your portfolio is easy to add by searching for the security and following blue hyperlinks until the CUSIP Detail window displays AVS Automated Valuation Service Home Searches Portfolios My Account CUSIP Detail issuer Name NAIC Test issuer CUSIP
34. HOT Been Reviewed This Year Filing Exempt Securities In Portfolio All Securities in Portfolid Requested Dec 26 2012 03 26 Pu To download a fie simply click on the desired ink Ad hoc Valuation Files ingisted By Portfolio File Transaction Report Account Test Not Requesies Valuation Fie Welcome Test Account Help Log Off Completed Dec 26 2012 03 35 Pu D 0 Jes Pages getye Tos All Valuation files will be available for 90 days Click on the file type in order to save the file or open view it s cst Dec 26 2012 03 26 Pu Sarath Teni Not Dec 26 2012 03 35 Pu CST gt T Requested cst Dec 26 2012 03 26Pu ccount Test Not Dec 26 2012 03 35 Pu CST gt Requested CST 201 Pt Not 6 201 pu Dec 26 2012 03 26 Aooual Taal ot Dec 26 2012 03 3 CST Requesies CST Dec 26 2012 03 26 Pu Not Dec 26 2012 03 35 Pu s Account Test he cst Requesies cst 1 12 Pu 1 1S Pu erg id dan Account Test Update De wnked Not Reqvesies ag DA Period End Valuation Files zi EEE rated tes a Ron B start Y A x N 0 P R ME 0 inbox Mate Bu 253 Internet Explo W 3 Microsoft Word E 2 Windows Explorer I TEST AvS Vasati Si svorr izorpa 09 10 57AM IA TEST AYS Valuation File txt Notepad 2012 01 16 15 35 16 NAIC Test SER X11111 AHO 1B8VI 2 2012 12 31 55 10 2012 12 31 4841 000000098 038 11111 a 1 1BVI 2 2012 12 3
35. IC Designations 1 through 6 for bonds and P1 through P6 and RP1 through RP6 for preferred stocks are quality ratings from which the required EVES ore Commissioners Page 47 2015 AVS User s Guide Last Updated April 4 2015 Schedule D accounting value is determined and are defined in the Purposes and Procedures Manual of the NAIC Securities Valuation Office Bonds and short term promissory instruments are divided into six quality categories for NAIC rating purposes ranging from 1 highest to 5 lowest for non defaulted bonds plus one category 6 for bonds in or near default The term bond as used here means any form of promissory note with a maturity of over one year at the time of issue Short term 397 days or less to maturity promissory notes such as commercial paper certificates of deposit etc will be valued in the same manner as bonds The meaning of each NAIC Designation is as follows NAIC Designations are the specific alphanumeric symbols in use by the NAIC SVO to denote a category of credit quality When applied to Bonds and to derivative counterparties the NAIC Designation appears without a prefix The valuation indicator P is placed in front of the NAIC Designation to indicate that the SVO has classified the security as a perpetual preferred stock The valuation indicator RP is placed in front of the NAIC Designation to indicate that the SVO has classified the security as a redeemable preferred stock for the purposes of v
36. IT 4 1BVI 2 2012 06 19 55 10 2012 12 19 1040 000000110 000 11111 ER 5 1BVI 2 2012 08 30 55 10 2012 12 19 1040 000000100 366 National Association of NA I C Insurance Commissioners Page 40 2015 AVS User s Guide Last Updated April 4 2015 h Portfolio Valuation Record Layout Header Starting position Length Field Description COBOL Data Type 1 6 AVS Portfolio Number X 06 8 16 Date File Created X 16 25 2 File Type X 02 28 40 Company Name X 40 68 65 Reserved X 66 Body Starting position Length Field Description COBOL Data Type 1 6 AVS Portfolio Number X 06 8 6 CUSIP PPN CINS X 06 Issuer Number 15 2 CUSIP PPN CINS Issue X 02 Number 18 1 CUSIP PPN CINS X 01 Check Digit 20 1 Market Indicator A L U X 01 or blank 22 1 Price Code X 01 O no price recorded 1 numeric price 2 3 UP 24 1 Classification X 01 26 1 Source X 01 28 1 Price Origin X 01 Internal E External 30 1 Designation Indicator X 01 AA 31 4 Reserved X 04 35 5 NAIC Designation X 05 41 10 Review Date X 10 52 14 User Security ID X 14 67 2 SVO Group Code X 02 70 2 SVO Group Code X 02 Extension 73 10 Price Date X 10 84 4 SIC Code X 04 89 13 Price NNNNNNNNN NNN X 13 102 31 Reserved X 31 For Filing Exempt securities the Designation Review Date SVO Group Code and SVO Group Code Extension fields will be blank For securities that are not from VOS or Filing Exempt the Designation Designation Review Date
37. RedueSt ses see ee ee ee ee RR ee Re ee ee ee ee RE RR ee 32 a Pre Upload Update or Replacement ses ie ie ER og EE oie nn GE ee ie ge De RE ie 33 D POS IG ie EE ie ee Ge Ee Ge GE EG ee de GOD 35 6 Submit Valuation Reati st ee Ed GE RE ee RR ee ER EE RE ee GR n Ge se er ee ei 36 d Valuation Reguest Complete ss EG EA Gie ee ie ie Oe EG Re GE Ee AG ee Ge REG ae 37 e Transaction REBOFL spesie De EG Ge AE ee Ge ee de Ge Ge ee EG Gee GE Ge Ge Di ie ee Ge ee GEE 38 fe Transacdtiom Report Record Layout EE ETE EE N Ee ek DEE Ee Ee ee Re Ee Ee NG GE GE oe N Ee 39 e IDOWMOACING a Valdstion Rep ss Eie ES EG Ge ee n ee ee ee Ge GE AE DE ee Gie 40 h Portfolio Valuation Record LAYOUT cccccccssssscccccsesecccccesseccecceuseeceesauseceesseaueecessauneceesseaeaseeeeseceesaeaeeessagaesss 41 i Period End Management pass RR ee on EE ee N GE oe on be ai etse ge on OG ee Eg ee ee 42 Te Alert Notification Setin ei ee ER ee ee Ee Go ee Go ee er EP ie oe geo ie ie ae Ge ES 43 3 ICME INO UITIG tien ODOM ei nde ee ei Ge EG ie ee ie TR A5 9 Descipuot of VOS Data oe es ee oe ee eo DE eo DE De 46 a FNMA GNMA FHLMC and FHA sesse ese ee ede ee ee eed ee eed ee ee eed ede ee ee ee ee de ee de ee ee ee AA ee Ge 46 b CUSIP Number Private Placement Number and CINS cccccccccccsesccscccseccesesceececsceeseseeeseceeeuseseeeseeueeuseseeneecss 46 C Market EO ee EE ee ie Ee on pce eens cet icin eo eee E eo be ee ee 47 N EE EE AE
38. SVO Group Code and SVO Group Code Extension fields will be blank N A IG National Association of 4 Insurance Commissioners Page 41 2015 AVS User s Guide Last Updated April 4 2015 i Period End Management Update Period End Management To generate a periodic valuation file it is possible to schedule periodic reguests for one or more of the following periods Month End Ouarter End Year End Addendum based on the current portfolio If you only select the Month End option the valuation file will generate for months that are not a Ouarter end or Year end EDELE EE EE ELE EE DE DEE EO ELLEN s Welcome Test Account i To generate a periodic Automated Valuation Service A product of corresponding check boxes Home Searches Portfolios My Account New Window Help Log Off Portfoto Upload amp Valuation Requests Period End Management In this example a Month End Portfolio Name 00000A NAIC Test Company i o 5 Please update the information below and cick Finish to save i Valuation file will generate Month End Quarter End 4 for all VOS securities and a ate W Leen L Year End and Addendum file Filing Exempt Securities In Portfolio Filing Exempt Securities In Portfolio 7 will generate for all filing All Securities In Portfoto All Securities in Portfolio D ae 3 exempt securities in the Year End Addendum ALVOS Securties in Portfo o T AIVOS Securities In Portfolo T po rtfolio Filing
39. Test Description DP NAIC Test Description DQ NAIC Test Description DR NAIC Test Description DS NAIC Test Description DT NAIC Test Description DU NAIC Test Description DV NAIC Test Description DW The search results display under the VOS FE Search label Automated Valuation Service A produc Home Searches Portfolios My Account VOS FE Search Criteria VOS FE Search 276 results X11111AH added to Portfolio CUSP a xian wee Identify the correct ARE EIER E IERE EE RI RETR RRR RI RR RR RI ER RI RE EIE RR ER RE RR Current Historical Enter the first 5 KAAS CUSIP digits of the h SERPE ar ag To remove the CUSIP and conduct a xar111 01 select the Remove wildcard Search man hyperlink xunnicH2 To add the CUSIP EE select the Add X111110P3 hyperlink X111110Q1 X11111DR9 To view CUSIP details select the CUSIP hyperlink X11111DS7 X11111DTS X11111DU2 X111110V0 X11111DW8 National Association of NA I C Insurance Commissioners TE 2015 AVS User s Guide Last Updated April 4 2015 AVS i Ex Dividend Search Specify the Year Specify the Year and Period Select the Search button To change the search criteria reselect a value from the drop down menu Automated Valuation Service A prod Automated Valuation Service A pro Home Searches Portfolios My Account Foreign Exchange Rate Search Criteria
40. VS application Select the View My Subscription option on the My Account menu aa art D Eer EE EDE E TED ETE DIE EK OES The My Subscriptions window displays The latest edition of the eeh Purposes and Procedures is available on the dashboard in a PDF file National Association of NA I C Insurance Commissioners Page 14 2015 AVS User s Guide Last Updated April 4 2015 Automated Valuation Service A produc Home Searches Portfolios My Account New Window My Subscriptions Account Hame NAIC Test Company Welcome Test Account Help Log Off Current 000004 NAIC Test Company Prt License Agreement on file with the NAIC Accepted by TEST User on behalf of On file with the NAIC on 12 27 2012 Name NAIC Test Company Account Code 00000A Subscription Period Feb 01 2012 Jan 31 2013 Current Subscription Price 7 500 00 Billing Contact Accourt Test testacct Accounts Type General and Separate System Users Click Agreement Authority User ID First Name Last Name Yes testacct Test Account Assets The following insurance companies are either the Licensee or affiliates subsidiaries of the Licensee to be covered by the 2012 License Agreement The company listed first must be the company named as the Licensee under which the AVS account is created Changes to Exhibit amp can be made annually before January 31 Year Company Code Group Code Separate Account Id Bonds Preferred Stock Common Stock Total 2
41. VS User s Guide Last Updated April 4 2015 a Contact Information Questions about becoming an AVS subscriber or questions regarding your company s securities portfolio and billing should be directed to National Association of Insurance Commissioners AVS Administrator 1100 Walnut Street Suite 1500 Kansas City MO 64106 Phone 816 783 8300 E mail securitiessupport naic org For assistance with your ID or password please have the following information available AVS User ID and password AVS company number usually the NAIC company code system contact name and type of browser used Then contact Help Desk 816 783 8500 E mail help naic org Questions about individual securities should be directed to National Association of Insurance Commissioners Capital Markets amp Investment Analysis Office One New York Plaza Suite 4210 New York NY 10004 Phone 212 398 9000 Fax 212 382 4207 E mail svoinguirydesk naic org NOTE Securities are assigned to analysts based on SIC Code Corporate Department or their filing type Municipal and Structured Departments A complete list of analysts and their assignments is posted at www naic org documents svo_contacts pdf b System Requirements AVS performs optimally under Microsoft Internet Explorer version 7 and version 8 and under the two most current major versions of Firefox i e 8 x and 9 x Customers will not be required to load any additional softwar
42. Verify the Email address and Portfolios that display are Automated Valuation Service A product of correct Home Searches Portfolios My Account New Window Help Log Off Select the Alert Options to Ee Go to Report p Recetve Aerts f ee receive by selecting the Email testaccount test com i s N Portfolios applicable Radio Buttons 00000A NAIC Test Company Qo sees ee pad Alert Options C only VOS Only FE Both VOS and FE When finished select the Save button To view the Alert Notification The following changes to the database will trigger the AVS alerts _ Report you can select the Go To Report hyperlink or e Addition of securities to the VOS FE database select the Alert Notification Report option from the Portfolio menu NEER EER EER EER ER ER RR EE RR rr ER ER RR EE DR EE RR RE ER ER RR RE RR EE RE RE ER ER rrr rie e Designation changes e Security is deleted vendor no longer rates the security Please Note Alerts are emailed only after the feature is enabled for your ID 1 National Association of NA I C Insurance Commissioners Page 44 2015 AVS User s Guide Last Updated April 4 2015 8 Alert Notification Report Alert Notification Report amp Report Criteria Once you have received an alert you can retrieve information at any time within the next 90 days or request a report that displays all Alerts generated within the same 90 day period i nr I l Wel
43. aluation under SAP NAIC 1 is assigned to obligations exhibiting the highest quality Credit risk is at its lowest and the issuer s credit profile is stable This means that interest principal or both will be paid in accordance with the contractual agreement and that repayment of principal is well protected An NAIC 1 obligation should be eligible for the most favorable treatment provided under the NAIC Financial Conditions Framework NAIC 2 is assigned to obligations of high quality Credit risk is low but may increase in the intermediate future and the issuer s credit profile is reasonably stable This means that for the present the obligation s protective elements suggest a high likelihood that interest principal or both will be paid in accordance with the contractual agreement but there are suggestions that an adverse change in circumstances or economic financial or business conditions will affect the degree of protection and lead to a weakened capacity to pay An NAIC 2 obligation should be eligible for relatively favorable treatment under the NAIC Financial Conditions Framework NAIC 3 is assigned to obligations of medium quality Credit risk is intermediate and the issuer s credit profile has elements of instability These obligations exhibit soeculative elements This means that the likelihood that interest principal or both will be paid in accordance with the contractual agreement is reasonable for the present but an exposure to an adverse
44. asnnnnrtnnncnnnnnngsnnn ny tere ST Ee onuiG Portfolio Name 00000A NAIC Test Company Download portfolio gg vessssensssncnseestnnnnnnsnsennrsnnnsnens TT o upload to the system Create Portfolio Request Select the portfolio file to upload to the AVS System and or the valuation type to request and click Submit to continue The Choose File to Upload ER ee window displays Select the file to upload and select the Open button The Create Portfolio Request window Action to Take Update Replacement Valuation Type au VOS Securities In Portfolio VOS Securities That Have Been Reviewed This Year I VOS Securities That Have NOT Been Reviewed This Year displays 7 Filing Exempt Securities In Portfolio T AN Securities In Portfolio Specify the Action to Take and select the Update or To downlad a fie simply click on the desired link Replacement option Ad hoc Valuation Files Requested intiated By Portfolio File Transaction Report Valuation File Completed If you do not want to request a Valuation Type select the Period End Valuation Files Completed Period End File No Period End valuation files available Please be aware that files will be retained for 90 days before being deleted Multiple AVS accounts or TPA view as nn en een Automated Valuation Service A product of maa a SO If you are associated to Home Searches Portfolios New Window Help Log Off i E multiple AVS account
45. ation Report structured securities Web based application can 3 Foreign Exchange Rates be accessed at https isis naic org RE eee ee ene a Mutual Funds ms EE IE GEE Re The structured securities application makes the RE RE ar Tee modeled data for residential mortgage backed Group Code 99 securities RMBS and commercial mortgage Schedule BA backed securities CMBS more easily Surplus Notes NAIC1 accessible This information helps to determine Surplus Notes NAICT Surplus Notes NAIC2 NAICE the aard es fo er ee the RSAT Index List non agency RUBS CMBS securities owned by industry Memo U S insurers More NA I C Insurance Commissioners Page 32 2015 AVS User s Guide Last Updated April 4 2015 d Pre Upload Update or Replacement Create Portfolio Reduest The two types of files you can upload to your portfolio are update or replacement Update File An update file will add change or delete securities from the portfolio Replacement File A replacement file will delete the current portfolio and replace it with the securities submitted in the new file To establish or maintain your portfolio you will need the following information mm Sample file for portfolio code 12345A 12345A 2 002920AB2 Dept 999 12345A 2 010397DX2 Test 12345A 2 701094104 12345A 1 783760HQ7 Delete 12345A 1 78462M306 Delete 12345A 3 796236FN2 Changed Sample file for portfolio code 00011A 00011A 2 002920AB2 Dept 999
46. ch category of these securities is listed You may use this information for schedule D valuation purposes listing only the universal number provided below for the entire category in your AVS Portfolio Although you use the valuation information based on the universal numbers provided below you must still list these securities individually with their correct CUSIP numbers when filing your Schedule D Mortgage pools issued and guaranteed by the following agencies have the following universal PPN numbers for their categories Type of Security Universal PPN Number Government National Mortgage Association 36200 AA GNMA Federal Housing Administration FHA 31342 AA Federal Home Loan Mortgage Corporation 31340 AA FHLMC Federal National Mortgage Association 31358 AA FNMA b CUSIP Number Private Placement Number and CINS CUSIP The CUSIP number is used to identify securities Every publicly traded security in the Valuation of Securities Database has a unique CUSIP number CUSIP numbers are 9 characters long The first 8 characters of the CUSIP number uniquely identify a security The first 6 characters Issuer Number represent the Issuer of a security the next two characters Issue Number represent the individual issue and the last character is a check digit For example 008000AA7 is the full 9 character number 008000 the issuer e g ACF Co AA the issue e g Senior note 7 Check digit Private Placement Number PPN
47. come Test Account Automated Valuation Service A product of Pree SE POSE PSC IERE RI EER R RR IR RR IR RR R RR IR RR IERE RR IR RR R RR IR RR R RR IR RR R RR IR RR E EF Home Searches Portfolios My Account New Window Help Log Off Bulletin Board Lates Portfolio Upload amp Valuation Requests View All Posts f ae To Si Period End Update Date To view the Alert Notification Atinteresied Partes 2 Alert Notification Settings Report you can select the Go Interested Parties Mi Alert otifi ation Report owas sees To Report hyperlink or AN AVS Subscribers November Month End Dec 18 2012 a R select the Alert Notification AVS Search AVS Portfolio Structured Se Report option from the VOS and FE Quick Search Portfoto Upto ad amp Valuation Requests Coming Soon P o rtf ol j o menu CUSIP ae ei ray Fee Structured securities results will be incorporated Alert Notification Settings into AVS in early Fall 2013 Until then the aeng structured securities Web based application can VOS and FE Advanced Search Alert Notification Report aici be accessed at https isis naic org Ex Dividend Foreign Exchange Rates hd Mutual Funds The structured securities application makes the pa ea ao modeled data for residential mortgage backed Counterparty Designations ities RMBS and rd Letter of Credt Banks secures F Jand ommen jes gage backed securities CMBS more easily Group Code 99 ee 3 Schedule BA acc
48. d April 4 2015 NOTE The administrative symbols FMR and FMC are related to symbols that insurers are reduired to use in the financial statement reporting process Under applicable financial statement reporting rules an insurer uses the symbol FM as a suffix to identify modeled RMBS and CMBS CUSIPs AM as a suffix to identify CUSIPs not modeled and not designated by the SVO but for which NAIC CRP ratings were used to derive the NAIC Designation The symbols FM and AM are inserted by the insurer in the financial statement as a suffix in front of the NAIC Designation category i e 2FM h SVO Group Codes Bond Groups 02 U S Government Bonds 05 Canadian Government Bonds Domestic 06 Canadian Government Bonds Foreign 08 Foreign Government Bonds 15 Municipal Bonds in Default 20 U S Government Agency Bonds Domestic 22 U S Government Agency Bonds Foreign 25 Bonds of Puerto Rico and U S Virgin Islands 26 Government Sponsored Entities GSE Non Exempt Bonds 30 U S General Obligation Bonds 35 U S Revenue Bonds 37 Appropriation Backed Municipal Bonds 40 Canadian General Oblig and Rev Bonds Domestic 42 Canadian General Oblig and Rev Bonds Foreign 50 Public Utility Bonds 52 Foreign Public Utility Bonds 55 Industrial Bonds 56 Schedule BA Assets 57 Foreign Industrial Bonds 95 Replication Synthetic Asset Transactions Equity Groups 65 Public Utility Stocks 67 Foreign Public Uti
49. d for the SCA investment was reviewed by the SVO and was deemed to be reasonable calculated in accordance with an appropriate valuation method under Part Five Section 2 c of the Purposes and Procedures Manual of the NAIC Securities Valuation Office and calculated accurately by the insurance company K when used to report an SCA investment means that the valuation reported for the SCA investment was not assigned or reviewed by the SVO but was derived by the insurance company itself pending a valuation analysis by the SVO or is an SCA investment described in Part Five Section 2 b iv B of the Purposes and Procedures Manual of the NAIC Securities Valuation Office that is not required to be reviewed by the SVO iii The following administrative symbols are used in the VOS Products to identify RMBS and CMBS that the NAIC vendor has confirmed will be subject to the financial modeling methodology described in Part Three Section 3 c of the SVO Purposes and Procedures Manual FMR indicates that the specific CUSIP identifies an RMBS that is subject to the financial modeling methodology FMC indicates that the specific CUSIP identifies a CMBS that is subject to the financial modeling methodology The use of these administrative symbols in the VOS Product means the insurer should not use the filing exempt process for the security so identified N A IG National Association of Insurance Commissioners Page 51 2015 AVS User s Guide Last Update
50. d will not reproduce or externally distribute copyrighted documents without permission N A Ji C National Association of Insurance Commissioners Page 4 2015 AVS User s Guide Last Updated April 4 2015 1 Introduction to the Automated Valuation Service The Securities Valuation Office SVO of the National Association of Insurance Commissioners NAIC maintains a database of insurer owned securities to which the SVO has assigned an NAIC designation and a price together called Association Values Association Values are produced by the SVO solely for use by NAIC members These members acting in their official capacity as state insurance officials use Association Values to determine whether to permit an insurer to reflect an investment on an amortized basis or to require that the insurer reflect the investment at market value The Automated Valuation Service AVS allows users to view the SVO rated securities referred to as VOS securities as well as a listing of securities that have been deemed exempt from filing with the SVO called Filing Exempt FE securities The information in the AVS database and therefore in the AVS system can be changed at any time A Word about Filing Exempt Securities Filing Exempt FE status is based on a ruling adopted by the NAIC which grants an exemption from filing with the SVO for bonds and preferred stock that have been assigned a current monitored rating by a nationally recognized statistical rati
51. e UNITED STATES Select the Print EES Amie a ii EE button to printthe Guar Issuer aes E Guarantor p TOERE window National Association of NA i C Insurance Commissioners Page 22 2015 AVS User s Guide Last Updated April 4 2015 h Adding CUSIP from Search Results Welcome Test Account Automated Valuation Service A produ Home Searches Portfolios My Account VOS FE Search Criteria VOS FE Search 276 results Current C Historical Cusips issuers CUSIP X11111 Advanced Criteria CUSIP a X11111AE1 X11111AF8 X11111AG6 X11111AH4 X11111AJ0 X11111C01 X11111CE9 X11111CF6 X11111C0G4 X11111CH2 X11111CJ8 X111110G3 X11111DP3 X11111DO1 X11111DR9 X11111DS7 X11111DTS X11111DU2 X11111DV0 X111110W8 NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer NAIC Test Issuer Issue Description NAIC Test Description AE NAIC Test Description AF NAIC Test Description AG NAIC Test Description AH NAIC Test Description AJ NAIC Test Description CD NAIC Test Description CE NAIC Test Description CF NAIC Test Description CG NAIC Test Description CH NAIC Test Description CJ NAIC Test Description DG NAIC
52. e onto their PCs AVS is a subscription service Users must have a valid ID and password to use the system To obtain an AVS User ID and password please contact the AVS Administrator at 816 783 8300 N A IG National Association of Insurance Commissioners Page 6 2015 AVS User s Guide Last Updated April 4 2015 c Reporting AVS is shut down for Period End Processing on the last day of each month AVS users should enter valuation request on the last business day of the month A new feature to AVS will allow users to access historical records during period end processing The length of time needed for processing varies AVS will be unavailable for 24 hours during month end processing 2 3 days for quarter end processing and 3 4 days for year end processing Generally year end processing is not completed until the 4 or 5 of January depending on what day of the week New Year s Day falls on Period end times are posted in advance on the AVS Bulletin Board Prices are updated in the AVS system on the evening of the last business day of the month d Third Party Administrator Service A Third Party Administrator TPA is defined as an individual or group of individuals that are in the business of advising managing or procuring SVO Securities Valuation Office data for insurance companies investment portfolios A TPA is allowed to create and maintain portfolios in the name of one or more insurance companies All clients of TP
53. e Agreement begins February 1 2013 for an initial term of one year Thereafter the effective date of this agreement shall be from February 1 of the current year through January 31 of the following year RECITALS The NAIC maintains a database of reported investments of insurers with Association Values The Licensee has s j represented to the NAIC that it wishes access to the AVS and that its needs are consistent with Association v Cancel liza apo ee e EG ET EI EE ete Aa TE E z National Association of NA i C Insurance Commissioners Page 13 2015 AVS User s Guide Last Updated April 4 2015 e Exhibit A AvS Automated Valuation Service A product Exhibit A Welcome Test Account von a License Agreement for Insurer Exhibit A Subscription Name Subscription Period Billing Contact NAIC Test Company System Users Click Agreement Authority User ID First Name Last Name Test Account z Yes testacct 3 My Account Feb 01 2012 Jan 31 2013 Account Test testacct Account Code M Ihave read Exhibt A r ieseieeesecteeeseneteeesenesennsaeesccccecscceeiecossuttanniasasannenssanecennsanerenniaessenssennsanereensousisaninessnneiennsaneieeninstengions View My Subscription Information Subscription Price Accounts Type General and Separate To view print your AVS License Agreement and System Users Home Searches Portfolios My Account Bulletin Board Latest Posts View My To Subject
54. e To Terms Subscriptions to Authorize For existing customers the 2013 Subscription has been bypassed therefore Steps A and B will not apply After successfully logging on the Subscriptions to Authorize License Agreement window will display To continue you must select the License Agreement Agree to Terms button Welcome Test Account f aan SRSA BASEER GARS RAARAR ADDR An Re ERA GR nana RAGE SADR enna eb GE sn GE KERSE ER Rae AvS leek cnn Automated Valuation Service Al button to continue or the Postpone Click Agreement Subscriptions to Authorize 00000A NAIC Test Company button License Agreement EEN do dd MAIC Test Company VN ad Subseription Period N EES If you select the Agree to Type Insurer Terms button the Attestation Account Code 00000A window will display If you select the Postpone Click Agreement button the Postpone Click Agreement window displays b Postpone Agreement Postpone Click Agreement If you select the Postpone Click Agreement button the Postpone Click Agreement window displays Welcome Test Account EE EEN EE Subscriptions to Authorize Select the Cancel button to 0008 HAI sone Gick Agreement return to the Subscriptions EE Maree You have no ready subscriptions Until you agree to terms f to Authorize window ame access to those Subscriptions will be unavailable Subscription Pe If you select the Postpone Click Agreement button
55. earch Search or conduct Advanced Criteria searchs of PPNs CINS and CUSIPS AVS Portfolio Used to upload your portfolio into the system and manage Alert Notifications NA I C Insurance Commissioners Page 16 2015 AVS User s Guide Last Updated April 4 2015 ee EE EE EO EE EE a a eee 5 Searches The Searches menu offers a variety of ways to search for portfolio related information about specific CUSIPs CINS PPN or Issuers a 7 Welcome Test Account Home Searches Portfolios My Account Bulletin E Inquiry Service To Filing Exempt i Select the preferred All interes VOS and FE Advanced Search interested Ex Dividend e Factor for 12 31 12 Dec 18 2012 sea rch method from Foreign Exc e Rates ALAVS S ign Exchang Dec 18 2012 the Searches menu Mutual Funds Counterparty Designations ape S AVS AVS Portfolio Structured Securi Letter of Credit Banks d Sec u rities meen Group Code 99 a MOET BERE Coming Soon CU Schedule BA FA Period End Uodate i Structured securities results will be incorporated i Feriod tnad Update d a DEE EET EE EE EE EE TE EE EE EE EE OE EE EE OD EE ET EP EI VOS Surplus Notes NAIC1 Alert Notification Settines into AVS in early Fall 2013 Until then the Ex Div Surplus Notes NAIC2 NAIC6 Alert Notification Report Structured securities Web based application can Forel RSAT Index List be accessed at https isis naic org Froreig ex Lis Matus Industry Memo The structu
56. en The Create Portfolio Request Window will display Choose File to Upload Look jn je Porttoho O gt d E gt o My Recent Documents Desktop My DEE Br My Computer 7 My Network File name 00000A portfotio txt Places Files of type An Files es 7 Cancel ZA b Post Upload Ad Hoc Valuation Files Once the file uploads successfully the file information displays in the Ad hoc Valuation Files section of the window N tf Welcome Test Account Home Searches Portfolios My Account New Window Help Log Off Portfolio Upload amp Valuation Requests Period End Management Portfolio Name 00000A NAIC Test Company Download portfolio Create Portfolio Request Select the portfolio file to upload to the AVS System and or the valuation type to request and click Submit to continue Action to Take Update C Replacement Valuation Type au VOS Securities In Portfolio I VOS Securities That Have Been Reviewed This Year EEN gee Reg ee Filing Exempt Securities In Portfolio f ma ad Post upload of the file the Action To Take options selected will display in the Portfolio File To download a fie simply cick on the desired ink Ad hoc Valuation Files o aii TR ER ae ETER Re column of the Ad hoc Valuation Dec 26 2012 03 12 PM CST Account Test Update Not Requested 4 Files section EE If you also want to request a Completed Period End Fie i TREERE a
57. ent Blank When reporting a security on its annual or quarterly financial statements the administrative symbol FE is used with an NAIC 1 6 Designation and in addition in the case of preferred stock in combination with the P and RP Valuation Indicators FE signifies that the reported security meets the criteria set forth in Part Two Section 4 e of the Purposes and Procedures Manual of the NAIC Securities Valuation Office and that the NAIC Designation was arrived at by the insurer by converting the NAIC ARO rating s into a corresponding NAIC Designation in accordance with the conversion instructions set forth in Part Two Section 4 e i A and B and the rating equivalency identified in Part One Section Z D iii to the Purposes and Procedures Manual of the NAIC Securities Valuation Office or by the NAIC in comparing the security with the NAIC ARO rating feeds NR means Not Rated The symbol is used in the VOS publication for bonds and communicates that the information required to arrive at an NAIC Designation is not available to the SVO or that such information was received too late to be processed and reflected in the most current VOS publication Bonds assigned an NR symbol will be deleted from the VOS Database if any information deficiency is not rectified by the end of the first quarter following the previous year end Z means that the NAIC Designation reported by the insurance company was not derived by or obtained from the SVO but has been d
58. essible This information helps to determine the risk based capital RBC requirements for the Surplus Notes NAIC1 Pe non agency RMBS CMBS securities owned by Surplus Notes NAIC2 NAICS RSAT Index List U S insurers industry Memo More Specify the From and To LZ Welcome TestAccount Date Range for the Alert Notification report and select the Generate button Automated Valuation Service A product of Home Searches Portfolios My Account New Window Help Log Off If there are no notification Alert Report Criteria records to report a message Date Range From 11 27 2012 To 12262012 will display Alert Report Ho VOS or FE results found from 11 27 2012 to 12 26 2012 Portfolo Code CUSP Classification Event Prior Designation Prior VOS FE Status Current Designation Current VOS FE Status Date of Change If there are notification records to report the report will display W Forat ey ORR maemo ene Bed Resulissn vere To export the generated format select the Format and the Export Generated Results button and save toa common location National Association of NA i C Insurance Commissioners Page 45 2015 AVS User s Guide Last Updated April 4 2015 9 Description of VOS Data a FNMA GNMA FHLMC and FHA The following securities are not listed individually in the AVS system or on the Valuations of Securities CD ROM instead one entry for ea
59. ete AVS Portfolio Portfolio amp Valuation ts Multiple Portfoko Upload Period End Update Purposes and Procedures Manual Notification i Alert Notification Report R EE EE Ee EE AVS Portfolio New Window Date woe Apr 02 2076 Mar 31 2015 nr Mar 29 2015 Mar 16 2015 The application makes the modeled data for residential mortgage backed securities RMBS and commercial mortgage backed securities CMBS more easily accessible as it helps to determine the risk based capital RBC requirements for the non agency RMBS CMBS securities owned by U S insurers e Review RMBS CMBS modeled data for CUSIPs held as reported by the end of the second quarter e Get CUSIP prices based on expected losses for each NAIC designation e Purchase modeled data year round for additional securities acquired e Download modeled data for companies in a group into one convenient CSV file Check out the Structured Securities homepage to find more information as to whatis available Here is a brief overview of the window Each function will be described in detail in the following pages AVS Tool Bar Provides easy access to a variety of functionality SERRE ER EER IE RE ER EIE ERK RR RRR E EERSTE RRR Bulletin Board Posts Bulletin Board Posts Displays important dates and other information for AVS users To view all posts select the View All Posts button AVS Search Offers a variety of options to Quick S
60. etermined analytically by a reporting insurance company A security designated with a Z must be submitted to the SVO for valuation within 120 days of the date the security was acquired The Z symbol should not be used for securities that are exempt from filing with the SVO pursuant to Part Two Section 4 e of the Purposes and Procedures Manual of the NAIC Securities Valuation Office NR indicates that the security so designated belongs to a class of securities currently under policy review by the NAIC Z follows an NAIC Designation and means that the class of securities cannot be rated by the SVO because the valuation procedure is under regulatory review b The SVO SCA Companies Group uses the following administrative symbols to denote the status of the filing or to comment on the value claimed by the reporting insurance company The symbols and their meaning are published here solely to facilitate understanding by NAIC members i When entered in the status field of the VOS Database screen NV signifies Not Valued and means that the SVO SCA Companies Group has received and processed a SUB 1 form filing for the SCA investment shown See Part Eight for a discussion of the significance of this administrative symbol AP indicates that the value claimed by the reporting insurance company for the SCA investment in its SUB 2 filing was approved by the SVO SCA Companies Group and entered into the status field of the VOS Database screen N A IG
61. for current or historical Surplus Notes information e Surplus Notes NAIC2 NAIC6 Search for current or historical Surplus Notes by CUSIP or Issuer Name N A Ji C National Association of Insurance Commissioners Page 17 2015 AVS User s Guide Last Updated April 4 2015 e RSAT Index List Search for current or historical RSAT Index List information e Industry Memo Search for current or historical Industry Experience Factory Memo information a Searches VOS and FE VOS FE Quick Search A Quick Search for the Valuation of Security Filing Exempt information can be executed by CUSIP or ISSUER information Current or Historical information searches can be specified Current CUSIP Quick Search re Welcome TestAccount F Under the VOS FE i 7 do n Search results will Search Criteria label hiomat vatstion serico aam da display under the select the Current ni ics isc New Window Help Logon VOS FE Search label Quick Search Option vosresearencrtens TOE A record count of the and the CUSIP tab i current Historica cP oe ae ei results will also i X11111AE1 NAIC Test issuer NAIC Test Description AE Add f g i cae X11111AFS NAIC Test issuer NAIC Test Description AF Add d l S p ay Enter the CUSIP i X11111AG6 NAIC Test issuer NAIC Test Description AG Add D CUSIP X11111 Q pere number a Select any blue j Advanced Criera X11111AJ0 NAIC Test issuer
62. he price given for a share of common or preferred stock is the price listed on any market or exchange including a foreign exchange other than the New York Stock Exchange the American Stock Exchange or the NASDAQ National Market System NOTE The Administrative Symbols A L U and V which identity the manner or source of a Unit Price assigned by the SVO are collectively referred to as Market Indicators in the NAIC Annual Statement Instructions UP means unable to price This symbol is used with common or preferred stock and indicates that a current market quotation was not obtainable or was not deemed reliable by the SVO N A Ji C National Association of Insurance Commissioners Page 49 2015 AVS User s Guide Last Updated April 4 2015 F means that the NAIC Designation Unit Price or both shown was determined by the reporting insurance company and not by the SVO Unlike the administrative symbol Z the F symbol is used by insurers that meet the definitional criteria for a Sub paragraph D Company as defined by Part Three Section 1 a ii D 4 of the Purposes and Procedures Manual of the NAIC Securities Valuation Office to report ownership of a foreign security for which the company did not have the information necessary to permit the SVO to conduct an assessment or a valuation FE means exempt from filing with the SVO and is used by an insurance company to report an NAIC Designation for an exempt security on the NAIC Financial Statem
63. ion Report is created automatically each time a file has been uploaded P avs0000000A bupd 1 listing Notepad File Edit Format Yiew Help SECURITIES VALUATION OFFICE PORTFOLIO UPDATE TRANSACTION REPORT 12 26 2012 00000A 2 A1111AH 00000A 2 X1111143J 00000A 2 X11111cF 00000A 2 X11111cY 00000A 2 X111110L 00000A 2 X11111DN 00000A 2 X111110Q 00000A 2 X111110Y 00000A 2 X11111E8 00000A 2 X11111EF 00000A 2 X11111EL 000004 2 X11111EP 00000A 2 X11111EQ 00000A 2 x11111FM 00000A 2 X11111FN 00000A 2 X11111FP 00000A 2 X11111FT 00000A 2 X11111FY 000004 2 111116 00000A 2 X11111GK 00000A 2 X11111GN 00000A 2 X11111GP 00000A 2 X111116Q 00000A 2 A1111GK 00000A 2 X11111HA 000004 2 X11111HK 00000A 2 X11111HP 00000A 2 X11111H5S 00000A 2 X11111HZ 00000A 2 X111117IB 00000A 2 A1111IC 00000A 2 X1111170 00000A 2 A11117IG 00000A 2 x1111135 000004 2 x111113uU 00000A 2 x111113x 00000A 2 X11111KC 00000A 2 X11111KL 00000A 2 X11111KM 00000A 2 X11111KN 00000A 2 ALEC NAIC STATUS SECURITY NOT LISTED wJ This is a sample Transaction Report Although most of the securities successfully added three had errors SECURITY ALREADY EXIS1 INVALID CUSIP PPN ADDED a The text will usually tell you what the problem was but the chart below provides additional details SECURITY NOT LISTED wJ SECURITY NOT LISTED wJ SECURITY NOT LISTED WI MESSAGE ADDED DELETED CHANGED ERROR SECURITY NOT IN PORTFOLIO UNABLE TO
64. lity Stocks 70 Industrial Stocks 72 Foreign Industrial Stocks 75 Bank Stocks 77 Foreign Bank Stocks 80 Insurance Stocks 82 Foreign Insurance Stocks erg jeer Page 52 2015 AVS User s Guide Last Updated April 4 2015 i SVO Group Code Extensions Extension Extension Extension Description 10 Issuer Obligations 20 Single Class Mortgage Backed Asset Backed Securities 30 Defined Multi Class Residential Mortgage Backed Securities 40 Other Multi Class Residential Mortgage Backed Securities 50 Defined Multi Class Commercial Mortgage Backed Securities 60 Other Multi Class Commercial Mortgage Backed Asset Backed Securities 61 Aviation Equipment 62 Automobile Loans 63 Credit Card Receivables 64 Capital Equipment 65 Consumer Other 67 Other Multi Class CMBS 68 Future Flow Domestic 69 Future Flow Cross Border 70 Other 71 Franchise 72 Mutual FD Fee 73 Utility 74 BIDCO CAPCO 75 Credit Linked Notes 76 CTL 77 REIT 81 Coll Bond Obligations 82 Coll Loan Obligations 83 Coll Debt Obligations 84 CAT Bonds 85 Business LN Classification Classification Description B Bond C Common Stock P Preferred Stock Z blank LD Source Source Description V Valuation of Securities VOS F Filing Exempt FE blank Unknown j Review Date Indicates the last date an NAIC Designation was reviewed It is possible that a designation may have been reviewed but not changed N A IG National Association of Insurance C
65. me Searches Portfolios Help Log Off Enter a CUSIP Es under the Surplus Notes NAIC1 and or Issuer Surplus Notes NAIC2 NAIC6 Search Surplus Notes NAIC2 NAIC6 Search Results No results found AE S d N ame Criteria CUSP issuer Name Filing Year Statement Factor car year os Perio n E Results label Select the Search N button cust A record count of the results also displays To change the j Issuer tame Year or Period EE If there are no search select a different Clear results the No results value from the found message drop down menu displays Select Clear to re enter information Ee Ee ee r RSAT Index List Welcome Test Account Specify the Year SAM a N RSAT Index Search Criteria RSAT Index Search Results 25 results Select the Search aE Search results will Year 2011 7 Period O01 hd z 3 o button 2011 ABX HE A index display under the ABKHEAK nse Surplus Notes NAIC1 To change the En ees Search Results label ABX HE BBB Index Year or Period f FEE aa i select a different Banc of America CMBS A Index A record count of the value from the Banc of America CUBS AA Index results also displays drop down menu scemenacrtamoscaeeencnacaeaan EE Banc of America CMBS BBB index Banc of America CMBS Investment Grade 10 Year index
66. nd purchase hardcopy publications online at www naic org account_manager htm E mail prodserv naic org Phone 816 783 8300 Monday through Friday 8 30 a m to 5 p m Central International Orders Hardcopy international orders must be prepaid including shipping charges Because of additional cost incurred on international shipments please contact us for a rate quote N A IG National Association of Insurance Commissioners Page 9 2015 AVS User s Guide Last Updated April 4 2015 2 AVS Home Page amp Logging In To access the AVS home page open your browser and enter https avsplus naic org avsplus The AVS Home page displays AVS Home Page Window ad J A Automated Valuation Service A pro Inquiry Service Filing Exempt AVS A wealth of information is at your fingertips with a subscription to the Automated Valuation Service AVS is the fastest and most efficient way to obtain crucial information about the securities in your portfolio e Web based real time Automated Valuation Service now with a historical view e Database includes over 250 000 securities from over 40 000 issuers e Unlimited securities in your portfolio Unlimited searches and Unlimited yaluation files e Alert Service will send you a daily e mail notifying you of changes to securities in your portfolio or to any security in the database Check out the AVS homepage to find out how you can get access to AVS
67. ng organization FE also includes filing exemption for public common stock that is not restricted to transferability and is listed on the New York Stock Exchange American Stock Exchange or traded on the NASDAQ National Market System Filing Exempt securities can be found within the AVS database however they are not supported by the SVO and will not include the same level of information as that of the VOS securities For more information on FE Securities please consult the Security Valuation Office s information page at www naic org svo htm System and Support Hours The Automated Valuation Service is available at https avsplus naic org avsplus pages public home jsf Due to the nature of the Internet the system is available nearly 24 hours a day seven days a week However the official system hours are 8 a m to 5 p m CST The system is not available during periods of scheduled maintenance and updating such as the first business day of the month or any time system maintenance may be required Maintenance and update periods are posted on the AVS Bulletin Board to let you know when the database will be unavailable System support is provided by the NAIC Help Desk the AVS Administrator and other NAIC staff as necessary Support hours are Monday through Friday 8 00 a m to 5 00 p m CST excluding holidays and or other periods of time when the NAIC offices may be closed N A IG National Association of Insurance Commissioners Page 5 2015 A
68. ome Testaccount Search results will Select the Historical a La display under the Search button _ _ Tr meee VOS FE Search label A record count of the Specify the Year jy VOSIFE Search Criteria VOS FE Search 276 results results will also and Period and C Current Historical i CUSP a issuer Name issue Description Portfolio display Year 2011 X11111AE1 NAK Test Issuer NAIC Test Description AE Add enter the CUSIP EF XINT1AFS NAI Test issuer NAC Test Descripton AF ae os X11111AG6 NAIC Test Issuer NAIC Test Description AG Add Select any blue Issuer Number X11111 x IAH4 TF EFN Ad R Select the Search mae ve Re hyperlink to view Issuer Name X11111AJ0 NAIC Test Issuer NAIC Test Description AJ Add sey button X11111001 NAIC Test Issuer NAIC Test Description CO Add lt 4 additional Clear X11111CE9 NAIC Test Issuer NAIC Test Description CE Aad i i nfo rm atio n To clear the X11111CF6 NAK Test Issuer NAIC Test Description CF Add y X11111C0G4 NAIC Test Issuer NAIC Test Description CG Add A information entered XIIIIICH2 NAIC Test issuer NAIC Test Description CH aa Select the single select the Clear XININ1CN8 NA Test issuer NAIC Test Description CJ Asd arrow to view the hyperlink X11111063 NAK Test issuer NAIC Test Description DG Atd next page of search tese ee X111110P3 NAIC Test Issuer NAIC Test Description DP Add X11111D01 NAIC Test Issuer NAIC Test Description DQ Add results of the double X11111DRS
69. ommissioners Page 53 2015 AVS User s Guide Last Updated April 4 2015 k Price Review Date The Price Review Date reflects the last date that changes were made to the price field If the price field is blank the price review date is not updated The price review date reflects the most recent date that a valid price was assigned I SIC Codes SIC Codes are Standard Industrial Classification codes For a complete list please refer to the Purposes and Procedures Manual Part Two Section 12 or How to Comply Exhibits 5 and 6 N A I C National Association of Insurance Commissioners Page 54 2015 AVS User s Guide Last Updated April 4 2015
70. ould incur more stringent treatment under the NAIC Financial Conditions Framework NAIC 6 is assigned to obligations that are in or near default This means that payment of interest principal or both is not being made or will not be made in accordance with the contractual agreement An NAIC 6 obligation should incur the most severe treatment under the NAIC Financial Conditions Framework National Association of PETES insurance Commissioners Page 48 2015 AVS User s Guide Last Updated April 4 2015 f Valuation Indicators Pursuant to Part Three Section 1 b of the Purposes and Procedures Manual the SVO is required to classify preferred stock as either perpetual or redeemable Valuation Indicators show the classification decision of the SVO and are to be used by insurers to determine a SAP valuation method for preferred stock P means perpetual and is a valuation indicator used to classify a preferred stock as perpetual pursuant to Part Three Section 1 b of the Purposes and Procedures Manual The valuation indicator P means that the issuer of the preferred stock is not obligated to redeem the issue the holder of the preferred stock does not have a right to put the preferred stock to the issuer or there is no other equivalent right The P valuation indicator is assigned for the purposes outlined in SSAP No 32 RP means redeemable preferred and is a valuation indicator that classifies a preferred stock as a redeemable preferred stock
71. pursuant to Part Three Section 1 b of the Purposes and Procedures Manual of the NAIC Securities Valuation Office This means that the issuer of the preferred stock is obligated to redeem the issue the holder of the preferred stock has a right to put the preferred stock to the issuer or there is some other equivalent right The RP valuation indicator is assigned for the purposes outlined in SSAP No 32 g SVO Administrative Symbols SVO administrative symbols convey information about a security or an administrative procedure instead of an opinion of credit quality or Unit Price The administrative symbols in use by the SVO and their meanings are described below a All SVO analytical departments except the SVO SCA Companies Group use the following administrative symbols A means that the Unit Price of the share of common or preferred stock has been analytically determined by the SVO when used in context of an analytical department other than the SCA Companies Group V when used to report a Unit Price for common or preferred stock means the Unit Price reported was not provided by the SVO or any market or exchange but was derived by the insurance company itself or from some other source pending a valuation analysis by the SVO L indicates that the Unit Price given for a share of common or preferred stock is the price listed on the New York Stock Exchange the American Stock Exchange or on the NASDAQ National Market System U indicates that t
72. rch results no results will display m Letter of Credit Banks Welcome Test Account ees AV S N a Specify the Year waan a ea eT New Window Help Log Off and Period i Letter of Credit Banks Search Criteria Letter of Credit Banks Search Results 167 results Select the Search Year Period a1 vak ode di eT button Search COE ANZ Banking Group Ltd New York NY Austraka f Search results will me display under the To change the Allstate Bank Vernon Hi L usa Letter of Credit Banks Year or Period nce ese zm Search Results label A 7 American Business Bank Los Angeles CA USA select a different hesoested Bank WA Green Bay Wi USA record count of the value from the BNP Parbas New York NY France results will also drop down menu ated nik m display Banco Bibao Vizcaya Argentaria New York NY Spain Banco Santander Central Hispano New York NY Spain BancorpSouth Bank El Dorado AR USA Bank Leumi New York NY Israel Bank of Agriculture amp Commerce Stockton CA USA Bank of Albuquerque N A Albuquerque NM USA Bank of America NA Los Angeles CA USA Bank of Hawai Honolulu HI USA Bank of Kansas City N A Tulsa OK USA Bank of Montreal Chicago IL Canada Bank of Tokyo Miatsubishi UFJ Trust Company New York NY Japan 1 Welcome Test Account rj p ae Automated Valuation Service A pro Home Searches Portfolios My Account New Window Help Log Off Letter of Credit Banks
73. red securities application makes the modeled data for residential mortgage backed securities RMBS and commercial mortgage backed securities CMBS more easily accessible This information helps to determine the risk based capital RBC requirements for the non agency RMBS CMBS securities owned by U S insurers Counterparty vesignauons Letter of Credit Banks Group Code 99 Schedule BA Surplus Notes NAIC1 Surplus Notes NAIC2 NAIC6 RSAT index List industry Memo More To search for specifics about your portfolio you can search by the following categories e VOS and FE Quick Search Conduct a quick search by CUSIP e VOS and FE Advanced Search Search for current or historical information by CUSIP multiple CUSIPS or by Issuer Name e Ex Dividend Search for either current or historical Ex Dividend information by CUSIP or Issuer Name e Foreign Exchange Rates Search for current or historical Foreign Exchange rates by CUSIP or Issuer Name e Mutual Funds Search for current or historical Mutual Fund information by CUSIP or Issuer Name Complex Name or Fund Name e Counterparty Designations Search for current or historical Counterparty Designations e Letter of Credit Banks Search for current or historical Letter of Credit Banks e Group Code 99 Search for current or historical Group Code 99 information e Schedule BA Search for current or historical Schedule BA information e Surplus Notes NAIC1 Search
74. rmation message displays Submit The Transaction Report will To download a file simply click on the desired iink id Ad hoc Valuation Files show the securities added to i Requested hitiated By Portfolio File Transaction Report Valuation File Completed your portfolio and any errors Vee 28 OE ASM se Toat t that occurred A Transaction CST Requested TE EIN rs Report generates each time a opu file uploads Dec 26 2012 0326 PM a ount Test Not EE CST Requested Dee28 2012 OS2BPM ount Test Not PT EE EE N DE NEE EE EE REEN i Refer to the Appendix for an CST Requested 6 example of a Transaction Dec 26 2012 03 26PM Not cst TSS Requested Report Dec 26 2012 03 12 PN Account Test Update Download Not Requested Dec 26 2012 03 15PM ee n CST The following is the list of Valuation Request Types CST All VOS Securities In Portfolio The valuation includes all VOS securities within the portfolio VOS Securities That Have Been Reviewed This Year The valuation includes all VOS securities reviewed this year within the portfolio VOS Securities That Have NOT Been Reviewed This Year The valuation includes all VOS securities NOT reviewed this year within the portfolio Filing Exempt Securities in Portfolio The valuation includes all Filing Exempt securities within the portfolio All Securities In Portfolio The valuation includes all VOS and Filing Exempt securities within the po
75. rrent Isser si eae mn et ae er ne gs ee e ee meer eee 20 e VOS FE Historical Issuer Searle gese es eo ER EE se EE Ee Des Ge onesie EE ae He EE ep Ge De Ee de Ee SE AR 21 f CUSIP Detail amp Adding Security to Portfoli0 sees see Re ee RE EE ee ee ee Ee ee ee Re ee ee ee ee RE ee ee ee 21 g Added Removed to from Portfolio see ee ee ee ER ee ee ee ee ee ER EE Ee ee ee ee ee ee ee ee 22 he Adding CUSIP from Search tN FS ae Ee DE Ie DE RE EE Oe GR oe RE EE ee Oe 23 kL BeDividend is ige ELE N EE N AO EE 24 jk iS ek DRS ee ae Oe Ee N EE EE AE EE EE N EE 24 e ee EP es ic gc 9 EE N ER EE ORE RO EE EE eee 25 l Counterparty Designation Search iese see RR EE RR ee ee ee AR ee ee ee ee Re ee ee RE ee see ee ee AR ee ee EE 25 jn Letter of Credit Ban eek AE ee Ee EO ae ee ee aa ER ee RE n ED ee ee Ee 26 surance gesel Page 2 2015 AVS User s Guide Last Updated April 4 2015 EN GC OE I OR ONE ET RE EER EE N N RE N EE 27 o se OE EE HO EE EE EE EE EE OE EET EE 28 p Surplus Notes NA IE UF See Er Ge Go DE Ga Ge EG Ee GE Ge OE AG Gee eo dem 29 q Surplus Notes NAIC2 NAICG ccssssssssccssscssssssssccssccsssssessssccssccessesescccssccsssesesssccssscesssesssccssessscessecessssssessss 30 e PR ees ok EE OE EN RE AE EE ER EE EE EE 30 s Industry Experience Factor MEMO sesse ees ses ee ee Ee ee EE ee ee ee ee ee ee ee ee ee Re ee ee ee Re ee ee RE RR Ee ee see RE ee ee 31 6 Portfolio Upload amp Valuation
76. rtfolio N A IG National Association of Insurance Commissioners Page 36 2015 AVS User s Guide Last Updated April 4 2015 d Valuation Request Complete Welcome Test Account Home Searches Portfolios My Account Help Log Off Portfolio Upload amp Valuation Requests Period End Management Portfolio Name 00000A NAIC Test Company Download portfolio Create Portfolio Request Select the portfolio file to upload to the AVS System and or the valuation type to request and click Submit to continue File to Upload EE or Action to Take Update Replacement Valuation Type ay yos Securities In Portfolio 7 YOS Securities That Have Been Reviewed This Year YOS Securities That Have NOT Been Reviewed This Year Filing Exempt Securities In Portfolio E All Securities in Portfolio REKE EER ER REKE ER IR ir REKE ER IR ER RI EE RI R ER RE IE REKE RI E E RI RR EIE ER EE RI RE EIE RE ER N To download a fie simply click on the desired ink Once complete a hyperlink iii i will display in the Valuation Requested Initiated By Porttolio File Transaction Report Valuation File Completed i Dec 26 2012 03 26 PM CST Account Test Not Requested Filing Exempt Securities in Portfolio Dec 26 2012 03 35 PM CST Column of the Ad hoc Dec 26 2012 0326 PM CST Account Test Not Requested All Securities in Portfolio Dec 26 2012 03 35 PM CST i Valuation Files section of the Dec 26 2012 03 26 PM CST Account Test No
77. s obtained This field will be blank for bonds Valid Market Indicators are A The unit price of the share of common or preferred stock has been analytically determined by the SVO U The price given for a share of common or preferred stock is the price listed on any market or exchange including a foreign exchange other than the New York Stock Exchange the American Stock Exchange or the NASDAQ National Market System L The Unit Price given for a share of common or preferred stock is the price listed on the New York Stock Exchange the American Stock Exchange or on the NASDAQ National Market System d Price This is the market value to be used for statutory accounting purposes It should be entered in the Investment or Amortized Value column of schedule D of the NAIC Annual Statement Form Where a price is not available for either a public or private security the price field will contain a dash For bonds this field contains the percentage of par of the issue recorded up to three decimal points For both common and preferred stocks the share price is recorded up to three decimal points Prices for publicly traded stocks and bonds are updated monthly Privately placed common and preferred stocks are priced annually Privately placed bonds are priced when requested Prices for municipal bonds are updated quarterly e NAIC Designations For Bonds the Designation 1 2 3 4 5 or 6 will be left justified first position NA
78. s or a Portiolo Upload amp Valsallon Requests EEN PERE an TPA you can narrow your Account Code Account Name search by populating the filter Please select a portfolio 99999A My Test Ins Co with the Account Code or ed 00000A World Ins Co A tN _ Account Name Portfolio Name Create Portfolio Request Search for a company by Select the portfolio fie to upload to the AVS System and or the valuation type to request and click Submit to continue i Fite to Upioed oester Ned Account Cocode or Account Action to Take Update G Replacement Name Valuation Type AN VOS Securities In Portfolio C VOS Securities That Have Been Reviewed This Year I VOS Securities That Have NOT Been Reviewed This Year Type the cocode or name in I Filin em curities In oli ae ns the choose file Click on the Bord company name deed as ER ee Gee EE EE EE EE GE N EG ee Ad hoc Valuation Files Requested initiated By Portfolio File Transaction Report Valuation File Completed No Ad hoc valuation files available Period End Valuation Files Completed Period End File No Period End valuation files available Please be aware that files will be retained for 90 days before being deleted 1 National Association of NA I C Insurance Commissioners Page 34 2015 AVS User s Guide Last Updated April 4 2015 Choose File to Upload The Choose File to upload window will display Select the file s to upload then select Op
79. sted Parties 2 MlertMotification Settings ti eevee Dec 18 2012 i Dec 18 2012 ABAVS Subscribers November Month End Dec 18 2012 The Receive Alerts Window will display AVS Search AVS Portfolio 7 0eCUu VOS and FE Quick Search Portfolio ma amp Valuation Requests Comin g S oon Multiple Port oad CUSIP An Structured securities results will be incorporated H VOS and FE Advanced Search Alert Notification Settings into AVS in earty Fall 2013 Until then the Ex Dividend Alert Notification Report structured securities Web based application can SEE EE Alert Hotificaton Repon Foreign Exchange Rates be accessed at https isis naic org Foreign Exchange Rates Mutual Funds Counterparty Designations The structured securities application makes the Letter of Credit Banks modeled data for residential mortgage backed Group Code 99 securities RMBS and commercial mortgage Schedule BA backed securities CMBS more easily Surplus Notes NAIC1 accessible This information helps to determine Surplus Notes NAIC1 Surplus Notes NAIC2 NAICS the risk based capital RBC requirements for the Surplus Notes NAIC2 NAICE r RSAT index List non agency RMBS CMBS securities owned by industry Memo U S insurers More National Association of NA I d Insurance Commissioners Page 43 2015 AVS User s Guide Last Updated April 4 2015 MELLE LTEEERELE LLE TEL re To Receive Alerts select the Receive Alerts checkbox Wis Weicome Test Account
80. t Requested All VOS Securities In Portfolio Dec 26 2012 03 35 PM CST i Window Dec 26 2012 03 26 PM CST Account Test Not Requested VOS Securities That Have NOT Been Reviewed This Year Dec 26 2012 03 3SPMCST og Dec 26 2012 0326PMCST Account Test Not Requested VOS Securities That Have Been Reviewed This Year Dec 26 2012 03 35 PM CST Dec 26 2012 0312PMCST Account Test Undsle Download Not Requested Dec 26 2012 03 15 PM CST _ Refer to the Appendix of this Document for information once about downloading a Completed Period End File i Valuation Report Ho Period End valuation files available Please be aware that files will be retained for 90 days before being deleted H ELELITETITEEITTEITETITEEITTTITETITETITETITTEITTTITTTITTTITTTITTTITTTITYTITTTITTTITTTITTTI Valuation Request Process Order The system will process valuation requests every fifteen minutes Monday Friday between the hours of 6 00 a m and 9 00 p m CST All valuation requests will process in the order they are received except for Period end requests Period end report requests are typically available to retrieve once AVS is available after Period End Processing 1 National Association of NA I C Insurance Commissioners Page 37 2015 AVS User s Guide Last Updated April 4 2015 e Transaction Report The Transaction Report will show which securities were and were not able to be added to your portfolio and if there were any errors A Transact
81. vanced Search for the Valuation of Security Filing Exempt information is executed by entering additional details about the CUSIP or Issuer Advanced VOS FE Search m Welcome Test Account F Cati Automated Valuation Service i Enter additional Home Searches Portfolios My Account New Window Help Logoff Specify Advanced VOSIFE Criteria details about the VOS FE Search Criteria an X11111 CUSIP or Issuer O Current Cc Historical loouer amber issue Description Portfolio i Issuer Name i iption AE Add i ae When complete ve NEEE Country Name _ select the Search 9 dl Eros es button A list of A e teria Designation self Designation Review pion Ad Add results will be lt ag rom ode pas returned orifthere Group Code Ext eZ are no results an sani error message Market Indicator a v pton CG Add 8 Maturity Date bin iption CH Add i Select the Cancel Price tion DG Add i medi als button toreturnto Price Review Date m iption OP Add i Rate PEP z the VOS FE Search ee pion OR ado criteria window Guar Issuer Code x i iption DS AGa A Guarantor 7 i i Clear Select the Clear hyperlink to remove pion DW Add data entered NAIC Insurance Commissioners Page 19 2015 AVS User s Guide Last Updated April 4 2015 c VOS FE CUSIP Historical Pree EER EE FEE TT elc

2015 User`s Manual - National Association of Insurance

Contents

Download Pdf Manuals

Related Search

Related Contents