Tom and Jane Lundquist
Asset Allocation Plan
Tom and Jane Lundquist
Prepared by: Joe Advisor Financial Consultant
April 29, 2016
Table Of Contents Results Comparison Target Band Portfolio Detail Distribution and Reallocation by Asset Class Risk Assessment Monte Carlo Results - Portfolio Accumulation Monte Carlo Results - Income Distribution
1 2 3 4 5 6-8 9 - 11
Results Comparison These charts compare your Current Portfolio with the Target Portfolio you selected and show the allocation changes you should consider. Target Portfolio Total Return I
Current Portfolio Projected Returns 5.05%
Total Return
5.81%
2.50%
Base Inflation Rate
2.50%
2.55%
Real Return
3.31%
9.98%
Standard Deviation
12.09%
Bear Market Returns -20%
Great Recession
-26%
5%
Bond Bear Market
6%
Portfolio Comparison with Allocation Changes Current Amount
% of Total
$48,000
15%
$45,750
14%
$32,000
Asset Class
% of Total
Target Amount
Increase / Decrease
Cash & Cash Alternatives
4%
$12,800
-$35,200
Short Term Bonds
22%
$70,400
$24,650
10%
Intermediate Term Bonds
13%
$41,600
$9,600
$34,250
11%
Long Term Bonds
0%
$0
-$34,250
$80,000
25%
Large Cap Value Stocks
24%
$76,800
-$3,200
$77,750
24%
Large Cap Growth Stocks
15%
$48,000
-$29,750
$2,250
1%
Mid Cap Stocks
0%
$0
-$2,250
$0
0%
Small Cap Stocks
8%
$25,600
$25,600
$0
0%
International Developed Stocks
10%
$32,000
$32,000
$0
0%
International Emerging Stocks
4%
$12,800
$12,800
$0
0%
Unclassified
0%
$0
$0
$320,000
$0
$320,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 1 of 11
Target Band The Risk-Based Portfolio was selected from this list of Portfolios, based upon the risk assessment. The Target Band is comprised of the portfolio(s) that could be appropriate for you, based upon the Risk-Based Portfolio indicated. The Target Portfolio was selected by you. The Average Real Return is equal to the Average Total Return minus the inflation rate of 2.50%. Average Return Current
Risk Based
Target Name
Cash
Bond
Stock
Alternative
Total
Real
Standard Deviation
Capital Preservation I
5%
67%
28%
0%
4.42%
1.92%
5.89%
Capital Preservation II
5%
57%
38%
0%
4.83%
2.33%
7.64%
Current
15%
35%
50%
0%
5.05%
2.55%
9.98%
Balanced I
4%
51%
45%
0%
5.10%
2.60%
8.92%
Balanced II
4%
42%
54%
0%
5.46%
2.96%
10.59%
Total Return I
4%
35%
61%
0%
5.81%
3.31%
12.09%
Total Return II
3%
25%
72%
0%
6.27%
3.77%
14.23%
Capital Growth I
2%
16%
82%
0%
6.70%
4.20%
16.26%
Capital Growth II
0%
9%
91%
0%
7.10%
4.60%
18.02%
Equity Growth
0%
0%
100%
0%
7.47%
4.97%
19.80%
The Target Portfolio you selected is : Total Return I Efficient Frontier Graph When deciding how to invest your money, you must determine the amount of risk you are willing to assume to pursue a desired return. The Efficient Frontier Graph reflects a set of portfolios that assume a low relative level of risk for each level of return, or conversely an optimal return for the degree of investment risk taken. The graph also shows the position of the Current, Target, Risk-Based, and Custom Portfolios, if applicable. The positioning of these portfolios illustrates how their respective risks and returns compare to each other as well as the optimized level of risk and return represented by the Portfolios. This graph shows the relationship of return and risk for each Portfolio in the chart above.
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 2 of 11
Portfolio Detail Portfolio Detail - Total Return I This chart summarizes the growth and return information for the portfolio for this period.
Portfolio Information Average Total Return
5.81%
Inflation
2.50%
Average Real Return
3.31%
Standard Deviation
12.09%
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 3 of 11
Distribution and Reallocation by Asset Class Description
Cash & Cash Alternatives
Short Term Intermediate Bonds Term Bonds
Long Term Bonds
Large Cap Value Stocks
Large Cap Growth Stocks
Mid Cap Stocks
Small Cap Stocks
International International Unclassified Developed Emerging Stocks Stocks
Total Value
Tom's 401(k) Qualified Total
$41,250
$41,250
$27,500
$27,500
$68,750
$68,750
$6,750
$4,500
$4,500
$6,750
$11,250
$9,000
$2,250
Total Current Portfolio :
$48,000
$45,750
$32,000
$34,250
$80,000
$77,750
$2,250
$0
$0
$0
$0
Roth Total
$275,000 $45,000 $320,000
Increase / Decrease :
-$35,200
$24,650
$9,600
-$34,250
-$3,200
-$29,750
-$2,250
$25,600
$32,000
$12,800
$0
$0
Total Target Portfolio :
$12,800
$70,400
$41,600
$0
$76,800
$48,000
$0
$25,600
$32,000
$12,800
$0
$320,000
Percent of Total Value :
4%
22%
13%
0%
24%
15%
0%
8%
10%
4%
0%
100%
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 4 of 11
Risk Assessment Portfolio Appropriate for Score
Compare Me to my Group
Bear Market Loss
Total Return I
Average Age 50 to 64
Total Return I
Portfolio Value
$320,000
Great Recession Return from November 2007 through February 2009 Potential loss of Portfolio Value
Average Return: 5.81%
-26% -$81,676
You are a Higher than Average Risk-Taker
You selected a Risk Score for your Household of 60. • The Bell Curve above shows the normal distribution of risk scores for your group. The average score is 50. • Your Score indicates that you are a Higher than Average Risk-Taker (scores 55-62) as compared to other Investors of similar age. • Your Score corresponds to a Total Return I Portfolio with 61% Stock . • You know that the Total Return I Portfolio you selected had a -26% return during the Great Recession and are willing to accept the risk that you could experience a similar or worse result. • You realize that you may be accepting greater risk of loss as a household than Jane might prefer based upon her individual Risk Score. Tom
Jane
Household
65
47
60
Total Return I
Balanced I
Total Return I
61%
45%
61%
Average Return:
5.81%
5.10%
5.81%
Great Recession Return:
-26%
-15%
-26%
6%
2%
6%
Risk Score: Portfolio Selected: % Stock :
Bond Bear Market Return:
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 5 of 11
Monte Carlo Results - Portfolio Accumulation This analysis shows how variations in rates of return can affect the results of the analysis. The simulations were calculated assuming a beginning portfolio value of $320,000, and assets and an allocation you have identified. The analysis is for a period of 20 years of accumulation.
This table illustrates a range of possible results, given the beginning portfolio value, additions, return assumptions, and time frame that you have indicated. The results shown below include only the assets selected. If any annual additions are included, the additions will occur until the end date specified or the end of the period, whichever is earlier.
The selected target portfolio is Total Return I. Current
Total Return I Hypothetical Value in 20 Years
Result High Value:
Current Dollars
Future Dollars
Hypothetical Value in 20 Years Result
Current Dollars
Future Dollars
$1,453,570
$2,293,488
High Value:
$1,805,182
$2,896,146
Median Value:
$752,906
$1,167,490
Median Value:
$763,106
$1,272,419
Low Value:
$342,851
$550,911
Low Value:
$317,146
$511,737
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 6 of 11
Monte Carlo Results - Portfolio Accumulation The chart below displays the year-by-year Portfolio Values for the Low, Median, and High Scenarios from the Monte Carlo Simulation. Current
Total Return I
Low Value
Median Value
High Value
Year / Event
Low Value
Median Value
High Value
$357,062
$311,853
$359,251
2016
$355,858
$300,550
$379,082
$346,999
$363,380
$417,365
2017
$281,217
$313,220
$452,236
$329,848
$380,454
$437,421
2018
$335,786
$312,282
$620,218
$371,659
$421,938
$454,801
2019
$349,783
$336,222
$650,535
$379,686
$451,909
$492,904
2020
$398,730
$373,142
$856,312
$377,531
$526,982
$561,407
2021
$438,709
$418,862
$934,036
$384,769
$579,715
$575,010
2022
$521,403
$483,254
$967,337
$412,240
$607,870
$660,900
2023
$482,058
$572,499
$1,145,001
$444,903
$735,064
$724,212
2024
$509,049
$564,952
$1,203,863
$403,392
$830,741
$898,639
2025
$547,818
$592,235
$1,035,498
$442,524
$860,234
$1,107,669
2026
$577,133
$733,999
$1,089,818
$468,535
$919,195
$1,298,092
2027
$614,748
$839,348
$1,384,324
$494,070
$1,088,678
$1,277,538
2028
$652,144
$1,024,213
$1,473,614
$504,349
$1,044,571
$1,528,049
2029
$607,256
$995,389
$1,612,961
$482,411
$1,173,479
$1,711,621
2030
$748,774
$935,664
$1,717,809
$480,902
$1,080,602
$1,907,857
2031
$598,539
$1,186,046
$1,702,897
$529,560
$1,276,376
$2,009,176
2032
$646,298
$1,039,721
$2,067,064
$448,880
$1,139,293
$2,198,335
2033
$527,884
$1,092,328
$2,146,746
$488,590
$1,053,307
$2,273,728
2034
$547,358
$1,082,295
$2,520,640
$550,911
$1,167,490
$2,293,488
2035
$511,737
$1,272,419
$2,896,146
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 7 of 11
Monte Carlo Results - Portfolio Accumulation Your Monte Carlo results were calculated using the following information: Client
Spouse
First Name :
Tom
Jane
Date of birth :
01/01/1955
03/15/1957
Age :
61
59
Number of years of accumulation :
20
Last year of accumulation :
2035
Tax Rate during accumulation period (marginal) :
30.00%
Inflation rate :
2.50%
The Program will assume that all assets checked will be reinvested into the Target Portfolio you choose. Select Asset Description
Value
Owner
Annual Additions
Tom's 401(k)
$320,000 Tom
$12,960
Jane's 403(b)
$315,000 Jane
$7,875
Variable Annuity with GMWB
$103,000 Tom
Brokerage Account
$272,089 Joint Survivorship
$15,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 8 of 11
Monte Carlo Results - Income Distribution This analysis shows how variations in rates of return can affect the results of the analysis. The simulations were calculated assuming a beginning portfolio value of $320,000, assets and an allocation you have identified, and an after-tax withdrawal of $1,800 per month starting in 2022. The analysis is for a total period of 21 years-- 6 years of accumulation and 15 years of withdrawals.
This table illustrates the likelihood of sustaining a specified withdrawal amount, given the beginning portfolio value, additions, return assumptions, and time frame that you have indicated. The results shown below include only the assets selected. If any annual additions are included, the additions will occur until the year before the withdrawals begin.
The selected target portfolio is Total Return I. Current
Total Return I
Likelihood your money could last for 15 years of distribution is:
80%
Hypothetical Value in 21 Years Result
81%
Likelihood your money could last for 15 years of distribution is:
Years Money Lasted
Current Dollars
Future Dollars
High Value:
15 years
$687,329
$1,146,796
Median Value:
15 years
$155,094
$237,454
Low Value:
10 years
$0
$0
Hypothetical Value in 21 Years Result
Years Money Lasted
Current Dollars
Future Dollars
High Value:
15 years
$911,172
$1,629,940
Median Value:
15 years
$181,830
$316,269
Low Value:
9 years
$0
$0
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 9 of 11
Monte Carlo Results - Income Distribution The chart below displays the year-by-year Portfolio Values for the Low, Median, and High Scenarios from the Monte Carlo Simulation. Current
Total Return I
Low Value
Median Value
High Value
Year / Event
Low Value
Median Value
High Value
$351,589
$353,019
$409,829
2016
$354,503
$287,248
$405,322
$376,831
$434,087
$514,005
2017
$381,246
$355,703
$442,065
$331,508
$382,675
$501,192
2018
$321,456
$372,564
$545,469
$358,346
$435,427
$569,679
2019
$349,505
$462,158
$751,432
$370,760
$422,065
$724,936
2020
$360,396
$510,640
$956,660
$353,985
$492,683
$816,510
2021
$336,766
$572,902
$853,824
$298,000
$525,149
$731,302
2022 / Withdrawals Begin
$275,391
$491,461
$883,996
$291,479
$527,408
$700,666
2023
$269,810
$508,504
$970,437
$274,378
$593,679
$628,300
2024
$253,800
$457,811
$918,588
$251,270
$596,796
$763,339
2025
$231,208
$474,788
$1,067,631
$186,699
$510,790
$829,839
2026
$163,058
$534,814
$1,000,087
$152,592
$484,142
$889,940
2027
$128,586
$600,887
$962,409
$125,779
$445,007
$883,295
2028
$101,098
$681,065
$947,026
$87,457
$411,949
$822,517
2029
$62,604
$653,395
$1,097,983
$54,022
$388,938
$917,470
2030
$26,971
$578,142
$1,534,357
$14,397
$365,031
$1,107,530
2031
$0
$515,244
$2,086,985
$0
$310,450
$1,034,569
2032
$0
$456,084
$1,696,153
$0
$254,454
$977,064
2033
$0
$451,330
$1,450,238
$0
$248,225
$925,678
2034
$0
$458,762
$1,509,811
$0
$258,018
$1,033,361
2035
$0
$365,419
$1,599,076
$0
$237,454
$1,146,796
2036
$0
$316,269
$1,629,940
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 10 of 11
Monte Carlo Results - Income Distribution Your Monte Carlo results were calculated using the following information: Client
Spouse
First Name :
Tom
Jane
Date of birth :
01/01/1955
03/15/1957
Age :
61
59
Monthly withdrawal amount :
$1,800
At what rate will this withdrawal increase :
Program Estimate
Year to start withdrawals :
2022
Number of years money must last :
15
Last year of withdrawals :
2036
Tax Rate during accumulation period (marginal) :
30.00%
Tax Rate after withdrawals begin (average) :
20.00%
Deduct Tax Penalty on early withdrawals from Qualified Assets :
No
Inflation rate :
Yes
2.50%
The Program will assume that all assets checked will be reinvested into the Target Portfolio you choose. Select Asset Description
Value
Owner
Annual Additions
Tom's 401(k)
$320,000 Tom
$12,960
Jane's 403(b)
$315,000 Jane
$7,875
Variable Annuity with GMWB
$103,000 Tom
Brokerage Account
$272,089 Joint Survivorship
$15,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 11 of 11
Tom and Jane Lundquist
Prepared by: Joe Advisor Financial Consultant
April 29, 2016
Table Of Contents Results Comparison Target Band Portfolio Detail Distribution and Reallocation by Asset Class Risk Assessment Monte Carlo Results - Portfolio Accumulation Monte Carlo Results - Income Distribution
1 2 3 4 5 6-8 9 - 11
Results Comparison These charts compare your Current Portfolio with the Target Portfolio you selected and show the allocation changes you should consider. Target Portfolio Total Return I
Current Portfolio Projected Returns 5.05%
Total Return
5.81%
2.50%
Base Inflation Rate
2.50%
2.55%
Real Return
3.31%
9.98%
Standard Deviation
12.09%
Bear Market Returns -20%
Great Recession
-26%
5%
Bond Bear Market
6%
Portfolio Comparison with Allocation Changes Current Amount
% of Total
$48,000
15%
$45,750
14%
$32,000
Asset Class
% of Total
Target Amount
Increase / Decrease
Cash & Cash Alternatives
4%
$12,800
-$35,200
Short Term Bonds
22%
$70,400
$24,650
10%
Intermediate Term Bonds
13%
$41,600
$9,600
$34,250
11%
Long Term Bonds
0%
$0
-$34,250
$80,000
25%
Large Cap Value Stocks
24%
$76,800
-$3,200
$77,750
24%
Large Cap Growth Stocks
15%
$48,000
-$29,750
$2,250
1%
Mid Cap Stocks
0%
$0
-$2,250
$0
0%
Small Cap Stocks
8%
$25,600
$25,600
$0
0%
International Developed Stocks
10%
$32,000
$32,000
$0
0%
International Emerging Stocks
4%
$12,800
$12,800
$0
0%
Unclassified
0%
$0
$0
$320,000
$0
$320,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 1 of 11
Target Band The Risk-Based Portfolio was selected from this list of Portfolios, based upon the risk assessment. The Target Band is comprised of the portfolio(s) that could be appropriate for you, based upon the Risk-Based Portfolio indicated. The Target Portfolio was selected by you. The Average Real Return is equal to the Average Total Return minus the inflation rate of 2.50%. Average Return Current
Risk Based
Target Name
Cash
Bond
Stock
Alternative
Total
Real
Standard Deviation
Capital Preservation I
5%
67%
28%
0%
4.42%
1.92%
5.89%
Capital Preservation II
5%
57%
38%
0%
4.83%
2.33%
7.64%
Current
15%
35%
50%
0%
5.05%
2.55%
9.98%
Balanced I
4%
51%
45%
0%
5.10%
2.60%
8.92%
Balanced II
4%
42%
54%
0%
5.46%
2.96%
10.59%
Total Return I
4%
35%
61%
0%
5.81%
3.31%
12.09%
Total Return II
3%
25%
72%
0%
6.27%
3.77%
14.23%
Capital Growth I
2%
16%
82%
0%
6.70%
4.20%
16.26%
Capital Growth II
0%
9%
91%
0%
7.10%
4.60%
18.02%
Equity Growth
0%
0%
100%
0%
7.47%
4.97%
19.80%
The Target Portfolio you selected is : Total Return I Efficient Frontier Graph When deciding how to invest your money, you must determine the amount of risk you are willing to assume to pursue a desired return. The Efficient Frontier Graph reflects a set of portfolios that assume a low relative level of risk for each level of return, or conversely an optimal return for the degree of investment risk taken. The graph also shows the position of the Current, Target, Risk-Based, and Custom Portfolios, if applicable. The positioning of these portfolios illustrates how their respective risks and returns compare to each other as well as the optimized level of risk and return represented by the Portfolios. This graph shows the relationship of return and risk for each Portfolio in the chart above.
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 2 of 11
Portfolio Detail Portfolio Detail - Total Return I This chart summarizes the growth and return information for the portfolio for this period.
Portfolio Information Average Total Return
5.81%
Inflation
2.50%
Average Real Return
3.31%
Standard Deviation
12.09%
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 3 of 11
Distribution and Reallocation by Asset Class Description
Cash & Cash Alternatives
Short Term Intermediate Bonds Term Bonds
Long Term Bonds
Large Cap Value Stocks
Large Cap Growth Stocks
Mid Cap Stocks
Small Cap Stocks
International International Unclassified Developed Emerging Stocks Stocks
Total Value
Tom's 401(k) Qualified Total
$41,250
$41,250
$27,500
$27,500
$68,750
$68,750
$6,750
$4,500
$4,500
$6,750
$11,250
$9,000
$2,250
Total Current Portfolio :
$48,000
$45,750
$32,000
$34,250
$80,000
$77,750
$2,250
$0
$0
$0
$0
Roth Total
$275,000 $45,000 $320,000
Increase / Decrease :
-$35,200
$24,650
$9,600
-$34,250
-$3,200
-$29,750
-$2,250
$25,600
$32,000
$12,800
$0
$0
Total Target Portfolio :
$12,800
$70,400
$41,600
$0
$76,800
$48,000
$0
$25,600
$32,000
$12,800
$0
$320,000
Percent of Total Value :
4%
22%
13%
0%
24%
15%
0%
8%
10%
4%
0%
100%
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 4 of 11
Risk Assessment Portfolio Appropriate for Score
Compare Me to my Group
Bear Market Loss
Total Return I
Average Age 50 to 64
Total Return I
Portfolio Value
$320,000
Great Recession Return from November 2007 through February 2009 Potential loss of Portfolio Value
Average Return: 5.81%
-26% -$81,676
You are a Higher than Average Risk-Taker
You selected a Risk Score for your Household of 60. • The Bell Curve above shows the normal distribution of risk scores for your group. The average score is 50. • Your Score indicates that you are a Higher than Average Risk-Taker (scores 55-62) as compared to other Investors of similar age. • Your Score corresponds to a Total Return I Portfolio with 61% Stock . • You know that the Total Return I Portfolio you selected had a -26% return during the Great Recession and are willing to accept the risk that you could experience a similar or worse result. • You realize that you may be accepting greater risk of loss as a household than Jane might prefer based upon her individual Risk Score. Tom
Jane
Household
65
47
60
Total Return I
Balanced I
Total Return I
61%
45%
61%
Average Return:
5.81%
5.10%
5.81%
Great Recession Return:
-26%
-15%
-26%
6%
2%
6%
Risk Score: Portfolio Selected: % Stock :
Bond Bear Market Return:
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 5 of 11
Monte Carlo Results - Portfolio Accumulation This analysis shows how variations in rates of return can affect the results of the analysis. The simulations were calculated assuming a beginning portfolio value of $320,000, and assets and an allocation you have identified. The analysis is for a period of 20 years of accumulation.
This table illustrates a range of possible results, given the beginning portfolio value, additions, return assumptions, and time frame that you have indicated. The results shown below include only the assets selected. If any annual additions are included, the additions will occur until the end date specified or the end of the period, whichever is earlier.
The selected target portfolio is Total Return I. Current
Total Return I Hypothetical Value in 20 Years
Result High Value:
Current Dollars
Future Dollars
Hypothetical Value in 20 Years Result
Current Dollars
Future Dollars
$1,453,570
$2,293,488
High Value:
$1,805,182
$2,896,146
Median Value:
$752,906
$1,167,490
Median Value:
$763,106
$1,272,419
Low Value:
$342,851
$550,911
Low Value:
$317,146
$511,737
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 6 of 11
Monte Carlo Results - Portfolio Accumulation The chart below displays the year-by-year Portfolio Values for the Low, Median, and High Scenarios from the Monte Carlo Simulation. Current
Total Return I
Low Value
Median Value
High Value
Year / Event
Low Value
Median Value
High Value
$357,062
$311,853
$359,251
2016
$355,858
$300,550
$379,082
$346,999
$363,380
$417,365
2017
$281,217
$313,220
$452,236
$329,848
$380,454
$437,421
2018
$335,786
$312,282
$620,218
$371,659
$421,938
$454,801
2019
$349,783
$336,222
$650,535
$379,686
$451,909
$492,904
2020
$398,730
$373,142
$856,312
$377,531
$526,982
$561,407
2021
$438,709
$418,862
$934,036
$384,769
$579,715
$575,010
2022
$521,403
$483,254
$967,337
$412,240
$607,870
$660,900
2023
$482,058
$572,499
$1,145,001
$444,903
$735,064
$724,212
2024
$509,049
$564,952
$1,203,863
$403,392
$830,741
$898,639
2025
$547,818
$592,235
$1,035,498
$442,524
$860,234
$1,107,669
2026
$577,133
$733,999
$1,089,818
$468,535
$919,195
$1,298,092
2027
$614,748
$839,348
$1,384,324
$494,070
$1,088,678
$1,277,538
2028
$652,144
$1,024,213
$1,473,614
$504,349
$1,044,571
$1,528,049
2029
$607,256
$995,389
$1,612,961
$482,411
$1,173,479
$1,711,621
2030
$748,774
$935,664
$1,717,809
$480,902
$1,080,602
$1,907,857
2031
$598,539
$1,186,046
$1,702,897
$529,560
$1,276,376
$2,009,176
2032
$646,298
$1,039,721
$2,067,064
$448,880
$1,139,293
$2,198,335
2033
$527,884
$1,092,328
$2,146,746
$488,590
$1,053,307
$2,273,728
2034
$547,358
$1,082,295
$2,520,640
$550,911
$1,167,490
$2,293,488
2035
$511,737
$1,272,419
$2,896,146
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 7 of 11
Monte Carlo Results - Portfolio Accumulation Your Monte Carlo results were calculated using the following information: Client
Spouse
First Name :
Tom
Jane
Date of birth :
01/01/1955
03/15/1957
Age :
61
59
Number of years of accumulation :
20
Last year of accumulation :
2035
Tax Rate during accumulation period (marginal) :
30.00%
Inflation rate :
2.50%
The Program will assume that all assets checked will be reinvested into the Target Portfolio you choose. Select Asset Description
Value
Owner
Annual Additions
Tom's 401(k)
$320,000 Tom
$12,960
Jane's 403(b)
$315,000 Jane
$7,875
Variable Annuity with GMWB
$103,000 Tom
Brokerage Account
$272,089 Joint Survivorship
$15,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 8 of 11
Monte Carlo Results - Income Distribution This analysis shows how variations in rates of return can affect the results of the analysis. The simulations were calculated assuming a beginning portfolio value of $320,000, assets and an allocation you have identified, and an after-tax withdrawal of $1,800 per month starting in 2022. The analysis is for a total period of 21 years-- 6 years of accumulation and 15 years of withdrawals.
This table illustrates the likelihood of sustaining a specified withdrawal amount, given the beginning portfolio value, additions, return assumptions, and time frame that you have indicated. The results shown below include only the assets selected. If any annual additions are included, the additions will occur until the year before the withdrawals begin.
The selected target portfolio is Total Return I. Current
Total Return I
Likelihood your money could last for 15 years of distribution is:
80%
Hypothetical Value in 21 Years Result
81%
Likelihood your money could last for 15 years of distribution is:
Years Money Lasted
Current Dollars
Future Dollars
High Value:
15 years
$687,329
$1,146,796
Median Value:
15 years
$155,094
$237,454
Low Value:
10 years
$0
$0
Hypothetical Value in 21 Years Result
Years Money Lasted
Current Dollars
Future Dollars
High Value:
15 years
$911,172
$1,629,940
Median Value:
15 years
$181,830
$316,269
Low Value:
9 years
$0
$0
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 9 of 11
Monte Carlo Results - Income Distribution The chart below displays the year-by-year Portfolio Values for the Low, Median, and High Scenarios from the Monte Carlo Simulation. Current
Total Return I
Low Value
Median Value
High Value
Year / Event
Low Value
Median Value
High Value
$351,589
$353,019
$409,829
2016
$354,503
$287,248
$405,322
$376,831
$434,087
$514,005
2017
$381,246
$355,703
$442,065
$331,508
$382,675
$501,192
2018
$321,456
$372,564
$545,469
$358,346
$435,427
$569,679
2019
$349,505
$462,158
$751,432
$370,760
$422,065
$724,936
2020
$360,396
$510,640
$956,660
$353,985
$492,683
$816,510
2021
$336,766
$572,902
$853,824
$298,000
$525,149
$731,302
2022 / Withdrawals Begin
$275,391
$491,461
$883,996
$291,479
$527,408
$700,666
2023
$269,810
$508,504
$970,437
$274,378
$593,679
$628,300
2024
$253,800
$457,811
$918,588
$251,270
$596,796
$763,339
2025
$231,208
$474,788
$1,067,631
$186,699
$510,790
$829,839
2026
$163,058
$534,814
$1,000,087
$152,592
$484,142
$889,940
2027
$128,586
$600,887
$962,409
$125,779
$445,007
$883,295
2028
$101,098
$681,065
$947,026
$87,457
$411,949
$822,517
2029
$62,604
$653,395
$1,097,983
$54,022
$388,938
$917,470
2030
$26,971
$578,142
$1,534,357
$14,397
$365,031
$1,107,530
2031
$0
$515,244
$2,086,985
$0
$310,450
$1,034,569
2032
$0
$456,084
$1,696,153
$0
$254,454
$977,064
2033
$0
$451,330
$1,450,238
$0
$248,225
$925,678
2034
$0
$458,762
$1,509,811
$0
$258,018
$1,033,361
2035
$0
$365,419
$1,599,076
$0
$237,454
$1,146,796
2036
$0
$316,269
$1,629,940
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 10 of 11
Monte Carlo Results - Income Distribution Your Monte Carlo results were calculated using the following information: Client
Spouse
First Name :
Tom
Jane
Date of birth :
01/01/1955
03/15/1957
Age :
61
59
Monthly withdrawal amount :
$1,800
At what rate will this withdrawal increase :
Program Estimate
Year to start withdrawals :
2022
Number of years money must last :
15
Last year of withdrawals :
2036
Tax Rate during accumulation period (marginal) :
30.00%
Tax Rate after withdrawals begin (average) :
20.00%
Deduct Tax Penalty on early withdrawals from Qualified Assets :
No
Inflation rate :
Yes
2.50%
The Program will assume that all assets checked will be reinvested into the Target Portfolio you choose. Select Asset Description
Value
Owner
Annual Additions
Tom's 401(k)
$320,000 Tom
$12,960
Jane's 403(b)
$315,000 Jane
$7,875
Variable Annuity with GMWB
$103,000 Tom
Brokerage Account
$272,089 Joint Survivorship
$15,000
See Important Disclosure Information section in this Report for explanations of assumptions, limitations, methodologies, and a glossary. Prepared for : Tom and Jane Lundquist 04/29/2016
Company: PIEtech
Prepared by: Joe Advisor Page 11 of 11
