I'm trying to model out a company that has about seven line items (not including dep & amort) on the cash flow - adjustments to reconcile net income to net cash. How do I go about setting the model up? Do I use all the line items or lump all of line items into a single line item? What is the best way to project the line items or line item?
| +81 | Q&A - Buyside Equity Research Analyst/PM | 29 | 3d | |
| +32 | How the heck do you learn all of this stuff? | 5 | 1w | |
| +28 | My experience on the sell side | 20 | 2w | |
| +28 | Getting Frustrated | 10 | 3w | |
| +24 | Clues in Financial Reporting Analysis | 7 | 6h | |
| +18 | Biotech ER vs IB | 16 | 3w | |
| +17 | Am i fairly compensated? | 9 | 1d | |
| +14 | Heard they don’t model at Oppenheimer | 10 | 2w | |
| +14 | Data Science to PM | 8 | 6d | |
| +12 | ER - Remote Jobs? | 8 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Depends on the item - most you should be able to pull from how you forecast on the income statement. Others you will have to make assumptions - maybe it is a % of sales, stays constant, goes to 0 - depends. For example, change in working capital you can make some assumptions on A/R, Inventory, A/P, etc. days/turns to calculate.
So the line items in questions excludes working capital items. The line items in questions are things such as FX gain/loss, tax benefits, deferred comp.
Odit repudiandae qui rerum. Sunt repellendus voluptate minima omnis neque praesentium incidunt. Sit eius laboriosam fugit labore. Fugiat corrupti dolor et. Enim qui iure 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...