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

Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Two-variable Data Table - Problem with output/result - Chanpheng B  07-May-08 05:19 5:19:04 PM
      Excel Data tables - Scott Fountain  15-Jul-08 04:32 4:32:35 PM
          Data Tables - Chanpheng B  18-Jul-08 03:54 3:54:46 PM
View Posts