# CEA Deductible Calculator - California Earthquake Authority by xiaopangnv

VIEWS: 2 PAGES: 47

• pg 1
```									HO BASIC                 1-2012 CEA Basic Earthquake Policy - Homeowners
1-2012 Policy                 Deductible calculation worksheet                                      Clear All

Step 1: Use this top section to enter and select the available coverage
Available Coverage       Date                     3/27/2013
Enter dwelling coverage limit \$\$:   \$                -       Insured
Select coverage A deductible %                       15%     Claim #
Select personal property limit \$\$   \$              5,000     Policy #
Select loss of use limit \$\$         \$              1,500     Adjuster
Select code upgrade limit \$\$        \$             10,000     Other

Step 2: Enter all covered damage to see if damage clears the policy deductible
Enter the \$\$ amount of covered damage                            Policy Sublimit             Allowed
A & B dwelling damage \$\$           \$               -                          NA                \$                -
+ Emergency measures \$\$            \$               -                   \$              -         \$                -
+ Damage to all chimneys \$\$        \$               -                   \$           5,000        \$               -
+ Damage to land                   \$               -                   \$          10,000        \$               -
Code upgrade costs                 \$               -       <-Not used in ded. calculation           Not used
Cov. C pers. prop. damage \$\$       \$               -       <-Not used in ded. calculation           Not used
+ Emergency measures PP \$\$         \$               -       <-Not used in ded. calculation           Not used
5% sublimit on personal property emergency measures ->              \$             250            Not used
Coverage D loss of use spent       \$               -       <-Not used in ded. calculation           Not used
Total damage that can be used in the deductible calculation ->         \$               -
Less policy deductible of ->       \$               -
Did damage clear deductible?                 NO              Amount over the deductible ->      \$               -

Step 3: This section shows what can be paid on this claim
Real property emergency measures paid before deductible ->                \$                 -
Pers. property emergency measures paid before deductible ->               \$                 -
Total emergency measures that can be paid before meeting deductible ->                          \$               -
After deductible is exceeded, pay this additional amount for Cov A & B ->                       \$               -

If additional debris coverage needed, enter amount ->                     \$             -       \$               -

Additional payment for code upgrade when claim exceeds deductible ->                            \$               -
0
Coverage C personal property paid when claim exceeds deductible ->                              \$               -
Coverage D loss of use (ALE) - Pay with no deductible ->                                        \$               -

Version 11-15-2012                  For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for homes as well as mobilehome and manufactured homes insured und
<- Use the "Clear all" blue button on the left to run a macro that clears all the user entries.

WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to Excel Options, Trus
Settings, Enable macros. Or... make sure to clear the contents of user entered cells. manually before using this
<- One can only enter data into yellow cells, and the Adjuster Comment section at the bottom.
Attention: The notes below are not intended to over ride the coverage found in a CEA policy.
Always apply coverage according to the CEA policy wording.

<- The \$20,000 code upgrade limit is not available on mobilehome / manufactured homes. It is only available on homes on s

<- Enter all covered A and B damage (other than chimney, land, and emergency measure costs).
<- Up to \$1,500 of emergency measures can be paid before the deductible is met and is not used in the deductible calculatio
<- Enter the chimney damage. Remember, hearth, mantel and fire box damage go into dwelling estimate per the chimney d
<- Enter any cost to repair land. Payment will be held to the \$10,000 policy sublimit.
<- Enter any code upgrade costs that are necessary to get a repair permit. Code is not used in the deductible calc. It is add
<- Enter all damage to covered personal property, as reduced by any applicable Coverage C sublimits. Do not include emer
<- Enter any emergency measures specific to protecting personal property. Sublimit is 5% of the C limit. This will be used a
<- This calculates the 5% emergency measures policy sublimit on personal property.
<- Enter any loss of use / ALE payments made. This is subject to the ALE limit purchased.
<- This is an addition of the above numbers.
<- This is the policy deductible calculated by multiplying the deductible % against the Coverage A limit
<- Amount if claim over the deductible. When the real property damage clears the deductible, payment for personal propert

<- If the policy deductible was cleared, proceed to see how much can be paid to the policyholder. Pay full RCV, do not take
<- Amount of real property emergency measures in the payment of up to \$1,500 in emergency measures, paid before the po
<- This is the amount of personal property emergency measure expenses used in the \$1,500 payment that can be paid befo
<- Up to \$1,500 of emergency measures can be paid before the deductible is met. This can include expenses to protect dwe

<- This includes emergency measures over \$1,500, up to the emergency measures policy sublimit. Total A & B paid cannot

<- Pay up to an additional 5% of Cov. A if damages exceeded the Coverage A limit, and there were documented, not previou

<- This is the amount that can be paid for code upgrade incurred or reasonably expected to be incurred. This is not included

<- PP including related PP emergency measures, when the Coverage A & B exceeds the policy deductible. This number sub

<- Payment for Coverage D - loss of use / additional living expense. No deductible applies to loss of use.

<- This is the total amount that can be paid on this claim.
Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the ex
uninsured loss. An uninsured loss might include their deductible or any damage that exceeded a polic
whether the mortgagee needs to be named on the payment check. When damage does not exceed t
with supervisor for the required wording of the CEA "Under Deductible" Letter that must go out on all un
red homes insured under the 2012 CEA HO policy - Basic

go to Excel Options, Trust Center Settings, Macro
anually before using this calculator.

available on homes on site-built homes.

the deductible calculation.
timate per the chimney definition. Chimney has a \$5,000 sublimit.

deductible calc. It is additional insurance that can be paid once the damage exceeds the deductible
ts. Do not include emergency measures specific to protecting personal property.
limit. This will be used as part of any \$1,500, pre-deductible payment.

ment for personal property payment is allowed.

Pay full RCV, do not take a hold back.
sures, paid before the policy deductible is met.
ent that can be paid before the deductible is met.
expenses to protect dwelling and or personal property.

Total A & B paid cannot be over coverage A & B policy limit.

documented, not previously compensated, debris removal expenses.

red. This is not included in the deductible calculation. See the deductible section of the policy where it reads; "only the following can be incl

uctible. This number subtracts any pers prop emergency measure expenses paid prior to meeting the policy deductible.

assistance to the extent that they had an
hat exceeded a policy sublimit. Determine
ge does not exceed the deductible, consult
must go out on all under deductible claims.
only the following can be included in the deductible calculation. Code upgrade is not included.
Condo                     1-2012 CEA Condominium Earthquake Policy
2012 Policy                          Deductible calculation worksheet                                      Clear All
Step 1: Use this top section to enter the available coverage
Enter the coverage limit                   Deductible      Date:                   3/27/2013
Cov A Building Property   \$                   - \$              - Insured
Cov C Personal Property      \$                - \$           750 Claim #
Cov D Loss of Use (ALE)      \$                -           None Policy #
Cov E Loss Assessment        \$                - \$              - Adjuster
Other
Step 2: Use this section to enter the amount of covered damage
Coverage A - Building property policyholder is responsible for                 Incurred                   Allowed
Covered damage to Cov. A Building (exclude emergency measures)              \$                      - \$                  -
Money spent on emergency measures up to the sublimit of \$1,500              \$                      - \$                  -
Total allowable coverage A damage                                                        \$                - .
Less the coverage A deductible                                                           \$                -
Coverage A payment                                                                       \$                -
Add building code upgrades expenses up to a limit of \$10,000                \$                      -   \$                -
Add debris removal expenses, if loss is over coverage A policy limit:       \$                      -   \$                -
Total that can be paid for Coverage A:                                     \$                -
Coverage C - Personal Property                                                     Incurred               Allowed
Enter the total amount of covered personal property damage:                     \$                  - \$                  -
Less the policy deductible                           \$                -
Gross loss                                           \$                -
Coverage C owed:                                                           \$                -
Additional insurance for debris removal if loss is over coverage C limit:       \$                  -                   \$0
Total that can be paid for Coverage C:                                     \$                -
Coverage D - Loss of Use / ALE                                                     Incurred               Allowed
Enter the total amount spent for Loss of Use / ALE                              \$                  - \$              -
There is no deductible on this coverage                                                           None
Total that can be paid for Coverage D:                                     \$                -
Coverage E-Loss Assessment                                                         Incurred               Allowed
Enter the total amount of covered loss assessment - exclude code upgrade        \$                  - \$                  -
Enter any code upgrades to covered items under loss assessment                  \$                  - \$                  -
Subtotal                                                \$                -
Less the policy deductible                              \$                -
Gross loss                                              \$                -
Total that can be paid for Coverage E:                                     \$                -

Adjuster comments          Total of all claim payments on this claim:                                 \$                -

Version 11-15-2012          For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for CEA Condominium claims written on the 1-2012 policy.
<- Use the blue button on the left to run a macro that clears all the user entries.

WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to Excel Options, Trust Center
Settings, Macro Settings, Enable macros. Or... make sure to clear the contents of user entered cells.

<- One can only enter data into yellow cells, and the Adjuster Comment section at the bottom.
Attention: The notes below are not intended to over ride the coverage found in a CEA policy.
Always apply coverage according to the CEA policy wording.

<- If Cov. A purchased, enter covered damage to built-in appliances, fixtures, alterations, and improvements within the dwelling
<- Enter emergency measures for Cov. A. This is sublimited to \$1,500.
.
<- This is the coverage A deductible
<- This is the total that can be paid for coverage A (up to the policy limit) before consideration of additional debris removal and c
<- Building code upgrade expenses associated with Coverage A. Additional limit of \$10,000 on top of the Cov A limit of \$25,000
<- Pay up to an additional 5% of Cov. A if damages exceeded the coverage A limit, and there were documented, not previously
<- Total that can be paid for Coverage A.

<- If coverage C purchased, enter the total amount of covered personal property damage including associated debris removal, a
<- Subtracts policy deductible from covered damage.
<- Gross loss before application of policy limit.
<- Coverage C payment restricted to no more than policy coverage C limit.
<- Additional debris removal coverage (limited to lesser of 5% of the cov C limit or \$1,000), if loss over policy limit, and where do
<- Total that can be paid for coverage C.

<- Enter the total amount of Loss of Use / ALE. Restricted to policy limit.
<- ALE never has a deductible in a CEA policy.
<- Amount of claim for ALE / Loss of Use that can be paid. Document the claim file with receipts. There is no time limit on CEA

<- Enter the total amount of covered loss assessment excluding any expense for code upgrade associated with these repairs.
<- Enter associated code upgrade expenses to repair covered loss assessment property. There is a \$10,000 sublimit for code i
<- Subtotal of all covered loss assessment expense before deductible.
<- Coverage E - Loss Assessment deductible.
<- Gross loss before the policy limit is applied.
<- This takes the gross loss and limits the payment to no more than the policy limit for this coverage.

<- Total that can be paid on this claim.

Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the extent that they had an unin
An uninsured loss might include their deductible or any damage that exceeded a policy sublimit. Determine whether the mortga
be named on the payment check. When damage does not exceed the deductible, consult with supervisor for the required word
"Under Deductible" Letter that must go out on all under deductible claims.
2012 policy.

cel Options, Trust Center
d cells.

provements within the dwelling unit including associated debris removal. If covered chimney damage exists, apply \$5,000 chimney sublimit.

top of the Cov A limit of \$25,000. Read the "and you repair…" wording in the coverage.
ere documented, not previously compensated, debris removal expenses.

ng associated debris removal, as reduced by any applicable coverage C sublimits.

s over policy limit, and where documented debris removal exists.

s. There is no time limit on CEA loss of use.

associated with these repairs.
e is a \$10,000 sublimit for code in this coverage.

the extent that they had an uninsured loss.
Determine whether the mortgagee needs to
supervisor for the required wording of the CEA
ts, apply \$5,000 chimney sublimit.
Renters                        1-2012 CEA Renters Earthquake Policy
2012 Policy                            Deductible calculation worksheet                                 Clear All
Step 1: Use this top section to enter the available coverage
Enter the coverage limit                  Deductible      Date:                    3/27/2013
Cov C Personal Property     \$           5,000 \$            750 Insured
Cov D Loss of Use (ALE)     \$           1,500            None Claim #
Policy #
Other
Step 2: Use this section to enter the amount of covered damage
Coverage C - Personal Property                                                     Incurred            Allowed
Enter the total amount of covered personal property damage                      \$               - \$              -
Enter amount of emergency measure taken to protect covered pers. Prop.          \$               - \$              -
Sub total of damage that can be used.                                   \$            -
Less the policy deductible                         \$          750
Gross loss                                         \$            -
Coverage C payment:                                                     \$            -
Additional insurance for debris removal if loss over coverage C limit:          \$               -   \$            -
Total that can be paid for Coverage C:                                  \$               -
Coverage D - Loss of Use / ALE                                                     Incurred            Allowed
Enter the total amount spent for Loss of Use / ALE                              \$               - \$              -
There is no deductible on this coverage                                                        None
Total that can be paid for Coverage D:                                  \$               -

Total of all claim payments on this claim:                              \$               -
Don't forget that CEA policies have sublimits for certain items of personal property:
\$2,500 sublimit on personal property owned by others.
\$250 on money, bank notes, coins, medals, including any that are part of a collection…
\$250 on securities, checks, money orders, deeds, bank notes, passports, tickets and more…
\$3,000 on computers, business or not, storage media, & software. Unusable software not covered...
\$1,000 on business property other than computers...

Version 11-15-2012                     For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for CEA Condominium claims written on the 1-2012 policy.
<- Use the blue button on the left to run a macro that clears all the user entries.

WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to Excel Options, Trust Center
Settings, Macro Settings, Enable macros. Or... make sure to clear the contents of user entered cells.

<- One can only enter data into yellow cells, and the Adjuster Comment section at the bottom.

Attention: The notes below are not intended to over ride the coverage found in a CEA policy.
Always apply coverage according to the CEA policy wording.

<- Enter the total amount of covered personal property damage including associated debris removal, as reduced by an app
<- Enter any emergency measures taken to protect covered personal property. These are sublimited to the lesser of 5% of

<- Subtracts policy deductible from covered damage.
<- Gross loss before application of policy limit.
<- Coverage C payment restricted to no more than policy coverage C limit.
<- Additional debris removal coverage (limited to lesser of 5% of coverage C limit or \$1,000), when loss over policy limit an
<- Total that can be paid for coverage C.

<- Enter the total amount of Loss of Use / ALE. Document the claim file with receipts. There is no time limit on CEA loss
<- ALE never has a deductible in a CEA policy.
<- Amount of claim for ALE / Loss of Use that can be paid up to policy limit.

<- Total that can be paid on this claim.

<- This is a partial summary of sublimits for some items of personal property.

Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the extent that they had a
An uninsured loss might include their deductible or any damage that exceeded a policy sublimit. When damage does no
deductible, consult with supervisor for the required wording of the CEA "Under Deductible" Letter that must go out on all un
claims.
1-2012 policy.

cel Options, Trust Center
d cells.

oval, as reduced by an applicable coverage C sublimits. Do not include emergency measures to protect personal property.
mited to the lesser of 5% of coverage C limit or \$1,000.

hen loss over policy limit and documented unpaid debris removal exists.

no time limit on CEA loss of use.

the extent that they had an uninsured loss.
When damage does not exceed the
r that must go out on all under deductible
ersonal property.
HO BASIC                  1-2003 CEA Basic Earthquake Policy - Homeowners
1-2003 Policy                  Deductible calculation worksheet
Step 1: Use this top section to enter and select the available coverage.
Available Coverage       Date                     3/27/2013
Enter dwelling coverage limit \$\$:   \$                -      Insured
Select coverage A deductible %                       15%     Claim #
Select personal property limit \$\$   \$              5,000     Policy #
Select loss of use limit \$\$         \$              1,500     Adjuster
Select code upgrade limit \$\$        \$             10,000     Other

Step 2: Enter all covered damage to see if damage clears the policy deductible.
Enter the \$\$ amount of covered damage                             Policy Sublimit
A & B dwelling damage \$\$            \$                 -                        NA
+ Emergency measures \$\$             \$                 -                 \$              -
+ Damage to all chimneys \$\$         \$                 -                 \$           5,000
+ Damage to land                    \$                 -                 \$          10,000
Code upgrade costs                  \$                 -     <-Not used in ded. calculation
Cov. C pers. prop. damage \$\$        \$                 -     <-Not used in ded. calculation
+ Emergency measures PP \$\$          \$                 -     <-Not used in ded. calculation
5% sublimit on personal property emergency measures ->               \$             250
Coverage D loss of use spent        \$                 -       Not used in ded. calculation
Total damage that can be used in the deductible calculation ->
Less policy deductible of ->
Did damage clear deductible?                 NO              Amount over the deductible ->

Step 3: This section shows what can be paid on this claim.
Start with the total amount of A & B damage, including all chimney damage.
Next, subtract all chimney damage included above, over the \$5,000 chimney sublimit.

New sub-total of A & B damage after adjustment to limit chimney to \$5,000

Total amount that can be paid for dwelling A & B claim up to policy limit:

If needed, enter amt. of additional debris removal coverage ->              \$               -

Coverage C personal property paid when claim exceeds deductible

Coverage D loss of use (ALE) - Pay with no deductible

Version 11-15-2012                  For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for homes as well as mobilehome and manufactured h
Clear All           <- Use the "Clear all" button on the left to run a macro that clears all the user entries.

ble coverage.                            WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to "Excel Opt
3/27/2013                       macros". Or... make sure to clear the contents of user entered cells. manually before using.
<- One can only enter data into yellow cells, and the yellow Adjuster Comment section at th
Attention: The notes below are not intended to over ride the coverage found in a CEA po
Always apply coverage according to the CEA policy wording.

<- The \$20,000 code upgrade limit is not available on mobilehome / manufactured homes. It is only avai

olicy deductible.
Allowed                                                                  `
\$                  -       <- Enter all the covered A and B damage (other than chimney, land, and emergency measure costs).
\$                  -       <- Separate emergency measures expenses and show them here. This will be limited to 5% of Coverag
\$                  -       <- Enter all chimney damage. Use all chimney damage in the deductible calculation, but in Step 3, only p
\$                  -       <- Enter any cost to repair land. Payment will be held to the \$10,000 policy sublimit.
Not used            <- Enter any code upgrade costs that are necessary to get a repair permit. Code is not used in the dedu
Not used            <- Enter all damage to covered personal property, as reduced by any applicable coverage C sublimits. D
Not used            <- Enter any emergency measures specific to protecting personal property. Sub-limit is 5% of the C limi
Not used            <- This calculates the 5% emergency measures policy sublimit on personal property.
Not used            <- Enter any loss of use / ALE payments made. This is subject to the ALE limit purchased.
\$                  -       <- This is an addition of the above numbers.
\$                  -       <- This is the policy deductible calculated by multiplying the deductible % against the Coverage A limit.
\$                      -   <- When the real property damage clears the deductible, payment for personal property is allowed.

claim.                                   <- If deductible cleared, proceed to see how much can be paid to the policyholder. Pay full RCV, do not
\$                      -   <- To determine payment, start with the total coverage A & B damage amount that includes all the chimn
\$                      -   <- This is a negative number used to adjust chimney damage back down to the \$5,000 of chimney policy

\$                      -   <- Total amount of A & B damage after adjustment to limit chimney payment to the policy sublimit of \$5,0

\$                      -   <- Payment for coverage A & B. This is limited to no more than the policy limit of insurance.

\$                      -   <- Pay up to an additional 5% of cov. A if damages exceeded the Coverage A limit, and there were docu

\$                      -   <- This is the amount that can be paid for code upgrade incurred or reasonably expected to be incurred.

\$                      -   <- Payment for coverage C - personal property. PP is paid up to the policy limit when the coverage A &

\$                      -   <- Payment for coverage D - loss of use / additional living expense. No deductible applies to loss of use

\$
\$                  - -     <- This is the total amount that can be paid on this claim.
Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the exte
uninsured loss might include their deductible or any damage that exceeded a policy sublimit. Determine
the payment check. When damage does not exceed the deductible, see your supervisor for the required
that must go out on all under-deductable claims.

ur CEA Claim Liaison.
bilehome and manufactured homes insured under the 2003 CEA Basic HO policy.
user entries.

does not work, go to "Excel Options", "Trust Center Settings", " Macro Settings", "Enable
anually before using.
Adjuster Comment section at the bottom.
the coverage found in a CEA policy.

nufactured homes. It is only available on homes on site-built homes.

emergency measure costs).
s will be limited to 5% of Coverage A.
e calculation, but in Step 3, only pay up to \$5,000 for chimney damage.

it. Code is not used in the deductible calc. It is additional insurance that can be paid once the damage exceeds the deductible.
plicable coverage C sublimits. Do not include emergency measures specific to protecting personal property.
ty. Sub-limit is 5% of the C limit.
nal property.
LE limit purchased.

% against the Coverage A limit.
rsonal property is allowed.

icyholder. Pay full RCV, do not take a hold back.
mount that includes all the chimney damage.
n to the \$5,000 of chimney policy limit.

ment to the policy sublimit of \$5,000.

cy limit of insurance.

age A limit, and there were documented, not previously compensated, debris removal expenses.

onably expected to be incurred. This is not included in the deductible calculation. See the deductible section of the policy where it reads; "o

icy limit when the coverage A & B damage exceeds the policy deductible.

deductible applies to loss of use.

or federal assistance to the extent that they had an uninsured loss. An
ded a policy sublimit. Determine whether the mortgagee needs to be named on
e your supervisor for the required wording of the CEA "Under Deductible" Letter
xceeds the deductible.

ction of the policy where it reads; "only the following can be included in the deductible calculation. Code upgrade is not included.
not included.
Condo                         1-2003 CEA Condominium Earthquake Policy
1-2003 Policy                         Deductible calculation worksheet                               Clear All
Step 1: Use this top section to enter the available coverage
Enter the coverage limit                  Deductible      Date:                 3/27/2013
Cov A Building Property   \$                   - \$             - Insured
Cov C Personal Property      \$                - \$          750 Claim #
Cov D Loss of Use (ALE)      \$                -          None Policy #
Cov E Loss Assessment        \$                - \$             - Adjuster
Other
Step 2: Use this section to enter the amount of covered damage
Coverage A - Building property policyholder is responsible for                Incurred              Allowed
Covered damage to coverage A building (exclude emergency measures)         \$                 - \$                 -
Money spent on emergency measures up to a 5% sublimit of A.                \$                 - \$                 -
Total allowable coverage A damage:                                  \$               -
Less the coverage A deductible:                                     \$               -
Coverage A payable:                            \$               -
Additional insurance for building code upgrades up to a limit of \$10,000:  \$                 -   \$               -
Additional insurance for debris removal, if loss over cov. A policy limit: \$                 -   \$               -
Total that can be paid for Coverage A:                               \$               -
Coverage C - Personal Property                                                   Incurred           Allowed
Enter the total amount of covered personal property damage:                   \$              - \$                 -
Enter any emergency measures taken to protect personal property.              \$              - \$                 -
Less the policy deductible                      \$               -
Gross loss                                      \$               -
Coverage C payment:                                                  \$               -
Additional insurance for debris removal if loss over coverage C limit:        \$              -   \$               -
Total that can be paid for Coverage C:                               \$               -
Coverage D - Loss of Use / ALE                                                                      Allowed
Enter the total amount spent for Loss of Use / ALE:                           \$              - \$              -
There is no deductible on this coverage.                                                    None
Total that can be paid for Coverage D:                               \$               -
Coverage E-Loss Assessment                                                                          Allowed
Enter the total amount of covered loss assessment - exclude code upgrade:     \$              -   \$               -
Enter any code upgrades to covered items under loss assessment:               \$              -   \$               -
Subtotal                                           \$               -
Less the policy deductible                         \$               -
Gross loss                                         \$               -
Total that can be paid for Coverage E:   \$               -

Adjuster Comments                                    Total of all claim payments on this claim: \$               -
Version 11-15-2012   For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for CEA Condominium claims written on the 1-2003 policy.
<- Use the blue button on the left to run a macro that clears all the user entries.

WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to Excel Options, Trust Center
Settings, Macro Settings, Enable macros. Or... make sure to clear the contents of user entered cells.

<- one can only enter data into yellow cells, and the Adjuster Comment section at the bottom.
Attention: The notes below are not intended to over ride the coverage found in a CEA policy.
Always apply coverage according to the CEA policy wording.

<- If cov. A purchased, enter covered damage to built-in appliances, fixtures, alterations, and improvements within the dwelling
<- Enter emergency measures to protect real property. This is sublimited to 5% of the policy coverage A limit. (\$1,250)
.
<- This is the coverage A deductible.
<- This is the total that can be paid for coverage A (up to the policy limit) before consideration of additional debris removal and
<- Building code upgrade expenses associated with coverage A. Additional limit of \$10,000 on top of the cov A limit of \$25,00
<- Pay up to an additional 5% of Cov. A if damages exceeded the coverage A limit, and there were documented, not previousl
<- Total that can be paid for coverage A.

<- If cov. C purchased, enter the total amount of covered personal property damage including associated debris removal, as re
<- Emergency measures to protect personal property provides coverage up to a sublimit of the lesser of 5% of the policy limit
<- Subtracts policy deductible from covered damage.
<- Gross loss before application of policy limit.
<- Coverage C payment restricted to no more than policy coverage C limit.
<- Additional debris removal coverage (limited to lesser of 5% of the cov. C limit or \$1,000), if loss over policy limit, and where
<- Total that can be paid for coverage C.

<- Enter the total amount of Loss of Use / ALE. Restricted to policy limit.
<- ALE never has a deductible in a CEA policy.
<- Amount of claim for ALE / Loss of Use that can be paid. Document the claim file with receipts. There is no time limit on CE

<- Enter the total amount of covered loss assessment excluding any expense for code upgrade associated with these repairs.
<- Enter associated code upgrade expenses to repair covered loss assessment property. There is a \$10,000 sublimit for code
<- Subtotal of all covered loss assessment expense before deductible.
<- Coverage E - Loss Assessment deductible.
<- Gross loss before the policy limit is applied.
<- This takes the gross loss and limits the payment to no more than the policy limit for this coverage.

<- Total that can be paid on this claim.
Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the extent that they had an un
An uninsured loss might include their deductible or any damage that exceeded a policy sublimit. Determine whether the mort
be named on the payment check. When damage does not exceed the deductible, see your supervisor for the required wordin
"Under Deductible" Letter that must go out on all under deductible claims.
2003 policy.

cel Options, Trust Center
d cells.

provements within the dwelling unit including associated debris removal. If covered chimney damage exists, apply \$5,000 chimney sublimit.
erage A limit. (\$1,250)

op of the cov A limit of \$25,000. Read the "and you repair…" wording in the coverage.
ere documented, not previously compensated, debris removal expenses.

ssociated debris removal, as reduced by an applicable coverage C sublimits.
esser of 5% of the policy limit or \$1,000.

ss over policy limit, and where documented debris removal exists.

s. There is no time limit on CEA loss of use.

associated with these repairs.
e is a \$10,000 sublimit for code in this coverage.

the extent that they had an uninsured loss.
Determine whether the mortgagee needs to
pervisor for the required wording of the CEA
s, apply \$5,000 chimney sublimit.
Renters                       1-2003 CEA Renters Earthquake Policy
1-2003 Policy                          Deductible calculation worksheet                              Clear All
Step 1: Use this top section to enter the available coverage
Enter the coverage limit                  Deductible      Date:                    3/27/2013
Cov C Personal Property     \$           5,000 \$           750 Insured
Cov D Loss of Use (ALE)     \$           1,500            None Claim #
Policy #
Other
Step 2: Use this section to enter the amount of covered damage
Coverage C - Personal Property                                                       Incurred           Allowed
Enter the total amount of covered personal property damage                        \$              - \$               -
Enter amount of emergency measure taken to protect covered pers. Prop.            \$              - \$               -
Sub total of damage that can be used:                   \$             -
Less the policy deductible:             \$           750
Total loss:                    \$             -
Coverage C payment up to policy limit:                                   \$             -
Additional insurance for debris removal if loss over coverage C limit:            \$              -   \$             -
Total that can be paid for Coverage C:                                   \$             -
Coverage D - Loss of Use / ALE                                                     Incurred             Allowed
Enter the total amount spent for Loss of Use / ALE       \$                - \$             -
There is no deductible on this coverage                                     None
Total that can be paid for Coverage D:                                       \$             -

Total of all claim payments on this claim:                               \$             -
Check policy for sublimits:          Personal property owned by others limited to \$2,500.
\$250 on money, bank notes, coins, medals, including any that are part of a collection…
\$250 on securities, checks, money orders, deeds, bank notes, passports, tickets and more…
\$3,000 on computers, business or not, storage media, & software. Unusable software not covered...
\$1,000 on business property other than computers...

Version 11-15-2012                     For assistance with this calculator, contact your CEA Claim Liaison.
Use this deductible calculation worksheet for CEA Condominium claims written on the 1-2003 policy.
<- Use the blue button on the left to run a macro that clears all the user entries.

WARNING - The "Clear all" button uses an Excel Macro. If this button does not work, go to Excel Options, Trust Center
Settings, Macro Settings, Enable macros. Or... make sure to clear the contents of user entered cells.

<- One can only enter data into yellow cells, and the Adjuster Comment section at the bottom.

Attention: The notes below are not intended to over ride the coverage found in a CEA policy.
Always apply coverage according to the CEA policy wording.

<- Enter the total amount of covered personal property damage including associated debris removal. Do not include emer
<- Enter any emergency measures taken to protect covered personal property. These are sublimited to the lesser of 5% of

<- Subtracts policy deductible from covered damage.
<- Gross loss before application of policy limit.
<- Coverage C payment restricted to no more than policy coverage C limit.
<- Additional debris removal coverage (limited to lesser of 5% of Coverage C limit or \$1,000), when loss over policy limit an
<- Total that can be paid for Coverage C.

<- Enter the total amount of loss of use / ALE. Document the claim file with receipts. There is no time limit on CEA loss o
<- ALE never has a deductible in a CEA policy.
<- Amount of claim for ALE / Llss of use that can be paid up to policy limit.

<- Total that can be paid on this claim.

<- This is a partial summary of sublimits for some items of personal property. Read the policy.

Don't forget to remind the policyholder that they may be eligible for state or federal assistance to the extent that they
had an uninsured loss. An uninsured loss might include their deductible or any damage that exceeded a policy
sublimit. When damage does not exceed the deductible, see your supervisor for the required wording of the CEA
"Under Deductible" Letter that must go out on all under deductible claims.
2003 policy.

cel Options, Trust Center
d cells.

oval. Do not include emergency measures to protect personal property.
mited to the lesser of 5% of C: or \$1,000.

hen loss over policy limit and documented unpaid debris removal exists.

no time limit on CEA loss of use.

the extent that they
ceeded a policy
wording of the CEA
July 1, 2012 CEA Basic Earthquake Policy - Homeowners Choice
Deductible Calculation Woorksheet
Step 1: Use this top section to enter and select the available coverage
Coverage that the policyholder purchased             Date                     3/27/2013
Enter dwelling coverage limit \$\$:   \$                -      Insured
Select Coverage A Deductible %                      15% Claim #
Select Personal Property limit \$\$   No coverage             Policy #
Select Personal Property ded. %                          15%     Adjuster
Select Loss of Use limit \$\$             No coverage              Other
Select Code Upgrade limit \$\$            \$           10,000       Other

Step 2: Enter all covered damage and determine what can be paid
REAL - Enter the \$\$ amount of covered damage                            Policy Sub limit
A & B dwelling damage \$\$                \$                 -                          NA
+ Emergency measures \$\$                 \$                 -      5% of A->                    \$0
+ Damage to all chimneys \$\$             \$                 -                               \$5,000
+ Damage to land                        \$                 -                            \$10,000
Code upgrade costs                      \$                 -         <-Not used in ded. calc.->
Total A & B damage that can be used in the deductible calculation ->
Less policy deductible of ->
Total gross amount of loss ->
Amount of claim for Coverage A & B damage up to policy limit ->
Pay this amount for emergency repairs before the deductible is met ->
Pay this amount for coverage A. It excludes emergency measures already paid->
Pay code upgrade costs once deductible is exceeded ->
Enter unpaid debris removal expenses if loss over Cov A limit-> \$                    -

Total of all payments for real property ->

PERSONAL - Enter the \$\$ amount of covered damage                             Policy Sub limit â
Cov. C pers. prop. damage ->            \$                 -                          NA
+ Emergency measures to PP->            \$                 -       5% of C              #VALUE!
Total amount of personal property that can be used in deductible calculation ->
Less policy deductible of ->
Total gross amount of loss ->
Pay this amount for emergency measures before the deductible is met ->
Pay this amount for coverage C. This excludes emergency measures already paid ->

Total of all payments for personal property ->
0
LOSS 0f USE - \$\$ incurred ->            \$                 -             Pay up to policy limit ->

Version 11-15-2012                     For assistance with this calculator, contact your CEA Claim Liaison.
Clear All
oice                               Use this deductible calculation worksheet for homes as well as mobilehome and manufactured
Clear All         <- Use the "Clear all" blue button on your left to run a macro that clears all the user entries.

ble coverage                                     WARNING - The "Clear all" button uses an Excel Macro. If this button does no
3/27/2013                                  Macro Settings, Enable macros. Or... make sure you clear the contents of user
<- You can only enter data into yellow cells, and the Adjuster Comment section
Attention: The notes below are not intended to over ride the coverage fou
Always apply coverage according to the CEA policy wording.
7-1-2012 CEA Basic Earthquake Policy - Homeowners Choi
Deductible calculation worksheet
<- The \$20,000 code upgrade limit is not available on mobilehome / manufactured homes. It is only ava

an be paid                        <- In the CEA HO Choice policy, there is a deductible for both real and personal, and if real excee
\$\$s Allowed                        In the CEA HO Choice policy, the policyholder is required to have coverage A. Pe
\$0   <- Enter all the covered A and B damage.
\$0   <- Up to \$1,500 of emergency measures can be paid before the deductible is met and that amount is no
\$0   <- Enter the chimney damage. Chimney sublimit is \$5,000. Remember, hearth, mantel and fire box da
\$0   <- Enter any cost to repair land. Damage amount is held to the \$10,000 policy sublimit. Any land damag
\$0   <- Enter any code upgrade costs that are necessary to get a repair permit. Code is not used in the dedu
\$0   <- This is the total amount of real property A & B damage that can be used in the deductible calculation.
\$0   <- This calculates the real property policy deductible.
\$0   <- If this amount is over the policy limit, the deductible may be absorbed and full policy limits can be paid
\$0   <- This is the amount of real property damage that can be paid for up to the policy limit.
\$0   <- Pay this amount for emergency measures (up to \$1,500) before the deductible is met.
\$0   <- Pay this amount for coverage A. It does not include emergency repairs already paid.
\$0   <- Additional payment for code upgrade coverage, up to policy limit. This is in addition to the coverage A
\$0   <- Additional payment of up to 5% of Cov. A if covered damages exceeded the coverage A limit and ther

\$0   <- This is the total of all the payments for coverage A real property.

\$\$s Allowed
\$0   <- If personal property coverage purchased, enter all covered damage. Do not include emergency meas
#VALUE!        <- Enter any emergency measures specific to protecting personal property (PP). Sub-limit is 5% of the
#VALUE!        <- This is the total amount of personal property that can be used in this deductible calculation.
\$0   <- This calculates the personal property deductible. The personal property deductible is waived when th
#VALUE!        <- If this amount is over the policy limit, the deductible may be absorbed and full policy limits can be paid
\$0   <- Pay this amount for emergency measures to personal property (up to \$1,500) before the deductible is
#VALUE!        <- Payment for personal property, up to the policy limit. This excludes emergency measures already pai

#VALUE!        <- This is the total of all the payments for coverage C personal property.

\$0   <- If loss of use coverage was purchased, enter all LOU / ALE payments made. This is subject to the AL

#VALUE!        <- This is the total amount that can be paid on this claim.

Determine whether the mortgagee needs to be named on any real property payment. When damage do
supervisor for the required wording of the CEA "Under Deductible" letter that must go out on all under de
ur CEA Claim Liaison.
ehome and manufactured homes insured under the 7-2012 CEA HO Choice policy.
e user entries.

o. If this button does not work, go to Excel Options, Trust Center Settings,
clear the contents of user entered cells manually before using.
djuster Comment section at the bottom.
er ride the coverage found in a CEA policy.
y wording.
Policy - Homeowners Choice

ctured homes. It is only available on site-built homes. Mobilehomes have \$10,000 code upgrade coverage.

personal, and if real exceeds its deductible, the personal deductible is waived.
d to have coverage A. Personal property and loss of use coverages are optional.

s met and that amount is not used in the deductible calculation.
arth, mantel and fire box damage go into dwelling estimate. See chimney definition.
cy sublimit. Any land damage above \$10,000 Is not used.
Code is not used in the deductible calc. It is additional insurance that can be paid once the damage exceeds the deductible
n the deductible calculation.

full policy limits can be paid.
Clear All
ctible is met.
in addition to the coverage A payment. Code is not used in the deductible calculation
he coverage A limit and there were documented, not previously compensated, debris removal expenses.

not include emergency measures specific to protecting personal property.
PP). Sub-limit is 5% of the C limit. These expenses can be used as part of a \$1,500, policy pre-deductible payment.
uctible calculation.
deductible is waived when the real property deductible is exceeded.
full policy limits can be paid.
500) before the deductible is met.