NOTES: B C D E F 1) Change the name of this excel file to your name! Points 2) Questions 1 to 12 are based on your assigned company (see "Assigned Company" tab of this spreadsheet). COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Astigned Companies" tab of this spreadsheet. What is its name? Best Bur Con, Inc: 1b What is the stock ticker symbol for your company? B8Y 2 How many emplovees does the company have? 1 3 What percent of analysts believe it is a HOLD rating? 1 4 What was the % Sales frowth rate between the most recent FisCAL veat and the wear 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. Go to the RATINGS section and take a screenshot showing the Long Term debt rating for vour Company and paste it into the "Insert 2 " tab of this spteadsheet. How much did your company spend on capital expenditures in its most recently reported fISCAL veas? (Give your answer in $ Millions eg. $2,000,000 would be " 2 ") 17.0 A B C D 8 10 What is the name of the top shareholder of the company in the "Insiders / Stakeholders" category? (NOT the "Institutions" categoryl) 1 11 What is the 52 week high of the stock price? 1 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.) 1 INDUSTRY TAB: For the "Canada / Consumer Non-Durables" industry, what was the return on equity \% for the calendar year ending in Dec 2021 ? 1 For the "United Kingdom / Apparel/Footware Retail" industry, what was the EBIT growth rate the calendar year ending Dec 2022? 1 ECONOMICS TAB: 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: 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. Assigned Company Questions Insert 1 Insert 2 Accessibility; investigate NOTES: B C D E F 1) Change the name of this excel file to your name! Points 2) Questions 1 to 12 are based on your assigned company (see "Assigned Company" tab of this spreadsheet). COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Astigned Companies" tab of this spreadsheet. What is its name? Best Bur Con, Inc: 1b What is the stock ticker symbol for your company? B8Y 2 How many emplovees does the company have? 1 3 What percent of analysts believe it is a HOLD rating? 1 4 What was the % Sales frowth rate between the most recent FisCAL veat and the wear 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. Go to the RATINGS section and take a screenshot showing the Long Term debt rating for vour Company and paste it into the "Insert 2 " tab of this spteadsheet. How much did your company spend on capital expenditures in its most recently reported fISCAL veas? (Give your answer in $ Millions eg. $2,000,000 would be " 2 ") 17.0 A B C D 8 10 What is the name of the top shareholder of the company in the "Insiders / Stakeholders" category? (NOT the "Institutions" categoryl) 1 11 What is the 52 week high of the stock price? 1 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.) 1 INDUSTRY TAB: For the "Canada / Consumer Non-Durables" industry, what was the return on equity \% for the calendar year ending in Dec 2021 ? 1 For the "United Kingdom / Apparel/Footware Retail" industry, what was the EBIT growth rate the calendar year ending Dec 2022? 1 ECONOMICS TAB: 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: 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. Assigned Company Questions Insert 1 Insert 2 Accessibility; investigate