I got this at 5% with $27k yearly earning and starting from £390k:
Year Year number Total invested Yearly Earning
2021 1 £436,500 £19,500
2022 2 £485,325 £21,825
2023 3 £536,591 £24,266
2024 4 £590,421 £26,830
2025 5 £646,942 £29,521
2026 6 £706,289 £32,347
2027 7 £768,603 £35,314
2028 8 £834,034 £38,430
2029 9 £902,735 £41,702
2030 10 £974,872 £45,137
2031 11 £1,050,616 £48,744
I'll have to check my formula in my spreadsheet. Thank you.
I just did quick and dirty one and got this at 5%
Investment Additional Yearly Earning Cash Total
Jun-20 390,000 15,000 10,125 54,000 469,125
2021 415,125 30,000 22,256 50,000 517,381
2022 467,381 30,000 24,869 50,000 572,250
2023 522,250 30,000 27,613 55,000 634,863
2024 579,863 30,000 30,493 55,000 695,356
2025 640,356 30,000 33,518 60,000 763,874
2026 703,874 30,000 36,694 60,000 830,567
2027 770,567 30,000 40,028 60,000 900,596
2028 840,596 30,000 43,530 60,000 974,126
2029 914,126 30,000 47,206 60,000 1,051,332
2030 991,332 30,000 51,067 60,000 1,132,398
2031 1,072,398 30,000 55,120 60,000 1,217,518
2032 1,157,518 30,000 59,376 50,000 1,296,894
2033 1,246,894 30,000 63,845 50,000 1,390,739
And this at 7%
Investment Additional Yearly Earning Cash Total
Jun-20 390,000 15,000 14,175 54,000 473,175
2021 419,175 30,000 31,442 50,000 530,617
2022 480,617 30,000 35,743 50,000 596,360
2023 546,360 30,000 40,345 55,000 671,706
2024 616,706 30,000 45,269 55,000 746,975
2025 691,975 30,000 50,538 60,000 832,513
2026 772,513 30,000 56,176 60,000 918,689
2027 858,689 30,000 62,208 60,000 1,010,898
2028 950,898 30,000 68,663 60,000 1,109,560
2029 1,049,560 30,000 75,569 60,000 1,215,130
2030 1,155,130 30,000 82,959 60,000 1,328,089
2031 1,268,089 30,000 90,866 60,000 1,448,955
2032 1,388,955 30,000 99,327 50,000 1,568,282
2033 1,518,282 30,000 108,380 50,000 1,706,661
This is helpful. I need to do more work on my calculations and projections.