as below

Excel Sheet Stock & Company Infos Hi!

Here is a very straight forward Explanation of the task! If you have a question pls contact me anytime. 1. Ticker & Company Name

The Ticker ist he shortening of the company name that you use in financial databases to identiy stocks of different companies. E.g. Amazon = AMZ, Netflix = NFLX, Apple = AAPL

If you type in the Ticker in the left corner, the excel sheet you then load all the right accompanying financial information of the stock/company. 2. Stockmetrics

Here all data regarding the stock should be listed. In this box you have to source the data from different sources.

Trailing P/E is the current P/E. Forward P/E is the expected P/E

ROE

Company Sector and Industry.

Target Price

Beta

3. Financials Box

This is exactly loaded from marketscreener. The only thats calculated manually is EBITA Marging (EBITA/SALES).

4. Debt

The same source as the financial box. Market screener.

5. Sales per Region

Also Market screener but this time a different tab. Use the Company Tab for Sales per Region.

6. Sales per Business

Also Market screener but this time a different tab. Use the Company Tab for Sales per Region

7. Surprises

Use the Calender Tab from Marketscreener.

8. Peer Group Figures.

Also under the company tab you will find the sector/industry peers. Just load the top 4 into the peer table and beneath the valuations.

9. Company Description

Use Reuters About:

10. Company News

https://www.reuters.com/companies/CPB.A/events

11. Volume & MAV

Just use sesssion volume and av volume of 20 sessions.

Sources:

Stockrow.com

Marketscreener.com

Yahoofinance.com

Reuters.com