Project
Use data from your Ratio Analysis Project
(1) 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
(2) 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
(3) Competitor Comparison In Excel, create a columnar bar chart to highlight a comparison between the company and all competitor fo6r the percentage of debt in the firm's capital structure in 2013.
(4) 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 .