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
| +165 | How to stop feeling like shit for not making it in IB? | 61 | 22m | |
| +121 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 59 | 6h | |
| +85 | Updated LA Banking Scene (2024) | 61 | 3h | |
| +40 | Ranking banks that went under | 24 | 3h | |
| +38 | Burnt Out M&A ASO | 20 | 3h | |
| +36 | Relevance of A-Levels for U.K. London recruiting | 25 | 1h | |
| +33 | A strategy for SA applicants late to the game like myself | 17 | 2s | |
| +27 | Series 79 Help / Tips to Pass The First Attempt | 11 | 2d | |
| +27 | Intern Ettiquette | 4 | 1d | |
| +26 | How to overcome Sexual Attraction to PJT? | 8 | 2h |
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
Nostrum neque placeat minus. Quod nisi modi unde quibusdam.
Ut excepturi animi velit aliquid. Pariatur autem quidem dolor et voluptatibus. Delectus voluptates dolorem quae eum.
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...