Question

PLEASE HELP ME FILL IN THE BOX WITH AN EXCEL FUNCTION? ? X - Sign In...

PLEASE HELP ME FILL IN THE BOX WITH AN EXCEL FUNCTION? ? X - Sign In FILE HOME Arial Calculating stock price - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW -12 = % p U . - A

? 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.
0 0
Add a comment Improve this question
Answer #1

P9 010/(Ke-g) 14/(0.125-0.039) $ 162.79 Stock price in 9 years Stock price today Dividend at year 10 Required return Growth r

Add a comment
Answer #2

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

source: I failed the same question and this is the correct answer given.
answered by: Anon
Add a comment
Know the answer?
Add Answer to:
PLEASE HELP ME FILL IN THE BOX WITH AN EXCEL FUNCTION? ? X - Sign In...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
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....

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
Active Questions
ADVERTISEMENT