I’m having some trouble projecting the CFS in a three statement model of a public company. For practice. It would be significantly easier for me to just create my own cash flow statement format using the balance sheet and IS projections instead of trying to reconcile them with this company’s CFS line items. They don’t seem to lineup well and it’s hard to tell where they have consolidated certain things. Is it kosher in the real world to do this? It shouldn’t matter right?
Trending Content - Investment Banking Forum
| +66 | Any tips for sleeping well? | 32 | 17h |
| +46 | Post-IB Paths (non-buyside) | 11 | 1d |
| +38 | Background check issue IB Full Time | 19 | 3h |
| +38 | Wealthy Parents / Jaded | 10 | 2h |
| +32 | The Impossible Triangle: Speed, Quality, and Managing Directors | 9 | 2d |
| +30 | Venezuela Debt Restructuring - LAZ vs CVP | 8 | 20h |
| +27 | Q dealflow slowdown | 22 | 2d |
| +27 | How are hours rn for SA (interns) | 17 | 1h |
| +24 | HL vs WB | 19 | 33m |
| +23 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 11 | 1h |
Career Resources
Bump.
Am I right in thinking that the best way to run a 3-statement model would be to project the income statement pretty much as is, likewise the BS (maybe consolidate a few of the more esoteric line items) and then the CFS pretty much just exists to plug the BS from one period to the next (i.e. you would disregard most of the weird line items that normally show up in a real company's CFS)?
Many thanks
Each company does their CFS differently and it’ll almost always be impossible for you to reconcile it line-by-line with BS accounts. To do a three statement op model project IS and BS and create the CFS from the balance sheet change year to year. (For assets, it’s beginning minus ending, vice versa for liabilities). There should be a line for everything that appears on the BS except cash. Then you can add andsubtract D&A and net income. Change in cash per period should match the company’s CFS, just the specific amounts contributed by Ops, Investment and Financing may differ depending upon how you organize.