________ Is a Simulation Model, Often Constructed Using Excel, Which

question 31

Multiple Choice

________ is a simulation model, often constructed using Excel, which calculates the relationships between many variables; users can change some variables to see how others are affected.

• A)Goal-seeking analysis
• B)What-if analysis
• C)Market basket analysis
• D)Data aggregation

---

Definitions:

Compounded Annually

A method of calculating interest where the interest earned each year is added to the principal, leading to an increase in the amount of interest earned in subsequent years.

Present Value

The current worth of a future sum of money or stream of cash flows given a specified rate of return, used in discounting and investment appraisal.

Annuity

A fiscal tool that disburses a set sequence of payments to a person, frequently serving as a financial income for retirees.

Equal Payments

Regular payments of the same amount, typically used in the context of loans or amortization schedules.