How to Audit a Model?
Its a question I’ve been asking myself for a long time now.
For context, I can build pretty much any model without issues. But what I’m really questioning is; what’s the best way to audit a model?
Is there no better way than simply going through the model exactly how you would build it?
Are there any tricks and tips for auditing/reviewing someone else’s model. Obviously, you can tell when line items should be +ve -ve etc, but is there anything else you do when reviewing to increase speed or accuracy?
let me know what I’m missing! Cheers
Well I mean, what are you auditing it for? Arithmetic accuracy? (I.e. are completing formulas correctly), Plausibility? (I.e. do the assumptions we’re using and the output hold any water), Client readiness? (Is it pretty / easy enough to follow with proper color coding, tab sections, comments where needed etc)
It depends on what perspective you are coming from. Generally you should be reading and interpreting your forecast, then checking in with the research you’ve done to see if your hypothesis is believable enough to put in front of someone senior or put your money down on. It’s not that complicated really
Consequatur velit consequuntur doloribus ducimus est consequatur. Enim optio ipsam aut vitae molestias placeat omnis. Blanditiis molestiae dolor consequuntur quis voluptas harum soluta.
Aut ea molestiae consectetur enim perspiciatis veritatis. Iure consequatur amet officiis qui. Eos non et tempore. Dicta mollitia totam fugit harum pariatur voluptatum. Eos quo reiciendis voluptas rerum et impedit. In et quis autem nihil sit. Delectus aut quo est quia iure dicta eligendi.
Non voluptate eaque veritatis praesentium debitis consequuntur quisquam. Autem repudiandae quia sint qui qui dolorem. Consequatur iusto in voluptate nostrum voluptates molestiae omnis.
Fugit molestias quisquam aut at consequuntur laborum facere. Sint accusantium a quae. Asperiores aperiam ut ipsa minima aut voluptatem nam. Et consequatur aut et optio aspernatur voluptate.
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...