Software solutions for actuaries

Act-fx : the Actuarial Toolkit for Excel

Date

Function                      Description

AgeExact                      Age exact (years).
AgeNrst                         Age nearest birthday.
AgeNext                        Age next birthday.
AgeLast                        Age last birthday.
CompleteMonths           Number of complete months between two dates inclusive.
CompleteTaxYears       Number of complete tax years between two dates inclusive.
CompleteWeeks            Number of complete weeks between two dates inclusive.

CompleteYears             Number of complete years between two dates inclusive.
DaysExcl                       Number of days between two dates exclusive of second date.
DaysIncl                        Number of days between two dates inclusive of second date.
EarlierOf                        Earlier of two dates.
LastAnniv                      Last anniversary of a date before a given effective date.
LaterOf                          Later of two dates.
NrstAnniv                      Nearest anniversary of a date to a given effective date.
NextAnniv                      Next anniversary of a date after a given effective date.
StartTaxYear                 6th April before or equal to the specified date.
StatePensionDate          State pension date for specified sex and date of birth.
YearsCompleteMonths  Number of years between two dates inclusive rounded to complete months.
YearsExact                   Number of years between two dates inclusive unrounded.
YearsNrst                      Number of years between two dates inclusive rounded to the nearer year.


Market, statistical & statutory

Function                      Description

EarningsCap                  Earnings cap or notional earnings cap for the tax year.
GiltYield                         FTSE-Actuaries gilt yield* for specified index.
GiltYieldAnn                   FTSE-Actuaries gilt yield* for specified index annualised.
PPFYieldDef                  The yield in deferment for a PPF s179 valuation.
PPFYieldPay                  The yield in payment for a PPF s179 valuation.
RPI                                 Retail Prices Index for the specified month and year.
RPIAnnFrom                  Ratio of the Retail Prices Index for the year after the specified month and year to that
                                      at the specified month and year.
RPIAnnTo                       Ratio of the Retail Prices Index for the specified month and year to that at a year
                                      before the specified month and year.
CPI                                 Consumer Prices Index for specified month and year.
CPIAnnFrom                  Ratio of the Consumer Prices Index for the year after the specified month and year  to
                                      that  at the specified month and year.
CPIAnnTo                      Ratio of the Consumer Prices Index for the specified month and year to that at a year
                                     before the specified month and year.               


*FTSE-Actuaries gilt yield values not supplied.