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.