How to use flags in a model
Can someone explain how to use flags in a model simply (I.e. to indicate lease start dates)? For example, I see 1s and 0s used pretty frequently. And also, what is the reason they are used / what would have been the alternative otherwise? I understand they’re a bit easier to follow / audit
I’m able to follow them when built in a model but am struggling conceptually about how to think about them when building them from scratch on my own. Is there anyway I should think about them at their core / broken down? Thanks!
The idea is to always keep your model simple to follow. This also helps minimizes potential mistakes you could make when creating it!
Flags are useful when a formula becomes too complex to follow. By breaking the formula into two parts using a flag, you can make it easier to understand. The alternative is either having a long, hard to follow formula or just hardcoding (I like to keep my models dynamic, but it really depends on the situation).
I'll use your example of a start date for some lease. You can build this type of flag the following way:
Got it this makes a ton of sense. So I should think of flags as not just to show timing but as an actual input / switch (i.e. for visibility to see where on a timeline a lease starts) that id multiply
Yes, that's the general idea.
Qui omnis atque pariatur. Laborum et at illum ut numquam alias quasi voluptatibus. Est sit ut explicabo sequi doloribus cum quia rerum.
Pariatur possimus non voluptatem vero excepturi alias ut. Est laborum culpa dicta similique deserunt accusantium. Dolor nisi illum neque ut ex reiciendis.
Aperiam sed dolorem sit ipsam est. Eum nulla iure explicabo deleniti atque qui et. Tempore et harum recusandae sapiente ut qui molestias.
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...