[SOLUTION] Dividend Analysis and Preliminary Valuation

*PLEASE REVIEW WEEK 3 MODEL ASSIGNMENT BEFORE BEGINNING PAPER*In Section 3: Dividend Analysis and Preliminary Valuation assignment, you will compute the company’s stock value based on historical dividend data for your company 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 undervalued or overvalued 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 over the past 10 years if it has not paid dividends for 10 years, including as many years as available.o Calculate the growth in annual dividends per share each year and include this annual growth rate in your table.? To find the dividends your company has paid in the past 10 years, review the BUS401 |Picking a Company that Pays Dividends (Links to an external site.) video from Week 1.o Calculate the average dividend growth rate over the following periods:? the most recent 10 years,? the most recent 5 years, and? the most recent 3 yearso 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 yearo 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 the following:? the most recent year growth rate;? the average growth rate over the 10-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 10-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 usein the constant growth formula.? Justify the determined 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 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.o 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%.o Show your calculations.•In a similar manner, calculate another estimate of the stock price for your selected company using the constant growth formula and the high-end dividend growth rate.o 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.o Show your calculations.• Compare each of the two stock prices you just calculated to the current stock price per share of the company.o State whether each constant growth stock price (low-end and high-end) is above or below the current price.o State whether each constant growth stock price (low-end and high-end) indicates if the stock price is currently undervalued or overvalued in the market.•Deter mine 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 at least two financial facts from your Week 1 and Week 2 analyses.Must be three to four double-spaced pages in length, including any tables or calculations (but not including title and references pages) and formatted according to APA Style (Links to an external site.) as outlined in the Writing Center’s APA Formatting for Microsoft Word (Links to an external site.) resource).Must include a separate title page with the following:Title of the paper in bold fontSpace should be between the title and the rest of the information on the title page.Student’s namName of institution (The University of Arizona Global Campus)Course name and numberInstructor’s nameDue dateMust utilize academic voice. See the Academic Voice (Links to an external site.) resource for additional guidance.Must include a separate references page formatted according to APA style as outlined in the Writing Center. See the APA: Formatting Your References List (Links to an external site.) resource in the Writing Center for specifications.Must cite where the financial statement information comes from (i.e., Mergent)For help citing the information from Mergent, see the BUS401: Principles of Finance Research Guide.Note: Since this is Section 3 of the Week 5 final project, there is no need for an introduction paragraph.


So much stress and so little time? Take care of yourself: let us help you with your task on
[SOLUTION] Dividend Analysis and Preliminary Valuation
Get a 20% Discount on this Paper
Get Help Now

Order Solution Now at a 15% Discount!

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
Sign up, place your order, and leave the rest to our professional paper writers in less than 2 minutes.
step 1
Upload assignment instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Get personalized services with Do My Homeworkk
One writer for all your papers
You can select one writer for all your papers. This option enhances the consistency in the quality of your assignments. Select your preferred writer from the list of writers who have handledf your previous assignments
Same paper from different writers
Are you ordering the same assignment for a friend? You can get the same paper from different writers. The goal is to produce 100% unique and original papers
Copy of sources used
Our homework writers will provide you with copies of sources used on your request. Just add the option when plaing your order
What our partners say about us
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Business and administrative studies
Thank you so much for your help!!!!!
Customer 452519, November 9th, 2022
A well-researched paper. Delivered before the deadline as well. Extremely pleased !!
Customer 452445, August 20th, 2021
M5A1 Outline and Thesis
Paper was late
Customer 452457, November 15th, 2021
Looks good. Thank you!
Customer 452523, September 27th, 2022
Leadership Studies
This is great! Thanks a bunch
Customer 452485, March 1st, 2022
English 101
Great work!
Customer 452443, December 2nd, 2021
Excellent. Thnk you
Customer 452443, October 22nd, 2021
Excellent services!
Customer 452443, November 11th, 2021
Business Studies
I can't even explain how much your help meant to me. Thnk you always
Customer 452443, November 15th, 2021
National Security Intelligence and Security Analysis
Customer 452457, November 3rd, 2021
Customer 452493, April 12th, 2022
Thank you! Will definitely use the writer again.
Customer 452443, October 22nd, 2021
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat

Order your essay today and save 15% with the discount code ESSAYHELP