E '3' C" i' = Calculating stockprice-Excel ? E X HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In\" E I HE E? E3 Alignment Number Conditional Format as Cell Cells Editing . . Formatting ' Table ' Styles ' . . Clipboard G Font ii Styles A In vl AI . A C D E F G H I J K 1 I 2 Estes Park Corp. pays a constant $7.80 dividend on its stock. The company will maintain this 3 dividend for the next 13 years and will then cease paying dividends forever. If the required return on this stock is 11.2 percent, what is the current share price? 4 5 6 Current dividend $ 7 Years until dividend ceases 8 Required return 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 Share price 14 B '3' C" 3' = Preferredstock-Excel ? E X HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In H E I E3? E? Alignment Number conditional Format as Cell Cells Editing 1 v Formatting ' Table ' Styles ' v . Clipboard ii Font ii Styles A IAI ~| ~ El . A C D E F G H I J K . 1 I 2 3 Moraine, Inc., has an issue of preferred stock outstanding that pays a $3.50 dividend every year in perpetuity. If this issue currently sells for $85 per share, what is the required return? 4 5 6 Annual dividend 7 Current price 8 9 10 Complete the following analysis. Do not hard code values in your calculations. 11 12 Required return 13 14 15