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.

This competition is in collaboration with: