Why are the advanced worksheets missing?

The advanced worksheets are now hidden by default to make the spreadsheet less intimidating for new users. To show and hide the advanced worksheets use the Show and Hide buttons on the Start Here Worksheet.

Why does the spreadsheet pay taxes in the subsequent year?

The spreadsheet pays taxes in the subsequent year to avoid a circular reference in Microsoft Excel. For example 2023 income taxes are recorded as paid in 2024. The circular reference happens when you are retired and using RRSP/RRIF withdrawals to fund your expenses. Your RRSP/RRIF withdrawal results in taxes owing which requires you to withdraw more from your RRSP/RRIF to pay the taxes which results in more taxes owing - and so on and so on.

The way the spreadsheet deals with this is to pay taxes in the subsequent year but record a tax liability in the current year so the net worth and net estate calculations are correct.