Mcraefrc.weebly.com



Accounting 40S Financial Statement Analysis AssignmentLet’s take your knowledge of the information provided on financial statements and apply it to actual companies. Answer the questions on this document or put the information directly onto the PowerPoint presentation. You’ll also need to create an Excel spreadsheet to do calculations and create graphs. You will submit three documents for this assignment—a PowerPoint presentation file, the Word file (with the company “story” completed) and an Excel file. Note that I’m asking you to use the financial reports from the company’s own website but feel free to access information from finance. or other sites you find useful as well. QuestionsResponsesYour NameCompany NameProvide a link to the company’s financial statements--use the company's own site and access the 2019 reports. (2 marks)Type of business (service, merchandising, or manufacturing) Include the Sector and the Industry (2 marks)Describe the products/services the company provides it its customers. (2 marks)Discuss how/why the products/services offered have determined the impact of COVID 19 on the company’s financial statements. (3 marks)Who is the chief executive officer (CEO) of the company? (1 mark)Who is the auditing firm for the company? (1 mark)Who are some of the company’s competitors? (2 marks)Choose a headline about the company—a recent news item about the company—and provide the link and a brief summary of the item. (3 marks)20192018Net income during the period (2 marks)Calculate the percentage change from the two yearsFormula:Difference / previous period (2 marks)Create a graph comparing Net Income for 3 years* (5 marks)Calculate:Current YearPrevious YearReturn on Sales (3 marks)Formula:Net Income / Net Sales (Revenue)Explanation of what this tells the companyReturn on Total Assets (3 marks)Formula:Net Income / Average Total Assets(Add the total assets for the two operating quarters and divide by two to get the average)Explanation of what this tells the companyReturn on Equity (3 marks)Net Income/Average Owner’s EquityExplanation of what this tells the companyCreate a graph comparing Total Assets, Liabilities and Shareholder’s Equity for 3 years (5 marks)Calculate:20192018Current ratio (3 marks)Formula:Current Assets / Current LiabilitiesExplanation of what this tells the companyQuick ratio (3 marks)Formula:Cash + Short-term investments + Net Accounts Receivables / Current LiabilitiesExplanation of what this tells the companyCreate a graph comparing operating cash flows for 3 years (5 marks)Total MarksOut of 50Complete the “business’s story” by filling in the blanks with information from the financial statements you prepared (click in the box and replace the words with your answer)—5 marks.376237547625$ amount00$ amount112395029845Company Name00Company NameAt March 31, 2020 had assets totaling in use for the purpose of generating a return for the owners (shareholders).3981450764540$ amount00$ amount733425371475%00%34861508890$ amount00$ amount0-635Company Name00Company Name partially funded those assets with of debt which equates to of the total asset value.134302519050%00%The remaining portion of the assets in the amount of was funded by the shareholders.48672759525$ amount00$ amount5334009525Company Name00Company NameIn May, generated value for its shareholders by earning in revenue.1885950-24130Company Name00Company Nameleft342265$ amount 00$ amount In order to generate those sales, sacrificed (gave up) value by utilizing of resources as expenses.…. 695325685800$ amount00$ amount2543175332740$ amount00$ amount42005258890$ amount00$ amount…..resulting in Net Income/ Net Loss (highlight the applicable answer) of which is reflected in the Retained Earnings , which takes into account a dividend of .*Instructions for creating a graph:Using Excel, copy the Net Income (Loss) amounts for the years shown. Rekey the numbers (for some reason Excel doesn’t recognize the copied amounts as numbers)Select the data to include on the graph and then Insert ChartChoose the type of graph that you think best represents the data you’re using: Column or Bar Chart; Line Graph; etc.Right click and Move the chart as an Object on a New Sheet—be sure to include axis labels and a title on the chartCompany AssignmentsStudentCompany3MAmerican ExpressApple Inc.BoeingCaterpillarChevronCoca ColaDisneyDow Inc.Home DepotIBM CorporationIntelJohnson & JohnsonMcDonald’sMerckMicrosoftNikePepsiPfizerProcter and GambleUnited HealthVerizonVisaWalgreensWal-Mart ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download