BANK FINANCIAL MANAGEMENT ASSIGNMENT -

The Question - The Balance Sheet for Commercial Banking Company of Australia Limited (CBC) as at 28 February 2018 is shown below as Table 1. CBC is an Authorised Depository Institution in Australia and operates both retail and investment banking operations in Australia. CBC's assets and liabilities are exclusively domiciled in Australia and hence it does not have any foreign exchange risk.

You are CBC's Head of Interest Rate Management. You have identified the current market interest rates applicable to the bank's assets and liabilities and calculated the zero coupon equivalent yields using bootstrapping, and they are set out in (Table 2).

You are required to write a report addressing the questions set out below and provide your recommended strategies to manage the Bank's interest rate risks as at 28 February 2018.

The intended audience for your report is the senior management team of your bank. Your report should include an Executive Summary (of no more than one page) which means that your main points and findings are given at the start. Sub-headings in the report are a good idea to maintain structure. Your style should be professional and succinct and contain supporting reasons for your conclusions. It is essential that your answer contain supporting tables, graphs and/or diagrams and that these should be embedded/wrapped in the text. The calculations performed under Question 1 should be shown as an Appendix to your report.

Question 1 -

You have been asked to prepare a Report to Management on the current risk profile of the bank.

(a) Draw the cashflow ladder for CBC's interest rate sensitive assets and liabilities. You should use the following time buckets; Time 0 for Call or overnight exposures and then six-monthly buckets up to 4 years (e.g. 6 months, 12 months, 18 months etc.).

(b) Using the Zero-Coupon equivalent interest rates calculated from market interest rates shown, in Table 2; calculate the PVBP for each of the "time bucket" cashflows in the Cashflow Ladder and the total PVBP, for all interest rate sensitive assets and liabilities?

(c) You are required to undertake an assessment of past daily changes in interest rates for each of the "timebuckets" set out in Cashflow Ladder assuming that the assessed interest rate changes for each "timebucket" are independent i.e. uncorrelated. You have decided to base this assessment on the past six months daily changes in interest rates, i.e. from 1 September 2017 to 28 February 2018 and you are required to source the appropriate data. Note; depending on the data you have sourced, you may need to interpolate data to estimate interest rate changes for each "timebucket". A spreadsheet has been provided to assist with this process.

(i) The Bank's policy is to assess its risk using a 95% confidence level based on an assumption of that future interest rate changes are normally distributed. What is the bank's DEAR?

(ii) The Bank's policy also requires its risk to be assessed over a 10 day time horizon. What is the Bank's Value at Risk (VaR)?

(iii) You should explain the approach that you used, the assumptions that were made to obtain and derive the data and the results and any limitations that you consider exist with the approach or the methodology used. You should also include the workings for this calculation as an Appendix to your paper.

(d) You have been asked to explain to management what these results reveal about the CBC's interest rate exposure? Management also wishes to know what limitations might exist with the use of these results and what if any assumptions were used to derive the results. The explanation should also include a justification for these assumptions.

Question 2 -

The Bank's Head of Markets considers that the current monetary policy environment is such that "call" or overnight interest rates are unlikely to change from the current levels in the near term, but in the longer-term interest rates are likely to rise. This has led the Head of Markets to form the view that the yield curve is likely to steepen in the future. You have been asked to develop a strategy to manage the risks of changes in the value of the portfolio as a result of the potential future interest rate changes identified by the Head of Markets. You are also required to include the following in your Report for Management:

(a) The specific action, if any, that you would recommend be taken, which may include the use of transactions involving the derivative instruments and/or action to restructure the balance sheet,

(b) Show the impact of them on the Bank's risk profile that you have assessed in Question 1, and (20 marks); and

(c) Give the reasons why you chose the recommended strategy and, if applicable, any assumptions that you have made (and why you made them) on which to base your recommendations;

Attachment:- Assignment File.rar