I could probably put one together myself, but there must exist somewhere out there an Excel spreadsheet that calculates term life reserves.
To be very specific, I want to use…
Mortality: 1980 CSO ALB M/F
Interest: 4.00%
Premiums & Benefits for 15 years
CRVM, Mean, Semi-continuous
If you have one & are willing to share it with me, kindly send it to actuary1695814 [at] gmail.
If you know of one that exists in the wild on the internet, a link would be helpfully nice.
That is not a data input; that is the tool.
OK, so your data columns will be:
Some Policyholder Number
Birthdate (need to know current age, right?)
Issue Date
Sex
Policy Amount
Annual Premiums
(Could have been done by now… by some life actuary, not me.)
How many rows will your data be? Will determine whether to do them line-by-line with
a macro or not.