Is there an easy way to override the investment returns for individual years in the yearly table? I like that you can specify returns for ranges of years in the confg section in A10-C14, but it would be very useful to be able to override individual years in the generated table to simulate market downturns peiordically that are bound to happen. Or even better would be to have the config section take lower and upper bound values and then randomly select a value within the range for each year. Having both these featuers would be ideal.
That’s interesting, @shethk2006. We haven’t implemented this functionality.
If you unhide the hidden portion of the spreadsheet at right, you might find that it is not too hard to override some of the rate-of-return inputs.