#1   Report Post  
Posted to microsoft.public.excel.misc
hmz hmz is offline
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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   Report Post  
Posted to microsoft.public.excel.misc
hmz hmz is offline
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.misc
hmz hmz is offline
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 762
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup data in a variable table & retrieve data from a pivot table Shawna Excel Worksheet Functions 3 October 10th 08 11:11 PM
Convert Pivot table back to Data Table Samaa Excel Discussion (Misc queries) 2 March 21st 07 11:02 AM
convert Pivot table back to Data table Samaa Excel Discussion (Misc queries) 2 March 21st 07 10:22 AM
Convert Pivot Table to Normal Data table ashish128 Excel Discussion (Misc queries) 2 May 2nd 06 09:34 AM
Excel Pivot Table Plugin? (crosstab to data table) HoMoon115 Excel Discussion (Misc queries) 0 February 22nd 06 09:20 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"