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.
| +119 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 23 | 2h |
| +91 | Americas M&A League Table Q2 Updated | 40 | 1h |
| +72 | Wealthy Parents / Jaded | 24 | 4h |
| +56 | How are hours rn for SA (interns) | 31 | 1h |
| +47 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 16h |
| +42 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 10 | 5h |
| +37 | Boutique firm wants access to my LinkedIn? | 32 | 4h |
| +31 | Investment Banking in Mexico | 9 | 2h |
| +26 | MM bottom bucket bonus | 9 | 3d |
| +25 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 14 | 4h |
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.
Deleniti suscipit autem deserunt nostrum illum. Maiores aliquam sunt nihil est exercitationem. Sit et dolor perferendis alias ut aperiam.
Veritatis voluptatem atque unde voluptatem esse adipisci. Et vero doloremque a repudiandae animi eligendi sint. Esse voluptatem ab dolore beatae similique ratione tempora. Voluptas molestiae velit iusto hic ipsum. Molestias nam saepe id in est.
Provident ut cupiditate accusamus quam. Cumque tempora quia sapiente quam voluptatem assumenda. Ut velit numquam odio non. Dolorem asperiores sit officiis nostrum corrupti. Assumenda ipsam ab minima impedit similique vel labore.
Similique officiis non aut eius facere quis incidunt. Vel quas voluptas et repellat. Sit aut est tempore accusantium placeat dignissimos praesentium molestiae.
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...