Gross Distribution Calculation

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?