Question

In: Finance

Assume the following information about a company: Past dividends 2015                $1.32              &nbsp

Assume the following information about a company:

Past dividends

2015                $1.32                           Required return = 11%

2016                $1.44                          

2017                $1.54                          

2018                $1.66

2019                $1.76

Use the appropriate dividend model to place a value on this stock for 2020.

How do I set this up in excel?

Solutions

Expert Solution

Year Past Dividends
                                    2,015                     1.32
                                    2,016                     1.44
                                    2,017                     1.54
                                    2,018                     1.66
                                    2,019                     1.76
Calculate compounded annual growth rate of dividend from 2015 to 2019
Growth rate of dividend 7.46% (1.76/1.32)^(1/4)
Equity Valuation for 2020 as per dividend discount model
Value of Equity                   53.38 1.76*1.0746)/(.11-.0746)
Dividend at year 0 *(1+growth rate of dividend)/(Cost of equity - growth rate of dividend)

Please Upvote and Support!!.

thanks


Related Solutions

You are given the following information about a company. The company pays no dividends. What is...
You are given the following information about a company. The company pays no dividends. What is the company’s WACC? Debt: Common Stock: Market: 90,000 bonds with a par value of $2,000 and a quoted price of 108.40. The bonds have coupon rate of 5.3 percent and 20 years to maturity. 40,000 zero coupon bonds with a quoted price of 29.15, 25 years to maturity, and a par value of $10,000. Assume semiannual coupon payments. 5.5 million shares of stock selling...
Suppose that you are given the following information about the stock price/dividends for a company: Year...
Suppose that you are given the following information about the stock price/dividends for a company: Year Beginning of Year Price Dividend Paid at Year-End 2016 $80 $3 2017 $85 $4 2018 $78 $2 2019 $82 $2 If the company's stock price is $85 per share at the end of 2019, what is the arithmetic average return for an investment in XYZ over the period? What is the geometric average return for an investment in XYZ over the period? (Do not...
​(Common stock​ valuation)  The common stock of NCP paid ​$1.32 in dividends last year. Dividends are...
​(Common stock​ valuation)  The common stock of NCP paid ​$1.32 in dividends last year. Dividends are expected to grow at an annual rate of 8.00 percent for an indefinite number of years. a.  If your required rate of return is 10.50 percent​, what is the value of the stock for​ you? b.  Should you make the​ investment?
The balance sheet includes the following information: A. Information about the firm's past operations B. Information...
The balance sheet includes the following information: A. Information about the firm's past operations B. Information to calculate financial ratios C. Information about the firm's current market value D. A, B, and C E. A and B When a firm declares dividends: A. Net income decreases and cash decreases B. Retained earnings decreases and cash increases C. Net income decreases and dividend payable increases D. Retained earnings decreases and dividend payable increases E. None of the above For a firm...
Grosbeck Cattle Company has gathered the following information about operations for the past three years. Mathew...
Grosbeck Cattle Company has gathered the following information about operations for the past three years. Mathew Grosbeck has been expanding herd size and is frustrated that profits have not shown consistent growth. Available 20 Year 1 Year 2 Year 3 Your Score Cow herd size 120 140 180 Revenues from sale of calves $       102,000 $       119,000 $       153,000 Feed             18,000             21,000             27,000 Labor (1 cowboy per 120 cows)             24,000             48,000             48,000 Cow depreciation...
Over the past 5 years from 2015 to 2020, DL Insulation has paid annual dividends of...
Over the past 5 years from 2015 to 2020, DL Insulation has paid annual dividends of $0.46, $0.635, $0.71, $1.03 and $1.13 per share. What would you estimate the share price to have been at 30/06/2020? Would you have bought your company’s stock? (a required an actual return of 16%)
You are given the following past information and assume the tax rate to be 45% 2018...
You are given the following past information and assume the tax rate to be 45% 2018 2017 ( $ ) Net sales 10,500 9,800 Depreciation 200 160 Dividend paid 100 70 End of 2018 End of 2017 Cash & m/s 650 580 Accounts receivable 1,000 930 Accounts payable 600 540 Inventory 1,100 1,070 Notes payable 180 130 Long term debt 4,000 3,800 Common shares 2,500 2,400 Net fixed assets 8,000 7,700 The cash flow from investments is: The cash flow...
Bethesda Mining Company reports the following balance sheet information for 2015 and 2016. Prepare the 2015...
Bethesda Mining Company reports the following balance sheet information for 2015 and 2016. Prepare the 2015 and 2016 common-size balance sheets for Bethesda Mining. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) BETHESDA MINING COMPANY Balance Sheets as of December 31, 2015 and 2016 2015 2016 2015 2016 Assets Liabilities and Owners’ Equity Current assets Current liabilities Cash $ 55,526 % $ 70,205 % Accounts payable $ 188,922 %...
1. Given the information below about Thomas Corporation, what was the amount of dividends the company...
1. Given the information below about Thomas Corporation, what was the amount of dividends the company paid in the current period? Beginning retained earnings $ 54,000 Ending retained earnings $ 117,000 Decrease in cash $ 9,900 Net income $ 91,000 Change in stockholders’ equity $ 13,000 2. The ending Retained Earnings balance of Boomer Inc. decreased by $1.9 million from the beginning of the year. The company declared a dividend of $4.7 million during the year. What was the net...
A company paid $150 in dividends and $500 in interest over the past year. The company...
A company paid $150 in dividends and $500 in interest over the past year. The company increased retained earnings by $400 and had accounts payable of $690. Sales for the year were $16,000 and the tax rate was 30 percent. What was the company's EBIT? Group of answer choices $1,050 $1,286 $4,800 $3,750 $1,740
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT