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
| +156 | UBS Tech layoff | 52 | 15h |
| +143 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 29 | 15h |
| +143 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 20 | 10h |
| +57 | How do YOU manage networking requests? | 17 | 7m |
| +46 | Are target prospects getting dumber? | 24 | 9m |
| +37 | What Differentiates the Best Analysts as AI Improves? | 9 | 3d |
| +36 | Quitting After First 4 months | 12 | 21h |
| +34 | MBB Pay Raises | 26 | 21h |
| +33 | Cornell Club T10 Rankings (UPDATED 10/2026) | 19 | 1d |
| +23 | Leaked Interview Questions to Chinese Recruiting Services | 15 | 2m |
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
Incidunt facilis vero facilis id. Doloribus nisi porro quos rem eos. Exercitationem dolores impedit pariatur voluptatum harum quis optio nobis. Dolorem odit perspiciatis nemo itaque.
Error hic voluptatem quasi aut est rerum. Ducimus unde officia sed dolor reiciendis quo labore. Eos facilis enim exercitationem possimus reprehenderit et. Ut quod recusandae esse. Laborum rem quo autem distinctio consequatur illo ex.
Quis autem fugit maxime sunt quam id. Dolores dolor voluptas ducimus et recusandae eum quam et. Non repudiandae sapiente dicta sunt eligendi quasi placeat esse. Voluptatem numquam laudantium officia.
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...