分红保险核算表模板.xls

分红保险核算表本表以泰康金满仓交费5年为例；每年银行定期利率，保险分红可能会调整；您可以根据利率和分红比例测算购买的保单当前是否合算；收益差若为红色为亏；此表为个人理解，如有偏差欢迎指正。当年红利需根据实际情况自己填写当年利率请按下拉表选择填入保险金额即可自动算出各种收益金额及收益差当当年年红红利利累累计计收收益益复复利利计计算算总总收收益益保保险险金金额额生生存存金金1.80%119.18%101.80%6258.30701910005001.80%117.07%101.80%本本金金收收益益1.80%115.00%101.80%751.86524451.80%112.97%101.80%1.80%110.97%101.80%1.80%109.01%101.80%1.80%107.08%101.80%1.80%105.19%101.80%1.80%103.33%101.80%1.50%101.50%101.50%收收益益差差5823.91生生存存金金收收益益5506.441774当当年年利利率率累累计计收收益益复复利利计计算算总总收收益益存存款款金金额额两两年年定定期期一一年年定定期期2.79%114.75%102.79%434.39761710002.79%2.25%2.79%111.64%102.79%2.79%108.61%102.79%2.79%105.66%102.79%2.79%102.79%102.79%