Answered step by step
Verified Expert Solution
Link Copied!

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:
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
image text in transcribed
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

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_2

Step: 3

blur-text-image_3

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

Warren Buffett Accounting Book Reading Financial Statements For Value Investing

Authors: Stig Brodersen, Preston Pysh

1st Edition

1939370159, 9781939370150

More Books

Students also viewed these Accounting questions