AXIS Assignment #4: Understand and Reconcile Key Results for Variable Universal Life Products

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

AXIS Assignment #4: Understand and Reconcile Key Results for Variable Universal Life Products

In this assignment, you will use the AXIS cells I have provided to understand and reconcile/calculate the results in various reports in the UL module. Your final product will be an Excel workbook that shows the results you pasted from AXIS, and your own calculation (for reconciliation). Remember you have to do the actual calculation IN EXCEL, instead of using it to display results. You should have one spreadsheet for each of the following three cells.

1- Cell “VUL Equity” – Illustration Reports

(1) Please reconcile “NAAR Period Start” column in the Main illustration report.

(2) Columns to be reconciled in “Fund 1 total” illustration report: Risk Charge, Interest Credited, Fund Period End.

(3) Please only reconcile the first 36 policy months of results.

2- Cell “VUL 5yr GIC”

“Fund 1 investment Account 1” illustration report:

(1) Reconcile the “Matured Deposits” values for PM60, 72, 120, and 132.

(2) Reconcile “Interest Credited”, and “Average Credited Rates” for the entire year of attained age 66 (PM61-72)

(3) Reconcile “Net Premium Deposit” for PM13 and 25.

(4) Reconcile the “Transfer Mth Start” value for PM265. Answer this question: why did you not transfer the full amount that was needed to deplete the pending account negative balance? You can write your answer in a cell in the same Excel spreadsheet you are working on.

“Fund 1 total” report:

(1) Please first reconcile “NAAR Period Start” column in the Main illustration report for the first 24 policy months only.

(2) Columns to be reconciled in “Fund 1 total” report: Risk Charge, Fund Period End

(3) Please only reconcile the first 24 policy months of results.

3- Cell “VUL Equity_Separate Acct”

(1) Reconcile Surrender Benefit, Seg Fund Fees Received, and Book Profit in the Policy Year Report.

(2) Please only reconcile the first policy year result. Please be sure to use the information in the Illustration reports (monthly) for this reconciliation (for example, please do not directly use the mortality charge and expense charge columns in the PY report to reconcile Seg Fund Fees Received column, instead, you should start with the monthly illustration report).