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

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