ratio analysis and excel project

/in /by

THIS ALL WHAT NEEDED IN THE PROJECT

1. Overview. In a paragraph, describe the industry in which your company operates.

2. ) Ratios. Present the following for your company using the most recent three years available on Bloomberg (use a table format): Quick Ratio Current Ratio Total Asset Turnover Inventory Turnover Profit Margin Return on Assets Return on Equity Total Debt to Equity PE Ratio Market Capitalization

3. Ratio Analysis. For the following three ratios, briefly indicate the meaning of the values you found in #2 and the trend for the company over the three year period. A) Inventory Turnover, B) Profit Margin, C) Return on Assets.

4. Comparison to Competitor. How does your company compare to its competitors in terms of liquidity, use of leverage, efficiency, profitability, and shareholder value?

5. DuPont Analysis. Complete a DuPont analysis of your company and discuss its outcome. Using the DuPont Analysis data, write a brief (one paragraph) statement to the CEO of your company indicating the strengths and weaknesses of your company, and suggesting some actions that can be taken to improve the weaknesses.

6. Company Trend. In Excel, create a line chart to show the company’s performance for profit margin over the last three year period. Appropriately label and title the chart.

7. Competitors’ Trend. In Excel, create a line chart to show the competitors’ performance for profit margin over the last three year period. Appropriately label and title the chart.

8. Competitor Comparison. In Excel, create a columnar bar chart to highlight a comparison between the company and all competitors for the percentage of debt in the firm’s capital structure in 2017

9. Including a Text Box. In Excel, create a text box where you will write a brief summary for management in which you explain the trend in company performance and the comparison to competitors by referring to the charts you have created. Format the document so that all items print on one page. Landscape and portrait print are equally acceptable. Graded for grammar.


Company: Target, Inc.

Competitor: Walmart, Inc.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.