Look up Insurer Financial Ratings of list

To look (on the internet) the financial rating of specific type “Insurer Financial Strength” or “IFS”, of the financial entities described on column A. If the rating “Insurer financial strength” is not available, then indicate so and include the debt rating or other rating available (and indicate when this case so). The rating date must also be indicated. This is highlighted on the spreadsheet titles in yellow The ratings are usually available on the website of each company. The hyperlink to the website containing the financial rating must we inserted in the cell of the name. There are 12 examples on the sheet. Another source of Insurer Financial Strength ratings can be obtained from the following rating agencies- you can look up ratings here as well (some require you sign in to lookup). • [login to view URL] • [login to view URL] • [login to view URL] • [login to view URL] Rating from other agencies different from the above 4 are not relevant here. There are 223 records (entities). Disregard column K – is for my internal use. If an agency does not rate the entity include “Not Rated” (NR) in the spreadsheet- see examples. The web page source of the information containing the financial rating must be included as a hyperlink to the cell. If there is more than one hyperlink, include it on the cell corresponding to the applicable rating (example cell E16). Be sure that the entity is domiciled on the country specificied on column B The deliverable is this same spreadsheet with the filled information of applicable rating for all entities. Please be sure to understand all of this as we want to make sure it is correctly done.