You need to double check the formulae inside your excel Looks like the annualised return does not cater the exact timing of the premium payment.
@Bowtiehongkong5 ай бұрын
hey Brownie-b, thanks for the comment We were assuming the premium is paid at the beginning of the each policy year in an annual payment mode, so the "surplus amount" is immediately invested for the duration of the whole year. Happy to hear your thoughts and open to adjust the model to cater other scenarios too. let us know, cheers!