Assignment: Analysis of Leverage Ratios in Canadian Chartered Banks Objective: To understand the risk profile of Canadian chartered banks through the analysis of leverage ratios over time. Instructions: 1. Data Collection: Access historical data on total chartered bank assets, total liabilities, and shareholders' equity from the Bank of Canada's website. For total Assets, use (https://www.bankofcanada.ca/rates/banking-and-financial- statistics/historical-chartered-bank-assets-month-end-formerly-c3/). For Liabilities and Shareholders' Equity, access data through (https://www.bankofcanada.ca/rates/banking-and-financial-statistics/historical-chartered- bank-liabilities-and-shareholders-equity-month-end-formerly-c4/). Download the data in CSV format for the period from January 2011 through the most recent month available. 2. Data Preparation: Using spreadsheet software (e.g., Excel or Google Sheets), consolidate the two datasets by matching the corresponding monthly data points for total assets and shareholders' equity. Calculate the monthly leverage ratio, defined as the ratio of shareholders' equity to total assets. 3. Data Analysis and Visualization: Create a line graph that plots the leverage ratio over the specified period. Observe any trends or notable changes in the leverage ratio. 4. Discussion: Based on your findings, discuss potential implications regarding leverage and moral hazards in Canadian chartered banks. Consider how changes in leverage might reflect the banks' risk management practices and risk appetite