# In the Section 3: Dividend Analysis and Preliminary Valuation assignment,

In the Section 3: Dividend Analysis and Preliminary Valuation assignment, you will compute the of the company’s stock value based on historical dividend data for your company (APPLE INC) and a market-based equity rate of return. In this analysis, you will use the constant growth formula to compute two estimates of the stock price, a high-end value and a low-end value. Analysts frequently assess the stock value using a range of values, based on reasonable assumptions for a high-end and a low-end range.

Once you have calculated two stock values, you will compare the company’s calculated values compared to the current market price of the stock. This comparison will help you determine if the stock is currently under-valued or over-valued, and will help you determine your recommendation of buy, hold, or sell. Analysts prepare value estimates based on historical data for the company as well as an understanding of expected future equity rates of return. It is important to understand that the constant growth formula provides an estimate of value, and analysts, like all humans, can be both right and wrong. The inputs used in the formula will greatly impact the value conclusion.

Write:

In your paper, address the following five parts in a Word document:

Part 1: Dividend Analysis (two to three paragraphs):

• Create a table that illustrates the annual dividends per share paid by your selected company (APPLE INC)over the past 8 years. If the company has not paid dividends for 8 years, include as many years as available.
• Calculate the growth in annual dividends per share each year and include this annual growth rate in your table.
• Calculate the average dividend growth rate over the following periods:
• the most recent 8 years,
• the most recent 5 years, and
• the most recent 3 years.
• Summarize the trend in the dividend growth rates.
• Have the dividend growth rates increased or decreased? By how much? Has the increase or decrease been steady or varied from year to year?
• Determine two distinct estimates of the future dividend growth rate for this company: a high-end growth rate and a low-end growth rate. You are to choose these growth rates based on what is reasonable from the data you have on the company’s dividend growth in prior years, as presented in your table. The two future dividend growth rates can be any of following:
• the most recent year growth rate;
• the average growth rate over the 8-year period;
• the average growth rate over the most recent 5 years;
• the average growth rate of the most recent 3 years; or
• a growth rate you select that is reasonable, given the 8-year, 5-year, and 3-year averages, as well as the recent year growth rates.
• NOTE: Both dividend growth rates must be lower than the required rate of return used in the constant growth formula. See Part 2 below for the required rate of return to use in the constant growth formula.
• Justify the determined the high-end dividend growth rate and low-end dividend growth rates for your company. In your justification, provide a least two financial facts from your Week 1 and Week 2 assignments to support your determination.

Part 2: Preliminary Valuation: (two to three paragraphs)

• Calculate the stock price for your selected company (APPLE INC) using the constant growth formula and the low-end dividend growth rate you determined in Part 1. Show all calculations for this estimated stock price using the low-end dividend growth rate.
• For the required rate of return (r), use the following assumptions:
• For a large capitalization company (greater than \$10.0 billion in market capitalization) use 10.0%.
• For a mid-cap company (between \$2.0 billion and \$10.0 billion in market capitalization) use 12.0%.
• For a small-cap company (less than \$2.0 billion in market capitalization) use 15.0%.
• In a similar manner, calculate another estimate of the stock price for your selected company (APPLE INC) using the constant growth formula and the high-end dividend growth rate.
• Use the same assumptions for the required rate of return (r) that you used for the low-end stock price, other than using the high-end dividend growth rate.
• Compare each of the two stock prices you just calculated to the current stock price per share of the company.
• State whether each constant growth stock price (low-end and high-end) is above or below the current price.
• State whether each constant growth stock price (low-end and high-end) indicates if the stock price is currently under-valued or over-valued in the market.
• Determine your concluded stock value, based on the two calculations using the constant growth formula.
• Justify your conclusion of value for your stock, using either the high-end stock price or the low-end stock price from the constant growth formula.Include least two financial facts from your Week 1 and Week 2 analyses.

The Section 3: Dividend Analysis and Preliminary Valuation paper

Note: Since this is Section 3 of the Week 5 final project, there is no need for an introduction paragraph.

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Discussion Question 1: Define data mining. Why are there many

Discussion Question 1: Define data mining. Why are there many names and definitions for data mining? Discussion Question 2: What are the main reasons for

### Recently, a terminated employee used his mobile device to log

Recently, a terminated employee used his mobile device to log into the company network and steal sensitive data. As the manager of the information technology

### Machiavelli Ideology on Hobbe’s Leviathan

The paper should be 1700 words long. Double spaced, Times New Roman, Must have citations in APA format (with the page number in the citation).

Present  your original research findings, analysis and links to your relevant references, literature citations, and the applied theories.    ​(What does data collection say about

### · The write-up should be at most 1,000-words (12-point font,

·  The write-up should be at most 1,000-words (12-point font, 1.5 spaced)  1.  “Cyber Breach at Target” Case Questions 1.  What is your diagnosis of the

### For unit one Complete assignment, write a narrative essay (minimum

For unit one Complete assignment, write a narrative essay (minimum of 1000 words) which addresses the statements below. When finished the essay should reflect a

### he purpose of this project is to demonstrate your understanding

he purpose of this project is to demonstrate your understanding of the following course concepts: 1. How companies use digital and social media to effectively

### Accountability in the Workplace

We are all responsible for quality—health care leadership, providers, volunteers, and yes, even patients and their families. An organization with high standards and a reputation

### Analyze the country of Indonesia. The concept of capabilities approach

Analyze the country of Indonesia. The concept of capabilities approach as developed by A. Sen and M. Nussbaum. Nobel Prize winner A. Sen has

### TOPIC: Needs Assessment Throughout the remainder of the course, you

TOPIC: Needs Assessment Throughout the remainder of the course, you will work on developing a training solution for an organization of your choosing. You should

### Analyzing outcomes from previous months is a helpful step in

Analyzing outcomes from previous months is a helpful step in refining projections and a process. Discuss the importance of evaluating the competition and continually refining

### One of the biggest challenges in nursing education is to

One of the biggest challenges in nursing education is to develop culturally sensitive graduates. Although theory and lecture are appropriate to introduce cultural issues, the

New questions