21.30. Stock Valuation Analysis in Excel: Using an Excel spreadsheet, please complete the calculations for this stock valuation problem. Please then submit your Excel worksheet with your Exam. Current dividend per share: $1.05 Expected annual dividend growth rates in Years 1-5: Year: 1 2 3 4 5 Annual Dividend Growth Rate: 9.0% 8.5% 8.1% 7.5% 7.1% After year 5, the dividend's annual growth rate expected to be a constant: 5.0% Cost of equity capital for the firm (rs): 9.0% I Given the above information, please calculate the value per share for this stock