I think you’ve over complicated things. First. Only count liquid assets. Then create a burn down chart.
If I have 500K and earn 6% per year but withdraw 40K per year, it will last 22 years . 40K plus 30K SS(for example, 62+) gives you 70K per year. If you do not have debt or a mortgage, that’s not bad.

This makes you work optional or you could work part time, earning about 30K more per year before it affects your SS(assuming you’re not at full retirement)

Year Savings
initial $500,000
1 $488,712
2 $476,746
3 $464,062
4 $450,617
5 $436,366
6 $421,260
7 $405,247
8 $388,273
9 $370,281
10 $351,210
11 $330,994
12 $309,565
13 $286,850
14 $262,773
15 $237,251
16 $210,198
17 $181,521
18 $151,124
19 $118,903
20 $84,749
21 $48,545
22 $10,169