The data below has been extracted from the financial statements of Barclays Bank Plc for a 10-year period [2004-2013]

The data below has been extracted from the financial statements of Barclays Bank Plc for a 10-year period [2004-2013]

Order Description

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.

Assignment Question:
The data below has been extracted from the financial statements of Barclays Bank Plc for a 10-year period [2004-2013]

Year    RSF(%)    ROCE(%)    RTA(%)    LQR(X)    ADMIN EXP(£’m)    PAIT (£’m)    TAX (£’m)
2013    4.73    4.16    0.22    1.04    30384    963    1577
2012    0.16    0.15    0.01    1.03    18189    -723    483
2011    9.62    8.52    0.38    1.03    19447    3616    1928
2010    10.27    9.43    0.41    1.03    19967    4172    1516
2009    8.15    5.28    0.33    1.05    27142    3512    1047
2008    14.65    7.98    0.29    1.03    21100    5249    786
2007    23.79    13.36    0.58    1.03    17456    5126    1981
2006    28.31    1.26    0.72    0.33    16231    5256    1941
2005    23.43    0.99    0.57    0.36    13468    3872    1439
2004    25.24    16.23    0.88    1.04    10152    3277    1289
Source: FAME (2015), Barclay Bank Plc,  Available at: https://fame2.bvdep.com/version-201525/Report.serv?_CID=182&context=2W1YA0YV748SNF9&SeqNr=1 [Online] Accessed on 6th February, 2012 at 17:02pm
Key
RSF (%)    Return on Shareholders’ Funds
ROCE (%)    Return on Capital Employed
RTA (%)    Return on Total Assets
LQ (X)    Liquidity Ratio
ADMIN EXP    Administrative Expenses
PAIT (£’Millions)    Profit After Interest  and Tax
TAX (£’Millions)    Taxation

Required:
Task 1 : Graphs (Descriptive statistics)
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 : Correlation Analysis
Perform a correlation analysis for RSF; ROCE and RTA and examine the strength of relationship between these profitability ratios.

Task 3 : Regression Analysis
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.
Report Writing
1.  Introduction [300 words]
o    The objectives/ rationale for the assignment should be captured
o    The key highlights should be captured etc.

2.  Graphical Analysis [600 words]
o    Use relevant software tools to draw suitable graphs as specified in the Task 1
o    Discuss the nature of the relationship from the resulting graphs
o    Your discussion should be supported with some relevant literature

3.  Correlation Analysis [800 words]
o    Use relevant software to produce a correlation matrix as specified in Task 2
o    Examine the strength of relationship between the ratios
o    Use relevant literature to support your discussion

4.  Regression Analysis [800 words]
o    Use relevant software to perform the regression analysis as specified in Task 3
o    Examine the resulting model using the relevant mechanisms such as goodness of fit; significance; the model and its interpretation etc.
o    Use relevant literature to support your discussion

5.  Conclusion and Recommendations [500 words]
o    Provide a suitable conclusion and recommendation for the entire discussion
o    Ensure your conclusion represents a reflective summary for the discussion

6.  Referencing
o    Use Harvard referencing style should be strictly followed.
o    Ensure your reference list include all citations in the text and others which may not be in the text (bibliography)
o    Ensure that your references are coming from quality sources such as articles; textbooks and other peer-reviewed journals

Note: Reference List ; Tables and Figures are not part of the word count

Some Recommended Text
o    Curwin J. and Slater R. (2007) Quantitative Methods for Business Decisions, (5thedn)  Chapman& Hall

o    Wisniewski, M (2010) Quantitative Methods for Decision Makers, (5th edn) FT Prentice Hall

o    Lucey T (2002) Quantitative Techniques, Thomson Learning

o    Oakshott L (2006),Essential Quantitative Methods for Business, Management and Finance, (3ndedn) Palgrave Macmillan

o    Swift, L, Piff, S. (2010) Quantitative Methods for Business, Management and Finance, (3rd end) Palgrave

o     Field, A. (2009). Discovering statistics using SPSS. Sage publications.

o    Sekaran, U. (2006). Research methods for business: A skill building approach. John Wiley & Sons.

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 10% with the discount code tCPCOVID10