Subject: Intro to Underwriting
1. Topic-
Census Analysis
2. Content-
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)-

Open-door policy

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.

This Lesson Plan is available at (