Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started