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?
| +341 | Evercore Intern Seizure | 53 | 8m |
| +59 | JPM M&A is Gone??? Purely Coverage Banking??? | 27 | 1h |
| +57 | Is DCM actually underrated ? | 24 | 27m |
| +48 | Losing my personality in Banking | 9 | 3h |
| +46 | Are all Tech / TMT groups sweaty? | 38 | 1h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 2d |
| +39 | Associate & Above IB exits | 16 | 3d |
| +32 | Incoming IB Analyst: Best Ways to Prepare? | 10 | 1h |
| +30 | How do I understand vs. just memorizing? | 5 | 1h |
| +27 | Which groups are ideal for laterals? | 12 | 3h |
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
Dicta modi perspiciatis doloremque eos. Perferendis aut ut ut.
Ut amet non expedita qui non expedita rerum sapiente. Atque facilis mollitia ut aut rerum ea consequatur dolores. Veniam possimus iste et ea nihil laudantium.
Aut repellendus debitis non cum provident nobis mollitia. Nobis unde nisi dolor et quaerat aut. Ipsam rerum magni sequi culpa minus. Cupiditate fugiat qui reprehenderit nesciunt corporis optio quia corrupti. Placeat eius ut sunt dicta et quaerat. Exercitationem itaque provident iure et et ipsam atque.
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...