Please solve the problem using Excel and attach pictures.

Integrative: Risk and valuation Hamlin Steel Company wishes to determine the value of Craft Foundry, a firm that it is considering acquiring for cash. Hamlin wishes to determine the applicable discount rate to use as an input to the constant- growth valuation model. Craft's stock is not publicly traded. After studying the required returns of firms similar to Craft that are publicly traded, Hamlin believes that an appropriate risk premium on Craft stock is about 9%. The risk-free rate is currently 5%. Craft's dividend per share for each of the past 6 years is shown in the following table. P7-24 Year 2019 2018 2017 2016 2015 2014 Dividend per share $3.44 3.28 3.15 2.90 2.75 2.45 a. Given that Craft is expected to pay a dividend of $3.68 next year, determine the maximum cash price that Hamlin should pay for each share of Craft. b. Describe the effect on the resulting value of Craft of (1) A decrease in its dividend growth rate of 2% from that exhibited over the 2014-2019 period. (2) A decrease in its risk premium to 4%