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
| Current and Former UBS Bankers: Do You Regret Joining? Was It Worth It? | 41 | 3m | |
| +181 | UBS IB Americas has failed, now behind Santander and Stiffel | 35 | 3d |
| +161 | Some banks are overrated as fuck | 55 | 53m |
| +144 | Beware all those preparing to recruit for '28 | 41 | 18h |
| +38 | Post-IB Paths (non-buyside) | 9 | 1h |
| +35 | Does making it in IB mean killing your personality? | 11 | 1d |
| +34 | How to be satisfied | 23 | 18h |
| +31 | Any tips for sleeping well? | 10 | 1h |
| +29 | Weird Question: Would you rather your MD be someone you despise, or someone you love? | 3 | 2h |
| +27 | Summer Class is wild | 17 | 13h |
Career Resources
I would say you can use your own projections/assumptions from the projected years in your BS/IS to forecast your CF line items and link the final cash balances back to the BS
As long as your only output is the end cash balance flowing into the balance sheet that should make no difference
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
Second this question
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.
Thanks - SB'd. So basically you create your own CFS based on your BS. Historical changes in cash per period should reconcile to the company's but line items (and O/I/F groupings) will not?
Laborum est deserunt non mollitia suscipit. Architecto ut cumque commodi nobis. Pariatur nulla ipsa labore aut tempore sapiente qui. Aut eligendi et nihil et ut.
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...