Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

and the market returns. Use the SP 5 0 0 i Project Each member of the class is encouraged to become part of a study

and the market returns. Use the SP500 i Project
Each member of the class is encouraged to become part of a study group consisting of two to
four students. This group will work together and prepare the topic explained more below.
Once a group is formed it cannot be changed, so please choose your groups CAREFULLY.
Topic: You must write an Equity Research Report.
Although there is no universal format for any equity research report, some rules and contents
are widely used and covered. Please refer to this document produced by the CFA Institute,
here. Also, there are various Equity Research Reports available on the internet. Search for them
and become familiar with the most common contents.
Select a company that you like. The only restriction is that you must select a company whose
stock is traded in the stock market. Then: Go to yahoo finance, use the selected company's
ticker (examples: the ticker for Apple is AAPL, the ticker for Coca-Cola is KO, the ticker for
Tesla is TSLA) in the search engine and access to the company's profile. There, you find 11
pages you can browse, from 'Summary' to 'Sustainability'. The data/information conveyed in
these pages is the primary source of information for your project. Use it.
These are the aspects that you must include in your report:
Executive summary at the beginning of your report. An executive summary is a
brief description of what the reader is about to read once he or she goes through your
report. Again, there are many places where you can find information about how to write
a good executive summary. Search for it in the CFA document (link provided above).
The company's financial ratios. You should select the most relevant ones, and you
should consider the ones that you have learned in the prerequisite course of Principles
of Finance. Make sure that you present the financial ratios for the last 5 years (2023,
2022,2021,2020 and 2019).
The annual rate of return (both arithmetic and continuous) for the last five years, the
standard deviation and variance for those five years' monthly returns and the
company's Beta. Use monthly data, which means that you need to consider 61 prices
, plus one because you need a base price to compute the first rate of return).
To estimate the Beta, you need to determine the covariance between the stock returns
and the market returns. Use the SP500 index prices as a proxy to measure the American
stock market. If the stock that you selected is traded in a different country, make sure
that you select that co Topic: You must write an Equity Research Report.
Although there is no universal format for any equity research report, some rules and contents are widely used and covered. Please refer to this document produced by the CFA Institute, here. Also, there are various Equity Research Reports available on the internet. Search for them and become familiar with the most common contents.
Select a company that you like. The only restriction is that you must select a company whose stock is traded in the stock market. Then: Go to yahoo finance, use the selected companys ticker (examples: the ticker for Apple is AAPL, the ticker for Coca-Cola is KO, the ticker for Tesla is TSLA) in the search engine and access to the companys profile. There, you find 11 pages you can browse, from Summary to Sustainability. The data/information conveyed in these pages is the primary source of information for your project. Use it.
These are the aspects that you must include in your report:
1. Executive summary at the beginning of your report. An executive summary is a brief description of what the reader is about to read once he or she goes through your report. Again, there are many places where you can find information about how to write a good executive summary. Search for it in the CFA document (link provided above).
2.
The companys financial ratios. You should select the most relevant ones, and you should consider the ones that you have learned in the prerequisite course of Principles of Finance. Make sure that you present the financial ratios for the last 5 years (2023,
2022,2021,2020 and 2019).
3. The annual rate of return (both arithmetic and continuous) for the last five years, the
standard deviation and variance for those five years monthly returns and the companys Beta. Use monthly data, which means that you need to consider 61 prices (12*5=60, plus one because you need a base price to compute the first rate of return). To estimate the Beta, you need to determine the covariance between the stock returns
and the market returns. Use the SP500 index prices as a proxy to measure the American stock market. If the stock that you selected is traded in a different country, make sure that you select that countrys market index returns.
4. You need to apply the following models/techniques in your work:
a) Capital Asset Pricing Model (you need the companys beta for such).
b) Dividend Discount Model (Gordon-Shapiro Model).
c) Multiples Valuation.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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 Principles Volume 1

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

8th Canadian Edition

978-1119502425

Students also viewed these Finance questions