Docstoc

Excel-Spreadsheet---Sense-&-Nonsense

Document Sample
Excel-Spreadsheet---Sense-&-Nonsense Powered By Docstoc
					RIO - COMPANHIA VALE ADS PROFITABILITY
One point is awarded for a positive return on assets ONE ROA=Net Income/Total Assets 49% Net Income Total Assets 6,293,000,000.00 12,730,000,000.00

One point is awarded for an improvement on return on assets over the last year TWO Change in ROA Net Income 83.07% Total Assets 24.77% One point awarded for a company where cash flow from operations exceed net income. THREE Cash Flow from Operations is Greater Than Income Operating Cash Flow Net Income OCF -cash flow from operations One point is awarded for a positive cash flow. FOUR Positive Cash Flow

LEVERAGE, LIQUIDITY, AND SOURCES OF FUNDS

One point is awarded if the measure of financial leverage - the ratio of total debt to total assets - declined in the past y FIVE Leverage (Debt Ratio = Total Debt/Total Assets) Leverage Change in Long Term Debt Total Assets 17,671,000,000.00

One point is also given if the current ratio (working assets or curent assets divided by current liabilities) increased ov SIX Liquidity Current Ratio = Current Assets/Current Liabilities Current Ratio Current Assets Current Liabilites

One point is given if the company has not issued any new shares in the current financial year SEVEN New Shares Issued

OPERATING EFFICIENCY
One point is awarded for an increase in gross margin. EIGHT Margins = Revenue-COGS/Revenue Margins Total Revenue CostOfGoodsSold

One point is given if asset turnover (total sales divided by total assets at the start of the financial year) has increased

NINE Asset Turnover Total Revenue Total Assets

Score
1

F SCORE 4
FIDO FINANCIALS Net income - Income Statement Total Assets - Balance Sheet Net Cash Flow - Cash Flow Change in LTD - Balance Sheet Current Assets - Balance Sheet Current Liabilities - Balance Sheet Total Revenue - Income Statement COGS - Income Statement Inventory Turnover - Income Statement

12/06 6,293,000,000.00 12,730,000,000.00

12/05 4,474,000,000.00 5,386,000,000.00

0

1 6,293,000,000.00 6,526,000,000.00

6,526,000,000.00

1

More Piotroski screen explanations Good interpretation here:

http://www.investorschronicle.co.uk/ResearchTools/default/article/20

t to total assets - declined in the past year. 12/06 12/05 21,555,000,000.00 3,884,000,000.00 12,730,000,000.00 5,386,000,000.00

0

ded by current liabilities) increased over the year. ent Assets/Current Liabilities 12/06 12/05 12,730,000,000.00 5,386,000,000.00 671,774,000,000.00 4,998,000,000.00

0

t financial year 12/06 4,832,386,000 12/05 4,606,080,000.00 0

1 12/06 12/05 21,222,000,000.00 14,564,000,000.00 8,915,000,000.00 6,359,000,000.00

art of the financial year) has increased during the year.

12/06 12/05 21,222,000,000.00 14,564,000,000.00 12,730,000,000.00 5,386,000,000.00

0

earchTools/default/article/20050324/7d7f63b4-e929-11db-9f1b-00144f2af8e8/14-a-year.jsp


				
DOCUMENT INFO
Shared By:
Tags: Excel, -Spre
Stats:
views:12
posted:11/28/2009
language:English
pages:5
Description: Excel-Spreadsheet---Sense-&-Nonsense