For the last several years, I have been hardcoding column and row inputs when creating sensitivity tables for IRR calculations. However, I have been asked numerous times to move some key inputs around and I would sometimes forget to adjust scaling for the sensitivity table. When you link the sensitivity inputs to a cell, the calculations are incorrect. It seems like data tables can only operate using hard-coded inputs. Does anyone know a workaround on this?
-XSX
| +195 | Evercore > Goldman and I don’t think it’s particularly close anymore | 69 | 11m |
| +158 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 18 | 2h |
| +109 | Think Twice before Recruiting for HOUSTON IB!! | 59 | 1m |
| +86 | UBS Offer Day | 34 | 1h |
| +73 | I hate Wells Fargo | 20 | 3h |
| +53 | No return offer - feeling like a failure is an understatement | 24 | 4h |
| +49 | How cooked am I as an incoming WF IB SA 2027? | 17 | 1d |
| +47 | WF Return offers | 30 | 6m |
| +40 | 2026 Investment Banking Return Offer Climate | 25 | 2d |
| +39 | Should I go back into a junior IBD role for comp? | 16 | 3d |
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.
Solved
what was the solution?
He's taking his secrets to the grave.
Also wondering how u can fix this too
Id illo ducimus et sed ut minima. Nulla debitis soluta exercitationem tempora numquam eum. Et commodi dicta at laudantium.
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...