Tutorial 2_answers

.pdf

School

Australian National University *

*We aren’t endorsed by this school

Course

3006

Subject

Finance

Date

Apr 3, 2024

Type

pdf

Pages

5

Uploaded by xinghun88 on coursehero.com

THE AUSTRALIAN NATIONAL UNIVERSITY School of Finance, Actuarial Studies and Applied Statistics College of Business and Economics Financial Intermediation and Debt Markets Tutorial 2 - Answers Question 1 Go to the FDIC website https://www.fdic.gov/bank/statistical/ and download the December 2009 and the December 2010 call reports for Bank of America (National Association, Charlotte NC) and Citibank (N.A., Las Vegas NV) to answer the following questions. [From the page click on Central Data Repository (CDR), then select “call report”. In the search box type in the names of the bank and required dates, press enter and then download the files] a. Calculate the return on equity (ROE) for each of the banks in December 2009. Answer: ROE = net income/total equity = RIAD4340/ RCFD3210 BoA = 5,643,593/166,163,746=3.40% Citi = -2,794,000/116,599,000=-2.40% b. For each of the banks in December 2009, perform DuPont analysis and break up ROE into its component parts (i.e. return on assets, equity multiplier, net profit margin, asset utilization.) Answer: ROA = net income/total assets = RIAD4340/ RCFD2170 BoA = 5,643,593/ 1,465,221,449=0.39% Citi = -2,794,000/ 1,161,361,000=-0.24% EM = total assets/total equity = RCFD2170/ RCFD3210 BoA = 1,465,221,449/166,163,746=8.82 Citi = 1,161,361,000/116,599,000=9.96 Operating revenue = RIAD4107 + RIAD4079 BoA = 47,911,887+33,339,138 Citi = 45,788,000+12,090,000 PM = net income/operating revenue = RIAD4340/(RIAD4107 + RIAD4079) BoA = 5,643,593/(47,911,887+33,339,138)= 6.95% Citi = -2,794,000/(45,788,000+12,090,000)=-4.83%
AU = operating revenue/total assets =(RIAD4107+RIAD4079)/ RCFD2170 BoA = (47,911,887+33,339,138)/1,465,221,449=5.55% Citi = (45,788,000+12,090,000)/1,161,361,000=4.98% c. Which bank is more profitable according to these measures? Answer: BoA looks to be more profitable and is also less levered. d. Calculate the return on equity (ROE) for each of the banks in December 2010. Answer: ROE = net income/total equity = RIAD4340/ RCFD3210 BoA = 9,054,794/ 171,325,208=5.29% Citi = 7,904,000/ 127,090,000= 6.22% e. For each of the banks in December 2010, perform DuPont analysis and break up ROE into its component parts (i.e. return on assets, equity multiplier, net profit margin, asset utilization.) Answer: ROA = net income/total assets = RIAD4340/ RCFD2170 BoA = 9,054,794/ 1,482,278,257=0.61% Citi = 7,904,000/ 1,154,293,000= 0.68% EM = total assets/total equity = RCFD2170/ RCFD3210 BoA = 1,482,278,257/171,325,208=8.65 Citi = 1,154,293,000/127,090,000=9.08 Operating revenue = RIAD4107 + RIAD4079 BoA = 43,173,074+ 26,665,559=69838633 Citi = 40,820,000+ 15,545,000=56365000 PM = net income/operating revenue = RIAD4340/(RIAD4107 + RIAD4079) BoA = 9,054,794/(43,173,074+ 26,665,559)= 12.97% Citi =7,904,000/(40,820,000+ 15,545,000)= 14.02% AU = operating revenue/total assets =(RIAD4107+RIAD4079)/ RCFD2170 BoA = (43,173,074+ 26,665,559)/1,482,278,257=4.71% Citi = (40,820,000+ 15,545,000)/1,154,293,000=4.88% f. Which bank is more profitable according to these measures? Answer: Citi looks to be more profitable and is also more levered.
g. Can you explain any changes that occur over the year? Do these calculations highlight any problems with simple ratio analysis at any given point in time? Answer: In the year between December 2009 and December 2010, Citibank not only went from negative to positive profitability but it is also now more profitable than BoA. The main reasons for this significant change is that Citibank was more exposed to subprime risk (through positions in asset backed securities such as CDOs and CMOs) than BoA - which lead to massive losses on its balance sheet. As the financial system slowly recovered from the crisis, business returned to 'normal'. The analysis here shows that it is important not only to look at ratios between firms at any given point in time (cross-sectional analysis) but that it is also very important to consider changes in ratios over time (time-series analysis). h. Is this information enough to conclude that one bank is ‘better performing’ than the other? What other factors may you look at? From the call reports, can you come up with some ratios that measure these other factors that an analyst should consider? Answer: This analysis only considers the profit/return to investing in the bank. It ignores that riskiness of the bank. An important consideration is how risky the banks are relative to each other. I higher return that is generated by taking higher risks does not necessarily translate to ‘better performance’. Ideally, we would like a risk-adjusted return. Other ratios that one might look at include proxies for the riskiness of the bank including: loan charge-offs/loans; non-performing loans/loans; loan loss provisions/loans; liquid assets/liquid liabilities; interest sensitive assets/interest sensitive liabilities and so on. Question 2 Use the Quarterly Authorised Deposit-taking Institution Performance Statistics file you downloaded last week to answer the following: a. Produce a graph to compare the profit margins of the “Big 4” banks and smaller domestic banks for the 2004-2021 period. b. Produce a graph to compare the ROE of the “Big 4” banks and smaller domestic banks for the 2004-2021 period. c. Produce a graph to compare the deposits-to-assets ratio of the “Big 4” banks and smaller domestic banks for the 2004-2021 period. d. Produce a graph to compare the capital ratio of the “Big 4” banks and smaller domestic banks for the 2004-2021 period. e. Briefly comment on each of these graphs. Answer: See Excel Worksheet
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help