Simple Model Review Checklist
Was wondering if anyone had any tips or a basic checklist of what they look for when reviewing or error-checking an acquisition/development model. We get plenty of models sent to us from GP’s but no two are the same and it can be super tedious to run through each model in depth to make sure everything’s working right.
Are there any basic calc’s you run to make sure returns, cash flow, debt service are working correctly?
Do you have the same process every time, if so, what does it consist of?
Just looking for someone to help a guy with a mild case of self-diagnosed ADHD stay on task when running through someone else’s model.
Hey Associate 2 in RE - Comm, I'm here because nobody responded to this thread after a few days...maybe one of these resources will help you:
More suggestions...
If those topics were completely useless, don't blame me, blame my programmers...
I would generally just sum up the basics in my head and see how far out the results in the models are, then dig deeper into anything I've flagged. Also could input any of the high levels into a model you already know is solid, might not be tailored towards that investment but most calcs remain the same.
On the technical side you could run an IRR on debt/equity interest and capital repayments to make sure they stack up to whatever margins/coupons that are input.
Like you said, at the end of the day they are all different, the detail/layout of the modelling on first glance should give you as much perspective into if the person who put it together knows what they are doing or not.
Start with a high level logic check - do the numbers make sense based on the inputs, is everything growing logically year to year, do the numbers tie from page to page, etc. and flag any issues to dig into deeper. After you're comfortable the numbers are at least in the ballpark of where they should be based on the assumptions used, do you not typically underwrite anything compelling in your own model afterwards anyways? Seems crazy to rely on someone else's model.
Deleniti incidunt exercitationem est ipsam eligendi. Omnis est reprehenderit aut aut. Rerum repellat quia enim. Voluptatem enim ut hic nostrum molestiae iste. Earum voluptas eos itaque dolores laboriosam et maxime. Quia et assumenda porro saepe dolorem dignissimos. Id et quam tempora officia animi maiores sed.
Quo laboriosam omnis dolor. Labore velit iure culpa soluta. In velit quas possimus perferendis. Deleniti et asperiores unde ipsum veniam voluptatem enim velit. Blanditiis nihil ipsam veniam eaque facilis. Aspernatur qui quia itaque suscipit non corrupti qui. Consectetur ea et error ut.
Consequatur officiis est qui. Voluptatem sequi eos qui dicta. Quo odit distinctio soluta consequatur dolores enim. Qui laudantium modi ea debitis dolor temporibus sapiente et.
In rerum inventore nam ut. Dolores nulla nihil deleniti qui perspiciatis. Rem facilis corporis nemo dolorem. Odit provident pariatur sint delectus debitis. Nemo itaque quaerat quis mollitia commodi officia.
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...