Question: The file banks_EMA provides selected financial data for a sample of 404 banks in the UK, Switzerland, and France. The table below lists the first
The file banks_EMA provides selected financial data for a sample of 404 banks in the UK, Switzerland, and France. The table below lists the first 10 banks from the file where each row represents an individual firm. Column ID assigns a unique identification number to each bank. Column Country codes the countries: FR (France), GB (Great Britain), and CH (Switzerland). The next two columns show the banks' total assets, measured in $'000 in 2021 and 2020 correspondingly. The first 10 rows in banks_EMA.xlsx ID Company name Country Total assets ($'000) 2021 Total assets ($'000) 2020 1 BNP PARIBAS FR 2,983,772,084 3,053,625,563 2 CREDIT AGRICOLE SA FR 2,348,962,071 2,406,417,806 3 SOCIETE GENERALE FR 1,658,635,388 1,772,427,136 4 BARCLAYS BANK PLC GB 1,426,392,440 1,422,159,894 5 CREDIT MUTUEL (COMBINED - IFRS) FR 1,223,764,439 1,253,616,915 6 GOLDMAN SACHS INTERNATIONAL GB 1,143,420,000 1,267,858,000 7 UBS AG CH 1,116,145,000 1,125,327,000 8 BPCE SA FR 1,045,376,493 1,041,734,906 9 LA BANQUE POSTALE FR 874,718,543 904,588,153 10 CREDIT SUISSE AG CH 831,833,058 933,761,924 (Fame, 2022) Use the file banks_EMA to answer the following questions. a.Add a new column titled 'Change in Assets' to the spreadsheet. In the newly created column, calculate the annual percentage change in total assets for each
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
