Scenario Manager Is One of the Tools Under ________ in the Forecast

question 58

Multiple Choice

Scenario Manager is one of the tools under ________ in the Forecast group on the Data tab.

• A)What-If Analysis
• B)Goal Seek
• C)Data Validation
• D)Data Table

---

Definitions:

IRR

Internal rate of return. A capital budgeting technique that rates projects according to their expected return on invested funds. The higher the return the better.

MIRR

Modified Internal Rate of Return (MIRR) is a financial metric that evaluates the profitability of investments, adjusting the internal rate of return (IRR) to account for the reinvestment of cash flows at a different rate.

Present Value

The current value of a future amount of money or stream of cash flows, discounted at a certain interest rate.

Future Value

The amount a present sum will grow into at a specified interest rate over a specified period of time.