Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi I am looking for some help with accounting homework. Could you please let me know the time frame and the price for this project.
Hi I am looking for some help with accounting homework. Could you please let me know the time frame and the price for this project.
MBA*620*DE COMPARATIVE FINANCIAL STMT ANALYSIS PROJECT Upload to Blackboard before the deadline, Save filename as LastNameFirstName620CFA.docx (no spaces). For example, if I was saving this file, I would save it as AlinoNelson620OCFA.docx. ONLY A WORD FILE SHOULD BE SUBMITTED. YOUR NAME HERE: An important part of learning is application. To learn accounting, we must practice the skills taught and apply those skills to real world problems. To that end, we have designed a project to reinforce the lessons in each module and apply that to real companies. The goal of this project is to complete a comprehensive analysis of two (or more) companies in the same industry. We might not aspire to be an analyst or creditor, but by completing a project of this magnitude, we will have mastered financial reporting at a sufficient level to be able to step into any role in an organization. Instructions: The goal of this project is to perform vertical analysis of the balance sheet and income statement, assess cash flows, and determine market capitalization. Please show supporting calculations. Considering the recent buzz in the market regarding a potential merger and acquisition deal between CVS and Walgreens. We will use the two companies for our Comparative Financial Stmt Analysis Project. Download the annual reports for each company and peruse them. Use the SEC EDGAR Website to locate the recent Form 10-K (or other annual report such as 20-F or 40-F). Download a spreadsheet version of the financial statements. Use Appendix 1A as a guide. Required: 1. Balance sheet analysis. a. Prepare a common size balance sheet for each company. To make this easier, obtain the balance sheet in a spreadsheet such as Excel. Compare the two vertical analyses and look for major differences between the companies - some questions to consider include: b. What are each company's largest assets? Largest liabilities? c. What proportion of total assets is financed by owners? (Hint: compare with total equity.) d. What proportion of total assets is financed by nonowners? 2. Income statement analysis. a. Prepare common size income statement for each company. Express each item on the income statement as a percent of total sales or total revenue. To make this easier, obtain the income statement in a spreadsheet such as Excel. Compare the vertical analyses and look for major differences between the companies. Do any patterns March? Some questions to consider: Copyright 2015 by Cambridge Business Publishers, LLC., and Copyright 2016 by Nelson Alino. All rights reserved. Unauthorized use (including posting on websites or using information from websites such as CourseHero) is prohibited. Revised October 2016 b. c. d. e. What are the companies' major expenses? Are there any unusual or discontinued items? Are they large in magnitude? Which company is more profitable? Was each company more or less profitable when compared to the prior year? 3. Statement of cash flows analysis. a. Determine the size and direction (cash source or use) of cash flows from operations, investing, and financing. One goal is to understand each company's pattern of cash flows and to form an opinion about the general strength of their cash flows. Some questions to consider: b. What were the companies' cash flow from operations? Were they positive? c. Were operating cash flows smaller or larger than net income? d. What are the major differences between operating cash and net income? e. Did the company purchase new property and equipment (\"capital expenditures\") during the year? f. Did the company issued new debt during the year or was debt repaid? (Hint: we must sometimes add one or more line items on statement of cash flows to determine total net debt activity.) g. Did the company issued new stock? h. Did the company pay dividends? YOUR NAME HERE (again): YOUR RESPONSES SHOULD BE BELOW THIS LINE (no need to duplicate the question, just use the relevant question number): 1. a. Copyright 2015 by Cambridge Business Publishers, LLC., and Copyright 2016 by Nelson Alino. All rights reserved. Unauthorized use (including posting on websites or using information from websites such as CourseHero) is prohibited. Revised October 2016Step 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