Spreadsheet: 09e9c917-6132-4c1a-b3b7-71664652b458
Sheet: Sheet1

Stock Price | 10 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Stock Price.1 | 10.1 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
Yield/ Growth | 0.05 | 1% Dividend Growth |  |  |  | Yield/ Growth | 0.02 | 5%  Dividend Growth
Starting Capital | 100000 |  |  |  |  | Starting Capital | 100000
Dividend | 0.5 |  |  |  |  | Dividend | 0.2
Stock A |  |  |  |  |  | Stock B |  |  |  |  |  | Stock C |  |  |  |  |  | Bonds
Year | Stocks | DPS | Annual Income | Stocks |  | Year | Stocks | DPS | Annual Income | Stocks |  | Year | Stocks | DPS | Annual Income | Stocks |  |  | Value | Annual Income
2007 | 10000 | 0.5 | 5000 | 500 |  | 2007 | 10000 | 0.2 | 2000 | 200 |  | 2007 | 10000 | 0.05 | 500 | 50 |  | 2007 | 100000
2008 | 10500 | 0.505 | 5302.5 | 530.25 |  | 2008 | 10200 | 0.21 | 2142 | 214.2 |  | 2008 | 10050 | 0.05500000000000001 | 552.7500000000001 | 55.27500000000001 |  | 2008 | 106000 | 6000
2009 | 11030.25 | 0.51005 | 5625.9790125 | 562.59790125 |  | 2009 | 10414.2 | 0.2205 | 2296.3311 | 229.63311 |  | 2009 | 10105.275 | 0.06050000000000001 | 611.3691375000001 | 61.13691375000001 |  | 2009 | 112360 | 6360
2010 | 11592.84790125 | 0.5151505 | 5972.061392752888 | 597.2061392752887 |  | 2010 | 10643.83311 | 0.231525 | 2464.313460792751 | 246.4313460792751 |  | 2010 | 10166.41191375 | 0.06655000000000001 | 676.5747128600626 | 67.65747128600626 |  | 2010 | 119101.6 | 6741.600000000006
2011 | 12190.05404052529 | 0.520302005 | 6342.509558343659 | 634.2509558343659 |  | 2011 | 10890.26445607928 | 0.24310125 | 2647.436902103443 | 264.7436902103443 |  | 2011 | 10234.06938503601 | 0.07320500000000002 | 749.185049331561 | 74.9185049331561 |  | 2011 | 126247.696 | 7146.096000000005
2012 | 12824.30499635965 | 0.52550502505 | 6739.23671836082 | 673.923671836082 |  | 2012 | 11155.00814628962 | 0.2552563125000001 | 2847.38624532935 | 284.738624532935 |  | 2012 | 10308.98788996916 | 0.08052550000000003 | 830.136404333712 | 83.0136404333712 |  | 2012 | 133822.55776 | 7574.861760000014
2013 | 13498.22866819574 | 0.5307600753005 | 7164.320864354937 | 716.4320864354937 |  | 2013 | 11439.74677082255 | 0.2680191281250001 | 3066.070955486647 | 306.6070955486647 |  | 2013 | 10392.00153040253 | 0.08857805000000003 | 920.5032311600725 | 92.05032311600725 |  | 2013 | 141851.9112256 | 8029.353465599997
2014 | 14214.66075463123 | 0.5360676760535049 | 7620.020156624125 | 762.0020156624125 |  | 2014 | 11746.35386637122 | 0.2814200845312501 | 3305.659898008165 | 330.5659898008165 |  | 2014 | 10484.05185351854 | 0.09743585500000004 | 1021.522556211914 | 102.1522556211914 |  | 2014 | 150363.025899136 | 8511.114673536009
2015 | 14976.66277029364 | 0.54142835281404 | 8108.789854371445 | 810.8789854371445 |  | 2015 | 12076.91985617203 | 0.2954910887578127 | 3568.622197141121 | 356.8622197141121 |  | 2015 | 10586.20410913973 | 0.1071794405000001 | 1134.623433436398 | 113.4623433436398 |  | 2015 | 159384.8074530842 | 9021.781553948182
2016 | 15787.54175573079 | 0.5468426363421804 | 8633.30095506608 | 863.3300955066081 |  | 2016 | 12433.78207588615 | 0.3102656431957033 | 3857.775393130023 | 385.7775393130023 |  | 2016 | 10699.66645248337 | 0.1178973845500001 | 1261.462690305167 | 126.1462690305167 |  | 2016 | 168947.8959002693 | 9563.088447185059
2017 | 16650.8718512374 | 0.5523110627056023 | 9196.460727131725 | 919.6460727131725 |  | 2017 | 12819.55961519915 | 0.3257789253554885 | 4176.342354970198 | 417.6342354970199 |  | 2017 | 10825.81272151389 | 0.1296871230050001 | 1403.968506044066 | 140.3968506044066 |  | 2017 | 179084.7696542854 | 10136.87375401615
2018 | 17570.51792395057 | 0.5578341733326583 | 9801.43534113362 | 980.143534113362 |  | 2018 | 13237.19385069617 | 0.342067871623263 | 4528.018726772183 | 452.8018726772183 |  | 2018 | 10966.20957211829 | 0.1426558353055001 | 1564.393786645706 | 156.4393786645706 |  | 2018 | 189829.8558335426 | 10745.08617925714
2019 | 18550.66145806393 | 0.5634125150659849 | 10451.67482822543 | 1045.167482822543 |  | 2019 | 13689.99572337339 | 0.3591712652044261 | 4917.053084607202 | 491.7053084607202 |  | 2019 | 11122.64895078286 | 0.1569214188360501 | 1745.381854572151 | 174.5381854572151 |  | 2019 | 201219.6471835551 | 11389.79135001256
2020 | 19595.82894088647 | 0.5690466402166448 | 11150.94062107154 | 1115.094062107154 |  | 2020 | 14181.70103183411 | 0.3771298284646474 | 5348.34247747251 | 534.834247747251 |  | 2020 | 11297.18713624008 | 0.1726135607196551 | 1950.047697702683 | 195.0047697702683 |  | 2020 | 213292.8260145684 | 12073.17883101333
2021 | 20710.92300299363 | 0.5747371066188112 | 11903.33596214554 | 1190.333596214554 |  | 2021 | 14716.53527958136 | 0.3959863198878798 | 5827.546646861572 | 582.7546646861572 |  | 2021 | 11492.19190601035 | 0.1898749167916206 | 2182.078981907051 | 218.2078981907051 |  | 2021 | 226090.3955754426 | 12797.56956087411
2022 | 21901.25659920818 | 0.5804844776849993 | 12713.33949763651 | 1271.33394976365 |  | 2022 | 15299.28994426752 | 0.4157856358822738 | 6361.224998024546 | 636.1224998024546 |  | 2022 | 11710.39980420105 | 0.2088624084707827 | 2445.862307261214 | 244.5862307261214 |  | 2022 | 239655.8193099691 | 13565.42373452656
2023 | 23172.59054897183 | 0.5862893224618493 | 13585.84241264255 | 1358.584241264255 |  | 2023 | 15935.41244406997 | 0.4365749176763875 | 6957.001375909129 | 695.7001375909128 |  | 2023 | 11954.98603492717 | 0.229748649317861 | 2746.641894138409 | 274.6641894138409 |  | 2023 | 254035.1684685673 | 14379.34915859817
2024 | 24531.17479023609 | 0.5921522156864678 | 14526.18950543032 | 1452.618950543032 |  | 2024 | 16631.11258166088 | 0.4584036635602069 | 7623.7629365156 | 762.37629365156 |  | 2024 | 12229.65022434101 | 0.2527235142496471 | 3090.720182739446 | 309.0720182739446 |  | 2024 | 269277.2785766813 | 15242.11010811405
2025 | 25983.79374077912 | 0.5980737378433325 | 15540.22464589796 | 1554.022464589796 |  | 2025 | 17393.48887531244 | 0.4813238467382173 | 8371.900973663773 | 837.1900973663772 |  | 2025 | 12538.72224261496 | 0.2779958656746119 | 3485.712944289256 | 348.5712944289256 |  | 2025 | 285433.9152912822 | 16156.6367146009
2026 | 27537.81620536892 | 0.6040544752217658 | 16634.34111668756 | 1663.434111668756 |  | 2026 | 18230.67897267882 | 0.5053900390751281 | 9213.603558368266 | 921.3603558368266 |  | 2026 | 12887.29353704388 | 0.3057954522420731 | 3940.87575533668 | 394.087575533668 |  | 2026 | 302559.9502087592 | 17126.03491747694
2027 | 29201.25031703767 | 0.6100950199739835 | 17815.53739543839 | 1781.553739543839 |  | 2027 | 19152.03932851565 | 0.5306595410288846 | 10163.21239983726 | 1016.321239983726 |  | 2027 | 13281.38111257755 | 0.3363749974662805 | 4467.52453809198 | 446.752453809198 |  | 2027 | 320713.5472212847 | 18153.59701252554
2028 | 30982.80405658151 | 0.6161959701737234 | 19091.47900434762 | 1909.147900434762 |  | 2028 | 20168.36056849937 | 0.5571925180803289 | 11237.65961071418 | 1123.765961071418 |  | 2028 | 13728.13356638675 | 0.3700124972129085 | 5079.580982971113 | 507.9580982971113 |  | 2028 | 339956.3600545618 | 19242.8128332771
2029 | 32891.95195701627 | 0.6223579298754607 | 20470.56712953176 | 2047.056712953176 |  | 2029 | 21292.12652957079 | 0.5850521439843454 | 12457.00427611135 | 1245.700427611135 |  | 2029 | 14236.09166468386 | 0.4070137469341994 | 5794.285010141703 | 579.4285010141703 |  | 2029 | 360353.7416578355 | 20397.38160327374
2030 | 34939.00866996945 | 0.6285815091742153 | 21962.01479882039 | 2196.201479882039 |  | 2030 | 22537.82695718193 | 0.6143047511835626 | 13845.09418114983 | 1384.509418114983 |  | 2030 | 14815.52016569803 | 0.4477151216276194 | 6633.132412961942 | 663.3132412961943 |  | 2030 | 381974.9661573057 | 21621.22449947015
2031 | 37135.21014985149 | 0.6348673242659575 | 23575.93150389024 | 2357.593150389024 |  | 2031 | 23922.33637529691 | 0.6450199887427408 | 15430.38513949407 | 1543.038513949407 |  | 2031 | 15478.83340699423 | 0.4924866337903814 | 7623.118559612687 | 762.3118559612687 |  | 2031 | 404893.4641267441 | 22918.49796943838
2032 | 39492.80330024051 | 0.641215997508617 | 25323.41726257532 | 2532.341726257532 |  | 2032 | 25465.37488924632 | 0.6772709881798779 | 17246.9596156109 | 1724.69596156109 |  | 2032 | 16241.1452629555 | 0.5417352971694196 | 8798.401655398906 | 879.8401655398906 |  | 2032 | 429187.0719743487 | 24293.60784760467
2033 | 42025.14502649804 | 0.6476281574837032 | 27216.66724149634 | 2721.666724149634 |  | 2033 | 27190.07085080741 | 0.7111345375888718 | 19335.79846149759 | 1933.579846149759 |  | 2033 | 17120.98542849539 | 0.5959088268863616 | 10202.54634183318 | 1020.254634183318 |  | 2033 | 454938.2962928097 | 25751.22431846097
2034 | 44746.81175064768 | 0.6541044390585402 | 29269.08819981549 | 2926.90881998155 |  | 2034 | 29123.65069695716 | 0.7466912644683155 | 21746.37556484448 | 2174.637556484448 |  | 2034 | 18141.24006267871 | 0.6554997095749978 | 11891.57759241621 | 1189.157759241621 |  | 2034 | 482234.5940703783 | 27296.29777756863
2035 | 47673.72057062923 | 0.6606454834491257 | 31495.42817420188 | 3149.542817420187 |  | 2035 | 31298.28825344161 | 0.7840258276917312 | 24538.66635323895 | 2453.866635323895 |  | 2035 | 19330.39782192033 | 0.7210496805324976 | 13938.17717406174 | 1393.817717406174 |  | 2035 | 511168.6697146011 | 28934.07564422273
2036 | 50823.26338804942 | 0.667251938283617 | 33911.92100557476 | 3391.192100557476 |  | 2036 | 33752.15488876551 | 0.8232271190763178 | 27785.68923169609 | 2778.568923169609 |  | 2036 | 20724.2155393265 | 0.7931546485857475 | 16437.5078933098 | 1643.75078933098 |  | 2036 | 541838.7898974771 | 30670.12018287607
2037 | 54214.45548860689 | 0.6739244576664531 | 36536.44751284146 | 3653.644751284146 |  | 2037 | 36530.72381193512 | 0.8643884750301338 | 31576.73664754559 | 3157.673664754559 |  | 2037 | 22367.96632865748 | 0.8724701134443222 | 19515.38212028257 | 1951.538212028257 |  | 2037 | 574349.1172913258 | 32510.32739384868
2038 | 57868.10023989104 | 0.6806637022431177 | 39388.71535106008 | 3938.871535106008 |  | 2038 | 39688.39747668968 | 0.9076078987816406 | 36021.50303982889 | 3602.150303982889 |  | 2038 | 24319.50454068574 | 0.9597171247887545 | 23339.84497407398 | 2333.984497407398 |  | 2038 | 608810.0643288054 | 34460.94703747961
2039 | 61806.97177499705 | 0.6874703392655489 | 42490.45985513343 | 4249.045985513343 |  | 2039 | 43290.54778067257 | 0.9529882937207227 | 41255.38526373857 | 4125.538526373857 |  | 2039 | 26653.48903809314 | 1.05568883726763 | 28137.79085175007 | 2813.779085175006 |  | 2039 | 645338.6681885337 | 36528.60385972832
2040 | 66056.0177605104 | 0.6943450426582044 | 45865.6684697527 | 4586.56684697527 |  | 2040 | 47416.08630704643 | 1.000637708406759 | 47446.32394390003 | 4744.632394390003 |  | 2040 | 29467.26812326814 | 1.161257720994393 | 34219.0926247571 | 3421.90926247571 |  | 2040 | 684058.9882798458 | 38720.32009131205
2041 | 70642.58460748567 | 0.7012884930847865 | 49540.83170699816 | 4954.083170699816 |  | 2041 | 52160.71870143643 | 1.050669593827097 | 54803.68113176768 | 5480.368113176768 |  | 2041 | 32889.17738574385 | 1.277383493093833 | 42012.09229398418 | 4201.209229398418 |  | 2041 | 725102.5275766366 | 41043.53929679084
2042 | 75596.66777818548 | 0.7083013780156343 | 53545.22396067888 | 5354.522396067888 |  | 2042 | 57641.0868146132 | 1.103203073518452 | 63589.82413482518 | 6358.982413482518 |  | 2042 | 37090.38661514227 | 1.405121842403216 | 52116.51237611629 | 5211.651237611629 |  | 2042 | 768608.6792312348 | 43506.15165459819
2043 | 80951.19017425337 | 0.7153843917957906 | 57911.21794795363 | 5791.121794795363 |  | 2043 | 64000.06922809572 | 1.158363227194374 | 74135.32673172031 | 7413.532673172032 |  | 2043 | 42302.0378527539 | 1.545634026643538 | 65383.46910157937 | 6538.346910157937 |  | 2043 | 814725.1999851089 | 46116.52075387409
2044 | 86742.31196904872 | 0.7225382357137485 | 62674.63705184803 | 6267.463705184803 |  | 2044 | 71413.60190126774 | 1.216281388554093 | 86859.03488212315 | 8685.903488212314 |  | 2044 | 48840.38476291184 | 1.700197429307892 | 83038.29662031103 | 8303.829662031103 |  | 2044 | 863608.7119842155 | 48883.51199910662
2045 | 93009.77567423352 | 0.7297636180708861 | 67875.15041199014 | 6787.515041199013 |  | 2045 | 80099.50538948005 | 1.277095457981798 | 102294.7145194935 | 10229.47145194935 |  | 2045 | 57144.21442494294 | 1.870217172238681 | 106872.0911116176 | 10687.20911116176 |  | 2045 | 915425.2347032685 | 51816.52271905297
2046 | 99797.29071543254 | 0.737061254251595 | 73556.71626562777 | 7355.671626562777 |  | 2046 | 90328.9768414294 | 1.340950230880888 | 121126.6623507491 | 12112.66623507491 |  | 2046 | 67831.4235361047 | 2.057238889462549 | 139545.4424260799 | 13954.54424260799 |  | 2046 | 970350.7487854647 | 54925.51408219617
2047 | 107152.9623419953 | 0.7444318667941109 | 79768.07978877063 | 7976.807978877063 |  | 2047 | 102441.6430765043 | 1.407997742424932 | 144237.6021820187 | 14423.76021820187 |  | 2047 | 81785.96777871269 | 2.262962778408804 | 185078.6008793686 | 18507.86008793686 |  | 2047 | 1028571.793712593 | 58221.04492712789
2048 | 115129.7703208724 | 0.751876185462052 | 86563.33254197969 | 8656.333254197969 |  | 2048 | 116865.4032947062 | 1.478397629546179 | 172773.5352068518 | 17277.35352068518 |  | 2048 | 100293.8278666495 | 2.489259056249685 | 249657.3193030044 | 24965.73193030044 |  | 2048 | 1090286.101335348 | 61714.30762275553
2049 | 123786.1035750703 | 0.7593949473166726 | 94002.5416029267 | 9400.25416029267 |  | 2049 | 134142.7568153914 | 1.552317511023488 | 208232.1503814973 | 20823.21503814973 |  | 2049 | 125259.55979695 | 2.738184961874654 | 342983.8429670474 | 34298.38429670474 |  | 2049 | 1155703.267415469 | 65417.16608012095