Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

search on mcDonald's Corporation MCD (Restaurants) through Factset A COMPANY/SECURITY TAB: 1a Look up your assigned company in the Assigned Companies tab of this spreadsheet.

search on mcDonald's Corporation MCD (Restaurants) through Factset
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
A COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Assigned Companies" tab of this spreadsheet. What is its name? 1b What is the stock ticker symbol for your company? 2 How many employees does the company have? 1 3 What percent of analysts believe it is a HOLD rating? 1 4 What was the % Sales growth rate between the most recent FISCAL year and the year before that? 1 5 Download your company's Debt Capital Structure (DCS) Summary from the DCS Overview into a new excel spreadsheet then copy it's contents into the "Insert 1" tab of this spreadsheet. 1 6 Go to the RATINGS section and take a screenshot showing the Long Term debt rating for your Company and paste it into the "Insert 2 " tab of this spreadsheet. 1 7 How much did your company spend on capital expenditures in its most recently reported FISCAL year? (Give your answer in \$ Millions eg. $2,000,000 would be " 2 ") 1 8 What is the most recently reported 12 months of EBIT? (Give your answer in \$ Millions) 1 Assigned Company Questions Insert 1 Insert 2 9 Name the top 5 comparable companies (use Source = Factset Peer Group) 10 What is the name of the top shareholder of the company in the "Insiders / Stakeholders" category? (NOT the "Institutions" category!) 11 What is the 52 week high of the stock price? 12 When was the company's last earnings call? (Note: An earnings call is when Co. management has a conference call with analysts to discuss the latest financial statements.) 88 For the "United Kingdom / Apparel/Footware Retail" industry, what was the EBIT growth rate the 14 calendar year ending Dec 2022? 1 ECONOMICSTAB: 15 What was Canada's Current Account total Balance for 2022 (in \$ Billions) 1 16 What was China's Government Debt as a \% of GDP as of March 2023? 1 SCREENING TAB: 17 Facset has an Equity Universal Screen template called "Share Repurchases". Run that screen and identify the company with the largest sum of shares repurchased during the Last 4 Quarters. 1 CHARTING TAB: 18 Insert below, a screenshot of a single Factset chart showing a 10 year history of the daily US\$ price of both your assigned company's common stock AND the S\&P 500 stock index. 1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Fundamentals Of Investments Valuation And Management

Authors: Bradford Jordan, Thomas Miller, Steve Dolvin

9th Edition

1260013979, 9781260013979

More Books

Students also viewed these Finance questions

Question

=+3. List the touchpoints where you'd reach your audience.

Answered: 1 week ago