Finance

Step 1: Choose any of the following companies for your assignment:Apple Inc. (NASDAQ: AAPL)Bed Bath & Beyond Inc. (NASDAQ: BBBY)Coach Inc. (NYSE: COH)IBM (NYSE: IBM)Step 2: Go to MergentOnline database, www.mergentonline.com to download the financial data of your company. If you are accessing thedatabase from outside the campus, you have to go through the library website, www.lib.unb.ca If you have any questions about how toextract data from MergentOnline, please consult me.Step 3: Download the O-S Checklist Excel template from the course D2L. There are seven worksheets in the template. You have to dealwith two of them, such as Data Input and Value Indicators. For example, input all the pertinent information (from Balance sheet, Incomestatement and Cash Flow statement of your company) in “Data Input” worksheet. You will see some key ratios have been calculated for youin the “Value Indicators” worksheet. For an overview of the approach, read our article, “Overcoming Cognitive Biases: A Heuristic forValue Investing Decisions,” also available on D2L.Step 4: Comment on the company whether it has durable competitive advantage (aka Wide Moat). You have to pass a judgment on this issue.You may want to consult the book, “Why Moats Matter: The Morningstar Approach to Stock Investing” by Heather Brilliant and ElizabethCollins.5 Minute QuickScanDate:Basic Quality Standards Question 2 Question 3 Question 4 Question 5 Question 6Question 7 DecisionCompany Name Ticker .OB or .PK? Mkt Cap 10%? 5 Years of Debt to Equity Ratio < 1? Recent Price to BookRatio < 2? 3 years of only positive net Tangible Assets? Keep and Conitue to Analyze or Drop Company?Bed Bath & Beyond Inc. BBBY .OB Yes No Yes Yes No Yes Yes Yes Keep the company