JAH has been removed from your Stock Email Alerts list.
Please enter Portfolio Name for new portfolio.
The Net-Net Working Capital of First Solar Inc for the quarter that ended in Dec. 2016 was 6.57
In calculating the Net-Net Working Capital (NNWC), Benjamin Graham assumed that a companys 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 companys value.
|Net-Net Working Capital|
|=||(CashAndCashEquivalents||+||0.75 * Acct. Rec.||+||0.5 * Inventory||-||Total Liabilities||-||Preferred Stock)||/||Shares Outstanding|
|=||(1955.146||+||0.75 * 266.687||+||0.5 * 363.219||-||1654.526||-||0)||/||103.91|
For more information about NNWC, visit: Net-Net Working Capital
The Tangible Book Value per Share of First Solar Inc for the quarter that ended in Dec. 2016 was 49.18
|Tangible Book Value per Share|
|=||(Total Equity||-||Preferred Stock||-||Intangibles)||/||Shares Outstanding|
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.
For more information about tangible book value per share, visit: Tangible Book Value per Share
The Intrinsic Value: Projected FCF of First Solar Inc for today is 41.54
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.
In the case of negative total equity, the following formula is used (see the Total Equity section for the reason):
Here First Solar Inc' s FCF(6 year avg) is calculate asFirst Solar Inc Quarterly Data
First Solar Inc's Intrinsic Value: Projected FCF for today is calculated as
|=||(Growth Multiple||*||Free Cash Flow(6 year avg)||+||Total Equity(Dec16)||*||0.8)||/||Shares Outstanding|
First Solar Inc's Free Cash Flow Growth Multiple is 9.52035159596.
For more information about Intrinsic Value: Projected FCF, visit: Intrinsic Value: Projected FCF
The Median PS Value of First Solar Inc for today is 56.54
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.
PS Ratio (10y Median) is 1.98.
First Solar Inc's revenue per share for the trailing twelve months (TTM) ended in Dec. 2016 was 8.258(Mar. 2016) + 8.995(Jun. 2016) + 6.633(Sep. 2016) + 4.67(Dec. 2016) = 28.56.
For more information about median ps value, visit: Median PS 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.
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 Dec. 2016 was 1.66(Mar. 2016) + 0.13(Jun. 2016) + 1.49(Sep. 2016) + -6.78(Dec. 2016) = -3.5.
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.
For more information about Peter Lynch fair value, visit: Peter Lynch Fair Value
The Earnings Power Value (EPV) of First Solar Inc for the quarter ended in Dec. 2016 was -11.77.
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.
|Average of Last 20 Quarters||Last Quarter|
|Operating Margin %||-2.68|
|SGA * 25%||68|
|Tax Rate %||-0.69|
|Cash and Cash Equivalents||1,955|
|Shares Outstanding (Diluted)||103|
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 = -2.6825%
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 = 3319.9342Mil, Average Operating Margins = -2.6825%, Average Adjusted SGA = 67.7889,
therefore "normalized" EBIT = Sustainable Revenue * Average Operating Margins + Average Adjusted SGA = 3319.9342* -2.6825% +67.7889= -21.268334915Mil.
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 = -0.6865%, and "normalized" EBIT = -21.268334915Mil,
therefore After-tax "normalized" EBIT = "Normalized" EBIT * ( 1 - Average Tax Rate ) = -21.268334915* ( 1 - -0.6865% ) = -21.4143420342Mil.
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) = 246.3298* 0.5 * -0.6865% = -0.8455270385Mil.
"normalized" Earnings = After-tax "normalized" EBIT + Excess depreciation = -21.4143420342+ -0.8455270385= -22.2598690727Mil.
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 = 245.6927 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 =
First Solar Inc's current interest bearing debt = Long-Term Debt + Short-Term Debt = 160.422 + 27.966 = 188.388 Mil.
First Solar Inc's current diluted shares outstanding = 102.866Mil.
First Solar Inc's Earnings Power Value (EPV) for the quarter ended in Dec. 2016 was calculated as:
|EPV||=||( ( Norm. Earnings||-||Maint. CAPEX)||/||WACC||+||CashandEquiv||-||Int. Bearing Debt)||/||SharesOutstanding|
|=||( ( -22.2599||-||245.6927 )||/||9%||+||1955.146||-||188.388 )||/||102.866|
|Margin of Safety (EPV)||=||( Earnings Power Value (EPV)||-||Current Price )||/||Earnings Power Value (EPV)|
|=||( -11.767666357||-||28.99 )||/||-11.767666357|
For more information about EPV, visit: Earnings Power Value (EPV)