Return to search

Development of a database for listed companies on the Botswana Stock Exchange

Thesis (MBA)--Stellenbosch University, 2001. / A database on South African industrial companies listed on the Johannesburg Stock
Exchange called FIN01 was created by the Graduate School of Business (USB),
University of Stellenbosch, to capture the various companies' financial data from 1970 to
date. FIN01 database is being updated to capture financial data of listed companies
from other African countries. Against the background, the purpose of the study project
was to update the University database (FIN01) by creating a database for listed
Botswana Stock Exchange companies. The creation of the database required gathering
and analysis of information of the various Botswana companies. Before the information
from the Annual Reports could be captured into the main database, it was captured into
Excel created spreadsheets. This information was captured under the respective
workbooks as created for the cash flow statements, income statements and balance
sheet items.
To conform to the requirements of the FIN 01 database, the Botswana companies were
allocated codes. The summarised data was then transferred to the main USB database
(FIN01). A thorough analysis on performance of the various companies was then carried
out. This was done through trend analysis, common size analysis and ratio analysis.
Problems were encountered during the process of data capturing and analysis. These
included unavailability of Annual Reports, various different reporting formats and the
standard Excel spreadsheets provided. The various companies' inconsistency in
reporting was further reflected in the non-reporting of turnover and share prices by most
of the listed companies.
However, the creation and incorporation of the listed Botswana companies was a
success. It is recommended that the project be continued as an ongoing process. The
information should be updated on a yearly basis. Companies should be encouraged to
continue sending the Annual Reports to the University. The companies should in return
get regular feedback on key performance indicators as reflected in the database.

Identiferoai:union.ndltd.org:netd.ac.za/oai:union.ndltd.org:sun/oai:scholar.sun.ac.za:10019.1/52187
Date12 1900
CreatorsMasole, Mothusi
ContributorsHamman, W. D., Stellenbosch University. Faculty of Economic & Management Sciences. Graduate School of Business.
PublisherStellenbosch : Stellenbosch University
Source SetsSouth African National ETD Portal
Languageen_ZA
Detected LanguageEnglish
TypeThesis
Format78 p.
RightsStellenbosch University

Page generated in 0.0026 seconds