Based on the company assigned to each of you (Individual Assignment - Companies - Canada - 69.xlsx ). Deliver a write-up and the accompanying Excel spreadsheet with all your calculations The Excel spreadsheet has already been provided and you must fill it out and submit it with your assignment WA - Template - Individual Assignment.xlsx .

The write-up should contain all the information needed to understand all the points described below. Assume that you are delivering a write-up of a company to your portfolio manager.

Files MUST be named as follows:

• PDF: Name of the Company Name of Student
• Excel: Name of the Company

Write-up MUST include ALL of the following:

1. Company overview: a detailed overview of the history of the company.
   1. Description of the business
   2. In what industry they are active in
   3. In which geographies
   4. What are their main products or lines of business
   5. Who are their main customers
   6. Understand the evolution of the company, how they got to where they are today
   7. Answer the fundamental question of how they make money?
   8. Why is their product bought by its customers?
2. Industry:
   1. In what industries is it active in?
   2. Who are its strongest competitors?
   3. What are its competitive advantages (moats)?
3. Management team: brief bio on the CEO, CFO, COO
   1. CEO compensation in the past three years
4. Main shareholders
   1. Build a table with the main shareholders. Give a brief description of the top three shareholders.
   2. Insider Ownership and recent purchases/divestitures of shares by insiders
5. Brief history and bio of the founder(s)
6. Stock price chart: 10-year stock price chart
   1. Compute the return obtained by an investor if he/she would have bought the stock 10 years ago. Compute the return with and without dividends. If your company was listed within the past 10 years, then since its Initial Public Offering
   2. When did they IPO and at what price?
7. Bonds: if the Company has bonds outstanding
   1. Build a table with the following: Date of issuance, Maturity, Coupon
   2. Ratings by rating agencies
   3. Comment on the cost of debt vs. the current rate environment
8. Capital allocation: analyze the following
   1. Dividends paid to shareholders. Would the company have the funds to continue paying dividends in the future?
   2. Acquisitions: analyze and comment on the most recent acquisitions the company has made. Have those added value?
9. Perform a Financial Analysis based on the last five (5) years of the companys financial statements, comment on:
   1. Sales or revenue growth
   2. Gross profit and gross margin
   3. Net profit (income) or net losses
   4. Cash Flow From Operations
      1. Pay particular attention to working capital (inventory, A/R and A/P)
   5. Cash Flow From Investment Activities
      1. Pay particular attention to Capital Expenditures, Acquisitions of Intangibles, and, Acquisitions of other companies
   6. Cash Flow From Financial Activities
      1. Pay particular attention to dividends, equity issuances/repurchases, and debt issuances/repayments
   7. Finally, based on all this financial analysis how does it affect the stock price performance?
10. Appendix: include a snapshot of the Excel spreadsheet on your write up. Make sure is legible and readable.
11. My company name is FirstService Corporation