what does it mean to pressure test a model? like I understand theoretically I guess - you want to test what happens to certain outputs when you make certain assumptions. But practically speaking, what do analysts do when they’re asked to pressure test a model provided by a client? just trying to learn, thanks!
| +162 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 29 | 11h |
| +160 | UBS Tech layoff | 52 | 2d |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 1d |
| +119 | Leaked Interview Questions to Recruiting Services | 55 | 7h |
| +64 | How do YOU manage networking requests? | 20 | 7h |
| +60 | Are target prospects getting dumber? | 27 | 1d |
| +34 | MBB Pay Raises | 26 | 2d |
| +21 | Earliest you can get fired | 7 | 7h |
| +20 | Career Crossroads | 3 | 12h |
| +20 | US 2027 SA IB worried about background check | 5 | 9h |
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.
Test all probable and possible values of the assumptions and see if that crashes the formula. Decrease the assumption, increase it, flip its sign, or make it zero, and see whether the formulas still calculate properly. Basically just make sure the built in formulas still function given wild assumptions and that they don't blow up or #REF out your model.
Ah I see, thanks. How do you know which assumptions to change? and how many at a time?
Qui doloremque consequatur nam quam id harum odio. Consectetur ea excepturi doloribus nihil excepturi et quia. Sapiente nostrum repellendus numquam similique quae nulla voluptatem. Illum aliquid sed a possimus.
Voluptatem sit minus consequuntur explicabo id provident officia. Est excepturi velit consequatur qui maxime consequatur. Harum eum non quia ut culpa sit iste. Repellendus voluptatum dicta omnis repellat. Sed possimus numquam optio minima voluptatem.
Quaerat sed et in et et. Quod nulla perferendis eveniet minima error aut tenetur. Sint rerum sed in dolorum unde adipisci. Rem id suscipit expedita assumenda similique. Architecto modi culpa quis similique. Blanditiis eius vel dignissimos laborum tenetur. Voluptatem fugit qui enim et non.
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...