Basic Excel Question- Insurance Premium Calculations

[Camilla_Brooks_8]

Interested in advice anyone would be able to provide for estimating insurance premiums for a number of different insurers. Each insurer writes a different amount of insurance and charges a different premium.

Premium = Rate * Insurable Value

Each insurer receives the same insurable value information. Estimating potential increases and would like to build out sensitivity model.

 

[James006]

Hi,

You should post a tiny explicit sample with actual numbers to expose the obstacle you are facing ... and show your expected result ...

 

[awoohaw]

@Camilla_Brooks_8 , Welcome to the forum , But, I'm not really sure how you can get any help with your question.
You already have a formula Rate * Insured Amount. But, you offer no other information on the challenge you are facing.

I'm guessing you need help with the sensitivity question. But, you don't say what makes something sensitive? What have the various insurers told you?
What is the sensitivity a measure of sensitivity of ?