(LO 9-6) This exhibit provides an example of a sensitivity analysis that might be performed by financial...

Question:

(LO 9-6) This exhibit provides an example of a sensitivity analysis that might be performed by financial analysts. In their estimation, the two most important inputs to determine the estimated stock price is the cost of capital and sales growth in the future. To perform sensitivity analysis, they vary sales growth from 1 to 10 percent (as shown in the columns) and the cost of capital from 4 to 14 percent (as shown in the rows). The colored columns are the estimated stock prices based on the changing input parameters. When combined with conditional formatting, the estimated stock price can also be evaluated in a visual way.

image text in transcribed

Required:
1. As the cost of capital increases, what happens to the estimated stock price?
2. As the sales growth decreases, what happens to the estimated stock price?
3. If the sales growth is 4 percent, and the cost of capital is 14 percent, what is the estimated stock price?
4. If the sales growth is 10 percent, and the cost of capital is 10 percent, what is the estimated stock price?
5. Which is more impactful on stock price, a 1 percent increase in sales growth or a 1 percent increase in cost of capital?
6. How does conditional formatting help you to visualize the impact of these two important inputs on estimated stock price?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Data Analytics For Accounting

ISBN: 9781266358234

2nd Edition

Authors: Vernon Richardson, Katie Terrell And Ryan Teeter

Question Posted: