Brooklyn College Stock Valuation Worksheet


Please see the word doc with the assignment and excel doc with the document to input figures and complete assignment.

2 attachmentsSlide 1 of 2attachment_1attachment_1attachment_2attachment_2

Unformatted Attachment Preview

Industry of your target company
Sector of your target company
Company Name
Target Company
Company Name
Comparable Company 1
Comparable Company 2
Comparable Company 3
Comparable Company 4
Comparable Company 5
*Comparable Company 6
*Comparable Company 7
Average P/E
Median P/E
Market Capitalization (# of shares outstanding * stock price)
Forward EPS (estimated for next year)
Market Capitalization (# of shares outstanding * stock price)
Target Price (Average P/E)
Target Price (Median P/E)
Bonus (2 points) Assignment – Price Estimation Using P/E Ratio
1. Select your target company
2. Find 5-8 comparable companies
a. Go to Yahoo Finance – Equity screener:
b. Select “Create New Screener”: set your industry & sector
c. Get the list of firms and select your comparable companies
i. Sometimes you will see multiple tickers for the same firm, be careful not to use
the OTC trading price
ii. You want to use the prices from the American Stock Exchange (AMEX), the New
York Stock Exchange (NYSE) and the National Association of Securities Dealers
3. Using the comparable companies, calculate the average P/E ratio and the median P/E ratio
a. Use =AVERAGE() in EXCEL to find average P/E
b. Use =MEDIAN() in EXCEL to find median P/E
4. Find the P/E estimated price of your target company
a. Estimated price (using average P/E) = EPS of your target firm * average P/E
b. Estimated price (using median P/E) = EPS of your target firm * median P/E

Purchase answer to see full

Explanation & Answer:
2 pages



stock valuation

User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.

Reviews, comments, and love from our customers and community:

This page is having a slideshow that uses Javascript. Your browser either doesn't support Javascript or you have it turned off. To see this page as it is meant to appear please use a Javascript enabled browser.

Peter M.
Peter M.
So far so good! It's safe and legit. My paper was finished on time...very excited!
Sean O.N.
Sean O.N.
Experience was easy, prompt and timely. Awesome first experience with a site like this. Worked out well.Thank you.
Angela M.J.
Angela M.J.
Good easy. I like the bidding because you can choose the writer and read reviews from other students
Lee Y.
Lee Y.
My writer had to change some ideas that she misunderstood. She was really nice and kind.
Kelvin J.
Kelvin J.
I have used other writing websites and this by far as been way better thus far! =)
Antony B.
Antony B.
I received an, "A". Definitely will reach out to her again and I highly recommend her. Thank you very much.
Khadija P.
Khadija P.
I have been searching for a custom book report help services for a while, and finally, I found the best of the best.
Regina Smith
Regina Smith
So amazed at how quickly they did my work!! very happy♥.