Question

# Please no excel 4/25/19 Group # Last Name: Section: 371-05 First Name: First Name: First Name:...

4/25/19 Group # Last Name: Section: 371-05 First Name: First Name: First Name: First Name: Last Name: Last Name: Last Name: Quiz 1. isexpected to paythefollowing dividends over the next 4 years: \$2, \$7, \$1, \$5. Afterwards, the company РТС Co will maintain a constant 6% growth rate in dividends. The required return on stock is 10%. Calculate the curren price.

Current Price= \$102.2666

Working:

#### Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
• ### Urgent please Problem (25 points) Lohn Corporation is expected to pay the following dividends over the...

Urgent please Problem (25 points) Lohn Corporation is expected to pay the following dividends over the next four years: \$11, 58, \$550, and \$245. Afterwards the company pledges to maintain a constant 4 percent growth rate in dividends forever If the required return on the stock is 11.5 percent, what is the current share price?

• ### Problem 6-19 Multiple Growth Rates (L01, CFA6) Leisure Lodge Corporation is expected to pay the following...

Problem 6-19 Multiple Growth Rates (L01, CFA6) Leisure Lodge Corporation is expected to pay the following dividends over the next four years: \$18.00, \$10.00, \$8.00 and \$2.60. Afterwards, the company pledges to maintain a constant 6 percent growth rate in dividends forever. If the required return on the stock is 12 percent, what is the current share price? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Share price

• ### Apocalyptica Corporation is expected to pay the following dividends over the next four years: \$8.00, \$6.00,...

Apocalyptica Corporation is expected to pay the following dividends over the next four years: \$8.00, \$6.00, \$4.75, and \$2.25. Afterwards, the company pledges to maintain a constant 4.5 percent growth rate in dividends, forever. If the required return on the stock is 10 percent, what is the current share price? Please done in excel sheet and show the whole workings.

• ### c/c++ Last name: First name: ID: Sec: The name, ID and section number that appear at...

c/c++ Last name: First name: ID: Sec: The name, ID and section number that appear at the beginning of the output of the program should be your own, not the ones used in the sample Note: results printed must show the data entered at run time, not the data shown in the sample run below! Sample run: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24...

• ### 19. Differential Growth Synovec Corp. is experiencing rapid growth. Dividends are expected to grow at 27...

19. Differential Growth Synovec Corp. is experiencing rapid growth. Dividends are expected to grow at 27 percent per year during the next three years, 18 percent over the following year, and then 4 percent per year indefinitely. The required return on this stock is 10 percent, and the stock currently sells for \$71 per share. What is the projected dividend for the coming year? I am trying to create an MS Excel table to help me with the various calculations...

• ### Lohn Corporation is expected to pay the following dividends over the next four years: \$14, \$10, \$7, and \$4. Afterward, t...

Lohn Corporation is expected to pay the following dividends over the next four years: \$14, \$10, \$7, and \$4. Afterward, the company pledges to maintain a constant 7 percent growth rate in dividends forever. If the required return on the stock is 14 percent, what is the current share price? Multiple Choice \$63.27 \$61.40 \$68.82 \$65.17 \$60.11

• ### show all the work please! Remember to write your name, date, instructor name, and section number...

show all the work please! Remember to write your name, date, instructor name, and section number in heading section on first page and center the lab number and title underneath this on the first page of your lab assignment Part A-Enter your work by hand into the answer sheet provided and turn into your instructor at the end of the lab period. Make sure to include UNITS in all of your answers. Exponential Growth 1. If you invested \$30 in...

• ### Assume that SL is a constant growth company whose last dividend (D0), which was paid yesterday)...

Assume that SL is a constant growth company whose last dividend (D0), which was paid yesterday) was \$4.00, and whose dividend is expected to grow indefinitely at a 4 percent rate. Assume the required rate of return for SL is 13%, (Different from your estimate of 1 above) What is the firm's expected dividend stream over the next 3 years? What is the firm's current stock price? What is the stock's expected value 1 year from now? What is the...

• ### . Kicssling Corp. pays a constant S9 dividend on its stock. The company will maintain this...

. Kicssling Corp. pays a constant S9 dividend on its stock. The company will maintain this dividend for the next eight years and will then cease paying dividends forever. If the required return on this stock is 11 percent, what is the current share price? 1. Metallica Bearings, Inc. is a young start-up company. No dividends will be paid on the stock over the next nine years, because the first needs to plow back its carnings to fuel growth. The...

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