Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The company chosen for your group will be your designated share for this assignment. Find the historical dividend payment pattern for the last 10-15 years

  1. The company chosen for your group will be your designated share for this assignment.
  2. Find the historical dividend payment pattern for the last 10-15 years from the company website, Annual Report or DSE website (www.dsebd.org).
  3. If dividend payment is not clear from the sources, then you may use the EPS data as an alternative.
  4. From these past data, you have to figure out the average growth rate of dividends or earnings. This will provide you with a basis for assuming how might the dividend growth pattern be.
  5. Use the Constant Growth model to find the value of your share. Use

V= D1/(k-g), To get D1, first get the information about the last dividend payment. That will be D0.

  1. Now use different combination of k and g value to find the various ranges of prices for the stock. Fill up the table using all combinations.

K value

8%

10%

12%

15%

18%

20%

25%

g=3%

g=4%

g=5%

g=6%

g=8%

g=10%

  1. Now find out the actual market price for the stock. Make your decision whether it is undervalued or overvalued according to your estimated table values.
  2. Addition to this also mention the price graph for the last one year for your stock and make an assessment on your decision on item#7.

For your help, please find below Square Pharmaceuticals dividend data for the past 10 years.

Declaration dateRecord datePayment dateAmount of dividend
2-Mar-0515-Mar-0515-Apr-050.33
24-May-0515-Jun-0515-Jul-050.33
2-Aug-0515-Sep-0515-Oct-050.33
30-Nov-0515-Dec-0515-Jan-060.33
1-Mar-0615-Mar-0615-Apr-060.33
2-May-0615-Jun-0615-Jul-060.33
1-Aug-0615-Sep-0615-Oct-060.33
31-Oct-0615-Dec-0615-Jan-070.33
6-Feb-0715-Mar-0715-Apr-070.365
1-May-0715-Jun-0715-Jul-070.365
31-Jul-0714-Sep-0715-Oct-070.365
6-Nov-0714-Dec-0715-Jan-080.365
6-Feb-0814-Mar-0815-Apr-080.365
12-Dec-0823-Dec-0815-Jan-090.365
10-Feb-0916-Mar-0915-Apr-090.385
6-May-0915-Jun-0915-Jul-090.385
5-Aug-0915-Sep-0915-Oct-090.405
11-Nov-0915-Dec-0915-Jan-100.405
3-Feb-1015-Mar-1015-Apr-100.435
5-May-1015-Jun-1015-Jul-100.435
4-Aug-1015-Sep-1015-Oct-100.4575
9-Dec-1015-Dec-1015-Jan-110.4575
9-Feb-1115-Mar-1115-Apr-110.4925
11-May-1115-Jun-1115-Jul-110.5175
3-Aug-1115-Sep-1115-Oct-110.5175
2-Nov-1115-Dec-1115-Jan-120.5175
8-Feb-1215-Mar-1215-Apr-120.5425
3-May-1215-Jun-1215-Jul-120.5425
7-Aug-1214-Sep-1215-Oct-120.5675
31-Oct-1214-Dec-1215-Jan-130.5675
6-Feb-1315-Mar-1315-Apr-130.5825
8-May-1314-Jun-1315-Jul-130.5825
7-Aug-1316-Sep-1315-Oct-130.5825
6-Nov-1316-Dec-1315-Jan-140.5825
5-Feb-1414-Mar-1415-Apr-140.6175
5-May-1416-Jun-1415-Jul-140.6175
6-Aug-1415-Sep-1415-Oct-140.6175
5-Nov-1415-Dec-1415-Jan-150.6175
4-Feb-1516-Mar-1515-Apr-150.65
29-Apr-1515-Jun-1515-Jul-150.65
5-Aug-1515-Sep-1515-Oct-150.65

Step by Step Solution

3.33 Rating (147 Votes )

There are 3 Steps involved in it

Step: 1

ANSWER Based on the dividend data for Square Pharmaceuticals the average growth rat... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Business Reporting For Decision Making

Authors: Jacqueline Birt, Keryn Chalmers, Albie Brooks, Suzanne Byrne, Judy Oliver

4th Edition

978-0730302414, 0730302415

More Books

Students also viewed these Accounting questions

Question

Is Method a multinational company? Explain.

Answered: 1 week ago