|
Subject: Intro to Underwriting |
|
1. Topic-
|
|
2. Content-
|
Census
Headers
Excel Functions (pivot tables, calculating ages, etc.)
Plan Maximums
Guaranteed Issue Level
Carrier Q&A |
|
|
3. Goals: Aims/Outcomes-
|
1. Manipulate census data in order to run meaningful manuals and
populate various underwriting calculators
2. Understand census content to verify plan design
3. Analyze census data to perform in-depth analysis of various meaningful
measures (example: appropriate claim distribution, guaranteed issue
risk, etc.) |
|
|
4. Objectives-
|
1. Identify required census information
2. Understand excel functions and how they relate to underwriting
needs
3. Ability to differentiate between
4. Relate reinsurance issues effectively. |
|
|
5. Materials and Aids-
|
Sample census data
Sample RFP document
Underwriting workbook
Underwriter Add-Ins
Census checklist |
|
|
6. Procedures/Methods-
|
A. Introduction-
1. Observation
2. Hands-on practice
|
|
|
B. Development-
1. Observation of case or senior underwriter manipulating census
2. Census training modules and in-house Excel Help Desk videos
|
|
|
C. Practice-
Manipulation of sample census data using checklist
|
|
|
D. Independent Practice-
1. Manipulation of additional census data.
2. Compare output of census data to original output of life RFP
|
|
|
E. Accommodations (Differentiated Instruction)-
|
F. Checking for understanding-
Live case scenario - pair up with senior case underwriter on an
active case. Take charge of census manipulation portion concurrently
with senior underwriter to check understanding.
|
|
|