IMPORTANT: Please make sure you should store all relevant workings and/or calculations in a separate Excel file. I can not accept the work without an Excel file. The provided excel file includes dataset to be used for the assignmentThe file includes PL and BS accounts of 3 German, 3 British and 3 French Banks. Assignment: To analyse Deutsche Bank (DBK GR Equity) within excel document provided. You have to write a report with the following structure.Part 1 (300 words)Based on the provided accounting data, compute the Capital Adequacy and Profitability ratios (at least two ratios for each) for the last 9 years (2012-2020) for:a. the Bank you are assignedb. its main national competitors (preferably the 2 largest competitors);and itsmain competitors in the global market (2 global competitors).Show your findings in tables in your report and comment briefly about these findings, based on ratio analysis and information provided in annual reports, macroeconomic data and published news. Part 2 a. Define the degree of Liquidity Risk, Capital Risk, Interest Rate Risk and Credit Risk of the Bank you analyse based on ratio analysis (at least one ratio for each); andb. compare your bank to its main national competitors (preferably the 2 largest competitors) and its main competitors in the global market (2 global competitors) that you used on Part 1, during the period 2009-2020.Your analysis will be based on ratio analysis, the information provided in annual reports, macroeconomic data and published news.
Related Completed Projects
Write the answer of the empty box after reading the passage of Handmaids Tale by Margaret Atwood.
What is the meaning of being resilience?
Write a Discussion, you will focus on Logic and Fallacies.
How does the play deal with issues surrounding the pursuit of forbidden
knowledge and/or the conflict between knowledge and faith?