Microsoft, Excel, Word, and/or other Microsoft products referenced herein are either trademarks or registered trademarks of Microsoft Corporation. No endorsement by Microsoft Corporation is implied.The XBRL Logo is a registered trademark or service mark of XBRL International, Inc. No endorsement by XBRL International, Inc. is implied.Solvency II Solutions, the Solvency II Solutions logo, Tabular, the Tabular logo, the Tabular interface and other marks are copyright © Solvency II Solutions, 2014.

Solvency II Solutions provides a comprehensive suite of software and

professional services designed to meet your unique Solvency II reporting

requirements, based on a foundation of unparalleled market and reporting

expertise and product excellence.

Register for full product details at www.solvencyiisolutions.com

Microsoft Excel -basedSolvency II reporting solution

Tabular t

1

Contents

Solvency II Solutions 2

Tabular 2

Agility 2

Comprehensive compliance toolkit 3

Market and regulatory expertise 3

Detailed product features 4

Return setup 4

Workflow 5

Data management 6

Data governance 7

Validation 8

Narrative report 9

In-screen tools 10

Submission 10

Conclusion 12

2

Solvency II SolutionsSolvencyIISolutions(SiiS)isaspecialistsoftwareproviderandconsultancycompanyprovidingaholisticsolutionforthedatacollection, validation and submission of Solvency II regulatory returns.

Our expert team has delivered regulatory return software to over 90% of the UK market. We have a wide rangingskillset,withexperienceworking for top-tier insurance ratings agencies, auditingfirms, insurers, the Lloyd’smarket and technology companies.

TabularTabular is a Excel add-in built on a back-end database with a comprehensive tool kit to assist in the Solvency II reporting process.

Ourrobust,user-friendlysoftwarealignswithawiderangeofend-to-endreportingprocessesanditsflexibilityallowsfirmstoadapttheiroperatingmodelsinanagileandefficientway.

Tabular is based on three core principles: agility, comprehensiveness and regulatory expertise.

Agility

x Excel-basedlowimpact/lighttouchSolvencyII reporting tool that is quick and easy to implement:

³ leveragesthebenefitsofExcel (powerfulfunctionality,userfamiliarityetc.)

³ managesthedataintegrityweaknessesbyproviding acomprehensivedatagovernance‘wrapper’

x Multi-language customer support and product

x Choice of implemention method — choose the modelthatbestfitsyourorganisationandITstructure:

³ locally hosted

³ cloudhosted—softwareasaservice(SaaS)

x Supportforcustomisableintegrationwithexistingsystemsandin-houseapplications

3

Comprehensive compliance toolkit

x Includes all European Insurance and Occupational Pensions Authority (EIOPA) specifications,nationalspecifictemplates,EuropeanCentralBank(ECB) andotherancillaryreportingrequirementssuchasthoseofLloyd’s

x Comprehensive assurance checks incorporating EIOPA business rules, eXtensibleBusinessReportingLanguage(XBRL)taxonomyvalidations and National Competent Authority (NCA) requirements

x Supplementalvalidationsandindicativewarningsbased on Solvency II Solutions market and regulatory expertise

x A robust audit log capability that tracks every change (values, formulas, comments, returnstructure)forafullytraceablerecord,withtheabilitytorollbacktoanypointintime

x Aworkflowmanagementcapabilitytoensurebestpracticeinproject management and completion of your Solvency II return, handled in an intuitive and controlled manner, based on our expertise of regulatory return completion

x Data quality

³ Customisable business rules to check data quality

³ Data quality toolbox to identify broken links, potential formula errors, use of particular Excel functions prone to causing issues, e.g. sumif

Market and regulatory expertise

x A team of industry experts based on over 30 years insurance and consultancy experience,deliveringapowerful,dynamicandsecuresolutionfor Solvency II reporting needs.

x Our product development team complements our insurance industryexpertisewithanunparalleledcombinationofmarketand industryknowledgeandproductdevelopmentexcellence.

x In-depth consultancy and product support for all of your Solvency II reporting needs

4

Detailed product features

Return setup

SettingupyourcompanyorreturnisstraightforwardinTabular.Manyfeaturesareincludedtoreducetheneedforuserstoinputcompany/returninformationsuchasimportfromtheSolvencyIreturn.Oncedetailshavebeeninputaone-clickfacilityisavailablewherenochangestothereturnstructurearerequired.

x Intuitive step-by-step process for simple return setup

³ One-click return setup available thereafter

x AutomatedfacilityusingSolvencyIsubmissionfilestoeasesetupandhistoricalreporting

x Validation rules to ensure no invalid return settings are selected

x Automatedorcustomisablemigrationoffinancialfigures and narrative reporting from prior returns

x Confirmationprocesshighlightsreturnstructurechanges

5

Workflow

Tabular includes full-suite process management tools to document and manage the end-to-end reporting process. In-builtregulatorycalendarallowsprojectmanagerstoassigntasksandmonitoragainstsettimeframes.Arduousdocumentationofdatalineage,datatransformationprocessesandcontrolsissimplifiedthroughanintegrateddataflow-chartcanvas.

x Full-suite process management tools:

³ Assign tasks, document task dependencies and escalation processes

³ Monitor status at any point time

³ Customisable MI reporting

³ Fulldrill-downcapabilitiestosub-processesandtaskdependencies

³ In-builtregulatorycalendarandautomatednotificationsbasedoncustomisablerules

x Adaptable to any end-to-end reporting process

x Dataflow-chartfacilitytodocumentdatalineagethroughthebusiness— annotatewithdocumentationondatatransformations,dependencies,controlsandtimelines

6

Data management

Solvency II requires a broader and more granular level of data to be submitted. To assist in the aggregation of data from multiple source systems, Tabular includes extensive data management tools to facilitate an easily repeatable process. Aflexibledataimportengineallowsimportfrommostdatabases,fileformatsandcommonaccountingandactuarialsystems.

x Intuitive, customisable data management tools to rationalise the parallel Solvency and FinancialConditionReport(SFCR),RegularSupervisoryReport(RSR),financialstability, EuropeanCentralBank(ECB)andinternalMIreportingworkstreams

x Migration facility for importing prior return data

x Straightforwardconsolidationprocess

x Flexible import engine facilitates import from most databases, fileformatsandcommonaccountingandactuarialsystems

x Fully customisable, repeatable import routines

x Exportreturnandancillarydataintocsv,XMLandXBRLformats

7

Data governance

SolvencyIIplacesasignificantemphasisondatamanagementwithininsurers.AcoretenetoftheDirectiveisthatdatausedthroughout an organisation should be “accurate, complete and appropriate.” Our audit log tracks every change made, from achangeinvalueorformulawithinaQRTtotheinclusionofacommentinthevalidationreport,todeliverasecureandtraceable record of the completion process.

x AllchangesstoredinTabulardatabase,independentofthereturnworkbook,toensuredatasecurity

x Annotatedauditlogreporttoprovideadditionalinformationforreviewers(e.g.internalorexternalaudit)

x Standard and customisable MI reporting tools

x Data quality

³ Customisable business rules to check data quality

³ Data quality toolbox to identify broken links, potential formula errors, use of particular Excel functions prone to causing issues e.g. sumif

x Integrated Excel comments and documentation manager to easily track data manipulations for data governance and process management purposes

x Customisabledataflowchartforthetrackinganddocumentationofdatalineagethroughouttheprocess

x Predefinedandcustomisablecross-cycletooltoenablequickandeasytrendanalysis

8

Validation

TabularincludesacomprehensiveandcustomisablevalidationenginetoensurecompliancewithallEIOPAandNCAdatachecksandXBRLtaxonomyvalidations.Intuitivedrilldownfunctionalityallowsfastrootcauseanalysisintovalidationexceptions.

x Comprehensive validation checks incorporating EIOPA and NCA data checks, XBRLtaxonomyrulesandsupplementalSolvencyIISolutionsvalidations andindicativewarnings

x Customvalidationbuildertoallowimplementationofuserspecificvalidations

x Ancillary validation tool for deconstructing validations into their component parts for root cause analysis

x Flexibledrill-downfacilitytoquicklynavigatetothevalidationQRTsourcedata

x Annotated validation report to provide additional information forreviewers(seniormanagement,audit)

³ Integrated report manager to facilitate migration of validation report annotationsforuseacrossreportingcycles(withadministratorsign-off)

x ValidationrulesintegratedthroughthesystemtorestrictQRTdata entrytovalidXBRLdomainmembersandotherdataspecifications

9

Narrative report

Toassistfirms in completing theSFCRandRSR, Tabular includes functionality toensure consistencyacross the reportingschedule.Directlylinkingthenarrativereporttothereportingworkbookthroughaneasy-to-useinterfaceeliminatestheneedformanualupdateswhenchangesaremadetothesourceQRTfigures.

x TabulareasilyenablesthedatafeedtotheQRTdisclosures:

³ ReferencesarecreatedthroughasimpleinterfacewithwhichaQRTdatapoint (or combination of data points through a native calculation builder) is selected.

³ Allreferenceswithinthereportareeasilyidentifiableandusers havetheoptiontotogglebetweenvaluesandreferences.

x Additionally,businessrulescanbesetsothatspecificwording willbeusedinthenarrativereportdependentontheQRTfigures, ensuring accuracy of commentary and ease of future returns maintenance.

10

In-screen tools

By leveraging the Excel task pane API, many of Tabular’s features are available to users alongside the standard Excelspreadsheetview.Moreover,severalfeatureshavebeenincludedwithintheright-clickcontextsensitivehelpmenuforevengreater ease of use.

x QRTsincludecomprehensiveprebuiltcalculationsforsub-totallingandcross-forminteractions

x XBRLtaxonomydomainsavailabledirectlyintheQRTinput(drop-downmenus) to ensure valid data content

x In-screenQRTvalidationwindowprovidingreal-timevalidationresults

x Drill-downfeaturetoparseExcelformulaeintotheircomponent QRTdatapointsandone-clickgo-tofunctionality

x AbilitytoinsertQRTandQRTdatapointcommentsfor formal and informal documentation purposes

³ Comments manager tool to minimise rekeying information across reporting cycles

x In-screen regulatory reference task pane presenting the relevant (fully searchable) Directive, delegated acts, implementing technical standards, guidelines and other ancillaryregulatorydocumentssuchasEIOPAandNCAQ&Amaterials

Submission

Tabular provides for all the expected submission formats demanded by NCAs — Excel, csv, XML and XBRL. Asubmissionwizardensuresallrequiredsign-offshavebeenreceivedandallrequiredconstituentfileshavebeencollatedandincluded.XBRLtaggingforXBRLsubmissionfilegenerationiscompletelyautomatedthroughTabular’sXBRLengine.

x Tabular’sin-builtXBRLenginerequiresnoadditionaluser inputtocreatetheXBRLinstancesubmissionfile

x Otherancillaryreportingdemands,e.g.Lloyd’ssyndicatereturns, are included as standard

x Electronicsignofffacility—SolvencyIIsubmissionfilescanonly be submitted once designated management has approved

x Straightforwardandsimplesubmissionwizard:

³ Ensures allocated users sign-off on validation and related reports beforeelectronicsign-offtoenablesubmissionfilecreation

³ In-builtchecklistofallrequiredsubmissionfiles—SFCR,RSR,QRTs, audit report (if required), plus any other ancillary reports

x Group-specificprocessenablingsingleconsolidatedSFCR/RSRifinsurersoelects

x Easy-to-useprintingcapabilitiestoallowcustomisation,brandingand styling of the Solvency II return for both private and public returns

11

12

Conclusion SolvencyIISolutionsprovidesacomprehensivesuiteofsoftwareandprofessionalservicesdesignedtomeetyouruniqueSolvency II reporting requirements, based on a foundation of unparalleled market and reporting expertise and providing product excellence.

Oursolutionisflexibleandscaleable—wewillworkwithyoutoseamlesslyintegrateintoyoursystemsforeaseofcollationof data, consolidation and data checks to make your return easy to complete, accurate and on time!

Tabular’s unique design (technology implemented through an Excel add-in and a powerful back-end database) andcomprehensiveproductofferinghasmanyattractivefeaturesforinsurers’reportingprojects:

x LowITfootprint—upandrunningwithinminutes

x Fitseasilywithinsurersexistingworkingprocesses

x Allowsinsurersmaximumflexibilityindesigningtheir Solvency II end-to-end reporting processes

x Adjustmentscanbemadequicklyyetinacontrolledenvironment usingTabular’sin-builtdatagovernancetools

x Assistsfirmsinkeepingtrackofdataflowsthroughacomprehensive and user-friendly process management module

x Fullauditlogwithroll-backtoanypointintime

x Facilitytorunpredefinedandcustomisablecrosscycletrendanalysis

x Collaborativetoolstoallowmultipleuserstocontribute tothesamereportingfileinparallel

x XBRLsubmissionfilegenerationiscompletelyautomated throughTabular’sXBRLengine

x All EIOPA data checks, taxonomy validations included at point of dataentry/importwithextensiveancillarydataaccuracytools to aid root cause analysis

Microsoft, Excel, Word, and/or other Microsoft products referenced herein are either trademarks or registered trademarks of Microsoft Corporation. No endorsement by Microsoft Corporation is implied.The XBRL Logo is a registered trademark or service mark of XBRL International, Inc. No endorsement by XBRL International, Inc. is implied.Solvency II Solutions, the Solvency II Solutions logo, Tabular, the Tabular logo, the Tabular interface and other marks are copyright © Solvency II Solutions, 2014.

Solvency II Solutions provides a comprehensive suite of software and

professional services designed to meet your unique Solvency II reporting

requirements, based on a foundation of unparalleled market and reporting

expertise and product excellence.

Register for full product details at www.solvencyiisolutions.com

Microsoft Excel -basedSolvency II reporting solution

Tabular t