ILVA/RILA & AG54 : Overview and Intro to Excel Lambda Libraries

ABOUT THIS WEBINAR

The increase in Registered Index-Linked Annuities (RILAs)/Index-Linked Variable Annuities (ILVAs) has prompted regulatory evolution, including the adoption of Actuarial Guideline LIV (AG 54). This 90-minute webinar will provide an overview of Index-Linked Variable Annuity (ILVA)/Registered Index-Linked Annuity (RILA), a policy paper published in Dec. 2025, that presented a description of definitions, relevant product considerations, and practices believed to be commonly used by actuaries employed by life insurance companies issuing RILA/ILVA products.

In addition to an overview of ILVA as it relates to AG 54, this webinar will feature a hands-on presentation on leveraging Excel’s Lambda Dynamic Array Function to build reusable, extensible libraries for replicating data. The Academy hosts the Excel Lambda Array to replicate the duplicate the calculations in AG54. This functional programming approach offers actuaries a powerful framework for streamlining complex calculations and improving consistency across workflows.

After attending this webinar, participants will be able to:

• Recognize RILA/ILVAs and common index strategies.
• Explain Interim Value under AG 54 and the IIPRC-A-03-I-ILVA standard.
• Understand how to apply Excel’s Lambda Dynamic Array Function to create reusable, extensible libraries for replicating actuarial data.
• Describe how this functional programming approach was demonstrated and adapted in the context of the policy paper, including how to access open-source code libraries hosted by the Academy.

MODERATOR

Beth Keith, MAAA, FSA
Chairperson, Index-Linked Variable Annuity Subcommittee

SPEAKERS

Ryan Stowe, MAAA, FSA, CFP
Member, Index-Linked Variable Annuity Subcommittee

Yolanda Chow, MAAA, FSA
Member, Index-Linked Variable Annuity Subcommittee

Bryon Robidoux, MAAA, FSA
Member, Index-Linked Variable Annuity Subcommittee

REGISTRATION

Registration for this webinar is limited to the first 1,000 registrants. Visit our webinar FAQs to learn more about our webinar policies, including group registration.

For more information about this webinar, contact education@actuary.org.

Event Pricing

• Members: $55
• Nonmembers: $110
• Group Registration for Academy Members: $500

Complimentary registration is available to the following cohorts of Academy members. Contact education@actuary.org to request a discount code to register.

• Government regulators
• Academy volunteers who meet both
  • “active” members of an Academy committee, board, subcommittee, task force, or work group; and
  • qualified for either a partial or full dues waiver during 2026.

Contact education@actuary.org to request a discount code to register

CONTINUING EDUCATION

The American Academy of Actuaries believes in good faith that attendance at this live webinar constitutes an organized activity as defined under the current Qualification Standards for Actuaries Issuing Statements of Actuarial Opinion in the United States, and that attendees may earn up to 1.8 organized continuing education (CE) credits for attending this live webinar. 

ADDITIONAL INFORMATION
Registration for this webinar is limited to the first 1,000 registrants. Visit our webinar FAQs to learn more about our webinar policies, including group registration. For more information about this webinar, contact education@actuary.org.