ChatterBank3 mins ago
Maturing insurance policy
Answers
No best answer has yet been selected by Mallaig. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.If you any good with Excel, an easy way is to calculate a little spreadsheet that multiplies up the increasing value of the policy based on an estimated percentage value of the growth. All the calculations in the spreadsheet have to be referenced back to this cell in the spreadsheet, which is initially estimated. Once you've developed a basic map of the payments in and the increasing value per year up to the maturity date, you compare the final figure it gives you, then change the spreadsheet cell containing the estimated % growth, until it produces the maturity value as stated by the company. It may sound complex but it took me about 20 minutes to knock something up for a 25 year policy. HTH.