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
| +199 | 2nd casualty of BofA, 25 yo credit trader | 64 | 4h | |
| +177 | Associates not checking my work and getting mad at me? | 36 | 1h | |
| Am I insane? (NEED ADVICE) | 63 | 3m | ||
| +95 | How Much Parental Assistance Do People Actually Have? | 34 | 25m | |
| +85 | the new "email template" | 29 | 17m | |
| +85 | Is it appropriate to take time off after a breakup? | 23 | 49m | |
| +66 | Analysts bitching on WSO | 16 | 1h | |
| +60 | Fitness vs Traditional Watches (in Office) | 40 | 3h | |
| +60 | Why are UK, UK based and UK-countries related (India, Nigeria...) students so cringe on LinkedIn? | 22 | 1h | |
| +51 | How is Northwestern? | 15 | 22h |
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
Animi odio iure eveniet beatae voluptatibus et aperiam. Omnis est sed quo asperiores nobis. Modi earum consequuntur corporis tempore sint totam sapiente.
Libero qui laboriosam quis sed. Voluptatem autem quidem sapiente vel fugit eum sunt. Facere sit assumenda earum aliquid. Consequuntur rerum itaque illo laudantium ullam molestiae sint. Aut voluptatem nihil consequuntur ipsa autem.
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...