Thanks for taking a look at this - see below for quick summary. Very high level model. Have 2016/17 balance sheet, no balance sheet projections. Need to know what to use as driver going forward.
In driving Change in NWC impact going forward, do you: A) Take WC as a % of sales each year, then use the delta of those two numbers for your FCF impact
-OR-
B) Take change in NWC from '16 to '17 as % of sales
Thanks in advance
| +85 | Drunk VP. How to manage? | 28 | 4h |
| +45 | How do I take my foot off the gas? (AN1) | 4 | 3d |
| +44 | Lazard US Views 2026/2027 | 16 | 2h |
| +40 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 9 | 6h |
| +37 | Tomorrow Will Be Better | 5 | 6h |
| +33 | Moelis PCA vs Lower tier BB Coverage | 18 | 3h |
| +28 | Why Do We Turn Comments? | 3 | 11h |
| +22 | UBS’s Investment Bank Is Building an AI Slop Factory | 2 | 8h |
| +21 | How early is to early? | 9 | 1d |
| +20 | MS NYC Generalist Program Group Rankings & Placement Process | 11 | 9h |
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.
I believe either of the following two options is correct:
1) NWC as a % of sales 2) change in NWC as % of CHANGE in revenue
what does the % of change in revenue mean? How is this different from ((final rev - initial rev)/(initial rev))?
Change in NWC as % of change in revenue. Assumption is every unit of growth will proportionately drive the items within working capital.
which is same as % of revenue. I.e. if change / delta nwc = 5% of revenue, if revenue increases, delta nwc increases proportionally
So either method is valid?
i believe so
Iusto adipisci nam porro. Repellendus itaque qui illo. Amet harum quae sit dolorem dolorem facere et consectetur.
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...