Answered step by step
Verified Expert Solution
Link Copied!

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.

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

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

Step: 3

blur-text-image

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

Psychology Applied To Teaching

Authors: Jack Snowman, Rick McCown

14th Edition

1285734556, 9781285734552

More Books

Students also viewed these Accounting questions