Accounting Question

1. Group work (GWS): 100 marks, 10% weighting.Use Orbis database to collect available data on BARCLAYS BANK UK PLC, OrbisID: 249727602.Use USD (in thousands) as the unit of currency. No need to exchange USD to GBP.a. Present the Balance Sheet and Income Statement data for 2022, 2021, and 2020.[40 marks]b. Calculate the accounting ratios of bank performance and other relevant ratios thatcan be calculated from the data, and present the results in a Table. The formulas ofthese ratios can be found in lecture and seminar materials.In your Excel spreadsheet, for each cell of calculation, you need to show details ofworkings in each cell, not just the final value of your calculation. In other words,the cell contains formulas if we click on it.[60 marks]2. Individual assessment (REP): 100 marks, 20% weighting.a. Analyse the performance of BARCLAYS BANK UK PLC over these three yearsby using the data collected.Instructions: You need to include the Result Table of the accounting ratios that yourgroup presents in Question 1b. You need to refer to these ratios in your bankperformance analysis.[50 marks]b. Critically discuss how this bank can increase its profit margin. Refer to the data andthe banking literature where appropriate.[50 marks]

Please check the File attached.

Bank Financial Management- Group Written Assessment and Report Instructions:
– The weight for this assessment is 30% of the total mark for the module. This 30% weight is further split
into: 10% for a group written assessment (GWS) and 20% for an individual assessment (REP). – Each
group is formed of 2 to 3 students.
– This coursework consists of two questions/parts (group work and individual report assessment).
Candidates must attempt BOTH questions/parts.
– Your answer to each question should INCLUDE the full references of the articles, books and other
sources cited. There must be citations in text where appropriate. You can present the references at the
end of your answer and discussion to each question. Harvard referencing style is preferred. – The word
count of the project must be printed on the first page of the coursework. The maximum word count is
1200 (with ±10% of this word count). The tables, references and appendices are not included in the
word count. There is no word limit for the group written submission as only data and tables are to be
presented in the main part.
– Students need to submit two separate documents using two separate links available on Canvas: one for
group work and one for the individual report.
Assessment criteria Students should refer to the School generic assessment criteria when checking the
assessment criteria/marking scheme of the report. Questions Marks availableNotes What the markers
are hoping you will show Weight Data collected and presented 40/100 Downloading and presenting the
correct balance sheet and income statement for the correct bank Knowledge and Understanding 0.4
Application 0.4 Presentation and style 0.2 Calculations 60/100 Calculate performance ratios Knowledge
and Understanding 0.4 Application 0.4 Presentation and style 0.2 Analysis 50/100 Analyse and discuss
bank performance Knowledge and Understanding 0.3 Application 0.3 Critical thinking 0.2 Reading and
Research 0.15 Presentation and style 0.05 Discussion and strategies recommendation 50/100 Critically
discuss what the question asks Knowledge and Understanding 0.3 Application 0.3 Critical thinking 0.2
Reading and Research 0.15 Presentation and style 0.05.
1. Group work (GWS): 100 marks, 10% weighting. Use Orbis database to collect available data on
BARCLAYS BANK UK PLC, Orbis ID: 249727602. Use USD (in thousands) as the unit of currency.
No need to exchange USD to GBP. a. Present the Balance Sheet and Income Statement data for
2022, 2021, and 2020. [40 marks] b. Calculate the accounting ratios of bank performance and
other relevant ratios that can be calculated from the data, and present the results in a Table. The
formulas of these ratios can be found in lecture and seminar materials. In your Excel
spreadsheet, for each cell of calculation, you need to show details of workings in each cell, not
just the final value of your calculation. In other words, the cell contains formulas if we click on it.
[60 marks].
2. Individual assessment (REP): 100 marks, 20% weighting. a. Analyse the performance of
BARCLAYS BANK UK PLC over these three years by using the data collected. Instructions: You
need to include the Result Table of the accounting ratios that your group presents in Question
1b. You need to refer to these ratios in your bank performance analysis. [50 marks] b. Critically
discuss how this bank can increase its profit margin. Refer to the data and the banking
literature where appropriate. [50 marks]
.