Which of the Following Functions Should Be Used to Evaluate

question 82

Multiple Choice

Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes?

• A)AND
• B)DSUM
• C)IF
• D)DMAX

---

Definitions:

Capital Cost Allowance (CCA)

A tax deduction in Canada that represents a yearly depreciation charge for the cost of assets.

After-Tax Cost Savings

The reduction in expenses that result from deductions on taxes, essentially the net savings after accounting for tax effects.

Salvage Value

The estimated value at which an asset can be sold at the end of its useful life.

Discount Rate

The interest rate used to discount future cash flows to their present value, crucial in calculating the net present value (NPV) of an investment.