Question

EXCEL 3: CHAPTER 7 x Get Homework Help With Che X → C newconnect.mheducation.com/flow/connect.html EXCEL 3: CHAPTER 7 A Saved Help Save & Exit Submit ? X - Sign In 05. Calculating stock price - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW * Calibri 111 SAA = % 1 DP Paste B I U- - - A. Alignment Number Conditional Format as Cell Formatting Table Styles Clipboard Font H Cells Editing eBook Styles A1 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 dividend 10 years from today and will increase the dividend by 3.9 percent per year thereafter. If the required return on this stock is 12.5 percent, what is the current share price? 14.00 10 Future dividend Years until first dividend Dividend growth rate Required return 3.9% 12.5% Complete the following analysis. Do not hard code values in your calculations. Stark nrira in a voare S 162 70 Graw < Prey 6 of 6 Next >
I have the answers I just don't know how to input the answers into a formula in the excel solver so that it can accept my answers. Thank you.

Answer 1

A B E F $14.00 10 Future dividend Years until first dividend Dividend growth rate Required return 3.90% 12.50% Stock price in 9 years 162.79 Stock price today $56.40

B E Future dividend Years until first dividend Dividend growth rate Required return 10 0.039 0.125 Stock price in 9 years =D6/(D9-08) Stock price today --PV(D9,D7-1,,D14)