CALL FOR PROPOSAL
CALL FOR PROPOSAL
Details on the Proposal
II. Indonesian Stock Exchange (IDX) Overview
The IDX Composite Index (Jakarta Composite Index - JCI / Indeks Harga Saham Gabungan - IHSG) includes all publicly traded stocks on the Indonesian Stock Exchange.
These stocks will be collectively referred to as "Indo Stocks."
III. Index Membership Tracking
Each Indo Stock should be categorized based on its inclusion in the following indices:
LQ45 – Top 45 most liquid and actively traded stocks with large market capitalizations.
IDX30 – Subset of LQ45, tracking the 30 most liquid stocks with strong fundamentals.
IDX80 – Broader index covering the 80 most liquid stocks.
Kompas100 – Curated list of 100 highly liquid stocks by IDX and Kompas daily.
IDX Small-Mid Cap (SMC) Composite – Tracks small- and mid-cap companies, excluding large caps.
IDX Small Cap (IDX SMC Liquid) – Focuses on small-cap companies with high liquidity.
IDX High Dividend 20 – Represents 20 companies with high and consistent dividend yields.
IDX Basic Materials – Includes companies in mining, agriculture, and raw materials.
IDX Finance – Covers banks, insurance, and financial institutions.
IDX Energy – Tracks oil, gas, and renewable energy companies.
IDX Healthcare – Includes healthcare providers and pharmaceutical firms.
IDX Infrastructure – Covers construction, telecom, and transportation.
IDX Technology – Focuses on tech companies and digital innovation.
IV. Financial Data Collection Requirements
For each company, collect and analyze the following financial metrics:
1. Profitability Ratios
Return on Assets (ROA) = Net Income / Total Assets
Return on Equity (ROE) = Net Income / Shareholders' Equity
Return on Invested Capital (ROIC) = NOPAT / Invested Capital
Gross Profit Margin = (Revenue - Cost of Goods Sold) / Revenue
2. Efficiency & Productivity Ratios
Asset Turnover = Revenue / Total Assets
Inventory Turnover = Cost of Goods Sold / Average Inventory
Days Sales Outstanding (DSO) = (Accounts Receivable / Revenue) × 365
Operating Efficiency Ratio = Operating Expenses / Revenue
3. Liquidity & Cash Flow Metrics
Current Ratio = Current Assets / Current Liabilities
Quick Ratio = (Current Assets - Inventory) / Current Liabilities
Operating Cash Flow / Total Debt
4. Value Creation & Shareholder Returns
Earnings Per Share (EPS) = Net Income / Total Shares Outstanding
Economic Value Added (EVA) = NOPAT - (Capital Employed × Cost of Capital)
Market Value Added (MVA) = Market Capitalization - Invested Capital
Total Shareholder Return (TSR) = (Capital Gains + Dividends) / Initial Share Price
5. Cost Control & Operational Performance
Operating Margin = Operating Profit / Revenue
Cost-to-Revenue Ratio = Total Costs / Revenue
Break-even Analysis = Fixed Costs / Contribution Margin per Unit
6. Growth & Competitive Positioning
Revenue Growth Rate = (Current Revenue - Previous Revenue) / Previous Revenue
Market Share = Company Revenue / Total Industry Revenue
Customer Acquisition Cost (CAC) vs. Customer Lifetime Value (CLV)
7. Governance & Risk Management
Debt-to-Equity Ratio = Total Debt / Shareholders’ Equity
Interest Coverage Ratio = EBIT / Interest Expense
Free Cash Flow (FCF) = Operating Cash Flow - Capital Expenditures
Submission Requirements
Proposals should include:
Data sources: List of APIs or platforms to be used (Yahoo Finance, Bloomberg, IDX official data, etc.).
Delivery format: All company data must be compiled into a single Excel file, formatted as per Exhibit A.
Project timeline: Expected duration to compile the requested data.
Cost estimate: Pricing structure for data collection and delivery.
Please submit to admin@levenstein.net no later than March 1st, 2025. We look forward to your proposal.
Project Overview:
"Ugly Duckling" Competition
Purpose:
Conduct a study on underappreciated companies listed on the Indonesian Stock Exchange (IDX).
Availability:
The study will be published after our meeting to generate competitive interest among corporations attending the Nicholas Levenstein dan Rekan 2025 Indonesian Equity Conference.
Additionally, for graphing and data analysis, all companies should be included in a single Excel file, formatted as shown in Exhibit A.