SOA Exams & Modules
[mathjax] Review Basic Concepts – Integrals: \(\int_{0}^{\infty }{{{t}^{n}}{{e}^{-ct}}dt}=\dfrac{n!}{{{c}^{n+1}}}\) \(\int_{0}^{u}{{{t}^{n}}{{e}^{-ct}}dt}=\dfrac{1-(1+cu){{e}^{-cu}}}{{{c}^{2}}}\) \({{(\bar{I}\bar{a})}_{u}}=\dfrac{{{{\bar{a}}}_{\overline{u}}}-u{{v}^{u}}}{\delta }\) – Geometric Series: \(\sum\nolimits_{k=0}^{n-1}{a{{r}^{k}}}=a\dfrac{1-{{r}^{n}}}{1-r}\) \({{i}^{(m)}}=m({{(1+i)}^{{}^{1}/{}_{m}}}-1)\) \({{d}^{(m)}}=m(1-{{(1+i)}^{-{}^{1}/{}_{m}}})\) – Survival Function: \({{S}_{x}}(0)=1\) \(\underset{t\to \infty }{\mathop{\lim }}\,{{S}_{x}}(t)=0\) \({{S}_{x}}(t)\) must be a non-increasing function of t Review from MFE – Rate of Discount: \(d=\dfrac{i}{1+i}\) – Discounting Rate: \(v=\dfrac{1}{1+i}=1-d\) – Continuously Compounded Interest Rate: \(\delta =\ln (1+i)\) – Simple Interest Rate i: \({i}_{t}=1+it\) , \({{v}_{t}}=\dfrac{1}{1+it}\) – PV of …
Accounting Principles
OPBT Rollforward Analysis Summary Fee Based Income Insurance Operating Income Beginning – Last Year One-off – Claims Experience Actual claim profits – Expected claim profits, from basic and UDR products Actual claim profits – Expected claim profits, from PPR products Expense Experience Actual expense profits – Expected expense profits Lapse and Persistency Experience Anything else that are difficult to …
Issued: Dec 1987 Superseded by: ASC Summary Scope: For universal life-type contracts that were not addressed by FASB Statement No. 60, Accounting and Reporting by Insurance Enterprises. For limited-payment long-duration insurance contracts and investment contracts and amends Statement 60 to change the reporting of realized gains and losses on investments. Applicability: {US-FAS97-6} Investment contracts, Long-duration contracts that do not …
Classification of Insurance Contracts
Insurance contracts are classified as short-duration or long-duration contracts.
Long-duration contracts: insurance contracts that are expected to remain in force for an extended period include contracts, such as:
whole-life,
guaranteed renewable term life,
endowment, annuity, and
title insurance contracts.
Otherwise, short-duration contracts.
most property and liability insurance contracts.
Defined Terms cedant The policyholder under a reinsurance contract. deposit component A contractual component that is not accounted for as a derivative under IAS 39 and would be within the scope of IAS 39 if it were a separate instrument. direct insurance contract An insurance contract that is not a reinsurance contract. discretionary participation feature A contractual right to receive, …
Product Classification Definition of Insurance Contract An insurance contract is a contract under which the insurer accepts significant insurance risk from the policyholder by agreeing to compensate the policyholder if a specified uncertain future event (the insured event) adversely affects the policyholder. Definition of Insurance Risk Insurance risk is risk, other than financial risk, transferred from the policyholder to the …
Please note that the information contained in this post is based on my own research and understanding of the topic. While I have made every effort to ensure its accuracy, I cannot guarantee that it is completely error-free. If you notice any errors or omissions, please let me know so that I can correct them. Applicability FAS 60 …
Coding & Programming
File Management CopyFolder Function: CopyFolder (Source As String, Target As String) As Integer Copies contents of a source folder including subdirectories to the target folder. If target folder exists then it will be deleted before copy operation is performed. Returns True(-1) if successful or False(0) if failed. Example: DeleteFolder Function: DeleteFolder (FolderName As String) As Integer Deletes a directory with …
Types of Tables Tables are used at many levels in AXIS for many different: uses, structures, and shapes Table Hierarchy Characteristics Cell Tables Used only by cells, or by sub-objects linked to cells Support policy level calculations at the cell level Projection Tables Used by higher level objects, such as sub-funds, funds and offices Column-specific shape Rows are financial years …
Background There are times you are interested in summing up the results across various dimensions with specified conditions or indicators to exclude some results from the ARRAY_SUM function. There is an incident that I need to separate medical health UCOI cash flows from total medical UCOI cash flows, because there are different loss ratios for these two types of UCOI …
What is calculation looping? Calculation looping is a process whereby parts of the calculation are repeated several times. In many ways it is similar to the rebasing facility. However, calculation looping differs from rebasing in the following ways: With calculation looping the parts that are repeated are repeated for the whole of the period of calculation. With rebasing only the …
Fundamental Concepts Notes Goal-seeking cannot be used in conjunction with looped modules. If you wish to goal seek at a product or fund level, you should use the REPEAT_LEVEL function. Variables used in goal-seeking Variable Description SEED_VAL Seed value for first iteration. PREV_VAL Value for current iteration. NEXT_VAL Value for next iteration. IF_CONVERGED If iteration has converged. How …
Dates CODE_SEGMENT Dates ; Valuation Date IF LEN(STRVAL(MONTH(EXTRACT_DATE))) = 1 THEN VAL_DATE = STRVAL(YEAR(EXTRACT_DATE)) + “0” + STRVAL(MONTH(EXTRACT_DATE)) ELSE VAL_DATE = STRVAL(YEAR(EXTRACT_DATE)) + STRVAL(MONTH(EXTRACT_DATE)) ENDIF ; Last-Year End LYE_DATE = STRVAL(YEAR(EXTRACT_DATE) – 1) + “12” ; Beginning of Current Year BOY_DATE = STRVAL(YEAR(EXTRACT_DATE)) + “01” ; Last-Month LM_M = STRVAL(NUMVAL(SUBSTR(VAL_DATE, 5, 2)) – 1) IF LEN(LM_M) = 1 THEN LM_M …