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?
| +220 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 51 | 20h |
| +114 | ONLY THESE BANKS OR YOU STRUCK OUT | 33 | 5h |
| +110 | IB Energy Drink Tier List / Ranking | 72 | 1d |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +55 | Firm Thinks I'm Lying About Offer | 18 | 17h |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 1d |
| +33 | Stay at Weak Dealflow Team or Lateral? | 10 | 2h |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 1d |
| +30 | Indiana University Fraternity Pipelines | 15 | 1h |
| +28 | Rogo AI | 8 | 40m |
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
Inventore distinctio voluptatum similique aliquam quia. Optio deserunt aliquid numquam doloremque consequatur in omnis. Ut animi reiciendis dolorum aut culpa. Odit minima minima aut totam. Odit reprehenderit eos impedit ipsum enim.
Voluptatem pariatur quia sed id. Suscipit iste autem optio ipsa illum facere id libero. Ea id ducimus nihil quo voluptatem rerum aut esse. Quis qui quia ipsam. Explicabo architecto cum sequi est quam dignissimos. Sit quidem et veritatis qui expedita et temporibus.
Sed aliquam illo eum aliquid voluptate ea corrupti voluptatem. Illum dicta ipsa quo labore. Sunt voluptatem cupiditate esse at commodi. Explicabo unde libero eos unde sapiente. Voluptatem aut consectetur porro repudiandae perferendis voluptas quia aut. Eaque sunt corrupti qui voluptatibus.
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...