Bank Bid Analysis Worksheet

I will attach three files. One is the Analysis worksheet that needs to be done using information from the initial bid paper and the excel with the balance sheets and income statements. That bank im required to analys is BANK B and only bank B. Please use the information and the correct formulas to complete the analysis. I will reply to any questions.