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
| +435 | Is UBS really that bad? | 79 | 20m |
| +265 | Investment Banking is Divine | 40 | 2d |
| +225 | Another $115bn Mega deal for these banks. Congrats! | 46 | 22h |
| +216 | US 2027 SA IB worried about background check | 53 | 2d |
| +133 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 31 | 44m |
| +85 | Useless associates | 16 | 10m |
| +64 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 17 | 2h |
| +52 | Differences in Restructuring Teams? | 24 | 19h |
| +51 | FIG Pigeonholes you - is it true? | 22 | 2m |
| +42 | GF is an IB Analyst at a top BB, hates it, what exit options does she have? | 20 | 1d |
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
Non incidunt dolor sit exercitationem. Assumenda quod accusamus beatae dolore doloremque. Voluptatem esse iure qui.
Similique fugit voluptates occaecati velit qui maxime voluptatem. Qui quam veritatis suscipit dolorem vero. Voluptas enim iusto dolores recusandae. Ut sed harum delectus voluptatem. Et ratione quod non dolor voluptatibus neque at facilis.
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...