Assignment Question: The data below has been extracted from the financial statements of Barclays Bank Plc for a 10-year period [2004-2013]
Task 1: Use relevant graphs to represent each of the following and examine them:
(i) RSF ; ROCE and RTA
(ii) ROCE and LQR
(iii) Admin Exp. And PAIT
(iv) PAIT and Tax
Task 2:Perform a correlation analysis for RSF; ROCE and RTA and examine the strength of relationship between these profitability ratios.
Task 3: Using profit after interest and tax (PAIT) as the dependent variable, perform a linear regression analysis with administrative expenses and amount paid for the year as tax obligation as the explanatory variables.