Question

? X - Sign In FILE HOME Arial Calculating stock price - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW -12 = % p U . - A - Alignment Number conditional Format Cell Formatting as Table Styles Font Styles A À Paste B I Cells Editing Clipboard D16 А в D E F G H I J 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 pay a \$14 per share 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. Stock price in 9 years \$ 162.79 Stock price today Sheet1 READY @ - H + 100% Attempt(s) 1/3 Hint Step: If no dividends are paid in the interim, the stock price today is the present value of the future stock price.

=PV(D9,D7-1,,-D14)

source: I failed the same question and this is the correct answer given.

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### ? X Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT...

? X Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Arial -12 A À Paste B IU B A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Editing Clipboard Font D16 д в E F G H K 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...

• ### I have the answers I just don't know how to input the answers into a formula...

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. 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 = %...

• ### Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock...

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 pay a \$14 per share 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? Future dividend Years until first dividend Dividend...

• ### please show steps. thank you :) Metallica Bearings, Inc., is a young start-up company. No dividends...

please show steps. thank you :) 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 pay a dividend of \$17 per share 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?...

• ### Metallica Bearings, Inc., is a young start-up company. No dividends will be paid on the stock...

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 pay a dividend of \$17 per share 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? (Do not round intermediate calculations and...

• ### X 5 ? Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In x FILE...

X 5 ? Calculating stock price - Excel FORMULAS DATA REVIEW - Sign In x FILE HOME INSERT PAGE LAYOUT VIEW 8 Arial B IU- - 12 - AA - A - = % Alignment Number - Paste Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font Styles C3 The Jackson-Timberlake Wardrobe Co. just paid a dividend of \$1.95 per share on A B D E F G H I J The Jackson-Timberlake Wardrobe Co. just paid a...

• ### All answers must be entererd as formulas two different questions CHAPTER 7 6 Saved Help Save...

All answers must be entererd as formulas two different questions CHAPTER 7 6 Saved Help Save & Exit Submit 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 pay a \$14 per share dividend 10 years from today and will increase the dividend by 3.9 percent per year thereafter. If the required return...

• ### ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE...

? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE HOME INSERT PAGE LAYOUT VIEW 86 Calibri - 11 LE Paste B I U - AA AAlignment Number Conditional Format as Cell Formatting" Table Styles Styles Cells - Editing Clipboard Font > 41 \$ 1.95 Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend...

• ### ? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE...

? - X SEE Calculating stock price - Excel FORMULAS DATA REVIEW 6 Sign In FILE HOME INSERT PAGE LAYOUT VIEW 86 Calibri - 11 LE Paste B I U - AA AAlignment Number Conditional Format as Cell Formatting" Table Styles Styles Cells - Editing Clipboard Font > 41 \$ 1.95 Current dividend Dividend growth rate Required return Price in Year Price in Year Price in Year Complete the following analysis. Do not hard code values in your calculations. Dividend...

I got the wrong answer? Please help me 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 pay a dividend of \$14 per share 10 years from today and will increase the dividend by 8 percent per year thereafter. If the required return on this stock is 14 percent, what is the current...