CA2455473A1

CA2455473A1 - System and method for providing financial planning and advice

Info

Publication number: CA2455473A1
Application number: CA002455473A
Authority: CA
Inventors: Jodi Jenson; Mark Ledson; Patti P. Lipinski; William J. Moran; Linda Ostrem; Beth M. Vanney
Original assignee: American Express Travel Related Services Company, Inc.; Jodi Jenson; Mark Ledson; Patti P. Lipinski; William J. Moran; Linda Ostrem; Beth M. Vanney
Current assignee: American Express Travel Related Services Co Inc
Priority date: 2001-07-31
Filing date: 2002-07-31
Publication date: 2003-02-13
Also published as: JP2007234049A; WO2003012594A3; US20050010510A1; US20030028466A1; JP4557933B2; JP2006318500A; US20050004855A1; KR20040019378A; WO2003012594A2; US8306885B2; US8498913B2; EP1412835A4; JP2004537799A; EP1412835A2; AR034959A1; US8407125B2; US20050004856A1; US20040267651A1

Abstract

The present invention provides systems and methods for facilitating financial advising and planning for a user. According to an exemplary embodiment of the present invention, the system includes a portfolio integration module (107) for facilitating integration of a user's goals, assets, savings, and risk tolerance to facilitate analyzing and developing a customized strategy for financial portfolio planning. A portfolio reconciler module in communication with the portfolio integration module (107) facilitates comparison of the customized strategy to other strategies and projected user financial decisions in order to further facilitate the financial portfolio planning of the user. A
stochastic modeling module (111) in communication with the portfolio integration module (107) and the portfolio reconciler module (109) for facilitating the use of data from the portfolio integration module (107) and the portfolio reconciler module (109) in a stochastic modeling analysis using a synchronous stationary bootstrap sampling method to facilitate creation of a proposed situation portfolio for the user.

Description

SYSTEM AND METHOD FOR PROVIDING
FINANCIAL PLANNING AND ADVICE
Field of Invention The present invention relates generally to financial planning and advice systems and, more specifically, to financial planning and advice systems using stochastic modeling with a stationary bootstrap sampling method to model a user's financial situation.
Background of the Invention Achieving personal financial objectives generally includes a long-team relationship with a trusted and knowledgeable financial advisor who can assist with periodic financial planning. A financial advisor who is able to develop these types of relationships and meet a client's need for periodic financial planning thereby facilitates client retention. Inaccurate consumer impressions that financial planning is a once in a lifetime event should be mitigated in order to facilitate advisor-client relationships and accurately assess the client's current financial position as well as their future direction. An initial evaluation of a client's financial situation, followed by periodic reevaluation in light of changes in asset performance, market conditions, and client objectives, is important for the realization of the client's financial goals. Since initiating, building, and maintaining long-temp advisory relationships with a client aids in becoming a successful advisor, financial planners are constantly searching for methods to foster this relationship in an effort to better serve clients and remain competitive.
Generally, the financial advice and information that is pr ovided in a financial plan is becoming standardized as a result of the standards set forth by the Certified Financial Planning College and the adoption of those standards by the International Organization of Standards (ISO). Therefore, minimum levels of quality regarding the financial advice provided to clients are required to meet these standards and satisfy consumer needs.
However, consumers of financial advice are becoming increasingly sophisticated and are, therefore, demanding more complete services fiom financial service companies and advisors.
For example, in order for a financial advisor to prepare a comprehensive, integrated, financial plan for a client, it is useful to be able to illustrate to the client the effects of future uncertainty on that financial plan. A financial planner's ability to model the effects of unpredictable future events enhances the value of a financial plan to a client because it allows the client to prepare for those events in proportion to the likelihood of their eventuality.
Conventional financial advice applications generally ask the financial planner to input assumed rates of return (or a return rate that is calculated based upon the client's cmT eat investment portfolio) for the client's current and proposed investment portfolio without deteunining the type of strategy that might be best suited to the particular client's financial situation and objectives. In addition, a myriad of conunercially available products target each of the three main financial categories, that is, cash, equity, and bonds, as well as the various subcategories of each. For example, equity funds can be categorized as domestic or international, large cap stock, small cap stock, etc. While it is difficult to keep abreast of all the mutual funds that a particular company may offer, financial planners are assisted in the selection of financial investment products by a variety of tools that can access and store the product offerings of at least a particular company in a database.
These conventional applications are unsatisfactory in several regards.
Existing model portfolio engines do not adequately blend shoat-term and long-term needs to arrive at a client's recommended portfolio. Financial products capable of meeting the recommended portfolio are typically selected outside of the application. Conventional applications often fail to provide a cmTent list of available products within the application that are directed to specific consumer needs. Furthermore, these applications do not offer an adequate proposed investment strategy for the client. Current financial planning tools usually provide detemninistic illustrations (which may foster a false sense of ceutainty).
Moreover, existing financial applications often provide stochastic modeling only of retirement goals and do not normally present stochastic models addressing lifetime cash flow, disability, long-term care, and death, for example. Finally, current applications do not offer personalized quality financial advice that is consistent with industry standards and tailored to the client's individualized needs.
In view of the foregoing, there is a need for financial planning systems and methods which overcome the shortcomings of conventional computer implemented financial planning applications.
Summary of the Invention The present invention provides systems and methods for probability modeling which facilitates ftnancial advising and planning. A portfolio integration module facilitates

2 integration of at least one of a user's goals, assets, savings, and risk tolerance in analyzing and developing a customized strategy for financial planning of the user. A
portfolio reconciles module communicates with the portfolio integration module to facilitate comparison of the customized strategy to other strategies and projected financial decisions in order to further facilitate the financial planning of the user. A stochastic modeling module in communication with the portfolio integration module and the portfolio reconciles module uses data fiom the portfolio integration module and/or the portfolio reconciles module in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user. The stochastic modeling module uses a synchronous stationary bootstrap method of statistical sampling to facilitate analysis of historical economic data in order to facilitate creation of the proposed situation portfolio. A simulator module in communication with the portfolio integration module and the stochastic modeling module may be used to forecast the effects of changes to the probability modeling system and to monitor and test the system over a predetermined amount of time.
Brief Description of the Drawings Additional aspects of the present invention will become evident upon reviewing the non-limiting embodiments described in the specification, the appendices and the claims taken in conjunction with the accompanying figures, wherein like numerals designate like elements, and wherein:
FIG. 1 is a block diagram of a system for facilitating financial planning and advising for a user in accordance with an exemplary embodiment of the present invention;
FIG. 2 is a block diagram of a more detailed system for facilitating financial planning and advising for a user in accordance with an exemplary embodiment of the present invention;
FIG. 3 is a flowchart of a method for facilitating financial planning and advising for a user in accordance with an exemplary embodiment of the present invention;
FIG. 4 illustrates the bootstrapped estimate of the samples' geometric mean standard errors as functions of block size 1/p;
FIG. 5 illustrates the cyclical behavior of Japanese inflation within a period of about 12 months;
FIG. 6 illustrates the bootstrapped autocorrelation estimate for Japanese inflation;
and

3

4 PCT/US02/24315 FIG. 7 illustrates the bootstrapped auto covariance estimate for Japanese inflation.
Detailed Description The following disclosure presents, describes and teaches various exemplary embodiments in sufficient detail to enable those skilled in the art to practice the invention, and it should be understood that other embodiments may be realized without departing from the spirit and scope of the invention. Thus, the following detailed description is presented for proposes of illustration only, and not of limitation, and the scope of the invention is defined by the appended claims.
The system of the invention, as well as any of its component systems, may include a host server or other computing system, including a processor for processing digital data, a memory in communication with the processor for storing digital data, an input digitizer in communication with the processor for inputting digital data, an application program stored in the memory and accessible by the processor for directing the processing of digital data by the processor, a display in communication with the processor and memory for displaying information derived from digital data processed by the processor and a plurality of databases, the databases including client data, merchant data, financial institution data and/or like data that could be used in association with the present invention.
The present invention includes, in general, a comprehensive and integrated financial advising and planning system. The system includes probability modeling which facilitates the determination of the probability for successfully achieving identified personal financial goals based upon at least one of thousands of hypothetical projections of each of several types of scenarios, which may include, for example, scenarios such as the premature death, disability, retirement, and/or long-term care needs of any member of a particular household or other economic group. The probability modeling facilitates quantification of future unceutainty through statistically valid sampling to provide accurate simulations of a client's potential financial future. Each scenario has its own simulation-sets, which use, for example, common underlying economic and portfolio assumptions and combine these assumptions with unique scenario-specific cash flow activity. In this way, the resources used to meet financial goals and address concerns are rationally interactive and integrated between scenarios. For example, resources used to purchase disability insurance may not be available as savings for college education, or tax savings resulting from the use of tax-defei~red vehicles may have a positive effect on all scenarios. The system can also select appropriate strategies and tactics for achieving selected personal financial goals and/or facilitate the selection of appropriate strategies depending on the needs of the system and users. The system also enables financial advisors and their clients to collaborate over the Internet to conduct financial planning for the client.
FIG. 1 illustrates a system 100 for facilitating financial planning and advising for a user 101 in accordance with an exemplary embodiment of the present invention.
System 100 includes user 101 in communication with a financial advisor 103 and a server 105 via communication channels 115 and 117, respectively. Financial advisor 103 and server 105 also communicate via communication channel 119. Communication channels 115, 117, and 119 may be one channel or separate channels depending on the needs of system 100. In addition, user 101 and financial advisor 103 are illustrated as separate elements, but may also be the same element depending on the needs of system 100.
User 101 submits data to financial advisor 103 and/or server 105 via communication channels 115 and 117. The data may include user financial information (e.g., current and expected income, expenses, liabilities, assets, policies, taxes, Social Security/social pension, social pension information, company pension, and/or the like), user personal information (e.g., marital status, date of birth, age, occupation, lifestyle, family members, and/or the like), user goals, System assumptions, user risk tolerance, and/or the like.
User's 101 net Worth is one measure of financial security and can be used along with an analysis of cash flow to help determine user's 101 ability to achieve his or her goals. For example, net worth is calculated by subtracting the total liabilities from the total assets. User and/or system assumptions include assumptions in connection with investment perfomnance, inflation, taxation, cost of insurance, cost of insurance growth rates, interest rates, risk tolerance and personal needs and objectives. Depending on the needs of system 100 and/or user 101, such assumptions could be designated by user 101. In this manner, system 100 does not rely on user 101 to make difficult uneducated decisions about future inflation rates, interest rates, investment market performance, cost of insurance growth rates, and/or the like. Financial advisor 103 can help user 101 select appropriate assumptions. For example, user 101 provides the ownership information and current values of assets and insurance policies to server 105. However, some of these assumptions may be modified in the process of analyzing user's 101 goals.
User 101 can quickly provide personalized and high-quality financial data to system 100 and receive quick financial advice. Based upon user's 101 data input, server 105 receives user's 101 cmTent situation (e.g., current investment portfolio, insurance information, personal information, scenario information (e.g., insurance, tax, disability, long-temn care, goals, and/or the like)). Server 105 can create a proposed situation portfolio based upon at least one of user's 101 data input, goals, and goal assumptions. A
proposed situation portfolio may include a proposed investment portfolio along with, for example, scenarios (e.g., normal life span, disability, long-term care (e.g., costs, benefit, etc.), early death, and/or the like), life insurance information (e.g., costs, death benefit, etc.), disability insurance information (e.g., costs, disability benefit, etc.), Social Security, social pension, asset structure, savings, goals, retirement information, expenses, tax structure of assets and otherwise, savings, and/or company pension information, and other factors affecting a person's (or family member's) financial or personal situation. Proposed investment portfolios illustrate different methods of investing assets across various types of investments and may include, for example, asset structure, savings amounts, goals and amounts, retirement information, and/or the like. These proposed situation portfolios may improve the likelihood of success given a risk tolerance and a timeframe to achieve selected goals. In particular, server 105 is provided with the timeframe to achieve the goal, the dollar amount related to the goal, assets and savings available to meet the goal, and user's 101 risk tolerance. Simulations are run for each of the cmTent situation and the proposed situation portfolio and the simulations compare user's 101 cuiTent situation with the proposed situation portfolio.
When data is submitted to server 105, various elements within server 105 analyze the data to create and present advice to user 101 in the form of a proposed situation poutfolio.
Server 105 includes, in one embodiment, portfolio integration module 107, portfolio reconciles module 109, stochastic modeling module 111, and simulator module 113, which analyze the data to facilitate creating and presenting advice to user 101.
Portfolio integration module 107 facilitates integration of at least one of a user's 101 goals, assets, savings, and risk tolerance into customized proposed situation portfolio. Portfolio reconciles module 109 uses the proposed situation portfolio to facilitate allocation of assets, develop specific investments to fulfill investment strategies, and/or gather savings and premiums to develop specific investments appropriate for the proposed investment portfolio.
Stochastic modeling module 111 uses a stochastic sampling methodology of synchronous station bootstrap sampling of historical data to develop the probability of financial success after review of at least one of user's 101 data, user's 101 goals, user's 101 goal assumptions, and historical data. Probability of financial success may be developed by creating discrete projections of future market and economic behavior and applying these projections to user's 101 data in conjunction with various scenario assumptions. In each projection, user 101 may not be able to fund one or more of the goals depending on the needs of user 101. The individual successes and failures in the projections are aggregated by stochastic modeling module 111 to develop the probability of success. Simulator module 113 uses the data to simulate, monitor, and test portfolio integration module 107, portfolio reconciles module 109, and/or stochastic modeling module 111. Simulator module 113 may be a pan of server 105 or separate fiom server 105 (e.g., on a separate server or other device) depending on the needs of system 100.
PORTFOLIO INTEGRATION
In one exemplary embodiment of the present invention, portfolio integration module 107 integrates at least one of a user's 101 goals, assets, savings, and risk tolerance into customized proposed situation portfolio. Portfolio integration module 107 determines the portfolio strategies by considering the timing of at least one of a user's 101 goals, the amount of user's 101 goals, the amount of user's 101 asset base, the amount of user's 101 savings, and the user's 101 risk tolerance. The portfolio strategies include various portfolios, such as taxable assets, taxable savings, and tax-defeiTed assets/savings. These portfolios allow server 105 to distinguish between assets and savings needed to meet short-term goals and assets and savings needed for long-team goals. In this manner, the proposed situation poutfolio balances short-term market risks with long-team return potential. For example, portfolio integration module 107 can assess changes in fipancial planning assumptions, tax laws, other laws and regulations, and other developments, and integrate these changes into the proposed situation portfolio.
In one exemplary embodiment, server 105 assumes that consumers will spend their taxable assets first in order to fund their goals and that these assets represent what they have accumulated so far to realize their goals. Server 105 can also assume that savings represent funds that are available to be allocated for goals in the future. Server 105 can further assume that consumers will spend their life insurance cash value and premiums (e.g., net of the cost of insurance) before their tax-deferred retirement assets. Finally, server 105 can assume that consumers will spend their tax-defeiTed retirement assets last in order to leverage the tax advantages of deferred growth.

Portfolio integration module 107 determines the timeframe for user's 101 goals and the assets and savings user 101 may need in the short-term (e.g., within 10 years). Portfolio integration module 107 takes into account the relative timing and dollar amounts of the goals that will occur within, for example, 10 years. Large goals that may occur right away will be weighted more heavily than small goals that may occur later. A determination is made for the long-temp portfolio's timeframe based on the retirement date or the earliest retirement date (if the analysis is for more than one user). User's 101 risk tolerance is ascertained along with each time frame in order to map the customized proposed situation portfolio.
Poutfolio integration module 107 uses various poutfolios to develop the customized proposed situation portfolio. Various portfolios include, for example: regular assets, which provide a cash/fixed/equity mix for the taxable assets; regular contributions, which provide a cash/fixedlequity mix for ongoing contributions (e.g., savings) to taxable accounts;
retirement assets and contributions, which provide a cash/fixed/equity mix for retirement plans and other tax-defeiTed assets and ongoing contributions (e.g., savings);
VUL (Variable Universal Life) insurance cash values and premiums for those policies used to fund goals, which provide a cash/fixed/equity mix for life policy cash values and ongoing premiums;
VUL insurance cash values and premiums for those policies not used to fund goals, which provide a cash/fixed/equity mix for life policy cash values and ongoing premiums, and/or the like. These portfolios allow portfolio integration module 107 to distinguish between assets and contributions needed to meet shoat-term goals and assets and contributions needed for long-team goals. In this manner, the model allocation balances the short-term risks in the market with long-term r eturn potential.
For example, a taxable assets portfolios) and/or a taxable savings portfolios) have a shout-term model portfolio based on an average-weighted timeframe and risk tolerance and a long-term model portfolio based on first retirement date and risk tolerance. A
retirement savings and asset poutfolio is based on first retirement date and risk tolerance. A poutfolio associated with cash values and premiums may be a short-term model portfolio based on timeframe and risk tolerance. As such, these portfolios are used in portfolio integration module 107 to help develop the customized proposed situation portfolio.
Portfolio integration module 107 also determines the amount of taxable assets to be invested in the shoat-term and/or long-term assets portfolios. Poutfolio integration module 107 divides the dollar value of all goals occmTing, within for example ten years, by the value of the taxable assets. The result is the percentage of taxable assets to invest in the shoat-term assets portfolio. If user 101 has more assets than are needed to fund these goals, then part of the assets may be invested short-term and the remaining assets may be invested in the long-term assets portfolio (e.g., to fund goals that extend beyond 10 years). On the other hand, if user 101 does not have enough assets to fund these goals, the shortage can be funded out of user's 101 on-going savings and tax-defeiTed assets. Finally, the shoe-term and long-term assets portfolios are combined into one portfolio, namely, the taxable assets portfolio.
Portfolio integration module 107 then determines the amount of taxable savings to be invested in the short-term and long-term savings portfolios. This calculation is made by subtracting user's 101 taxable assets from the value of the goals occurring within 10 years, for example. The result of this calculation is the value of the goals that are not covered by user's 101 table assets; any shortage may be funded from taxable savings. If the asset base covers the goals, then savings are generally not allocated to the short-team portfolio.
The present value of the taxable savings is calculated. The funding needed from savings is divided by the present value of the taxable savings. This result is the percentage of savings to allocate to the shoat-term portfolio. If the value is greater than l, then all savings can be invested in the short-term portfolio. The remaining savings can be invested in the long-term savings portfolio (1-% short-term). Finally, the short-temp and long-term savings portfolios are combined into one portfolio: the taxable savings portfolio.
In addition, portfolio integration module 107 may use a master set of data for user 101 and then analyze that data depending on a number of predetermined scenarios. The different scenarios may represent various circumstances that user 101 may face in a lifetime that may affect user's 101 finances. For example, the master set of data may be analyzed for a normal life expectancy of user 101 and family members, disability of user 101 or family members, long-team care for user 101 or family members, early or unexpected death of user 101 or family members, and/or the like. The master data may be used to generate information for each scenario for each of the current situation and the proposed situation portfolio. The flexibility of portfolio integration module 107 allows for analysis of such scenarios in order to better analyze circumstantial effects on user's 101 finances and the integrated resource allocation between scenarios and user 101 scenarios (e.g., specific cash flow activity projections of user 101).
Thus, a customized portfolio is generated for user 101. Server 105 uses asset retm-ns based on the user's 101 cmTent situation (for the "cmTent" scenario) and the proposed situation portfolio (for the "proposed" scenario). In this way, server 105 can illustrate how user's 101 cmTent situation strategy, user's 101 risk tolerance, and the investment advice contribute to user's 101 ability to reach his or her goals. As user 101 makes changes to the amounts or timing of the goals, any implementation recommendations, user's 101 risk tolerance, and/or the proposed situation portfolio, the effects on user's 101 probability of success is dynamically updated.
Thus, system 100 ties the risk tolerance, resources, and goals to the customized proposed situation portfolio. In this manner, user 101 and/or financial advisor 103 need not input assumed rates of return for user's 101 current and proposed situation portfolios without a link to the type of strategy useful to user 101 or an average return rate calculated from how user's 101 assets are cmTently invested.
In order to fuuther illustrate portfolio integration module 107, an exemplary illustration of one embodiment of portfolio integration module 107 is attached as Appendix B, which is hereby incorporated by reference. In order to further illustrate cash flow calculations in connection with portfolio integration module 107, an exemplary illustration of one embodiment of calculating such cash flows is attached as Appendix I~, which is hereby incorporated by reference. Use of the terms "Japanese Lightning", "Lightning", "Apex", andlor "application" herein including the Appendices shall mean system 100.
PORTFOLIO RECONCILER
Once portfolio integration module 107 develops the proposed situation portfolio for user 101, portfolio reconciles module 109 andlor financial advisor 103 may further develop the proposed situation portfolio by selecting the specific investments to fulfill those strategies. Server 105 uses portfolio reconciles module 109 to illustrate how user's 101 proposed situation poutfolio compares to other model portfolio strategies and projected user 101 financial decisions and where changes can be made (e.g., at the asset class level) to the proposed situation portfolio. Portfolio reconciles module 109 facilitates specific action steps for user 101 to make (e.g., moving investment assets fiom the current portfolio to the proposed investment portfolio). As user 101 and/or financial advisor 103 makes buy, sell, and hold recommendations, portfolio reconciles module 109 monitors the recommendations and dynamically updates progress towar d the proposed situation portfolio.
Some user situations may not allow them to invest according to the proposed situation portfolio. For example, user 101 may have tax considerations that prevent him or her fiom selling a stock. However, since the proposed probability of success is based on the proposed situation portfolio, the completed buy/sell/hold recommendations are tested against the model portfolio strategies to determine if such recommendations are sufficiently close to each other. For example, the buy/sell/hold recommendations may be within a margin of 5%
at the cash/fixed/equity level of the proposed situation portfolio. If the recommendations are not sufficiently close, user 101 is informed and advised of the differences and asked to make further adjustments or state reasons for the differences.
Portfolio reconciles module 109 compares the cmTent situation of user 101 and the customized proposed situation portfolio and incorporates specific buy/sell/hold recommendations and/or decisions aiding in developing an appropriate customized proposed situation portfolio for user 101. Furthermore, testing the cmTent investment of user 101 against the proposed investment quantitatively aids user 101 and/or financial advisor 103 in developing appropriate customized proposed situation portfolio for user 101.
Still further, the ability to create a customized proposed situation portfolio and provide specific recommendations and available products distributed by a company to user 101 aids user 101 in improving his or her financial portfolio. Portfolio reconciles module 109 is "smart" in that once a particular type of product is selected by user 101, then options within that product type are displayed to user 101. For example, in the case of life insurance, information relevant to life insurance is displayed to user 101. In addition, information relevant to cost of insurance, increase in costs of insurance, savings from investing in insurance, and/or the like are analyzed. If a specific asset class is selected, then investments within that asset class are displayed (e.g., large-cap stock funds). To maintain such information, portfolio reconciles module 109 may be linked through the Internet to the current offerings of any company. Alternatively, portfolio reconciles module 109 may be maintained on a static database that may be updated either by batch processing (i.e., periodic updates) or in real time. Thus, portfolio reconciles module 109 further develops the proposed situation portfolio for user 101 by selecting the specific investments to fulfill those strategies.
In order to further illustrate portfolio reconciles module 109 and portfolio integration module 107, an exemplary illustration of one embodiment of portfolio reconciles module 109 and portfolio integration module 107 is attached as Appendix A, which is hereby incorporated by r eference.

STOCHASTIC MODELING MODULE
During cuiTent and/or proposed situation portfolio simulations, server 105 uses stochastic modeling module 111 to aid in modeling the uncertain nature of the future.
Examples of uncertainty include inflation, equity and bond market performance, bond returns, and/or the like. Inflation may impact expenses, incomes, and/or the like; whereas, market performance may impact investment returns, potential cost of loans, and/or the like.
Stochastic modeling module 111 measures the probability of user 101 reaching his or her lifetime financial goals (e.g., if the current situation portfolio is used versus if the proposed situation portfolio is implemented). Stochastic modeling module 111 analyzes several variables with a wide range of different values fiom year to year to randomly sample values fiom actual and/or generated historical data. For example, some historical data (e.g., back to the 1950s) may not be easily accessible, so that stochastic modeling module 111 may generate such historical data given other information from that economic period. The analyses from stochastic modeling module 111 take into consideration both favorable and unfavorable possible performance patterns. The analyses help calculate performance of investments given thousands of different patterns in month-to-month changes in economic conditions (e.g., inflation, cash returns, bond returns, stock market performance, and/or the like) and user 101 data (e.g., risk tolerance, amount and timing of goals, resources available to set aside toward goals, and/or the like).
Based upon the outcomes of the stochastic modeling module 111 and other inputs, a stochastic determination is made and a customized proposed situation portfolio is deliver ed to user 101. User 101 has the ability to propose specific implementation recommendation adjustments in an effort to match the current situation with the proposed situation portfolio.
The proposed situation portfolio may use stochastic modeling module 111 to rerun its analysis and generate an updated stochastic determination, as well as supplemental or updated proposed situation portfolio information. Server 105 provides user 101 with the ability to present information using either stochastic modeling andlor detemninistic illustrations in the proposal. As such, user 101 can determine how best to illustrate financial planning concepts or analyze financial planning needs to server 105, and using a stochastic modeling approach allows user 101 a method to communicate his or her needs to server 105.
Server 105 provides for stochastic modeling via stochastic modeling module 111 to illustrate the probability of financial success after review of at least one of user's 101 data, user's 101 goals, user's 101 goal assumptions, savings, asset base, insurance policies, historical data, and/or the like. Stochastic modeling module 111 is in communication with portfolio integration module 107 and poutfolio reconciles module 109 for using data fi~om at least one of portfolio integration module 107 and portfolio reconciles module 109 in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio and other planning strategies for uses 101. Since it is difftcult to predict performance of stock markets or investments for the future, it is helpful to use probability modeling to help account for future uncertainty.
Stochastic modeling module 111 uses a sampling methodology of historical data.
Historical data includes inflation rates, rates of return (stock returns, interest rates, and/or the like), T-bill rates, and/or any other information relevant to calculating financial information for user 101. Stochastic modeling module 111 maintains the auto-correlation behavior of inflation (e.g., the modeling of inflation is likely more similar from one period to the next as opposed to moving randomly and erratically) via a synchronous stationary bootstrap sampling method. For example, such modeling is more realistic in that inflation usually goes from 3.5% to 3.7% to 3.6% than 3.5% to ~.5% to 1.5% over a sample 3-year period.
Other techniques assume a fixed and constant rate of inflation or model inflation randomly (e.g., 3.5% to ~.5% to 1.5% over a sample 3-year period). Often these techniques force all of the rich information in the historical data to be compressed into three data points: return, variance, and correlation. Unlike such rigid techniques, stochastic modeling module 111 can maintain more information and better simulate the actual behavior of investments relative to each other (e.g., in a market correction, when assets tend to all go down together) and lag effects of inflation on interest rates.
In one exemplary embodiment of the present invention, stochastic modeling module 111 uses a stationary bootstrap sampling method of stochastic modeling analysis in sampling the historical data. The stationary bootstrap method uses rates of return, for example, to generate random periods of time (each of which has a rate of return). The stationary bootstrap method randomly selects a starting period in time to draw from, repeats this process, generates a length of time (e.g., one month) from which the period will be extended from, selects another starting period, grabs the specific data points in that period from all indexes in the data set synchronously (e.g., simultaneously), and generates a "P" number.
The P number is the length of time of one continuous strip of data and includes the number of periods used in one simulation run of stochastic modeling module 111. For example, the P number can be a period of time (e.g., 40 months) for an economic business period, or any other designation. Data may be sampled synchronously from the relevant economic business periods, pasted together in a sample set of data, and repeated for any type of projected period (e.g., amount of time desired, such as average lifetime, disability time, long-term care time, and/or the like). This sample set of data may be generated for more than one data set at a time, which provides synchronous stationary bootstrap data sampling. For example, a sample data set may represent an average length of an economic business cycle.
Synchronous data sampling uses convergence techniques (e.g., a geometric distribution) to calculate accurate rates of return, inflation rates (e.g., serial cowelation of inflation), and other such data. Synchronous data sampling leverages information from sample sets of data and extrapolates such information to create larger sets of data over a period of time (e.g., a selected economic business cycle, financial futures, and/or the like).
Synchronous data sampling aids in maintaining the integrity and richness of information in the historical data (e.g., effects of change in bond returns over the next several years) in order to provide more accurate rates of return, inflation rates, and other such data. See Dimitris N. Politis & Joseph P. Romano, The StatiofZary Bootstrap, Journal of the American Statistical Association, 1303-1313, Volume 89, Issue 428 (Dec. 1994), which is hereby incorporated by reference.
In one exemplary embodiment of the present invention, estimating the p-value in a stationary bootstrap method uses sample results in measuring stability of portfolio performance. Stationarity includes a quality of a process in which the statistical parameters of the process do not substantially change with time. One aspect of a stationary process is that the autocorrelation depends on lag alone and does not change with the time at which it was calculated. Analogies between auto correlated data and independent observations are also described. The stochastic processes in simulation experiments are usually auto correlated and consequently the time series or sample records they generate usually are not analyzed by traditional statistical methods that apply to independent observations. One way to reduce or eliminate autocorrelation is to perform transformations on the original time series. Traditional analysis is then applied assuming the transformed observations are uncorrelated. However, this procedure discards a considerable amount of valuable information about the behavior of a process and that the transformed time series may be inappropriate for comparison purposes. An alternative method is suggested for studying time series by exploiting the autocomelations rather than eliminating them.
The approach centers on estimating standard errors of the bootstrapped sample means for the original series (e.g., for stocks, bonds, cash and inflation) and comparing these statistics for several independent bootstraps.
In performing two bootstraps for the same length of simulated time, there is no reason to expect that the statistical quality of the two resulting time series or sample records will be the same. Suppose that the process being observed has the same variance but is more auto colTelated in one experiment than in the other, then the more auto correlated process will generally show fewer changes in value during a given time than the other will. With fewer changes, there is less fluctuation around the mean of the process, and consequently, it is not expected that stochastic modeling module 111 can obtain as good an estimate of the mean for the process with higher col~elation as is for the other. This brings up the problem how to determine stability of the sample mean of an auto colTelated process so that the dependence structure in the historical series is maintained in the bootstrap samples. Simple random sampling is usually not appropriate since it destroys any dependence in the series.
Accordingly, it is desirable to introduce a resampling procedure called the stationary bootstrap. The procedure is based on resampling blocks of random length, where the length of each block has geometric distribution. The average length of these blocks is 1/p and this quantity plays a similar role as the parameter b 111 the moving block method.
Although the stationary bootstrap estimate of standard elTOr is less sensitive to the choice of p than the moving blocks bootstrap method is to the choice of b, it is desirable to have an educated guess based on studying the data more deeply. The selection of the p value includes choosing a block size, which involves a tradeoff. As the block size becomes too small, the bootstrap destroys the time dependency of the data and its average accuracy will decline. As the block size becomes too large, there are few blocks and pseudo-data will tend to look alike. As a result, the average accuracy of the bootstrap also will decline.
This suggests that there exists an optimal block size, which maximizes accuracy.
The standard error of the sample mean computed from a set of independent observations is inversely proportional to 1/p. This is not true for auto col~elated data.
However, for a sufficiently small p-value, the standard deviation of the sample mean for auto colTelated data is inversely proportional to a fraction number of observations. This fractional number depends on the autocorrelation of the process. Using the colTelation time together with the observation interval, the number of independent observations contained in auto colTelated time series can be defined. Comparing these measures for two auto col.Telated samples allows the drawing of inferences about the relative stability of their sample means (as can be done with independent observations).
Based on historical observations of, for example, Japanese stock, bond, cash monthly returns, and inflation, FIG. 4 illustrates the bootstrapped estimate of the samples' geometric mean standard errors as functions of block size 1/p. As the 1/p increases, the corresponding estimate of the standard error initially increases, remains fairly constant, and then decreases.
Improved resolution accounts for the initial increase and stabilization, whereas the increasing influence of bias is responsible for the eventual decline. The estimates do appear to stabilize for 1/p between 25 and 50, the decline for greater 1/p introduces skepticism.
The following autocoiTelation plots illustrated in FIG. 5 reveal more about the randomness of such data sets for if random autocorrelations are near zero for any and all time-lag separations, and if non-random autocomelations then one or more of the autocorrelations is significantly non-zero.
FIG. 5 illustrates the cyclical behavior of Japanese inflation within a period of about 12 months. In this manner, it would be advisable to let 1/p be of the order of two or three cycles to allow for cancellations to take place. In one example, it would be advisable to take 1/p not lower than 38. The bootstrapped autocorrelation estimate for Japanese inflation is illustrated in FIG. 6. After the first three spikes the autocomelation becomes close to zero for lags greater than 38. FIG. 6 and 7 also reveal high autocoirelation of cash. In this example, the comparison of the auto covariance structure offers more insights into the true nature of the process. For 1/p greater than 38, the autoconelation properties of the original data are not significantly eliminated by bootstrap. This leads to an acceptable choice of 1/p not lower than 38. Thus, in this example, it is desirable to avoid underestimating the variance of stock returns in portfolio performance analysis, so that it is advisable to choose 1/p equal to 38.
Thus, an example for estimating p-value in stationary bootstrap has been provided.
The example assumes the input data is stationary. However, non-stationary data can also be used to provide a non-stationary bootstrap method. See Dimitris N. Politis, Joseph P.
Romano (1994), The Stationary Bootstrap, Journal of the American Statistical Association, Volume 89, Issue 428, 1303-1313; Russell Davidson & James G. MacKinnon, Bootstrap Tests: Size and Power of Bootstrap Tests, Working Paper, Department of Economics, Queen's University, Kingston, Ontario, Canada; Maurice R. Masliah, Stationarity/Nonstationarity Identification; James G. MacI~innon (1999), Bootstrap Testing in Econometrics, Working Paper Presented at the CEA Annual Meeting; Pin-Huang Chou (1996), Using Bootstrap to test Mean-Variance Efficiency of a Given Portfolio, Working Paper, Department of Finance, National Central University Chung Li, Taiwan;
Donald W. K.
Andrews ~ Moshe Buchinsky (1990, Evaluation of a Tree-step Method of Choosing the Number of Bootstrap Repetitions. Working Paper, Cowles Foundation for Research in Economics, Yale University; and Blake LeBaron & Andreas S. Weigend, A
Bootstrap Evaluation of the Effect of Data Splitting on Financial Time Series, Working Paper IS-97-013, Leonard N. Stem School of Business, New York University; all of which are hereby incorporated by reference.
The information from the synchronous stationary bootstrap method may be used in a stochastic modeling analysis to estimate user's 101 percentage of likelihood of achieving financial success. For example, many iterations of a lifetime simulation for user 101 can be run (e.g., 6750 iterations) returning either a successful or unsuccessful lifetime simulation.
Such a binomial technique can retm-n a successful run if user 101 has a predetermined amount of money or assets at the end of a lifetime simulation (otherwise retm.~ing an unsuccessful run). Stochastic modeling module 111 calculates user's 101 chance of achieving financial success using stochastic modeling of, for example, at least any or all of the following: rates of return, inflation rates, specific goals (e.g., education, accumulation, and/or the like), lifetime cash flow with integration of some or all goals, potential disability and/or need for a long-term care and/or death, and/or the like. As such, server 105 does not only adda-ess the probability of achieving financial success during retirement, but also considers various scenarios (e.g., long-temp care, disability, early death, and/or the like).
Stochastic modeling module 111 mimics actual behavior of relevant factors (inflation, rates of return, and/or the like) and allows all assets to be available to fund goals. In this way, if user 101 has too much for one goal, then the excess assets can be applied to another goal. If, for example, user 101 has a shortage of assets, then user 101 can use other assets. Also, user 101 may take out loans for goals that user 101 will pay back with excess income. Stochastic modeling module 111 can model a loan when assets are depleted before retirement, such that a loan balance is created, interest is accrued based on the level of inflation and a risk premium, and savings are applied to paying the loan off. When the loan is paid off, savings are applied to the investment portfolios.
Thus, stochastic modeling module 111 aids in forecasting the effects of various conditions and scenarios on the current situation. Stochastic modeling module 111 allows user 101 to forecast the effects of his or her goals and decisions on thousands of financial situations and provide a likelihood of success for each. In this manner, stochastic modeling module 111 allows user 101 to analyze the effects of his or her decisions on the likelihood of achieving his or her goals by aggregating the results of thousands of possible economic scenarios applied to various situations.
In order to further illustrate stochastic modeling module 111, an exemplary illustration of one embodiment of stochastic modeling module 111 is attached as Appendix C, which is hereby incorporated by reference.
Thus, system 100 analyzes the data to facilitate creating and presenting advice to user 101 and also automates the functions performed by financial advisor 103.
Server 105 integrates user's 101 goals, assets, savings, and risk tolerance into customized proposed situation portfolio via portfolio integration module 107. Server 105 uses the proposed situation portfolio to develop specific investments to fulfill those strategies via portfolio reconciles module 109. Server 105 uses a stochastic sampling methodology of historical data to develop the probability of financial success after review of user's 101 data, user's 101 goals, user's 101 assets and savings, various assumptions, and historical data via stochastic modeling module 111.
User 101 can quickly provide personalized, high-quality, financial data to system 100 and receive quick financial advice. After user 101 enters the data, system 100 generates advice that is specifically tailored for user 101. The advice is developed via a system of rules that automatically create and present the advice to user 101. In one exemplary embodiment, the advice includes observations, strategies, and recommendations for the proposed situation portfolio. Each observation, strategy, and recommendation has various aspects (e.g., logic associated with the financial advice analysis and text associated with the output to user 101). See U.S. Serial No. 09/712,743, entitled "System and Method For Creating Financial Advice Applications" and filed November 14, 2000; U.S.
Serial No.
091731,163, entitled "System and Method For Evaluating Work Product" and filed December 6, 2000; and U.S. Serial No. 09/141,013, entitled "Computer-Implemented Program For Planning and Advice System" and filed August 26, 1998; all of which are her eby incoipor ated by refer ence in their emir eties.
The following data may be used by server 105, in whole or in pant, to generate advice for uses 101: data entered by the user, calculations preformed by portfolio integration module 107, portfolio reconciles module 109, stochastic modeling module 111, and simulator module 113, and placement of the stochastic results generated by server 105 on a scale (e.g., probability of meeting a goal, percentage of likelihood of success, and/or the like). For example, probabilities and percentages may be valued as follows: 0%-49%
indicates a low probability of success in achieving user's 101 selected goals;
50%-74%
indicates a moderate probability of success in achieving user's 101 selected goals; and 75%
or more indicates a high probability of success in achieving user's 101 selected goals. The probability of success may be calculated by dividing the number of projections where at least one dollar of assets remained (e.g., at the time of retirement, at the time of death, or any other relevant time) by the total number of projections simulated. There are numerous options available to help improve the likelihood of meeting user's 101 selected goals:
reduce the amount of goals, delay the start date of goals, save more toward goals, reposition your investment assets, and/or the like. These probabilities and percentages and options may be re-defined by system 100 as desir ed.
In one exemplary embodiment of the present invention, server 105 uses various formulas for calculating each projection's cash flow and asset level which are aggregated into the probability of meeting a goal, percentage of likelihood of success, and/or the like.
Some considerations include analysis of income, liabilities, assets, living expenses (e.g., income minus liabilities, savings, insurance premiums, taxes, andlor the like), and various scenarios (normal lifespan, disability, early death, retirement, and/or the like). Depending on the needs of system 100, analysis of such infomnation may be broad (e.g., one value for liabilities) or detailed (e.g., specific breakdowns of each liability, such as house payment, car payment, student loans, etc.). Such flexibility of system 100 allows for wide usage of system 100 to many different applications.
Various information (e.g., text) in the form of advice may be presented to user 101 in the form of a proposal of the proposed situation portfolio. In one exemplary embodiment, there are three forms of advice: observations, strategies, and recommendations.
Observations include statements that primarily discuss user's 101 cmTent situation, such as, for example, cmTent non-contribution to a retirement savings plan. Exemplary observations for user 101 fiom server 105 may include: the additional money you committed to reach your financial goals should enable you to increase the likelihood of success;
you have allocated 2% of your total income to savings; although you are currently saving, the amount you are saving is below the national average; savings are an important step in helping you to successfully meet your financial goals; approximately 40% of your total income is being used to pay your liabilities; you should focus your attention on managing your debt; your earned income is the predominant source of income for maintaining your current lifestyle;
currently, earned income makes up 98% of your total income; our federal marginal tax bracket is 28% and your effective tax rate is 12%; it appears that you are not maximizing your retirement plan contributions; it appears that you have done a good job of utilizing deductions to manage your income tax liability; and/or the like.
Strategies include a discussion ofwhat user 101 can do to meet the selected financial goals, such as, for example, give consideration to investing savings in a Roth IRA.
Recommendations are derived fiom the strategies and include the specific action steps that user 101 may take to reach its financial goals, such as, for example, give consideration to investing a specific amount in a specific mutual fund. The timing of investment and need for liquid assets may also be considered. Each observation, strategy, and recommendation can also include variable text that further personalizes the advice for user's 101 financial situation. Some examples of variable text include: user's 101 name, names of products recommended, probabilities, dollar amounts needed to meet goals, and/or the like.
In an exemplary embodiment of the present invention, server 105 may categorize each observation, strategy, andlor recommendation into subcategories, such as required, recommended, or optional, for example. The purpose of these subcategories is to help speed up the preparation of advice (e.g., paragraph selection of text process) for user 101. A
required observation, strategy, and/or recommendation is usually included in user's 101 proposal and helps ensure that the proposals are legally compliant. An example is advice pertaining to a strategy user 101 is considering (e.g., changes to the portfolio, increased retirement age, add disability, LTC or life insurance, etc.). A recommended observation, strategy, and/or recommendation is based on the data and the simulated results fiom server 105 which best suits user 101. This advice is presented to user 101 optionally, so that if user 101 prefers not to use the advice, user 101 may refuse the advice. An optional observation, strategy, and/or recommendation is based on the data and the simulated results fiom server 105, which may apply to user 101. However, server 105 does not have enough information to "recommend" it. This advice is presented to user 101 optionally, so that if user 101 prefers to use the advice, user 101 may request the advice. Thus, this categorization allows user 101 to easily identify what advice will be included in the proposed situation portfolio.
If user 101 wishes, the selection process can be bypassed by simply printing the proposed situation portfolio. In one exemplary embodiment, all "required" and "recommended" advice is included. This presents user 101 with a financial portfolio proposal that provides accurate, personalized advice for user 101 that complies with legal standar ds. Furthemnore, by filter ing out extraneous advice and providing individualized, legally compliant, quality financial advice to user 101, server 105 frees up user's 101 time, so that he or she can concentrate on other tasks and spend time on more complex issues.
This advice may be fully editable text.
SIMULATOR MODULE
Either as a part of server 105 or separate from server 105, simulator module 113 uses the data to simulate, monitor, design, and test system 100 or parts thereof (e.g., server 105, portfolio integration module 107, portfolio reconciles module 109, and stochastic modeling module 111) including reconunendations for improvements to system 100 and the effects of changes. Simulator module 113 substantially mimics the operation of server 105 including portfolio integration module 107, poutfolio reconciles module 109, and stochastic modeling module 111. Simulator module 113 can be in communication with portfolio integration module 107 and stochastic modeling module 111 for testing, designing, replicating, and monitoring system 100. Such testing, designing, replicating, and monitoring of system 100 can be over a predeteumined amount of time (e.g., a normal lifespan, a disability lifespan, an early death lifespan, and/or the like). For example, simulator module 113 can assess changes in financial planning assumptions, tax laws, other laws and regulations, and other developments, and integrate these changes into the proposed situation portfolio.
In an exemplary embodiment of the present invention, simulator module 113 may use one or more spreadsheets (e.g., Excel~) to mimic server 105. For example, simulator module 113 obtains data in connection with user 101 from server 105 via a log file of data from server 105. Simulator module 113 can access the log file by using an address (e.g., web address) associated with server 105 to identify the data and copy it to simulator module 113. The log file may include data input by user 101, market and economic projections, cash flow from various scenarios, and descriptions of the data fields in the log file. The data is copied to simulator module 113 and configured so that it may be further analyzed by simulator module 113.
Simulator module 113 uses the data to determine whether there are programming eiTOrs in server 105, which helps to validate the data. For example, simulator module 113 uses the data to calculate income, future income, liabilities, expenses, and assets and compares these calculations to the same results from server 105. This form of calculation tests whether eiTOrs have been programmed into server 105 and/or whether server 105 otherwise contains eiTOrs.
Simulator module 113 uses the data to calculate the probability of meeting a goal, percentage of likelihood of success, and/or the like to further test system 100. Such calculations can include an aiT ay of spr eadsheets analyzing var ions data.
For example, probabilities and percentages may be valued to mimic values fiom server 105 (e.g., 0%-49%
indicates a low probability of success in achieving user's 101 selected goals;
50%-74%
indicates a moderate probability of success in achieving user's 101 selected goals; and 75%
or more indicates a high probability of success in achieving user's 101 selected goals). In one exemplary embodiment, simulator module 113 uses various spreadsheets of calculations (e.g., master data spreadsheet, insurance spreadsheet, Social Security/social pension, social pension spreadsheet, historical data spreadsheet, returns spr eadsheet, for ecasting spreadsheet, portfolio spreadsheet, testing spreadsheet, statistical spreadsheet, scenario spreadsheet, and/or the like) to analyze the data. For example, random rates of r eturn, non-qualified assets, qualified assets, savings, lifetime goals may be used in the analysis and calculations.
Simulator module 113 can use historical portfolio data and at least one of user's 101 financial decisions, investment strategy, present cash flow, future cash flow, and goals in order to facilitate forecasting the effects of the proposed situation portfolio on user's 101 portfolio, decisions, combination of decisions, investments, policies, and/or the like. Cash flow can include at least one of income, savings, liabilities, insurance premiums, living expenses, medical expenses, inheritance, government assistance, assets, and/or the like. In addition, simulator module 113 can forecast effects based on at least one of a country's current economic data, a country's historical economic data, cuwent world economic data, and historical world economic data.
In an exemplary embodiment, simulator module 113 can analyze many iterations of calculating such values. Simulator module 113 can use decision analysis and risk analysis products to help analyze the data, such as Crystal Ball~ by Decisioneering~ of Denver, Colorado. A product such as Crystal Ball~ can use the data including any formulas provided by simulator module 113 to run iterations for analyzing the data. In one exemplary embodiment, simulator module 113 uses 6750 iterations of data calculations using Crystal Ball~ in order to calculate the probability of meeting a goal, percentage of likelihood of success, and/or the like. Any number of iterations may be used depending on the needs of system 100. If such calculations are compared to the results of system 100 and are within a statistically predetermined amount (e.g., within 2%), then system 100 is assumed to be functioning properly. Such a predetermined amount may be set to any value (any percentage rate, another quantified value, and/or the like) depending on the needs of system 100.
Simulator module 113 can use data, such as historic or current rates of return, inflation rates, and estimated r ates of r eturn and inflation r ates, to calculate the pr obability of meeting a goal, percentage of likelihood of success, and/or the like. If the probabilities and percentages calculated fiom simulator module 113 are compared to the probabilities and percentages calculated fiom server 105 and they correlate within a predetermined amount (e.g., within 2%), then simulator module 113 can project a properly functioning system 100.
Such a predetermined amount can be varied depending on the needs (e.g., accuracy desired) of system 100.
Simulator module 113 may generate a master set of data for user 101 and then analyze that data depending on a number of predetermined scenarios. The different scenarios may represent various circumstances that user 101 may face in a lifetime that may affect user's 101 finances. For example, the master set of data may be analyzed for a normal life expectancy of user 101 and family members, disability of user 101 or family members, long-term care for user 101 or family members, early or unexpected death of user 101 or family members, and/or the like. The master data may be used to generate a spreadsheet of information for each scenario for each of the current situation and the proposed situation portfolio. The flexibility of simulator module 113 allows for analysis of such scenarios in order to better mimic server 105.
Various embodiments of system 100 are illustrated in FIG.s 2 and 3 in accordance with exemplary embodiments of the present invention. FIG. 2 illustrates system 100 in association with having a secure session between user 101, financial advisor 103, and server 105 in accordance with an exemplary embodiment of the present invention.
Further to FIG.
1, FIG. 2 includes an Internet web server 221 in communication with financial advisor 103 via communication channel 119. Communication 119 includes a fir ewall and uses, for example, http or https, a WAN, a LAN, a VPN tunnel, and/or the like, for communication.
For example, Internet web server 221 can be in association with a secure server (e.g., American Express~) requiring a user ID and password for authentication for access. The secure session can be logged in and out by user 101 or timed out automatically. In this way, all data is stored in a trusted domain of Internet web server 221 and encrypted when transmitted outside intemet web server 221.
FIG. 2 further illustrates aspects of the exemplary secure session. Financial advisor 103 begins a session with user 101 and server 105 via communication channels 115, 117, and 119. Financial advisor 103 begins a web session (e.g., receives signed JARs) for a user interface of server 105. Financial advisor 103 and/or user 101 may need a user ID and password in order to gain access to intemet web server 221 and begin a session. Submission of a user ID and password by financial advisor 103 and/or user 101 includes server 105 verifying the user ID and password. Server 105 uses any verification system in order to verify the user ID and password. The secure session may use any encryption method to validate or authenticate financial advisor 103 and/or user 101. If user 101 is not a new user, then financial advisor 103 retrieves the case file for user 101 fiom server 105. After retrieving user's 101 case file fiom server 105, financial advisor 103 andlor user 101 can update the personal, financial, risk tolerance, goal, and other data in association with user 101.
System 100 may run simulations and calculations using further information fiom an application server 223 in communication with UDB database server 231 and server 233.
UDB database server 231 includes a repository database 235, a library database 237, a stocks database 239, and a bonds database 241. Repository database 235 stores data user 101 submitted to server 105. Library database 237, stocks database 239, and bonds database 241 store various information (e.g., Securities and Exchange Commission information, bond returns and information, Social Security/social pension, social pension information, tax accounting and planning information, laws and regulations, and/or the like) used in calculations by server 105. Application server 223 includes portfolio integration module 107, portfolio reconciles module 109, stochastic modeling module 111, and simulator module 113. Application server 223 uses fiu-ther information fiom UDB database server 231 and server 233 to analyze data and create a proposed situation portfolio for user 101.
Financial advisor 103 initially reviews, reconciles, selects further data to be analyzed in connection with the proposed situation portfolio for user 101. Financial advisor 103 can reallocate user's 101 assets to attempt to meet user's 101 goals. The data is formatted and compiled into ~ format, which is further conveuted into a PDF (Portable Document Fomnat) document via the Arbor Text document rendering software. After such conversion and configuration, the data is presented to user 101 in the form of a proposed situation portfolio (e.g., via Adobe~ Acrobat~).
FIG. 3 is a flowchart of a method for facilitating financial advising and planning for user 101 in accordance with an exemplary embodiment of the present invention.
Although FIG. 3 illustrates a series of method steps, it will be realized that the order of particular steps may be altered and/or other steps may be omitted altogether while still attaining the same or a similar result. In one exemplary embodiment of FIG. 3, user 101 and/or financial advisor 103 communicate with server 105 (step 301). For example, user 101 and/or financial advisor 103 opens a web browser and enters a URL for accessing server 105. A
web page is retm-ned with a link to a JNLP file (e.g., for defining JARs to download and starting web session). User 101 clicks the JNLP link and server 105 retains a mime type JNLP, and the operating system may dispatch a web start to handle such a mime type. The web start checks the version of the JRE (Java Run-time Environment) and all the jars in the JNLP
check whether they have been downloaded to user 101 and/or financial advisor 105. Any jars that are not downloaded cache.
User 101 and/or financial advisor 103 gain access to server 105 (step 303).
User 101 and financial advisor 103 enter user IDs and passwords into server 105 (e.g., a security service may check such credentials). Once credentials are verified, the security service returns a cookie to server 105 verifying the same. Server 105 begins a session with user 101 and financial advisor 103.
User's 101 data, goals, and risk tolerance axe integrated in analyzing a customized strategy for financial poutfolio planning of user 101 (305). User 101 enters data into application server 223 via financial advisor 103 and/or web server 221. The data is periodically stored in repository server 235, which also uses the log file described in FIG. 1.
Server 223 analyzes the data as described in connection with server 105 in FIG.s 1 and 2.
The customized strategy is compared to at least one of other strategies and projected financial decisions in order to fiu-ther facilitate the financial portfolio planning of user 101 (step 307). Application server 223 analyzes the results from the customized situation portfolio and compares these results to the results from at least one of the other strategies and projected financial decisions from repository server 235.
The data from the integration is used and compared in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for user 101 (step 309). Application server 223 analyzes the data as described in connection with server 105.

Simulator module 113 mimics the operation of portfolio integration module 107, poufolio reconciles module 109, and stochastic modeling module 111 in order to test and monitor system 100 (step 311). Data may be accessed via application server 223 via web server 221. Finally, a proposed situation portfolio is presented to user 101 outlining various scenarios and recommendations for financial strategies for each (step 313).
Other exemplary embodiments of the present invention include further assumptions.
System assumptions for asset allocation and growth rates include the asset growth rates vary annually and are based on historical returns for cash, bonds, and stocks;
asset growth rates for a cmTent situation are based on cmTent investment portfolio data; asset growth sates for the proposed situation axe based on a proposed situation portfolio based on risk tolerance and the amount and timing of goals; investment portfolio (current and proposed) is adjusted annually to restore asset class weightings to their designated percentages;
asset growth rates are not based on the performance of specific investment products; all persons included in this analysis who have wages that are subject to FICA or self employment tax are fully insured and can receive full benefits; and/or the like. Omission of any assets or insurance policies in the analysis could lead to inaccuracies or distortions that would diminish its accuracy.
System assumptions for inflation include the inflation rate varies annually and is based on historical inflation rates and economic conditions in the relevant countiy(s); living expenses grow annually at the inflation rate (or an appropriate multiple thereof); Social Security/social pension, social pension benefits grow annually at about half the inflation rate;
and/or the like.
System assumptions for taxes include, for example, income during the simulations is taxed at an average tax rate; Social Security/social pension benefits are assumed to be 50%
taxable; all Social Security/social pension calculations are based on yearly intervals, regardless of actual Social Security/social pension rules; and/or the like.
Time estimates of federal income tax liability assumes no caiTyover fiom previous years other than those provided. Rules exclusive to capital loss limitations and passive losses are not considered.
Income taxes are calculated by applying an average tax rate to the sum of all taxable income amounts. Suggestions involving income, estate, or gift tax consequences are based on federal tax law. If user 101 is not currently receiving retirement Social Security/social pension, but indicated that he or she expects to in the future, then this analysis uses an estimate of user's 101 future retirement Social Security/social pension benefits. For example, user 101 may have provided such an estimate fiom his or her statement of benefits fiom the Social Security/social pension Administration, which is based on user's 101 actual ea~.nings history. Otherwise, an estimate is calculated (using the Social Security/social pension Administration's methodology), which makes assumptions about user's 101 past earnings based on this year's income.
System assumptions for disability include, for example, analysis between the ages of 18 and 60 years old and earnings or self employment income greater than $18,000 per year.
If included, the disability analysis assumes that user 101 will be disabled for the first twelve years of the projection or until retirement if earlier.
System assumptions for long-term care include, for example, long-temn analysis if user 101 is between the ages of 40 and 84. If included, the long-term analysis assumes that user 101 will require long-term care for the last six years of life.
System assumptions for survivor information include, for example, life expectancy of survivors of user 101 (if applicable) to detemnine the projection period;
benefits for surviving spouses will begin immediately or at the time survivor is 60 years old (whichever is later); survivor benefits for children under age 18 years old will begin immediately;
additional life insurance death benefits are not included in the decedent's estate, but do become additional investment capital for the survivor (if applicable); funeral costs are assumed to be $10,000 at death; administrative expenses are assumed to be 5%
of the probate estate; income tax ramifications of withdrawals from qualified plans at death, either to pay estate settlement costs or when such assets are distributed to non-spousal heirs, are not taken into account; and/or the like. For example, whole and universal life policy cash values and premiums may be available after savings are depleted, VCTL policy cash values and premiums may be available after whole and universal life polices are depleted, and consumers may spend their tax-defeiT ed retie ement assets last in order to leverage the advantages of tax-deferred growth.
System assumptions for success include, for example, having a positive investment balance (e.g., at least $1 of investment assets left at the end of the simulation (e.g., end of lifetime)); if goals occurring prior to retirement deplete investment assets, server 105 can simulate user 101 taking out a loan and directing future savings to the loan until it is paid off; simulations indicate past or future investment performance; actual results will vary and will be based on additional factors such as the asset allocation and investment products chosen and future market conditions.

System assumptions are, in one embodiment, adjusted and vary depending on the current regulations, laws, culture, preferences, and economic environment of each country.
System assumptions described above are mostly in connection with the United States, but each country's assumptions should be carefully selected in connection with these variations and adjustments. Thus, although specific examples are given above, they are for illustration purposes only and should not limit the scope of system 100.
The present invention may be described herein in terms of functional block components and various processing steps. It should be appreciated that such functional blocks may be realized by any number of hardware and/or software components configured to perform the specified functions. For example, the present invention may employ various integrated circuit components, e.g., memory elements, processing elements, logic elements, look-up tables, and the like, which may ca~Ty out a vaxiety of functions under the control of one or more microprocessors or other control devices. Similarly, the software elements of the present invention may be implemented with any programming or scripting language such as C, C++, Java, COBOL, assembler, PERL, or the like, with the various algorithms being implemented with any combination of data structures, objects, processes, routines, or other programming elements. Further, it should be noted that the present invention may employ any number of conventional techniques for data transmission, signaling, data processing, network control, and the like. For a basic introduction to cryptography, please review a text written by Bruce Schneider which is entitled "Applied Cryptography: Protocols, Algorithms, And Source Code In C," published by John Wiley ~ Sons (second edition, 1996), which is hereby incorporated by r efer ence.
It should be appreciated that the particular implementations shown and described herein are illustrative of the invention and its best mode and are not intended to otherwise limit the scope of the present invention in any way. Indeed, for the sake of brevity, conventional data networking, application development, and other functional aspects of the systems (and components of the individual operating components of the systems) may not be described in detail herein. Furthermore, the connecting lines shown in the various figures contained herein are intended to represent exemplary functional relationships and/or physical couplings between the various elements. It should be noted that many alternative or additional functional relationships or physical connections may be present in a practical electronic transaction system.
2~

It will be apps eciated that many applications of the pr es ent invention could be formulated. One skilled in the art will appreciate that the network may include any system for exchanging data or transacting business, such as the Internet, an intranet, an extranet, WAN, LAN, satellite communications, and/or the like. The users may interact with the system via any input device such as a keyboard, mouse, kiosk, personal digital assistant, handheld computer (e.g., Palm Pilot~), cellular phone, and/or the like.
Similarly, the invention could be used in conjunction with any type of personal computer, network computer, workstation, minicomputer, mainfiame, or the like running any operating system such as any version of Windows, Windows NT, Windows 2000, Windows 98, Windows 95, MacOS, OS/2, BeOS, Linux, UNIX, or the like. Moreover, although the invention may be described herein as being implemented with TCP/IP communications protocols, it will be readily understood that the invention could also be implemented using IPX, Appletalk, IP-6, NetBIOS, OSI, or any number of existing or future protocols. Moreover, the system contemplates the use, sale, or distribution of any goods (including downloadable software related to the computer application of the invention), services, or information over any network having similar functionality described herein.
Communication channels 115 117, and 119 are any hardware and/or software for enabling conununication between user 101, financial advisor 103, and server 105. For example, communication channels 115 117, and 119 may include any communications system that enables the transmission or exchange of data and/or facilitates electronic commercial transactions. Exemplary communication channels 115 117, and 119 include the Internet, an intranet, an extranet, a wide area network (WAN), local area network (LAN), satellite communications, and/or the like. In an exemplary embodiment, user 101, financial advisor 103, and server 105 may be suitably in communication with communication channels 115 117, and 119 via data links. A variety of conventional communications media and protocols may be used for data links, such as a connection to an Internet Service Provider (ISP) over a local loop, as is typically used associated with standard modem communication, cable modem, Dish networks, ISDN, Digital Subscriber Line (DSL), or various wireless communication methods. User 101, financial advisor 103, and server 105 may each also reside within a LAN, which interfaces to communication channels 115 117, and 119 via a leased line (e.g., T1, D3, and/or the like). Such communication methods are well known in the az-t and are covered in a variety of standard texts. See, e.g., Gilbei-t Held, Uride~stayadiyag Data Commuyaicatioras (1996), which is hereby incorporated by reference.

Communication between participants in the system of the present invention is accomplished through any suitable communication channel, such as, for example, a telephone network, public switch telephone network, intranet, Internet, extranet, WAN, LAN, point of interaction device (e.g., point of sale device, personal digital assistant, cellular phone, kiosk temninal, automated teller machine (ATM), and/or the like), online communications, off line communications, wireless communications, satellite communications, and/or the like. The network may also be implemented as other types of networks, such as an interactive television (ITS network. It will appreciated that, for security reasons, any databases, systems, or components of the present invention may consist of any combination of databases or components at a single location or at multiple locations, wherein each database or system includes any of various suitable security features, such as firewalls, access codes, encryption, de-encryption, compression, decompression, and/or the like.
Any databases and any other data storage devices referred to herein may include any type of hardware and/or software device, which is configured to store and maintain card-holder transaction data and any other suitable infomnation. Exemplary devices include any suitable type of database, such as relational, hierarchical, object-oriented, and/or the like.
Common database products that may be used to implement transaction history database 116, databases 110, 112, 122, and any other data storage devices referred to herein include DB2 by IBM (White Plains, N~, any of the database products available from Oracle Corporation (Redwood Shores, CA), Microsoft Access by Microsoft Corporation (Redmond, Washington), or any other database product. Transaction history database 116, databases 110, 112, 122, and any other data storage devices referred to herein may be organized in any suitable manner including as data tables or lookup tables.
Association of certain data may be accomplished through any data association technique known and practiced in the art. For example, the association may be accomplished either manually or automatically. Automatic association techniques may include, for example, a database search, a database merge, GREP, AGREP, SQL, and/or the like. The association step may be accomplished by a database merge function, for example, using a "key field" in each of the manufacturer and retailer data tables. A
"key field"
partitions the database according to the high-level class of objects defined by the key field.
For example, a certain class may be designated as a key field in both the first data table and the second data table, and the two data tables may then be merged on the basis of the class data in the key field. In this embodiment, the data corresponding to the key field in each of the merged data tables is preferably the same. However, data tables having similar, though not identical, data in the key fields may also be merged by using AGREP, for example.
The financial advisor/planner and consumer/client may represent individual people, entities, or businesses. It is further noted that other participants may be involved in some phases of the financial planning process, such as intermediary investment brokers, mutual fund operators, and the like, but these participants are not shown.
Each participant or user of the system of the present invention, including consumers, financial advisors, and/or the like, for example, may be equipped with a suitable computing system to facilitate communications and transactions with any other participant. For example, some or all participants may have access to a computing unit in the form of a personal computer, although other types of computing units may be used, including laptops, notebooks, handheld computers (e.g., a Palm Pilot~), set-top boxes, kiosk teuminals, personal digital assistants, cellular phones, and the like. Additionally, other participants may have computing systems which may be implemented in the form of a computer server, PC
server, workstation, minicomputer, mainframe, a networked set of computers, or any other suitable implementations which are known in the aa-t or may hereafter be devised. A
participant's computing system may include any suitable operating system, such as any version of Windows, Windows NT, Windows 2000, Windows 98, Windows 95, MacOS, OS/2, BeOS, Linux, UNIX, or the like. Further, although the invention may be described herein as being implemented with TCP/IP communications protocols, it will be readily understood that the invention could also be implemented using IPX, Appletalk, IP-6, NetBIOS, OSI, or any number of existing or future protocols. Moreover, the system contemplates the use, sale, or distribution of any goods, services, or information over any network having functionality similar to that described herein.
The computing systems may be connected with each other via a data communications network or communication channel. For example, the network may be a public network, which is assumed to be insecure and open to eavesdroppers. In one embodiment, the network is embodied as the Internet. In this context, the computers may or may not be connected to the Internet at all times. For instance, a participant's computer may employ a modem to occasionally connect to the Internet, whereas a financial advisor computing system, and/or another computing system might maintain a permanent connection to the Internet. Specific information related to the protocols, standards, and application software used associated with the Internet are not discussed herein. For further information regarding such details, see, for example, Dilip Naik, Internet Standards and Protocols (1998); Java 2 Complete, various authors (Sybex 1999); Deborah Ray and Eric Ray, Mastering HTML 4. D (1997); and Loshin, TCPlIP Clearly Explained (1997). Each of these texts is hereby incorporated by refer ence.
As will be appreciated, the present invention may be embodied as a method, a data processing system, a device for data processing, and/or a computer program product.
Accordingly, aspects of the present invention may take the form of an entirely software embodiment, an entirely hardware embodiment, or an embodiment combining aspects of both software and hardware. Furthermore, the present invention may take the form of a computer program product on a computer-readable storage medium having computer-readable program code means embodied in the storage medium. Any suitable computer-readable storage medium may be used, including hard disks, CD-ROM, optical storage devices, magnetic storage devices, and/or the like.
The present invention may be described with reference to screen shots (such as input screen shots and output screen shots, for example), block diagrams, and flowchart illustrations of methods, apparatus (e.g., systems), and computer program products according to various aspects of the invention. It will be understood that each screen shot, functional block of the block diagrams and the flowchart illustrations, and combinations of functional blocks in the block diagrams and flowchart illustrations, respectively, can be implemented by computer program instructions. These computer program instructions may be loaded onto a general purpose computer, special purpose computer, or other programmable data processing apparatus to produce a machine, such that the instructions which execute on the computer or other programmable data processing apparatus create means for implementing the functions specified in the flowchart block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart block or blocks. The computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be per formed on the computer or other programmable apparatus to produce a computer-implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart block or blocks.
Accordingly, functional blocks of the block diagrams and flowchart illustrations support combinations of means for performing the specified functions, combinations of steps for performing the specified functions, and program instruction means for perfomning the specified functions. It will also be understood that each functional block of the block diagrams and flowchart illustrations, and combinations of functional blocks in the block diagrams and flowchaut illustrations, can be implemented by either special propose hardwar e-based computer systems which perform the specified functions or steps, or suitable combinations of special purpose hardware and computer instructions.
In the foregoing specification, the invention has been described with reference to specific embodiments. However, it will be appreciated that various modifications and changes can be made without departing from the scope of the present invention.
The specification and figur es ar a to be regar ded in an illustrative manner, r ather than a r estrictive one, and all such modifications are intended to be included within the scope of present invention.
Benefits, other advantages, and solutions to problems have been described above with regard to specific embodiments. However, the benefits, advantages, solutions to problems, and any elements) that may cause any benefit, advantage, or solution to occur or become more pronounced are not to be construed as critical, required, or essential features or elements. As used herein, the terms "comprises", "comprising", "including", or any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Further, no element described herein is required for the practice of the invention unless expressly described as "essential" or "
critical".

APPENDIX A
Title: Model Portfolios -Determining Current and Model allocations for Simulation and Reconciles One process for the life policy allocations is outlined below.
Summary:
The system 100 will base the clients' probability of success on their investment strategy. In the cmTent scenario, that investment strategy will be the same as the clients' cmTent strategy.
In the proposed scenario, the system 100 will integrate the:
~ Clients' risk tolerance ~ Timing of the clients' goals ~ Value of the goals ~ Value of the clients' assets and contributions into customized, proposed investment strategies. These investment strategies will be based on model-allocation strategies.
The model allocations will give the percentage of the portfolio invested in cash equivalents, fixed income, and equity-.
The model allocations will be appropriate for the type of investment account;
therefore there will be three types of model allocations:
The Model Portfolio engine determines the allocation strategies by considering the timing of the clients' goals, the amount of the clients' goals, and the clients' risk tolerance. The allocation strategies consist of five (5) portfolios:
~ Regular assets: which provide the Cash/Fixed/Equity mix for the taxable assets.
~ Regular contributions: which provide the Cash/Fixed/Equity mix for ongoing contributions (savings) to taxable accounts.
~ Retirement assets and contributions: which provide the Cash/Fixed/Equity mix for retirement plan and other tax-defeiTed assets and ongoing contributions (savings).
VUL insurance cash values and premiums for those policies used to fund goals:
which provide the Cash/Fixed/Equity mix for life policy cash values and ongoing pr emiums.
~ VUL insurance cash values and premiums for those not policies used to fund goals:
which provide the CashlFixed/Equity mix for life policy cash values and ongoing premiums. (We do this now, we will just adjust it slightly.) These distinct portfolios allow the system 100 to distinguish between assets and contributions desired to meet short-team goals and assets and contributions desired for long-term goals. In this manner the model allocation balances the shoat-term risks in the market with long-term return potential.
The system 100 assumes that consumers will spend their regular assets first in order to fund their goals and that these assets represent what they have accumulated so far to realize goals.
The next assumption is that savings represent funds that are available to be allocated for goals down the road. Next, whole and universal life policy cash values and premiums will APPENDIX A
be available after savings are depleted. Then VLTL policy cash values and premiums will be available after whole and universal life polices are depleted. The final assumption is that consumers will spend their tax-deferred retirement assets last, in order to leverage the advantages of tax-defelT ed gr owth.
High-level walk through of the calculations:
1. Determine the clients' risk_tolerance.
2. Determine when, on average, the clients' goals occur in the short term (within 10 years). This is called the short-term_timeframe.
3. Determine when assets will be desired to fiend retirement spending. This is based on the time until the fir st retie ement date. This is called the long-term timefr ame.
Model allocation mapuin~
4. Use the timeframes and risk tolerance to map to short-term_allocation and long-term_allocation allocation strategies for regular assets and contributions and VUTL
cash values and premiums.
a. Short-term_allocation allocation - based on short-term_timefi ame and r isk_tolerance b. Long-term_allocation allocation-based on long-term_timeframe and risk_tolerance

5. Retirement Contributions & Asset Allocation-based on first retirement date and risk tolerance - no further steps ar a needed.
Amount of regular assets invested in the short-term and long,-term allocations

6. The next step is to determine the amount of regular assets that should be invested in the short-tenn_allocation.
a. Divide the dollar value of all goals occmTing within ten years by the value of the regular assets. The result is the percentage of regular assets to invest in the short-term assets allocation.
i. If this value is less than 100%, the clients have more assets that are desired to fund these goals, so pant of the assets will be invested shoit-term. The remaining assets will be invested in the long-term_allocation to fund the goals after 10 years.
ii. If this value is greater than 100%, the clients do not have enough assets to fund these goals, the shortage will be funded out of their on-going contributions and tax-defeiTed assets.

7. Determine the amount of regular assets that should be invested in the long-term_allocation.
a. If the percentage above is less than 100%, then subtract that value fi om 100%. This is the percentage of regular assets invested in the long teirn allocation.

APPENDIX A
b. If the percentage is greater than or equal to 100%, then no regular assets are invested in the long-term_allocation. So the percentage of regular assets invested in the long term_allocation = 0%

8. Finally the shout- and long-term assets allocations are combined into one allocation:
the regular assets allocation.
Amount of regular contributions invested in the short-temp and long-term allocations

9. Next, determine the amount of regular contributions that should be invested in the short- and long-term allocations.
a. This calculation is made by subtracting the clients' regular assets from the value of the goals occurring within 10 years. This result is the value of the goals that is covered by the clients' regular assets - any shortage may be funded from regular contributions first then life policies.
i. If this value is greater than $0 then the asset base covers the goals, and no regular contributions are allocated to the short-term allocation.
1. All regular contributions will be invested in the long-term_allocation to fund the goals after 10 years.
2. All VUL cash values and premiums will be invested in the long-term_allocation to fund the goals after 10 years. Proceed to step ?
ii. If this value is less than $0, then there is a shortage of assets that may be funded first from regular contributions then life policies.
1. The shortage is divided by the present value of the regular contributions. This result is the percentage of regular contributions to allocate to the short-temp allocation.
a. If the value is less than 100%, the clients have more regular contributions than are desired to fund these goals.
i. So part ofthe regular contributions will be invested in the short-term_allocation. The remaining regular contributions will be invested in the long-term regular contributions/UL
premiums allocation to fund the goals after 10 years.
ii. No VUL cash values or premiums will be needed to fund these goals so all VUL cash values and premiums will be invested in the long-term_allocation to fund the goals after 10 years. Proceed to step ?
b. If the value is gr eater than 100%, then all regular contributions ar a invested in the short-tem allocation.

10. The next step is to combine the shoat-term and long-term regular contributions allocations into one allocation: the regular contributions allocation.

APPENDIX A
Amount of VUL cash values and premiums invested in the shout-term and long-term_allo cations

11. Next, detemnine the amount of VUL cash values and premiums that should be invested in the shoat- and long-term_allocations.
a. This calculation is made by subtracting the clients' regular assets, savings, whole life and UL cash values and pr emiums fr om the value of the goals occurring within 10 years. This result is the value of the goals that is covered by those assets/policies and savings/premiumns clients' - any remaining shortage may be funded from the VLTL cash values and premiums.
i. If this value is greater than $0 then no VUL cash values and premiums are allocated to the short-term allocation.
1. All VUL cash values and premiums will be invested in the long-teum_allocation to fund the goals after 10 years.
ii. If this value is less than $0, then there is a shortage of assets that may be funded from VLTL cash values and premiums.
1. The shortage is divided by the present value of the VUL cash values and premiums. This result is the percentage of regular contributions to allocate to the short-temp allocation.
a. If the value is less than 100%, the clients have more regular contributions than are desired to fund these goals.
i. So pant of the regular contributions will be invested in the short-term_allocation. The remaining regular contributions will be invested in the long-term regular contributions/UL premiums allocation to fund the goals after 10 years.
ii. No VUL cash values or premiums will be needed to fund these goals so all VUL cash values and premiums will be invested in the long-term allocation to fund the goals after 10 years. Proceed to step ?
b. If the value is greater than 100%, then all regular contributions are invested in the short-tem allocation.

12. The next step is to combine the shoat-term and long-term regular contributions allocations into one allocation: the regular contributions allocation.
In this way, a customized, allocation strategy is generated. The asset retm-ns used in the simulation are based on the clients' cuiTent allocation strategy (for the current scenario) and the proposed model allocation strategy (for the proposed scenario). Therefore, the system 100 can show how the clients' current allocation strategy, their risk tolerance and our investment advice contribute to the clients' ability to reach their goals.
The proposed model allocation strategy is dynamically updated as the user makes changes to:
~ The amounts or timing of the goals;
~ Proposed contribution amounts;
~ Mixtur a of regular versus retirement assets;
~ Cash value policies or ~ The clients' risk tolerance.

APPENDIX A
The propose here is to document two things:
1. How the system determines the Current Allocations that are used for simulating the current scenario.
2. How the system chooses the correct Proposed Model Allocations that are used for simulating the proposed scenario and in the Reconciler.
Details I. Determining account assets in each portfolio tyae 1. Account types: Each account's assets/cash values and contributions/premiums will fall into one of six types:
1. Regular assets 2. Retie ement 3. Whole/UL_ goals: all of the universal_life~olicies and whole_life~olicies owned by client_l, client_2, or community; and whose 'available to fund goals' indicator is on/yes.
4. Whole/LTL_not: all of the universal_life_policies and whole_life~olicies owned by client l, client_2, or community; and whose 'available to fund goals' indicator is off/no.
5. VUL_goals: all of the VUL~olicies owned by client_l, client_2, or community; and whose 'available to fund goals' indicator is on/yes.
6. VLTL_not: all of the VUL-policies owned by client 1, client_2, or community; and whose 'available to fund goals' indicator is off/no.
II Cost of Insurance and cost-of insurance growth rates See cash value in simulation section for details on how to yet cost of insurance data.
Listed below ar a the variable names for calculations used later .
A. COI client 1: cost of insurance for client 1 B. COI client 2: cost of insurance for client 2 C. COI other: cost of insurance for other D. COI_growth_client_1: annual growth rate on the cost of insurance for client 1 E. COI_growth_client_2: annual growth rate on the cost of insurance for client 2 F. COI_growth_other: annual growth rate on the cost of insurance for other APPENDIX A
III. Determining each portfolio's desired value Each portfolio will have a total asset_balance based on the value of the accounts/policies in that portfolio. The asset_balance may be different in the_cmTent and the_proposed scenarios because of Movement between regular assets and variable annuity~olicies;
Contribution amounts increasing or decreasing.
Premium amounts increasing.
Therefore the asset_balances will have to be recalculated as changes are made in the~roposed. The asset balances are calculated as follows:
1. The- cuiTent scenarios a. Current regular_assets_balance: sum of all regular_asset_values in the_curr ent b. Current- regular_contributions_balance: sum of annual contributions- to regular assets in the current c. Cure ent- r etirement_balance: sum of asset_values in all Retirement_accounts in the_cuiTent d. Current-retirement_contributions_balance: sum of -contributions- in all retie ement accounts in the cmT ent.
e. Whole/UL_ goals_cash_value_balance client_1: sum of all cash_values in whole/UL_goals where client_1 is the insured, in the_cmTent f. Whole/LJL_ goals_cash_value_balance_client_2: sum of all cash_values in whole/LJL-goals where client_2 is the insured, in the_cmTent g. Whole/LTL_ goals cash_value_balance_other: sum of all cash_values in whole/UL_goals owned by client_l, client_2, or community, where the insur ed is other in the current h. Whole/UL_ goals_premiums balance client_1: sum of all premiums in whole/LJL-goals where client_l is the insured, in the cuiTent i. Whole/LTL_ goals~remiums_balance client_2: sum of all premiums in whole/LJL_goals where client_2 is the insured, in the_current j. Whole/UL_ goals_premiums balance_other: sum of all premiums in whole/UL_goals owned by client_l, client_2, or community, where the insured is other in the current k. VLJL goals_cash_value_balance client_1: sum of all cash_values in VUL_goals where client_1 is the insured, in the_current 1. VULJ_goals cash_value_balance client_2: sum of all cash_values in W L goals when a client 2 is the insur ed, in the cmT ent APPENDIX A
m. VUL_goals cash_value_balance_other: sum of all cash_values in VUL_goals owned by client_l, client_2, or community, where the insured is other in the cuiT ent n. VUL_goals_premiums_balance_client_1: sum of all premiums in VUL_goals where client_1 is the insured, in the_cmTent o. VLTL_goals~remiums_balance_client_2: sum of all premiums in VUL_goals where client_1 is the insur ed, in the_cmT ent p. VUL_goals~remiums_balance other: sum of all premiums in VUL_goals owned by client_l, client_2, or community, where the insured is other in the cuiT ent q. VUL not_cash_value_balance: sum of all cash_values in VUL_not where the owner is client 1, client_2, or community, in the_current r. VUL_not~remiums_balance: sum of all premiums in VITL_not where the owner is client l, client 2, or community, in the current Policy_goals balance: sum of all cash_values in whole/UL_goals +
cash values in VUL goals 2. The-proposed scenarios a. Proposed_regular assets_balance: sum of all regular asset values in the~roposed b. Proposed- regular_contributions_balance: sum of annual contributions- to regul'ar_assets in the~roposed c. Proposed- retirement balance: sum of asset_values in all Retirement_accounts in the~roposed d. Proposed- retirement_contributions_balance: sum of contributions- in all retirement accounts in the_proposed e. Whole/UL_ goals cash value balance client_l: sum of all cash_values in whole/UL_goals where client_1 is the insured, in the-proposed f. Whole/LJL_ goals_cash_value_balance_client_2: sum of all cash_values in whole/LJL_goals where client_2 is the insured, in the-proposed g. WholelLTL_ goals cash_value_balance_other: sum of all cash_values in whole/LTL_goals owned by client_l, client_2, or community, where the insured is other in the_proposed h. Whole/LJL_ goals~remiums_balance client_l : sum of all premiums in whole/UL_goals where client_1 is the insured, in the_proposed i. Whole/UL_ goals_premiums_balance client_2: sum of all premiums in whole/UL_goals where client_2 is the insured, in the_proposed j. Whole/UL_ goals-premiums balance_other: sum of all premiums in whole/LJL_goals owned by client_l, client 2, or community, where the insured is other in the~roposed APPENDIX A
k. VUL_goals cash_value_balance client_l: sum of all cash_values in VUL_goals where client_1 is the insured, in the~roposed 1. VUL_goals_cash_value_balance client_2: sum of all cash_values in VUL_goals where client_2 is the insured, in the~roposed m. VUL_goals cash_value_balance other: sum of all cash_values in VUL_goals owned by client_l, client_2, or community, where the insured is other in the_proposed n. VUL_goals~remiums_balance_client_l: sum of all premiums in VUL_goals where client_1 is the insured, in the_proposed o. VUL_goals_premiums balance client 2: sum of all premiums in VUL goals where client_1 is the insured, in the~roposed p. VUL_goals_premiums_balance other: sum of all premiums in VLTL_goals owned by client_l, client_2, or community, where the insured is other in the~roposed q. VUL not_cash_value_balance: sum of all cash_values in VLTL not where the owner is client_l, client_2, or community, in the~roposed r. VUL not_premiums_balance: sum of all premiums in VUL_not when a the owner is client_l, client 2, or community, in the~roposed Simulation allocations for the current IV. Re".~~assets A. Current_regular_assets cash_% = sum of all holdings in the current with a simulation level_asset_class of cash equivalents and the 5% of all _balanced_ holdings in regular assets /current regular_assets balance B. Current_regular_assets_fixed_% = sum of all holdings in the_current with a simulation level_asset_class of fixed_income and the 30% of all _balanced_ holdings in regular assets /current regular_assets_balance C. Current_regular_assets_equity % = sum of all holdinbs in the_current with a simulation level_asset class of equity_ and the 65% of all _balanced_ holdings in regular assets /current regular assets balance V. Regular contributions A. Current regular_contributions cash-% = same as current_regular_assets cash B. Current_regular_contributions_fixed_% = same as current regular assets fixed_%
C. Current regular_contributions equity_% = same as current regular assets equity_%

APPENDIX A
VI. Whole/LJL goals - allocation is always 100% fixed A. Current whole/UL_ goals cash_% = 0%
B. Current whole/UL_ goals fixed % =100%
C. Curr ent whole/UL- goals equity_% = 0 %
VII. VULs og als (cash values & premiums) A. Current_VLTL_ goals_cash_% = sum of all holdings in the_current with a simulation level_asset class of cash_equivalents and the 5% of all _balanced_ holdings in YCTL goals /current_VIJL-goals cash value balance B. Current_YfJL_ goals fixed_% % = sum of all holdings in the current with a simulation level_asset_class of fixed income and the 30% of all_balanced_ holdings in VCTL_goals /current WL_goals cash_value_balance C. Current_VITL_ goals-equity_%_% = sum of all holdings in the_current with a simulation_level_asset class of equity and the 65% of all _balanced_ holdings in YUL_goals /current VIJL_goals cash value balance VIII. Retirement (assets and contributions) A. Current_retirement cash % = sum of all holdings with a simulation level_asset class of cash equivalents and 5% of all _balanced_ holdings in all retirement accounts in the current B. Cur rent_retirement fixed % = sum of all holdings with a simulation level_asset_class of fixed_income and 30% of all _balanced_ holdings in all retirement_accounts in the current C. Current_retirement equity_% = sum of all holdings with a simulation _level_asset class of equity_ and 65% of all _balanced_ holdings in all retirement accounts in the current Simulation allocations for the proposed If the risk_tolerance is " current_", then all of the simulation allocations used in the_current will be used in the~roposed and the following steps are not necessary.
I. Regular Assets Simulation Allocation Determination There are five _timeframes_ used:
0 to 3 Years from non-retirement goal 4 to 7 Years from non-retirement goal 8 to 15 Years fi~om non-retirement goal 16 or More Years from non-retir ement or 3+ year s away from retirement 2 year s or les s fr om retir ement APPENDIX A
The inflation factor is: 3%
The discount rate is: 7%
The regular assets and contributions and the WL cash values and premium proposed allocations are a combination of a shoat-term allocation and a long-term allocation.
A) To detemnine the long-temn_timeframe & long-temn_allocations 1. If the retirement_starting-period is in _periods 0 or 1, then the timeframe is '2 years or less from retirement'. If the retirement_starting-period is after period_ 2, then the timeframe is 16+ years.
2. This gives you the long-term_timeframe for the proposed regular asset allocation, proposed regular contribution_allocation, and proposed_VLTL_goals_allocation.
3. Determine the regular_assets long-term_allocation - Use the risk_tolerance and the long-teim_timefr ame to map to the C/F/E mix in the regular_assets allocation_table.
4. Determine the regular_contributions_long-term_allocation - Use the risk_tolerance and the long-term_timeframe to map to the C/F/E mix in the regular_contributions allocation_table.
5. Determine the VUL_goals long-term_allocation - Use the r isk_toler ante and the long-term_timefr ame to map to the C/F/E mix in the VLJL allocation table.
B) To determine the short-term_timeframe and shoe-term allocation (same as Apex) a. If clients have any non-retirement goals occurring in _periods_ 0 to 9, then follow the steps below:
1. Determine goal amounts sum - Sum of all goal amounts and retirement living expenses in the~roposed = (cash reserve_goal +
accumulation goals + education_goals + retirement living expenses) occui~ing in _periods 0 to 9 2. Determine annual goal_amouts_sum= For each _period_ 0 to 9, sum the goal_amounts in that period_ 3. Determine weighted_goals = the multiply each period's_ annual_goal_amounts_sum by (the period it occurs +1).
4. Determine short-term_timeframe = weighted goals divided by the goal amounts sum. This gives you the shoat-temp timeframe for the proposed_regular_asset allocation, proposed_regular-contribution_allocation, and pr opo s ed_VUL_go als_allo cation.
5. Determine the regular_assets short-temp allocation - Use the risk_toler ante and the short-temn_timefr ame to map to the C/F/E mix in the regular assets_allocation table.

APPENDIX A
6. Determine the regular_contributions_short-term_allocation - Use the risk_tolerance and the short-term_timeframe to map to the C/F/E mix in the regular_contributions_allocation_table.
7. Determine the VtTL_goals short-temn_allocation - Use the risk_tolerance and the shoe-term_timeframe to map to the C/F/E mix in the VLTL_goals allocation_table.
b. If clients do not have any non-retirement goals occurring in _periods- 0 to 9, then the short-term timeframe is the same as the long-term timefr ame.
C) Determine the assets_short_term_% - percentage of the regular-assets in the regular_assets_short-term_allocation.
1. assets_shont_term_% = goal amounts sum divided by the regular_assets_balance. Use the lesser of the calculated amount or 100%
D) Determine the assets long temn_% - percentage of regular assets in the long-temn_allocation.
1. assets long term % = 1 minus the assets short term E) Determine the aggregate mix for the proposed regular_assets allocation:
1. Proposed_regular assets-group cash_% _ (assets short term %)(cash % in regular_assets_short-tenn_allocation) + (assets long term_%)(cash % in regular_assets_long-term_allocation) 2. Proposed_regular assets-group-fixed_% _ (assets short term %)(fixed % in regular assets_shont-teum_allocation) + (assets long term_%)(fixed % in regular_assets_long-tenn_allocation) 3. Proposed_regular_assets equity_% _ (assets short term %)(equity % in regular_assets_short-term_allocation) + (assets long term_%)(equity_% in regular assets long-term allocation Example:
accumulation_goal of $20,000 in period 3 education-goal of $10,000 per year for 4 years -beginning in period 7 Retir ement is in 20 Years.
r egular_asset_total = $500,000 risk tolerance = moderate Step 1 -Determine the long-term timeframe and long-teim_allocations:
retirement_sta~-ting-period is in period_ 19.
This indicates We should point to the 8 to 15 year timeframe allocation and the moderate mix.

APPENDIX A
long-term allocation:
In the regular assets allocation table look up the allocation with ~ a 8 to 15 year timeframe; and ~ a risk tolerance of moderate.
~ The appropriate allocation is:
cash_% in regular assets_long-term_allocation = 40%
fixed % in r egular assets long-term_allocation = 25%
equity-% in regular assets_long-term_allocation = 35%
In the regular contributions allocation _table look up the allocation with ~ a 8 to 15 year timefr ame; and ~ a risk tolerance of moderate.
~ The appropriate allocation is:
cash_% in regular contributions_long-term_allocation = 40%
fixed % in regular contributions_long-term_allocation = 25%
equity-% in regular- contributions long-term allocation = 35%
Step 2 - Determine the short-teim_timefi ame and short-term_allocations:
goal amounts sum= $50,000 $20,000 Accum Goal + $30,000 Education Goals = $50,000 annual_goal amouts sum period 3 = $20,000 period 7 = $10,000 period 8 = $10,000 period 9 = $10,000 weighted_goals = $350,000 $20,000 * (3+1) _ $80,000 $lo,ooo * (~+1) _ $so,ooo $10,000 * (8+1) _ $90,000 $10,000 * (9+1) _ $100,000 Total = $350,000 short-temn_timefiame = weighted_goals / goal_amounts_sum = 7 $350,000/50,000 = 7 This indicates that we should point to the 4 to 7 year timefi ame shoat-teim_allocations:
In the regular assets allocation_table look up the allocation with ~ a 4 to 7 year timeframe; and ~ a risk tolerance of _moderate ~ The appropriate allocation is:
cash_% in regular assets_short-term_allocation = 60%
fixed % in regular assets short-temn_allocation = 20%
equity_% in regular assets_short-term_allocation = 20%
In the regulaa- contributions allocation_table look up the allocation with ~ a 4 to 7 year timefiame; and a risk tolerance of moderate APPENDIX A
~ The appropriate allocation is:
cash_% in regular contr ibutions_shon-teun_allocation = 60%
fixed_% in r egular contributions_shout-term_allocation = 20%
equity-% in regular contributionss short-temp allocation = 20%
Step 3 - Determine the assets short_term_%:
goal_amounts_sum = $50,000 regular-pool = $500,000 assets_shon_temn_% = goal_amounts_sum / regular~ool = 10%
$50,000/$500,000 = 10%
10% of regular_assets should be invested in the regular assets_short-term_allocation (60% Cash/20% Fixed/20% Equity) Step 4 - DeteiTnine the assets long term_%:
assets long term_% = 1 - assets short_term_% = 90%
1 - 10% = 90%.
The remainder, or 90%, of regular_assets should be invested in the regular assets long-term allocation (40% Cash/25% Fixed/35% Equity) Step 5 - Determine the aggregate mix for the regular asset~roposed_allocation:
Cash = (10% * 60%)+ (90% * 40%) = 42%
Fixed = (10% * 20%) + (90% * 25%) = 25%
Equity = (10%* 20%) + (90% * 35%) = 33%
II. Determining the proposed regular contributions allocation A) Determine the contributions_short-term_% - percentage of regular contributions in the short-term allocation.
1. Determine the assets shoutfall - funding desired from regular_contributions =
goal amount sum minus regular assets_balance. Use the greater of 0 or equation result.
a. If assets shortfall is equal to zero, then contributions short_temn % _ 0%, then go to step B below.
b. If assets_shortfall is greater than zero then proceed to Step 2 2. Determine the contributions~ool - total present value of regular_contributions a. Present value regular_contributions = Sum of f regular-contributions *{(1+inflation-factor)~(-period)~/~(1+ discount_rate)~(-period~~
3. contributions_short_temn_% = assets_shortfall divided by contributions~ool Use the lesser of the calculated amount or 100%.
B) Determine the contributions_long-temn_% - percentage of regular_contributions in the regular_contributions_long-temn_allocation.
1. 1 less the contributions short term APPENDIX A
E) Determine the aggregate mix for the proposed regular contributions allocation:
1. Proposed regular_contributions_cash_% _ (contributions_short_temn_%)(cash % in regular_contributions_short-teim_allocation) + (contributions long term_%)(cash % in regular_contributions long-term_allocation) 2. Proposed regular_contributions fixed_% _ (contributions_short_term_%)(fixed % in regular contributions short-temn_allocation) + (contributions long term_%)(fixed % in regular_contributions long-term_allocation) 3. Proposed regular_contributions equity-% _ (contributions_short_temn_%)(equity % in regular_contributions shout-term_allocation) + (contributions long term_%)(equity % in regular contributions long-term allocation) Example:
Accumulation Goal of $20,000 in period 3 Education Goal of $10,000 per year for 4 years -beginning in period 7 Retirement is in 20 Years.
Total Regular Assets of $20,000 Risk Tolerance = Moderate Annual Regular Contributions of $3,000.
Step 1- pool_shortfall goal_amount_sum= $50,000 $20,000 Accum Goal + $30,000 Education Goals = $50,000 regular_assets_balance = $20,000.
assets shortfall = $30,000 $50,000 - $20,000 = $30,000 APPENDIX A
Step Determine the tions~ool 2 periodcontribu - PV of contributions 0 3,000 1 2,871 2 2,747 3 2,629 4 2,516 S 2,407 6 2,304 7 2,204 8 2,110 9 2,019 1,932 11 1,849 12 1,769

13 1,693

14 1,620 1S 1,SS0 16 1,483 17 1,420 18 1,358 19 1,300 Total40, 810 Step 3 - Determine the contributions_short-temn_%
assets_shontfall/ contributions~ool $30,000/$40,810 = 74%
Step 4 -Determine contributions long-term_%
1 less contributions_shont-teim_%
1 - 74% = 26%
Step S - Determine the aggregate mix for the proposed regular contributions allocation:
Cash = (74% * 60%)+ (26% * 40%) = SS%
Fixed = (74% * 20%) + (26% * 2S%) = 21%
Equity = (74%* 20%) + (26% * 3S%) = 24%
IX Determine proposed VUL goals allocation A. Determine the VIJL_goals short-term % - percentage of VUL goals in the VUL goals short-term allocation.
4. Determine the contributions shoutfall - funding desired fiom VUL-goals not covered by assets, savings or whole life and UL policies = assets shortfall APPENDIX A
minus contributions~ool minus whole/UL_pool. Use the greater of 0 or equation r esult.
a. whole/LTL_pool = sum of the proposed_whole/LJL_goals cash_value_balance_client_1 + sum of the present value of ~proposed_ whole/UL_goals_premium_balance client_1 minus [(COI client_1)*(1+COI_growth_client_1)~(-period] / f (1+
discount_rate)~(~eriod~} + sum of the proposed_whole/LTL_goals cash_value_balance_client 2 + sum of the present value of {proposed whole/UL_goals~remium_balance_client_2 minus [(COI client_2)*(1+COI-growth_client_2)~(_period~] / f (1+
discount_rate) -(periods} + sum of the proposed_whole/LJL goals cash value balance other + sum of the present value of ~proposed_ whole/LJL_goals_premium_balance other minus [(COI
other)*(1+COI_growth other)~(_period~] / f (1+ discount_rate) ~(-period} for -periods 0 to retirement_staning-period i. If contributions_shortfall is equal to zero, then VLTL_goals_short_term_% = 0%, then go to step B below.
ii. If contributions_shoutfall is greater than zero, then proceed to Step 2 b. Determine the VUL_goals~ool =
proposed_WL_goals cash_value_balance_client_l + sum of the present value of f proposed_VLTL_goals_premium_balance_client_1 minus [(COI client_1)*(1+COI_growth client l)~(_period~] / (1+ discount_rate)}
+ sum of the proposed WL_goals cash_value_balance_client_2 + sum of the present value of f proposed_VLTL_goals-premium_balance_client_2 minus [(COI_client_2)*(1+COI_growth_client_2)~(_period~] / (1+
discount_rate)} + sum of the proposed_WL_goals cash_value_balance other + sum of the present value of {proposed_VIJL_goals~remium balance_other minus [(COI other)*(1+COI_growth other)~(-period] / (1+ discount_rate)} for periods_ 0 to retirement_starting_period c. WL,_goals_short_term_% = contributions_shortfall divided by VLJL goals_pool Use the lesser of the calculated amount or 100%.
B. Determine the YUL_goals_lon;-term % - percenta;e of VLTL_goals_ in the VIJL goals long-term allocation 1 less the contributions short term C. Determine the aggregate mix for the proposed_VIJL_goals_allocation:
4. Proposed_WL_goals cash_% _ (contributions_short_temn_%)(cash % in VUL goals short-term_allocation) + (contributions long term_%)(cash % in VIJL goals long-term allocation) APPENDIX A
5. Proposed_VUL_goals fixed_% _ (contributions short term %)(fixed % in VUL_goals_short-term_allocation) + (contributions long term_%)(fixed in VUL_goals long-temn_allocation) 6. Proposed_VUL_goals equity % _ (contributions short_temn_%)(equity % in VUL_goals_shont-term_allocation) + (contributions long term_%)(equity_%
in VUL goals long-term allocation) X. Determine proposed~retirementaallocation Retirement assets and contributions are invested identically.
The proposed_retirement_allocation is based on two factors:
Risk Toler ante Time Frame of the Retirement Goal - long-term timeframe To deteiTnine the proposed retirement allocation, use the risk_tolerance and _timeframe- to map to the cash/fixed/equity mix in the retir ement_allocations_table.
Varialbe names are:
A. Proposed retirement cash B. Proposed retirement fixed C. Proposed retirement equity XI. Determine proposed VUL not allocation VUL cash values and premiums are invested identically.
Since the policy is not being used to fund goals, and the policy is a 'permenant' one, we assum it is desired for the 'long-term'. Therefore all of the VUL_not allocations are long-term and the proposed VUL not allocation is based only on the risk tolerance.
A. To determine the proposed VUL_not allocation, for all VUL not policies, use the risk_tolerance to map to the cash/fixed/equity mix in the VUL not allocations table - portfolios.
This is different fi om cmT ent, in that in the current system 100, each VUL_not policy had it's own risk tolerance. Now, all policies will have the same risk tolerance as the client's assets. (All VUL policies are VUL not policies in the the cmTent system 100.) APPENDIX A
IV. Changing the Proposed Allocations as Advisor Works in Analysis Hub The proposed allocations chosen will be displayed in the analysis hub. The mix could change as a result of work done by the advisor in the analysis hub:
The advisor could simply change the risk tolerance by choosing a different one in the analysis hub.
By changing the amount an accumulation or education goal is funded or by changing the retirement date of the client, the weighted average time flame of the goals will change. This may result in a different allocation.
XII. Composite Mixes Calculation of the composite cash/fixed/eduity mixs for use in tables and pie charts on the Mass and in the system 100.
A. All_composite_mix - appears in Model Portfolio and Goals screens in Analyze and used for Smart Advice rules. (new calculation) B. Regular/policy goals composite_mix - appears in Other Investments pies and tables, and used to generate expected return and chance of loss statistics, and for Smart Advice rules.
C. Policy_goals composite_mix - appears in Survivor output and is used for Smart Advice rules The composite_mixes are weighted averages of the regular assets, the VUL
goals, whole/Ul goals, and the retir ement allocations. The composite_mixes ar a calculated as follows:
Desire new composites:
1. Regular/policy-goals 2. Policy-goals X policymgoals_composite mix - X = the_cmTent or the_proposed 1) Calculate X_VULJgoals_weighting as follows: (X VUL_goals balance client l +
X_VUL_goals balance_client_2 + X_VUL-goals_balance_other) divided by X_policy_goals balance a) Determine the X_VL1L ~oalsgweighted_cash % b~pl~g the X VUL~goals wei htin~ with the X VUL goals cash %.
b) Detemnine the X VUL goals weighted fixed % b~multipl~in~the X_VUL_~oals weighting with the X VUL foals fixed %.
c) Detemnine the X VUL goals weighted eduity % by multiplyy X VUL~oals weighting with the X VUL foals eauit~.

APPENDIX A
2) Calculate X_whole/UL_goals_weighting as follows:
(X whole/UL goals balance client_l + X_ whole/UL_goals_balance client_2 +
X_whole/UL goals balance other) divided by X~olicy-goals balance a) Determine the whole/UL weighted fixed % by multiplying the whole/LTL weighting with the whole/LTL ,gioup fixed %.
3) Detei~nine the X-policy_goals_composite_mix_cash_% _ X_VLTL_goals_weighted_cash_%
4) Detemnine the X~olicy_goals_composite_mix_fixed_% by summing the X_WL_goals_ axed_% and whole/UL_group- fixed_%.
5) Determine the X~olicy_goals_composite_mix_equity-% _ X VIIL goals weighted equity_%
X re ug larlpolicy~goals composite mix - X = the_current or the-proposed 6) Calculate X_regular assets_weighting as follows: X_regular assets_balance divided by (X regular assets balance + X~olicy-goals balance) a) Determine the X regular assets weighted cash % b~ltiplyin~ the X regular assets wei~;htin~ with the X regular assets cash %.
b) Determine the X_regular assets weighted fixed % b~pl in~g the X_re~ular_assets_wei~htin~ with the X regular assets fixed %.
c) Determine the X Regular assets weighted equit~~pl in~g the X regular assets weighting with the X regular assets eguity %.
7) Calculate X~olicy~oals_weighting as follows: X-policy-goals_balance divided by (X regular assets_balance + X~olicy-goals balance) a) Determine the X~olicy goals weighted cash % b~pl in~g the X~olicy, goals weighting with the X policy~oals composite mix cash %.
b) Determine the X~olicy goals wei hued axed % b~plyin~ the X~olicX eoals weighting; with the X uolicX goals composite mix fixed %.
c) Determine the X~olicy goals weighted equit~y multipl in~g the X~olicy~oals weighting with the X~olic~g-pals, composite mix equity.
Detemnine the X_regular/policy_goals composite mix cash % = by summing the X_regular_assets_weighted_cash_% With the X-policy-goals weighted cash 9) Determine the X_ regular/policy-goals composite mix fixed % by summing the X_regular_assets_weighted_fixed_% and X-policy-goals weighted fixed %.
10) Determine the X_ regular/policy-goals composite_mix_equity-% = by summing the X regular assets_weighted_ equity-% and X~olicy_goals_weighted equity_%.
X all composite mix - X = the current or the_proposed APPENDIX A
11) Calculate X_ regular/policy-goals weighting as follows;
(X regular assets_balance + X~olicy-goals balance) divided by (X regular assets_balance + X~olicy_goals balance+X retirement balance) a) Detemnine the X re u~ lar/policy goals weighted cash % by multiulyin~ the X regulai/policy goals weighting with the X regular/policy goals composite mix cash %.
b) Determine the X re ug lar/policy goals weighted fixed % by multiulyin~
the X re ug lar/policy~oals weighting with the X re u~ lar/polic~goals composite mix fixed %.
c) Determine the X_regular/policy goals wei hued equity % by multipl~ng the X reg~ulax/policy goals weighting with the X re~ular/policy goals composite mix equity %.
12) Calculate the X_retirement weighting as follows:
X_retirement_balance divided by (X regular assets_balance +
X-policy_goals_balance+X retirement balance) a. Detemnine the X_retirement_weighted cash % b~tipl ly'n~ the X retirement weighting with the X retirement cash %.
b. Determine the X_retirement_wei, h~ ted fixed % b~plying the X_r etirement_weightin~ with the X retirement fixed %.
c. Determine the X retirement_weighted equit~y multiplying the X retirement weighting with the X r etir ement equity.
13) Determine the X_all_composite_mix_cash_% = by summing the X regular/policy-goals_weighted_cash_% with the X_retirement_weighted_cash 14) Detemnine the X_all_composite_mix_fixed_% by summing the X
X_regular/policy_goals_weighted fixed_% and X_retirement_weighted_fixed_%.

15) Determine the X_all_composite_mix_equity-% = by summing the X_regular/policy-goals_weighted_equity-% and X_retirement_weighted_ equity_%.
To alTive at the current ** composite mix, use the asset balances from the cmTent.
To arrive at the-proposed_**_composite mix, use the asset_balances fiomthe~roposed.
If the advisor uses the 'Moved to TDA" option in Analyze, they would reduce the value of the regular asset_balance and increase the value of the retirement_balance so the weightings_ would be desired to be recalculated for the~roposed.
II. Chance of lose and expected return statistics Since the life policies used to fund goals will be included with regular assets in the Other Investments output tables and pie charts, the expected return and chance of loss statistics desired to be based on that combined allocation - specifically the X regular/policy-goals composite mix APPENDIX A
Outstanding Issues:
ALLOCATION TABLES - on next page APPENDIX A
Regulaa-assets allocation table Moderately Moderately Time Risk Conservative Moderate Ag~.essive Frame Tolerance Conservative A gressive 0 to Cash 100% 80% 60% 40% 25%
3 Years from Fixed 0% 20% 40% 60% 75%

AccumltnInternational Fxd Inc Goal ~
yield Long>Interm 10% 15% 25%

Short 20% 30% 45% 50%

Equity 0% 0% 0% 0% 0%

International Stocks Lar a Ca Stocks Mid/Small Cap Stocks 4 to Gash 25% 10% 8% 5% 0%
7 Years from Fixed 60% 65% 57% 45% 35%

Accumultn~temational 5% 6%
Fxd Inc Goal ~ 7% 6% 4%
yield Long/Interm 25% 18% 15% 12% 9%

Short 35% 35% 30% 29% 26%

Equity 15% 25% 35% 50% 65%

International 5% 7% 10% 12%
Stocks Lar 15% 20% 28% 35% 46%
a Ca Stocks Mid/Small 5% 7%
Cap Stocks 8 to Cash 8% 5% 0% 0% 0%
15 ~
Years from Fixed 57% 45% 35% 20% 0%

Accumultn~ternational 6%
Fxd Inc Goal ~~ 6% 4%
yield Lon 15% 12% 9% 8%
Interm Short 30% 29% 26% 12%

Equity 35% 50% 65% 80% 100%

International 9% 12% 16% 20% 25%
Stocks Lar 19% 28% 37% 44% 55%
a Ca Stocks Mid/Small 7% 10% 12% 16% 20%
Ca Stocks

16 or Cash 5% 0% 0% 0% 0%
More Years/3_ 45% 35% 20% 10% 0%
or Fixed more ~ternational years Fxd Inc from High 4%
Yield retirementLong/Intermediate 12% 9% 8% 10%
Bond Short 29% 26% 12%

Equity 50% 65% 80% 90% 100%

International12% 16% 20.% 23% 25%
Stocks Large Ca Stocks30% 37% 44% 50% 55%

Mid/Small 8% 12% 16% 17% 20%
Cap Stocks RetirementCash 15% 15% 10% 10% 10%

Income:Feed 50% 35% 25% 15% 0%
Use beginning ~ternational 6%
two Fxd Inc years Hid Yield 6% 4%
from retirement Lon Interm 15% 12% 9% 7%

Short 23% 19% 16% 8%

Equity 35% 50% 65% 75% 90%

International 7% 10% 16% 18% 23%
Stocks Lar 23% 32% 37% 43% 50%
a Ca Stocks Mid/Small 5% 8% 12% 14% 17%
Cap Stocks SS

APPENDIX A
Regular contributions allocation table TiineFrame Risk ToleranceConservativeModeratelyModerateModeratelyAggressive Conservative Aggressive 0 to 3 Cash 100% 80% 60% 40% 25%
Years fromAccumltnFled 0% 20% 40% 60% 75%
G
l oa International Fxd Inc High Yield 0%

Long/Interm 10% 15% 25%

Short 20% 30% 45% 50%

Equity 0% 0% 0% 0% 0%

International Stocks Large Cap Stocks Mid/Small Cap Stocks 4 to 7 Cash 15% 0% 0% 0% 0%
Years fromAccumultnFled 70% ~~ 75% 65% 50% 35%

Goal International 5% 6%
Fxd Inc High Yield 5% 10% 9% 5%

Long~Interm 30% 25% 20% 15% 9%

Short 35% 35% 30% 30% 26%

Equity 15% 25% 35% 50% 65%

International 5% 7% 10% 12%
Stocks Large Cap 15% 20% 28% 35% 46%
Stocks Mid/Small 5% 7%
Cap Stocks 8 to 15 Casli 0% 0% 0% 0% 0%
Years fromAccumultnFled 65% 50% 35% 20% 0%
G
l oa International6%
Fxd Inc High Yield 9% 5%

Long/Interm 20% 15% 9% 8%

Sliort 30% 30% 26% 12%

Equity 35% 50% 65% 80% 100%

International9% 12% 16% 20% 25%
Stocks Large Cap 19% 28% 37% 44% 55%
Stocks Mid/Small 7% 10% 12% 16% 20%
Cap Stocks 16 or Casli 0% 0% 0% 0% 0%
More Yearsl3 Fled 50% 35% 20% 10% 0%
or more years International from Fxd Inc ti t re High Yield 5%
remen Long>Interm 15% 9% 8% 10%

Sliort 30% 26% 12%

Equity 50% 65% 80% 90% 100%

International12% ' 16% 20% 23% 25%
Stocks Large Cap 28% 37% 44% 50% 55%
Stocks Mid/Small 10% 12% 16% 17% 20%
Cap Stocks APPENDIX A
Regular contributions allocation table Moderately Moderately Time Frame Risk ToleranceConservativeConservativeModerateAg~.essivep'g~'essive RetirementCash 15% 15% 10% 10% 10%

Income: Feed 50% 35% 25% 15% 0%
Use b i i t eg nn International6%
wo Fxd Inc ng years from retirement ugh field 6% 4%

Long/Interm 15% 12% 9% 7%

Short 23% 19% 16% 8%

Equity 35% 50% 65% 75% 90%

International7% 10% 16% 18% 23%
Stocks Large Cap 23% 32% 37% 43% 50%
Stocks Mid/Small 5% 8% 12% 14% 17%
Cap Stocks $7 APPENDIX A
VLTL goalsocation all table Time Frame Risk ToleranceConservativeModeratelyModerateMgt latelyAggressive Conservative A essive 0 to 3 Cash 100% 80% 60% 40% 25%
Years from Accumltn Goal Fixed 0% 20% 40% 60% 75%

I nternational Fxd Inc High Yield 0%

Long/Interm 10% 15% 25%

Principal 20% 30% 4s% so%
Pr eservation Short Equity 0% 0% 0% 0% 0%

International Stocks Large Cap Stocks Mid/Small Cap Stocks 4 to 7 Cash 15% 0% 0% 0% 0%
Years fr om Accumultn Goal Fixed 70% 75% 65% 50% 35%

International 5% 6%
Fxd Inc High Yield 5% 10% 9% 5%

LonglInterm 30% 25% 20% 15% 9%

Principal 35% 35% 30% 30% 26%
PTeSeTVatlOn Short Equity 15% 25% 35% 50% 65%

International 5% 7% 10% 12%
Stocks Large Cap 15% 20% 28% 35% 46%
Stocks Mid/Small 5% 7%
Cap Stocks 8 to 15 Cash 0% 0% 0% 0% 0%
Years from Accumultn Goal Fixed 65% 50% 35% 20% 0%

International6%
Fxd Inc High Yield 9% 5%

LongIInterm 20% 15% 9% 8%

PrlnClpal 30% 30% 26% 12%
Preservation Short Equity 35% 50% 65% 80% 100%

International9% 12% 16% 20% 25%
Stocks Large Cap 19% 28% 37% 44% 55%
Stocks Mid/Small 7% 10% 12% 16% 20%
Cap Stocks 5g APPENDIX A
VUL goalslocation al table Moderately Moderately Time Frame Risk ToleranceConservativeConservativeModerateAggressiveAg~'essive 16 or Cash 0% 0% 0% 0% 0%
More Years/3 or more years from retirement Fixed 50% 35% 20% 10% 0%

International Fxd Inc High Yield 5%

Long/Interm 15% 9% 8% 10%

Principal 30% 26% 12%
Preservation Short Equity 50% 65% 80% 90% 100%

International12% 16% 20% 23% 25%
Stocks Large Cap 28% 37% 44% 50% 55%
Stocks Mid/Small 10% 12% 16% 17% 20%
Cap Stocks RetirementCash 15% 15% 10% 10% 10%
Income:
Use begim~ing two years from retirement Fixed 50% 35% 25% 15% 0%

International6%
Fxd Inc High Yield 6% 4%

Long/Interm 15% 12% 9% 7%

PTlnCl~a1 23% 19% 16% 8%
Pr es er vation Short Equity 35% 50% 65% 75% 90%

International7% 10% 16% 18% 23%
Stocks Large Cap 23% 32% 37% 43% 50%
Stocks Mid/Small 5% 8% 12% 14% 17%
Cap Stocks APPENDIX A
Retirement allocations table Tune Risk ToleranceConservativeModeratelyModerateg~euatelyAgg~.essive Frame Conservative A essive RetirementCash 15% 15% 10% 10% 10%

Income: Fixed 50% 35% 25% 15% 0%
Use begimting International6%
two Fxd Inc years ~~ yield 6% 4%
from ti t re Long/Interm 15% 12% 9% 7%
e emen Principal 23% 19% 16% 8%
Preservation Short Equity 35% 50% 65% 75% 90%

International7% 10% 16% 18% 23%
Stocks Large Cap 23% 32% 37% 43% 50%
Stocks Mid/Small 5% 8% 12% 14% 17%
Cap Stocks 3 or Cash 0% 0% 0% 0% 0%
more ~~

years Feed 50% 35% 20% 10% 0%
from retirement International Fxd Inc High Yield 4%

Long/Interm 12% 9% 8% 10%

Principal 34% 26% 12%
Preservation Short Equity 50% 65% 80% 90% 100%

International12% 16% 20% 23% 25%
Stocks Large Cap 28% 37% 44% 50% 55%
Stocks Mid/Small 10% 12% 16% 17% 20%
Cap Stocks APPENDIX A
VLTL
not allocations table Risk ToleranceConservativeModeratelyModerateMg~ ratelyAg~.essive Conservative A essive Cash 0% 0% 0% 0% 0%

Fixed 50% 35% 20% 10% 0%

International Fxd Inc High Yield 4%

Long/Inteim 12% 9% 8% 10%

Principal Preservation34% 26% 12%

Short Equity 50% 65% 80% 90% 100%

International 12% 16% 20% 23% 25%
Stocks Large Cap Stocks28% 37% 44% 50% 55%

Mid/Small Cap 10% 12% 16% 17% 20%
Stocks APPENDIX B
Title:
Simulation: Goal Simulation Overview - Disability #115 Parent: Goal Simulation Overview #7~
Summar y:
~ The system 100 will follow the rules laid out in the Goal Simulation Overview Summary.
~ The system 100 will assume that the disability of the client exists from the beginning of the simulation period (as of analysis_start_date) and is a permanent disability -the client will not resume his/her employment again ~ The system 100 will adjust the current_living expenses by the Disability Goal Assumptions disability_percent of_ lifestyle expense ~ The system 100 will adjust the retirement_living_expenses by the Disability Goal Assumptions' disability-percent of_lifestyle_expense ~ The system 100 will track incomes and expenses as of the start of simulation ~ The system 100 will include an individual accumulation goal in the disability simulation if the goal specific disability-accumulation goalX indicator is set ~ The system 100 will include an individual education goal in the disability simulation if the goal specific disability_education_goalX indicator is set ~ The system 100 will include the cash_reserve_goal if present ~ The system 100 will include disability-additional_income for the disability simulation if entered in the Disability Goal Assumption Details:
Outstanding Issues:

APPENDIX B
Title:
Simulation: Goal Simulation Overview - Lifetime Summary #124 Parent: Goal Simulation Overview Summary #78 Child: Goal Simulation Overview - Long Term Care Summary #116 Summary:
~ The system 100 will follow the general rules defined in the Goal Simulation Overview section.
~ The system 100 will always perform the lifetime simulation goal ~ In general, the system 100 will track incomes and expenses, for the propose of having them affect the asset balances, starting at the earliest retirement (if client 1 retires in 2025 and client_2 retires in 2021, the system 100 will start tracking in 2021 ) ~ There are certain incomes and expenses that are tracked prior to the earliest retirement:
o Income fiom the sale of a business owned by a client o Income fi om the sale of real pr opei-ty owned by a client o The lump sum income fiom a company benefit_income (the company benefit_retirement allowance_net amount) o Income fi om an endowment or a fixed_annuity where the insur ed is a client o Income fi om a child_endowment where the owner is a client o The future cash value payment on a whole life or whole life term policy o Adjustments to savings o Accumulation goal expenses o Cash reserve goal expenses o Education goal expenses Localization: #3 -7 are done in System 100 Details:
Outstanding Issues:

APPENDIX B
Title:
Simulation: Goal Simulation Overview - Disability #115 Parent: Goal Simulation Overview #78 Summary:
~ The system 100 will follow the rules laid out in the Goal Simulation Overview Summar y.
~ The system 100 will include a disability goal for each client who has at least 2,000,000 Yen of combined employment income and business income, and whose age is between 18 and 60 inclusive ~ The system 100 will assume that the dis ability of the client exists fi om the beginning of the simulation period (as of analysis_start date) and is a permanent disability -the client will not resume his/her employment again ~ The system 100 will adjust the current_living expenses by the Disability Goal Assumptions disability~ercent of_ lifestyle expense ~ The system 100 will adjust the retirement living_expenses by the Disability Goal Assumptions' disability~ercent of_lifestyle_expense ~ The system 100 will track incomes and expenses as of the start of simulation ~ The system 100 will include an individual accumulation goal in the disability simulation if the goal specific disability_accumulation_goalX_indicator is set ~ The system 100 will include an individual education goal in the disability simulation if the goal specific disability_education_goalX_indicator is set ~ The system 100 will include the cash reserve_goal if present ~ The system 100 will include disability additional_income for the disability simulation if entered in the Disability Goal Assumption Details:
1) Determine the number of individual simulation runs and the duration of an individual run See parent 2) Set up the asset portfolios See parent 3) Detemnine key retirement periods See parent APPENDIX B
4) Set up the cashflows used in a simulation run Same as Parent. Rules specific to the Disability Goal are defined in the components of the Goal Simulation Cashflow Definition section #69 5) Set up additional scenarios of cashflows desired to create probability graphs See parent 6) Perform the simulation See parent 7) Calculate the probability results See Simulation: Calculating Probability Results Outstanding Issues:

APPENDIX B
Title:
Simulation: Goal Simulation Overview - Lifetime #124 Parent: Goal Simulation Overview #78 Child: Goal Simulation Overview - Long Term Care #116 Summary:
~ The system 100 will follow the general rules defined in the Goal Simulation Overview section.
~ The system 100 will always perform the lifetime simulation goal ~ In general, the system 100 will track incomes and expenses, for the propose of having them affect the asset balances, starting at the earliest retirement (if client 1 retires in 2025 and client_2 retires in 2021, the system 100 will start tracking in 2021 ) ~ There axe certain incomes and expenses that are tracked prior to the earliest retirement:
o Income fi om the sale of a business owned by a client o Income fiom the sale of real property owned by a client o The lump sum income fiom a company-benefit_income (the company benefit_retirement_allowance_net_amount) o Income fiom an endowment where the insured is a client o Income fiom a child_endowment where the owner is a client o The future cash value payment on a whole life or whole life temp policy o Adjustments to savings o Accumulation goal expenses o Cash reserve goal expenses o Education goal expenses Localization: #3 - 7 are done in System 100 Details:
1) Detemnine the number of individual simulation runs and the duration of an individual run See parent 2) Set up the asset portfolios See parent APPENDIX B
8) Determine key retirement periods See parent 9) Set up the cashflows used in a simulation run Same as parent. See Simulation: Goal Simulation Cashflow Definition Section and children for rules specific to Lifetime 10) Set up additional scenarios of cashflows desired to create probability graphs No additional scenarios are simulated since the probability graph shows the probability of success for each year of simulation between the_current and the~roposed.
11) Perform the simulation See parent 12) Calculate the probability results See parent Outstanding Issues:

APPENDIX B
Title:
Simulation: Goal Simulation Overview - Long Term Care #116 Parent: Goal Simulation Overview - Lifetime #124 Summary:
~ The system 100 will follow the rules laid out in the Goal Simulation Overview Summary.
~ The system 100 will perform the Long Term Car a simulation if at least one client is age 40 or gr eater ~ In general, the system 100 will track incomes and expenses during the post-retirement period ~ The system 100 will track ceutain incomes and expenses that occur in the pre retirement period as defined in the Goal Simulation Overview - Lifetime ~ The system 100 will adjust the retirement_living expenses by the LTC Goal Assumptions' long term_care-percent_of_lifestyle_expense staving at the first confinement ~ The system 100 will assume that the older client goes into a long term care confinement 11 years prior to the simulation end and is confined for 5 years, then dies so any incomes for that client will stop. The client may be retired at or prior to confinement so if the retirement of the client has not occmTed 11 years prior to the simulation end, the confinement start will be the lesser of 11 years from simulation end or the retirement of the older client. The confinement end will be the lesser of 5 years or year s to simulation end.
~ The system 100 will assume that the younger client or a single client goes into a long temp care confinement 5 years prior to the simulation end and is confined for 5 years, then dies at the end of simulation. The client may be retired at or prior to confinement so if the retirement of the client has not occmTed 5 years prior to the simulation end, the confinement start will be the lesser of 5 years from simulation end or the r etir ement year of the older client. The confinement end will be the lesser of 5 years or years to simulation end.
~ The system 100 will get the annual nursing home or car a cost from the Long Term Care Goal Goal Assumptions ~ The system 100 will include long temn_care_additional_income if entered in the Long Term Car a Goal Assumptions ~ The system 100 will not include individual accumulation goals or education goals in the Long Term Care Goal simulation if 1) long teim_care accumulation_goalX_indicator/
long temp_care_education_goalX_indicator is not set AND 2) the goal duration extends into the confinement start of the older client:

APPENDIX B
CASE EXAMPLE:
the older client's confinement starts in 2020 accumulation goal that occurs in the years 2018 - 2021 advisor indicated that the accumulation goal is not to be included in the long term care goal Simulation treatment: there would be a goal expenses in the years 2018 and 2019;
however, since the confinement period starts in 2020 and the accumulation goal is to be excluded in the long term care goal, the accumulation goal will not occur in 2020 and 2021. This treatment makes the Lifetime simulation and Long Term Care Goal simulation the same up to the confinement period of the older client.
Details:
1) Determine the number of individual simulation runs and the duration of an individual Tun See parent 2) Set up the asset portfolios See parent 3) Detemnine key retirement periods See parent 4) Set up the cashflows used in a simulation run Same as Parent. Rules specific to the Long Term Care Goal are defined in the components of the Goal Simulation Cashflow Definition Section 5) Set up additional scenarios of cashflows desired to create probability graphs Lifetime or LTC goal: no additional scenarios are simulated since the probability graph shows the probability of success for each year of simulation between the current and the_proposed.
6) Perform the simulation See parent APPENDIX B
7) Calculate the probability results After all the simulation runs have been completed, the probability results are calculated.
See Simulation: Calculating Probability Results Outstanding issues:

APPENDIX B
Title: Simulation: Goal Simulation Overview Childr en:
Goal Simulation Overview - Lifetime #124 Goal Simulation Overview - Disability #115 Goal Simulation Overview - LongTermCare #116 Survivor Simulation #82 Summary:
~ The system 100 will perform simulations that project out cashflows of client incomes, savings, liabilities, premiums, goal expenses, and living expenses, tracking the impact on clients' assets for a specific set of goals.
~ The specific set of goals to be simulated are dependent on client data ~ The system 100 will always perform the lifetime cashflow ~ The system 100 may also perform cashflow projection simulations that represent a disability situation for a client, a survivor situation where a client is assumed to have died, and a long term car a situation where the clients are assumed to be confined to a long term care facility prior to the simulation end ~ The system 100 will simulate in period increments based on the simulation period fiequency. This period fi~equency is defined to be annual so all cashflows will be convened to an annual amount ($1000 /month becomes $12,000/year) - for the remainder of this document, the conversion step will say that the amount will be converted to an amount based on the simulation fiequency ~ The system 100 will calculate the duration of each individual simulation by subtracting client_l_current_age fiom client_1 life expectancy for all but the survivor goal simulation ~ The system 100 will perform a specific number of individual simulation runs (as defined in the Stochastic Sampling Methodoloy section - #123) for proposes of collecting probability results ~ The system 100 will consider the simulation start to be as of the analysis_start_date ~ An individual goal simulation run will project out cashflows based on data entry related to incomes, savings, premiums, liabilities, living expenses, and goal expenses ~ An individual goal simulation will track the effect that incoming and outgoing cashflows have on the clients' asset balances and will consider that the clients have run out of money (a failed simulation run) if the clients' total asset balance has insufficient funds to meet expenses any time after the retirement of the client working the longest ~ The system 100 will assume that a loan is taken out in the cases where a shortage occurs prior to the retirement of the client working the longest ~ The system 100 will perform a goal simulation based on the clients' cmT ent situation as specified by data entry inputs (for the rest of this document, it will be referred to as the cuiT ent) ~ The system 100 will perform a goal simulation based on modifications to the_cument. The simulation based on the clients' modified situation will be refers ed to as the-proposed APPENDIX B
The system 100 will collect and present results that illustrate the probability of success given the_cument and the~roposed The system 100 will trigger a recalculation of the goal simulation when modifications are made to data entry or when modifications are made and saved to assumptions in the analysis of other simulation goals (lifetime, disability, survivor, or long term care) Details:
Assumptions:
1) For this document, we assume that there is a client_1 and a client_2. For groups where then a is not a client_2, the information related to client_2 is ignor ed.
2) incomes ar a owned by client_1 or client_2 3) liabilities are owned by client 1 or client 2 1) Determine the number of individual simulation runs and the duration of an individual run ~ The system 100 will perform a specific number of simulation runs for each goal simulation (See the Stochastic Sampling Methodology section - #123) ~ The system 100 will calculate the simulation duration r) For all but the survivor goal simulation, the simulation duration in years of the cashflow projections is calculated by subtracting the client_1 current age from client_1 life_expectancy ii) For the survivor goal simulation, the simulation duration depends on whether there is a surviving client (see Survivor Simulation section - #S2 for specific detail) 2) Set up the asset portfolios ~ The system 100 desires that the clients' investment_assets are divided into a specified number of simulation~ortfolios -1) regular_asset_simulation portfolio, 2) regular contribution_simulation-portfolio, 3) client_1 retirement_simulation~ortfolio, and, if client_2 exists, 4) client_2_retirement_simulation-portfolio (See the Model Portfolio Section) ~ The system 100 will detemnine the beginning asset balance for each of the specified portfolios based on the asset_owner and ASSET TYPE of each of the clients' investment assets (See Asset section - #27) Additional feature: for simulation, the regular_asset_simulation-portfolio will include the cash value of universal life policies.
~ The system 100 will determine the investment asset allocation to use for each of the portfolios (See the Model Portfolio Section) APPENDIX B
3) Determine key retirement periods ~ client_1's client_retirement_stant~eriod equals client_1_retiiement_age minus client_1 cuiT ent age ~ client_2's client_retirement_start~eriod equals client_2_retirement_age minus client_2 cument_age ~ The system 10U will determine the retirement_starting_period to be the same as client_retirement_sta~-t-period of the first client to retire ( the lesser of client_1's client_retirement_start-period and client_2's client_retirement stant_period) ~ The system 100 will determine the latest_retirement~eriod by taking the greater of Client 1's client_retirement_start-period and client_2's client_retir ement_stant~erio d ~ the latest_retirement_period is the first period that triggers the process of determining whether an individual simulation run has failed due to insufficient assets to meet expenses ~ For a single client case or if the two clients r etire in the same year (given that the simulation periods are annual), the retirement_starting~eriod is equal to the latest retirement-period 4) Set up the cashflows used in a simulation run During simulation, the system 100 will add cashflows that represent income and policy benefit cashflows to the regular_asset_simulation portfolio, increasing the portfolio's balance as long as 1) the cashflow's start~eriod is equal to or greater than simulation period currently being processed and 2) the cashflow's end~eriod is less than or equal to the simulation period currently being processed.
During simulation, the system 100 will add cashflows that represent adjustments to savings to the regular asset_simulation-portfolio. The portfolio's balance is increased or decreased depending on whether the adjustment is an increase or decrease to savings.
The cashflow affects the balance if 1) the cashflow's start~eriod is equal to or greater than simulation period currently being processed and 2) the cashflow's end_period is less than or equal to the simulation period cmT ently being processed.
During simulation, the system 100 will add cashflows that represent savings to regular assets and the accumulation piece of an Universal Life pr emium to the regular contribution_simulation_portfolio, increasing the portfolio's balance as long as 1) the cashflow's sta~-t_period is equal to or greater than simulation period cmTently being processed and 2) the cashflow's end~eriod is less than or equal to the simulation period currently being processed.
Additional feature: considering a portion of a Universal Life premium as a savings During simulation, the system 100 will add cashflows that represent savings to retirement_assets to the retirement_simulation-portfolio for the pa~.-ticular client whose savings it is. The portfolio's balance will be increased by the cashflow amount as long as 1) the cashflow's stal-t-period is equal to or greater than simulation period currently APPENDIX B
being processed and 2) the cashflow's end~eriod is less than or equal to the simulation period cmTently being processed.
During simulation, the system 100 will subtract certain expense cashflows (types include living expenses, goal expenses, liabilities, pr emiums, and savings) fr om the simulation~oufol.ios, decreasing a portfolio's balance as long as 1) the cashflow start-period is equal to or greater than simulation period currently being processed and 2) the cashflow end~eriod is less than or equal to the simulation period currently being processed.
The system 100 will subtract the expenses from the portfolios in the following withdrawal order: 1) regular asset_simulation~ortfolio, 2) regular_contribution_simulation portfolio, 3) retirement simulation-portfolio of the oldest client, and if there are two clients, 4) retirement_simulation~ortfolio of the younger client See Simulation: Simulation Cashflow Definition section - #69 5) Set up additional scenarios of cashflows desired to create probability graphs Lifetime or LTC goal: no additional scenarios are simulated since the probability graph shows the probability of success for each year of simulation between the_cument and the~roposed.
Disability goal: In addition to simulating scenarios based on cashflows based on the_current and the proposed, the system 100 will set up 4 additional scenarios which will be the same as the_proposed except in the amount of additional disability benefits.
The additional disability benefits that will included in each of the 4 additional scenarios are determined based on the client's maximum disability insurance limit given their employment income.
Survivor goal: In addition to simulating scenarios based on cashflows based on the_cuiTent and the proposed, the system 100 will set up 4 additional scenarios which will be the same as the-proposed except in the derived net change to life policies' sum assured amounts. The sum assured death benefits that will included in each of the 4 additional scenarios will be determined based on rules specified in the Stuvivor Goal -Determining Additional Benefits to Crraph section.
6) Perform the simulation For each iteration or run of the simulation, the process is as follows:
a) Apply inflation: inflation is applied to incomes, expenses, and savings in all periods except the first period (year of analysis_start_date). The rules regarding how a specific type cashflow inflates are found in the Simulation Cashflow Definition sections.

APPENDIX B
b) Apply inter est to the phantom loan balance: if then a previously wer a insufficient assets to cover expenses, a phantom loan was taken out. Interest is applied to the outstanding loan balance. The interest rate used is the stochastically determined inflation rate + PHANTOM LOAN RATE
c) Process incomes:
1 ) go through all the income cashflows and sum up the total income for the curs ent period. those income cashflows whose start-period is greater than or equal to the cmTent period and whose end_date is less than or equal to the cmTent period ar a included in the total income.
2,) The income total is added to the regular asset simulation portfolio.
d) Process savings to asset portfolios - for each simulation poutfolio:
1) sum up the total client savings associated with the portfolio for the current period.
those client savings cashflows whose start_period is greater than or equal to the cmTent period and whose end date is less than or equal to the current period are included in the total client savings.
2) The sum of total client savings is added to the balance of its corresponding simul ation-portfolio.
3) The sum of total client savings is also subtracted from the regular_asset_simulation~onfolio that receives the incomes since while the savings increase assets, it is also an expense in that the client must fund the savings. The savings is subtracted from that portfolio for the entire duration of the disability goal simulation and the survivor goal simulation. However, for the Lifetime and LTC goals, the savings is subtracted fr om that portfolio during the retirement period of simulation;
4) sum up the total employer savings for the current period. those employer savings cashflows whose staut-period is greater than or equal to the current period and whose end_date is less than or equal to the cmTent period are included in the total employer savings.
5) The sum of total employer savings is added to the balance of the simulation~ortfolio.
e) Pay off phantom loan with existing assets: if there is an outstanding phantom loan that was 'taken' out in order to cover asset shortage (insufficient assets to meet expenses), go through the simulation-portfolios, based on the withdrawal order, and use any existing assets to pay off the phantom loan.
f) Process expenses (includes living expenses, goal expenses, premiums, and liabilities):
1) Go through all the expense cashflows and sum up the total expense for the current period. Those expense cashflows whose start-period is greater than or equal to the current period and whose end_date is less than or equal to the cmTent period are included in the total expenses.
2) The expense total is subtracted from the simulation_ponfolios based on the withdrawal order. Depending on the specific portfolio, a withdrawal from the portfolio may be taxable. If so, the amount desired to be pulled from the APPENDIX B
portfolio is equal to expense total divided by (1 -AVERAGE_TAX_RATE_ON_WITI~RAWAL). If the asset portfolio balance is insufficient to meet the total expense for the period, the portfolio meets as much of the expense as it can, bringing its balance down to zero.
3) If there is any remaining expense to be paid off, continue through the other simulation-portfolios in an attempt to fully paid down the expense 4) If there are insufficient assets to meet the expenses for the period, a phantom loan is taken out to meet the difference unless the period being processed is on or after the retirement period of the client retiring last (if one client, it is the retirement_starting~eriod). In that case, the clients are considered to have failed and that simulation run is ended.
g) Apply growth to portfolios - for each simulation portfolio:
1) get the ending balance for the period 2) get the cash rate of return, the bond rate of return, and the equity rate of return for the current period (see Stochastic Sampling Methodology section - #109) 3) calculate the portfolio investment r eturn by applying the portfolio weight to the corresponding simulated retm-n for the period: 1) percentage of cash * the cash return + 2) percentage of bonds * the bond return + 3) percentage of equity *
the equity retiu-n 4) adjust the weighted portfolio return based on rules for the specific asset portfolio (if the portfolio grows at an after-tax growth rate, the growth rate = investment return * ( 1- AVERAGE CAP-GAINS_TAX) 5) add the growth to the portfolio balance 7) Calculate the probability results After all the simulation runs have been completed, the probability results are calculated.
See Simulation: Calculating Probability Results Outstanding Issues:
1) Are the investment assets specifically identified in the Asset section?

APPENDLY B
Title:
Simulation: Goal Simulation Overview Summary - Section 78 Children:
Goal Simulation Overview - Lifetime #124 Goal Simulation Overview - Disability #115 Goal Simulation Overview - LongTermCare #116 Survivor Simulation #82 Summary:
~ The system 100 will perform simulations that project out cashflows of client incomes, savings, liabilities, premiums, goal expenses, and living expenses, tracking the impact on clients' assets for a specific set of goals.
~ The specific set of goals to be simulated are dependent on client data ~ The system 100 will always perform the lifetime cashflow ~ The system 100 may also perform cashflow projection simulations that represent a disability situation for a client, a survivor situation where a client is assumed to have died, and a long term car a situation where the clients are assumed to be confined to a long term car a facility pr for to the simulation end ~ The system 100 will simulate in period increments based on the simulation period fiequency. This period fiequency is defined to be annual so all cashflows will be conveuted to an annual amount ($1000 /month becomes $12,000/yeax) - for the remainder of this document, the conversion step will say that the amount will be converted to an amount based on the simulation fiequency ~ The system 100 will calculate the duration of each individual simulation by subtracting client_1_current_age fiom client_1 life_expectancy for all but the survivor goal simulation ~ The system 100 will perform a specific number of individual simulation runs (as defined in the Stochastic Sampling Methodoloy section - #123) for purposes of collecting pr obability results The system 100 will consider the simulation start to be as of the analysis start_date ~ An individual goal simulation run will project out cashflows based on data entry related to incomes, savings, premiums, liabilities, living expenses, and goal expenses ~ An individual goal simulation will track the effect that incoming and outgoing cashflows have on the clients' asset balances and will consider that the clients have run out of money (a failed simulation run) if then a is a shortage at the retirement period of the client retiring last or, for a single client, the final simulation period -this period is considered the failure trigger period.
~ The system 100 will assume that a loan is taken out in the cases where a shortage occurs prior to the failure trigger period.
~ The system 100 will perform a goal simulation based on the clients' current situation as specified by data entry inputs (for the rest of this document, it will be referred to as the cui-r ent) APPENDIX B
The system 100 will perform a goal simulation based on modifications to the_curr ent. The simulation based on the clients' modified situation will be r efemed to asthe_proposed The system 100 will collect and present results that illustrate the probability of success for the current and the probability of success for the~roposed.
The system 100 will trigger a recalculation of the goal simulation when modifications are made to data entry or when modifications are made and saved to assumptions in the analysis of other simulation goals (lifetime, disability, survivor, or long term care) Outstanding Issues:
7~

APPENDIX B
Title:
Simulation: Calculating Probability Results - REQ #89 Referenced Sections:
Risk Goal Assumptions #88 Survivor simulation: Graph points sections #133 Summary:
Additional feature: Japanese Lightning wants the disability simulation to show the probability success for each period of simulation ~ The system 100 will calculate the probability of success for each goal that is simulated The system 100 will compare the probability of success of the current and the_proposed for each goal that is simulated ~ The system 100 will calculate lifetime simulation results based on the current data and based on the~roposed data ~ The system 100 will calculate long term care simulation results based on the_cmTent data and based on the_proposed data ~ The system 100 will calculate survivor simulation results based on the cmTent data, the-proposed data, and on 4 additional scenarios based on net change to sum assured death benefits.
~ The system 100 will calculate disability simulation results based on the current and on the~roposed data D etails:
Assumption: a period of simulation is equivalent to a year of simulation.
The simulation probabilities are detennined based on data collected during the simulation pr ocess.
1) Collect asset balance for each period of an individual simulation run:
The system 100 will determine the maximum number of periods of a single simulation by subtracting the first client's (or surviving client's) cmTent age fiom the life expectancy of the client. In the case of a survivor goal for a single client, the simulation periods is equal to the survivor period entered in the Risk Goal Assumptions.
~ the system 100 will simulate the lesser of the max number of periods or the retirement period in which they run out of money.

APPENDIX B
~ at the end of each period simulated, the system 100 will collect the ending asset balance (if the clients run out of money prior to the last period of simulation, the balance for those un-simulated periods has been preset to 0.0).
2) Summwize the results collected fiom each simulation run:
~ for each period x in each run, the system 100 will increment a counter if the ending period balance is greater than 0Ø
-~ after going through each period for each run, the system 100 will have the total number of times there was a positive ending balance for that period.
~ For each period, the system 100 will divide the total number of times there was a positive ending balance by the total number of runs. This provided the probability of success for that individual period.
3) The system 100 will determine the summary probability for success to be the probability of success of the final simulation period.
current_lifetime_summary-probability - based on client data proposed lifetime summary~robability - based on advisor modifications cument_ltc_summary-probability - based on client data proposed ltc summary-probability - based on advisor modifications cument_dis ability-summary~r obability proposed disability summary-probability - based on advisor modifications in analyze curs ent_survivor summary-pr obability proposed survivor_summary-probability-advisor_selected - based on advisor modifications in analyze 4) The system 100 will provide detailed probability r esults for a simulated goal:
Additional feature: Japanese Lightning wants the disability simulation to show the probability success for each period of simulation rather than the probability of success based on various levels of disability benefit amounts.
Disability, Lifetime and Long Term Care Goal Simulation Detailed Results:
~ The system 100 will provide the probability of success for each period of simulation.
~ The system 100 will provide that detail for both the current and the_proposed cument_disability detail-probability cument_lifetime detail_pr obability current ltc detail~robability proposed disability_detail-probability proposed_lifetime detail_probability proposed ltc detail_probability APPENDIX B
Survivor Goal Simulation Detailed Results:
The system 100 will provide the summary probability of success for the current, for the~roposed, and for each of the additional scenarios that are based on additional insurance benefits that were derived fiomthe additional insurance the advisor proposed in the~roposed scenario. (See Survivor simulation: Graph points sections #133) current_survivor summary_probability pr oposed_survivor_summary_probability_advisor_selected proposed_survivor-summary-probability_system_generated_1 proposed survivor summary_probability system_generated_2 proposed survivor summary_probability_system_generated_3 proposed survivor summary_probability_system generated 4 Outstanding Issues:

APPENDIX B
Title:
Simulation: Goal Simulation Overview - Lifetime Summary #124 Parent: Goal Simulation Overview - Lifetime #124 Summary:
~ The system 100 will follow the rules laid out in the Goal Simulation Overview Summary.
~ In general, the system 100 will track incomes and expenses during the post-retirement period ~ The system 100 will track ceutain incomes and expenses that occur in the pre retirement period as defined in the Goal Simulation Overview - Lifetime The system 100 will adjust the retirement_living expenses by the LTC Goal Assumptions' long term_care-percent_of_lifestyle expense staring at the first confinement ~ The system 100 will assume that the older client goes into a long term care confinement 11 years prior to the simulation end and is confined for 5 years, then dies so any incomes for that client will stop. The client may be retired at or prior to confinement so if the retirement of the client has not occmTed 11 years prior to the simulation end, the confinement start will be the lesser of 11 years fiom simulation end or the retirement of the older client. The confinement end will be the lesser of 5 years or yeaxs to simulation end.
~ The system 100 will assume that the younger client or a single client goes into a long term care confinement 5 years prior to the simulation end and is confined for 5 years, then dies at the end of simulation. The client may be retired at or prior to confinement so if the retirement of the client has not occmTed 5 years prior to the simulation end, the confinement start will be the lesser of 5 years from simulation end or the retirement year of the older client. The confinement end will be the lesser of 5 years or years to simulation end.
The system 100 will get the annual nursing home or care cost fi om the Long Temp Care Goal Goal Assumptions ~ The system 100 will include long term_care additional_income if entered in the Long Term Care Goal Assumptions ~ The system 100 will not include individual accumulation goals or education goals in the Long Term Care Goal simulation if 1) long temn_car a accumulation_goalX_indicator/
long temn_care education_goalX_indicator is not set AND 2) the goal duration extends into the confinement start of the older client:

APPENDIX B
CASE EXAMPLE:
the older client's confinement stars in 2020 accumulation goal that occurs in the years 201 ~ - 2021 advisor indicated that the accumulation goal is not to be included in the long term care goal Simulation treatment: there would be a goal expenses in the years 201 ~ and 2019;
however, since the confinement period starts in 2020 and the accumulation goal is to be excluded in the long term caa-e goal, the accumulation goal will not occur in 2020 and 2021. This treatment makes the Lifetime simulation and Long Term Care Goal simulation the same up to the confinement period of the older client.
Outstanding issues:
~3 APPENDIX C
Title: Stochastic Methodology - Sampling Process for Simulation Section: 123 Summary:
System 100 will measure clients' probability of successfully reaching all of their financial goals over many different market conditions. The system 100 will stochastically vary the market forces over the length of the clients' financial future (simulation duration). The system 100 will also project the clients' financial future thousands of times so that we can measure a probability of success over many thousands of possible futures.
For proposes of this system 100, the key market forces are the following:
~ Inflation rate;
~ Return on cash investments;
~ Return on fixed-income investments; and ~ Return on equity investments.
This section will describe how the system 100 will sample these variables stochastically to create the various lifetime and protection simulations.
D etails:
Sampling Methodology The stationary bootstrap methodology that is used for Apex Select should be used for System 100. Because this methodology is confidential, detailed specifications will not be given in this document. The methodology was discussed with Mitsui content expects, along with other sampling choices. Mitsui prefers to use the stationary bootstrap.
The methodology will be localized as follows:
~ The indexes used will reflect the investment opportunities available. The indexes ar e:
~ Inflation: Consumer Price Index (All Country General) ~ Cash Equivalents: Postal Savings Certificates Less than 1 year ~ Fixed Income: International Monetary Fund Country Long-Term Government Bond - Total Retui~ with dividends ~ Equities: MSCI Country Stock- Total Return with dividends ~ The data sent is attached below:
~ The sampling timeframe will reflect Mitsui's view of the future investment market's behavior. The indexes will be sampled fi om a timeframe of December 1977-December 2000.
~ The -p-value_ will be appropriate for the indices characteristics. (The process to determine the p-value is also considered strictly confidential. The process and APPENDIX C
analysis will be on file, but not available for general reference.) See Section #147.
Stability of Results - Number of Simulations In or der to reach a high degree of confidence in the probability of success, the system 100 will run enough simulations for the results to be stable - each time the probability of success is run, the r esult should not be very differ ent from prior r esults. Bach individual simulation result can take on one of two possible values: successful or unsuccessful.
This is a binomial distribution. Therefore, we consider 6,750 runs the number that is desired to obtain a precision of 1% with a 90% level of confidence.
The actual results may vary more than 1%. If the actual results vary by more than 1% so often that we feel the results are not stable or outside of our confidence level, then we can increase the results.
Per formance Conversely, if the simulation time is so great that performance is unacceptable, we can to decrease the number of runs.
Calculating and Displaying the Probability of Success When we display the probability_ for each simulation, normal rounding rules should be used to show the nearest whole percentage. Specifically:
~ Round up for values greater than or equal to 0.5%;
~ Round down for values less than 0.5%.
However, when the calculated probability is less than 5%, "<5%" should be displayed to the client and, when the calculated probability is greater than 95%, ">95%" should be displayed to the client.
Maintaining and updating the index data Annually, the impact of updating the monthly index data on the simulation results will be evaluated.
Outstanding Issues:

APPENDIX C
Title: Lite: Lifetime Simulation Sections _Purpose/Description:
The propose of this section is to explain the business rules that should be used during the simulation. This section also explains how each major input should be treated in the simulator.
Methodology The stationary bootstrap methodology that was used for MC1 should also be used for System 100. The difference is that we will use a cash/fixed/equity mix for System 100 rather than just a fixed/equity mix as we did in MCl. The following spreadsheet contains the inflation, cash, fixed and equity data that should be used for sampling.
For each simulation, we should run 6,750 iterations as we did in MC1. We realize that we can reduce this number for performance reasons though.
When we calculate the probability for each simulation (number of iter ations in which ending asset balance was > 0 divided by total number of iterations), normal rounding rules should be used to round to the nearest whole percentage. However when the calculated probability is less than 5%, "<5%" should be displayed to the client and when the calculated probability is greater than 95%, ">95%" should be displayed to the client.
Determining the projection period for the lifetime simulation Calculate Client 1's current age. (If their month of birth is less than or equal to the month of the analysis staut date, then current age = year of analysis start date minus year of birth. Else cmTent age = year of analysis sta~~t date minus 1 minus year of birth. - -Added "or equal to"
Number of years in the projection period is then equal to Client 1's age at the end of the projection minus Client 1's current age The same projection period will be used for disability and long-term care See death goal sections for specific information regarding the projection period for death Summary of projection period for death: For a two client case we will use the hfe expectancy of the surviving client (behind the scenes lookup to single life expectancy table, advisor will not be able to oveiTide). For a one client case, the advisor will enter the survivor period in goal assumptions.
Determining client age and the year for each period during the simulation The first period of the projection will always be the year of the analysis start date regardless of whether the month is January or December.
We will calculate the cmTent age for both clients to determine their beginning age for the simulation.
The year and age will then be incremented by one for each year of the simulation to detei~nine when cash flows start and stop.
Example - given an analysis start date of 2/2/2001, Client 1's birth date of 1/4/68 and Client 2's birth date of 4/6/70:
In the first year of the projection, we would look for cash flows in existence in the year 2001 and at Client 1's age 33 and Client 2's age 30.

APPENDIX C
In the second year of the projection, we would look for cash flows in existence in the year 2002 and at Client 1's age 34 and Client 2's age 31.
Etc.
Processing order for simulation Get inflation and growth r ates for the curs ent per io d.
Apply inflation (Exception - inflation should not be applied in the fir 5t period. Note that this could be accomplished by setting the inflation rate to 1 for the first period.) Process any RMDs and apply tax on RMDs Process incomes and apply tax on income (tax = taxable income * average tax rate entered) Process expenses Add savings to "non-qualified" savings bucket and "qualified" assets.
If after-tax income and RMDs exceeds expenses and phantom loan balances and savings (employee poution only), the excess should be added to "non-qualified" assets.
(Note that in "happy" situations when we are not tracking income vs. expenses, excesses we ignor ed. ) If expenses and phantom loan balances and savings (employee portion only) exceed after-tax income and RMDs, the shortage should be subtracted from assets based on the following order: 1) "non-qualified" assets, 2) "non-qualified" savings 3) "qualified" of older client and 4) "qualified" of younger client. When "qualified" assets are used to cover a shortage, the amount desired to cover the taxes on the "qualified"
assets withdrawn should be withdrawn at the same time. This can be accomplished by taking the amount of the withdrawal and dividing by (1- the average tax rate entered).
Calculate the end of period asset balances and apply growth to those balances.
Calculating Phantom Revolving Loans In situation #~ above, when the shortage has consumed all non-qualified and qualified assets, a phantom revolving loan balance should be created. It is calculated as the remainder of the shoutage, increased by a phantom interest rate. This interest rate is calculated as the modeled inflation rate plus 6.1%. Thus, the phantom interest rate will change each year. In the next year the loan balance is added to any cash flow shortage or subtracted from any cash flow surplus before applying the surplus or shortage to assets in the order previously specified. In such a way, regular savings will in effect pay down phantom loan balances. In years that there is a phantom loan balance, all asset balances will naturally be zero, so asset balance can still be the indicator of success. If at second retirement there is still a phantom loan balance, that particular simulation may be stopped as a failure. Talk to Linda Ostrem for questions on phantom loans.
Calculating RMDs RMDs should be withdrawn from "qualified" assets starting in the period in which the owner is age 71. The RLVID should be calculated by taking the beginning of period balance for the owner's "qualified" assets divided by the number of periods remaining in the projection. The number of periods remaining in the projection is equal to Client 1's age at the end of the projection (input field) minus Client 1's age in the cw~rent period.
~7 APPENDIX C
Applying asset growth The "CmTent" Cash/Fixed/Equity mixes will be calculated based on the asset classes of the client's holdings entered. See section "Detemnining rollup of investment class" for an explanation of how the asset classes roll up to the cash/fixedlequity level.
We will use the holdings entered as taxable Other investment accounts to determine the cash/fixed/equity mix that will apply to "Non-qualified" assets and "Non-qualified" savings in the Current.
The cash/fixed/equity mix is calculated by taking the value of the taxable cash holdings entered under "Other investment accounts" (excluding cash reserve) divided by the value of all taxable holdings (excluding cash reserve) entered under "Other investment accounts" to azTive at the % for the cash portion of the mix. This calculation is then repeated for fixed and equity.
We will use the holdings entered as retirement plan accounts to detemnine the cash/fixed/equity mix that will apply to all "qualified" assets and savings in the CmTent.
The cash/fixed/equity mix calculation is the same as for taxable Other investment accounts.
Just substitute "r etirement plan account holdings" for "taxable holdings entered under "Other investment accounts" in the formula.
Note that holdings entered under the cash value of a life insurance policy should not be factored into the calculation of the cash/fixed/equity mix calculations.
Made the changes above to coincide with the field labels that are going to be used on the LTI.
Added the note about the holdings entered under cash value of a life insurance policy since we are now asking for the asset class breakdown of the cash value in the UI.
Originally we were just going to ask for the amount of the cash value. Crossed out "excluding cash reserve" since there will no longer be a cash reserve asset class.
In the remote situation that a client does not have any "qualified" assets but they entered "qualified" savings, we can use the mix of their "non-qualified" assets for the "qualified" in the CmTent. In the even more remote situation, that they don't have "non-qualified" assets but entered "non-qualified" savings, we can use the mix of their "qualified"
assets for the "non-qualified" in the CuiT ent.
The Portfolio section "Determining the Proposed Cash/Fixed/Equity Simulation Portfolio"
explains how to aiTive at the "Proposed" Cash/Fixed/Equity mixes that will be used for 1) "Non-qualified" assets, 2) "Non-qualified" savings and 3) "Qualified" assets and savings.
Note that the current and proposed mixes are detemnined based on the "happy"
scenario and then applied to all the pr otection goal scenarios. In other words, we will not recalculate the current mix in the death scenario or recommend a different proposed mix for disability or ltc. The mixes that we aiTive at in the "happy" scenario will be applied throughout.
Once the cash/fixed/equity mixes are determined, the investment r eturn is calculated by applying the portfolio weight to the corresponding simulated return for the period (i.e. cash * the cash r eturn). For "Non-qualified" buckets, the investment r eturn should then be multiplied by (1 - average tax rate entered) to asTive at the after-tax growth rate.

APPENDIX C
IJse of inputs in the simulator The following table explains how each major input should be treated in the simulator. Note that this table contains general statements r egarding when cash flows start and stop and how they are inflated, The sections that follow for each goal (i.e. lifetime, DI, death, LTC) explain when incomes and expenses should be taken into consideration for that particular goal.
Inpnt How it works in simulator Incomes Note that there is not a limit to the number of incomes that can be entered Employment, Gross amount entered should be converted to an annual amount. Should Self employment grow at modeled inflation rate. Should stop and Bonus at the owner's retirement age (income should not be included in the period equal to their retirement age). The advisor will not be entering a % taxable, but we should calculate the % taxable beliind the scenes.
The % should be calculated as follows: 100% minus (total (plan deferrals and "Other") annual pre-tax deductions entered / annual gross income).
In the proposed, the pre-tax deductions in the numerator should be increased if the advisor enters additional employee salary deferral contributions (input exists for a 401(k), 403(b), Section 457, Other defined contribution plan, SEP, SIMPLE IRA or SIMPLE 401 (k)). Taxes should be applied to the portion that is taxable (gross amount * % taxable calculated). - - Deleted SEP

since the SARSEP option was removed from the UI.

Investment Ignored for simulation purposes.

Pension Annual amount entered should grow at modeled inflation rate if COLA

option was selected. If the COLA option was not selected the annual amount will not grow over time. Should start at the later of the owner's retirement age or the year entered in the Year Begins field (full year of income should be included in the period that it starts). Should stop at the earlier of the year entered in the Year Ends field or the end of the proj ection. (If a specific year is entered in the Year Ends field, no income should be included for that period.)Taxes should be applied to the portion indicated as taxable in the Percent Taxable field.

Other Aunual amount entered should grow at modeled inflation rate. Should start at the year entered in the Year Begins field (full year of income should be included in the period that it starts). Should stop at the earlier of the year entered in the Year Ends field or the end of the proj ection (no income should be included in the period that it stops). Taxes should be applied to the portion indicated as taxable in the Percent Taxable field.

Social Security- The annual amount entered should grow at Current half the modeled inflation rate.

benefit received Should start at the later of the client's Amount retirement or age 62 and continue entered by advisoruntil the end of the projection. Taxes should be applied to 50% of the (if the advisor income. If the client is not yet retired entered an or retired and less than age 62, the amount, it shouldbenefit entered should be adjusted to the always be benefit at the later of the client's used in the analysisretirement or age 62.

regardless ofwhether the advisor checked the box to include a system calculated estimate) - -Social Security- If the advisor did not enter a benefit amount System- and indicated that a calculated estimateretirement benefit system-calculated estimate of future should be included in the benefit (if they analysis, the benefit should start at the entered a later of the owner's retirement age current benefit or age 62 (full year of income should be for the included in the period that it owner, they will starts) and continue until the end of the not be able proj ection. Taxes should be to enter this applied to S 0% of the income. The amount one) calculated by the system will (an estimate sliouldbe their Normal Retirement Age benefit in be today's dollars. Tlierefore, the APPENDIX C
calculated if the advisor did benefit can be adjusted based on their actual retirement age and should not enter a benefit amount grow at half the modeled inflation rate.
AND they checked the box to include an estimate) - -Business Refer to the "Small business owner without business planning section"
lllllllllllllllllrlllllllllllllllllllllll lllrllllllrlllllllllllllllllllrllllrlllllllllllllrllllllllllrlllllllllllllrllll llllllllllllllllrlllllllllll Residence and Personal Note that there is not a limit to the number of personal assets and Assets (and associated residences that can be entered. Therefore the number of associated expenses) liabilities is also unlimited.

Value ofresidenceIgnored for simulation purposes.

Mortgage and Annual payment continues as au expense until the end date. We will not Home equity loan recognize a fractional payment in the final year, so include a full annual payment (conservative approach) in the period equal to the end year. The payment does not grow with inflation.

Real estate taxesAnnual amount continues as an expense until the end ofthe projection.

(we will not be Should grow at the modeled inflation rate.
asking for Would not need to be tracked real estate taxesseparately from living expenses (could just as a separate be added to living expenses) input. Therefore since they are treated the same.
ignore this section.) Value of personalIgnored for simulation purposes.
and other noninvestment assets Associated liabilitiesAnnual payment continues as an expense until the end date. We will not recognize a fractional payment in the final year, so include a full annual payment (conservative approach) in the period equal to the end year. The payment does not grow with inflation.

rrrrrrlrlrrrrrrrrrrrrrllrrrrrrrrrrrlrrrriiririiiiriuiiiririiruiiurrriiriririiii rirriritiriiriuruiiriiiiritiiiiiiiiiuiuiiiiiiiiiiriririiriu Investment Assets Retirement accountsThe value of all assets entered under retirement - accounts plus the current current value balance of any outstanding loans on retirement plans should roll to the owner's "qualified" pool for simulation purposes. See section "Determining rollup of investment class"
for au explanation of how to map the asset class entered to cash, fixed or equity.

Retirement accountsThe employee contribution will be entered - as an annual dollar amount on contributions the retirement plan screen. Employer contributions may be entered as an annual dollar amount, straight % or employer matcli depending on the type ofplan. When employer contributions are entered as a straight (i. e. profit sharing contribution or nonelective contribution) - deleted profit sharing since it was removed from the LTI, the annual amount of that employer contribution should be determined by multiplying the % entered times the annual gross employment income for that client (the one tied to the plan if more than one income is entered).
employer contributions will never be entered as a straight %. A nonelective contribution will be entered as a dollar amount, so no conversion will be necessary. When employer contributions are entered as matches, the annual amount of the employer contribution should be determined as follows:

First calculate the employee salary deferral % by taking the annual amount ofthe employee contribution and dividing bytlie annual gross employment income for that client (the one tied to the plan if more than one income is entered).

Then given inputs of "Employer matches A%
of the first B%"

"After which they match C% of the next D%", the annual amount ofthe employer contribution should be determined by the following formula:

[A% times the minimum of (tlie employee salary deferral % entered and B%)] times the annual gross employment income tied to the plan plus APPENDIX C
0 if the employee salary deferral % entered is < or equal to B%

or if the employee salary deferral % entered is >B% add [C% times the minimum of (the employee salary deferral % entered minus B% and D%)] times the annual gross employment income tied to the plan.

Note that more than one type of employer contribution (straight dollar amount and % match) could be entered for a given plan, so the two can be summed to arrive at the total employer contribution.

Annual contribution amounts calculated should grow at modeled inflation rate. Should stop at the owner's retirement age (contribution should not be included in the period equal to the owner's retirement age). Employee and employer contributions should be added to the owner's "qualified" pool.

In any situation wliere we are calculating income shortage or surplus (after first retirement, disability or death), the employee portion of the contribution should be considered as au expense.

Retirement accountsAnnual payment continues as an expense until - the end date. We will not outstanding loansrecognize a fractional payment in the final year, so include a full annual payment (conservative approach) in the period equal to the end year. The payment does not grow with inflation. For simulation purposes, we will ignore the fact that a portion of their retirement assets would grow at a different rate (loan rate) until the loan is paid off.

Taxable Other The value of all assets (except those with investment a cash reserve asset class) accounts assets entered under taxable other investment accounts - current assets should roll to the value "nonqualified" asset pool for simulation purposes. See section Changed wording "Determining rollup of investment class"
to be for an explanation of how to consistent with map the asset class entered to cash, fixed UI and or equity. Assets with a cash deleted note aboutreserve asset class will be excluded for cash simulation purposes.

reserve, since there is no longer a cash reserve asset class.

Taxable Other Annual contributions entered (excluding investment cash reserve savings) should accounts assets grow at modeled inflation rate. Should stop - at the owner's retirement age contributions (contribution should not be included in the period equal to the owner's Changed wording retirement age). If the owner is "Both"
to be clients, The contributions should consistent with stop at the first retirement. Should be UI and added to the "nonqualihed" savings deleted note aboutpool.
cash reserve, since - - From a programming standpoint, it is there is no easier to just say that all "Other longer a cash investment asset" savings stop at the first reserve asset retirement. Since any excess class. will get invested in "nonqualified" after the first retirement, the net effect will be the same so I am fine with this approach.

rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr Policies Life insurance Ignored for simulation purposes.
- cash value Life insurance Annual premium entered should not grow with - annual inflation. Should stop at premium the earlier of the policy termination date or the end of the projection. If an ownership type of "Other" or "Irrevocable trust" is entered, the premium expense should be ignored. - Added irrevocable trust since it was added as an option in the dropdown.

Life insurance See death use cases for an explanation of - benefit how the benefit will affect the death scenario. Summary ofuse cases - death benefit proceeds are added to the non-qualified asset pool.

Disability insurancePortion of the annual premium that the client - is paying should inflate at annual premium 3% ifthere is a COLA on the benefit. Ifthere is not a COLA on the benefit, the premium expense (portion of the annual premium that the client is paying) should not inflate. Should stop at the insured's retirement age.

APPENDIX C
Disability insuranceAny benefit from the client's disability - policies (note there are separate benefit entries for the benefit amount in the first year vs. following years) would be added during the assumed period of disability (up to the benefit end date entered for each policy). The annual benefit entered should be inflated at 3% if there is a COLA on the policy. Otherwise it should not grow with inflation. If the % of premium that the client is paying is 0%, the benefit is fully taxable. Otherwise no taxes should be applied to the benefit.

Long-term care Annual premium entered should not grow with insurance - inflation and should annual premium continue until the end of the projection.

Long-term care Any benefit from the client's long-term insurance - care policies would be added benefit during their assumed long term care stay.
If the benefit period for a policy is less than six years (assumed long-term care stay), we can stop the benefit after the term of the benefit period entered. The annual benefit entered should be inflated at 5% ifthere is a benefit increase option.

Otherwise it should not grow with inflation.
A portion of the benefit may be taxable. See the long-term care use case for details.

lrllllllllllllllllllrlllllllllllllllllllllllllllllllllrllllllllllllllllllllllll lllllllrllllllllllllllllllllllllllllllllllrllllllllllllllllllrlllll Living Expenses Prior to the first retirement, use the annual living expense number that we back into via the formula. At the first retirement switch to the estimate of retirement living expenses entered by the advisor (for the Proposed, use the product of the retirement living expenses entered by the advisor and the % change selected on the retirement living expense "slider"). Both expense numbers are in today's dollars and should grow at the modeled inflation rate.

uriiiiiiiriiiililiiiiirriiiriiiiiriiilliiuriiiiriiiiiriiiiiiiliiliiiliiiiulurii iiiiriiiiiiiirimrimiiriiiiiiiiiiiiiiiiimiriiiiiiiiiiiliri Goal Assumptions Cash reserve goalThe goal amount entered should be treated as an expense in the first - - Cash reserve period. Since it will always occur in the is now an first period, inflation does not explicit goal apply.
in the UI so it can be added as au expense in the simulation.

Accumulation goalThe annual amount entered (for the Proposed (note use the product of the that 2 accumulationannual amount entered and the % change selected goals on the corresponding may be entered) accumulation goal "slider") should grow at the modeled inflation rate and should be treated as an expense in the periods that it applies. It should start in the begin year entered and continue for the nwnber of years entered. Final year of expense would be in the period equal to the begin year + # of years -1.

Education goal The annual amount entered (for the Proposed (note that 4 use the product of the education goals annual amount entered and the % change selected may be on the education goal entered) "slider") should grow at the modeled inflation rate plus 2.6% and should - - The number be treated as an expense in the periods of children that it applies. It should start in the that can be enteredbegin year entered and continue for the is now number of years entered. Final essentially unlimitedyear of expense would be in the period equal (I think to the begin year + # of years the limit is 20).- 1.

Income tax goal Ignored for simulation purposes.
assumptions Average tax rate Used to calculate tax on income, RMDs, 'Sionqualified"
investment return, and "qualified withdrawals". Note that the same rate will be used for all goals.

Goal assumptions Usage is explained below.
for disability, death and long-tenn care APPENDIX C
Lifetime (happy) analysis Prior to retirement, just add to assets what the client tells us they are currently saving (using inflated savings amounts over time) and withdraw fiom assets to cover accumulation or education goals that occur prior to the first retirement. At the first retirement start looking at the difference between projected income and expenses. Shortages should be withdrawn from assets and excesses should be added to nonqualified assets.
SUMMARY OF DIFFERENCES FROM LIFETIME SIMULATION FOR THE
PROTECTION GOALS
Disability analysis (See the Disability Use Case for more detail) The client is assumed to be disabled for the first twelve years of the disability projection.
(The preference is to show 10 years of full disability followed by 2 years of partial disability. We realize that the 2 years of partial disability may not be feasible fiom a scope standpoint though.) The disability period should not extend beyond their retirement age though.
During the twelve years of assumed disability (this is for full disability -additional adjustments can be made if we implement the two years of partial disability):
The current annual living expenses are adjusted according to the % input for the disability goal assumption. In a two-client case, if the other client is retiring within the first twelve years of the projection, then at the other client's retirement age the simulator would switch to the retirement living expenses entered. The retirement living expenses would then also be adjusted according to the % input for the disability goal assumption until the end of the assumed disability period.
Any new source of income in the event of disability (entered in goal assumptions) is added. - Note that this income applies during the period of disability. This income is assumed to be fully taxable and should grow at the modeled inflation rate.
If the advisor chose to exclude accumulation or education goals in the event of disability (via goal assumptions), those goals should not be added as expenses (should not be included in the disability simulation regardless of when they occur - during the assumed disability or after).
Any benefit fiomthe client's disability policies (note there are separate entries for the benefit amount in the first year vs. following years) would be added during the assumed period of disability (up to the benefit end date entered for each policy). The annual benefit entered should be inflated at 3% if there is a COLA on the policy.
Otherwise it should not grow with inflation. If the % of premium that the client is paying is 0%, the benefit is fully taxable. Otherwise no taxes should be applied to the benefit.
The disabled client's earned income (employment, self employment and bonus), the disabled client's retirement plan savings (employee and employer), and all taxable account savings should stop during the assumed disability period.
The premium expense should stop on any disability policy of the disabled client that has a waiver of pr emium on it.
After the twelve years of assumed disability:
The client's earned income (employment, self employment and bonus) and retirement plan savings will start back up at the amount entered in data input. The income should APPENDIX C
not inflate during the DI period, but should start growing at the modeled inflation rate after the assumed disability period.
The taxable account savings should start back up at the inflated value.
Any disability premiums that were waived during the disability period should start back up at the inflated value (if inflation applies due to a COLA on the policy).
The living expenses should no longer be adjusted by the % input for the disability assumptions.
Any new source of income in the event of disability should be stopped.
Summary of how to aiTive at the five levels of disability insurance to simulate in the proposed:
The first time the advisor enters the analysis hub, the slider will be defaulted to the maximum value. The five points simulated will be 60% of the max, 70% of the max, 80%
of the max, 90% of the max and the maximum value.
- Due to the way the UI was manifested using the Add policy feature rather than a slider, the proposed will have to default to no additional coverage. Therefore until a policy is added in the proposed, the five points simulated should be: no additional coverage, 10%
of max the client is eligible for, 20% of max the client is eligible for, 30% of max the client is eligible for and 40% of max the client is eligible for. The amounts calculated should be used for the benefit in the fn-st year and the benefit in the following years.
- Making changes below to be consistent with the way the UI was manifested (Add policy feature rather than a slider).
We never want to simulate a point higher than the maximum value on the slider that the client is eligible for. Therefore, the following rules should apply when something other than the maximum value is selected on the slider after a policy has been added in the pr oposed:
If 110% of the amount selected on the slider of additional coverage recommended in the proposed exceeds the maximum value that the client is eligible for, the following points should be simulated:
70% of slider amount additional coverage in proposed, 80% of slider amount additional coverage in proposed, 90% of slider amount additional coverage in proposed, slider amount additional coverage recommended in proposed, maximum value on slider that the client is eligible for Else if 120% of the amount selected on the slider exceeds the maximum value, the following points should be simulated:
80% of slider amount additional coverage in proposed, 90% of slider amount additional coverage in proposed, slider amount additional coverage recorrnnended in proposed, 110% of slider amount additional coverage in proposed, maximum value on slider that the client is eligible for Else the following points should be simulated:
80% of slider amount additional coverage in proposed, 90% of slider amount additional coverage in proposed, slider amount additional coverage recommended in proposed, 110% of slider amount additional coverage in proposed, 120% of slider amount additional coverage in proposed APPENDIX C
Additional cover age r ecommended in the pr oposed is the benefit amount in the "Fir st year" and "Following year s" field (i. e. if differ ent amounts wer a enter ed for the fir st year and following years, different amounts should be used for the four other points simulated with the percentage increase or decrease applying to the amounts entered in each field).
- Note that the premium entered for the new cover age in the proposed can be used in all five simulations. Even though we will be changing the amount of coverage in the five simulations, we can just use the same premium as it would be difficult to arrive at a rule of thumb to adjust the premium expense. Since the preretirement living expenses are reduced by the amount of the new premiums in the proposed, this assumption should have a minimal impact on the probability. - Before any policies are added in the proposed, we will just have to use $0 for the premium in the five simulations (no additional coverage, 10%
of max, 20%
of max, 30% of max and 40% of max).
Lonb term care analysis (See LTC Use Case for more detail) For a one-client case, the client is assumed to spend the last six years of their life in long-term car e.
For a two-client case, during the last twelve out of thirteen years of the simulation it is assumed that one of the clients will be in long-teen car a (six-year stay followed by one year break followed by six-year stay).
We will never assume that the client enters long-term care prior to retirement though.
This could result in a shortened projection period for long-temp care. See the use case for details.
The simulation for the long-team care analysis is the same as the lifetime analysis up until the staa~ting period for long-term care. At the starting period for long-term care:
The retirement living expenses (amount entered in data inputs for Current or amount entered in data inputs * % change selected on retirement living expense "slider" for Proposed) are adjusted according to the % input for the long-temp care goal assumption.
The cost of long-term care (entered in goal assumptions and inflated at 5%) is added as an expense (does not apply during the one-year break for a two-client case though).
Any new source of income in the event of long-team care (entered in goal assumptions) is added. Note that this income applies during the assumed long-term care stay (last 13 years for 2 client, 6 years for 1 client). This income is assumed to be fully taxable and should grow at the modeled inflation rate.
If the advisor chose to exclude accumulation or education goals in the event of long-temn care (via goal assumptions), the goals occmTing within the period of the assumed long-team care stay (last 13 years for 2 client, 6 years for 1 client) would not be added as expenses.
Any benefit fi om the client's long-temp car a policies would be added during their assumed long-temp care stay (for the benefit period entered for each policy).
The annual benefit entered should be inflated at 5% if there is a benefit increase option.
Otherwise it should not grow with inflation. A portion of the benefit may be taxable.
See the use case for details.

APPENDIX C
The premium expense should stop on any long-term care policy that has a waiver of premium once the insured client has begun their assumed long-term care stay.
Death analysis (See death use cases for more detail) Incomes, savings and expenses tied to the decedent would be gone. Any assets passed to charity would also be gone. Assets passed to "Other" for a two client case would also be gone.
Any instuance proceeds would be added to non-qualified assets.
Living expenses are adjusted according to the % input for the death goal assumption.
For a one-client case, the % applies to curf°erat living expenses (amount backed into via formula on input screen). Retirement living expenses never come into play for a one-client case. For a two-client case, the % input for the death goal assumption applies to cur~eoat living expenses prior to the survivor's retirement age after which the % applies to the retirement living expenses entered. In the proposed for a two-client case, as the retirement living expenses are adjusted via the retirement living expense "slider" the input for expenses for the death goal would then apply to the adjusted retirement living expenses. Example Current annual living expenses input - $30,000 Retirement annual living expenses input- $25,000 adjustment to expenses for death - 70%
adjustment to retirement living expenses via the Proposed "slider" - 85%
For a one-client case, use $21,000 ($30,000 * .70) for living expenses in the current and proposed.
For atwo-client case - current scenario use $21,000 ($30,000 '~ .70) for living expenses prior to the survivor's retirement age and $17,500 ($25,000 * .70) thereafter.
For a two-client case - proposed scenario use $21,000 ($30,000 * .70) for living expenses prior to the survivor's retirement age and $14,875 ($25,000 * .85 *
.70) thereafter.
Any new source of income in the event of death (entered in goal assumptions) is added.
- Note that this income should continue until the end of the projection. This income is assumed to be fully taxable and should grow at the modeled inflation rate.
If the advisor chose to exclude accumulation goals in the event of death, those goals would not be included as expenses.
If the advisor chose to exclude education goals in the event of death, those goals would not be included as expenses.
- Note that the pr emium entered for the new life insurance coverage in the proposed can be used in all five simulations (Jeffs section explains how to arrive at the points to simulate).
Even though we will be changing the amount of coverage in the five simulations, we can just use the same pr emium as it would be difficult to arrive at a rule of thumb to adjust the premium expense. - I realized today that the issue of the premium to use for the other four simulations is a moot point, because the premium has no impact on the death scenario. The insured dies today, so the premium does not carry forward into the death simulation. The premium that is desir ed for the lifetime simulation is the premium associated with amount of coverage actually recommended and that premium will be entered by the advisor when they enter a new policy.

APPENDIX D
Title:
Simulation: Simulation Cashflow Definition-Incomes #71 Parent: Simulation Cashflow Definition #69 Referenced Sections:
Income section #12 Income Tax section 10 Estate Processor for Survivor section - #12~
Social Pension: Overview #125 Social Pension: Calculated Old Age #120 Social Pension: Calculated Survivor #122 Long Team Care Social Benefits #127 Risk Goal Assumptions #88 Summary:
The system 100 will set up the income cashflows used in a simulation run for a goal simulation. Each income cashflow represents the net income or after-tax income that is derived fiom a data entry income type (See the Income Section #12). Since the tax is removed from the initial amount being simulated, there is no tax calculated on incomes during simulation.
The system 100 will include the after-tax cashflow amount to the total income for the period that is added to the regular_asset_simulation~ortfolio, specified by the Model Portfolio Requirements which represents the clients' non-retirement existing assets, if 1) the cashflow start~eriod is less than or equal than the simulation period currently being processed AND
2) the cashflow end-period is equal to or greater to the simulation period currently being pr ocessed.
Whether an income is included in simulation is dependent on rules specific to the goal being simulated.
The start~eriod and end~eriod of an income included in simulation are based on rules specific to the goal being simulated.
The income is inflated based on sections specific to the INCOME_TYPE, not the goal being simulated.

APPENDIX D
Details:
1) bonus income - for each income:
Localization - the Bonus income type should be r emoved as an option in the Data Entiy section; since simulation doesn't do anything specifically related to bonus income but pulls them in when it asks for Employment incomes, there will be no required simulation changes.
2) dividend income - for each income:
The system 100 will not include any dividend income for simulation purposes.
3) employment income - for each income:
~ the system 100 will convert the employment_income-gr oss-amount to an amount based on the simulation fiequency and the employment income fiequency ~ the system 100 will simulate the after-tax income amount that is calculated by the formula:
converted employment_income-gross amount -(converted employment income-gross amount * average tax rate) ~ localization section: there are no business specified deduction made to the employment_income-gross amount prior to calculating the net income such as employee contributions to qualified/retirement plans or pre-tax deductions:
~ the system 100 will inflate the after-tax amount based on a stochastically determined inflation rate for each period except the initial period Additional feature:
There is a section that different tax rates are used for the pre-retirement and post-retirement periods. The tax rate used for the pre-r etirement period would be client specific and would be the client_tax_rate_entered ( see the Income Tax section 10). Having two different tax rates means that for the disability goal and survivor goal, an employment income could be represented by two cashflows 1) pre-retirement employment income: start_period of analysis start~eriod;
end_period of period prior to retirement_sta~-ting_period 2) post-retirement employment income (assumes that the client retirement_start~eriod of the disabled_client occurs prior to the client_retirement_start~eriod of the non-disabled client): start_period of retirement starting-period; end~eriod of client retirement start-period of payee payee refers to employment income~ayee ::,'.':!:,'y;::':v::i'v:::; i::;:;:':::':::<! ::::::::::::::::::::::~:!::~:::
:::: :::::':::::::::::~:::::::::
::::::::::::::::!::::;~:::.::::::::::::::::::::w:::::::::::::::::::::::::::::::
:::::::::: :::::::::::::::::i:' ...... v ........................................................
::: : :v:::.
.........:.... ...... ... :::::::::::.
.... . . ...... ...... .......:...................J...... ....
....
: :' ...............................................;..........::::::::::::
..........
: .': ..: ...: .......... . ... . . ...
: ::h:':i:v:;:::: !:'.': : .: : :": .......... . . . .
....................
.....:;..~:::.~:::::::.~:::::::............. .~. . . .:::
:::::: :v::::::::::::::::::::::.::.... . ~ . . .
..::::.:.......::n;.;;4:4:-:4:9 ........ .
:.~::::0::4:0:4::i::
:. . : , .. . .. . . ............. ::. . . . :::
. . .~::::::::::::::::::::::: . : . .d.~::
:v: ::::::::::::::::::::::::.:..............: :..............
.. a . ......:::....::::.:::..:::.::.::::::...:.::::.:.:::.:::.::...........
end aer~o .
:
!' ::i:
.'~
>.
!
' ~
:
:~:O:::::~:::::::::::::
.
.
..
..::
.;
'.
.
, .
::::::::::::::::::::::
..:sia..t ac gad it ment startineriod rior ~' ::'"'~y'~E:'"es if client retirement ret a to start eriod _ g_ _ _ _p P

': ' ' client retirement :::::::::::::::::::::::::::::: of payee is greater period _ _ tlian v ' . . r eriod of : : retirement_startmg_period sta t_p .........................

:::::::::::::::::::::::::::v a ee :::>:::::~::>:::::::
~'I'~'.'..'..'.:..'..'..~ same ifetime same as Lifetime same as L

Ti~l~aTi~": es if a ee is not the first same as Lifetime .:;::::.:::;:;::;::.:;:~';:disabled client period :: y p Y of ~ ~: simulation based on :::::::::::::::::':;:::::::: is .... . start ..........:.. date ..... anal s '~~''~'v'v''es if ee is the survivorfirst same as Lifetime ~iit~:~:<:Y p Y eriod of p '~<~ simulation based on :::::.:::::::::::.~::::::: anal :':::::::::::::::::::::; s is start date 4) occasional income - for each income:
The system 100 will not include any occasional income for simulation purposes.
5) miscellaneous income - for each income:
~ The system 100 will convert the miscellaneous_income cash_received and the miscellaneous_net_taxable_income to amounts based on the simulation fiequency ~ The system 100 will simulate the net income amount that is calculated by the formula:
converted miscellaneous_income_cash_received -(converted miscellaneous_income net_taxable income * average tax rate) ~ The system 100 will inflate the amount based on a stochastically determined inflation rate for each period except the initial period Added feature:
There is a section that different tax rates are used for the pre-retir ement and post-retirement periods. The tax rate used for the pr e-retirement period would be client specific and would be the client_tax_rate_entered ( see the Income Tax section 10). Having two different tax rates means that for the disability goal and survivor goal, two different cashflows may be defined:
1) pre-retirement pension income: start~eriod of analysis start~eriod;
end~eriod of period prior to retirement_starting~eriod (assuming the year miscellaneous income_ends occurs after the first retirement) 2) post-retirement pension income: start-period of the retirement starting~eriod;
end~eriod of year miscellaneous income ends year end refers to year miscellaneous income ends;
payee refers to miscellaneous income_payee APPENDIX D
~~ti~ included if periodgreater of lesser of yearend of period ,,",,,,,,",,,,,.,,,,".":..,,,,yearend retirement_starting_periodor :. retirement_starting_periodor year begin last_simulation_period :~";~:~:::::::::::::::::::same as L
ifetime same lesser of yearend period '',.','.'.'";''''.,'.; nfinem ent_en d_p erio d .:.
:: of a ee :::::::::::::::::::::::.

y~~ak~ili~yyes first period of same as Lifetime simulation based :::::::::::;:::::::::::::;:::::::: on anal s '::::::::::::::::~ y is_start_date es if a ee is first eriod of simulationsame as Lifetime survivor based Y P Y p :::::::::::::::::::::::::: on anal s :::::<:<:~v Y is_start_date 6) company benefits income - for each company benefit income:
a) handle lump sum income ~ The lump sum income company benefits_retiiement_allowance_net amount is to be received in the period of the company benefits_retirement_allowance~ayment_age.
~ The lump sum is special in that it affects asset balance in the lifetime simulation even if it occurs prior to client retirement_start~eriod of the company benefits_payee.
~ The system 100 will simulation the company benefits retirement_allowance_net_amount, which is the after-tax amount ~ The system 100 will inflate the after-tax amount payee refers to company benefits-payee :::...::::.:..
:::::..:::.~,:::.::.,....:::::::::.:.~..~::::.:::::::..::,:::~:.::::.~:::.:::.

~n..:,;::::..~:::..:::.::.:..:.:>::.::.,..::.::::.:.:::.::..::::.::.::.:
:.::::.:::::::::~~~~:1::~.~~i~:v:ri::::::::::a ~~:r~:::::.~~w.>.r~:~:.~:::"';,:::::'< '::;~,,,:;::;::,1.~,d,,:>::::><
:v~~~:::::::::::: tt ~
~::::::::::::._::::::::::::::::::::::::.~:::::::::::::::::::.::::

::;::.::.:~:'~::~.~;::::::::::::~:es the er :i~~tiatz~~';:;::y p iod of same as start_period the ,.,, ;,: company benefits_retirement_allowance_pa .; ............................

::::::::::::::::::::::.~::::.; ment a a ..........

. ....
........... es same same 1~'f ..
.....

.... ....
. s am a s am a .............
Ii~~ik~i~y :::::::::::::::::::::'...:es i ~::::::::::::y ~f Payee ::::<:::::::::::::::::::~:::~:

:::::::::::::::::::::;:::::::non-di :::::::::~<:::::::::::.:::::::;::~sabled :::::::.:::::::::::::::::ien :~~~~'S~:4~:~::::::~:es i ::::::::::::::::::w:;:,y ~f payeesame same :

: .:::ia i or :
:::::~:::::::.:

b) handle pension-like income ~ The system 100 will convert the company benefits-pension_gross amount based on the simulation fi equency ~ The system 100 will calculate the after-tax amount as follows:

APPENDIX D
Converted company benefits-pension_gross_amount -(company benefits~ension_gross amount * average tax_rate) system 100 will simulate the after-tax amount The system 100 will inflate the after-tax amount based on a stochastically determined inflation rate for each period except the initial period.
Added feature:
There is a section that different tax rates are used for the pre-retirement and post-retirement periods. The tax rate used for the pre-retirement period would be client specific and would be the client_tax_rate_entered ( see the Income Tax section 10). Having two different tax rates means that for the disability goal and survivor goal, two different cashflows may be defined:
1) pre-retirement pension income: stai-t_period based on year_company benefits~ension_begins; end~eriod of period prior to retirement staz-ting-period 2) post-retirement pension income: start-period of the retirement_staiting-period;
end_period of year company benefits_pension ends payee refers to company benefits-payee :::.,~:.:::::::.~::::::::::..::::::::::.
:::::::::::.,..::::::::::::::::.~::::.:::. ;-;.::::::::.~:.:~::::::.:::::::::::::::::::::::.
:::::::::::: ::.::
:.::::::::::::::::::::::::::::::::::::::::::::::::::::::.
:....................En ... : .
............................:.....:.:::::::::::::::: :.
ai::::::::::.::::::::::.... ... . . . ...
........................................... ...
..............................:
..................., ei.i,is.4~n..::.;.::::.:::.~:::.~:::::::::::::::::::::::5...:.:.:.:
..:::::::::::.::_::::::::::::::::.~::::::::::. .::. ..:..:::::::::::::.:::
.................................................................. ..
.t:.~rG.:. . a d... . . .
:~l' ~a~...........................................
.................................
~...................................................n.....
.er.~Qd.................................

:;.'':''''''"> es if t a ~,jfi~t~...rn.~............;;y h greater of the periodperiod of of :::::::::::::::::::ear co y _ mpany_benefits_p year_company_benefits_penyear company_benefits a n s :,;,;,;,:,;,;,:.;,;.;.;:,ion ends sion_begins or _pension ends :....:..::..:..:....:..:..:..:..::....::....::.

'''''.'''':~'''''retirement startinret' a a t ' ' er'o it m n startmg_period ................................_ g_p ~
::::::::::::::::::::::::::::::::::::::::

................................

:~'~v ~ same lesser of ::>;.::::: a ::::::: y ar_company_benef :v:::: ::::: its :...:...
:::::::::'::::::::::':::::
:...::..:..::....::....:::..:.:::.:

::::::::::::::::::::::::::: _pension ends or .::::::::::::::::::::::::::::~::: confi ::::::::::::::::::::::::::::::::::::::::::::::::::
'nement end_perio ::::::::::::::::::.~:::::.~::::.same as L
:::::::::::::::::::::::::::::::::::::::ifetime d of payee f~v~vl~i~i~:': eriod of a ' ' a :::::::::::::::::::::~::::::::::::: P sam as Lifetim ::::::::::::::::::::::::::::::::::a s -;;;:;::;:;::;;;;;;::::::;:;;y if payee non year company_benefits_pen disabled ,vvv vvclient sion be ins 5~,~!....~f.....:....... period of same as Lifetime : .
:
:
.
.:

::. :::. year p Y
, ::::.: c m an _benefits_pen :::::::::
::::::
.
.:
:':'<:::::::v::::::::v::::::::

::::.::::.::::: es if a ee is sion be ins :.::survivor c) handle death benefit The death benefit_amount is not addressed by the lifetime, long term care, or disability goal.
However, it will be dealt with in the survivor goal through the estate processing (See Estate Processor for Survivor section - #12~).
~) Social~ension - for each income:

APPENDIX D
a) handle retirement pension:
~ The system 100 will simulate the cashflows determined by the Social Pension sections (#120 - 122, 125) ~ The system 100 will inflate the calculated amount based on a stochastically detemnined inflation rate for each period except the initial period.
Payee refers to social pension payee :::.::::~.::::::::::::::::
;::;::....:::,:::::::::::::::~_.::.::::::::::::::::::J;:::::::::::....:::::::::
::::::::::::::::::>:::::::::::::::::::::::::<;::::::::::::::::;:::.>:::::::>:::
:::::::::::::.:>::;;:..,..;:::::::::::::::::::::::::::::::::::::
:::.....,.:....; : :.:::::. ..::: :.::.:>:. .:;:: :
............... .:;:::.:..:.:....:.:;:>::..:...,~. ...
::;:;::.:;:;::.::>...;...;:;::.::.:;:::....:.... ::::::::::::::::::;::::::
. . .......,.....................::.:: ., .... . :
........................................
. . . . . . .. . . . ... . . . . .::. . 7.1.
.f~........................................
. . . . ............................. .
.................................................., . ~11G~1T~l~f.il.:.~:::... . . . : .::: . .
............. :.::::::::::::::::::::. . .
..........,........................................:.
~.a~.:::: :. ~. I' .... . I. .
::::.::: . .
...................................................
:.

1i~~ti~ueves if meets reater of the start based .........................rules in year period on Y Social Pension .~:.._,#120 determined by the Socialrules Pension .....:::.......:......::.
Requirement or ''"'v''ww'~wv'''''" irement startin eriod :...:.,..:..:.:...::..:..:..::..:.. ret im based ~:<T:~'''"';: yes 'f meets same as Lifet a on ..........:::::::::::.... rules in Social Pension v rules ::::::::::::::::::::::>:::;:: # 12 0 and "'; confinement_end-period : of :
:::

:
... a ..: ee .....
........................
;:::.::.:::::::.:>:;:;:;:>::.:

~' in d b the Social based ~'~''_' yes if payee period determ a y on ~i~i?:x~~:~~.,.,.,; is non- Social Pension ::;:>:::::.::.:
....:;::;;: 'sabled clientPension Re uirement rules > and q d1 :::::::::::::::::::::;:: 'n # 120 :..:..:..:..::..:..:..:......::..,..: meets rules r 's and # 121 ri etermined b the based ~;::::~:::r,:::;::::::::::::: f a ee is Social on ~:~:~~:~ Yes p Y pe od d y Social '::: Pension ::: survivor and Pension Requirement rules meets ';':';;;;;:;"~' rules in #120 and :::::::::::::::::::, # 12 2 Social Pension- disability pension ~ The system 100 will simulate the cashflows detemnined by the Social Pension sections #121 The system 100 will inflate the calculated amount based on a stochastically determined inflation rate for each period except the initial period.
::::.:::;:.:.:::::._:::::::....
.. . ................................ ............................
::~:::::.;.:.:.v:::::::::::::. ............................:.
:::::..~::.~:::.:;.::::.~:::::::::::::::::::::.::
.. .... ............ :::::::.:..... :.::::::.~::::::
:.::....:. : :.:.,....:.:::::::::::::::::.::.:............ w::.::.
:.::::.:::.:,::::.:;:>:::.::.::.::;:>::;:
::::::::::.~:.. :.:::::::::::::::::::..:::::::::::: ::.:..:. :..;:
.... :::..::::::..::::.~::::::.::::::::.:::::..:,:::~::~::::~:~:~:::~:~:.:
.:;:::.:::.::.:::....:;::;
.:.::::::::::::.~:>.
....::::::::::.,::.::.:.~::::::::::::::::::::::::::.~:::::::::::.:::::::::::..:
::.::::::.::.<.::,:::::::::.v:::::::::::::::::::::::::::n. ... ~ .r1.
:~"~.t:oa.l.:::;:~:;:.:;::>:;.. ......: .:.: .
;::;::.::.:......:::>:;::.::...::.~::.:~.::...:...:.:.;:.;;,,..; ,.~
..;;..:,..::. ....................
.1~1~.1~s~t~.n,~;_,::::,::.~:::::::::.: .:::::::::::::.~..:::::::::::::
::.::: ::..~:::: .. ~t .~.: ...
:.::::::::::.:::: : I:I c~.............................

::
t. o ..
.
................
.........
~.'~~t~.~rt.e..........

TC'~ no :~~.'::.::.v.'.:..::::::
led client and meetseriod determinederiod determined ;~ ~disab b the p Yes p Y

:::::::::::::<:?>vv':' #121 Social Pension b the Social rules m Y

:::::::::::::::'': .
:::::::::::::~:>:: Reqmrement Pension :::;::::::::::::::::::::::::::::: Re a .;';,:.:.:.:.:.:.~: irement ~i21'~a:::."v'~::::~:::no Social Pension- long temp care pension The system 100 will take the long term care benefit determined by the Social Pension sections #127 into account when determining the nursing home cost (see Simulation Cashflow Definition - Living Expenses #75) APPENDIX D
::::::::::::::::::::::::::::..:::::.~:::::::::::::::::.~:::::::::::::::::::::::
:::::::::::.:.::::::;::::::::.~::::::::.
::::..::::::::::.:~::.>::....::::::::::::::::...::
.. .. . . . . . . . .. ::::.::;.:.::::::::::::::::::::::.:.:::::.:::....' . . :.:.
. ........................................................................ . .
.............................. . f . .
Croal;::<:<::<..::::::;.Ive:1.u.siox~..:,:::;:;:...:>:::::::>::..::::;::::.:;::
::::::;:;:;:::.a.tnx:t;::
:ox.fed:.:::.:;:;::::;::::::.:::;:::.:::::::::::.~:::n~:.
.en.~l::.:
o.i.Lo.d.:::.:;:::::.::;:;<.::.

:.: ~:
::.~1~~:lio ..:::::::.
:., :
...
..~.::::::::.
1~~.
.

::::::::::::::::::::::::::es conf ;'f..':;:;:;;;;;"'.:;y inement start_periconfinement_end_ ::::::::::;::::::::::::::::::::::::::::;#::
' 11 .. od of client eiiod of c '........ 'ent :.
::
..:::.~.::::::::~lx'....:....>:::...
.. o ~ .i;
:,::, v.t.
. .t~
.s~::::;
l~.~sal~.
: t.5::::::::

....
.................no :': ':
::::' ~ :
::::::::

Social Pension - survivor pension ~ cashflows determined by the Social Pension sections #122 ~ The system 100 will inflate the calculated amount based on a stochastically detemnined inflation rate for each period except the initial period.
:.:...:::::::::::::::::::::;:.....::......:.:...:::.::;::....::::::::::::::::::
:::::::::::::::::::;:::::::::::::..::.::::..:>::.:::::...::.::::::.::.:.;;::.:.
:.:.:.....:....:::>:;:..:.:.:;:.:::;::
.... .... ... .:
.......................................................;:;:;::::;::;...>..:;::.
.:;...:;::.:: . . :..
.................~ : .... . .... .: . .. .,::. :::::::::::::::::::.:.::::.~.
.,. . ::::::::::::::::::.
::::::::.:::::::::::::::::::::::::::::::::.. .. ..: .::. .c ...:. .
:.: ::::::::::: :.:: . ...: . :::::::::,:::::::::::::::::::.1:
....::::::::::::::::
:.:::: ...
~nc.luslo.n.....................................................s~tnx~...
exm~L............................::.
~vs~rl............... . end... c md...................

~;:i~~:no :~:i2i:
;:

'T' < no .:.,..:..,..:::.
..:.~:...:..:......:::.::: no ~3:is~tbalx : r.::::

erio determined eriod determined ............................. b the y~~v if r i in n / r p yes su v v g spouse p d y a d o ': minor children Social Pension by the Social and meets rules ;;::""";;:":"'.;:;:;in #122 Requirement Pension ;;:<:,,;:::,;;::::<,:, irement :...::::av:::::::::::::::;:::::::::::::::::::
Re a 9) fixed miscellaneous income - for each income:
~ The system 100 will convert the fixed_miscellaneous_income cash_received and the fixed_miscellaneous_net_taxable_income to amounts based on the simulation frequency ~ The system 100 will simulate the net income amount that is calculated by the formula:
convened fixed_miscellaneous_income_cash_received -(converted fixed miscellaneous income_net_taxable_income * average tax_rate) ~ The system 100 will not inflate the amount Added feature:
Ther a is a section that different tax rates ar a used for the pre-r etirement and post-r etir ement periods. The tax rate used for the pre-retirement period would be client specific and would be the client_tax_rate_entered (see the Income Tax section 10). Having two different tax rates means that for the disability goal and survivor goal two different cashflows may be defined:
1) pre-retirement pension income: start~eriod of analysis start-period; end-period of period prior to retirement_starting~eriod (assuming the year fixed_miscellaneous income ends occurs after the first retirement) 2) post-retirement pension income: start~eriod of the retirement_starting~eriod;
end~eriod of year- axed miscellaneous income ends APPENDIX D
year end refers to year fixed_miscellaneous income ends;
payee refers to fixed miscellaneous income_payee '::::::::::::::::::::::::::::::::::::::jr::::::::::::::::::::::::::::::::::::.:
::::.v::::::::::.............;;'::::::::..................................:::::
:::::::::::::::::::::.~::::.~::::::::::::::::::.w::
. .. ::: ....,'.':.~:::::::.,. .. .., ..,; .;:::::::
.. , ' ... .. ....... .::
...;:::::::'::::::::::::::::::::::::::::::::....., ..,; .::::.~:::::::.~
.'.......~...;................................~.... . ...... ' , :;;.v.v.vv.vv:.::v:...:v.:.:.~::::::::::
...:. . . 'r.~: ~l :.;:.:..::.:L: . .. : :::: :
:::ut:a:': . '..................................... S ~ :~
..... .;::::::.~::::.:::':..:
.. .. ,.';.'..
~ T . ..................
.. .

a~e~'ii~~included if period greater of lesser of of yearend period ::::::::.?::::::::::::::::::::::>_ ::: year end : rement startin eriodr ; reti _ g_P
:
:
:
:
:
:
:
:
:
:

: retirement startinodor ear be ins last : err simulation : Y eriod : P g p : g :
:
:
:
:
:
:
:
::
':'::::::;:::::::::::::::::::::
::::::.:::::::::::::::::::::::

~:;p:~::::::::::::::::same as L
t:: ifetime same lesser "''''' of ear end eriod o r .:.:~::.::~:.:~::.::,:~.:. a a v:v':v:v: a . conf . in . m . nt . nd . eriod . P
.
.

z _ :. _ :::::. of :,::.: a ::. ee .
.
.
.
.
,::.:::::::::::::.:.::.

~z~~~i~l~..yes first period of same simulation based as Lifetime '.'' on analysis_start_date ~'ui:z~ivi~a~~es if is survivor first same as Lif time :::::::::::::::::::::::::::::e riod of imul tion a Y Payee ba ed P s a s ....................... on analys :::::;:::::::::::::::::::::::::::::: is start date 10) additional_income:
This income represents additional income in the case of a protection goal (See Risk Goal Assumption section #S~).
~ The system 100 will convert the additional income (disability_additional income, survivor_additional_income, long_term_care additional_income) to an amount based on the simulation fiequency The system 100 will simulate the additional_income that is an after-tax amount ~ The system 100 will inflate the amount based on a stochastically determined inflation rate for each period except the initial period.
Additional feature: SYSTEM 100 rules around the disability and survivor additional income end-period are different (end-period is last simulation~eriod) APPENDIX D
:....:..:.,:.:
~~::..::...:.:::.:...::::::::::::::::::::::::::::::::::::::::::::::::::::....::
....:: ;,...:..~: :...:.:.. :::.:....:.:..;
:::....::....::::::. . ..
................................................<:::::.:.::.~,::::.: .: .::::
:....;::.::..:.::.::.::>:;::.:;:;:;,:;::.:;:;:;:
:... . .
................................................::::::::::::::::::::::...
....: ............................
. : .................::.:. : .. ... ..........
............ <..........:::...::::;;~;........
...:...:.::...:::.:::.::.::.::.:;::;:;:.....:::..:....:::.:::.:::::.:::::::::::
:::::::.~::::::::::
............ ; ~d.~t.... :::::...... ,f_,~, :1.::.~~e.t.o d . . :::......:::. :::::::.::.~o.d........
.......... ~, :~:i~~ttiii~>:no ;' y 'od of last simulation . es if pert eriod :: _ _p .
.

:::::..;:::.long : erm care additionalconfinement ::::: in start_pe ..
t ~...~.....~..~.~..~..~....~.come 0 iod of older client r ask~~~~~yes if first period Two client case:
' of period prior n b sed on to the :: disability_additional simulatio a income :':': > 0 analysis start client retirement date start_peri :::::::::::::::::::::::::: 'sabled client;
.:..:..::.:..;:..:::..::...:..: od of the no d ::::::<::::::::::::: Sm 1e Ghent: er <::::::::;:::::;::. ' g ' p iod prior to :::::::::::::._:::. the :

::::::::::::;::::::::::::: r erg :;.;;::;.;<;:::;:;::;:;::;;:
chent_retirement sta t_p od of disabled client 'iizz~~Q~es if additional first eriod Two client care:
death income of period prior ::::::::::::::::::::::::::> 0 'mulation basedto survivor's on si :;;;;;;;;;;~..;;;;.,....;;.,.;;;;;;, analysis start_date Tent retirement start eri c1 _ _ _p ::::::::=::::::.: ; Single client:

''':"''yv''~:':':"' imulation eriod ::::::::::::::: last s Outstanding Issues:

APPENDIX D
Title:
Simulation; Simulation Cashflow Definition #69 Childr en:
Simulation Cashflow Definition- Savings #70 Simulation Cashflow Definition - Incomes #71 Simulation Cashflow Definition - Business and Real Property #72 Simulation Cashflow Definition - Liabilities #73 Simulation Cashflow Definition - Goal Expenses #74 Simulation Cashflow Definition - Living Expenses #75 Simulation Cashflow Definition - Policy Benefits #76 Simulation Cashflow Definition - Pr emiums #77 Simulation Cashflow Definition - Adjustment to savings #130 Summary:
~ The system 100 will set up cashflows that represent client incomes, savings, liabilities, premiums, and expenses to use in simulation.
~ The cashflows that are set up are based on data entry related to incomes, savings, living expenses, and goal expenses ~ The cashflows in the_proposed may be different fiom cashflows used in the current due to modifications made by the advisor in Analyze ~ The system 100 will simulate in period increments based on the simulation period fiequency. This period fiequency is defined to be annual (See Goal Simulation Overview - #7~) so all cashflow will be converted to an annual amount ($1000 /month becomes $12,000/year) - for the remainder of this document, the conversion step will say that the amount will be converted to an amount based on the simulation fi equency D etails:
1) Set up the investment asset savings used in a simulation run The system 100 will set up savings cashflows based on client and employer contributions defined in data entry and modified in Analyze. During simulation, the system 100 will add the savings contribution amount to the clients' assets based on proprietary rules.
The system 100 will also set up certain savings expense cashflows based on client contributions defined in data entry and modified in Analyze. During simulation, the system 100 will subtract the savings expenses fiom the clients' assets based on proprietary rules.
see Simulation: Simulation Cashflow Definition- Savings #70 see Simulation: Simulation Cashflow Definition-Adjustment to savings #130 APPENDIX D
2) Set up the incomes fiom a Business or a Real Property used in a simulation run The system 100 will set up business income cashflows and the real property income cashflows based on businesses and real propeuties defined in data entry.
During simulation, the system 100 will add the amount to the clients' assets based on proprietary rules.
See Simulation: Simulation Cashflow Definition - Business and Real Property #72 3) Set up the incomes used in a simulation run The system 100 will set up income cashflows based on incomes defined in data entry.
During simulation, the system 100 will add the income to the clients' assets based on proprietary rules.
See Simulation: Simulation Cashflow Definition - Incomes #71 4) Set up the policy benefits/incomes used in a simulation run:
The system 100 will set up policy benefit income cashflows based on insurance policy data defined in data entry (or in Analyze). During simulation, the system 100 will add the benefit amounts to the clients' assets based on proprietary rules.
See Simulation: Simulation Cashflow Definition - Policy Benefits #76 5) Set up the liabilities used in a simulation The system 100 will set up liability expense cashflows based on liability data defined in data entry. During simulation, the system 100 will subtract the liability expense amount fiom the clients' assets based on proprietary rules.
See Simulation: Simulation Cashflow Definition - Liabilities #73 6) Set up the policy premiums used in a simulation run The system 100 will set up premium expense cashflows based on policy data defined in data entry (or in Analyze). During simulation, the system 100 will subtract the pr emium expense amount from the clients' assets based on proprietary rules.
In the case of universal life insurance policies, the savings portion of the premium (the universal_life_accumulation_fund~remium) is treated as a client savings for proposes of simulation.
See Simulations: Simulation Cashflow Definition-Premiums #77 7) Set up the living expenses used in a simulation run APPENDIX D
The system 100 will set up living expense cashflows based on data defined in data entry (or in Analyze). During simulation, the system 100 will subtract the living expense amount fiomthe clients' assets based on proprietary rules.
See the Simulation: Simulation Cashflow Definition - Living Expenses #75 8) Set up the event/goal expenses used in a simulation run The system 100 will set up goal expense cashflows based on data defined in data entry (or in Analyze). During simulation, the system 100 will subtract the goal expense amount fiomthe clients' assets based on proprietary rules.
See the Simulation: Simulation Cashflow Definition - Goal Expenses #74 Title:
Simulation: Simulation Cashflow Definition-Premiums #77 Par ent: Simulation Cashflow Definition #69 Referenced Sections:
Disability Policy #83 Estate Processing for Survivor Goal #128 Life Policy #85 Long Term Care Policy #84 Summary:
The system 100 will set up cashflows that represent client premiums to be used in a simulation run for a goal simulation. Each premium cashflow represents the amount that is derived from a client paid policy premium entry (See the specific Policy sections #83, 84, 85).
With the exception handling of the Universal Life policy accumulation fund, the system 100 will include the premium amount when totaling expenses for the period as long as 1) the cashflow start-period is less than or equal than the simulation period cuiTently being processed AND 2) the cashflow end-period is equal to or greater to the simulation period cuurently being processed.
Whether a premium is included in simulation is dependent on rules specific to the goal being simulated (See Estate Processing for Survivor Goal for discussion regarding how the life insurance policies of the decedent are handled).
The stas-t~eriod and end-period of a premium included in simulation are based on rules specific to the goal being simulated.

APPENDIX D
Details:
Assumption: refer ence to sur vivor in describing whether a premium is included in the survivor simulation, the survivor means the surviving client, either client 1 or client_2. In the case where there is one client, there is no surviving client, so no premiums would be included in simulation.
Localization: if there are no surviving clients, we include premiums paid by 'Other' in the survivor simulation. This is not done for System 100 1) term_life_insurance - for each temp policy:
~ the system 100 will convert the term_life_premium to an amount based on the simulation fiequency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will not inflate the amount Localization: handling of the payment disability indicator insured r efers to term_life_insured owner refers to team life_owner payment disability_indicator refers to term life~ayment disability-indicator :,.:;::::::<:::::~::,:;::.:::..::..::..;:.:;:;:.:....;;'-:::::::::::::::::::.::::...::;::..::.~~ .. her ;.,..::::>:::::::::::::::::
:::::. .: ....:...;:;:: . . . :god.............
~Tfla~...............~il.G~llS~~..ll..,..;::.:. errod :::::::.:::::::.:~::::;<:....;::::::::::::
:.:: :.::::::::::::.5~3.1'~::: .. ~.... ....
..............,..............................
:.:..::.. ~.....:.. ........................
:.. .:::.....:...........

Ilf~ti~iiees if owner retirement eriod rior to the eriod :::::::::::<:::::::::::is a client startin of _ g_ p p p Y

:::::::v:>::::::. . . . ' im rmination .:: and ifperiod period term life_premn to of _ _ : term life period (if ends at age ......................reminm_to 65, it ends the ....
..
..............
::::::::::>:::.>;::::::::
;;

::::::::::::::::::::::::::::
:;;;:::::::rmmation is period prior to owner .....,.........:........greater turning 65) .

........................
::::::;::::::,::.:.::::.~:. than :::::::::::::::::: irement starting .....................~...r et ::::::::::::::::;:::: iod :::::::::::::::::::<;:::::: er :;: : , 1 r f m ::: : game as Lifetimesame as Lifetimethe esse o the pe 'od ::::::::::::::;::::::: of the I<~'C:.::.:.

:::::::::::::::::::::~::::::: nfm m n n er ;:;;:;.:;..:.;>::::;>:;:.::
a a t a d iod of owner ~o _ _p :,:::::::::::::: or the eri : : p 'od prior to :
:
:
:
:
:
:
:' :
:
:

: term life_preminm termination :
:
:
:
:
:
:
:
:
:
v<v >.>.' la.I~~Ii~y'' yes if owner first period same as Lifetime is client of ..........~..~...........~...
insured is simulation unless based on ''.''''isabled client analysis start AND date <~ payment disability in ::::::;;:::::::;::::::::: ' 1 tlr~rici~'yes if owner first period same as Lifetime is survivor of ';~ ' simulation b ased on :;::::::::::::::::::::: anal sis start date APPENDIX D
2) whole life_insur ance - for each whole life policy:
~ the system 100 will convert the whole_life~r emium to an amount based on the simulation frequency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will not inflate the amount Localization: handling of the payment disability_indicator insur ed refers to whole_life_insur ed owner refers to whole_life_owner payment disability indicator refers to whole life-payment disability-indicator .................
...............................................................................
...:.......................
............................................................................
:~y::':';'<::..:::;.::.::.:,,,;'''v~<';::<::::::,.",,,;:.::.;;ii:;.;..~........
.
Goai...........Iixclusion.... .sta.i-1... '~riiliver~~ii .... ..... ..........~: . od ........
....: .
.. :

es if owner is retirement eriod rior to :::::::::::::.a client startin p p :::::::::: Y _ g_ '': and period period whole life_premium termination of "''y_y':y':'y""''''"' ' ' iod if ends at a a 65, :.::.::::.::..:;::.;:.:.::.;:.:;::. whole hfe it ends the remium er ( g vtermination eriod rior to owner turnip >:.~:::.~:.~:::::::.:is eater 65 ~:. ~' p p g ) ;.:',',;;''':,::retirement starting_p ;::::::::::::::::;~::::: iod ::.::.:<~:::::>::::::::: same as same as Lifet f'~'~~.:~:.~:.'.~:::Lifetime . ime the lesser of ~:.~ . .

:..:..:..:...::.:..:.:.:..::....
:... ...
..................... nement end eriod of owner conf _ _p ;;>;>:.;;;;;~.;.:.: or the period prior to ';;;;:'::v::;:;y': who e_ ife_premium termination <' e riod i~saTa~~i"~:yes if owner first period same as Lifetime .........is a client of ;;'.: :except if insuredsimulation is based on ~~ disabled client anal sis start AND date :;::::::::';pay a t disability in "~'"''""w'''"'' icator is indicated ~itr~tiSrQ:r:
:~: y if owner first period same as Lifetime is of :es .:..:..:::::..:::..::..::
.vor simulation ..:.. survi based on pal s :::::::::.:::::::::::::::; is start date ;;::.:.::.:>:..;;~:,.;.;:>;:;:

3) whole life_with_term insurance - for each whole life with teiTn policy:
~ the system 100 will convent the whole_temn_life-premium to an amount based on the simulation frequency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will not inflate the amount Localization: handling of the payment disability_indicator insured refers to whole_term_life_insured owner refers to whole_term_life_owner payment disability indicator refers to whole term life_payment disability-indicator APPENDIX D
:::::::::::::::::::::::::..:::::::::::::::::::::::::::::::::::::::::::::.:.::::
::..::::::::::::::::::::::::::::::::::::.~:::::::::::...:
:::::::::::::::::::::::::::::.;.::::::::::::::::::::::::::::::::::::::::::.,:::
::..:::::
;:":;:i:?::':~::::i:i:yy;.;v..:!?Y.Yf:::::Gi:?Jiv:v:Ji?iiiiii:::::::'::::::::::
:::::::;:::,'.,'':::::::::::::::,'.:::::::::::::::::':,'.:::i::::f::::':::,'.::
,'.:::::::::::::::::::::::::::::::::::::viii:iiiiiii:Jii:
. . . . . ........ . .J . .... .. . ... . . .
...........................................................
. ....................................... 1 . . .....................:.. #1.
:::. .~T:IO.rl:::::::::.::::::::.::.~.~::::::::.::::.:::::::.~:::::::::::
:.......:::.::::::::::............ . ..:.::.........r-~l...n Cro.a3::.:::.:::::::.... .:.~:::::......:..:::::::::::::::~.
..:::::.~::::::::::::.:
.Inclus~o.n:.~:::::,::::..:.................st,xtlt...
a.t.io.rl..................,.

~~~iz~x~es if owner retirement eriod prior to the period :: is startin of Y _ p g_ . client 1 or eriod whole term life_premium :: client 2 termini :,;_,,,,,,,and period of tion period (if ends at age 65, it ends <~~ whole term life the eriod prior to owner re turning 65) '''''''"""''''''''''''"ium_termination is ~s< r an greate th ...:..:..:..:.:...:....:....:..:..:..:.
:::::::::::::::::::::::::;::v:irement starting_p ret '~'.~''~~>''>eriod ''::''>..::::::::::;:::Li :T~TC':"~':'~:".:same as ~fetimesame the lesser ofthe as Lifetime '<
;;;,..;.:. confinement end_period of owner or the period prior to ,i.;.y.:, whole term life_premium termini :.,.::::::.:::::::.::::::. tion eriod first ;:';,::';;';''';;';y ' ' ' per same as Lifetime ~zsalazl~;.:::<es if owner iod is a client of v>:: ' ~ ~ .
~: except if insured~
is on simulation based ~::~,::::;;::::::::
~:: disabled clientanalysis AND start date :::::::::>:::::::::::::::
isabilit in piYment d Y_ .::..::....:..:..:dicator is indicated '''' tli'i'''~i~es if owner first same as Lifetime '~ is eriod ~~ Y of p ..:::::::::::::::;;sure '.. ivor simulation '~. based ::::::::::::::::::::::: on anal sis start date 4) universal life insurance - for each universal life policy:
handle the risk premium the system 100 will convert the universal_life_risk-premium to an amount based on the simulation fi equency the system 100 will simulate the converted amount if > 0 the system 100 will not inflate the amount Localization: handling of the payment disability_indicator insured refers to universal_life_insured owner refers to universal_life owner payment disability indicator refers to universal life-payment disability-indicator APPENDIX D
...............................................................................
...............................................................................
...........................::..:.;::::
.. .:.:.::.::
:.::.:.:~.:.::.:.::.::.::.::.::::....::....:.::.::.::.::.::.::.::.::.:.::~.;:.:
...:.,::::.:::::.::.:::~.......... .-~~..,:..:.::..:..::... .. . .
.:::::::::.::::::::::::::::::::::.~.::.::.:.::.::.::.::.::.:::.::.::.::.:::.:.:
:.::.:::.:.::.::.:.::.:::._;.::::.:::....:::::::::::::::::::::::::::::::.::::..
..,:.:..:.,..::....::::::;:::::::::::
~::::..:.,...~~,ylTl,&T0.~,1.:::::::........................... . .~: . .. ..
. ;:>: :~., . .:::::::::::::::::::::::::::::::::::::::.:._:::::::::::::::.
:. ..::;::.:;::;::,.:: ::::::::::::::.:::::::.~tltL... . G~:~O.
.
~".x~J.~l.:.: ~~'~1't... :.: ::.::::. :.:: :::::..::::::.:
:.......::.
~~.LU.d.......................:::...:.......:.............

~~~~ yes if owner retirement period prior to the is a client starting_ period of ::::::::::::::: lit s k remmm terms .,,,..,,;:,,,,,,,,.,,,...,.,,.,and period of period umversal_ a r s _p life nation period (if ends .. risk_ r at age 65, it ' nniversal '.v p ~

. _ ends the period prior .. _ to owner .. eminm termination :.: is '.'' :::::::.~:~:::~::::.:.:::.:::::agreater than turning 65) ::::::::::.::.:::::::::::::
'';';':'''','',;';'irement starting ret ::;;:::::<::::::::::::::::::er :::::::::::::::::::::'::sod '' same as Lifetimesame as Lifetimethe lesser ofthe ::::::::::::::::::::::::::::
'nement end eriod of owner confi _ _p :::;:::::::::::::<::~:
.:.':.:.:.:~ p ~od prior to or the en ::::::::::::::::::::.::::: s k r mmm term universal life_r.s _p a ' _ .

l3id~i~ai..,yes if owner first period same as Lifetime is client of ...;:....:::.:;:;::.;::::.:.:;::~.
if insured is simulation except based on isabled client analysis start AND date :::::::::::::::::a merit d ::::::::::::::::::::::::;:p Y _ isability in ......<

i~~~ yes if owner first period same as Lifetime is survivor of ':y;'""~'y'~''~'"'"~"' 'mulationbased ;:.::.:;:;:;:>:;;.;:.::..:.: on si ''vr'i'> anal sis start date handle the savings portion of universal life premium ~ the system 100 will convert the universal life accumulation_fund-premium to an amount based on the simulation fiequency ~ the system 100 will simulate the converted amount if > 0.
~ the system 100 will not inflate the amount Localization: the premium of a universal life policy that represents savings insured refers to universal_life_insured owner refers to universal_life owner payment disability_indicator refers to universal life-payment disability indicator Accumulation fund premium handled as subtraction fiom regular asset_simulation~ortfolio (premium expense):
accumulation fund premium handled as addition to regular contributions simulation~ortfolio and treated like a savings:

APPENDIX D
:.~.............................................:.:.::.:~:::::::::::::::::::::.
.:::.::::::::::::::.:::::::::::.~::::::::::::::::::::::.~::.::::::::::::.::::::
::::.,..~:.::..:::.::.:..::.:.;:.:.~:..z:::::::::::::::::::...::...::...:::::::
:::::
:::><~:~:~::::::::::::':v:>:~':~':w~::'>..:::::::::.:::::::::::::::::::::::::w:
::-~~:::~::~<:':;:~,::.,,,..,;::::::::::::::::::::::::.::,,.";.,..........;..::.:;
.,~.~.:.,:,::::::::::::::~:::::::::;:::::::::;:;:.:::
..o. .t. . . . .s.t. ~ x a r ~ d a ~ .
.....:.......... ~ . ~ .. . n ~ ~~.., d .~kf~~~rit~..y a s f t r s t p a r t p p r t o r t o o d o f s t m a a I a t t o n r t o d clientretirem ent start b a s a d o n _ _ _ anal sis start date .
eriod of owner '''>:' . , a as lifetim a L.f:.G:::.::::::::::.es sam a as lifetim sam a ~j~~~E7j~yyes if owner same as lifetime sameas lifetime is # c ' a t a n I a s s Ii n ::.::.:,.::.::::.:::.::.::.::.::::.:
:::::::::::::..............~ s insured ~ s a b I a d c I t a n t %:::::::::::::::::::::v::':,.a n d ..........................

::::::::::::::::::::::::::a t d .;:::.:.:.::.;:;>::.>::>;::..:.:p a Y m n _ is a b t I
t ':':'':":':':':Y _ t n d t ~:':':'':~':''c a t o r ..........................t s ::,:::.~::::::::::.;.:::::.s a t "'eu::i~::~i::C:::yes if owner same as lifetime sameas lifetime is <::::,~::::::::::v t n c I t t a n t s a r v 5) fixed annuity - for each fixed annuity policy:
~ the system 100 will convent the fixed_annuity~remium to an amount based on the simulation fiequency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will not inflate the amount Localization: this is considered an investment asset and the premium is treated as a savings.
insured refers to fixed_annuity-insured owner refer s to fixed annuity_owner :.:.:::::..:.:...:::::..:::::;::::::::::::::::::::::::::::.:....::.::::..::::::
:r :::::::::::.:::::.:::.~:~: ::::::::::. ::::::::..,..::
::::::.~:.::...:.., ...;:::.:.:_::::.:::..::::::::::::::::.~:::::.~:::::::::::.::::::::::::::::::::
::
:........;..::::.. :: ~ :::::::::::::::::::::::::.:::<::::::..:..::: .. n .::. . . .,.., ' <::::;;:::. . .:::. ::.::..:..:............
.....
:~11~'~'~115I0:1'i:.:::::.::::.:;:;:o:;:>:>::::::.::;:.:;::;;...::...;:...:::.:
::..:::: ..:::...:: ..:;:::.:..::_ ....... :. ~ ::::::.:.I'1..:: :::::::::
::::::::::::::::::::::::::::::::~::::::::::::
... ' ::::::::~::::.::.::.::.:;::. ::, .....
,;::::.::::;.:>:>:;:;:;::.:::.:::.:::.:;::>:::.:;:;:;:;:;:;:;:;::
.~.::::::.:::::: .....
~'.t~ix .

a riod of ri r o the rl~~ii'iieif owner is etirement startineriod o t ;::::::.::.:;:;::.:::.:::.::;::a client _ b_ p y P p ',:::;':;''';"and pe iod eriod of remium_terminatio P fixed annuit _ Y_P

fixed annuit n eriod if ends at age .....................,.remiu 65, it ends the ........................_ _P P
Y

:.: m_termination period prior to owner is turning 65) "''''''t r li n .........................grea a t a .:..::..:..::..:...:.:...::.::..::.
irement starting ret ::::;:;::::::::::::::::::::::::::, ::. enod ::
:::.:::::.:::::::::.

~Tv~,v~same as Lifetimesame as Lifetimethe lesser ofthe eriod ............. ofthe P

' '' inement end eriod of :::::::::: owner ::::::::::;::::::. conf _ _P

. or the period prior to ::::.:...:::.:, :.
:::::.

::::::::::::::::::::::: ' im t mm t :
:::;::::::::: it remit er ' at'o : fixed annu Y_P _ :
:
:

: n erio d :
:
:
:
:
:
:::::::
:.:::::::::::::::.

i~~~2i*'yes if owner first period same as Lifetime is client of 'mutation based on :.::::::::::::::::::>.::: anal sis start ::.>::::::::::::;::::::::<::::: date ~~il~~<:~~es if owner : is . ' ime : ~ p same as Lifet : y . first eriod .: of :
:
:
:
:
:
:
:
:
:
:

:? , .
: survivor , : simulation : based on :
:
:
:
:
:
:
:
:
:
:
:
'""'""~"' """"

a al sis start date APPENDIX D
6) endowment life - for each endowment policy:
the system 100 will convent the endowment_life~remium to an amount based on the simulation fiequency the system 100 will simulate the conveuted amount if > 0 the system 100 will not inflate the amount Localization: this is a policy type not included insur ed refers to endowment_life_insured owner refers to endowment_life_owner payment disability_indicator refers to endowment life-payment disability_indicator :..e :::.~:::::. :::::::::::::::::::.
::;:.:>::::::::::::::::::
::::.::.::::.::;.:::;::::.:'::.:.~:.':":'.':'::.':'.".:.':.'::.' :::::::::::::::::::::::::::::::.~::::::::::::.~:.
...o.al:r.::..:::..:..: : : ' :: :::.
......;.;.,.",,..;....;.....:>::~:.~:~:.:;~:.::.:::."::.:
:~. ::..:::::::::: ;,::.;;>>;:.
;::::.::.:::.:::.::::.::.:::::.::::.:;::;:::.:;::.:;:;:::.::.::~;:;:;:
:::~:::::::~:: ;:::.~::::. .'~''''~':':::'<::..::::;::... ; . .:::: :
rtt~:
....
..jn~I~us~Oir:..:..:..:..:..:..:..:...;.::.:.::::..:.~::.:::.::.::::::::.:;:>:;
:>::::;:::::::::::::::::::::::::::::::::::::::::::::::::::::::::
................ . ..................... t3 ; .::,.....~.. . ... ~...
.e.......~...........................................................
.................................~.' .::::::::::::::::.~:::
s.....~...
:~..x ..d..:..................

I>i~~~i~i~~ yes if owner retirement period prior to the period is a client starting_ of :::::::::.>::::::::::::..:::::::: :: n m ;::;;:..:::.;:..>::.:::.:::.::
~od of riod ndowment life remium : a d P a P terminat _ _P _ endowment life_prem ion pe iod (if ends at age 65, it ends ....................... . mm term .......................
_ ination is he period prior to owner . turning 65) ::::::::::::::::::::::::: . gi.eater than ..::..,,.;;:>:;:;:.::....;;...;;:. .. ret "r'~'''''''~~''''''''' : irement starting-p ........................ .

.,..................... .
... .
................. :. iod :~.>L:::.:.......:;:..:.::.: :~ er ;:::..:::::::~::~::::~::~:

>> m Lif im m Lif im the lesser of the eriod L,'.TC.............. . sa a as et sa a as et of the a a p ',:,:"'':: ' inement end_period of owner or the em <::::::::::::::::::::::: :: 'od rior to :::::::::::::::::::::::::::::: :

:':::::::::::: : en owment 1~
:'.;;'.:::;;;; d _ 'fe_preminm_terminat I?zal~aTak'yes if owner first period same as Lifetime is client of '~<<<''v' ' ' im 1 ion based ~ . except if on msnred is s a at ''::'.'::':'.'':'''.'.'.'. ' isabled clientanalysis start AND date - - _ 'v . . . , :_::~,:.;;.:~:'_':'": payment disabilrtyy : es i "~"""'"'''' " y ~f owner first period same as Lifetime '~"~ is survivor of t~.i:u:~
~:~:r::

"''"'w'~'w' 'mulationbased on ::~~:::~:''::~:~: ~ anal sis start date APPENDIX D
7) child endowment_policy - for each child endowment policy:
~ the system 100 will convert the child_endowment_life~remium to an amount based on the simulation fieeluency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will not inflate the amount Localization: this is a policy type not included in APEX
insured refers to child_endowment life_insured owner refer s to child_endowment life_owner premium termination refers to child endowment life-premium termination ~:::::;.:.::.:::::.:::::::::::::::::::::::::::::::::::::::::::::::::::.~...~::.
~:::::::::::::::::::...::::::::::::,:.:.:.,.:::::::
:::::::::::::::::::::._:::::::::::::.~::::::._.:.::.:.::::::::.:.:.:.:::::::::
:.:::::::...::::::.::
..~:::::::::.:::.:.::::::.::.:::::.:.:::,:.::.::.....:.:: :.:::.~:
::...~:~::::.:;::::::::::::::::::.~:::.~:::::::::::.~..:.:.::::::.::::::: ::
::.::::::::.~:::::::::::::::::::::.~::::::.~.:
:::::::::.. :.~:.:.:::...::.:::: :.,:
:..:,.::.:.:....>::.:.:::::::::::::::::::::
:.:~. ::.::::::::.~::::.~::::::::::::::::::.:.:. ::::. :::: :::::::.
:::::::::::..:::.
.. :.:..:. . . . . ..
:..:.:.,..,.:.::::::::::.~::::.~::::::..:::.::..:::.:::::::::::::::
:.:::::::::.................................... . ..............:.:::::
:... :... ...:..~. .... . .. . . . ... .
................................,..........................
. . .:.. :.:.:.::.:.;:.::.:.:.:.:.: ta: :. ~.:.:.:~;::e ~L::::.:er o:d:::.::::::::::::::::::::::::::::~:::::::::::::::
.:...:... .:..:d:::::::::::<::::
:..:...
. ::.:.:
:.
:::.:.::.:::::::.
al .

~~~~'~w~~i"yes retirement eriod rior to the eriod ...~.....~...;.if startin of owner _ g_ p p p is a client _ Y

' ' period premium termination period and (if period of : '' ends at age 65, it ends ~ premium the period . termination ~
~
~
.

:::::<:a:<:::::::::::::: m r rn .
:..:..:.:::::.,.::..:.:....:::is ~o to owner to ing 65) .... greater p .... than . . ...
..
..
..
.......

:::::::::::::::::::::::::::::::::::
::::::::::::::::::::::::::::::ret :::
irement starting-p .......................
:::::e::v::;::::vrod :
er :;:::::::::::
m im 1 r of lie eriod of the ~'~C'''L same as Lifetthe esse t p a :
sa a as ifetime 'vvvv~ ' ' n r of ner confinement a d_per od ow :
::>.:::::::::::::::: od rior to ::::::>,::::::: or the em ::::: p p :;::::::::::::::;::::::...::

::::::::::::::::::::::::::::<:
rum termination eriod rein 'l~i5a~iiTses first eriod same as Lifetime ~?' if of owner p is a client Y

::::::::::;<::::::::::: 'mulation ::::,:::::::;;:;:...:: based on ::::: si anal s :::::::::::::::::::::,::: is start date :::::::::::::::::::::::::;:

.~r~!l:~irp~.
yes first eriod same as Lifetime if of owner p r ~s :'':''.':''':: simulation :::::::::::::survivor based on ~:: :
~:::::

. . a al s . v: is start date 'v'v:v'''''v"''':v''''' APPENDIX D
~) disability~olicy - for each disability policy:
~ the system 100 will convent the disability~olicy~remium to an amount based on the simulation frequency ~ the system 100 will simulate the converted amount if > 0 ~ the system 100 will inflate the amount if the disability-policy-premium_increase_indicator is set ~ if the premium inflates, it will inflate at the constant defined by the DISABILITY PREMIUM INFLATION RATE (see Disability Policies section) insured refers to disability~olicy-insured ;:::.:::~:.:.:::::::::::::
.:.:::::.:.:::::~:.::::::.:>:::.:::::~::::::::.:;:::::::.::::::::::::;:::.:.:::
::::::>::.....::::...>::::.::::;::::::::::::::::.:::::;:::.:::
:
:::::::.,::::::::::::>::::::::::v:::
v:::.:.;:.::.;.:::;:::::::::::::::::::::::::::>>.:..::..:., :::::::.:.;::..:::...::,:::::..:;::::::.::::::::::>:::::;:;::::;:::.:::::::::
oa~:::;:~.:;::::.:;~z~:~~~i~~~~3 .,.;::.;::.:.,.::::.
::enil~'eiiail><
......... . .....,,,,::.::::::::.::::: .
. : ..
~~g~ .
er#~d ..
. .
.:... :..
:.::::::: ...........
: ...........................
................

Zj~ yes if the retirement period prior to stautin~per the i :: disabilit olic od disability~olicyy ....................~...remium_t emium . Y~ Y~ to -~v . . ' ' ' : ~ ei rrnnation i of insured > n rrrnnat o ::::;::::::::::::;,::: . ii a a t in ::::::::::::::<::::::::::::ei iod :.::.::.::,:;~:.:>;::;::;...::: m n start ; i et - _ ~'f same as Lifetime same same :':::::::'::: as as Lifetime Lifetime T~i~l~~liyes if the insuredfirst same is the period as of Lifetime simulation :':::::::::::::::::':::: nondisabled_clientbased on '' nal ....................... sis start date a guitaryes if insured first same .... is survivor period as . of Lifetime simulation ::::::::::::::::::::::::. based on ::::::::::::::::::::::::: is staut date APIPENDIX D
9) long term car e-policy - for each long team caa-e policy:
the system 100 Will convert the long term_care~olicy~remium to an amount based on the simulation fi equency the system 100 Will simulate the converted amount if > 0 the system 100 Will not inflate the amount insured refers to the long term care-policy_insured ';":.,:.:::::::::::::::::':;:..-v>.<..:.:,.....?.~~
';:~:':':':~~:,.;.,::_ ::.n~;;..,.
~oal.:::::.~::: <<'~:. ;'eYia~v ::. .. .e...
ln~I~~z~a~~ stair..: .
.. rforl .................................,.....
...................................... ........
........
:. .
.

' r eriod of :~~f~~~:::::yes r period pno to p ifperiod etirement of starting_peri :::::::::,:a~::::::::' i ;;,;.,.,,,,.::.,;..,;..;;. od m . i . a ,long i tei emium m tei cai long-to ey ca ermum ~
to v~..:.:.:~ urination rmination ofinsured ofinsured >

;:;:.::::.:>:::.::.:.::.;:;
ii ement startin ei iod ::z.
i et ' _ ~P

ri ~T' ..same same period as as prior Lifetime Lifetime to lessor ofpe od .............., :::::::::::::::::.:::::: .
::...:.:..:.:.:..:..:..::..::: .
...................... ~
'um ter lon tei m cai a i a _ ~
_ ::.;.;.'w>"v,. 'nation of insured or :::::::::::::::::::: -iod .....;;;;;;;;;;.;;;;;;.,;.,..., of confinement start~ei yes "* 'mulation same ''"'"' firstperiod as ;.i~ab~~tt of Lifetime ......................... si :::::::::::::::::::::;:.: based on :::::::::::::::::::;::: is start date anal s ~i~ii~uio~yes firstperiod same ........:.......::.if of as insured simulation Lifetime is survivor ...

::: :::. based :.:::: on :.:.::::::::

:::::::;::::::::::::: is ..... ... staut ,.......... date anal s Outstanding Issues:

APPENDIX D
Title:
Simulation: Simulation Cashflow Definition - Savings #70 Parent: Simulation Cashflow Definition #69 Referenced Sections:
Asset Section #27 Summary:
The system 100 will set up the savings cashflows used in a simulation run for a goal simulation. Each savings cashflow represents the savings amount that is derived fiom data entry elements or modifications made in Analyze.
The system 100 will add the savings amount to the appropriate simulation~ortfolio if 1) the cashflow start-period is less than or equal than the simulation period currently being pr ocessed AND 2) the cashflow end~eriod is equal to or greater to the simulation period currently being processed.
The system 100 will determine if the savings are client savings or employer savings. Based on that distinction, the savings will get different treatment.
For client savings, the system 100 can treat the savings as a savings and an expense. Since the client is doing the savings, that amount has to be paid for by the client.
During the times of simulation where incomes and expenses are being tracked (the disability goal, the survivor goal, and the post-retie ement period of the lifetime and LTC goals):
1) the system 100 will subtract the client savings amount for the period fiom the regular asset simulation~ontfolio.
2) the system 100 will add the client savings amount for the period to the simulation_portfolio it is associated with.
For employer savings, the system 100 will add the employer savings amount for the period to the appropriate client_X_retirement_simulation~ortfolio (the X representing either client 1 or client 2) since employer savings only impact retirement accounts.
Inclusion of a savings in the simulation is based on rules specific to the goal being simulated.
The start~eriod and end~eriod of the cashflow are based on rules specific to the goal being simulated.
The system 100 will inflate the savings amount based on a stochastically determined inflation rate for each period except the initial period APPENDIX D
Details:
1) regular savings - for each regular asset:
~ The system 100 will get the regular_asset_annual_contribution to the regular assets (See Asset Section #27).
~ The system 100 will convert the regular_asset_annual_contribution to an amount based on the simulation fiequency ~ The system 100 will inflate the converted amount based on a stochastically determined inflation rate for each period except the initial period ~ The amount will be added to the regular contribution simulation-portfolio Savings Handled as Addition to Asset:
Owner refers to regular asset owner :..:::::::::.::::.~::::::..:::::.~:::::.~:;::.:::::..
:;:::.::::.~:::::::...:::::.::: :::: ::::::.::::
.,.:.,..::,::::::.~:::::.~:::::::::::::::.::::;:::::::::.
::::::::.,::::::.::::::::::::::::::::::::::::.~::::::::::
,,;;:;::::::;::; :::~::~:.;::.;..,,:::::::::::::: : :~::li:::d:::::
.~'x.n..aa: ;::::::::::::::::::::::::::::::: :: :: ...<.:::
::~::#'a:o::d::::::::::::::>:::::::::::::::::::::::::::::::::
.........In oJ.ua.ra : .: ; ..:.,.:::::::::::::::::~::::::::::::::... .. :.
.. . .....................................................
r3 ................s.ir.a.rl a r~~ ...
.................................................d :::.:..: ::.
:: :.: :.::
.
..
..
...
.. .
.
.
.

:::y:;::,.::u o eriod riot to ;L~,fa;t(xrt::e:...:;:Ye s f P P
e fi t rioa sim rs lation P

<'#> based on retirement_starting_peri :::::::::::::::::::::::::
~v:~:~::~::~:~:~:~: i s s t a r t d o d a t a a n a l s :;.::;:;:;:;:;::a s s a m a a s I
ifetim a sam a as lifetim a E3ia~l3IliCyn o - a I I

.::::::::::::::::::::::::q ified ::::;::::::::::::::::::::;::a::;:;n o n a a I
~

:.::..:;::..:.v:.r::::~.;:.;:
.;:: in g s a re :::::>>:;::::::'v':::::::::::s a v v~'vv stoppad in casa of d :::::::::::::::::::::::isabilit ;:~:.':.:..>:.;;;:.:

~u~~ii~i~ii~yes if owner first period of period prior to is sim ulation ;;;.;'::;:;;;s a rv iv i b a s a d o n r a t i r a m a n n g c I i t_ s t a r t i n a n t g _ p a r i ww wwww~ a n a I s i s s o d ~ t a r t d a t a Savings Handled as Subtraction fiomAsset (savings expense):
-...........
...,.................................................................. .
~... ..............................
::.::.:::::::::::::'::'1" ''':.::::'::::::::::::::::::........ ..
......................................
~.~:a:I::..........~.n.:~..u.sE.a.rs...........................................
.................;:. nt~: ~a'a'Q'a~~::
,:.,,:.;..;.~;.,::.::.,,~;,t'IO~?a3.##.
s.t~a:r.t... ..
.

:::...::::::::.
~:J:~~;ai~i:f~::: n o E:r~>'.'''>n o ~lazi~i'ifi~:'n o ~i~y~~ciiyes if owner first period of period prior to is simulation '.,.,,,;,;,.;,;,;,;,s a rv i v b a s a d o n r a t i r a m a n :;; i n g c I l t _ s t a r t i i a n t n g _ p a r I

:::: analysis start iod date APPENDIX D
Fixed annuity_savings - for each fixed annuity investment account:
The application will get the annual_contribution to the fixed_annuity asset (See Asset Requirement).
The application will convent the annual_contribution to an amount based on the simulation frequency The application will inflate the converted amount based on a stochastically determined inflation rate for each period except the initial period Savings Handled as Addition to Asset:
.::::::::::::.-.:::::.~::.:
::..:;::::..::.::::::::::::::::::::::.,~.,::.:::.::::~:....>:...:.:>::::..:::;:
.:.::.::::::::::::::~:;:;:::::;:::;:::::::::.::~>...:.:-:.::.:;:::.::::::::::::.::.::.:::::::::::::;::.:;,::::::~:::;:>..:.:,::::
:::<...~:~::~.::::::::::::::::::::::::::::::..,...,...;;...,;;:::::::::w;:::::.
:
:~::~::::::;.:...,,.:,::::v~~;;;.,,~.,,::::::::::::::::::::::::::::::::::::::::
::::;::;::
.~:a..a.I:..,:::.::::::: n~ :::::::::::::::::::::::::::::::::::::. ~.1X.~.
... . ~.~.L4....
...........:..........tjiS2C113..:~.A. . ::.
:.~'...~:La..~....................:......................
. ~....................................:.~.~::::
:::.,::. ..
:~......~:~. .

~>:I~~efi:~l3f:v:::: yes first period of simulationthe lesser of period prior to 1) ~::::::::: a sis start date client retirement :.:::::::::::::::::::::::::. based on au 1y _ start erio _ _ _ _P

;...>:.:.::.;.:.:.;;;;:.
:;:;~. : ) p io d o f _ : d o f o w n a r o : r 2 a r :
#
:
:
:
:
:

, : y a a r _ a n d :: ::
:
:
:
:
:
:
:
:
;:;:;::;:::::::::::::::a:

::~::: ;:
:;:;:;:::::::;:;:, yas ifetima sama as lifetima ~;;;~",:;,:.:.,,, s am a a s 1 Z~~j;~~~~!yes if same as lifetime same as lifetime owner :;:'.:;::;::;:;:.,'.:::.::.;;;;'..;:. n n is ab 1e d ::~::::::::::;,;,: Tent ::::::.:::::::::::::.;::;~:; c1 ~.uT~.~.o~yyes if same as lifetime same as lifetime owner ?<'' i s s a r v iv in g ::::::::::::::::::::::::::::::::: c 1 ::::::z?:#::::::i a n t Savings Handled as Subtraction from Asset (savings expense):
...v:::::~:::::';::::::::::::::::::::::::;.......;~..::::::::::::::::::~::::::<
,~,,::~,:~:::~~~a::::w:~:r~d~d:;::::::::::<:<::::::::::::>:
..... ....
.~ug.t.~:ri.::::::.:::::::::::::::::::r:::::::::::::::::::~::....:.....:.
..............................................................
...............~.~.G..:..:......._........s.ta.r~....
.~r.~fl.:cl...........................:::::...:::::~p _ ..
~'3:::n:l::::::::::::.:
........_......n.........................................

..........................
~':I~~~~Il't~:n o ~~'r::::n o ~?~~~>Ef~J~~j?yes if 1 ) owner first period of simulationthe lesser of period prior to >v ' s's start date client retirement_start_ ;:y<~>::::::::::::::::::::1 s b a s a d o n a n erio aly i _ _ _ P

'rv~~ n o n d o f o w n a r o d is r 2 ) p a rio d o ab 1e f d :;:::<:::::::::::::::::::::::client yearend ~:lz:r.W.~.V:O.:I;;;;:
esser of eriod rior f owner irst period of simulationto 1 Yes the 1 p p ) 'ent retirement start ::~:''<:#%:##' ' ' anal sis start date erio :.. is survivingbased on y _ _ cli _ _ _P

>.:: er ' ::. client d of own or 2) period of ::.::::::::.~::::::::::.:::. year ;:::;:;;:;::.:::v;:.,: ~ n a ~::~

APPENDIX D
2) variable annuity savings - for each variable annuity:
The system 100 will convent the variable annuity-annual_contribution to an amount based on the simulation frequency The system 100 will inflate the converted amount based on a stochastically determined inflation rate for each period except the initial period The system 100 will add the amount to the client_X_retirement_simulation_poltfolio (based on client_l or client 2) Additional feature: qualified savings stop relative to a client's retir ement. System 100 wants to specify the ending.
Savings Handled as Addition to Asset:
:?~.~r;':: :''v ::i :5:: :::.;.,':~'::v''''fi''.
'.''';:1'IGI;~.~C~~Sa~'i''.''.v:;'.'.':':::::%:::z::::
"":4::::::::::"::':~":~:'~0?C~''.?.5'.? ._ .~...............l.n.cl.~a.s:Ea........'ta.r..... r lj~~aii7jv~v>yes first period of simulation period prior to the . ..... period of :::::::::::::::::::::.;:::::. based on the >'.> . . . re analysvs_start_date var~able_annmty_p mmm and "'[':'~''es same as lifetime same as lifetime j~;ia~1~]j~':as sama as lifatima sama as lifatima .yfyjo~ yes same as lifetime same as lifetime if :.::.;::~::::::::;::::o w ' n a r ::::::::::;:::::::;:~:::::::::;:;:::S a : rv ":>>'r:vi v i n g ::::'::~::::;::::::::::::::::i a n t Savings Handled as Subtraction fiomAsset (savings expense):
Pr emium end r efer s to variable annuity_pr emium end :::::::..:::._:;::::::.:::::::::::::.:.:::::.:~:::.::::::::,::::.::;.:::::.::::
:::...::~:::.::::::::.::::::::::.:.::::::.: ... . ,:::::::.~:::
....,.:.::::::::::::::::::::..:.:.::..:.::~<:~~:::::~::~:~:::::.::......
...............................:
~a~.l ::::~:'>:v~:':<:'::::::;.:::::::::::::::::.::::::::::::~v~~'<:<::.,.<::~:~:v:a:
~_<<_.
. ~ . ~ star ~.b.

~?j~'".;':":.'''''':'.:a? es if retirement start period prior to the ~ ~ifit~:~Y period period of ,. _ _ :

.... ; , .. . p r a m m m _ a n d .: p r a :" m aWm ' _ a '::
': ~:' :::'' ':':' . :n d >
. :
.
.
..
:::.:
:::::.:...:.:::::::.
:~
:
::::
:.:::
:::::

. .
:.; ::
: rct _ :.: rement ::::::::.:::::::::::a:::
i ':''? t n t ::::::::::::::::::::::::>:::a r i o :$ r _P

<..~:z~_<>'''~3'a ' retirement start eriod rior to the eriod : s if eriod of Y : _ _P P P P
;'::':::::::

. Premuim_e premium~end '' ,::::::.::. n d :.: >
:.:.:
~::.:.::::::

.::;::;:;;:.:.:::::;;:::::.:.:r c t it c m a n t _ start pert y~~~~~~~j~:'vyes if first period of simulationperiod prior to the owner period of bawd o .,',,,,,,,,,',,>_;,"'~,,',,"i s n a n a 1y s is _ p r em iu m _ en d s t a r t_ d a t a :;:;;;:~::~.:::.o:::::...:.:.: nondisabled 3:''<>''~::':c 1i a n t ~~;t'~I~Iat?ty~~'es if first period of simulationperiod prior to the .......,..................owner period of . Y

' is survivingbased on annlysis_start_dntepremium_end ::::::....................: client ':~~>:'~~>'.''' APPENDIX D
3) employer savings - for each company defined contribution plan:
Localization: new retirement asset type The system 100 will convert the company-dc-plan_X_annual_contribution to an amount based on the simulation frequency The system 100 will inflate the converted amount based on a stochastically detemnined inflation rate for each period except the initial period The amount will be added to the client_X_retir ement_simulation-portfolio (based on whether client 1 or client 2) Savings Handled as Addition to Asset:
Owner r efers to company dc_plan X owner ..................:......................:..............:..........-.........;::::.:.. ;::::
~......................................................:.....
:::::~;~;><.:;::::::::::::::::::~;::~:~:"..~<~~:::.......:..............;......
...................:::'e..'y.::::~:.eiaod'~~v'~~:
. ................. . . :<.::..-,:>:::::<>::::.;::.:....:....n...:..:.
....:..........
:.~.~.:~:.~~:. .
::::::::~::::::::;:>:.........................................
~:::::::..:.:::.. . .s.~.a. .t....
..~:.ri.o.ct................................ .....
:. .:..... ::.....:~:.. . . ......
:~.x'i:.C:~li:~:f.Ct:.... ...... ...-..................................
ft::::.

1~)f'~fiftxi~yes first period of the lesser of period :: simulation prior to :
:
::::

....... based on 1) ....:.
...
...
::.:::::::::.;.:.:::.~:::::..:

> analysis_start_date cfient_retirement_start_per <'z' ' o a r a r i o d :..:......................: god of wn or 2) p .. ......................
.

ownar torns aga 60 j'~';_~;.;:.;;;;;.;:;y a s s a m a a s I if s a m a a s l if a a ti m a t i m a ~t~~~#~~J~y a s s a m a a s I if s a m a a s I if a ~.~., if a ti m a t i m a '~s;'%;?'o w n a r i s :::::::;:::::.isable .::::.::.:.::.'..;::n o n :::;:.;;'..:::::.:d .~.;~;>>::;.::;:;:;:::.;:.:;.d c I
;:::::::::'::::::.'.:::::i a n t '<~~s~E~ti~%yes if sam a as lifetim sam a as lifetim a a ' o w n .. ...: a r ................is ......
...
................

s a r ,<;:.,:,:,:::.>.:.,.~vv i v i n g ''## c ie n t I

Savings Handled as Subtraction from Asset (savings expense): employer savings are not considered expenses since the client is not funding the savings APPENDIX D
4) employee savings - for each individual_defined_contribution~lan (1 or 2 based on contribution limits):
Localization: new retirement asset type ~ The system 100 will convert the individual_dc-plan_X_annual_eontribution to an amount based on the simulation frequency ~ The system 100 will inflate the converted amount based on a stochastically determined inflation rate for each period except the initial period ~ The amount will be added to the client_X_retirement_simulation~onfolio (based on whether client 1 or client 2) Savings Handled as Addition to Asset:
__ _ .::.., lei'~Iiii~i~~ei~t~<~t~''e'~loit'~'~ ~y'':'~':':::..;:;.::;':::<:::, :,..,.:.,~.;,:." :. :. .. ..:. :......::::::. : rt. d.l~.e ~
~.~r.~ ::::...::::::::.:.:::::::.... EO.~:::.: .. .....:.
.....::

1~f~~~FYIi?~?yes first period of the lesser of period .. ..... simulation prior to based on 1) :.::.:::.
..:.::.::.::.::.::;:.::.::.:.
.:.

_ _ _ . 1y ~ _ _ . a n a s s c I i a n t r a t ;;:::;:;:;_:_::;;:::;: 's t a r t d a t i r a m a n t s t ~::;;: a a r t p a r ::..:::.::::~::.~:.:
.~.:~:.~:.~:

''' i o d f o w n a r ........................... o ' o r 2) period o w n a r t a r n ....... s a a 6 0 ...................
'''"'"'' '' '"~"~"' ~'"'' 'v"v:~'vv'':v'w'''es same as lifet'me same as lifetime LTT:;C::.::::::::Y I

~~~ai)~~~y a s s a m a a s 1 if s a m a a s 1 if a ja i f a t i m a t i m a :::::;:::::::::'::::::::::;:::;::::::o w n a r .';;:;::.',:.:.;;::,:::.:','':.:n o n :::':::::::::d i s a b I
a d c I
::;::::::::::::i a n ::::;:::::::;::::;:;:::::::::;:;:;:.:t :~'a:~Ff:~!::lU<t3;T:;:~ye s ___-.
I same as lifetime same as lifetime ' 'f :::::: owner :::::::::::::::::::

':~::~ s a rv >>:v:~~v:v:~:v:v::v:vi v:v:::r:v:v:v::v%'v i n g :::::::::..::.::::::::::;:;:::,:;<;:c I
::::::;':::;i a n t APPENDIX D
Savings Handled as Subtraction fiomAsset (savin;;s e~ense):
..............:................................................................
................................................ .......... :.:
...............................................................:
............1':'>:'''~E~tia~?:vs~'awa'''~f"a'!~'~>~~vif':'e>i'a'~ial<v' .,.>'"'v. .t?..r;~.~it.
..~:~.k:............. . . . .......

~~~~~'f'~yas if tha tha ratiramant_start_Iassar of pariod prior pariod to ,'.''.''''.t h a s a v i p a r i o 1 ) i a n t_ r a t n g s a n d s d i r a m a n t_ s t a r t_ p w~wwwwwww~'v(lesser of period eriod of owner or prior 2) period """""""""""""'t o o w n a r t a r n : a g a 6 0 :.: ) ::::::::::::::::::::,:::.1 c I
................ient_retirement_s ::;:;:.::::::::::::::::::::::;:::::

#i t a r t a r i ::;.:::.,::.:;:;:.::.:>:;:;:>:::o d o f o w n a r _ p ;:;;;:::::::::::::a::;:;:;:..:;o r 2 ) p a r ; i o d o w n a r to rn ;:::::::::::::::::::::::;::a g a 6 0 ) >
:: _ #vz?>

'','.'.,,,,re them ent_start_peri :::::::...:::::::::::::.~:::o d s ' eti a same as lifetimesame as lifetime ~~:T::::.~,~.::::::.::..:::
:':''#'vsame a Lif m ']~#~y'~~j#j'~j~'es if owner is first period the lesser of period of prior to ''';:'::';'>>''isabled client simulation 1) ~::.:.; n o n d based :.::;.::.::.:;.:::.:;::.::.:

o n client_retirement_start_per .
:::::;:::::::::::::::::;::: analysis_start_di o d ::::::::::::::::::::::::::::;:: 0 0 owner or 2 er .:..:.:.:..:....:.:....:..:..::..:.. ~ d f ) P
...........................

"' "~' a t a o w n a r t a rn s """""' a g a 6 0 """"
...........................

~~Ei~~ yes if owner is first period the lesser of period of prior to iving client simulation 1) ..........................a rv based o n :~:.:<.:.:.:.> i a n t_ r a t i r a m a n t_ s t a r t_ p a r I

~:.:.;;;:.:.;:.;;>;;;;;: a a 1 s ::;:;:;:::;:;::;:;:;:;:; n y i s _ i o d o f o w n a ........................... s t a r t_ r o r 2 ) p a ri d o d '"""" a to o w n a r to rn s ''' a g a 6 0 '"""'"""

Outstanding Issues:

APPENDIX D
Title:
Simulation: Simulation Cashflow Definition - Policy Benefits and Income - #76 Parent: Simulation Cashflow Definition #69 Referenced sections:
Disability Policy - #83 Long Term Care Policy - #84 Life Policy - #85 Estate Processor for Survivor - #128 Summary:
The system 100 will set up the policy benefit and income cashflows used in a simulation run.
A cashflow represents either the amount that a policy pays out in benefits or pays out as an income for a specific simulation goal (See Disability Policy - #83, Long Team Care Policy #84, and Life Policy - #85).
The system 100 will add the cashflow amount to the regular_asset_simulation~ontfolio if 1) the cashflow start-period is less than or equal than the simulation period currently being processed AND 2) the cashflow end~eriod is equal to or greater to the simulation period cuiTently being processed.
Whether a cashflow is included in simulation is dependent on rules specific to the simulation goal being simulated (See Estate Processing for Survivor Goal section #128 for discussion regarding how the insurance policies of the decedent are handled).
The start~eriod and end~eriod of a benefit included in simulation are based on rules specific to the goal being simulated.
Added feature: in Apex, life insurance policies cannot be modified. For the Survivor Simulation, Apex has the Estate Processor handle existing life policies and has the Simulator include any added life insurance policy's death benefit as a increase to the regular asset~ortfolio. For System 100, all life policies will process through the Estate Processor (see Estate Processor for Survivor section).

APPENDIX D
Details:
1) term life insurance - for each term policy:
~ For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the owner and/or insured outside of the simulation - see the EstateProcessor for Survivor section ~ the system 100 will simulate the sum_assured ~ the system 100 will not inflate the amount insured refers to term_life_insured payment disability-indicator refers to team life-payment disability_indicator ....-_.........
......:.........~..........:...................................................
..................:..........:
':w:~;'::~::::::>.:a::':;::::.:;:>:;;;.'.':::::::~?............................
...........................................-~:~7.~i,~::.~:::::::::: ~21~~~LSIC?~ 'e':;:,::::'y:,w,.:..:..
::.. ;:..,,;,,,.'< ,,:<....:;...,;.~~#a~~d~<yv~<>>'?
.......... ... .g~~3'.~... !~~:~.:.
:..............................................................
...... ..~.'~'~~~
..........
:
, :~~~t~;~:::?::::: no ~' no ~f~~'~~I~~vyes if insuredfirst period same as start_period is of :' '.disabled clientsimulation based and on ..,,<.;~;,,,,p y _ ility analysis_start ::...:..:.:.._::.:.:.::..:..::in date ... a meat disab ~~ dicator is set :~~a:~::~!l:crox;::
'"~"v"'"''"'''v'v' ' insured is decedent :: ~f ::>:::::::::::::::::::::::::: handled by ........Estate ..............

::. :. processor ::::::::::::::::..:::

2) whole life insur ante - for each whole life policy:
handle sum assured benefit:
~ For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the owner and/or insured outside of the simulation - see the EstateProcessor for Survivor section ~ the system 100 will simulate the sum_assured ~ the system 100 will not inflate the amount insured r efers to whole_life_insured payment disability_indicator refers to whole life-payment disability indicator ...... ....
...................:...................................;;.....................:
..........................~
...........;; ~:::.:::::::::..:::::::...:::....~::: :::::::::::::::::
,;::::::'::.':::::::::..........:......................:..
.........~::.~. ...::.:::; :.:......::::-::::::.::..,...~.:.~~;.;::.:,:;:;:::..:.::.:::......>:....:::::::::::..::::,:::
::::::::::::::>::::
:.:::::;::.,y:':~:::.'::.'::w,...................................:::::~::~..:::
:....:....,:..::..~~<:.::.:.......:
;:::;:...y.::.:,:::::::.::..:::::::.:.~::::::::::::::::':::::::;.::.........::.
:,...;:::::.::::;:::::::::::::::::::::::::::>::~::::::::~::;::::::::::
.:;::;:>::.....::::.. ::.::..:::::.,::::::<:>><:;::::::::::::::::::::::~...
............~i.......;.::::::::::a ::.:::.:::::::..::, C~.aL:::..::.......lrtcl~~s~s~x~...:.:...................
::::::.:::.:::::::.
.................... :~tne-t~...~.e ::::::::::::.:.:::::::::::::::::::::.:::..
od.

;:~::.~;t~ntae:::::::no 'ti~~S~Iit~yes if insuredfirst period same as start_period is of disabled clientsimulation based and on :'..:.;;,;;,;payment disabilityanalysis start in date ::,::::::::::::::dicator is set ,,;;;:'~''::~''<'' insured is ,~~,.uiy~~;:::.:decedent ~f . handled by ~~~~ Estate ~~~~~~~~~~
~~~:~~~~~

::::::::.processor .~:::::.~:.~:::.

handle whole life future cash value-payment:

APPENDIX D
~ For the Survivor simulation, the system 100 will take into consideration the policies when a the decedent is the owner and/or insured outside of the simulation -see the EstateProcessor for Survivor section ~ the system 100 will simulate the whole_life future_cash_value~ayment amount ~ the system 100 will not inflate the amount .
future cash_value_payment refers to whole_life future_cash_value~ayment future_cash value~ayment date refers to whole life future cash_value-payment insured refers to whole_life_insured payment disability_indicator refers to whole life-payment disability indicator iFelsiiii~es eriod of future cash valvesame as start a ment eriod L'hC::::::':es ifetime same as start same as L eriod IJi~a'f~iTiyes except if same as Lifetime same as start_period insured is ''''"'"'''"'''''''''''"isabled_client and '~''v~'vment disabili in - tY_ paY

:,::::::::::::::::::::.~,.
dicator is set ~i~fi0~es if insured same as Lifetime same as start .........................is eriod Y _p ::::::::::::::::::::::::'vor :>::::::::::::::::::::::<::<::surm APPENDIX D
3) whole life with team insurance - for each whole life with temp policy:
handle the sum assured benefit:
For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the owner and/or insured outside of the simulation - see the EstateProcessor for Survivor section the system 100 will simulate the sum_assured the system 100 will not inflate the amount insur ed refers to whole_term life_insured payment disability indicator refers to whole term life_payment disability indicator :::: . ..
:.:::::: ..~.~1::.::.:.::::::::::::::::....::..::::::::::::.~:..::
.::::::.::::::::::. : :..:,.:::::.:.::.
:..:::.::, :::.: ..: ~:~. :.. :.::,..:
:::::::::::::::::::::::::::.~::::::::::::::::
.:::::::::: :: ::::::::::::.:::::::::::::::::::::.. :::::::::::::::.~::.~.:.:
:.:::::::::
.; . ~.x~..........................:.::..:..: . . .. >::: : . . ....:.: .
....
>::::::::: e ~.~~.
..~:.:;:;:;:;:>:;:;:;::.::.:::.::....;:;:;:>:~:.::.:;::.::.::::::::::.::.:.:::.
:;:;:
. .sta..t.... ;...:;::<....;:::::
. .; ; o:
:.:::::::.::::::..:.:..nd__.~e~..~n.d.,,;::.:::::.~::::::::::::::::::::::::.:::
:::::::::::::::::.
.........

:Pu~aii~ti~::: no I<T~<<; no ~Jz~al~zIa'.''Tes if insured first eriod same as start eriod is of _P
y p '~ : . . .
: disabled client.
and simulation based on ::.:::::::.,.::::::::::::.:p Y
:'':::::::::::::::::::::::::::::: m n i nalysis start a a t d'sabilitydate in ::::::::::::::.:::::: : icator is set ~.~z~~i:r;,:: : es 1 '"' ~f insured is ~ .
~
........................

decedent v - handled b ...................... .

''''''''''''''''''''''''''''''''' Estate Processor APPENDIX D
handle whole term life future cash value~ayment:
~ For the Survivor simulation, the system 100 will take into consideration the policies when a the decedent is the owner and/or insured outside of the simulation -see the EstateProcessor for Survivor section ~ the system 100 will simulate the whole_term_life future_cash_value~ayment amount ~ the system 100 will not inflate the amount future cash_value-payment refers to whole_term_life_future_cash_value~ayment future_cash value-payment_date refers to whole_term_life future cash value-payment insured refers to whole_term life insured payment disability_indicator refers to whole term life-payment disability indicator ~o:al.:;:.,:.::::.:::.::.fne2uarv.n.::.::.::.::.::.:::.:::.::.:.::::::.
::;:;::.:. i~;:; .e~;i ::d::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: n..
:::: :,~ri ........................................................
........~~~................o...................................................
................::d::;::::::::::::::::::::::::;::::
... ~...~... .......o...................................

i~e~ti2ees eriod of future cash valvesame as start a ment eriod ~~'~~:::::::::es same as Li 'fetime same as start eriod I;~isa'~~I~E~?'yes same as Lifetime same as start~eriod :. except : if insured is ::

.,.;.~:::~:.......
:';':.disabled y:.
client and :>:<:>
:?:''::: payment disabilityin ~;.,,;,,,..";,..,, a;.:::::::.':%:
dlcatOr sP.t tt~ttiayes same as Lifetime same as start~eriod if insured is ;::.:.::.:::.::.::.::::::...:
:<.<.:::::::::::::.:;:::::'vor ::::
surm APPENDIX D
4) universal life insurance - for each universal life policy:
~ For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the owner and/or insured outside of the simulation - see the Estate Processor for Survivor section the system 100 will simulate the sum_assured the system 100 will not inflate the amount insured refers to universal_life_insured payment disability indicator refers to universal life_payment disability indicator . w ...........................................................
::::.~::::::::::::::::::...~:::::::::.:>::::;.::.:>::.::>:::~:::::::>::.:;::.::
;:.::.:::.::.::~
:::::::::::.~:::::::::::::::::::::::::::::::::.:.:::::::::::.~:::::.~::::::::::
:._:::::::::.
<: ~::~a;:..:>:;::
;::;.:>::.:;::::::::::::::::::::;::::::::::::;.::::::::v:::::::::iia':.
::::::::::::::~:::.:.~:::::::::::::
::::::::::::::::::::::: . . :. us~o '::::::::::::::::::::::::::::'cri'":::~:::::.::::>::::,>:::::
::::::::::::::.................................... .
......................:::::::::::::::::::::::::::::::::::;:::::::::::::::::::::

~::::::..:::::..~ilG~: ' I~::::::::::~:~::':::::::::::::5# :1't ~e ...: ~
ygT~Od ::.:>::.::.::.:::.::.::::::::;:::.::.:::::;:;::;.:;:>:;:;::
, ..d ~~~::::::...:..................
... ..................
... ..

i':>~~~~no -'T' no I~~~a~~~i""'''en if insured first eriod same as start eriod is of _P
Y p ~ . . , ~,: disabled client, and simulation based on ''.'':"'':':'''"'':'~:::~','''_ inability analysis start .~........~....~...~...~..~....~in date ~ Payment d ::::::::::<:::,:.~ 's set ............dicator i ..
.........

~iirvi~en 1 v r::::Y ~f insured :...~.~:.....~.....~:.'.~.'::is :':'::'::".:::':'::::"::'::':::':decedent :::::':::':::- handled by .........................

"" """"~Estate Processor APPENDIX D
5) endowment-policy - for each endowment policy:
~ For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the insured outside of the simulation - see the Estate Processor for Survivor section the system 100 will simulate the sum_assured amount the system 100 will not inflate the amount ::
::~:::::...<::::::::::::::::::::.::::+::::::::;:::::;::::::::::::::::::::::,:>:
::::.:::::::::::::.::::.:::::::::::::::::::::::::;:::
:::::::::<:<:::::::::::::::::::::::::::::::::::::::::::::::::::::~::::::
. : ... . .......,......................... . . . .
........................ . . .... .
..........................................................
. ..::::::::.~::::..hicl~azv.v.:>::;:::.:;:;:;:;:;:;:;:;:;:;::.:;:.s~ax~:;.:
:end:;;.
:e~r~b:d;;;;.:>:::>::;;.::.::.::.::;.::.:;.:;;;;.:::;.:::.::.::>::;.:;::.::;;;.
::.
~:~r:al.:;:;:;:;:>:;::.......................................................e:
~:ro:d.:::.:;::;.:::;.:.::;;.:;:;........... .
.........................................................................
............
. .....................................

::::::::::::::yes if insured period of same as start_period ~~eti~ia~is Tent 1 or clientolic termination :~'~'~:::::.:::::same as L
ifetime same as Lifetimesame as start eriod T~a~abilitcase 1: if insuredcase 1: first case 1 and case2: same is period of as vvv'vvv'vvvvisabled client simulation start_ eriod and based on ... ment dis bili n 1 sis start ;.:::.::.::.::.::.::.::.::.:.:.::.::.:in date' p aY _ a tY_ a a Y _ _ ::;:::::::::::::::::::::::::I r i 2 case 2. em .;.::''",:',,':',:d'cato ~s set; ' p ~od of case :

:>::::::::::::ther s iW anon oli tei urination iv~~a~ case 1: if insuredcase 1: same case 1: same as Lifetime;
is as case 2:

:. .::;...:'::.:~:::.::.survi . .. 'vor ; case Lifetime; casehandled by Estate Processor . 2: 2:

rnsured ':":'';:;;:::y''::'is decedent handled by .:..::..:..::.::.::..:::...~..: Estate ......................
:::::::::. Processor APPENDIX D
6) fixed annuity - for each fixed annuity policy:
~ For the Survivor simulation, the system 100 will take into consideration the policies where the decedent is the insured outside of the simulation - see the Estate Processor for Survivor section ~ the system 100 will convent the fixed_annuity amount to an amount based on the simulation fi equency ~ the system 100 will simulate the converted amount ~ the system 100 will not inflate the amount :.....::::::::;::::::::::::,::::~::::::::::~:::::::::::...:::::::::::::::::::::
::::;::::::;::::::::::::::::::::::::::;:::::::<::::::::::::::::::::::::::::::::
:::::::::::::::::::::::::;::....::....::::::::::::::::::
:.. :... . . . . .::. : ... . . . .: :.:~..: ......:..
... . .. ... . .:::.....................................:...::.::. ::::::
:.::::::
:::::. .:::.:~:::::.a.. .: ..::::....... :.::
::.:::::::.,:.::::::::.~:::::::::::.
::::::.:....
....1......:::::.:>:;::.::...::::.::.::.::.:;::>...:.::.::.::::::.:;...::. ., ;.:.:. ~.. . ....................................,......................
:::::.:._:::.... .:::.~:::::::::. ... . .
..................................... :::::.: ::::::::::.
........... . . . .
::::::::::::::::.:.~:.~::::::::::::::::
a.a ............stay ,t~.ex.~od...............,~,..end.:.~.c~.god...,.,y,;y;..:::.........:,.......:
:...:.......................
to ~ s :..
t~ .

vi~~v~~vv'es if eater of erio +
~....: ins it gr p d of period ofpolicy_matnrity_year : y i ed : : is clientolic matnrit ear eriod based on annnit ::::::::::>.::::::1 or or term - 1 : - P Y_ Y_Y p Y_ ~v client retirement startin . 2 and eriod - _ g_P

::::::::::::::::. -:; end-period >_ :::::::::::::::::::::~::: ret ::~:~:::::::::::::::~:::::~s:v:<: irement st ::::::::::::::::::::::::::::: art :.:.:;:.:.:.::.:::: ing_Period 1~~~::::::::::::: same same as Li '.:.:..::..'.';';":':':'as 'fetime same as Lifetime .' v~< v Lif im et a ~S~E~~T~~~:yes if period of olic maturitsame as Lifetime .:::::.....:::::..insured ear ...: . P Y_ Yes' :::::::::::::::::::::::::::: ~, ient ::::::::::::::::::::::::::::::::: m c1 z~x~or::::yes if period of policy same as Lifetime insured matnrity~ear :::::::::::: vor :.::::::.~::.is survi :~<y<<':'.::

APPENDIX D
7) child endowment~olicy - for each child endowment policy:
the system 100 will convert the sum_assured to an amount based on the simulation fi equency the system 100 will simulate the converted amount the system 100 will not inflate the amount '.':~:J,~~1Inclusion s taW end eriod eriod '' : y 'f owner period same as start_period Ly~;~trti~::is of : es r :.. . client 1 olic or client termination ::::::::::::::: m Li L~'C':.~' sa a as Lifetimesame same as Lifetime .': as .'.'~". 'fetime zs~(i~l~'Tsame as Lifetimesame same as Lifetime as Lifetime >~#z:Y~~9~same as Lifetime same as Lifetimesame as Lifetime .....................if the .

:.:::::::::::::::::::.:~. owner was ........................the .

:.:::.~:::::::::::::::::. decedent :::::::::::::::::::::::::. the owner '""~~~~'~~~~~'~was changed ~~~' to the ............rvi v'"~'v'v'v~~"v''v'bor when Estate .

.
......................'f no :.......................: Goal Processor :::;::;::::::::::::::::::::- r ::::::::::~:.:.;..: surm ::: : wor, owner ::::::::::::is ~:::

; Other and policy ;
;
vvv :::::::::::::::::::::.. co a r :: ' 's a lied 8) disability_policy - for each disability policy:
handle disability_policy-first year benefit the system 100 will convert the disability~olicy first-year_benefit to an amount based on the simulation fiequency the system 100 will simulate the converted amount the system 100 will not inflate the amount . .:.:.:..::.:.:.. ... .:::... :::.,:.::. ..... :::...:::.....:::::::
: .....:.:,:::.:..::::.::.:::.::..:::::::.
.........:::.::::::::::::::::::::::::.....
:. .. ...... ..: - . .
.:::::::::::::::. .. .. ... , .. .. . . ... .
.........:..................:.
:::::::::::::::..:::::::.:......,.. ::::::::::::::.~.~.~::::.... . . :; . .~
.: : :.::>::;:;::;:;:::a::::::.::o:::.::::.:::;:::::;:::::::::::::::
a .....:.:.....: : .i7: ::.:.: . : ::. . .... .
.........................................................
~X4..........~ .. . ;:; : . .: . ~71(~...
)f'!:171(~...........................................................
.... ...:::;:::::::::~:.:>:;:. :::::::::::::::::::::::::;:;
. T. CI ... . . ... .
lei ................................................
. ... .. .....~ti~7.~...
..1,~5......~,...................)fl.d~~............................

Taf~C :no ::.e::::

,: . .
..............
..............:. no .:~~.::::.~:.~:::

13i~~3li~'''yes if insuredfirst eriod of same as start eriod :................is simulation _P
'... . P

dis ~;,;",:;,:.:.:,;""""".:;,;,; ' abled based on client :::::::::.;:;:::::::...:..::_..>: anal sis start eriod ;....::::>:::.::~~:>:;:
... no .i~:::::::

APPENDIX D
handle disability~olicy_following years benefit the system 100 will convert the disability-policy following years benefit to an amount based on the simulation fiequency the system 100 will simulate the converted amount the system 100 will inflate the amount if the disability~olicy benefit_increase_indicator is set. If set, the amount will increase by the DISABILITY BENEFIT INFLATION RATE which is a constant 2%
maximum_benefit_payment~eriod refers to the disability~olicy_ maximum benefit_payment-period ............ . ..................:.:
...............................................................................
...........................................................
:~aF .:::::::::.~:::::::::.::.:~,:;'YC>"'Er~iotl~~..
.. Iir~Iiiauoiz'. . ~t.~.. .. '~' '','tvi'.'"v<.<
........... . ... .......... ..: ....... . e.. .d..: f~....c~~
...... . . ... .................:......... ,...... ...
..... ..:...:.

::~~'~~tn~;::::: no ~'T'C~> no I~i~~~~2i''es if insuredthe eriod of simulationthe eriod rior to the EYis P eriod that the Y p p P

base on . d in it rn h ifi ::::::::::::::::::::::' disabled si ed to s t a age spec v:::'v'v'v'''vclient ed by the analysis start_periodmaximum benefit_payment~eriod +

.... .
.............. : no ':~';:::.~
fit:

APPENDIX D
long temp care~olicy - for each long temp care policy:
handle lump sum payment ~ the system 100 will simulate the long term_car e_policy-lump-sum-payment ~ the system 100 will not inflate the amount insured refers to long term_care-policy insured policy termination refers to long term care-policy-policy termination ..........
...........................................................................-...................................-....................................................................
~,:;::::>::.:::::::>::::; :<.::<;
::.:::..,..<::~::,:::>::<:.:;.....::...:.......
aI ;:
,:.,..,:;::.::~:::::::::::::::::::>:::::::::::~::::::::::::::::::::::::::.:::::
:::.,;:.:::::...::.::::
....................:..T~t~Tu.mo...:::::::::::. ... : :
;:::::>::;:::;::...:;::.:,::;::::~::::::::::::::::::::::::::;::::::::;:::::::::
::::::::
.:::::. .~t~r't::. :: :
.:>:;:;:;:;::.:;:::::.:::.::::;:::::.::::::::::::::::::.
.......:..:.......:?~.:::::::::::::::.:ergo .......................en ... .
ran .......................................:...:.::.::::::::::.
::::::. :::.:. d.............................cl...~~~.-..d...........................................................

~i~~tiiriev'no E'..T' x 'f h :, ; yes a cept confinement same as start_period i t a period startle :::::::::::::::::::::<h : of t a r : iod of insured :
~

: .
: : ~ . , , .::::: policy termination :::;:: is ;::::::::.
::::::::::>:::::::::::::::::
"~;:'':'~,:::';':' ::.,::.~:::::.~::::::::::<

.:;:::::::::::::::::::::;:: tout ::;:::::::::::::::::::::::::::::::'inement start pe :.i::::.~;..;:::::::.
v Via: no 'ilit:::

~'~~0~ no handle pension payment ~ the system 100 will convert the long term_care-policy-pension to an amount based on the simulation fiequency ~ the system 100 will simulate the converted amount ~ the system 100 will inflate the amount based if the long term_care~olicy-benefit_increase_indicator is set. If set, the pension will inflate at the LONG TERM CARE BENEFIT INFLATION RATE of 2%
insur ed r efer s to long term_car e~olicy-insured policy termination r efers to long temp car e_policy~olicy termination ~''rQai..~~G1~.~S oz~ start... en:d aex.~n.d . ~ertod . :... .
..

r~~~ii~i:~::::~::: no - ___._._ >''T'~es exce t if confinement start . i start_pe period [number of periods :, y p t1 a period to ~.~. ::. o t a n -~...~..:.:..;;:::.: 'od of insured lesser of a) period of pension term -1 :,, po cy termination or b) contmement_end_penod is of :.:::::::::::::::::::::::::::::: <
::: insured]
:::

: :::: .
~:::::::::::::,, confmement_start_pe ,.:.,,~,",:., , ::;
, ,:
, . , , ' riod of insured , , .
w~wwwwww "~~ilaa:''no ~~a...,:: no ,:av~a:
:::

Outstanding Issues:

Claims

What is claimed is:

1. A probability modeling system for facilitating financial advising and planning, comprising:
a portfolio integration module for facilitating integration of at least one of a user's goals, assets, savings, and risk tolerance to facilitate analyzing and developing a customized strategy for financial portfolio planning of the user;
a portfolio reconciles module in communication with the portfolio integration module for facilitating comparison of the customized strategy to at least one of other strategies and projected user financial decisions in order to further facilitate the financial portfolio planning of the user; and a stochastic modeling module in communication with at least one of the portfolio integration module and the portfolio reconciles module for facilitating use of data from at least one of the portfolio integration module and portfolio reconciles module in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user.

2. The system of claim 1, wherein the portfolio reconciles module monitors at least one of buy, sell, and hold recommendations for the proposed situation portfolio and dynamically updates the proposed situation portfolio with the at least one of buy, sell, and hold recommendations.

3. The system of claim 1, wherein the stochastic modeling analysis uses at least one of a stationary bootstrap sampling method and a synchronous stationary bootstrap sampling method.

4. The system of claim 1, wherein the stochastic modeling module measures the probability of the user reaching at least one user goal.

5. A probability modeling system for facilitating financial advising and planning, comprising:

a portfolio integration module for facilitating integration of at least one of a user's goals, assets, savings, and risk tolerance in analyzing a customized strategy for financial portfolio planning of the user;
a portfolio reconciles module in communication with the portfolio integration module for facilitating comparison of the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of the user;
a stochastic modeling module in communication with at least one of the portfolio integration module and the portfolio reconciles module for facilitating use of data from at least one of the portfolio integration module and the portfolio reconciles module in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user; and a simulator module in communication with at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module for at least one of:
facilitating forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module;
simulating at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module;
designing at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module; and testing at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module.

6. The system of claim 5, wherein the simulator module is configured to forecast effects based on at least one of a country's current economic data, a country's historical economic data, current world economic data, and historical world economic data.

7. The system of claim 5, wherein stochastic modeling analysis uses at least one of a stationary bootstrap sampling method and a synchronous stationary bootstrap sampling method.

8. The system of claim 5, wherein the simulator module is configured to facilitate use of at least one of the user's historical portfolio data, historical economic data, financial decisions, investment strategy, present cash flow, future cash flow, and goals in order to facilitate forecasting the effects of the proposed situation portfolio on the user's portfolio.

9. A method for facilitating financial advising and planning, comprising the steps of:
integrating at least one of a user's goals, assets, savings, and risk tolerance to facilitate analysis of a customized strategy for financial portfolio planning of a user;
comparing the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of the user;
using data from the integration and comparison steps in a stochastic modeling analysis which includes at least one of a stationary bootstrap sampling method and a synchronous stationary bootstrap sampling method to facilitate creation of a proposed situation portfolio for the user; and at least one of facilitating:
forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the integrating, comparing, and using data steps;
simulating at least one of the integrating, comparing, and using data steps;
designing at least one of the integrating, comparing, and using data steps; and testing at least one of the integrating, comparing, and using data steps.

10. A system for facilitating financial advising and planning, comprising:
a host system including a processor for processing data associated with a user;
a memory in communication with the processor for storing the data;

an input digitizer in communication with the memory and the processor for inputting the data into the memory; and an application program stored in the memory and accessible by the processor for directing processing of the data by the processor, wherein the application program is configured to facilitate the steps of:
integrating at least one of a user's goals, assets, savings, and risk tolerance in facilitating analysis of a customized strategy for financial portfolio planning of a user;
comparing the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of the user;
using data from the integration and comparison steps in a stochastic modeling analysis which includes at least one of a stationary bootstrap sampling method and a synchronous stationary bootstrap sampling method to facilitate creation of a proposed situation portfolio for the user; and at least one of facilitating:
forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the integrating, comparing, and using data steps;
simulating at least one of the integrating, comparing, and using data steps;
designing at least one of the integrating, comparing, and using data steps; and testing at least one of the integrating, comparing, and using data steps.

11. A computer implemented method for facilitating financial advising and planning, comprising the steps of:
obtaining data in connection with a user via a communication channel in communication with a computer system having a memory and a processor;

storing the data in the memory and configuring, via said processor, the data to integrate at least one of the user's goals, assets, savings, and risk tolerance in analyzing a customized strategy for financial portfolio planning of the user;
comparing, via said processor, the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of the user;
analyzing, via said processor, the data from the integration and comparison in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user; and at least one of facilitating, via said computer system:
forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the integrating, comparing, and analyzing the data steps;
simulating at least one of the integrating, comparing, and analyzing the data steps;
designing at least one of the integrating, comparing, and analyzing the data steps; and testing at least one of the integrating, comparing, and analyzing the data steps.

12. A system for facilitating financial advising and planning, comprising:
a host server for accepting and processing data in connection with a user;
a database in communication with the host server for collecting data on the user and using a portfolio integration module to analyze the data in order to integrate at least one of the user's goals, assets, savings, and risk tolerance in analyzing a customized strategy for financial portfolio planning of the user;
a second database in communication with at least one of the host server and the database for using a portfolio reconciler module in communication with the portfolio integration module for comparing the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of a user;

a third database in communication with at least one of the host server, the database, and the second database for using a stochastic modeling module in communication with at least one of the portfolio integration module and the portfolio reconciler module for using data from at least one of the portfolio integration module and the portfolio reconciles module in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user; and a second server having a simulator module in communication with at least one of the portfolio integration module, the portfolio reconciler module, and the stochastic modeling module for at least one:
facilitating forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module;
simulating at least one of the portfolio integration module, the portfolio reconciler module, and the stochastic modeling module;
designing at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module; and testing at least one of the portfolio integration module, the portfolio reconciler module, and the stochastic modeling module.

13. A system for facilitating financial advising and planning, comprising:
a browser for submitting data to a web server, wherein the browser and the web server communicate via a communication channel and the data submitted to the web server includes information in connection with at least one of a user's goals, assets, savings, and risk tolerance;
a portfolio integration module associated with the web server for using at least one of the user's goals, assets, savings, and risk tolerance to develop a customized strategy for financial portfolio planning of the user;
a portfolio reconciler module associated with the web server and in communication with the portfolio integration module for comparing the customized strategy to at least one of other strategies and projected financial decisions in order to further facilitate the financial portfolio planning of a user; and a stochastic modeling module associated with the web server and in communication with at least one of the portfolio integration module and the portfolio reconciles module for using data from at least one of the portfolio integration module and the portfolio reconciles module in a stochastic modeling analysis to facilitate creation of a proposed situation portfolio for the user.

14. The system of claim 13, further comprising a simulator module in communication with at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module for at least one of:
facilitating forecasting the effects of the proposed situation portfolio on the user's portfolio;
monitoring at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module;
simulating at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module;
designing at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module; and testing at least one of the portfolio integration module, the portfolio reconciles module, and the stochastic modeling module.