Change in NWC & CapEx Assumptions
Currently at a MM IB and is doing interview with a MM PE. Received a case study with a CIM to build out a LBO model.
In the CIM, there is no CapEx figure shown in the company financials. There is only one balance sheet so I'm only able to calculate the NWC (Current Asset - Current Liability) and not the Change in NWC given there's only one period shown. Any idea how I should approach the assumptions for Change in NWC & CapEx so I can arrive at FCF? Thanks.
A few ideas.
1) What do your growth assumptions assume. I don't know the industry, but if its industrials for example you likely need to spend to grow.
2) Do like you would if you are building an LBO model for a public company you cover, use research. As the company in the CIP likely doesn't have research pick five close comps (as pure play as possible) and put together a benchmark of what CapEx / NWC capital should be in periods moving forward.
3) Because you have historical current assets / current liabilities (at least for one period) assume that they just stay at a constant % of revenue. Change in NWC is typically relatively immaterial unless you have massive prepayments for some reason (you sell all your software in year 1 for 5 years and collect for the 5 years up front.. etc.)
4) Do something that makes sense and that you can easily justify that fits your overall thesis and story and you will be just fine.
Remember that CapEx is very dependent on industry and how much in fixed permanent assets you need to grow. Zoom for example is going to have a lot of future CapEx not only tied to building out infrastructure, but opening more offices so that they can step up the pace on hiring very high quality talent diversified around the world like you need for a company that is trying to hit their targeted scale.
Net Working Capital adjustments at the end of the day are just there to true up cash flows and are tied to your ability to collect up front, collect cash rapidly (low accounts receivable), and delaying paying distributors (or conversely needing to pay-up front as a company itself).
I don't know anything about Zoom but I'd say tech is a terrible example of an industry that requires a lot of capex. R&D, their main "capex" driver, is actually expensed. And you think they are buying all their offices? No, they are renting them. Sure there are leasehold improvements that get capitalized but those are pretty minor.
Capex-heavy industries are ones that need to build infrastructure, plants, etc. Think heavy manufacturing, pipelines, railroads, etc...a few extra office chairs and computers is not going to be a big investment.
That said - the accounting treatment of R&D is something that needs to be separated from its essence. You do have to think of it as if it is capex, not a fixed operating expense. A portion of that R&D is maintenance and a portion is growth.
Good post, but one correction; a range of tech companies esp. in the software space capitalize R&D (e.g. 50%); not everything is expensed...
I’ll acknowledge I don’t know the software space generally and in my limited experience R&D is capitalized. So if I’m wrong about it being standard then I’m wrong.
I surrender. And thank you bringing this up. It is what makes the forums great. Pushing back on people. What was clear in my though process was not clear in my answer.
Notice I never said anything about S&M, R&D, or G&A. I was more attempting to convey that even in an industry like cloud software where there is "zero marginal cost (more like 10 - 25%)" and most expenses are recognized before the line there is still CapEx (more details below). However, the CapEx matches your industry. Why I started with industrials as my main example. I am a software guy and had just finished watching Zoom's analyst day when they were discussing future growth so it was top of mind. To assume that CapEx is immaterial for any company as a general rule of thumb is a mistake.
Also I agree with the point that when looking at the value of a company R&D should often be capitalized. Investments in current periods that will yield greater returns in future periods and should be amortized over its useful life. Damodaran has a great discussion on this. However, because it is hard to match those two up GAAP calls for expensing most of your R&D spend.
In terms of capitalizing software, it is governed by two principles: ASC 985
And ASC 350
Because of the barrier is so much higher in developing for external use (sold to customers) we often see more of these expenses expensed in R&D at a point-in-time than internal-use software which is typically more generously capitalized. It is a bit of a toss-up but most of the leading public tech companies recognize their expenses this way: MSFT, CRM, WDAY, ORCL etc. Further often what see capitalized in external facing costs are the implementation costs that can be easily analyzed on the time period for which they are to be amortized.
For reference the MD&A from one cloud company relating to their capitalized delivery costs.
However, for sake of discussion as these are not what we would all consider "traditional capital expenditures" and GAAP doesn't always match with Damodaran we will ignore capitalized software for the sake of the below analysis.
Turning back to Zoom what my post should have read to be more clear was:
Turning to Zoom's MD&A
To conclude most types of businesses require some form of fixed investment. It may not be as material as an industrial or healthcare firm, but they do need to be examined. Just because I have don't have to build factories or Hospitals doesn't mean the investments into the computers, office space renovations, furniture, displays, kitchens, servers etc. needed to support my growth are free and depreciated over time.
At the end of the day, it still remains a tool to help true up EBIT or Net Income to cash flows.
Hopefully that clears my writing up a bit. Thanks for pushing back and calling me out.
Good stuff. Appreciate the detailed response.
Tough to say without knowing the industry, but a common approach in case studies is to set capex equal to D&A. Implicit assumption is that you are “maintaining” the business. If your company is in a growth industry, then you will want to have higher capex (i.e., growth capex vs maintenance capex). Growth capex should yield some sort of return in the form of higher top line growth.
On NWC, calculate the usual ratios (DSO, DIO, DPO, % revenue) for the period you have. Hold those flat throughout the projection period unless you have a reason to believe they change.
Nailing the revenue build is probably a better use of your time than NWC / capex.
Voluptate mollitia hic et voluptatem. Facere ratione quo aperiam assumenda voluptatem et assumenda exercitationem. Dolor eaque labore porro magnam molestias atque maiores id.
Veritatis provident ipsa libero eius. Laborum tempora autem illum ab pariatur. Laboriosam laudantium ipsam aut est quod eos at.
Quia doloremque voluptatem ut nam possimus rem. Tempora quis unde dolore fugiat. Natus iusto et voluptatibus dolorem deserunt.
Vel magnam et inventore qui. Dicta rerum labore distinctio et. Eius necessitatibus nisi harum cum modi. Error saepe minima culpa provident nihil et.
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...