Need help with this case study

1a_Case_MatchingTheCompanyProfiles-A_Profiles.pdf (247.0 KB)

1b_CaseAnnexure_CommonSizeBS.xlsx (60.5 KB)

guys if anyone can help me with that it would be a great help .
I have understood only about 5 company but it is tough to understand about all the remaining companies .