Erryka Yusnita Rahmadani
Unknown Affiliation

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

The Design Of A Microsoft Excel-Based Financial Distress Prediction Tool As A Basis For Credit Decision-Making By Creditors Erryka Yusnita Rahmadani; Tojibussabirin, Muhammad
Reviu Akuntansi, Keuangan, dan Sistem Informasi Vol. 4 No. 4 (2025): REAKSI
Publisher : Fakultas Ekonomi dan Bisnis Universitas Brawijaya

Show Abstract | Download Original | Original Source | Check in Google Scholar

Abstract

This study aims to design a Microsoft Excel-based financial distress prediction tool that can be used as a basis for credit decision-making by creditors. The tool is equipped with Visual Basic for Applications (VBA) to enhance its functionality and ease of use. Financial distress prediction serves as an early warning system to assess prospective debtors’ ability to meet their financial obligations before credit is granted. The tool incorporates several financial distress analysis models, namely the Grover model and the Zmijewski model. The study was conducted on LQ45 index companies listed on the Indonesia Stock Exchange in 2020 (pre-COVID-19) and in 2023 (post-pandemic). The results show that the developed prediction tool is capable of providing comprehensive, informative, and easily accessible financial analysis through a simple user interface. The tool is expected to assist creditors in conducting more accurate and objective financial analyses, thereby minimizing the risk of default.