I'm attempting to analyze percentage of ending balances in each million dollar increment.
I used $1M and $40k withdrawal, Firecalc says I have 6 failures. But the spread sheet says I have 5 failures in actual dollars and 6 failures if I look at the after inflation dollars. So, I'm confused;
Does the graph show ending balances in real dollars or after inflation dollars?
I'm not good with Excel, But I'll attempt to slog through to find the formulas to give me a breakout of how many times the ending balance is between $0 to $500k, $500k to $1M, $1M to $2M, $2M to $3M etc. But, if some one is good with math and Excel and would give me the formula to sort a column into the categories I listed above I would appreciate it.
I used $1M and $40k withdrawal, Firecalc says I have 6 failures. But the spread sheet says I have 5 failures in actual dollars and 6 failures if I look at the after inflation dollars. So, I'm confused;
Does the graph show ending balances in real dollars or after inflation dollars?
I'm not good with Excel, But I'll attempt to slog through to find the formulas to give me a breakout of how many times the ending balance is between $0 to $500k, $500k to $1M, $1M to $2M, $2M to $3M etc. But, if some one is good with math and Excel and would give me the formula to sort a column into the categories I listed above I would appreciate it.