In order to value a company that you have chosen in the first topic this week, you would need to forecast its future (a key word here) free cash flows. How would you approach this task? Using downloaded real data, try to make the forecast and see, what issues you might have.
Chevron Corporation
Full Answer Section
- Calculate free cash flow. I would calculate the company's free cash flow for each year of the forecast period using the following formula:
Free cash flow = Operating cash flow - Capital expenditures
Operating cash flow is calculated by subtracting operating expenses from revenue. Capital expenditures are the company's investments in property, plant, and equipment.
-
Discount free cash flows to present value. I would discount the company's future free cash flows to present value using a discounted cash flow (DCF) model. The DCF model takes into account the time value of money and the riskiness of the investment.
-
Calculate the company's valuation. I would calculate the company's valuation by adding up the present value of its future free cash flows.
Issues with forecasting future free cash flows:
There are a number of issues that can arise when forecasting future free cash flows, including:
- Uncertainty about future economic conditions. Economic conditions can have a significant impact on a company's free cash flows. For example, a recession can lead to lower revenue and higher costs.
- Uncertainty about future industry trends. Industry trends can also have a significant impact on a company's free cash flows. For example, the rise of e-commerce has disrupted many traditional industries.
- Uncertainty about future company performance. It is difficult to predict how a company will perform in the future. Factors such as new product launches, competitor activity, and management changes can all have a significant impact on a company's performance.
Using real data to forecast free cash flows:
To forecast the future free cash flows of a company using real data, I would use the following steps:
- Download the company's financial statements from a website such as EDGAR or SEC.gov.
- Build a financial model in Excel or another financial modeling software.
- Enter the company's historical financial data into the model.
- Forecast the company's future revenue, expenses, capital expenditures, and working capital requirements.
- Calculate the company's free cash flow for each year of the forecast period.
- Discount the company's future free cash flows to present value using a DCF model.
- Calculate the company's valuation by adding up the present value of its future free cash flows.
Example:
The following example shows how to forecast the future free cash flows of a company using real data:
Step 1: Download financial statements
Download the company's financial statements from a website such as EDGAR or SEC.gov.
Step 2: Build a financial model
Build a financial model in Excel or another financial modeling software.
Step 3: Enter historical financial data
Enter the company's historical financial data into the model.
Step 4: Forecast future financial performance
Forecast the company's future revenue, expenses, capital expenditures, and working capital requirements.
Step 5: Calculate free cash flow
Calculate the company's free cash flow for each year of the forecast period.
Step 6: Discount free cash flows to present value
Discount the company's future free cash flows to present value using a DCF model.
Step 7: Calculate valuation
Calculate the company's valuation by adding up the present value of its future free cash flows.
Issues with using real data to forecast free cash flows:
There are a number of issues that can arise when using real data to forecast future free cash flows, including:
- Accuracy of historical data. The accuracy of the historical financial data can have a significant impact on the accuracy of the forecast.
- Assumptions about future performance. The assumptions made about future revenue, expenses, capital expenditures, and working capital requirements can also have a significant impact on the accuracy of the forecast.
- Risk assessment. The risk assessment is a key input to the DCF model. An inaccurate risk assessment can lead to an inaccurate valuation.
Conclusion:
Forecasting the future free cash flows of a company is a complex task.
Sample Answer
To forecast the future free cash flows of a company, I would use the following approach:
- Gather data. I would gather as much historical data as possible on the company's financial performance, including its revenue, expenses, capital expenditures, and working capital requirements. I would also gather data on the company's industry and the overall economy.
- Build a financial model. I would build a financial model to forecast the company's future revenue, expenses, capital expenditures, and working capital requirements. The model would take into account the company's historical performance, its industry trends, and the overall economic outlook.