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

Download 14
File Size 278.70 KB
File Count 1
Create Date 02/06/2025
Last Updated 02/06/2025

Download

Description

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

Author: Vivek Kumar Yadav
Institution: School of Business, Galgotias University
Program: MBA (2023–2025)
Date: May 2025

Abstract

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.

Previous

High-Performance AES Encryption Architecture on FPGA Using Pipelined Simulation and Adaptive NoC Routing

Next

Skin Disease Detection Using CNN

What is DOI

DOI:

A DOI will help Author(s) easily locate a document from your citation. Think of it like a Social Security number for the article you're citing — it will always refer to that article, and only that one. While a web address (URL) might change, the DOI will never change.

Where can i find DOI:

In IJSREM journal articles, the DOI will be printed with the article itself, usually on the footer of the page
If the DOI isn't included in the article, look it up on the website CrossRef.org (use the "Search Metadata" option) to check for an assigned DOI.

Benefits:

Allows for a quick and precise search.
Article can always be located.
Persistent link to its location on the Internet.
Easier identification of published articles even if the metadata URL is changed.
Aid in citation tracking, ensuring a researcher has accurate metrics on how and where their research outputs are being used or referenced.

Site Map

Terms and Conditions

Copyright Infragmentation

Publication Ethics

Editorial Board

Processing Fee's

Call for Papers

Publication Procedure

Research Topics

Frequently Asked Questions

What type of papers does International Journal of Scientific Research in Engineering and Management (IJSREM) publish?

Research Paper, Survey Paper, Informative Article, Case Studies, Review Papers, Comparative Studies

How long does it take for an accepted paper to be actually published?

Approximate will inform within 24 hours via email and sms.

What is the procedure to submit my paper?

Please Submit your Research Paper here Submit Research Paper Online - IJSREM

What is a Paper ID?

Paper ID is an Unique Identification Code provided to your submitted Manuscript. You should always mention the Paper ID during any communication with us.

How long my published paper will stay online?

Lifetime.

May I submit more than one article?

We will accept multiple submissions across multiple communities, as long as the author joins each community.

Why IJSREM?

IJSREM is one of the world's leading and fastest-growing research publications with the paramount objective of discovering advances by publishing insightful, double-blind, peer-reviewed scientific journals.

Publication Time Period

The Submitted Article/Paper will accept within 12-24 Hours, and it can publish within 24 Hours

Publication Procedure

Manuscript Submission - Check Manuscript Plagiarism - Send for Editorial Review - Final Decission to Author - Payment of Publication Fee - Re-screening - Final Publication

Processing Fee's

For Management, Hosting & Office Expenditure IJSREM Journal may charge some amount to publish the paper.

To Publish a Paper ₹: 800/- INR (without DOI)

₹:1000/- INR (with DOI)

To the extent possible under, Indospace Publications has waived all copyright and related or neighboring rights to Journal. This work is published from India.

Disclaimar Privacy Policy Terms and Conditions

Copyright © 2023. All Rights Reserved