Which What-If Analysis Tool Is Best to Determine the Optimal

question 55

Multiple Choice

Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?

• A)Goal Seek
• B)Solver
• C)Scenario Manager
• D)Two-variable Data Table

---

Definitions:

Capital Gains Yield

The percentage change in the price of an investment over a specified period, not accounting for dividends or other earnings.

Yield to Call

The return an investor would receive if a callable bond is held until the issuer exercises the call option.

Par Value

The nominal or face value of a bond, share of stock, or coupon as stated by the issuer.

Coupon Rate

The interest rate stipulated on a bond or fixed-income security that the issuer pays to the holders periodically until maturity.