Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Table
Hi,
I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, -- hmz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Table
hmz -
For an example of a two-input data table, see my chapter "Sensitivity Analysis Using Excel" file: http://www.treeplan.com/chapters/02_...71029_1042.pdf specifically, section 2.4. - Mike http://www.MikeMiddleton.com "hmz" wrote in message ... Hi, I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, -- hmz |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Table
Thank you. This information is helpful. I realize that data tables are only
for input sensitivities. What I need is to use an output to find my input. In my case, I am trying to find out what (input) rent should be to produce an IRR (outcome), but I need to use the IRR to find the rent. If I want a 25% IRR, what rent should I have to get there. Since, IRR is an output (calculated cell), the table will not work for me. Is there another area in Excel that I can look? Goal Seek will work, but I was hoping to have something more in a table format for my client. Again, thank you for the helpful information. €“ hmz nyc "hmz" wrote: Hi, I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, -- hmz |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Table
Thank you. This information is helpful. I realize that data tables are only
for input sensitivities. What I need is to use an output to find my input. In my case, I am trying to find out what (input) rent should be to produce an IRR (outcome), but I need to use the IRR to find the rent. If I want a 25% IRR, what rent should I have to get there. Since, IRR is an output (calculated cell), the table will not work for me. Is there another area in Excel that I can look? Goal Seek will work, but I was hoping to have something more in a table format for my client. Again, thank you for the helpful information. €“ -- hmz nyc "hmz" wrote: Hi, I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, -- hmz |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Table
hmz -
Goal Seek will work, but I was hoping to have something more in a table format for my client. < So, perform multiple "manual" goal seeks, and display the results in a "table." - Mike "hmz" wrote in message ... Thank you. This information is helpful. I realize that data tables are only for input sensitivities. What I need is to use an output to find my input. In my case, I am trying to find out what (input) rent should be to produce an IRR (outcome), but I need to use the IRR to find the rent. If I want a 25% IRR, what rent should I have to get there. Since, IRR is an output (calculated cell), the table will not work for me. Is there another area in Excel that I can look? Goal Seek will work, but I was hoping to have something more in a table format for my client. Again, thank you for the helpful information. €“ hmz nyc "hmz" wrote: Hi, I am trying to create at data table with two inputs and one outcome. The inputs are calculated: (1) An IRR and (2) a Debt Coverage Ratio. The output is rent, which is not a formula. I want to be able to input any IRR value and/or DCR, but the Data Table will not output my rental change that would correspond to the changes in the IRR/DCR. Is Excel capable of doing this, and if so, can someone send me a simple demonstration/calculation to help me? I have been working on this for a bit and am frustrated. I am afraid that I am not able to have a clear head since i have been working on this for a couple of hours trying different scenarios. Thank you so much, -- hmz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) |