Financial Analysis Assignment Description

Financial Analysis Assignment Description

ASSIGNMENT OVERVIEW

You will do a financial analysis FOR Clorox Company . Do not rely on the company’s annual report since it is nothing other than a marketing tool. The primary emphasis of this analysis is corporate finance complimented by accounting and economics. I want your writing to be succinct, terse and exact and be no more than five (5) well written pages not including title page, executive summary, appendices, and bibliography. However, you can have as many appendices as it takes to support your position.You will have no more than 10% duplication writing of your paper.

• Must follow the APA format
• Make sure your pro forma statements balance. For example, your end of year cash in the cash flow statement must equal your cash and equivalent in your pro forma balance sheet.

1) Accounting Component

1. a) Obtain the most recent ten years of annual total sales (total revenue) data from the firm’s financial history. In addition, use just the last three years for the firm’s financial statement data: I recommend you use abbreviated financial statements. They can be found in Nasdaq.com, Yahoo Finance, MSN Money. DO NOT GET BOGGED DOWN IN THE DETAILED OF THE AGGREGATE FINANCIALS i) Income Statement ii) Balance Sheet iii) Statement of Cash Flow

1. b) Derive common size statements for the income statement and the balance sheet NOT the cash flow i) Looking at trends in the data 9 ii) Looking at variations in the same data as well as variations in the trends

2) General Component

1. a) No more than one paragraph describing the history and industry of the company.

3) Economic Component

1. a) How does the above relate to the industry that the company is in, i.e. need to perform competitive economic analysis about the company: i) Macroeconomic analysis—-is the company’s sales cyclical or counter cyclical for example? ii) Industry analysis—market share. Are the company’s sales growing, declining, or staying the same? How is the company performing relative to its competition?

4) SWOT

1. a) STRENGTHS and WEAKNESSES should focus EXCLUSIVELY on the INTERNAL CHARACTERISTICS OF THE FIRM’S FINANCES.
2. b) The OPPORTUNITIES and THREATS should focus EXCLUSIVELY on the EXTERNAL CHARACTERISTICS OF THE FIRM’S FINANCES.

5) Trends and Deviations in the company’s historical data

6) Finance Component

1. a) The PERCENT OF SALES MODEL and the above should provide you the assumptions for deriving proformas for each of the three financial statements (balance sheet, income statement, and statement of cash flow), and will allow you to do your critical financial analysis of the firm. i) The pro forma, must be forecasted out three years. ii) Make sure you focus on your assumptions and EXPLICITLY show them since they will drive your forecasted data, which will allow you to perform the critical analysis where the company is going, based on your forecasted data INCLUDING THE FORECASTED SHARE PRICES. 10 iii) This should be the focus of your written analysis; stated differently, the focus needs to be on the future of your company and where it is going and why.
2. b) The emphasis should not be on the history of the company, other than what I have asked you to include, that is stated above.
3. c) Finally, in your analysis you need to justify your conclusions. For example, is the company in a strong financial position based on its EXPECTED SHARE PRICES and MARKET CAPITALIZATION? Why or why not? What direction does the company need to go in either case? These are some of the questions that need answered.

7) Final Submission Format

1. a) Executive Summary
2. b) Introduction i. One paragraph history of the firm ii. Problem Statement—–Is the firm financially viable?
3. c) Review of Literature Newspapers ii. Periodicals iii. Etc.
4. d) Structural Framework—Estimation of sales (revenue) forecast using your data i. Regression Analysis ii. Alternative Estimation Techniques iii. Derivation of Proformas—Balance Sheet, Income Statement, Cash Flow through the PERCENT OF SALES MODEL
5. e) Analysis of your findings Using your historical data from your financial statements and common-size financial statements 11 ii. Using your forecast data from your pro-forma financial statements and other information such as economic value added, free cash flow, intrinsic value, return on invested capital to name a few examples that can help in your analysis
6. f) Summary and conclusions
7. g) Appendix Tables ii. Graphs iii. Other

h) Additional Requirements i. Use the APA format—Full Documentation, which includes explicitly identifying others works. ii. NO CUTTING AND PASTING iii. Title page iv. Executive Summary v. Maximum of five (5) written pages, does not include title page, executive summary or appendences—tables etc. go into