A
agbiggs
I'm doing a Monte Carlo simulation of the balances of public pension
funds where I'm interested in the year in which the fund becomes
insolvent. So I have a column showing the pension fund balance by year
and I want to calculate (in a separate cell) the first year in which
the fund goes negative. Since I'm applying random investment returns
this will vary from iteration to iteration, so I need something that
can do this on the fly (otherwise I'd just look for myself).
Any ideas on how to do this? I'd think maybe using a lookup function,
but it's not clear to me exactly how I might do it since I don't need
all the years in which it's negative, just the first one. Any ideas
appreciated!
funds where I'm interested in the year in which the fund becomes
insolvent. So I have a column showing the pension fund balance by year
and I want to calculate (in a separate cell) the first year in which
the fund goes negative. Since I'm applying random investment returns
this will vary from iteration to iteration, so I need something that
can do this on the fly (otherwise I'd just look for myself).
Any ideas on how to do this? I'd think maybe using a lookup function,
but it's not clear to me exactly how I might do it since I don't need
all the years in which it's negative, just the first one. Any ideas
appreciated!