OPTIMIZING RETURNS IN A CHALLENGING MARKET: AN APPLICATION OF THE MEAN-VARIANCE MODEL ON THE INDONESIAN LQ45 INDEX

Abstract

The rapid growth of retail investors in Indonesia, from 2.48 million in 2019 to over 20 million by 2025, underscores an urgent need for empirically grounded portfolio optimization frameworks adoptable into practical tools such as robo-advisory systems. This study applies the Markowitz Mean-Variance model to construct and evaluate an optimal stock portfolio from the LQ45 index over January 2022 to December 2025, a post-pandemic period characterized by predominantly adverse risk-adjusted returns. Using daily closing price data for 27 consistently listed LQ45 stocks (958 trading days) from the Indonesia Stock Exchange (IDX), with sample consistency verified through official BEI constituent evaluation announcements, this study constitutes an ex-post empirical analysis designed to isolate the mathematical efficacy of the Mean-Variance model under adverse market conditions. The analysis encompasses individual return and risk profiling, construction of a 27x27 covariance matrix, efficient frontier derivation via constrained quadratic optimization using Microsoft Excel Solver (GRG Nonlinear), and Sharpe ratio-based performance evaluation against a risk-free rate of 5.3281% per annum (average BI Rate 2022-2025). The core finding is that 19 of 27 sample stocks (70.4%) generated negative Sharpe ratios, confirming the inadequacy of undiversified single-stock strategies in adverse markets. In contrast, the tangency portfolio achieved a Sharpe ratio that materially surpasses all 27 individual stocks, establishing that quantitative portfolio optimization delivers superior risk-adjusted outcomes precisely when markets are most challenging. These results validate the enduring relevance of Modern Portfolio Theory in Indonesia's capital market and provide a transparent, replicable framework for investors and practitioners.