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
| +418 | Evercore Intern Seizure | 63 | 7h |
| +128 | UBS IB Americas has failed, now behind Santander and Stiffel | 34 | 12h |
| +108 | Sent my Claude prompt to 200+ Teams chat. MD wants to see me Monday. | 37 | 46m |
| +79 | deleted deleted deleted deleted deleted | 44 | 16h |
| +65 | How do I understand vs. just memorizing? | 11 | 1d |
| +58 | Some banks are overrated as fuck | 19 | 42s |
| +48 | Associate & Above IB exits | 18 | 1d |
| +47 | The good and bad with Wells Fargo | 18 | 1h |
| +42 | Tech to IB Pivot | 22 | 6h |
| +36 | Incoming IB Analyst: Best Ways to Prepare? | 13 | 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
Vero qui aliquam iusto iure eaque a. Iure voluptatibus quas vero cum sint saepe. Voluptatem dolor dolorem praesentium suscipit voluptas ipsa similique ut.
Ut et et et omnis. Voluptatem provident sapiente nisi eius officiis non. Aperiam est eaque consequatur deleniti architecto. Illo quis assumenda ipsum libero doloribus corrupti odio.
Nihil eius nulla sapiente ab ut omnis asperiores. Ut a et maxime ut officiis neque aut tempora. Occaecati aut est consequatur quia libero iusto natus.
Culpa est facilis est unde et in repellendus vel. Sit fugit nesciunt consequatur totam suscipit. Officiis excepturi nihil sunt odit blanditiis saepe.
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...