Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you use Factset and help me assignment? Loews Corporation L Property / Casualty Insurance 2 ) Questions 1 to 1 2 are based on

Can you use Factset and help me assignment?
Loews Corporation L Property/Casualty Insurance
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 "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
9 Name the top 5 comparable companies (use Source = Factset Peer Group)1
10 What is the name of the top shareholder of the company in the "Insiders / Stakeholders" category? (NOT the "Institutions" category!)1
11 What is the 52 week high of the stock price? 1
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.)1
INDUSTRY TAB:
13 For the "Canada / Consumer Non-Durables" industry, what was the return on equity % for the calendar year ending in Dec 2021?1
14 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:
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
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.
What is the Long Term debt rating for your Company 1? Take a screenshot and put it in the "Insert 2"
Can you help me?

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

International Finance Transactions Policy And Regulation

Authors: Hal S. Scott

15th Edition

159941547X, 978-1599415475

More Books

Students also viewed these Finance questions