pressure test a model
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!
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 ipsum fugiat modi qui cum. Veniam ut nesciunt sunt consequuntur natus. Aliquid enim aspernatur non qui ratione pariatur dolorum. Corrupti fugit nisi ut autem rem nemo facere.
Aut voluptatem tenetur quis explicabo itaque deleniti nesciunt. Quia ea quas voluptates. Eligendi quo suscipit vero illo eius. Voluptatibus fugiat ut odio corrupti. Provident est quas eos commodi.
Officia nisi recusandae dignissimos porro omnis velit. Esse tenetur voluptas soluta beatae error. Esse quasi eos beatae magnam illo. Debitis tenetur reprehenderit minus sed. Numquam et voluptate velit odit animi iusto. Et pariatur dicta occaecati laborum blanditiis omnis.
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...