Get premium membership and access revision papers, questions with answers as well as video lessons.

Cms 205 Financial Computer Packages Question Paper

Cms 205 Financial Computer Packages

Course:Bachelor Of Commerce

Institution: Kca University question papers

Exam Year:2011

UNIVERSITY EXAMINATIONS: 2011/2012
YEAR 2 EXAMINATION FOR THE BACHELOR OF COMMERCE
CMS 205 FINANCIAL COMPUTER PACKAGES - SATURDAY
DATE: APRIL 2012 TIME: 2 HOURS
INSTRUCTIONS: Answer Question One and Any other Two Questions
QUESTION ONE
(a) Using appropriate examples explain the following terms:
i. Present Value Syntax (3 marks)
ii. Correlation Analysis (3 marks)
iii. Liquidity Ratios (3 marks)
iv. Profitability Ratios (3 marks)
v. Absolute cell referencing (3 marks)
(b) Describe three techniques that can be used to make a forecast in Microsoft Excel? (6 marks)
(c) Identify and briefly explain any five information types that a database file for a non current asset
may contain. (9 marks)
QUESTION TWO
The diagram below outlines a model of an organization’s Financial Information System (FIS) and its
external environment.
External
Parties
Internal
Parties FIS
2
i) Explain five vital services that FIS can provide to a business organization. (10 marks)
ii) The FIS interacts with the external and internal parties, Identify the stakeholders that interact
with the system and indicate whether they provide inputs, outputs (or both) across the FIS.
(10 marks)
QUESTION THREE
(a) Discuss how the following tools can be used by finance managers to aid them in making
decisions:
(i) Models (7 marks)
(ii) Information systems (7 marks)
(b) Explain the six main steps of formulating a linear programming model. (6 marks)
QUESTION FOUR
a) Suppose you request a loan of Kshs 300,000 over a period of 1 year of monthly payments at
an interest of 6% .
(i) Draw the amortization schedule for this problem. (6 marks)
(ii) Using the amortization schedule above write down the formulas used to get the contents of
Interest paid and beginning balance for subsequent periods. (4 marks)
b) Give five advantages and five disadvantages of financial computer packages compared to a
manual system. (10 marks)
QUESTION FIVE
(a) Identify six standing data and six variable data that you expect to be held in a receivable ledger.
(12 marks)
(b) State with appropriate examples the purpose of the following information system controls.
(i) Input controls
(ii) Processor controls (4 marks)
(c) Explain two non violent computer related crimes. (4 marks)

Cms 205 Financial Computer Packages Question Paper

More Question Papers

Popular Exams