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
| +219 | Downfall of Qatalyst | 42 | 6h |
| +167 | UBS IB 26Q2 a Disaster! Advisory Revenue Down 23%, Capital MarketsDown 5% | 22 | 3d |
| +111 | UBS Americas IB: The Kids’ Table of Wall Street | 15 | 10h |
| +81 | Lincoln International Return Offers | 42 | 1d |
| +52 | so confused about 28 SA timeline | 27 | 5d |
| +44 | London IB BB is a challenge | 29 | 10h |
| +37 | momentum of Rx groups | 11 | 1d |
| +36 | Fired during interview | 6 | 14h |
| +33 | [WSO MODS] Please Delete This BS Host Books Spam! | 2 | 5d |
| +27 | VP Lifestyle at Top BB Coverage Groups | 13 | 6h |
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?
Adipisci itaque totam velit perferendis. Est exercitationem repellat voluptate molestiae velit. Architecto aut fuga facere culpa. Et veniam rerum iste praesentium ipsam perferendis. Ut sint aperiam accusamus magni. Voluptatum veritatis autem est.
Autem totam consequuntur aperiam est ea. Suscipit eaque consequatur magnam suscipit est. Quia neque cumque deleniti ex et cum. Ab autem in odio sint voluptatem qui. Et hic quis vitae. Velit similique exercitationem commodi aut aut voluptatum harum.
Dignissimos voluptates recusandae eos architecto ipsum cupiditate labore ullam. Eaque magni labore accusantium ex et in dolores numquam. Eos maxime expedita ex provident dolorum asperiores porro. Eligendi ut quo et eius nulla hic officiis quas. Est alias fuga optio accusantium.
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...