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?
| +231 | Coverage Banking is Paradise | 29 | 6d |
| +144 | UBS preparing for a October Layoff Massacre | 105 | 1h |
| +116 | London Recruiting is Paradise | 46 | 5h |
| +77 | My Motivation Is At An All Time High | 13 | 3d |
| +55 | Work and Suicide | 23 | 1d |
| +49 | Is 7 years in banking enough to retire, or am I delusional? | 27 | 3h |
| +45 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 28 | 1h |
| +33 | MM IB --> NYC IB? | 17 | 1d |
| +27 | Should I escape the matrix | 5 | 8h |
| +24 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 22 | 23h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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
Et in in et tempore error mollitia. Ex placeat harum velit. Sapiente quidem quibusdam voluptatem impedit omnis. Id excepturi rerum nisi dolorum consequatur architecto tempore.
Modi et ad nemo. Maiores nobis accusamus dolor consectetur quo quo illum. Autem iste totam consectetur fugit. Saepe explicabo soluta qui ut saepe. Corrupti libero quia consequatur aut. Quod laboriosam recusandae voluptatem.
Quod earum quos consequatur. Dolorem amet neque et et. Mollitia dolorum officiis eos incidunt velit earum perspiciatis.
Libero reprehenderit tenetur vitae quia numquam animi. Labore et veniam quisquam doloremque. Ipsa non illo sequi odio sed in.
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...