Related Posts
Which FAANG companies have non-tech PM roles?
Additional Posts in Finance
Why does Congress get a pass on insider trading?
Fed hike: 👍 or 👎
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Assuming it’s just a generic 3 statement operating model:
Turn off your circ switch to zero out the interest expense and then make sure you have the correct sign (positive or negative) for all sources and uses in the cash flow statement
CTRL+F the value that’s half of whatever the model is off by (i.e. if model is off by 1,000, look for 500). Flip the sign on that number and it’ll balance (assuming it was wrong)
Then flip the circ switch back on
There are some other places to check if it’s an LBO model or anything with a debt waterfall with a revolver and multiple tranches...
Do you have a minimum cash balance? Could be double counting that.
Hope this helps!
Line up one quarter vs next on BS with a column laying out difference between quarters. Make sure all of those differences are accounted for in CFS (assuming you are building from NI)
also, what is the best way to prevent errors like that from happening in the first place?
Thank you!