Calculate the insurance premium values for Columns E and I. The formulas are based on a flat rate of $100 per policy, $35 added for each policy level, and 60% additional for each year under 100 in age.

 

For example, Policy Level 1 costs $35 and Policy Level 2 costs $70 plus $100 base rate. If the client is 67 years old, then an additional $33 is added at a discount of 40%, or 100-67 times.

What is the formula?

1001 12747 67 1 $ 154.80