Stock Valuation Assignment - Prepare a stock valuation model

Reference no: EM132415880

Stock Valuation Assignment -

All students are being assigned an individual company to prepare a stock valuation model, which is to be based on material covered in Chapters 18, 7 and 10.

The assignment requires a copy of the latest annual report (10-K) of your assigned company. You will need to use the financial statements portion to complete the assignment, which has to be turned in with the assignment and can be obtained through several sources. Some major sources include:

1) The company's Investor Relations Department.

2) A business library, such as the Baruch College Library or the Business and Science Library in New York City.

3) The company's web site, where a copy can usually be downloaded directly.

4) A web site that accesses EDGAR, the SEC's corporate filing center. This can be accessed from Yahoo (under the company's profile) or through sites such as Free EDGAR and EDGAR Online.

5) An annual report service, which is provided by major financial information companies such as Dow Jones.

A pro forma Income Statement must be prepared in MS Excel, using a minimum projection of three years, as based on pro forma projections discussed in Chapter 18. This information can then be used to calculate the fair value of the company's stock price, as based on the stock valuation formulas discussed in Chapters 7 and 10. All assumptions and formulas used for the pro forma projections and the company's fair value must be included at the end of your model. Once a fair value is reached, this can be compared to a recent quote of the company's stock price to determine whether or not the company is fairly valued at its most recent trading price.

Reference no: EM132415880

Questions Cloud

What were scheiber total and annual returns : In turning $5000 into $22 million, what were Scheiber's total and annual returns?

Poisson distribution with parameter : A troubled miser stores his coins in a large number of boxes. Each box has a different number of coins; if you pick a box at random, the number of coins N

Define the dependent and independent variables : Define the dependent and independent variables. How to Fit a simple linear regression for the above data.

Negative correlation between the number of overtime : The question states: You tell your supervisor that there is a strong negative correlation between the number of overtime hours worked and the level

Stock Valuation Assignment - Prepare a stock valuation model : Stock Valuation Assignment - All students are being assigned an individual company to prepare a stock valuation model, use the financial statements portion

How are social workers involved in the field of practice : How are social workers involved in the field of practice you picked? What ideas or recommendations do you have for providing good services and/or making.

What is the approximate maximum number of hours : What is the approximate maximum number of hours that puts a candle in the bottom 7% of burn time?

Why is an understanding of child mortality essential : Write a 175- to 265-word response to the following: Why is an understanding of child mortality essential to describing advancements in health care outcomes?

Estimate effect size using partial omega-squared : How do I estimate effect size using partial omega-squared: ?P2? (Round your answer to two decimal places.)

Reviews

len2415880

12/12/2019 2:38:33 AM

Instructions: So it’s a stock Valuation and excel spreadsheet. If you need access to a textbook please let me know. Attached is also a small example from my notes. We are able to use only Income statement. Please let me know if there are any questions.

Write a Review

Required(*) Message

User Account

All Pages