Switch to:

This is a preview!

Analysis and historical valuations for First Solar, Inc. are shown here for you to look at this page's features.

Valuation for First Solar Inc

First Solar Incis more suitable for Asset Based valuation methods. This includes 1) Net-Net Working Capital 2) Tangible Book Value per Share. The Net-Net Working Capital of First Solar Incfor the quarter that ended in Mar. 2019 was 4.53.The Tangible Book Value per Share of First Solar Incfor the quarter that ended in Mar. 2019was 48.01.

Intrinsic Value: Projected FCF, Graham Number, and Earnings Power Value (EPV) are the combination valuation methods of Asset and Earnings Power. The Intrinsic Value: Projected FCF of First Solar Incfor today is 36.79.The Earnings Power Value (EPV) of First Solar Incfor the quarterended in Mar. 2019 was 4.19.

First Solar Inc Net-Net Working Capital

The Net-Net Working Capital of First Solar Inc for the quarter that ended in Mar. 2019 was 4.53

In calculating the Net-Net Working Capital (NNWC), Benjamin Graham assumed that a companys accounts receivable is only worth 75% its value, its inventory is only worth 50% of its value, but its liabilities have to be paid in full. In addition, Graham believed that preferred stock belongs on the liability side of the balance sheet, not as part of capital and surplus. In "Security Analysis", preferred stock is dubbed "an imperfect creditorship position" that is best placed on the balance sheet alongside funded debt. This is a conservative way of estimating the companys value.

Calculation:

 Net-Net Working Capital = (CashAndCashEquivalents + 0.75 * Acct. Rec. + 0.5 * Inventory - Total Liabilities - Preferred Stock) / Shares Outstanding = (2117.214 + 0.75 * 301.669 + 0.5 * 519.362 - 2127.765 - 0) / 105.046 = 4.53

First Solar Inc Tangible Book Value per Share

The Tangible Book Value per Share of First Solar Inc for the quarter that ended in Mar. 2019 was 48.01

Calculation:

 Tangible Book Value per Share = (Total Equity - Preferred Stock - Intangibles) / Shares Outstanding = (5129.161 - 0 - 86.103) / 105.046 = 48.01

Since intangibles such as goodwill cannot be sold when the company liquidates, tangible book value per share is considered more accurate in reflecting how much shareholders will receive when the company liquidates.

First Solar Inc Intrinsic Value: Projected FCF

The Intrinsic Value: Projected FCF of First Solar Inc for today is 36.79

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value: DCF (FCF Based), or Discounted Earnings (DCE) Intrinsic Value: DCF (Earnings Based) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Free Cash Flow and Book Value of the company. The details of how we calculate the intrinsic value of stocks are described here.

This method smooths out the free cash flow over the past 6-7 years, multiplies the results by a growth multiple, and adds a portion of total equity.

Value = ((Growth Multiple)* Free Cash Flow(6 year avg) + 0.8* Total Equity(most recent))/ Shares Outstanding

In the case of negative total equity, the following formula is used (see the Total Equity section for the reason):

Value = ((Growth Multiple)* Free Cash Flow(6 year avg) + Total Equity(most recent)/0.8)/ Shares Outstanding

Calculation:

Here First Solar Inc' s FCF(6 year avg) is calculate as

First Solar Inc Quarterly Data
 201612 201703 201706 201709 201712 201803 201806 201809 201812 201903 total_freecashflow 215 380 -272 484 235 -223 -66 -463 -315 -453 201406 201409 201412 201503 201506 201509 201512 201603 201606 201609 total_freecashflow 56 -118 909 -480 -49 -24 62 32 -140 -130 201306 201309 201312 201403 total_freecashflow 137 306 136 -369

Add all the Free Cash Flow together and divide 6 will get First Solar Inc FCF(6 year avg) = -25.09

First Solar Inc's Intrinsic Value: Projected FCF for today is calculated as

 Intrinsic Value = (Growth Multiple * Free Cash Flow(6 year avg) + Total Equity(Mar19) * 0.8) / Shares Outstanding = (9.52035159596 * -25.092 + 5129.161 * 0.8) / 105.046 = 36.79

First Solar Inc's Free Cash Flow Growth Multiple is 9.52035159596.

First Solar Inc Median PS Value

The Median PS Value of First Solar Inc for today is 40.79

This valuation method assumes that the stock valuation will revert to its historical mean in terms of PS Ratio. The reason we use PS Ratio instead of PE Ratio or PB Ratio is because PS Ratio is independent of profit margin, and can be applied to a broader range of situations.

Calculation:

 Median PS Value = Revenue per Share (TTM) * PS Ratio (10y Median) = 20.918 * 1.95 = 40.79

PS Ratio (10y Median) is 1.95.
First Solar Inc's revenue per share for the trailing twelve months (TTM) ended in Mar. 2019 was 2.952(Jun. 2018) + 6.37(Sep. 2018) + 6.532(Dec. 2018) + 5.064(Mar. 2019) = 20.92.

First Solar Inc Peter Lynch Fair Value

The Peter Lynch Fair Value of First Solar Inc for today is 0.00

Peter Lynch Fair Value applies to growing companies. The ideal range for the growth rate is between 10 - 20% a year. Peter Lynch thinks that the fair PE Ratio for a growth company equals its growth rate, that is PEG = 1. The earnings here is trailing twelve month (TTM) earnings. The growth rate we use is the average growth rate for earnings per share over the past 5 years. If 5-Year Earnings Growth Rate is greater than 25% a year, we use 25.

Calculation:

 Peter Lynch Fair Value = PEG * 5-Year EBITDA Growth Rate * EPS without NRI (TTM) = 1 * * -0.07 = 0.00

5-Year Earnings Growth Rate is . If 5-Year Earnings Growth Rate is greater than 25% a year, we use 25..
First Solar Inc's EPS without NRI for the trailing twelve months (TTM) ended in Mar. 2019 was -0.46(Jun. 2018) + 0.54(Sep. 2018) + 0.49(Dec. 2018) + -0.64(Mar. 2019) = -0.07.

Please note that we use the 5-year average growth rate of EBITDA per share as the growth rate. EBITDA growth is subject to less manipulations than net earnings per share. In the calculation, PEG=1 because Peter Lynch thinks that the fair PE ratio of the growth stock is equal to its earnings growth rate.

First Solar Inc Earnings Power Value (EPV)

The Earnings Power Value (EPV) of First Solar Inc for the quarter ended in Mar. 2019 was 4.19.

Earnings Power Value also known as just Earnings Power is a valuation technique popularised by Bruce Greenwald, an authority on value investing at Columbia University. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future.

Assumption: Current profitability is sustainable.

Calculation:

 Average of Last 20 Quarters Last Quarter Revenue 3,035 DDA 194 Operating Margin % 3.91 SGA * 25% 65 Tax Rate % -75.27 Maintenance Capex 349 Cash and Cash Equivalents 2,117 Short-Term Debt 12 Long-Term Debt 558 Shares Outstanding (Diluted) 105

1. Start with "Earnings" not including accounting adjustments (one-time charges not excluded unless policy has changed). "Earnings" are "Operating earnings" (EBIT).

2. Look at average margins over a business/Industry cycle: Average Operating Margin = 3.9125%

To normalize margins and eliminate the effects on profitability of valuing the firm at different points in the business cycle, it is usually best to take a long-term average of operating margins . Ideally this would be as long as 10 years and include at least one economic downturn. However, since most of companies do not have as long as 10-year history, here GuruFocus uses the latest 5 years data to do the calculation. To smooth out unusual years but reflect recent developments, we take an average of the 5 year margin.

3. Multiply average margins by sustainable revenues and then adjust for maintenance SGA. This yields "normalized" EBIT:

To be conservative, GuruFocus uses an average of the 5 year revenue as the sustainable revenue.
EPV analysis recognises that part of SGA expenditure is made to maintain and replace the existing assets, while part is made to grow sales. Since EPV is only interested in what it costs a going concern to maintain its existing asset base, it adds back a percentage of SGA (between 15% and 50% - this is a matter of judgment and industry knowledge) to make up for the fact that some of this expenditure went to fund growth and shouldn't be accounted for. To start off, we assume 25% for the sake of prudence.
Sustainable Revenue = 3035.4386Mil, Average Operating Margins = 3.9125%, Average Adjusted SGA = 65.1571,
therefore "normalized" EBIT = Sustainable Revenue * Average Operating Margins + Average Adjusted SGA = 3035.4386* 3.9125% +65.1571= 183.918635225Mil.

4. Multiply by one minus Average tax rate (nopat):

Same as average operating margin calculation, GuruFocus takes an average of the 5 years tax rates.
Average Tax Rate = -75.274%, and "normalized" EBIT = 183.918635225Mil,
therefore After-tax "normalized" EBIT = "Normalized" EBIT * ( 1 - Average Tax Rate ) = 183.918635225* ( 1 - -75.274% ) = 322.361548704Mil.

5. Add back excess depreciation (after tax at 1/2 average tax rate). This yields "normalized" Earnings:

Excess depreciation = Average DDA * % of excess depreciation (after tax at 1/2 average tax rate) = 193.7528* 0.5 * -75.274% = -72.922741336Mil.
"normalized" Earnings = After-tax "normalized" EBIT + Excess depreciation = 322.361548704+ -72.922741336= 249.438807368Mil.

6. Adjusted for maintenance capital expenditure:

First, calculate the revenue change regarding to the previous year. If the revenue decreased from the previous year, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
Second, if the revenue increased from the previous year, then calculate the percentage of Net PPE as of corresponding Revenue.
Third, calculate Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was negative, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was positive, then the Maintenance Capital Expenditure = Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
Fourth, GuruFocus uses an average of the 5 year maintenance capital expenditure as maintenance CAPEX.
First Solar Inc' s Average Maintenance CAPEX = 349.0446 Mil.

7. Investors require a return of "WACC" for the risk they are taking: WACC = 9%

8. First Solar Inc's current cash and cash equivalent = 2117.214Mil.
First Solar Inc's current interest bearing debt = Long-Term Debt + Short-Term Debt = 558.356 + 12.361 = 570.717 Mil.
First Solar Inc's current diluted shares outstanding = 105.046Mil.

First Solar Inc's Earnings Power Value (EPV) for the quarter ended in Mar. 2019 was calculated as:

 EPV = ( ( Norm. Earnings - Maint. CAPEX) / WACC + CashandEquiv - Int. Bearing Debt) / SharesOutstanding = ( ( 249.4388 - 349.0446 ) / 9% + 2117.214 - 570.717 ) / 105.046 = 4.19

 Margin of Safety (EPV) = ( Earnings Power Value (EPV) - Current Price ) / Earnings Power Value (EPV) = ( 4.18641329283 - 59.06 ) / 4.18641329283 = -1310.75 %