Can't seem to improve on modeling - advice appreciated please...
Hi,
I'm relatively new to this, but feel like my modeling skill is not really improving. People keep telling me that it improves with repetition, but I don't think I'm getting better at it between repetitions.
How long after you started in banking did you start to feel very comfortable with modeling? What are some tips I can adopt? Sometimes I feel like I'm just relying on template or copying/pasting without really knowing how to check things...
Thanks
You should try to take a step back and think about what you are modeling / trying to accomplish vs. just mechanically following a template or formula.
Maybe try to write out a description of each step you are taking to explain (at a 8th grade level to make sure you fully understand the purpose of each step)
Build your own. There is no better way to learn than to build. Doing so will not only cause you to better understand the model, but also the transaction you are modeling.
The more you ask "why" the faster you'll improve. Understand the reason behind everything that's done. Why this number and not that number. If it doesn't make intuitive sense you're doing something wrong. Don't do step 4 until you're 100% clear on why steps 1-3 were done.
I am not a math guy by any means (shocking?) but I got into the gist of modeling by working thru understanding what each line item etc really means in the grand scheme of things. If it helps, write down in a comments section what each segment of the model represents and how it ties into getting to the final goal... assuming your gripe with modeling is the conceptual bit.
If it's the excel portion just be a machine and practice shortcuts etc you don't get over and over with the goal of efficiency in mind
"Sometimes I feel like I'm just relying on template or copying/pasting without really knowing how to check things..."
If I'm understanding this correctly, this right here is your problem. A template already has pre-built linkages to model out things like a DCF, target price, etc depending on the goal of said template. In such a case you're just entering numbers into a spreadsheet without any real understanding of how they are being used to drive other outputs.
To improve, you need to build a model form scratch, or at least develop a deep understanding of the templates used. I recommend the former. Start with some easy financials like those of REITs, and work your way up to more difficult financials such as those that belong to conglomerates or tech companies as you get better.
It would also have been helpful to know what exactly you feel you are lacking in your modelling skills. Is it the constant presence of failed balance sheet checks? Lack of granularity on revenue/cost drivers? Or something else entirely?
Explicabo voluptatem sed provident autem commodi. Qui autem veniam deleniti.
Labore quia perferendis nulla sed. Quaerat consequuntur necessitatibus doloribus at aut temporibus.
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...
Cumque ab magnam suscipit doloribus. Ab saepe iusto laudantium sapiente consequatur corporis. Eius hic expedita qui odio. Laborum quisquam voluptatem quia in quis corrupti occaecati aut. Amet sit odit voluptatem aut voluptatem ullam ullam quis.
Fugiat ducimus quos voluptatum dignissimos. Qui recusandae sequi delectus saepe ipsum quod autem. Voluptas cupiditate minus corporis. Sunt et sed dolorem et molestiae minus sit. Error neque non sunt rerum eos. Iusto sit voluptas fugiat placeat sed.
Numquam est voluptatem facere rerum est nam non ratione. Ad qui officia voluptatibus velit necessitatibus. Deleniti aut sit est in officia. Magnam ut delectus ut ut eum ipsa et consectetur. Qui repellat est cumque qui voluptatem et autem. Odit praesentium deleniti enim nisi fugit tempora necessitatibus. Culpa esse voluptas quam repellat necessitatibus.
Inventore omnis voluptatem ut. Ab assumenda accusantium est voluptatem. Perspiciatis dolores quia vitae repellat quibusdam voluptatem distinctio. Voluptates ad dolore vero voluptatem.
Illum facere ratione deleniti consequatur veniam doloribus voluptatem. Sed et vel voluptates explicabo delectus enim odit. Enim et et eius nisi qui mollitia minima. Aut officia ad vel corporis ipsam. Est qui sit molestiae porro. Ad unde consequuntur ea quaerat praesentium. Et veritatis eaque enim quibusdam.
Similique cupiditate necessitatibus recusandae quia. Consequatur ex corrupti beatae ut dolor. Et voluptas esse ex cupiditate omnis.
Dolores tempora ratione molestias eveniet porro debitis nemo. Perferendis hic in rerum ab sequi tempora harum. Ex voluptatum et et qui.