Financial Company Analysis , business and finance homework help

This is a Cumbersome Project, That will require Time and Attention to Detail. 

 

I need a Financial Company Analysis Report. 

Company: CATerpillar Inc.

Project Requirement.

The course project will require each student to complete a thorough financial analysis of an assigned publicly traded corporation. The project deliverables will be:

  •  Structured Word Document (not a PDF) in proper APA Format. 

  •   Supporting Excel spreadsheets including formulas and calculations.

     Project requirements must include the following analysis:

  1. Description of the corporation: its products, markets, subsidiaries (if any), risks, public highlights, and financial highlights. (Aprox, a page or two)

  2. Overall trend assessment of the company’s balance sheet and income statement for the last three to five years. Including graphs and/or charts receives preferred grading. ( A page)

  3. Provide ratios fully calculated using your assigned corporations actual balance sheet and income statement data within formulas in excel. Also provide an analysis discussion of the same ratio trends (3 page “text” minimum) included in a word document. Ratio categories must include:

    1. Short Term Solvency aka Liquidity

    2. Long Term Solvency aka Financial Leverage

    3. Asset Management aka Turnover

    4. Profitability

    5. Market Value

    Select and analyze at least three ratios from each category, 15 ratios minimum. A three-year ratio analysis is the minimum expectation. A five-year analysis receives preferred grading.

    Trend analysis of the company’s stock price, PE ratio, and EPS trends for the last three to five years with comparisons of each to competitors.

    Evaluation of the firm’s posted Beta (do not calculate Beta, it will be posted in financial websites such as money.msn.com online) in relation to competitors.

    Assessment of the firm’s capital structure (D/E Ratio) including any significant changes in the firm’s capital structure over the last three to five years. (Continued on next page)

Excel calculation of the WACC (weighted average cost of capital) including independent calculations of each of the following variables. Cost of Equity using both the SML (aka CAPM) Approach and the Dividend Growth Model Approach with a discussion explaining which approach you prefer for WACC and why (Section 14.2 of the text provides advantages and disadvantages for each approach). All of these variables are defined in Chapter 14. There is an Eastman Chemical WACC calculation example on pages 468 – 471 in the text.

WACC = (E/V)*Re + (P/V)*Rp + (D/V)*Rd * (1-Tc)

 
 
 

4. Assessment of the firm’s statement of cash flows and determination of the firm’s free cash flow over the last three to five years. (1-2 Pages)
5. Closing summary of the firm’s financial health in relation to the overall economy and within its industry. In your own words explain why or why not someone should invest in this firm. Show current analyst recommendations as a guide with a discussion of supporting facts and financial data. (Approx. 2 Pages)

Key Factors

  1. Financial analysis Word file is to be a minimum 10 pages in length as

    outlined in the rubric below. The cover page and supporting reference appendices are not included in the 10 page minimum. Page minimums are written text not including charts, graphs, tables, or other images.

  2. APA Paper Format: including but not limited to proper APA headers, proper APA page numbers, and APA references with hanging indent.

  3. Supporting financial data will be prepared using Excel, including mathematical formulas within the cells. The Excel data must be clearly referenced as appendices in the related written discussion in the Word file.

  4. Additional materials such as graphs, charts, maps, etc. add clarity and will earn preferred grading. Small items are to be nested within the discussion. Large reference materials will be included as properly referenced APA appendices. Appendix A contains the income statement, balance sheet, and statement of cash flows. Appendix B contains the ratio analysis. Appendix C has the full WACC calculation with Cost of Equity using both the CAPM and the Dividend Growth Model. Additional appendices are OK.

  5. Reference page includes all references cited within the paper using APA format including hanging indent for references. Safe Assign will be used to ensure proper citing of academic references.

Note: That is the project and its requirements. Finance, Accounting Tutors Preferred. Attached are two sample Financial Analysis reports along with the rubric for further clarification. Read Carefully, and Preferred grading get you additional tip. Thanks. 

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"