Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) (a1) What is the current value of this stock? (Round answer to 2 decimal places, eg. 15.20.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) (a1) What is the current value of this stock? (Round answer to 2 decimal places, eg. 15.20.) Current value eTextbook and Media Attempts: 1 of 3 used (a) The parts of this question must be completed in order. This part will be available when you complete the part above. Laura Hall is interested in buying the stock of Wildhorse, Inc, which is increasing its dividends at a constant rate of 6.8 percent. Last year the firm paid a dividend of $2.65. The required rate of return is 15.70 percent. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem) (a1) What is the current value of this stock? (Round onswer to 2 decimal places, es. 15.20)