Esta sección se la dedico a @IBracero, que me ha ayudado mucho a configurar la base de análisis que hoy podéis descargar.
Existen multitud de formas de alcanzar los datos.. estas formulas son algunas de ellas.
PER = Stock price / Earning Per Share
Market Cap = Stock price * Basic Shares Outstanding
Gross profit $ = Total Revenue - Costs of goods sold
Gross profit % = Gross profit $ / Total revenue
EBITDA = Gross profit $ - Operative Expenses (Not counting Amortizations and Depreciations.
EBIT = EBITDA - (Amortizations and Depreciations)
Net Income = EBIT + Non-operative Income - Net Interest Expenses - Income Taxes Expense
EPS = Net Income / Basic Shares Outstanding
Free Cash-flow = Cash from operating activities - Capital expenditure
DPS (%) = DPS $ / Stock price
Net Debt = LT Debt + ST Debt + Current Portion of LT Debt - Ending Cash & C.Eq - ST Investments
Interest Rate On Debt = Net Interest Expenses / (LT Debt + ST Debt + Current Portion of LT Debt)
Debt ratio = (Total Assets - Total Equity) / Total Assets
Debt quality = Current Liabilities / (Current Liabilities + Non-Current Liabilities)
Debt / EBITDA = Net Debt / EBITDA
Repayment Capacity = Cash from operating activities / Current Liabilities
ROE = Net Income / Total Equity
ROA = EBIT / Total Assets
ROCE = EBIT / (Total Equity + Net Debt)
EBITDA Margin = EBITDA / Total Revenue
Net Margin = Net Income / Total Revenue
Payout = Dividends Distribution Costs / Net Income
Current Ratio = Current Assets / Current Liabilities
Quick Ratio = (Current Assets - Inventories) / Current liabilities