Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I desperately need help with answering all the components in an excel format using the most recent data March 23 from The financial company Blackstone.

I desperately need help with answering all the components in an excel format using the most recent data March 23 from The financial company Blackstone. The data must be obtained from the Factset website, or from another reputable website that displays the financials of Blackstone needed to obtain these calculations. Please feel free to respond with any further questions. image text in transcribed

OBJECTIVE: The goal of this assignment is to apply the fundamental analysis tools that we have studied in Chapter 13. We will use these tools to analyze a firm's fundamentals and then come up with a trading strategy. Using a version of the Dividend Discount Model, the Free Cash Flow Model, the P/E ratio, the P/CF ratio, and the P/S ratio, you will perform valuations for your equity, chosen from you industry to determine a target price and a recommendation of Buy, Sell, or Hold. PART I: DIVIDEND DISCOUNT MODEL Using Factest, we will find the financial statements of your company. For the Dividend Discount Model, find current dividends per share, D(0), from the income statement. Examine the dividends of the last 20 quarters and read analysts reports regarding predictions of growth in the future (specifically dividend growth). Then estimate the dividend growth rate, g, using the previous 20 quarters of dividends using the arithmetic and geometric method, also find it on the ratios/statements pages, and calculate the sustainable growth rate using the method from class. Provide an evaluation of these growth rates and choose the growth rate you are going to utilize. (i.e. an average of the methods, the stated growth rate because you do not believe your arithmetic or geometric average is accurate due to the dividend pattern, etc.). You estimate the discount rate, k, using the CAPM. Clearly state what you are employing to estimate the CAPM and be sure you are using proper proxies. Next determine which version of the DDM you should use (no growth, constant growth, multistage,etc.) Then estimate the stock price. (Note: Some stocks don't pay dividends. However you must choose a stock that does pay dividends.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Learning From Collaborative Audit

Authors: Higher Education Quality Council

1st Edition

1858242312, 978-1858242316

More Books

Students also viewed these Accounting questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago