Prediction of Financial Ratios Based on BSE Top 10 Companies: An Excel and VBA-Based Approach

This study explores the predictive potential of key financial ratios for the top 10 companies listed on the Bombay Stock Exchange (BSE) using historical financial data (FY 2022–2024). Utilizing Excel and VBA for automation, key ratios—such as P/E, P/B, ROE, EPS, Current Ratio, and Debt-to-Equity—are computed, analysed, and forecasted using regression models. The study demonstrates that financial ratios serve as effective tools for evaluating corporate performance, guiding investment decisions, and supporting strategic financial planning. Despite certain limitations, the model proves useful for short-term forecasting and provides a replicable framework for further research and practical application.