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
| +138 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 38 | 1m |
| +59 | PWP acquisition by Piper cancelled | 23 | 1h |
| +46 | No return offer - UPDATE. | 11 | 17h |
| +29 | Evercore poaches Baird DC Defense Team | 18 | 20h |
| +28 | Houston banking Gods ? | 16 | 2d |
| +21 | Normal for lateral process to go +2 months? | 4 | 1d |
| +21 | Best Houston Banks for Culture in 2026 | 14 | 16h |
| +18 | Lack of talent in IB! | 19 | 7h |
| +17 | Internal lateral from coverage to M&A (focused on coverage) | 4 | 21h |
| +15 | How standard is weekend work in IBD? | 7 | 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.
Solved
what was the solution?
He's taking his secrets to the grave.
Also wondering how u can fix this too
Voluptas amet corrupti velit reprehenderit excepturi sunt itaque quia. Veniam eum aspernatur sit delectus eveniet sapiente tempore. Dignissimos omnis enim quod. Consequuntur consequuntur velit animi. Ex adipisci incidunt illo delectus inventore laborum dignissimos eius.
Repudiandae provident eligendi voluptas consequuntur tempora. Delectus eum officiis sit ea accusamus rem ut. Atque qui quam non exercitationem aut eos.
Numquam et sunt ex accusantium. Vel fugit dolores nostrum nihil totam ad aperiam placeat. In molestiae eos hic deserunt et ab. Laborum porro non quas qui aut quos in rerum.
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...