Indian Listed Firms Database

A firm-level database covering financial statements, financial ratios, cash flows, ownership, quarterly information, market prices and other fundamentals for Indian listed firms. The database brings together information from multiple publicly available sources to facilitate empirical research on firms and markets.

12
Data Modules
6
Financial Statement
Modules
2
Ratio Modules
2
Market & Ownership
Sources

1. Financial Statements

Annual consolidated and standalone financial statement variables.

P&L — Consolidated

Annual consolidated income statement variables.

Source: Moneycontrol.com
Field
Revenue From Operations [Gross]
Less: Excise/Sevice Tax/Other Levies
Revenue From Operations [Net]
Total Operating Revenues
Other Income
Total Revenue
Cost Of Materials Consumed
Purchase Of Stock-In Trade
Operating And Direct Expenses
Changes In Inventories Of FG,WIP And Stock-In Trade
Employee Benefit Expenses
Finance Costs
Depreciation And Amortisation Expenses
Other Expenses
Total Expenses
Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax
Exceptional Items
Profit/Loss Before Tax
Tax Expenses-Continued Operations
Current Tax
Less: MAT Credit Entitlement
Deferred Tax
Other Direct Taxes
Total Tax Expenses
Profit/Loss After Tax And Before ExtraOrdinary Items
Profit/Loss From Continuing Operations
Profit/Loss For The Period
Minority Interest
Consolidated Profit/Loss After MI And Associates
Basic EPS (Rs.)
Diluted EPS (Rs.)
Equity Share Dividend

P&L — Standalone

Annual standalone income statement variables.

Source: Moneycontrol.com
Field
Revenue From Operations [Gross]
Less: Excise/Sevice Tax/Other Levies
Revenue From Operations [Net]
Total Operating Revenues
Other Income
Total Revenue
Cost Of Materials Consumed
Purchase Of Stock-In Trade
Operating And Direct Expenses
Changes In Inventories Of FG,WIP And Stock-In Trade
Employee Benefit Expenses
Finance Costs
Depreciation And Amortisation Expenses
Other Expenses
Total Expenses
Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax
Exceptional Items
Profit/Loss Before Tax
Tax Expenses-Continued Operations
Current Tax
Less: MAT Credit Entitlement
Deferred Tax
Tax For Earlier Years
Total Tax Expenses
Profit/Loss After Tax And Before ExtraOrdinary Items
Profit/Loss From Continuing Operations
Profit/Loss For The Period
Basic EPS (Rs.)
Diluted EPS (Rs.)
Equity Share Dividend
Equity Dividend Rate (%)

Balance Sheet — Consolidated

Annual consolidated balance sheet variables.

Source: Moneycontrol.com
Field
Equity Share Capital
Total Share Capital
Reserves and Surplus
Total Reserves and Surplus
Total Shareholders Funds
Minority Interest
Long Term Borrowings
Deferred Tax Liabilities [Net]
Other Long Term Liabilities
Long Term Provisions
Total Non-Current Liabilities
Short Term Borrowings
Trade Payables
Other Current Liabilities
Short Term Provisions
Total Current Liabilities
Total Capital And Liabilities
Tangible Assets
Intangible Assets
Capital Work-In-Progress
Fixed Assets
Non-Current Investments
Deferred Tax Assets [Net]
Long Term Loans And Advances
Other Non-Current Assets
Total Non-Current Assets
Current Investments
Inventories
Trade Receivables
Cash And Cash Equivalents
Short Term Loans And Advances
OtherCurrentAssets
Total Current Assets
Total Assets
Contingent Liabilities
Bonus Equity Share Capital

Balance Sheet — Standalone

Annual standalone balance sheet variables.

Source: Moneycontrol.com
Field
Equity Share Capital
Total Share Capital
Reserves and Surplus
Total Reserves and Surplus
Total Shareholders Funds
Long Term Borrowings
Deferred Tax Liabilities [Net]
Other Long Term Liabilities
Long Term Provisions
Total Non-Current Liabilities
Short Term Borrowings
Trade Payables
Other Current Liabilities
Short Term Provisions
Total Current Liabilities
Total Capital And Liabilities
Tangible Assets
Intangible Assets
Capital Work-In-Progress
Other Assets
Fixed Assets
Non-Current Investments
Deferred Tax Assets [Net]
Long Term Loans And Advances
Other Non-Current Assets
Total Non-Current Assets
Current Investments
Inventories
Trade Receivables
Cash And Cash Equivalents
Short Term Loans And Advances
OtherCurrentAssets
Total Current Assets
Total Assets
Contingent Liabilities
Bonus Equity Share Capital

Cash Flow — Consolidated

Annual consolidated cash flow variables.

Source: Moneycontrol.com
Field
Net Profit/Loss Before Extraordinary Items And Tax
Net CashFlow From Operating Activities
Net Cash Used In Investing Activities
Net Cash Used From Financing Activities
Foreign Exchange Gains / Losses
Adjustments On Amalgamation Merger Demerger Others
Net Inc/Dec In Cash And Cash Equivalents
Cash And Cash Equivalents Begin of Year
Cash And Cash Equivalents End Of Year

Cash Flow — Standalone

Annual standalone cash flow variables.

Source: Moneycontrol.com
Field
Net Profit/Loss Before Extraordinary Items And Tax
Net CashFlow From Operating Activities
Net Cash Used In Investing Activities
Net Cash Used From Financing Activities
Foreign Exchange Gains / Losses
Adjustments On Amalgamation Merger Demerger Others
Net Inc/Dec In Cash And Cash Equivalents
Cash And Cash Equivalents Begin of Year
Cash And Cash Equivalents End Of Year

2. Financial Ratios

Per-share, profitability, liquidity, coverage and valuation ratios.

Ratios — Consolidated

Annual financial ratios based on consolidated financial statements.

Source: Moneycontrol.com
Field
Basic EPS (Rs.)
Diluted EPS (Rs.)
Cash EPS (Rs.)
Book Value [ExclRevalReserve]/Share (Rs.)
Book Value [InclRevalReserve]/Share (Rs.)
Dividend / Share(Rs.)
Revenue from Operations/Share (Rs.)
PBDIT/Share (Rs.)
PBIT/Share (Rs.)
PBT/Share (Rs.)
Net Profit/Share (Rs.)
NP After MI And SOA / Share (Rs.)
PBDIT Margin (%)
PBIT Margin (%)
PBT Margin (%)
Net Profit Margin (%)
NP After MI And SOA Margin (%)
Return on Networth / Equity (%)
Return on Capital Employed (%)
Return on Assets (%)
Total Debt/Equity (X)
Asset Turnover Ratio (%)
Current Ratio (X)
Quick Ratio (X)
Inventory Turnover Ratio (X)
Dividend Payout Ratio (NP) (%)
Dividend Payout Ratio (CP) (%)
Earnings Retention Ratio (%)
Cash Earnings Retention Ratio (%)
Interest Coverage Ratios (%)
Interest Coverage Ratios (Post Tax) (%)
Enterprise Value (Cr.)
EV/Net Operating Revenue (X)
EV/EBITDA (X)
MarketCap/Net Operating Revenue (X)
Retention Ratios (%)
Price/BV (X)
Price/Net Operating Revenue
Earnings Yield

Ratios — Standalone

Annual financial ratios based on standalone financial statements.

Source: Moneycontrol.com
Field
Basic EPS (Rs.)
Diluted EPS (Rs.)
Cash EPS (Rs.)
Book Value [ExclRevalReserve]/Share (Rs.)
Book Value [InclRevalReserve]/Share (Rs.)
Dividend / Share(Rs.)
Revenue from Operations/Share (Rs.)
PBDIT/Share (Rs.)
PBIT/Share (Rs.)
PBT/Share (Rs.)
Net Profit/Share (Rs.)
PBDIT Margin (%)
PBIT Margin (%)
PBT Margin (%)
Net Profit Margin (%)
Return on Networth / Equity (%)
Return on Capital Employed (%)
Return on Assets (%)
Total Debt/Equity (X)
Asset Turnover Ratio (%)
Current Ratio (X)
Quick Ratio (X)
Inventory Turnover Ratio (X)
Dividend Payout Ratio (NP) (%)
Dividend Payout Ratio (CP) (%)
Earnings Retention Ratio (%)
Cash Earnings Retention Ratio (%)
Enterprise Value (Cr.)
EV/Net Operating Revenue (X)
EV/EBITDA (X)
MarketCap/Net Operating Revenue (X)
Retention Ratios (%)
Price/BV (X)
Price/Net Operating Revenue
Earnings Yield

3. Quarterly & Ownership Data

Quarterly financial information and shareholding variables.

P&L — Quarterly Consolidated

Quarterly consolidated income statement and ownership-related variables.

Source: Moneycontrol.com
Field
Net Sales/Income from operations
Other Operating Income
Total Income From Operations
Consumption of Raw Materials
Purchase of Traded Goods
Increase/Decrease in Stocks
Power & Fuel
Employees Cost
Depreciation
Excise Duty
Admin. And Selling Expenses
R & D Expenses
Provisions And Contingencies
Exp. Capitalised
Other Expenses
P/L Before Other Inc., Int., Excpt. Items & Tax
Other Income
P/L Before Int., Excpt. Items & Tax
Interest
P/L Before Exceptional Items & Tax
Exceptional Items
P/L Before Tax
Tax
P/L After Tax from Ordinary Activities
Prior Year Adjustments
Extra Ordinary Items
Net Profit/(Loss) For the Period
Minority Interest
Share Of P/L Of Associates
Net P/L After M.I & Associates
Equity Share Capital
Reserves Excluding Revaluation Reserves
Equity Dividend Rate (%)
EPS Before Extra Ordinary
Basic EPS
Diluted EPS
EPS After Extra Ordinary
Basic EPS.
Diluted EPS.
Public Share Holding
No Of Shares (Crores)
Share Holding (%)

Shareholding — Annual

Annual shareholding structure for Indian listed firms.

Source: screener.in
Field
Promoters+
FIIs+
DIIs+
Public+
No. of Shareholders
Detailed breakdown of promoter holding and large FII, DII and Public Holding

Shareholding — Quarterly

Quarterly shareholding structure for Indian listed firms.

Source: screener.in
Field
Promoters+
FIIs+
DIIs+
Public+
No. of Shareholders
Detailed breakdown of promoter holding and large FII, DII and Public Holding

4. Market Data

Weekly market prices and quarterly market fundamentals.

Weekly Price & Fundamentals

Weekly market prices, technical indicators and valuation measures, together with quarterly fundamental indicators.

Source: screener.in
Field
date
price
dma50
dma200
volume
pe_ratio
ev_ebitda
price_to_book
market_cap_to_sales
eps
ebitda
book_value
sales
gpm
opm
npm
quarter_sales

Data sources. The financial statement, ratio and quarterly income statement modules are sourced from Moneycontrol.com. The annual and quarterly shareholding modules and weekly price and fundamental data are sourced from Screener.in. The field names shown above follow the database field specification.