please include excel formulas

AutoSave Of H2 General Chapter 7 Homework (2) - Excel felicia chesnut FC X File Home Insert Page Layout Formulas Data Review View Developer My Silly Tab Help Search Share Comments Calibri 11 - 2 General LG - 2 Wrap Text 2 Merge Center Paste YO Sort & Find & Filter Select BIU- % A $ Insert Delete- Format Cells ob Ideas Conditional Format as Le Formatting Table Styles Styles Clipboard y Font Alignment Number tarting Ideas Sensitivity 85 1 K L M D E 7.15 Nonconstant Growth Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock over the next nine years, because the firm needs to plow back its earnings to fuel growth. The company will then pay a dividend of $19 per share 10 years from today and will increase the dividend by 5 percent per year thereafter. If the 1 required return on this stock is 13 percent, what is the current share price? 3 First Dividend Year for First Dividend Dividend Growth Rate Required Return 6 Share Price 7 8 9 10 13 14 15 16 Problem 7.02 Problem 7.03 Problem 7.07 Problem 7.14 Problem 7.15 Problem 7.16 + Ready d 11576 E Type here to search O W P 12:35 AM 12/5/2020