PR $13-5($LO $13\mathrm{.}5)$ The following heat map results from a sensitivity$.-$

$[$The following information applies to the questions displayed below$]$

The following heat map results from a sensitivity analysis that might be performed by financial analysts. It evaluates the two most important inputs to determine the estimated stock price:

$(1)$ the cost of capital and

$(2)$ sales growth in the future.

Sales growth varles from $1$ percent to $10$ percent $($as shown in the columns$),$ and the cost of capital varles from $4$ percent to $14$ percent $($as shown in the rows$).$ The colored columns are the estimated stock prices based on the changing input parameters.

Heat Map: Sensitivity Analysis Examining Changes in Variable Cost per Unit and Units Sold on Profitability

Microsoff Excel

Required a$.-$ e$.$

Required:

Refer to the heat map to answer the following questions.

Search