Spreadsheet: 71289d1271960577-stopping-spreadsheet-at-a-certain-number-roadmap-template
Sheet: Calculations

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly Investor Contributions
Risk Questionnaire Scoring: |  |  |  |  |  |  |  | Income Streams Future Values, Sequencing, and Summation |  |  |  |  |  |  |  |  |  | - Annualized and Inflated
 |  |  |  |  |  |  |  | 53 |  |  |  |  |  |  |  |  |  | 53
Points | Totals | Mult | Pct. | Sect. % | Result
0
0.7 |  |  |  |  |  |  |  | 53 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 53 | 62058
0 |  |  |  |  |  |  |  | 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 54 | 64186.5894
0 |  |  |  |  |  |  |  | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 55 | 66388.18941641999
0 | 0.7 | 1 | 0.7 |  |  |  |  | 56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 56 | 68665.3043134032
 |  |  |  |  |  |  |  | 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 57 | 71020.52425135294
 |  |  |  |  |  |  |  | 58 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 58 | 73456.52823317435
0 |  |  |  |  |  |  |  | 59 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 59 | 75976.08715157221
0.7 |  |  |  |  |  |  |  | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 60 | 78582.06694087115
0 |  |  |  |  |  |  |  | 61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 61 | 81277.43183694304
0 |  |  |  |  |  |  |  | 62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 62 | 84065.24774895018
0 | 0.7 | 1 | 0.7 | 0.7 | 0.7 |  |  | 63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 63 | 86948.68574673917
 |  |  |  |  |  |  |  | 64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 64 | 89931.02566785234
 |  |  |  |  |  |  |  | 65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 65 | 0
0 |  |  |  |  |  |  |  | 66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 66 | 0
0 |  |  |  |  |  |  |  | 67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 67 | 0
0.5 |  |  |  |  |  |  |  | 68 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 68 | 0
0 |  |  |  |  |  |  |  | 69 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 69 | 0
0 | 0.5 | 1 | 0.5 |  |  |  |  | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 70 | 0
 |  |  |  |  |  |  |  | 71 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 71 | 0
 |  |  |  |  |  |  |  | 72 | 3606.098373101376 | 2277.535814590342 | 3795.893024317238 | 0 | 0 | 0 | 116154.3265441075 |  |  | 72 | 0
0.9 |  |  |  |  |  |  |  | 73 | 3729.787547298753 | 2355.655293030791 | 3926.092155051319 | 0 | 0 | 0 | 120138.4199445704 |  |  | 73 | 0
0 |  |  |  |  |  |  |  | 74 | 3857.7192601711 | 2436.454269581748 | 4060.757115969579 | 0 | 0 | 0 | 124259.1677486691 |  |  | 74 | 0
0 |  |  |  |  |  |  |  | 75 | 3990.039030794969 | 2520.024651028401 | 4200.041085047336 | 0 | 0 | 0 | 128521.2572024485 |  |  | 75 | 0
0 |  |  |  |  |  |  |  | 76 | 4126.897369551236 | 2606.461496558675 | 4344.102494264459 | 0 | 0 | 0 | 132929.5363244925 |  |  | 76 | 0
0 | 0.9 | 1 | 0.9 |  |  |  |  | 77 | 4268.449949326845 | 2695.863125890638 | 4493.105209817732 | 0 | 0 | 0 | 137489.0194204226 |  |  | 77 | 0
 |  |  |  |  |  |  |  | 78 | 4414.857782588756 | 2788.331231108688 | 4647.218718514479 | 0 | 0 | 0 | 142204.8927865431 |  |  | 78 | 0
 |  |  |  |  |  |  |  | 79 | 4566.287404531548 | 2883.970992335715 | 4806.618320559525 | 0 | 0 | 0 | 147082.5206091215 |  |  | 79 | 0
0 |  |  |  |  |  |  |  | 80 | 4722.911062506982 | 2982.89119737283 | 4971.485328954717 | 0 | 0 | 0 | 152127.4510660144 |  |  | 80 | 0
0 |  |  |  |  |  |  |  | 81 | 4884.906911950971 | 3085.204365442719 | 5142.007275737865 | 0 | 0 | 0 | 157345.4226375787 |  |  | 81 | 0
0.5 |  |  |  |  |  |  |  | 82 | 5052.459219030889 | 3191.026875177404 | 5318.378125295673 | 0 | 0 | 0 | 162742.3706340476 |  |  | 82 | 0
0 |  |  |  |  |  |  |  | 83 | 5225.75857024365 | 3300.479096995989 | 5500.798494993315 | 0 | 0 | 0 | 168324.4339467955 |  |  | 83 | 0
0 | 0.5 | 1 | 0.5 | 0.6333333333333333 | 0.6333333333333333 |  |  | 84 | 5405.002089203005 | 3413.685530022951 | 5689.475883371585 | 0 | 0 | 0 | 174097.9620311705 |  |  | 84 | 0
 |  |  |  |  |  |  |  | 85 | 5590.39366086267 | 3530.774943702739 | 5884.624906171231 | 0 | 0 | 0 | 180069.5221288397 |  |  | 85 | 0
 |  |  |  |  |  |  |  | 86 | 5782.14416343026 | 3651.880524271743 | 6086.467540452905 | 0 | 0 | 0 | 186245.9067378589 |  |  | 86 | 0
0 |  |  |  |  |  |  |  | 87 | 5980.471708235918 | 3777.140026254264 | 6295.23337709044 | 0 | 0 | 0 | 192634.1413389674 |  |  | 87 | 0
0 |  |  |  |  |  |  |  | 88 | 6185.601887828409 | 3906.695929154785 | 6511.159881924641 | 0 | 0 | 0 | 199241.492386894 |  |  | 88 | 0
0 |  |  |  |  |  |  |  | 89 | 6397.768032580924 | 4040.695599524794 | 6734.492665874657 | 0 | 0 | 0 | 206075.4755757645 |  |  | 89 | 0
0 |  |  |  |  |  |  |  | 90 | 6617.21147609845 | 4179.291458588496 | 6965.485764314159 | 0 | 0 | 0 | 213143.8643880133 |  |  | 90 | 0
0.1 | 0.1 | 1 | 0.1 |  |  |  |  | 91 | 6844.181829728627 | 4322.64115561808 | 7204.401926030134 | 0 | 0 | 0 | 220454.6989365221 |  |  | 91 | 0
 |  |  |  |  |  |  |  | 92 | 7078.937266488318 | 4470.907747255779 | 7451.512912092966 | 0 | 0 | 0 | 228016.2951100448 |  |  | 92 | 0
 |  |  |  |  |  |  |  | 93 | 7321.744814728869 | 4624.259882986654 | 7707.099804977757 | 0 | 0 | 0 | 235837.2540323193 |  |  | 93 | 0
0 |  |  |  |  |  |  |  | 94 | 7572.880661874069 | 4782.871996973096 | 7971.453328288494 | 0 | 0 | 0 | 243926.4718456279 |  |  | 94 | 0
0 |  |  |  |  |  |  |  | 95 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 95 | 0
0.5 |  |  |  |  |  |  |  | 96 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 96 | 0
0 |  |  |  |  |  |  |  | 97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 97 | 0
0 | 0.5 | 1 | 0.5 | 0.3 | 0.5 |  |  | 98 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 98 | 0
 |  |  |  |  |  |  |  | 99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 99 | 0
 | 3.9 |  | 0.1114285714285714 |  | 0.611111111111111 |  |  | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 100 | 0
 |  |  |  |  |  |  |  | 101 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 101 | 0
 |  |  |  |  | [NAME] |  |  | 102 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 102 | 0
 |  |  |  |  | 0.095
 |  |  |  |  |  |  |  | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 103 | 0
 |  |  |  |  |  |  |  | 104 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 104 | 0
 |  |  |  |  |  |  |  | 105 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 105 | 0
 |  |  |  |  |  |  |  | 106 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 106 | 0
 |  |  |  |  |  |  |  | 107 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 107 | 0
 |  |  |  |  |  |  |  | 108 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 108 | 0
 |  |  |  |  |  |  |  | 109 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 109 | 0
 |  |  |  |  |  |  |  | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 110 | 0
 |  |  |  |  |  |  |  | 111 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 111 | 0
 |  |  |  |  |  |  |  | 112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 112 | 0
 |  |  |  |  |  |  |  | 113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 113 | 0
 |  |  |  |  |  |  |  | 114 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 114 | 0
 |  |  |  |  |  |  |  | 115 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 115 | 0
 |  |  |  |  |  |  |  | 116 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 116 | 0
 |  |  |  |  |  |  |  | 117 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 117 | 0
 |  |  |  |  |  |  |  | 118 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 118 | 0