Retirement Account Estimator and Tracker HSA (5/16 ) 5000 Yr - 2015 5170 Yr - 2016 5350 Yr - 2017 5530 Yr - 2018 5650
0
0
1500
0
0
0
0
0
0
0
5170 5350 5530
7393.1
1500
0
9195.4654
1500
0
11059.1112
1500
0
12986.121
1500
0
14978.6491
1500
0
17038.9232
1500
0
19169.2466
1500
0
21372.001
1500
0
23649.649
1500
0
26004.7371
2000
0
26888.8981
2000
0
27803.1207
2000
0
28748.4268
2000
0
29725.8733
2000
0
30736.553
2000
0
31781.5958
2000
0
32862.17
2000
0
33979.4838
2000
0
37202.7862
2000
0
40535.681
1000
0
42947.8941
1000
0
45442.1225
1000
0
48021.1547
1000
0
50,688
1,000
0
53,445
1,000
0
56296.4006
1000
0
59244.4782
500
2500
59190.7904
500
2500
59135.2773
500
2500
59077.8768
0
2500
58501.5246
0
2500
57905.5764
0
2500
57289.366
0
2500
56652.2044
0
2500
55993.3794
0
2500
55312.1543
0
2500
54607.7675
0
2500
53879.4316
0
2500
53126.3323
0
2500
52347.6276
0
2500
51542.4469
0
2500
50709.8901
0
2500
49849.0264
0
2500
5720 7150 7393.1 8893.1 9195.465 10695.47 11059.11 12559.11 12986.12 14486.12 14978.65 16478.65 17038.92 18538.92 19169.25 20669.25 21372 22872 23649.65 25149.65 26004.74 26004.74 26888.9 26888.9 27803.12 27803.12 28748.43 28748.43 29725.87 29725.87 30736.55 30736.55 31781.6 31781.6 32862.17 32862.17 33979.48 35979.48 37,203 39,203 40,536 41535.68 42947.89 43947.89 45442.12 46442.12 48021.15 49021.15 50687.87 51,688 53445.26 54,445 56296.4 57296.4 59244.48 57244.48 59190.79 57190.79 59135.28 57135.28 59077.88 56577.88 58501.52 56001.52 57905.58 55405.58 57289.37 54789.37 56652.2 54152.2 55993.38 53493.38 55312.15 52812.15 54607.77 52107.77 53879.43 51379.43 53126.33 50626.33 52347.63 49847.63 51542.45 49042.45 50709.89 48209.89 49849.03 47349.03
YTD Bal Q1 YTD Q2 YTD Q3 YTD Q4 YTD Age 5170 0 5065 5120 5170 1.034 0 1.01 1.02 1.034 5350 5200 5265 5300 5350 1.034 1 1.02 1.03 1.034 5530 5400 5465 5520 5530 1.034 1 1.02 1.03 1.034 5650 5610 5650 0 0 1 1.01 1.02 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Instructions
Enter at beginning of current year (=) 36 37 E3 (A5) at 36
F = Balance at end of Q1 G = Balance at end of Q2 H = Balance at end of Q3 I = Balance at end of Q4
38 E5 (A7) at 37 39 E7 (A9) at 38 40 E7 (A11) at 39 41
A and D are changeable FUNCTION columns E = YTD Selected Acct Bal B = Net + Contribution $ YTD/Actual and Projected (1/1) (D = A+B) C = Net - Withdrawal $ YTD/Actual and Projected (1/1) (D = A-C) *You will need to be able to access from your account's reporting site the following:
42 43
1. % performance annually on average since account inception 2. Present per Q YTD balance and % performance 3. Present YTD balance and % performance
44 Assumptions: 45 46 47 48 49 50 51 52 53 54 55 56
What will my average % return be per year? 3.4% When will I begin to draw down on my account? Age 67 How much and how often to withdraw? Variable. See Table. How much and how often to contribute? Variable. See Table. How long do I expect to draw down from the acct? From 67 to 95 The RAET annual estimate gains use 'simple interest' calculation assumptions for purposes of simplicity and to err, if at all, on the conservative. These gains are likely not to exceed those calculated when using a 'compound interest' assumption. Compound interest formula and example for Excel: Use in Col. A =P*(1+r/n)^(n*1). P = Principle. r = % interest yearly. n = number of times per year compounded Example: A7 formula is =D5*(1+.034/12)^(12*1). Compouned monthly. Presently, what is my anticipated annual income requirement at retirement, based on 70 to 90% of salary earned at retirement? $ (Ex. Roth IRA, Social Security, IRA and Savings) $96,000 (80%) Presently, what is my actual and goal $ draw down for this account at retirement? Goal Actual
$2,500 $2,500
57 58
For Guidelines, Rules and Restrictions for the selected account, click below:
59
HSA
60 61
Savings Account C and W Log
Contribution $ $ Date
Withdrawal $ Net +/- Yr $ Date
62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
Demo Scenario: This HSA was intiated at age 32. THE RAET was begun at 36. The present YTD HSA balance is $5,650. The owner anticipates a variable $ individual contribution yearly from age 40 through 69, as allowed. Plans are to withdraw from the HSA beginning at age 67.
48958.8933
0
48038.4957
0
47086.8045
0
46102.7559
0
45085.2496
0
44033.1481
0
42945.2751
0
41820.4144
0
40657.3085
0
39454.657
0
38211.1154
0
36925.2933
0
48958.89 2500 46458.89 48038.5 2500 45538.5 47086.8 2500 44586.8 46102.76 2500 43602.76 45085.25 2500 42585.25 44033.15 2500 41533.15 42945.28 2500 40445.28 41820.41 2500 39320.41 40657.31 2500 38157.31 39454.66 2500 36954.66 38211.12 2500 35711.12 36925.29 2500 34425.29
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
84 85 86 87 88 89 90 91 92 93 94 95
All rights reserved. No part of this Retirement Account Estimator and Tracker shall be reproduced or transmitted in any form or by any means electronic, mechanical, magnetic, photographic - including photocopying - recording or by any information storage and retrieval system, without prior permission of JAGF or as permitted through a lawfully purchased license by the end user. Please contact the the JAGF at 773-230-8817 concerning any digital sharing agreement one may pursue. Copyright. John Anthony George Foundation. 2018. Disclaimer: Although we will make every effort to include current and accurate information with respect to this retirement account estimator and tracker (RAET), the potential exists that an error or omission may occur. An Uncommon Way Forward, therefore, does not warrant the accuracy, reliability, or timeliness of any information of this tool or links to other websites or documents included in support or interpretation of the purpose implied or results subsequently provided. Any person or entity who relies on information or results obtained from this RAET does so at his or her own discretion. This RAET is the author’s sincerest effort to be as accurate, informative and assistive as possible. It is further provided with the understanding that the author is not engaged in rendering legal, financial or other like professional services or advice. Should such counsel be required by the user, please seek the competent services of a financial management professional. Also, it should not be presumed by the user of this RAET and its analysis that accruement of occupational or personal prosperity or financial well-being is guaranteed. Finally, the contents of this RAET are subject to change without notice; examples of narrative license are likely; and any errors in grammar, syntax and the like are, of course, unintended. In Good Faith Agreement: The user of this RAET agrees to honor its use as theirs alone and NOT file share with others unless otherwise authorized.
