**Assignment Task**

**1. Bank Performance**

You are a Research Analyst for Griffith Global Capital Partners and you have been asked to analyse Gold Coast Bank. You are required to:

Complete the Income StatementCalculate the specified ratio

**Income Statement Items**

**£ million**

Interest on reverse REPOs

10.00

Interest – federal funds purchased

14.00

Interest on mortgage loans

135.00

Overhead expenses

4.00

Fee for securitization of mortgage assets

12.00

Fee for liquidity enhancement of securitized assets

5.00

Employee wages, salaries, and benefits

35.00

Interest – clients with time and savings deposits

90.00

a. Insert the following items into the Income Statement and calculate the missing numbers:

b. Given your calculation in part a) and the information below, calculate the following ratios for the bank:

**Balance Sheet (averages over last two years)**

**£ million**

Cash

73.00

Investment securities

77.00

Reverse repurchase agreements

53.00

Commercial & industrial loans

38.00

Consumer & instalment loans

30.00

Mortgage loans

628.00

Plant and equipment

44.00

Goodwill and other intangibles

57.00

**Total assets**

**1000.00**

Demand deposits

0.00

Time and savings deposits

512.00

Federal funds purchased

80.00

Repurchase agreements

55.00

Other borrowed funds

95.00

Subordinated debt

123.00

Limited life preferred stock

90.00

**Total liabilities**

**955.00**

Common stock

15.00

Surplus

18.00

Retained earnings

8.00

Perpetual preferred stock

4.00

**Total Capital**

**45.00**

**Total Liabilities and Capital**

**1000.00**

**2. Repricing Gap**

Assets, in M$

Liabilities and Equity, in M$

T-notes (3 months) $90

Interest-paying demand deposits $50

Short-term Loans (9 months) $30

Bank accepted bills (8 months) $100

Bonds (2 years) $80

Equity: $50

Total assets: $200

Total liabilities and equity: $200

1. Calculate repricing gap.

2. Calculate incremental and cumulative gap for 6-12 months maturity bucket.

3. Calculate the impact on net interest income of 100 b.p. increase in interest rates for (i) incremental gap in 0-6 months maturity bucket; (ii) incremental gap in 6-12 months maturity bucket.

4. What is the interest rate exposure for cumulative gaps in 0-3 month’s maturity bucket and 3-12 months maturity bucket?

**3. Credit Risk Management**

3.1. ** **You are analysing a loan application from your client. Base lending rate in the bank is 6%, credit risk premium is 2%, loan origination fee is 20b.p., compensating balance is equal to 10% and reserve requirement with a central bank is 8%.

Calculate contractually promised return on this spot loan.Calculate contractually return on the loan commitment if the back-end fee is 35 b.p. and drawdown rate is 70%.

3.2. New loan application from the bank’s customer. Its financial ratios are EBIT/Total assets = 3%, MV of equity /BV of debt = 0.5, working capital to total assets =12%, sales to total assets = 1.5, earnings to total assets = 1%. Using Altman’s discriminant model:

Calculate Z-score?Decide whether to approve or reject the application. Briefly explain.

3.3. Assume the loan application. Loan probability of default equals to 5%, recovery rate if defaulted is 60%, risk-free rate is 4.5%.

Estimate required (expected) return on loan;Calculate risk premium

**4. Liquidity management**

1. Assume unexpected deposit withdrawal of $10M. Show the impact on the bank balance sheet if the following liquidity solution is used: (a) stored liquidity; (b) purchased liquidity.

Assets, in M$

Liabilities and Equity, in M$

Cash $10

Deposits $70

Securities $10

Borrowed funds $10

Other assets $80

Equity: $20

Total assets: $100

Total L+E: $100

2. Deposit earned 5% interest, securities yielded 4% p.a, mortgage loans earn 10%. Assuming scenario 1a, calculate the impact on bank’s NII and its size.

3. Assume loan commitment of $10 M is drawn upon. Show the impact on the bank balance sheet if the following liquidity solution is used: (a) stored liquidity; (b) purchased liquidity.

Assets, in M$

Liabilities and Equity,

in M$

Cash $10

Deposits $70

Securities $10

Borrowed funds $10

Other assets $80

Equity: $20

Total assets: $100

Total L+E: $100

**5. Capital management**

Assets, in M$

Liabilities and Equity,

in M$

Cash $10

Deposits $215

Securities (AA rated, 20% weight) $30

Loan capital $7

Corporate loans (BBB rated 100%) $150

Non-cumulative perpetual shares $3

Corporate loans (B rated 150%) $50

Equity: $15

Total assets: $240

Total L+E: $240