Get premium membership and access revision papers, questions with answers as well as video lessons.
Finance Computer Packages Question Paper
Finance Computer Packages
Course:Bachelor Of Commerce
Institution: Kca University question papers
Exam Year:2011
1
UNIVERSITY EXAMINATIONS: 2010/2011
SECOND YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
COMMERCE
CMS 205 FINANCE COMPUTER PACKAGES
DATE: DECEMBER2011 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any Other Two Questions
QUESTION ONE
The following are brief stories of actual employee thefts and embezzlements perpetrated using
computers.
Required:
What kind of control procedures were missing or inoperative that might have prevented or detected
the fraud?
a) The university computer system was entered. Vandals changed many students’ first name to
“Susan,” student telephone numbers were changed to the number of the university president,
grade point averages were modified, and some academic files were deleted completely
(4 Marks)
b) A computer operator at a state-run horse race betting agency set the computer clock back three
minutes. After the race was won, he quickly telephoned bets to his girlfriend, an input clerk at
the agency, gave her the winning horse and the bet amount, and won every time!
(4 Marks)
2
c) Your company has installed and used a computer system for processing a portion of its
accounting data. The following output computer files are produced in the daily processing
runs:
1. Cash disbursements sequenced by check number
2. Outstanding payable balances (alphabetized)
3. Purchase journal arranged by (a) account charged and (b) vendor
Company records, as described above, are maintained on magnetic tapes. All tapes
are stored in a restricted area within the computer room. A grandfather-father-son
policy is followed in retaining and safeguarding tape files
Vouchers (with supporting invoices, receiving reports, and purchase order copies)
are filed by vendor code. Another purchase order copy and the checks are filed
numerically.
Required:
a. Explain the grandfather-father-son policy. Describe how files could be
reconstructed when this policy is used (4 Marks)
b. Discuss whether company policies for retaining and safeguarding the tape files
provide adequate protection against losses of data. (4 Marks)
d) The two major ways a company obtains a computer system are developing one from scratch
and the other is buying one off-the-shelve. Discuss each process in detail (6 Marks)
e) Explain the at least three major financial forecasting techniques (4 Marks)
f) Explain the ERP implementation process, its controls and its security. (4 Marks)
Question Two
a) You can track your expenses in QuickBooks using either the checkbook or the bill-to-pay list
methods. Explain the differences between the two methods and how each affects the record
keeping and profit-calculation precision (10 Marks)
b) In populating the QuickBooks lists, explain how you add new vendors, new customers and jobs
(5 Marks)
3
c) Describe two categories of reports you can access in QuickBooks. How do you print the profit
& loss standard report and the inventory by vendor? (5 Marks)
QUESTION THREE
a) State and explain the major software applications involved in the procure-to-pay process
(6 Marks)
b) Discuss the major modules (software applications) involved in the order-to-cash process
(6 Marks)
c) Discuss the systems development life cycle (SDLC), including the internal system controls
(8 Marks)
QUESTION FOUR
The following selected amounts were extracted from financial statements of XYZ Ltd:
Year 1 Year 2 Year 3 Year 4
Sales 600,000 600,000 600,000 600,000
Gross Margin 400,000 436,000 448,000 464,000
Net Income 100,000 108,000 111,000 113,000
Required (round all answers to the nearest tenth of one percent):
a) Prepare a trend analysis for each of the above item using Year 1 as the base year (6 Marks)
b) For each of the above items:
1. Calculate the percentage change from Year 1 to Year 2 (2 Marks)
2. Calculate the percentage change from Year 2 to Year 3 (2 Marks)
c) For each of the four years, compute the percentage relationship of gross margin to sales and
the relationship of net income to sales (6 Marks)
d) Identify which requirement(s) above involves:
1. Horizontal analysis (2 Marks)
2. Vertical analysis (2 Marks)
4
QUESTION FIVE
You are given the following marks for students taking Finance Computer Packages:
ID Asg1 Asg2 Cat1 Cat2 Exam
10001 4 3 4 8 32
10002 4 5 6 7 50
10003 3 3 7 6 43
10004 3 4 5 5 30
10005 2 5 6 4 21
a) Explain how you use Excel to calculate the coursework marks (assignments plus cats) and the
total of coursework and exam. (Do not do it manually) (5 Marks)
b) Explain how you use Excel and its “IF…Then” formula to award grades to those student and
indicate the grades awarded. (5 Marks)
c) Explain the objectives of the following accounting information systems:
1. Financial accounting information system
2. Managerial accounting information system
3. Budgetary system
4. Inventory system
5. Accounts payable system
(10 Marks)
More Question Papers
Popular Exams
Return to Question Papers