Answered step by step
Verified Expert Solution
Question
1 Approved Answer
List of companies to choose from: Fortis Inc. Pembina Pipeline Franco-Nevada Metro Ridley Saputo Canadian Natural Resources Shaw Communications Torstar Husky Energy Lassonde Industries Winpak
List of companies to choose from:
Requirements: Your group is assigned to research and analyze the financial performance of Company Name. Through the company's website, download and review the annual reports for 2019, 2018 and 2017. Use the information presented in the annual reports and company's website, and answer the following questions: Part I: Provide a brief, 1-page, overview of the company including vision and mission, products/services, and market segments/shares. Part II: Create a MS Excel spreadsheet to calculate the following ratios for 2019, 2018 and 2017: - Current ratio - Accounts receivable turnover - Average collection period - Return on common shareholders' equity - Return on assets -Profit margin - Asset turnover - Earnings per share - Debt to assets ratio - Times interest earned Part III: Based on your calculations in Part II, use the intracompany comparisons approach and analyze the company's overall financial situation. Break your analysis into an evaluation of the firm's liquidity, profitability and solvency. Provide an overall conclusion Part IV: Based on your findings in Part III, would you consider working for this company? Why or why not? Deliverables: 1. One Word document containing a. Cover page b. Company overview section (1 page) c. Company analysis section (2-3 pages) d. Career inspiration section (1 page) c. References (1 page) 2. One Excel spreadsheet containing: a. Cover page - as a separate tab b. Key inputs - as a separate tab - please use the following format: c. Key Ratios - as a separate tab - make sure to use the cell references from the Key Inputs tab Requirements: Your group is assigned to research and analyze the financial performance of Company Name. Through the company's website, download and review the annual reports for 2019, 2018 and 2017. Use the information presented in the annual reports and company's website, and answer the following questions: Part I: Provide a brief, 1-page, overview of the company including vision and mission, products/services, and market segments/shares. Part II: Create a MS Excel spreadsheet to calculate the following ratios for 2019, 2018 and 2017: - Current ratio - Accounts receivable turnover - Average collection period - Return on common shareholders' equity - Return on assets -Profit margin - Asset turnover - Earnings per share - Debt to assets ratio - Times interest earned Part III: Based on your calculations in Part II, use the intracompany comparisons approach and analyze the company's overall financial situation. Break your analysis into an evaluation of the firm's liquidity, profitability and solvency. Provide an overall conclusion Part IV: Based on your findings in Part III, would you consider working for this company? Why or why not? Deliverables: 1. One Word document containing a. Cover page b. Company overview section (1 page) c. Company analysis section (2-3 pages) d. Career inspiration section (1 page) c. References (1 page) 2. One Excel spreadsheet containing: a. Cover page - as a separate tab b. Key inputs - as a separate tab - please use the following format: c. Key Ratios - as a separate tab - make sure to use the cell references from the Key Inputs tab Fortis Inc.
Pembina Pipeline
Franco-Nevada
Metro
Ridley
Saputo
Canadian Natural Resources
Shaw Communications
Torstar
Husky Energy
Lassonde Industries
Winpak
Norbord
Atlas Gas
Alimentation Couche-Tard
Manulife Financial
Shopify
Finning International
Aecon Group
Agnico Eagle Mines
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