Reference no: EM133397702

Question: Using the information you obtained last week, complete Part 2: Financial Overview portion of the case study report and submit it as an attachment here. Note that as stated in the document framework, your Financial Overview should contain: The Income Statement and Balance Sheet for the company. This should be downloaded into Excel and formatted for easy reading and reference. A Sales and Income Record, to include sales and net income figures for 5 years--20xx-20xx and a graph displaying the trends. Comments on the Sales and Income Record. A list of the company's major expenses for FY 20xx-the last available year and a pie chart showing the Expense Distribution. Comments on the expense distribution. A list of the company's major assets for FY 20xx-the last available year and a pie chart showing the Assets Distribution. Comments on the assets distribution. The asset categories listed in the document framework are more appropriate for manufacturing companies. If your case company is a service company, you can change the categories listed to better reflect the case company's assets. A list of the company's major capital accounts for FY 20xx-the last available year and a pie chart showing the Capital Structure. Comments on the capital structure. You may submit the financial statements in a separate file from the others if it helps with formatting. Please include all the records, graphs, and comments in one Excel file sheet, and not on different tabs. The reader should be able to scroll through the report from top to bottom and it should be formatted for printing . It is ok if you put submit your results in Word but your work in Excel (tables and graphs) must be submitted as well. In summary, for your submission: 1. Your completed part 2 of the case study (see the framework) in Excel or in Word. 2. Your tables and graphs in Excel. 3. The financial statements in Excel. They can be in one Excel file or separate files