Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two-variable Data Table - Problem with result/output
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 decreases accordingly based on # of shares repurchased (as it costs us more $ to buy more shares, therefore, EPS should decrease); however, the column output (EPS based on buy-back price) is staying the same at all levels of the # shares purchased, when it should increase as the # shares repurchased increases (because there will be less shares outstanding to split up profit between). I cannot figure out why this is not working...help. Tried to paste the matrix below for your reference, but the system was not letting me (rec'd a message stating 'inappropriate text found in text' !). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two-variable Data Table - Problem with result/output
Is it possible to post the formulas that you are using to do this?
"Chanpheng Botham" wrote: 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 decreases accordingly based on # of shares repurchased (as it costs us more $ to buy more shares, therefore, EPS should decrease); however, the column output (EPS based on buy-back price) is staying the same at all levels of the # shares purchased, when it should increase as the # shares repurchased increases (because there will be less shares outstanding to split up profit between). I cannot figure out why this is not working...help. Tried to paste the matrix below for your reference, but the system was not letting me (rec'd a message stating 'inappropriate text found in text' !). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
output negative result will show zero value | Excel Discussion (Misc queries) | |||
Combo Box to populate variable output range | Excel Discussion (Misc queries) | |||
Inputting variable length data - outputting fixed character result | Excel Discussion (Misc queries) | |||
one variable data table | Excel Worksheet Functions | |||
how do I output result of formula to another cell? | Excel Discussion (Misc queries) |