Spreadsheet: 71289d1271960577-stopping-spreadsheet-at-a-certain-number-roadmap-template
Sheet: WS... Client Additions

 |  |  |  |  |  |  |  |  |  |  |  |  | Cash Flows: Sam & Sally Sample
 |  |  |  |  |  |  |  |  |  |  |  |  | This is a "what if" analysis showing your investment progress throughout the years.
 |  |  | Retirement Age: |  |  | Risk Profile:
 |  |  | 65 |  |  | [NAME] |  | "Growth Phase" ROR: | 0.095 |  | Inflation to Use: | 0.0343
 |  |  |  |  |  |  |  | Post-retirement ROR: | 0.06
 |  |  | Begin | College | Other | Desired | After | [NAME] | Income Stream | Client | Investment Value | Investment Value
 | Year | Age | Investmnts | Expenses | Expenses | Income | Tax Gains | Sources | Additions | Additions | Future Dollars | Today's Dollars
 | 2009 | 53 | 1000000 | 0 | 0 | 0 | 90012.5 | 0 | 0 | 430791.220902427 | 1520803.720902427 | 1470370.028910787
 | 2010 | 54 | 1520803.720902427 | 0 | 0 | 0 | 136891.3449277297 | 0 | 0 | 445567.3597793803 | 2103262.425609537 | 1966076.507822244 |  | Monthly Additions: | 35899.26840853559
 | 2011 | 55 | 2103262.425609537 | 111154.849 | 0 | 0 | 179314.583239566 | 0 | 0 | 460850.320219813 | 2632272.480068916 | 2378982.620138637
 | 2012 | 56 | 2632272.480068916 | 117190.5573007 | 0 | 0 | 226388.8115731741 | 0 | 0 | 476657.4862033526 | 3218128.220544743 | 2812012.488161283 |  | Assets@94 | 8534101.995565318
 | 2013 | 57 | 3218128.220544743 | 0 | 0 | 0 | 289671.7664517837 | 0 | 0 | 493006.8379801276 | 4000806.824976654 | 3379986.447988327 |  | Assets@93: | 8534101.995565318
 | 2014 | 58 | 4000806.824976654 | 0 | 0 | 0 | 360122.6243332111 | 0 | 0 | 509916.972522846 | 4870846.421832711 | 3978554.286996329 |  | Difference: | 0
 | 2015 | 59 | 4870846.421832711 | 0 | 0 | 0 | 438437.0635452169 | 0 | 0 | 527407.1246803796 | 5836690.610058308 | 4609363.94243161
 | 2016 | 60 | 5836690.610058308 | 0 | 0 | 0 | 525375.1135378735 | 0 | 0 | 545497.1890569165 | 6907562.912653097 | 5274152.117569526
 | 2017 | 61 | 6907562.912653097 | 0 | 0 | 0 | 621767.0066751869 | 0 | 0 | 564207.7426415689 | 8093537.661969853 | 5974749.063090669
 | 2018 | 62 | 8093537.661969853 | 0 | 0 | 0 | 728519.5587980613 | 0 | 0 | 583560.0682141747 | 9405617.288982088 | 6713083.616005555
 | 2019 | 63 | 9405617.288982088 | 0 | 0 | 0 | 846623.1262245001 | 0 | 0 | 603576.1785539209 | 10855816.59376051 | 7491188.510000659
 | 2020 | 64 | 10855816.59376051 | 0 | 0 | 0 | 977159.1911458678 | 0 | 0 | 624278.8414783204 | 12457254.6263847 | 8311205.97182589
 | 2021 | 65 | 12457254.6263847 | 0 | 0 | 359724.1026714094 | 687744.6102731003 | 955517.147720931 | 0 | 0 | 13740792.28170732 | 8863534.788092617
 | 2022 | 66 | 13740792.28170732 | 0 | 0 | 372062.6393930386 | 760012.2801655668 | 0 | 0 | 0 | 14128741.92247985 | 8811546.689350942
 | 2023 | 67 | 14128741.92247985 | 0 | 0 | 384824.3879242199 | 781341.7118394873 | 0 | 0 | 0 | 14525259.24639511 | 8758425.136459969
 | 2024 | 68 | 14525259.24639511 | 0 | 0 | 398023.8644300206 | 803133.3314647155 | 0 | 0 | 0 | 14930368.71342981 | 8704145.417642575
 | 2025 | 69 | 14930368.71342981 | 0 | 0 | 411676.0829799704 | 825387.6760410733 | 0 | 0 | 0 | 15344080.30649091 | 8648682.28235092
 | 2026 | 70 | 15344080.30649091 | 0 | 0 | 425796.5726261834 | 848104.4302702099 | 0 | 0 | 0 | 15766388.16413494 | 8592009.929520033
 | 2027 | 71 | 15766388.16413494 | 0 | 0 | 440401.3950672614 | 871282.3478214975 | 0 | 0 | 0 | 16197269.11688918 | 8534101.995565357
 | 2028 | 72 | 16197269.11688918 | 0 | 0 | 455507.1629180685 | 894919.1670832575 | 0 | 116154.3265441075 | 0 | 16752835.44759847 | 8534101.995565355
 | 2029 | 73 | 16752835.44759847 | 0 | 0 | 471131.0586061583 | 925614.8945142131 | 0 | 120138.4199445704 | 0 | 17327457.7034511 | 8534101.995565353
 | 2030 | 74 | 17327457.7034511 | 0 | 0 | 487290.8539163495 | 957363.4853960503 | 0 | 124259.1677486691 | 0 | 17921789.50267946 | 8534101.99556535
 | 2031 | 75 | 17921789.50267946 | 0 | 0 | 504004.9302056803 | 990201.0529451345 | 0 | 128521.2572024485 | 0 | 18536506.88262137 | 8534101.99556535
 | 2032 | 76 | 18536506.88262137 | 0 | 0 | 521292.2993117351 | 1024164.949061153 | 0 | 132929.5363244925 | 0 | 19172309.06869528 | 8534101.995565347
 | 2033 | 77 | 19172309.06869528 | 0 | 0 | 539172.6251781278 | 1059293.80681395 | 0 | 137489.0194204226 | 0 | 19829919.26975152 | 8534101.995565346
 | 2034 | 78 | 19829919.26975152 | 0 | 0 | 557666.2462217376 | 1095627.584387668 | 0 | 142204.8927865431 | 0 | 20510085.500704 | 8534101.995565346
 | 2035 | 79 | 20510085.500704 | 0 | 0 | 576794.198467143 | 1133207.610532165 | 0 | 147082.5206091215 | 0 | 21213581.43337814 | 8534101.995565344
 | 2036 | 80 | 21213581.43337814 | 0 | 0 | 596578.2394745661 | 1172076.631573418 | 0 | 152127.4510660144 | 0 | 21941207.27654301 | 8534101.995565342
 | 2037 | 81 | 21941207.27654301 | 0 | 0 | 617040.8730885438 | 1212278.860036387 | 0 | 157345.4226375787 | 0 | 22693790.68612843 | 8534101.995565342
 | 2038 | 82 | 22693790.68612843 | 0 | 0 | 638205.3750354808 | 1253860.024935634 | 0 | 162742.3706340476 | 0 | 23472187.70666264 | 8534101.99556534
 | 2039 | 83 | 23472187.70666264 | 0 | 0 | 660095.8193991978 | 1296867.423790926 | 0 | 168324.4339467955 | 0 | 24277283.74500116 | 8534101.995565342
 | 2040 | 84 | 24277283.74500116 | 0 | 0 | 682737.1060045902 | 1341349.976426955 | 0 | 174097.9620311705 | 0 | 25109994.5774547 | 8534101.995565336
 | 2041 | 85 | 25109994.5774547 | 0 | 0 | 706154.9887405478 | 1387358.280618399 | 0 | 180069.5221288397 | 0 | 25971267.39146139 | 8534101.995565334
 | 2042 | 86 | 25971267.39146139 | 0 | 0 | 730376.1048543487 | 1434944.66964361 | 0 | 186245.9067378589 | 0 | 26862081.86298851 | 8534101.995565334
 | 2043 | 87 | 26862081.86298851 | 0 | 0 | 755428.0052508527 | 1484163.271812386 | 0 | 192634.1413389674 | 0 | 27783451.27088901 | 8534101.995565334
 | 2044 | 88 | 27783451.27088901 | 0 | 0 | 781339.1858309569 | 1535070.07203555 | 0 | 199241.492386894 | 0 | 28736423.6494805 | 8534101.99556533
 | 2045 | 89 | 28736423.6494805 | 0 | 0 | 808139.1199049589 | 1587722.975506369 | 0 | 206075.4755757645 | 0 | 29722082.98065767 | 8534101.995565327
 | 2046 | 90 | 29722082.98065767 | 0 | 0 | 835858.291717699 | 1642181.873566237 | 0 | 213143.8643880133 | 0 | 30741550.42689422 | 8534101.995565325
 | 2047 | 91 | 30741550.42689422 | 0 | 0 | 864528.2311236161 | 1698508.711829559 | 0 | 220454.6989365221 | 0 | 31795985.60653668 | 8534101.995565325
 | 2048 | 92 | 31795985.60653668 | 0 | 0 | 894181.5494511559 | 1756767.560645312 | 0 | 228016.2951100448 | 0 | 32886587.91284088 | 8534101.99556532
 | 2049 | 93 | 32886587.91284088 | 0 | 0 | 924851.9765973308 | 1817024.687975446 | 0 | 235837.2540323193 | 0 | 34014597.87825131 | 8534101.995565318
 | 2050 | 94 | 34014597.87825131 | 0 | 0 | 956574.3993946193 | 1879348.634773003 | 0 | 243926.4718456279 | 0 | 35181298.58547533 | 8534101.995565318
 | 2051 | 95 | 35181298.58547533 | 0 | 0 | 989384.9012938545 | 1943810.292945717 | 0 | 0 | 0 | 36135723.97712719 | 8474931.54211854
 | 2052 | 96 | 36135723.97712719 | 0 | 0 | 1023320.803408234 | 1996140.120425923 | 0 | 0 | 0 | 37108543.29414488 | 8414471.043496063
 | 2053 | 97 | 37108543.29414488 | 0 | 0 | 1058420.706965137 | 2049449.469081169 | 0 | 0 | 0 | 38099572.05626092 | 8352692.373894244
 | 2054 | 98 | 38099572.05626092 | 0 | 0 | 1094724.537214041 | 2103725.581457815 | 0 | 0 | 0 | 39108573.1005047 | 8289566.794305453
 | 2055 | 99 | 39108573.1005047 | 0 | 0 | 1132273.588840482 | 2158952.627238111 | 0 | 0 | 0 | 40135252.13890232 | 8225064.939148912
 | 2056 | 100 | 40135252.13890232 | 0 | 0 | 1171110.57293771 | 2215111.448025088 | 0 | 0 | 0 | 41179253.01398969 | 8159156.802610002
 | 2057 | 101 | 41179253.01398969 | 0 | 0 | 1211279.665589474 | 2272179.284856553 | 0 | 0 | 0 | 42240152.63325677 | 8091811.724681794
 | 2058 | 102 | 42240152.63325677 | 0 | 0 | 1252826.558119193 | 2330129.487371571 | 0 | 0 | 0 | 43317455.56250915 | 8022998.376902209
 | 2059 | 103 | 43317455.56250915 | 0 | 0 | 1295798.509062682 | 2388931.203488431 | 0 | 0 | 0 | 44410588.2569349 | 7952684.747780236
 | 2060 | 104 | 44410588.2569349 | 0 | 0 | 1340244.397923531 | 2448549.048384796 | 0 | 0 | 0 | 45518892.90739616 | 7880838.127904422
 | 2061 | 105 | 45518892.90739616 | 0 | 0 | 1386214.780772309 | 2508942.751498566 | 0 | 0 | 0 | 46641620.87812242 | 7807425.094726662
 | 2062 | 106 | 46641620.87812242 | 0 | 0 | 1433761.947752799 | 2570066.780191513 | 0 | 0 | 0 | 47777925.71056113 | 7732411.497014283
 | 2063 | 107 | 47777925.71056113 | 0 | 0 | 1482939.98256072 | 2631869.938636824 | 0 | 0 | 0 | 48926855.66663724 | 7655762.438963112
 | 2064 | 108 | 48926855.66663724 | 0 | 0 | 1533804.823962552 | 2694294.940406056 | 0 | 0 | 0 | 50087345.78308074 | 7577442.263964191
 | 2065 | 109 | 50087345.78308074 | 0 | 0 | 1586414.329424468 | 2757277.953140359 | 0 | 0 | 0 | 51258209.40679663 | 7497414.538016586
 | 2066 | 110 | 51258209.40679663 | 0 | 0 | 1640828.340923728 | 2820748.113594874 | 0 | 0 | 0 | 52438129.17946777 | 7415642.032778528
 | 2067 | 111 | 52438129.17946777 | 0 | 0 | 1697108.753017411 | 2884627.011243703 | 0 | 0 | 0 | 53625647.43769407 | 7332086.708249044
 | 2068 | 112 | 53625647.43769407 | 0 | 0 | 1755319.583245908 | 2948828.138525377 | 0 | 0 | 0 | 54819155.99297353 | 7246709.695072028
 | 2069 | 113 | 54819155.99297353 | 0 | 0 | 1815527.044951244 | 3013256.305695067 | 0 | 0 | 0 | 56016885.25371735 | 7159471.276454484
 | 2070 | 114 | 56016885.25371735 | 0 | 0 | 1877799.622593071 | 3077807.018129415 | 0 | 0 | 0 | 57216892.6492537 | 7070330.869690537
 | 2071 | 115 | 57216892.6492537 | 0 | 0 | 1942208.149648013 | 3142365.813802583 | 0 | 0 | 0 | 58417050.31340827 | 6979247.007282651
 | 2072 | 116 | 58417050.31340827 | 0 | 0 | 2008825.88918094 | 3206807.558517324 | 0 | 0 | 0 | 59615031.98274465 | 6886177.317651229
 | 2073 | 117 | 59615031.98274465 | 0 | 0 | 2077728.617179847 | 3270995.696332359 | 0 | 0 | 0 | 60808299.06189716 | 6791078.505423669