WE WRITE CUSTOM ACADEMIC PAPERS

100% Original, Plagiarism Free, Tailored to your instructions

Order Now!

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.

Our Service Charter

  1. Excellent Quality / 100% Plagiarism-Free

    We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
  2. Free Revisions

    We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
  3. Confidentiality / 100% No Disclosure

    We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
  4. Money Back Guarantee

    If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
  5. 24/7 Customer Support

    We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.

Excellent Quality
Zero Plagiarism
Expert Writers

Instant Quote

Subject:
Type:
Pages/Words:
Single spaced
approx 275 words per page
Urgency (Less urgent, less costly):
Level:
Currency:
Total Cost: NaN

Get 10% Off on your 1st order!