Two-variable Data Table - Problem with output/result |
| Chanpheng B posted at 07-May-08 05:19 |
Hi all. I'm having a problem with a two-variable data table. I have verified that I correctly have a formula driving the data table, and my 'base' inputs for the two variables are hard-coded in the table. I have multiple data tables in my workbook and all but this one seem to be working correctly; the table I'm having the problem with is essentially an Earnings Per Share table (specifically, what happens to EPS if the company repurchases X number of shares at X buy-back price--the # of shares repurchased and the share buy-back price are the variables).
The Row output seems to be correct (EPS based on # of shares repurchased; however, the column output (EPS based on buy-back price) is staying the same at all levels of the # shares purchased.
I cannot figure out what this is not working...help. The output looks like the following.
STOCK REDEMPTION PRICE
$18.00 $19.00 $20.00 $21.00 $22.00
8m $1.8694 $1.8678 $1.8662 $1.8646 $1.8630
9m $1.8694 $1.8678 $1.8662 $1.8646 $1.8630
10m $1.8694 $1.8678 $1.8662 $1.8646 $1.8630
11m $1.8694 $1.8678 $1.8662 $1.8646 $1.8630
12m $1.8694 $1.8678 $1.8662 $1.8646 $1.8630 |
| Biography |
| Financial Analyst - Denver, CO |
|