Which of the Following Tools Is Used to Create Decision

question 15

Multiple Choice

Which of the following tools is used to create decision trees in Excel?

• A)WhatIf
• B)Analytic Solver Platform
• C)GoalSeek
• D)Data Analysis

---

Definitions:

Required Rate

Often referred to as the discount rate or required rate of return, it is the minimum return an investor expects to receive for investing in a project or business.

Net Present Value

A method of evaluating the attractiveness of an investment project, by determining the present value of its expected future cash flows minus the initial investment.

Net Present Value

Net Present Value (NPV) is a financial metric used to evaluate the profitability of an investment or project, calculating the difference between the present value of cash inflows and the present value of cash outflows over time.

Discount Rate

The interest rate used to discount future cash flows of a financial instrument to present value.