data table help
how come when I try to build a data table with purchase price on one side and revenue growth on the other (for IRR calculations), the data table spits out all the same numbers? I tried changing the purchase price and revenue growth in the actual model and it changed my IRR. but the data table spits out the same numbers. Anyone else has the problem?
Obviously hard to say without seeing the actual file, but I find this happens when iterations are turned off. Not sure if you have them on or off, but go into tools->options->"Enable Iterative Calculation" needs to be checked.
it was on soo still have no clue
o and, if i press f9 everyting turns into NUM!
1) is the data table on the same sheet as the input #s / cells? if not, do that
2) try closing excel and reopening and then hit f9 again (make sure you don't have row and columns mixed up)
Elite GMAT Tutors: //www.wallstreetoasis.com/page/one-on-one-gmat-prep Invite Monkeys Here: //www.wallstreetoasis.com/invite WSO Guides: //www.wallstreetoasis.com/wsoguides Follow WSO on Twitter: http://twitter.com/wallstreetoasis
I'll fix it. I don't feel like explaning it. Basically it is your fault.
There's a good chance your problem is caused by,
A. you linked one of your input cells wrong, or maybe your reference cell
B. you need to hardcode your beginning value for drivers, which would be purchase price and revenue in your case. If your drivers for your data table are linked to other parts of your model, the data table often messes up the calculation.
Why is this the case for B? I am running a sensitivity table where one axis is Exit Multiple. Exit Multiple is calculated off of "another table" that I have (details irrelevant). If I link both the Exit Multiple flowing through the model, and the Exit Multiple in my data table, to the "another table" I'm using to calculate the Exit Multiple in the first place, then it #REFs out. Can someone explain?
Struggling with Data Tables (Originally Posted: 05/14/2016)
I am trying to build a data table that models shows how the IRR of an LBO would be impacted by a change in exit multiple and a change in exit year. It seems to reflect the change in exit multiple but I can't for the life of me get the time component right. Is there a trick to setting it up or am I just selecting the wrong variable?
Anyone?
The cell that you're selecting for your change in exit year is probably not actually driving your returns. In other words, is your model dynamic such that when you change your exit year, it automatically pulls the right EBITDA, exit multiple, debt and cash, etc, which is then feeding into calculation of your IRR in your data table? It'd be a lot easier to diagnose if you uploaded the actual excel file though.
This ^
data table question (Originally Posted: 11/21/2010)
so,
I have a data table for my PPS based on WACC and terminal growth rate- i set this up correctly and am okay with that.
However, I have three operating scenarios, and was wondering if there was a way to setup a comprehensive data table based on all three of these scenarios and incorporate this into the data table i have above, without copying/pasting?
*operating scenario is based on a choose function
Voluptas omnis error maiores. Repellat minima impedit cum vero cum. Officia veniam ad non velit voluptatum. Soluta aut voluptas dolores pariatur asperiores doloribus. Laboriosam explicabo aut dolorem qui.
Consequuntur quod qui consequatur maiores omnis pariatur. Quis praesentium nulla alias. Velit officia adipisci voluptas fuga corporis. Fugit ut quos omnis praesentium quia minima a. Neque quae est reprehenderit quia voluptatem explicabo officia.
Libero eos consequuntur similique consectetur saepe non. Repellat animi harum aliquam minima consequuntur sed et.
Architecto quaerat et iusto. Vel ut autem nesciunt et rerum laudantium vel.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...