Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Choose a publicly traded company. Download the latest available financial reports (balance sheet, income statement, statement of cash flows, and statement of owners' equity). CLO1,

Choose a publicly traded company. Download the latest available financial reports (balance sheet, income statement, statement of cash flows, and statement of owners' equity). CLO1, CLO2, CLO3, CLO4 Activities: Draw two (2) graphs either on paper or in Excel. On the X-axis write the "Years for the past three to five years (i.e. 2008, 2009, 2010, 2011, 2012, PLUS your forecast shown in dotted lines for 2013 and 2014) , and on the Y-axis write dollar ($) amounts for the following: On GRAPH 1 (CLO1, and CLO2) Sales (either Total Sales, or Net Sales) and COGS (Cost of Goods Sold) On GRAPH 2 (CLO3, CLO4, CLO5) Net Income (also referred to as Net Profit, or the bottom line) Calculate the annualized percentage change in Sales over the last three (3) to five (5) years. (CLO2) Carry out "horizontal and "vertical analysis on the balance sheet and financial statement for the last two consecutive years. On each line indicate if the entry has improved, stayed the same, or deteriorated. For example if "sales has increased by ten (10%) that is an improvement. But if COGS increased by twenty (20) percent that might be a bad sign unless there are other reasons. (CLO2) Calculate twenty different ratio analysis for the last two consecutive years and indicate if each ratio has improved, stayed the same, or deteriorated. See Exhibit 13.16 in textbook and/or (CLO1, CLO3) Average annual P/E ratio of the company over the past three to five years. (CLO3) SUMMARY in APA Format - What is your overall opinion about the strength and weaknesses of this company's sales, profitability, future stock price, risk, and growth rate. Please explain and validate your comments by providing clear and explicit numbers and reasons. (CLO3, CLO4, CLO6) Would you buy the shares of this company for yourself, and why?

NOTE: PLEASE PROVIDE HORIZONTAL & VERTICAL ANALYSES. THANK YOU

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

Supply Chain Finance Solutions

Authors: Erik Hofmann, Oliver Belin

1st Edition

3642175651, 978-3642175657

More Books

Students also viewed these Finance questions