Use of TABLE worksheet function to do What-if Analysis

Microsoft Excel has some tools for performing what-if analysis, most useful in financial planning. (Of course, since TABLE is a worksheet function, it can't be used as a UDF name).