Apple cash flow statement11/30/2023 You have to think that each public company, even the smaller companies, have probably 10 F&A people working on their reports. ![]() Do hedge fund investors and equity research guys who have to build these models without further internal information from the company just accept having to make a bigass plug for like half of the fucking model? I want to make my tax calculation align perfectly with the number that shows up in their historical financials, but I can't. If they don't give me more detail than that "we use the lower of a), b), and c)," then how can I make the interest rate that my historical debt schedule spits out be equal to that shown in their historical financials? Again, do I just use some sort of plug for the historical years? If so, of what nature?įourth, pension fund liabilities and accrued payroll.įifth, taxes. Same issue as w/ the depreciation schedule. So do I just use some sort of a "plug" for the historical years? Second, assuming I use the company depreciation method as mentioned in the 10-K, how do I get the depreciation numbers that my historical depreciation schedules spit out to equal the depreciation numbers from the company's historical financials? It seems like it'd be impossible given that the only detail they give you is that "the general ranges of useful lives are: buildings and improvements = 10-40 years, software = 3-10 years, etc, etc. If the 10-k or 10-q doesn't give much color on those items, how am I to project them? Do I just have them going as a % of some income statement item? There are several items I'm not sure how to project or make foot for the historical years.įirst, there are the "Other" items: other intangible assets, other assets, other current liabilities. I'm building a model for a publically traded company. Question about getting historical integrated balance sheet and cash flow statements to foot? ( Originally Posted: ) If those topics were completely useless, don't blame me, blame my programmers. If we're lucky, maybe I can guilt some users to help you out: pepperamy IESHC collier Less: Cash taxes Less: Capex Less: Mandatory paydown Excess cash flow for I have seen examples of when excess cash flow is calculated as follows: EBITDA Less: Cash interest. I tried building the cash sweep in, but my balance sheet went all off.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |