Just send an excel file

Bank A ESF & Cash Treasury Bonds L+E AUD 80 AUD 100.00 Deposits (all other AUD 920 AUD 100.00 Deposits (Axel) customers) FX, 10 USD, AUD/USDO.78 Loans AUD 12.82 AUD 1000.00 a) Copy the above balance sheet into your script and add the missing component. (2 marks) b) Show how each of the following transactions affect the above balance sheet. Axel transfers AUD 80 to Bill (who has an account at another bank). The bank collects AUD 20 interest (all borrowers have an account at the bank with sufficient funds). The exchange rate changes to AUD/USD 0.80 (Hint: What happened to the value of the AUD? USD? Does the bank make a profit or loss?) (6 marks) c) Analyze the new balance sheet and name which type of risk is now this bank's major concern. (2 marks)