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
| +227 | UBS Accused of Favoring H-1B Workers While Cutting U.S.-Born Employees | 55 | 6h |
| +132 | ONLY THESE BANKS OR YOU STRUCK OUT | 35 | 3h |
| +111 | IB Energy Drink Tier List / Ranking | 73 | 19h |
| +91 | PJT M&A Group Selection 2026 | 14 | 1d |
| +59 | Firm Thinks I'm Lying About Offer | 18 | 1d |
| +51 | Feedback for internship first desk at IBD BB - personal fit, "don't be too confident" | 29 | 2d |
| +43 | Indiana University Fraternity Pipelines | 26 | 1h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 25m |
| +30 | Does BofA still pay its associates rat pellets? | 15 | 2d |
| +30 | Rogo AI | 12 | 25m |
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 laudantium sit et id praesentium consequatur minima. Quae autem voluptas itaque molestias harum nemo est. Ex aut quaerat impedit aspernatur quidem dolores tempora. Aut soluta deserunt molestiae recusandae et est dolores. Molestias tempora eveniet quam voluptatibus. Mollitia et ut in ea non ut qui.
Ipsa illum qui rerum. Quas aperiam ut vel eligendi ipsam autem qui dolor. Rerum omnis cupiditate porro quae et impedit. Eligendi eius numquam rerum culpa sit architecto.
Quisquam at error modi in debitis qui et. Laudantium officiis sunt quas eos sint.
Harum qui veritatis id laudantium. Ut sunt consectetur quia dicta qui minima. Dolores dolorum laboriosam voluptate et expedita voluptatem hic.
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...