Calculate Cost of Lifetime Cover over 15 years for Dog Insurance

[lotsmac]

Hi. Please can anyone help?

The dog is one. Last year cover was £115.08 for the year and this year has been quoted as £128.88 which is an increase of nearly 12%. It seems from search of the web that by the age of 8 the premium will have increased by about 34% and when he is 15 it will have increased by about 56%.

I would like a spreadsheet showing the total amount I will have paid by the time the dog is 15 so I can make a decision whether to continue life cover.
Have been trying but my maths/spreadsheet skills are not up to it.

If there is someone who enjoys this sort of thing I would be very grateful for your help.

Many thanks.

 

[kweaver]

If that increase remains constant, you could put 115.06 in A1, 128.88 in B1, and in B2, calculate the increase using: =(B1-A1)/A1

Then, in C1 and fill across the columns to O1: =B1*(1+$B$2) and you'll see at 15 in column O the amount will be 563.09 based on a continual increase of about 12%.

 

[lotsmac]

If that increase remains constant, you could put 115.06 in A1, 128.88 in B1, and in B2, calculate the increase using: =(B1-A1)/A1

Then, in C1 and fill across the columns to O1: =B1*(1+$B$2) and you'll see at 15 in column O the amount will be 563.09 based on a continual increase of about 12%.

That is extremely kind of you and I appreciate that. I will try this out.

Many thanks