Oct 12 2017 09:22 AM
I have a cash flow workbook which includes two worksheets. The "Summay" Worksheet shows cash in (wages, investment income, etc.) and cash out (expenses and income tax). The income tax figure in the "Summary" worksheet references a cell in the second worksheet "Income Tax". The "Income Tax" worksheet calculates the current year income tax using the cash in and cash out calculations in the "Summary" worksheet. Therefore, a circular reference is created. Does anyone have a suggestion on how to calculate the after tax net cash flow without creating a circular reference?