Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started