mod 10 - dcf - forecast drivers
DESCRIPTION
Mod 10 - DCF - Forecast DriversTRANSCRIPT
![Page 1: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/1.jpg)
7/7/15
1
Michael R. Roberts William H. Lawrence Professor of Finance The Wharton School, University of Pennsylvania
Discounted Cash Flow: Forecast Drivers
Copyright © Michael R. Roberts
Copyright © Michael R. Roberts
Last TimeDiscounted Cash Flow (DCF)• Free Cash Flow
![Page 2: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/2.jpg)
7/7/15
2
Copyright © Michael R. Roberts
This TimeDiscounted Cash Flow (DCF)• Forecast Drivers
Forecast Drivers
Copyright © Michael R. Roberts
![Page 3: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/3.jpg)
7/7/15
3
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Revenue = Market Size x Market Share x Price
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 4: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/4.jpg)
7/7/15
4
Revenue = Market Size x Market Share x Price
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Revenue = Market Size x Market Share x Price
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 5: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/5.jpg)
7/7/15
5
Revenue = Market Size x Market Share x Price
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Corp
Revenue = Market Size x Market Share x Price
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Corp
![Page 6: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/6.jpg)
7/7/15
6
Costs = Cost Margin x Revenue
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Costs = R&D Expenditures
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 7: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/7.jpg)
7/7/15
7
Capital Expenditures
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Capital Expenditures
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 8: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/8.jpg)
7/7/15
8
Depreciation
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
*Straight line depreciation
Copyright © Michael R. Roberts
Net Working Capital = Cash + Inventory + AR – AP
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 9: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/9.jpg)
7/7/15
9
Net Working Capital = Cash + Inventory + AR – AP
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Net Working Capital = Cash + Inventory + AR – AP
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 10: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/10.jpg)
7/7/15
10
Net Working Capital = Cash + Inventory + AR – AP
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Net Working Capital = Cash + Inventory + AR – AP
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
![Page 11: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/11.jpg)
7/7/15
11
Δ Net Working Capital = Net Working Capital (t) – Net Working Capital (t-1)
where Δ = change over one period
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
Copyright © Michael R. Roberts
Taxes
FCF = (Revenue – Costs – Depreciation) x (1 – tC) + Depreciation – Capital Expenditures – Change in Net Working Capital
We want the marginal tax rate (MTR)=
Tax rate on additional $ of earnings25.5%
Copyright © Michael R. Roberts
![Page 12: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/12.jpg)
7/7/15
12
This is Nonsense!
Copyright © Michael R. Roberts
This is Nonsense!Impossible to make accurate forecasts!
Copyright © Michael R. Roberts
![Page 13: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/13.jpg)
7/7/15
13
This is Nonsense!Impossible to make accurate forecasts!
I agree, but that’s not the point!!!!
Copyright © Michael R. Roberts
Lesson: Point of DCF is to focus discussion and analysis on relevant issues
Copyright © Michael R. Roberts
![Page 14: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/14.jpg)
7/7/15
14
Lesson: Successful valuation (i.e., decision making) depends critically on input from non-finance personnel
Copyright © Michael R. Roberts
Summary
Copyright © Michael R. Roberts
![Page 15: Mod 10 - DCF - Forecast Drivers](https://reader038.vdocuments.us/reader038/viewer/2022103004/563dbb7a550346aa9aad8384/html5/thumbnails/15.jpg)
7/7/15
15
Lessons
• Forecast Drivers are the assumptions used to populate our free cash flow forecasts
• Goal is to establish framework for discussion– Think about value drivers
Copyright © Michael R. Roberts
Coming up next
• Discounted Cash Flow (DCF)– Forecasting free cash flow
Copyright © Michael R. Roberts