Only the gain inside a withdrawal is taxed. The part that is your own contributions coming back is never taxed again, so every withdrawal is split pro-rata between the two — the same way a brokerage reports it. The income you enter is what you actually receive, so the withdrawal is grossed up to cover the tax.
The water level is the balance from the table below, on one fixed scale that never changes as the years run — so the level moves only when the balance does. Every withdrawal takes out more than you receive, because the tax on the gain leaves the bucket with it.
Type an amount in any Contribution cell and it fills every year below it, up to the last contribution year. Outlined cells are the ones you set.
| Year | Contribution | Income taken | Tax paid | Withdrawn | Interest this year | Balance |
|---|
Contributions and withdrawals happen at the beginning of the year; interest is credited at the end, so the balance shown is the end-of-year value. In the final year the account may not hold a full withdrawal, so the income for that year is whatever is left. Negative rates are allowed to model losses.