Choose the listed company in PSX(PAKISTAN STOCK EXCHANGE) and make a detail report including

1. Make 5-year list of earning per share in excel and present through graphs.

2. Make 5-year list of total expense in excel and present through graph.

3. Make 5-year list of Net Profit in excel and present through graph.

Your final submission must include:

Work sheets of Earning per share, total expense, and net profit of 5 years on excel

Work sheet of expense of individual year and comparison of 5 years on excel

Work sheet of net profit of individual year and comparison of 5 years on excel.

Write a detail report on MS-word using a proper formatting and formulas you guys learned in class must include track change, sumIF, Average IF, MAX, MIN, Average, countif, concatenate Vlookup, dropdown but not limited.

Detail report of your work on MS word include Introduction, Summary of report, summary of excel sheet, conclusion, and references.

REPORT MUST BE 10-12 PAGES