Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
life contingencies
I'm doing an excel spreadsheet for a life contingencies right now. I'm
reproducing an illustrative life table with different values for the sexes (lx). I have completed my life table including qx,px,dx etc... so I have all the values for px, qx, lx, and dx so far, from age 0 to like 110. I need to calculate values for temporary life insurance and temporary life annuity due (Ax and ax with the double dots). The data are all aranged in columns. So what kind of excel function do you use to get the insurance values? ( ie the sum of (v^k)*(kpx) from k=0 to n-1) Obviously you cant sit there typing in all the values of k, so how do you get excel to do the summation of the general formula? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
life contingencies
sylphide,
Don't multi-post, just post once, to one group. See my reply in microsoft.public.excel HTH, Bernie MS Excel MVP "sylphide" wrote in message ... I'm doing an excel spreadsheet for a life contingencies right now. I'm reproducing an illustrative life table with different values for the sexes (lx). I have completed my life table including qx,px,dx etc... so I have all the values for px, qx, lx, and dx so far, from age 0 to like 110. I need to calculate values for temporary life insurance and temporary life annuity due (Ax and ax with the double dots). The data are all aranged in columns. So what kind of excel function do you use to get the insurance values? ( ie the sum of (v^k)*(kpx) from k=0 to n-1) Obviously you cant sit there typing in all the values of k, so how do you get excel to do the summation of the general formula? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
asset life | Excel Discussion (Misc queries) | |||
Shelf Life Percentage | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Money for life | Excel Worksheet Functions | |||
Money for life | Excel Discussion (Misc queries) |