Question 14

0 / 4 points

1. Suppose an analysis used the following expression as the indicator for how current a loan is as of the reporting date. This approach gives the correct loanCurrency for which pairs of reporting and maturity dates: loanCurrency: [paymentsMade]/[numberPayments] (1) reporting date = maturity date (2) reporting date <> maturity date [<> means not equal to] (3) reporting date > maturity date (4) reporting date < maturity date

Question options:

1)

1 and 3

2)

1 and 4

3)

2 and 3

4)

2 and 4

Hide Feedback

Feedback: Because there are no adjustments for (1) the number of elapsed months as of the report date for loans still running or (2) advance payments, the expression only gives the correct loanCurrency when the reporting date is the same as the maturity date or the loan has matured.

Question 23

0 / 4 points

Suppose a query has the following expression, where pymtsForCurrent contains the number of payments for a loan to be current: loanCurrency: IIF([paymentsMade]/[pymtsForCurrent]>1,1,[paymentsMade]/[pymtsForCurrent]) The purpose of the value of the TRUEPART of the IIF statement is to set loanCurrency when:

Question options:

1)	the loan has been fully satisfied

2)	no loan payment has come due

3)	the loan is in arrears on payments

4)	extra payments have been made

Hide Feedback

Feedback:The purpose of the TRUEPART of the IIF statement is to set loanCurrency to 1 when extra payments have been made on the loan.

Please, find right answers, and you can see feedback. above answers are wrong