Practicing Success

Target Exam

CUET

Subject

Accountancy

Chapter

Use of Spreadsheet in Business Applications

Question:

Consider the following factor related to Computerised Accounting system.

(A) 'Nper' is the parameter in a financial function, which represents the total number of payments for the loan.
(B) The transaction is a record of inflow and outflow of resources.
(C) 'PV' is the parameter in financial functions which represent the past value of the loan.
(D) ACCRINT is one of the financial functions which is used to calculate the principal amount.
(E) A 'What if Scenario' is used to generate a number of alternatives to examine the cause (if) and effect (What)

Choose the correct answer from the options given below :

Options:

(A), (B), (E) only

(B), (C), (E) only

(C), (D), (E) only

(B), (D), (E) only

Correct Answer:

(A), (B), (E) only

Explanation:

The correct answer is Option (1) - (A), (B), (E) only.

(A) 'Nper' is the parameter in a financial function, which represents the total number of payments for the loan. It is True. 'Nper' typically represents the total number of payment periods in financial functions, such as in the case of calculating the number of periods for a loan.

(B) The transaction is a record of inflow and outflow of resources. It is true. A transaction is indeed a record of the exchange or transfer of resources, involving both inflow and outflow.

(C) 'PV' is the parameter in financial functions which represent the past value of the loan. It is False. 'PV' stands for present value, not past value. It represents the principal amount or the initial investment in financial functions.

(D) ACCRINT is one of the financial functions which is used to calculate the principal amount. It is False. ACCRINT is used to calculate the accrued interest on a bond between two interest payment dates. It is not used to calculate the principal amount.

(E) A 'What if Scenario' is used to generate a number of alternatives to examine the cause (if) and effect (What). It is True. A 'What if Scenario' is a technique used in analysis and decision-making to explore the potential outcomes of different courses of action and examine the cause-and-effect relationships.

So, the correct evaluations are (A) True, (B) True, (C) False, (D) False, and (E) True.