<div class="captioned-image-container"><figure><a class="image-link image2 is-viewable-img" href="https://substackcdn.com/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F95b55f4c-4176-4b1e-834d-965671350fac_800x450.jpeg" target="_blank"><div class="image2-inset"><source type="image/webp" /><img alt="21 Coole Toepassingen met Excel - TailorIT" class="sizing-normal" height="450" src="https://substackcdn.com/image/fetch/w_1456,c_limit,f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fsubstack-post-media.s3.amazonaws.com%2Fpublic%2Fimages%2F95b55f4c-4176-4b1e-834d-965671350fac_800x450.jpeg" title="21 Coole Toepassingen met Excel - TailorIT" width="800" /><div class="image-link-expand"><div class="pencraft pc-display-flex pc-gap-8 pc-reset"><div class="pencraft pc-reset icon-container restack-image"><svg class="lucide lucide-refresh-cw" fill="none" height="20" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2" viewBox="0 0 24 24" width="20" xmlns="http://www.w3.org/2000/svg"><path d="M3 12a9 9 0 0 1 9-9 9.75 9.75 0 0 1 6.74 2.74L21 8"></path><path d="M21 3v5h-5"></path><path d="M21 12a9 9 0 0 1-9 9 9.75 9.75 0 0 1-6.74-2.74L3 16"></path><path d="M8 16H3v5"></path></svg></div><div class="pencraft pc-reset icon-container view-image"><svg class="lucide lucide-maximize2" fill="none" height="20" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2" viewBox="0 0 24 24" width="20" xmlns="http://www.w3.org/2000/svg"><polyline points="15 3 21 3 21 9"></polyline><polyline points="9 21 3 21 3 15"></polyline><line x1="21" x2="14" y1="3" y2="10"></line><line x1="3" x2="10" y1="21" y2="14"></line></svg></div></div></div></div></a></figure></div><p><em><strong>What if I told you that many financial models are lying to you?</strong></em></p><p>This post is inspired by the Excel file I received earlier this week. It <strong>contained 12 sheets, some of them with ~600 rows.</strong></p><p>The person who created it has a fantastic understanding of accounting and finance. He has spent decades in investment banking but fell into this trap.</p><p>It was a 10-year financial model divided into quarters. The level of detail was <strong>impressive but not useful.</strong></p><div><hr /></div><p><strong>1.0 More Data Is Not Always Better</strong></p><p>Most people in the finance world are passionate about numbers and consider themselves data-driven. By that logic, having more data should help us make better decisions. This is true at the very beginning.</p><p>However, <strong>there comes a point when more data doesn’t lead to better decisions but to more clutter. </strong>At that point, more data makes decision-making more difficult.</p><p>A financial model with 600 rows looks thorough, but if it has 20 assumptions, it just multiplies potential errors. The illusion of precision tricks us into thinking that more data points equal better forecasts.</p><p class="button-wrapper"><a class="button primary" href="https://thefinancecorner.substack.com/subscribe"><span>Subscribe now</span></a></p><div><hr /></div><p><strong>2.0 The Human Nature</strong></p><p>Throughout our lives, we’re taught that we'll get rewarded if we do the work.</p><ul><li><p>If you study and do your homework —> You’ll get good grades;</p></li><li><p>If you work hard —> You’ll get a promotion;</p></li><li><p>If you… —> You’ll get …</p></li></ul><p>There’s nothing inherently wrong with that, and it isn’t new. Even the cavemen knew, <em><strong>If you hunt —> You’ll get to eat.</strong></em></p><p>However, this relationship doesn’t always exist, and that’s what makes it dangerous.</p><p>If you spend a week building a model, you expect a reward:<strong> a thorough model that you trust because you put in the work. </strong>However, if you spend another week and make it more detailed, the model doesn’t necessarily improve.</p><p>You can divide your 10-year financial model into quarters. It’s a waste of time. <strong>You cannot forecast the capex in the third quarter, 7 years from now. Why bother? </strong>The decision to use quarters instead of a full year doesn’t make the forecast better, just more complex and difficult to read.</p><p>If used for investing, this is even more dangerous, where you can tweak an assumption to justify the time spent. Because otherwise, you’ve put in all the work, and the outcome is not actionable. If you are creating financial models for investing, you have to get comfortable that <strong>most of the time, the outcome is not actionable.</strong></p><div><hr /></div><p><strong>3.0 The Fake Feeling of Control</strong></p><p>Adding 50 additional rows and splitting one unknown variable into six unknown variables doesn’t make a forecast more accurate.</p><p>It gives a <strong>fake feeling</strong> <strong>of control</strong>. In reality, it just makes uncertainty less visible.</p><p>Instead of acknowledging unknowns, detailed models can <strong>hide flawed assumptions under layers of complexity</strong> that make them harder to challenge.</p><p class="button-wrapper"><a class="button primary" href="https://thefinancecorner.substack.com/subscribe"><span>Subscribe now</span></a></p><div><hr /></div><p><strong>4.0 The Real Purpose of a Financial Model</strong></p><p>The goal of a financial model isn’t to be exhaustively detailed - it is <strong>TO BE USEFUL </strong>to the stakeholder(s).</p><p>Here’s how you can be better at financial modeling:</p><ul><li><p>Be aware of who the stakeholders are. If it is the CEO or CFO, they don’t have time to go over 100s of rows. Figure out how to summarize everything into one page;</p></li><li><p>Before you make a model more complex, ask yourself if that is really necessary or if you’re replacing one with multiple unknowns;</p></li><li><p>Make any assumptions used <strong>transparent</strong> so that they can be tested and challenged - This allows for scenario analysis.</p><p></p></li></ul><p>Any forward-looking financial model is <strong>an educated guess,</strong> and it should be treated as such.</p><p></p><p>If you enjoyed this post, consider sharing it; it helps the newsletter immensely.</p><p class="button-wrapper"><a class="button primary" href="https://thefinancecorner.substack.com/p/how-financial-models-trick-smart?utm_source=substack&utm_medium=email&utm_content=share&action=share"><span>Share</span></a></p>