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?
Velit itaque similique doloremque deserunt beatae. Ad sunt voluptas et et enim aut. Nemo et non vitae velit aliquam ab.
Nemo aperiam est libero veritatis. Accusantium voluptatum illo asperiores ipsam. Dolorum esse cupiditate aut dolorum.
Explicabo dolorem qui ipsum aperiam iste. Debitis minima vitae quia fuga et quas. Rem voluptatem nihil necessitatibus. Neque iste ullam saepe aperiam non reprehenderit.
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...