With the stock down -21.8% over the last three months, investors may be tempted to buy shares of Rowan Companies PLC (NYSE: RDC). In this article, I am going to calculate the fair value of Rowan by forecasting its future cash flows and discounting them back to today’s value. Value investors may find the results from my analysis surprising.

##### DCF Methodology

The basic philosophy behind a DCF analysis is that the intrinsic value of a company is equal to the future cash flows of that company, discounted back to present value. The general formula is provided below. The intrinsic value is considered the actual value or “true value” of an asset based on an individual’s underlying expectations and assumptions.

Cash flows into the firm in the form of revenue as the company sells its products and services, and cash flows out as it pays its cash operating expenses such as salaries or taxes (taxes are part of the definition for cash operating expenses for purposes of defining free cash flow, even though taxes aren’t generally considered a part of operating income). With the leftover cash, the firm will make short-term net investments in working capital (an example would be inventory and receivables) and longer-term investments in property, plant and equipment. The cash that remains is available to pay out to the firm’s investors: bondholders and common shareholders.

I will take you through my own expectations for Rowan as well as explain how I arrived at certain assumptions. The full analysis was completed on Monday, April 9. An updated analysis using real-time data can be viewed in your web browser at finbox.io’s Rowan DCF analysis page. The steps involved in the valuation are:

`1. Forecast Free Cash Flows`

- Create a revenue forecast
- Forecast EBITDA profit margin
- Calculate free cash flow

`2. Select a discount rate`

`3. Estimate a terminal value`

`4. Calculate the equity value`

##### Step 1: Forecast Free Cash Flows

The key assumptions that have the greatest impact on cash flow projections are typically related to growth, profit margin and investments in the business. The analysis starts at the top of the income statement by creating a forecast for revenue and then works its way down to net operating profit after tax (NOPAT), as shown below.

From NOPAT, deduct cash outflows like capital expenditures and investments in net working capital and add back non-cash expenses from the income statement such as depreciation and amortization to calculate the unlevered free cash flow forecast (shown above).

###### Create A Revenue Forecast

When available, the finbox.io’s pre-built models use analyst forecasts as the starting assumptions. To forecast revenue, analysts gather data about the company, its customers and the state of the industry. I typically review the analysts’ forecast and modify the growth rates based on historical performance, news and other insights gathered from competitors. Note that if a company only has a small number of analysts giving projections, the consensus forecast tends to not be as reliable as companies that have several analysts’ estimates. Another check for reliability is to analyze the range of estimates. If the range is really wide, it may be less accurate.

Rowan Companies plc provides offshore oil and gas contract drilling services to the oil and gas industry. The company operates through Deepwater, Jack-ups, and ARO segments. The Deepwater segment operates 4 ultra-deepwater drillships. The Jack-ups segment operates 23 self-elevating jack-up rigs. The ARO segment operates 5 self-elevating jack-up rigs. The company operates in the United States Gulf of Mexico, the United Kingdom, and Norwegian sectors of the North Sea, the Middle East, and Trinidad. Rowan Companies plc was founded in 1923 and is based in Houston, Texas. Analysts covering the stock often compare the company to a peer group that includes Diamond Offshore Drilling, Inc. (NYSE: DO), Noble Corporation(NYSE: NE), ENSCO plc (NYSE: ESV), and Helmerich & Payne, Inc. (NYSE: HP).

^{source: Benchmarks: Forecasted 5yr Revenue CAGRs}

The company’s 5-year revenue CAGR of -1.6% is above all of its selected comparable public companies: DO (-13.0%), NE (-10.9%), ESV (-12.7%) and HP (-10.6%). However, the company’s projected 5-year revenue CAGR of -2.7% is above only DO (-7.0%), and below NE (6.4%), ESV (5.3%) and HP (18.0%).

As highlighted below, Rowan’s revenue growth has ranged from -30.4% to 17.1% over the last five fiscal years.

Going forward, analysts forecast that Rowan’s total revenue will reach $1,120 million by fiscal year 2022 representing a five-year CAGR of -2.7%.

###### Forecast Rowan’s EBITDA Profit Margin

The next step is to forecast the company’s earnings before interest, taxes, depreciation and amortization (EBITDA). Note that EBITDA is a commonly used metric in valuation models because it provides a cleaner picture of overall profitability, especially when benchmarking against comparable companies. This is because it ignores non-operating costs that can be affected by certain items such as a company’s financing decisions or political jurisdictions. For more detail, see Rowan’s EBITDA definition.

EBITDA margin is calculated by dividing EBITDA by revenue. The higher the EBITDA margin, the smaller the firm’s operating expenses are in relation to its revenue, which may ultimately lead to higher profit. Lower operating expenses for a given level of revenue can be a sign of internal economies of scale.

The charts below compare Rowan’s LTM EBITDA margin to the same peer group. The company’s EBITDA margin of 50.0% is above all of its selected comparable public companies: DO (31.8%), NE (31.1%), ESV (13.6%) and HP (23.8%).

Rowan’s EBITDA margin has ranged from 8.5% to 50.0% over the last five fiscal years.

Wall Street analysts are forecasting that Rowan’s EBITDA margin will reach 24.1% by fiscal year 2022, representing a decrease of -26.0% from its LTM EBITDA margin of 50.0%.

Although I don’t specifically walk through my assumptions here, I then forecasted depreciation & amortization, capital expenditures and net working capital based on historical levels.

###### Calculate Free Cash Flow

With all required forecasts in place, the next step is to calculate projected free cash flow as shown below.

##### Step 2: Select Rowan’s Discount Rate

The next step is to select a discount rate to calculate the present value of the forecasted free cash flows. I used finbox.io’s Weighted Average Cost of Capital (WACC) model to help arrive at an estimate. Generally, a company’s assets are financed by either debt (debt is after tax in the formula) or equity. WACC is the average return expected by these capital providers, each weighted by respective usage. The WACC is the required return on the firm’s assets.

It’s important to note that the WACC is the appropriate discount rate to use because this analysis calculates the free cash flow available to Rowan’s bondholders and common shareholders. On the other hand, the cost of equity would be the appropriate discount rate if we were calculating cash flows available only to Rowan’s common shareholders (i.e., dividend discount model, equity DCF). This is commonly referred to as the difference between free cash flow to equity (FCFE) and free cash flow to the firm (FCFF). By using the WACC to discount FCFF, we are calculating total firm value. If we discounted FCFE at the required return on equity, we would end up with equity value of the firm. Equity value of the firm is simply total firm value minus the market value of debt.

I determined a reasonable WACC estimate for Rowan to be 8.5% at the midpoint. An updated cost of capital analysis using real-time data can be found at finbox.io’s Rowan WACC Model Page. The DCF model then does the heavy lifting of calculating the discount factors by applying the mid-year convention technique.

##### Step 3: Estimate Rowan’s Terminal Value

Since it is not reasonable to expect that Rowan will cease its operations at the end of the five-year forecast period, we must estimate the company’s continuing value, or terminal value. Terminal value is an important part of the DCF model because it accounts for the largest percentage of the calculated present value of the firm. If you were to exclude the terminal value, you would be excluding all the future cash flow past the horizon period. Using finbox.io, users can choose a five-year or 10-year horizon period to forecast future free cash flow.

The most generally accepted techniques to calculate a terminal value are by applying the Gordon growth approach, using an EBITDA exit multiple and using a revenue exit multiple. This analysis applies the Gordon growth formula:

As the formula suggests, we need to estimate a “perpetuity” growth rate at which we expect Rowan’s free cash flows to grow forever. Most analysts suggest that a reasonable rate is typically between the historical inflation rate of 2% to 3% and the historical GDP growth rate of 4% to 5%.

Rowan’s free cash flows are recovering at a healthy rate at the end of the projection period, so I’ve selected a perpetuity growth rate of 4.0% (at the midpoint).

##### Step 4: Calculate Rowan’s Equity Value

The enterprise value previously calculated is a measure of the company’s total value. An equity waterfall is a term often used by valuation firms, referring to the trickle-down process of computing a company’s equity value from its enterprise value. Note that in the event of a bankruptcy, debt holders will be paid in full before anything is distributed to common shareholders. Therefore, we must subtract debt and other financial obligations to determine a firm’s equity value. The general formula for calculating equity value is illustrated in the figure below.

The model uses the formula shown above to calculate equity value and divides the result by the shares outstanding to compute intrinsic value per share as shown at the bottom of the figure below.

The assumptions I used in the model imply an intrinsic value per share range of $4.68 to $9.36 for Rowan.

Rowan’s stock price currently trades at $12.87 as of Monday, April 9, -48.5% above the midpoint value of $6.63.

##### Conclusion: Rowan Has Downside Potential

A DCF analysis can seem complex at first, but it’s worth adding to your investment analysis toolbox since it provides the clearest view of company value.

Rowan’s stock has lost significant value over the last three months and investors may very well decide to buy shares. However, the stock still appears to have further downside potential based on its future cash flow projections.

A DCF analysis is only one piece of the puzzle in terms of building your investment thesis, and it shouldn’t be the only analysis you use when researching a company. Finbox.io applies a number of pre-built valuation models to calculate a fair value for a given stock and uses consensus Wall Street estimates for the forecast when available. The company’s average fair value of $8.85 implies -31.3% downside and is calculated from 8 separate analyses as shown in the table below.

Analysis | Model Fair Value | Upside (Downside) |
---|---|---|

10-yr DCF Revenue Exit | $8.81 | -31.6% |

5-yr DCF Revenue Exit | $9.53 | -25.9% |

Peer Revenue Multiples | $16.15 | 25.5% |

10-yr DCF EBITDA Exit | $6.78 | -47.3% |

5-yr DCF EBITDA Exit | $6.89 | -46.5% |

10-yr DCF Growth Exit | $6.58 | -48.9% |

5-yr DCF Growth Exit | $6.63 | -48.5% |

Earnings Power Value | $9.41 | -26.9% |

Average |
$8.85 |
-31.3% |

Note that an updated model using real-time data can be viewed in your web browser by clicking on any of the analyses listed above.

##### Author: Andy Pai

*Expertise:* financial modeling, mergers & acquisitions

Andy is also a founder at finbox.io, where he’s focused on building tools that make it faster and easier for investors to do investment research. Andy’s background is in investment banking where he led the analysis on over 50 board advisory engagements involving mergers and acquisitions, fairness opinions and solvency opinions. Some of his board advisory highlights:

- Sears Holdings Corp.’s $620 mm spin-off via rights offering of Sears Outlet, Hometown Stores and Sears Hardware Stores.
- Cerberus Capital Management’s $3.3 bn acquisition of SUPERVALU Inc.’s New Albertsons, Inc. assets.

Andy can be reached at andy@finbox.io.

^{As of this writing, I did not hold a position in any of the aforementioned securities and this is not a buy or sell recommendation on any security mentioned.}