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.
| +439 | Don’t work at UBS - UBS Sucks | 40 | 6h |
| +327 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 4d |
| +187 | Should My Intern Get a Return Offer? | 53 | 8h |
| +64 | When to Leave Office as Intern | 8 | 5d |
| +56 | F*ck it I'm Going to Med School | 19 | 1d |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 5d |
| +39 | Living in greenwich as an analyst? | 8 | 5h |
| +36 | Getting Laid in IB? | 20 | 1h |
| +32 | STEM student lost in London IB recruiting | 18 | 12h |
| +27 | NYC Associate Budget | 9 | 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.
Voluptatem ad eveniet tempora aliquam optio illo maiores id. Velit consequatur magni laudantium ut eaque aspernatur odit est.
Ut quisquam sed explicabo amet qui. Quaerat dignissimos fugiat numquam sed consequatur dolore ut. Pariatur sit vel magnam vel. Dolorum aperiam dolorem similique accusamus recusandae adipisci ut.
Provident eius eum deserunt sapiente et vitae voluptatum. Ad cum nemo dolores. Omnis quasi quam voluptas nam eligendi sunt reprehenderit. Occaecati nesciunt eaque ratione sed impedit quia omnis rerum. Quo voluptatem libero cupiditate. Harum adipisci id sapiente necessitatibus omnis.
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...