Get premium membership and access revision papers, questions with answers as well as video lessons.
Cms 205: Finance Computer Package (Saturday Class) Question Paper
Cms 205: Finance Computer Package (Saturday Class)
Course:Bachelor Of Commerce
Institution: Kca University question papers
Exam Year:2009
1
UNIVERSITY EXAMINATIONS: 2008/2009
SECOND YEAR STAGE II EXAMINATION FOR THE DEGREE OF
BACHELOR OF COMMERCE
CMS 205: FINANCE COMPUTER PACKAGE (SATURDAY CLASS)
DATE: AUGUST 2009 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a) Having successfully completed your BCom course a firm of financial analysts has engaged
you. Your first task is to develop a decision support system for a client that trades in bonds and
equities at the NSE.
i.) State FOUR benefits of using an already written package, as a systems development
strategy, for the task [4 marks]
ii.) Illustrate, using a financial forecasting, financial decision making or financial analysis
situation of your choice, the benefits of using a spreadsheet
b) Explain the difference between financial modeling, financial forecasting and financial analysis.
[6 marks]
c) Describe how you can use a spreadsheet in variance analysis [8 marks]
d) Explain TWO advantages of computer based financial modeling, analysis and forecasting
over paper and pencil methods [2 marks]
e) Enumerate FIVE evaluation points in the selection of a finance computer packages[5 marks]
2
QUESTION TWO
a) You have been approached by an NGO that specializes in business skills training, within the
SME sector to train their client employees on the use of computers for finance and accounting
tasks. You decide to use QuickBooks for the task
i.) Explain to the participants the role of forms lists and registers in quick books.
[6 marks]
ii.) Explain how quick books automate the process of recording of transactions [4 marks]
iii.) Describe any TWO methods that can be used to set up the company files [4 marks]
b) State FIVE benefits that an SME would derive from use of already written application
programs for finance tasks such as forecasting, modeling, analysis and record keeping
[5 marks]
c)
i.) Explain why it is recommended to back up your data when using a computer package
[4 marks]
ii.) Describe the procedure you can use to back up data in a finance package you are familiar
with. [2 marks]
QUESTION THREE
a) State the equivalent of Quick Books chart of accounts and customer: job lists in a manual
system of record keeping. [2 marks]
b) In addition to reports to external parties, finance computer packages generate several reports
analyzing day to day financial operations. Describe EIGHT types of internal management
reports that a package, you are familiar with can produce. [8 marks]
c) Define a spreadsheet function and explain its structure using suitable example from a financial
analysis scenario. [3 marks]
d) Using a suitable example, from a task in financial analysis, explain the difference between
absolute and relative cell references [4 marks]
e) List the types of Excel operators, in each of the following FOUR categories, and explain how
they can be used in financial analysis, forecasting and decision making.
(i) Arithmetic Operators
(ii) Logical Operators
(iii)Reference Operators
(iv) Text Operators [8 marks]
3
QUESTION FOUR
a) Describe FOUR reasons why it is advantageous to outsource during the implementation of a
financial information system (4 marks)
b) State the output of each of the FIVE stages of the SDLC (5 marks)
c) Describe the following alternative systems development strategies
(i) Prototyping
(ii) End user development
(iii) Systems development life cycle
(iv) Rapid application development
(v) Object oriented development [10 marks]
d) State, with reasons, the systems development strategies that would be suited for developing an
information system, to support managerial tasks of financial forecasting, analysis, and decision
making, for each of the following firms
i) A large organization that has branches countrywide, in every district and deals in the
manufacturing distribution of fast moving consumer goods
ii) A large multinational firm with operations in several country keen on using internet
infrastructure to coordinate its operations
iii) A fast growing professional practice of accountants that serves several professional
partnership firms in a the finance and investment services sector
iv) A small law firm that just started operations in June 2009 that has no experience with a
computer based information system. [4 marks]
More Question Papers
Popular Exams
Return to Question Papers