Date/ Time |
Schedule |
Topic(s) |
Presenter(s) |
Location |
Friday 30/10/2015 09h00 – 12h00
|
Workshop |
Using VBA programing in Excel to extract data from annual reports |
Ngo Minh Hai,SoB/UEH |
Room B.125, 279 Nguyen Tri Phuong, Dist. 10, HCMC |
Presentation |
Management Control Systems, Reward Systems, and Performance in a Transitional Economy |
Dr. Nguyen Thi Thu FAA, UEH |
1. Session 1:
Workshop:
Using VBA programing in Excel to extract data from annual reports
Presenter: Minh Hai Ngo,School of Banking, UEH1,
Language: Vietnamese
Abstract:
Macro in Excel in general or Visual Basic Assembly programing in particular is an useful tool to extract variables from raw data such as annual reports and other Excel-format financial documents. Not as complicated as it seems to be, VBAs and macros can be easily learned, created and modified to match different needs.The workshop will guide every beginner with basic Excel knowledge on how to record an macro,understanding the fundamental VBA commands to extract data and creating a loop. A sample data and VBA codes are enclosed to guarantee that every participant will be able to convert any financial report into Stata/ SPSS-friendly long-format database. With VBAs, thousands of annual reports can be converted, merged into one data file for later processing in no more than 10 seconds.
1 https://de.linkedin.com/in/ngominhhai
Currently working as a senior lecturer at UEH and as Ph.D candidate in field of Behavioral Finance. His papers were presented at conferences in Nottingham, England; Chicago, USA (Best PhD student paper award); Beijing, China; Prague, Czech Rep.,Singapore and others. The plan for graduation is by the end of 2015.
Outside academia, his practical job is to work as managing partner (co-founder) at PVNi, a venture fund with the aim to support the start-ups in Vietnam and to build a professional network for investors & entrepreneurs. The current portfolios are MyProClub (www.myproclub.com), Beanies’ Crepes & Waffles (www.beanies.vn), CloudWare (www.cloudware.vn) and other consulting services in field of corporate financial governance.
2. Session 2:
Presentation:
Management Control Systems, Reward Systems, and Performance in a Transitional Economy
Authors:
Thi Thu Nguyen (corresponding author) University of Economics Ho Chi Minh City 279 Nguyen Tri Phuong, District 10 Ho Chi Minh City, Vietnam, thithun@ueh.edu.vn
Lokman Mia Griffith University Nathan, QLD 4011, Australia l.mia@griffith.edu.au
Allen Huang Griffith University Nathan, QLD 4011, Australia a.huang@griffith.edu.au
Presenter: Dr. Thi Thu Nguyen2
School of Accounting, University of Economics, HCMC
Language: English
Abstract:
Purpose. This study investigates the role of managers’ use of information provided by their firm’s management control systems (MCS) in the relationship between reward systems and performance in the context of Vietnam, a transitional economy. This is done by incorporating the effects of enterprise ownership types (state ownership, private ownership, and foreign ownership).
Methodology. Department managers in state-owned enterprises (SOEs), privately owned enterprises (POEs), and foreign-owned enterprises (FOEs) in Vietnam participated in the study. Data for the study were analyzed using a Partial Least Square (PLS) regression model.
Findings. The results reveal that managers’ reward systems are associated with their performance directly and indirectly via managers’ use of the information provided by MCS. However, the results by ownership type reveal that while the direct relationship between reward system and performance exists in firms under each of the three ownership types, the indirect relationship via managers’ use of MCS information does not exist in the case of SOEs.
Originality/value. The study contributes to existing knowledge on how managerial use of MCS information affects the relationship between reward systems and managers’ performance in SOEs, POEs, and FOEs in Vietnam.
Keywords. Enterprise ownership, MCS information, performance, reward systems, transitional economy
2 http://faa.ueh.edu.vn/giang-vien/thunt
Dr. Nguyen Thi Thu graduated her PhD in field of Accounting from University of Griffith, Australia. Her research interests are management control system, the use of management accounting information, leadership style, ownership type, managerial performance, and reward system. Her papers were presented in various interntional conferences in Kobe, Japan, Newcastle, UK and Gold Coast, Australia and were on processing to publish on Journal of Management Accounting Research and Accounting, Auditing & Accountability Journal.
Seminar materials (copy and paste the following link into address bar to download):
https://drive.google.com/folderview?id=0B3PYl1h7tBESbnhoWjN5cEI3Rzg&usp=sharing