Software Guide 2003

  Home Up Contents

Requirements
Creating a Universe
Creating a Template
Screening Function
Analysis Function
Copying and Pasting
Filtering Data
Data Settings
Database Coverage
Reporting Standards
Troubleshooting
List of Appendices

Appendix VII – Formulas

 You may access the Formula Descriptions within the software under <Help> in the Menu toolbar.  There are three levels of Formulas in your Personal Formula Library:

Financial Formulas and Ratios: contain the most commonly used formulas derived from items in the Financial Statements.

Stock Price Formulas and Ratios: contain the most commonly used formulas derived from stock prices (market valuations).

User-defined Formulas and Ratios: contain your own customized formulas, using your own definitions.

Assets Turnover:  Net Operating Revenues divided by Total Assets

BV/S:  Shareholders' Equity divided by the number of shares outstanding.

Curr. Liab/Tot. Liab:  Current Liabilities divided by Total Liabilities

Current Ratio:  Current Assets divided by Current Liabilities

Debt/Assets:  Total Debt divided by Total Assets

Debt/Equity:  Total Debt divided by Shareholders' Equity

Deposits/Revenues:  Total Deposits held divided by Revenues from Financial Operations

EBITDA:  Operating Income plus Interest deducted for the period, plus income taxes for the period, plus depreciation and amortization deducted for the period.

EPS:  Net Income for the preceding 12-month period divided by the number of shares outstanding.

Equity Turnover:  Net Operating Revenues divided by Shareholders' Equity

EV:  Enterprise Value = Market Capitalization plus short-term and long-term liabilities minus cash and short-term investments.

EV/EBITDA:  Enterprise Value divided by (Net Income plus Interest deducted for the period, plus income taxes for the period, plus depreciation and amortization deducted for the period).

Gross Margin:  Gross Income divided by Net Operating Revenues

Inventory Turnover:  Inventories divided by COGS (Cost of Goods Sold), then adjusted for the number of days in the period

Liabilities/Assets:  Total Liabilities divided by Toal Assets

Liabilities/Equity:  Total Liabilities divided by Shareholders' Equity

ST Debt/Equity:  Short-term Debt divided by Shareholders' Equity

LT Debt/Equity:  Long-term Debt divided by Shareholders' Equity

Net Margin:  Net Income divided by Net Operating Revenues

Operating Margin:  Operating Income divided by Net Operating Revenues

Payout:  Dividends paid in period divided by Net Income

P/BV:  Closing Price of stock divided by Shareholders' Equity per share

P/CF:  Closing Price of stock divided by Opearting Cash Flow per share

P/E:  Closing Price of stock divided by EPS

Quick Ratio:  (Current Assets minus Inventories) divided by Current Liabilities

Receivable Turnover:  Current Accounts Receivable divided by Net Operating Revenues, then adjusted for the number of days in the period

ROA:  Net Income divided by Total Assets

ROE:  Net Income divided by Shareholders' Equity

ROI subsidiaries:  Net Equity Income divided by Investments in Subsidiaries

Supplier Turnover:  Current Accounts Payable divided by COGS (Cost of Goods Sold), then adjusted for the number of days in the period

Total Margin:  Total Income divided by Net Operating Revenues

Working Capital:  Current Assets minus Current Liabilities

Yield:  Dividends paid per share in 12-month period divided by Closing Price of stock

 

 

Send mail to finasia@tej.com.tw with questions or comments about this web site.
Taiwan Economic Journal