Posts by: Guest 1

Dealing with Stock-based comp in the CF Stmt
What is the easiest way to deal with SBC in the CFFO section and then the CFFF sections of the CF Statement? Is there a way to estimate forward looking comp?
Go to post added 10 years ago
Re: Cash Circular
Well, what can I say. Thank you. I did not include the LT items because they were LT, but to is something to consider for the future. Many thanks and, well, I'll make the changes and move along to the rest of the model sans drama. Thank you once again. I love the company and chucking the model wo... Read More
Go to post added 10 years ago
Re: Cash Circular
Sending now. I'll be interested to hear your diagnosis.
Go to post added 10 years ago
Re: Cash Circular
Nope. It didn't work. I give.
Go to post added 10 years ago
Re: Cash Circular
Ok, I tried erasing interesting income completely. The idea here was that if it is flowing thru the BS, then the difference would probably disappear. I can redo the SCF and BS, but if it doesn't change anything, well, then I'll just force a balance somewhere. But, yes, I agree, double counting se... Read More
Go to post added 10 years ago
Re: Cash Circular
As an addendum, I have checked all formulas, all signs, and all working capital accounts. Basically, I have checked everything I can check, yet assets still exceed liabilities by an amount equal to interest income.
Go to post added 10 years ago
Re: Cash Circular
Ok. I tried it with another company. I found a few errors on my part, and implemented your change. Still won't balance. Only off by a few dollars, but close just doesn't work. There is absolutely nothing left for me to check. The core model simply will not balance.The company has no debt, so no inte... Read More
Go to post added 10 years ago
Re: Cash Circular
Many thanks! I will give it a try once this drink (and the few that followed it) have worn off!
Go to post added 10 years ago
Cash Circular
I have seen the videos (sometimes twice). I have read *everything* on circular references. I have checked that my income expense is keying off of my ending debt values (this company has no debt) and that it has a negative sign. I have similarly checked interest income. It too keys off the ending deb... Read More
Go to post added 10 years ago
Re: Beginning Cash Balance
I think I found the error, and it has nothing to do with implementing things as taught. Remember, I did what you said earlier, fixed my errors (there were 2), audited all formulas, and I have no debt, so the revolver/interest expense are zero. The SUM function is throwing off wrong answers. This ... Read More
Go to post added 10 years ago