I am studying comparable analysis and need to forecast the FCF (= Cash from operating activities - CapEx) for the next two fiscal years. I have the FCF (LTM 10/31/2017) and the estimated CapExs for 2017E, 2018E and 2019E. I hope to know how I could get the Cash from Operating Activities for 2017E, 2018E and 2019E.
Or maybe I should find a FCF annual growth rate from somewhere?
Thank you!!
| +158 | The "Not So Obvious" things that get you a return offer? | 18 | 4h | |
| +84 | Is my life over after not getting GS? | 19 | 49m | |
| +60 | Best IB group on the Street | 24 | 10m | |
| +52 | BIG FOUR ARE PARADISE | 13 | 9h | |
| +46 | Thoughts and tips on how to speak like an investment banker. | 23 | 6h | |
| +40 | Tell me one good reason why Jefferies isn’t going to be a top bank in the next 5 years | 20 | 18h | |
| +36 | UBS Outlook | 28 | 21h | |
| +35 | Georgetown Placement for 2024 and 2025 | 21 | 6d | |
| +31 | Highest Paid Bankers in Toronto? | 50 | 1d | |
| +30 | How to deal with egotistical team? | 6 | 2d |
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.
Maybe forecast sales (taking into account seasonality and trend) then make the rest of the items % of sales? You should be able to fill out the rest of the statements using that then just calculate OCF as EBIT+Depr.-Taxes+/-ChangeWC (i think).
Hi! Thank you very much for your kind answer. I have the Forecasting Sales (for 2017, 2018 & 2019) and FCF/Sales % (for previous three years). Do you think I could get the Forecasting FCF using [Forecasting Sales x Average FCF/Sales % of Previous Years]?
Don't try to find a shortcut, trust me you're going to want to forecast as much of the 3-statements as possible then calculate FCF for each period. Then unlever your FCF and derive your EV from that. After that you can calculate your multiples to compare to whatever comps set you have.
Thank You and wish you a successful Year of 2018! :)
I agree with MarlboroJones, don't shortcut this.
If you have forecasted sales and trailing information it is pretty easy to get FCF. You will need to find your net income - forecast your COGS, operating costs, interest, and taxes to derive this number. Your cost assumptions should be relatively straightforward, look at the trends and apply assumptions for scales of economy to fixed cost. Then you will have to find the balance sheet items that go into your operating cash flow - i.e. change in net working capital. You should use trailing ratios on AR, AP, Inventory, ect. to find future line items. Take the difference (Increase in asset means reduction in cash, increase in liabilities means an increase in cash - and vice versa) to find what your change in net working capital is on the cash flow statement.
Thank you and wish you a successful Year of 2018!
What's the best way to forecast FCF? (Originally Posted: 11/25/2017)
Hi smart friends,
I am contemplating on what FCF forecasting method is better in what situations.
Method 1: Damodaran suggests calculating the average historical ROIC of an economic period (5-10 years), average historical reinvestment rate, and multiply them to get the growth rate in operating income --> FCFF = Forecasted NOPAT * (1 - Reinvestment Rate)
Method 2: From McKinsey's book, they suggest forecasting most items on all financial statements by finding their relation to revenue (or other items)
Theoretically option 1 is done with option 2 as that gives you an idea of the terminal year growth rates and margins, but option 2 is more flexible especially if the firm had planned projects, cyclical, growing, or had a few years of change.
Generally people go with option 2 and may use aspects of option 1 for the terminal year if at all.
SB'ed. I think you've covered this in whole, yes :). Generally, option 1 is a good back of the envelope that you can use in the absence of very granular information, but I've usually found a driver based bottoms up model to be the most intuitive (though a degree more time consuming to build). Having X correspond to [ ], Y to [ ], and Z to [ ], and then each of these to segment/product level growth, was always the ideal way of going about it for me.
Unfortunately, sometimes we aren't given the necessary level of detail, and have to make a high level approximation based on the historicals. (truth be told, I don't think there is a meaningful difference between the two methodologies at all, but you didn't hear it from me ;P)
How to forecast FCF for a cyclical company? (Originally Posted: 11/27/2017)
What to do when the growth in revenues and reinvestment greatly fluctuate from year to year?
Thanks.
This is something you should rely on your group for; this is something that is highly specialized.
what?
If there's any pattern to the fluctuations, just run your DCF for a period that's divisible by that number of years.
EG if the company hits peaks and troughs over three years, run your DCF for 6. There's no magic to 5 years.
SOS! Free Cash Flow Model Forecast for a company without operations (Originally Posted: 12/01/2014)
Hi guys,
I am currently working on a valuation project of Cheniere Energy (LNG) for my class. The company has net losses for past 10 years because it has no operations so far but its stock price has gain remarkable momentum over the last 3-5 years. The company is the first to have the license to export LNG from US and is currently building LNG liquefaction facilities, which will be the first to become operational in US. When I am trying to do the Free Cash Flow Model forecast ten years into the future, I am using the contract prices and amount of purchases stated on various SPAs linked to the trains liquefaction facilities upon the commence of their operations. I am not sure about how to forecast the capex number and depreciation as there isn't a "normal year" with no growth to start with. I asked my professor, he said something about the project cost being capitalized, which is linked to depreciation. Should I simply use the depreciation number on the latest income statement (Income Statement Screenshot attached)? For Capex, should i use the number on Capex Screenshot attached
Depreciation grows with PPE. If you are increasing PPE due to building new facilities, I would expect a corresponding increase in depreciation. Perhaps use the average historical depreciation as a % of PPE and project that % forward based on where you see PPE going.
Cap-ex is probably not related to historic trends in this case, especially if they are starting a significant new project. Cap-ex expectations are usually disclosed by a company either in the most recent earnings release or most recent transcript. Management usually guides to the expected cap-ex number. The good news is, if you have your cap-ex number, you also have your increase in PPE.
Quam deserunt ut eligendi laudantium voluptate sint voluptatem. Quis itaque quas est voluptas velit qui. Distinctio eius corrupti doloribus similique velit. Accusamus aut dolores et quo in debitis. Similique illum illum facere qui possimus est ipsum.
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...