Best pracitces when auditing models?
Hi everyone:
I was wondering if you have any best practices/priority checks when it comes to auditing models that others have built please? Was curious about the shocks you will introduce to the numbers to make sure it's well-proofed in all situation, espcially in a limited time frame. Thanks!
Hey balbasaur1, the following topics might be helpful:
Hope that helps.
Couple ones that come to mind (with varying levels of obviousness):
This is pretty good - I also make sure to autocolor each tab at the end / Ctrl ~ to make sure there are no accidental hardcodes that got put in. Also, when auditing models and going through and F2'ing everything, always check things diagonally, instead of checking things only in 1 row or column.
Aggressively tap F2 + ESC. Over and over again.
Ahaha you beat me to it
Type "OK" in italics in the row for your BS balance check.
Hit f2 10 times on every cell in a flickering manner to make it look like you are doing stuff
Lol jk. Best thing to do is to try to recalculate stuff back of the envelope or in a different fashion, and make sure you get to same result
This trick has been known to drop panties
There are a few key points necessary for auditing other people’s models:
1.) No matter what the model looks like/functions, it is not your model. Bitch about how horrible it is to all superiors so they understand you are superior to the other person. 2.) Put no diligence and effort into actually validating the model, again, this entire exercise is just meant to make the other person look inferior. 3.) Spend the time you would have spent trying to check the model to kiss your boss’s ass.
Or at least these are some of the things I learned from some of the directors where I work :).
Spell checking (the title of the thread).
Officiis ut fuga eos officia impedit facere. Consequatur aspernatur voluptate hic laboriosam perspiciatis soluta cumque.
Corporis blanditiis adipisci libero. Ut asperiores ut voluptas harum accusantium blanditiis. Ipsa in voluptatum odit commodi qui provident.
Excepturi aspernatur sint magnam quaerat vero rem. Sit voluptates consectetur qui temporibus consectetur eius.
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...