Adding Switches to a Model
How do you add things like case switches or a circuit breaker to an excel model? Was trying to practice modelling and couldn’t figure it out. Thanks!
How do you add things like case switches or a circuit breaker to an excel model? Was trying to practice modelling and couldn’t figure it out. Thanks!
| +305 | I Snuck Into UBS Office And Took A Shit On The Floor | 28 | 1d |
| +250 | Houston 2026 Oil & Gas Investment Banking Rankings | 65 | 2h |
| +244 | Why leave restructuring for M&A? | 30 | 1d |
| +232 | Best Power/Renewables/Energy Teams? | 39 | 11h |
| +209 | Predicted 1Q 2027 Story - UBS IB blames Outlook Outage for Down Quarter | 37 | 6h |
| +188 | Centerview HC group falling off? | 30 | 1d |
| +184 | Actual EB List | 27 | 1d |
| +183 | Incoming TPH Analysts Larping as PWP on LinkedIn | 27 | 2h |
| +24 | I built a game to help me practice fundamentals like DCF, merger models and LBOs. Roast it? | 6 | 3h |
| +22 | What’s the current state of IBD at BofA? | 26 | 22h |
Career Resources
Case switch is using =OFFSET, rareliquid has model building videos on YouTube that shows how it works. Ex look at his Nvidia DCF valuation Live video at 1:06:00. idk about circuit breakers
Rareliquid is a total beauty, he got me into offset as well
You need to add a circuit breaker / circularity switch to avoid your model blowing up with #REFs beyond repair. This usually affects interest, as the interest payment is based on the average debt balance during any given year, which creates said circularity as the payment affects the cash flow which you would use to pay down debt. Hence, designate a cell in controls as switch, name the cell “circ”, and then add before any interest item in the debt waterfall =if(circ=0,previous year end balance debt*interest rate,average(starting balance,end balance)*interest rate)
hope this helps
.
See above for example.
No need to add a circuit breaker. Instead, simply CTRL + F, find and replace all "=" with "=".
This action refreshes all formulas and essentially has the same impact as a circuit breaker.
Labore sit nihil nam vel officia. Consequatur velit ut exercitationem modi iusto.
Dolor quisquam possimus deleniti velit numquam. Aut enim iste aut ipsa. Modi ipsum a aut quos error corporis dolores. Itaque est autem ipsam illum aut quis et.
Dolorem corporis cupiditate libero ut rerum consequatur qui. Laborum quo et commodi at. Vel ratione eligendi et qui mollitia.
Non voluptas occaecati ad alias ea rerum ut eum. Aut rerum rerum dicta minus debitis.
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...