I start with financial statements from Fidelity. Here is the Balance sheet for PWER:
Balance Sheet
| Item | 12/31/2010 | 9/30/2010 | 6/30/2010 | 3/31/2010 |
| Current Assets | ||||
| Cash and Short-Term Investments | 227.907 | 194.589 | 145.215 | 101.114 |
| Receivables | 270.526 | 211.011 | 137.949 | 123.252 |
| Inventories | 152.286 | 125.701 | 96.214 | 77.38 |
| Other Current Assests | 21.671 | 17.335 | 12.66 | 10.821 |
| Current Assets - Total | 672.39 | 548.636 | 392.038 | 312.567 |
| Long-Term Assets | ||||
| Property Plant and Equipment - Net | 63.325 | 56.539 | 47.29 | 47.312 |
| Other Assets Total | 26.097 | 23.983 | 25.361 | 26.009 |
| Goodwill | 0 | 0 | 0 | 0 |
| Assets - Total | 761.812 | 629.158 | 464.689 | 385.888 |
| Liabilities and Shareholders' Equity | ||||
| Q4 2010 | Q3 2010 | Q2 2010 | Q1 2010 | |
| 12/31/2010 | 9/30/2010 | 6/30/2010 | 3/31/2010 | |
| Current Liabilities | ||||
| Debt in Current Liabilities | 0.103 | 1.288 | 1.172 | 1.257 |
| Accounts Payable | 213.096 | 187.559 | 146.504 | 101.387 |
| Income Taxes Payable | 103.739 | 67.4 | 30.4 | 17.9 |
| Current Liabilities - Other | 67.888 | 40.947 | 30.982 | 31.638 |
| Current Liabilities - Total | 384.826 | 297.194 | 209.058 | 152.182 |
| Long-Term Liabilities | ||||
| Long-Term Debt | 35.911 | 38.387 | 72.636 | 73.174 |
| Liabilities - Other | 39.445 | 36.47 | 22.258 | 19.7 |
| Liabilities - Total | 460.182 | 372.051 | 303.952 | 245.056 |
| Minority Interest - Balance Sheet | 0 | 0 | 0 | 0 |
| Common Shares Outstanding | 103,924 | 103,924 | 88,589 | 88,370 |
Income Statement
| Item | 4 Quarters | Q4 2010 | Q3 2010 | Q2 2010 | Q1 2010 |
| Total Revenue | 1,047.1 | 366.2 | 314.0 | 214.5 | 152.4 |
| Cost of Goods Sold | 632.9 | 217.7 | 182.3 | 131.7 | 101.3 |
| Selling, General and Administrative Expenses | 111.0 | 32.6 | 28.2 | 26.8 | 23.4 |
| Operating Income Before Depreciation | 306.2 | 118.8 | 103.5 | 56.1 | 27.8 |
| Depreciation & Amortization | 14.8 | 3.0 | 3.0 | 3.8 | 5.0 |
| Operating Income After Depreciation | 291.4 | 115.8 | 100.5 | 52.3 | 22.8 |
| Interest and Related Expense | 6.7 | 1.4 | 1.2 | 2.0 | 2.0 |
| Nonoperating Income (Expense) | (0.7) | (0.3) | (2.5) | 1.1 | 0.9 |
| Special Items | (32.4) | (22.1) | - | (2.9) | (7.4) |
| Pretax Income | 251.5 | 92.0 | 96.8 | 48.4 | 14.3 |
| Income Taxes | 103.6 | 37.6 | 33.1 | 23.3 | 9.7 |
| Minority Interest - Income Account | - | - | - | - | - |
Calculation
| Op | Item | pwer |
| + | Operating Income After Depreciation | 291.36 |
| - | Minority Interest - Income Account | - |
| = | Income for Calculation | 291.36 |
| Diluted Shares Outstanding | 141.793 | |
| Share Price | 8.34 | |
| + | Market Cap Calc | 1,182.84 |
| + | Preferred Capital | 19.60 |
| + | Debt in Current Liabilities | 0.10 |
| + | Long-Term Debt | 35.91 |
| Cash and Short-Term Investments | 227.91 | |
| - | Excess Cash | 227.91 |
| = | Enterprise Value | 1,010.54 |
| + | Property Plant and Equipment - Net | 63.33 |
| + | Receivables | 270.53 |
| + | Inventories | 152.29 |
| + | Other Current Assests | 21.67 |
| + | Working Cash | - |
| - | Accounts Payable | 213.10 |
| - | Current Liabilities - Other | 67.89 |
| = | Invested Capital | 226.82 |
| Earnings Yield | 29% | |
| ROIC | 128% |
Working Cash
Working Cash = Max(0,[(AP + Current Liabilities Other) - (AR + Inventories + Other Current Assets)]
Excess Cash = Cash & ST Investments - Working Cash
3 comments:
In this example of PWER, the long term assets under "Other assets total" of 26.097 is not included in Invested Capital. Why is it excluded?
Hi marsh,
I am in the process of trying to replicate the magic formula- in the hope that i can run the screen and get a reasonable match with the MF website...once I am cobfident of this i will use the screen in Australia. I was wondering if you have run the formula in your blog through a dataset to see if you get a list of stocks that is comprable to the MF website. Thanks and regards. Nick
Hi marsh,
I am in the process of trying to replicate the magic formula- in the hope that i can run the screen and get a reasonable match with the MF website...once I am cobfident of this i will use the screen in Australia. I was wondering if you have run the formula in your blog through a dataset to see if you get a list of stocks that is comprable to the MF website. Thanks and regards. Nick
Post a Comment