25 May YOU HAVE BEEN ASKED TO EXPLAIN TO MANAGEMENT WHAT THESE RESULTS REVEAL ABOUT THE CBC’S INTEREST RATE EXPOSURE?
Instructions: In answering each of the questions below you should explain how you arrived at any calculated answers or show workings. Assignments must be submitted electronically via Turnitin. Please note that Turnitin will convert your file into a pdf format file, therefore your answer should be in “Word” format. Excel spreadsheets may not be converted properly by Turnitin, therefore whilst you may wish to use Excel to answer the questions, it is recommended that if you chose this approach the results of these calculations, particularly those included in the Appendix to your report, should be inserted into a “Word” document as tables.
Your answer should include a cover page (do not use the cover page template) indicating your name, student number and tutorial class and time and your tutor’s name. Your report, including the Executive Summary but excluding the cover page and the Attachment, should be no longer than 2000 words, but may be shorter. You should provide full references to sources used in your report.
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 (50 marks in total)
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.). (10 marks)
(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? (10 marks)
(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. (20 marks)
(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. (10 marks)
Question 2 (50 marks total)
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, (20 marks)
(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; (10 marks)
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.