[ Dec. 2001 ] [ Nov. 2001 ] [ Oct. 2001 ] [ Sept. 2001 ] [ August 2001 ] [ July 2001 ] [ June 2001 ] [ May 2001 ] [ April 2001 ] [ Mar. 2001 ] [ Feb. 2001 ] [ Jan 2001 ]
[ What is a Data Table? ]
(Note: Normally we meet on 1st Wednesday of the month.
We delayed this month on account of the 4th of July holiday)
|
6:30-7:15 pm
|
General
Questions and Problems from the Audience
Puzzler: How do you create a Hyperlink to an Excel
Chart? (I don't have a solution for this yet!! |
| 7:15-8:00 pm |
Main Topic for the
night: Data Tables.
What are Data Tables?
1D Data Tables: Do a "What If" analysis by
changing one input value and seeing the change in several output
variables.
|
|
8:00-8:10 pm
|
(Break) |
| 8:10-9:00 pm |
2D Data Tables:
Do a What If analysis by changing two input values (the row and column
headers of a table, and record one result value:
Crafty 1D Data Tables with many inputs and many outputs.
|
Example workbooks: (each are XL97 and
< 40KB)
Each workbook contains a macro to perform a Tax
Calculation. You must enable macro for these workbooks to run.
10SimpleTax.xls - a very
simple US Tax Model as a VBA User Function
15SimpleTax1D.xls - a 1D Data sensitivity
Table
20SimpleTax2D.xls - a 2D Data sensitivity
Table, showing Average Tax rate as a function of
Gross Income and Number of Exemptions
with Fixed Sched A Deductions.
The Question to be answered:
You have just been awarded a prize.
You can accept the money immediately or accept it in installments over time.
If you accept it in installments, you may pay less in taxes, but you will not be
able to invest it.
The sooner you receive the money, the sooner you can invest it, but it may put
you into a higher tax bracket.
What portion of the prize should you receive per year to maximize the value
of the prize?
30PrizeSensitivity_BaseModel.xls
35PrizeSensitivity1D.xls
40PrizeSensitivity2D.xls
50PrizeSensitivity1DCrafty.xls
