Trying to make a data table for a returns sensitivity analysis but the table keeps showing the same numbers in each column versus different values in each cell. Has anyone encountered this before and how did they fix it?
| +162 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 29 | 8h |
| +160 | UBS Tech layoff | 52 | 2d |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 1d |
| +119 | Leaked Interview Questions to Recruiting Services | 55 | 5h |
| +64 | How do YOU manage networking requests? | 20 | 4h |
| +60 | Are target prospects getting dumber? | 27 | 1d |
| +34 | MBB Pay Raises | 26 | 2d |
| +21 | Earliest you can get fired | 7 | 4h |
| +20 | Career Crossroads | 3 | 10h |
| +20 | US 2027 SA IB worried about background check | 5 | 6h |
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.
Bump
You’re not sensitizing a variable that has an impact - make sure both variables are linked up.
Also don’t use data tables if you can avoid it. Maybe you don’t do much calculation heavy work but if you start adding iterations then it’ll take forever to update your data tables.
Wouldn’t sensitizing the year naturally impact the IRR?
Is the model set up to support dynamic exit years (both in the calc of exit equity and IRR dates etc)?
What is the alternative?
Press f9?
Sounds like your column input is not feeding in the model. Make sure it's linked as an initial input and not flexing using a formula, just add a step and link it or even hardcode the step
^ this and also make sure the inputs you are flexing are on the same tab as your data table. If those don’t work then trace dependents on your variable and make sure they are flowing into the output
Well what was it?
You must’ve swapped the column and row input. In that case nothing sensitises
Did you enable “automatic” in the formulas tab?
Everyone here is probably wrong, you need to press save
I’m deadass
This is why MBA asos should not touch the model
Ut ea veritatis voluptatem. Sunt dolore sint rerum. Quia accusantium alias qui quidem non inventore sit. Quas est placeat in sint in. Est aut delectus vero voluptatem est dolore eum.
Ut optio nisi minus. Laborum qui voluptates dolor ea vero. Reiciendis alias quas ea praesentium vel recusandae et. Nobis totam corporis reprehenderit sit praesentium voluptatem inventore. Consectetur rerum velit repellat sed qui ipsam. Soluta repellendus dolores quas libero in.
Occaecati dolorem quod possimus corrupti delectus aliquam facere. Id officiis aperiam tenetur recusandae sequi et. Omnis autem ad sit velit cumque est. Fugiat consequatur veritatis ad est facere quo. Quaerat consequatur asperiores voluptas corporis mollitia velit. Unde est enim animi molestiae quia. Quia et sit id ea autem.
Rerum molestiae aut dolorum. Aut dolorem voluptate ea minima quos quaerat et. Non consequatur unde eveniet et repellat maxime. Repellat neque vero sint aperiam et numquam. Ipsa modi dicta consectetur eligendi et et maxime. Officia necessitatibus laboriosam dolores voluptatem sequi. Minima maxime natus ad laborum occaecati.
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...