Data Table (What If Analysis) Calculating Incorrectly

[prescient]

I've been banging my head against the wall over this issue. For some reason when the data table calculates it calculates incorrect values (if you notice correct values are in the bottom right cell of the data table. I've audited the table to make sure I'm don't have static values by accident and have not found any. Additionally, I've checked within calculation options to make sure that it is set to calculate tables automatically and it is. At this point I have no clue why the table is behaving as it is. Any insight would be helpful.

Data Table Audit.png
Data Table Problem.png
Valuations.xlsm

[Søren Larsen]

Sorry, where can I see the correct results that you expect?

---------- Post added at 06:53 PM ---------- Previous post was at 06:52 PM ----------

I suspect you may have a problem with circular referencing.

[prescient]

Sorry for not making this clear. Enterprise value in K31 should match the mid point on the data table (L38).

The only circularity should be between the Cash Flow, Balance Sheet, and Income Statement as well as the Implied Share Price but that shouldn't be hitting that data table.

[Søren Larsen]

Yes, you have a problem with circular referencing.

The data-table function works by substituting one-by-one your row- and column values into the destinations that you decide. But when you, e.g., say that L35 should be equal to K25, into which you are inserting the value of L35, then you have a circular reference. In the attached, I made a quick fix; have a look:

[prescient]

I see what you are saying about the circular reference now. Many thanks you are my hero!

[Søren Larsen]

You're too kind!

[Karan100]

I am facing the same issue. May I know what fix did u apply ?

[Karan100]

I am facing the same issue. May I know what fix you applied to resolve it?

[protonLeah]

Karan100,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.