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
| +214 | Coverage Banking is Paradise | 24 | 16h |
| +75 | My Motivation Is At An All Time High | 13 | 1d |
| +62 | Lost all ambition / don’t care at all anymore | 28 | 9h |
| +62 | London Recruiting is Paradise | 29 | 2h |
| +41 | Are Canadians still get jobs in the US? | 21 | 1d |
| +29 | MM IB --> NYC IB? | 14 | 17h |
| +29 | Is 7 years in banking enough to retire, or am I delusional? | 23 | 27m |
| +23 | Lawyer moving into Banking | 18 | 22h |
| +23 | Negotiating VP Sign-On Bonus (NOT Tied to Deferred Comp)? | 18 | 17m |
| +21 | "Don't include firm in Cover Letter's file name" | 9 | 6d |
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
Magni et dolorum qui ullam culpa. Dolore tempora quas beatae aut. Doloremque nostrum vero nihil exercitationem labore perferendis. Aut dolores consequuntur cupiditate maiores consectetur.
Iure cumque doloribus quam ad eaque animi dolorem voluptas. Qui magnam rerum optio assumenda dolorem similique. Doloribus maxime voluptates quam quia quidem quia in. Cum optio facilis modi illum.
Cum magnam sit officiis similique molestias est. Distinctio aut ducimus reprehenderit vel. Consectetur sequi impedit aliquid architecto omnis quo quo. Beatae sed repudiandae rerum quo reiciendis commodi ut.
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...