Gross Distribution Calculation

I am trying to calculate the pre-tax distribution from a retirement account needed to cover a net cash-flow deficit. I have a full tax calculation (federal and state) built into a worksheet that the gross # needs to run through to arrive at the net #. What would be the best way to solve for the pre-tax distribution if I know the net deficit #? This is a duplicate post to one submitted on the calculations forum.

Can you provide an example?

Hi Louis - I see you are in Calgary so I'll speak in Canadian tax terms:

I am running a retirement cash flow projection. There is a net deficit in cash flow for multiple years starting in year 10. I need to withdraw a fixed net amount to cover the deficit. I need to gross up the value to factor in an income tax calculation. So - based on a series of variables run on a specific cell, how to I solve for the value needed to get the net #?

Hi Jen, yes i'm in Calgary; nice to meet you eh! Sadly, i'm not familiar enough with tax terms either Canadian or American. what i really need is a visual example of your data or sample data and what your desired result would be. Can you provide that?