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?
| +200 | 2nd casualty of BofA, 25 yo credit trader | 64 | 6h | |
| +179 | Associates not checking my work and getting mad at me? | 35 | 2d | |
| Am I insane? (NEED ADVICE) | 63 | 3m | ||
| +96 | How Much Parental Assistance Do People Actually Have? | 34 | 57m | |
| +87 | Is it appropriate to take time off after a breakup? | 24 | 15m | |
| +86 | the new "email template" | 29 | 47m | |
| +66 | Analysts bitching on WSO | 16 | 1h | |
| +60 | Fitness vs Traditional Watches (in Office) | 40 | 4h | |
| +60 | Why are UK, UK based and UK-countries related (India, Nigeria...) students so cringe on LinkedIn? | 22 | 2h | |
| +51 | How is Northwestern? | 15 | 22h |
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
Est deleniti nostrum deleniti tempora eius. Fugiat ea repellat harum est.
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...