Hey everyone, working on my lbo model and all of the sudden I have #DIV/O! errors all over. Does anyone know why this happens or an easy way to figure out where the error is coming from or how to fix it? I really don't want to have to start over from the previous version.
Excel 2007 in case that makes a difference.
Thanks in advance.
| +212 | Investment Banks Ranked By Your Divorced Blue Collared Uncle | 17 | 3h |
| +156 | Think Twice before Recruiting for HOUSTON IB!! | 65 | 2d |
| +139 | UBS Exits 2026 | 39 | 2h |
| +65 | Congrats on the ROs. I Still Don’t Know Which One You Were | 8 | 11h |
| +40 | Mid-Level UBS Departure for another BB (Grass Isn’t Greener…) | 31 | 3d |
| +39 | Did not get a return offer due to headcount, but happy to move on. | 8 | 16h |
| +37 | IB RO Discussion | 6 | 3d |
| +32 | GS - Low Bonus | 23 | 22h |
| +29 | Getting a BB job just for brand name? | 5 | 2h |
| +29 | Lied about bonus to future employer | 17 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
probably referenced a blank cell by accident and Excel went nuts
no bank uses excel 2007
"Prospective Monkey" boutiquebank, would my "PE" icon indicate that I work at a bank? Go back to your dorm room and start talking shit when you have a job.
LMAOOOOOOOOOOOOOO u old fuck upgrade your windows 98 u slimey roasted corn dog -- btw +1sb made me laugh so hard
Yeah, you need your cells to have values instead of blanks when doing division.
this occurs when you are attempting to divide by zero or a blank cell. choose a #DIV/O! cell and trace precedents. if that takes you to a cell with a #DIV/O! error, then do it again until you find a 0 or blank.
If its all over your model, its going to be a bastard to figure out which cell is the problem. I hope you've been saving up so you can go to the last version of the model and start from there.
"no bank uses excel 2007"
Rephrase to "no noname bank uses excel 2007, such as my boutique"
Less: "no bank uses excel 2007" Plus: "my boutique bank can't afford excel 2007" Plus: "and CFO clients always shame us when they send us excel 2007 models"
1) Fix your ref / mistake that caused the #DIV/0 - if you changed a reference by accident, press undo or something. This will not fix your model but is necessary for following steps 2) Ctrl-H, find: = replace with: WSO4Life 3) Replace 4) Calculate 5) Ctrl-H, find: WSO4Life, replace with: = 6) Replace 7) Profit.
This trick has saved me countless times.
If you have an absolute reference, make sure it is an absolute reference ex. $B$4
Whenever this happens to me, it's generally just Excel being buggy cause of some circular references. I'd hardcode in some zeroes for interest expense, your revolver, and cash line items, calculate, then put the formulas back in, recalc again. If it's still DIVing all over, then I'd keep trying this trick throughout the usual trouble spots of the model.
Excel '07 is way better. I can't wait until we switch to '10 - sparklines are money sons.
...you work in PE and can't troubleshoot a model?
Mighta been a consultant before....but that's a bit stretching for benefit of the doubt.
Bottom line is that you have a circularity(most likely) and need to check out one of the lines involved in that circularity.
In the future make sure that when you have a circularity you build them with an "if" statement that allows you to manually set their values to some arbitrary number, then revert them. This breaks the circularity and stops errors from feeding forward so that it will calculate correctly when you put the formula back in.
The way most modeling programs teach you do this is a pain in the ass, they'll want you to copy-paste values in and out. You can do this in a pinch(like if you forgot to put a circuit breaker in) but in general adding your circuit breaker should be one of the first things you do in a model, and you should throw your if statement in as soon as you build your first circularity.
Sapiente dolorem ducimus enim dolorem doloribus est aliquam corporis. Nam occaecati dolor ex qui. Et voluptates delectus quos aliquid fugit quod non.
Saepe quae excepturi odio aperiam corrupti sint consequuntur. Eligendi delectus repudiandae voluptatem voluptatem libero recusandae voluptates dolor.
Et blanditiis nostrum quo eum molestias. Non quo repudiandae est et architecto rerum molestiae. Nam sint non id veniam magnam. Sequi aspernatur modi deleniti deleniti eaque unde. Blanditiis rerum alias magni omnis quam. Labore consequatur odio aut amet asperiores culpa autem harum.
Eum debitis error eos aut doloribus. Minus voluptas hic eos veritatis.
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...