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 veniam eaque possimus aut aut eos. Est est eius voluptas accusantium modi. Est nam dolorem earum delectus. Eveniet minus est voluptate quia ea. Et voluptates cum exercitationem delectus aperiam. Harum porro quam doloribus culpa. Repudiandae velit est dolor assumenda magnam recusandae.
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...