代写ASB-3525 – BANK MANAGEMENT ASSIGNMENT (SEMESTER 2, 2023/24)帮做R编程

ASB-3525 – BANK MANAGEMENT ASSIGNMENT (SEMESTER 2, 2023/24)

(20% of total module mark)

SUBMISSION DEADLINE – 23:59 15TH APRIL 2024

Please submit an electronic copy ONLY via Turnitin

You are reminded not to copy material from any sources without properly referencing it, as this constitutes plagiarism: cases of plagiarism will be referred to the Business School Academic Integrity Officer and will be subject to a deduction of marks, which can result in an overall mark of 0%.

Background

You have to apply the skills you have learnt during Lecture 1, Lecture 2, Lecture 3 and Lecture 4 to answer the assignment question.  You must answer all your questions (part1, part2 and part3) in one document (i.e. Word) and you can provide screenshots or copy and paste your working from Excel into the document to support your answer.  Your answers need to be clear and concise.

The total word limit for the report is 1,000 words.

All data required to complete the assignment is provided below.

Assignment

PART 1 (worth 20% of the total assignment marks)

A senior bank manager has asked you to analyse the profitability of selected customer relationships.  The procedure is to estimate the total expense associated with account activity and compare this with projected revenues.  Data from Table 1 can be used to answer the questions in Part A and Part B.

A. The typical low-balance customer at your bank with an average monthly demand deposit balance under £175 exhibits the following monthly activity: 30 withdrawals (8 electronic), two transit checks deposited, one transit check cashed, two deposits (one electronic), and one on-us check cashed per month.  Assume there is one account maintenance for an account in which checks are not returned and that net indirect expenses apply.

Use the unit cost data to estimate the average monthly expense for the bank to service this account.

Suppose the bank can earn an average 5.8 per cent annually on investable deposits (ledger balances minus float minus required reserves). The typical customer keeps an average monthly balance net of float equal to £112 in the account and pays a £3.23 monthly service charge.  The bank must hold 10 per cent required reserves against the average balance and thus can invest 90 per cent of the balance.  Determine whether the account is profitable for the bank.

B. The typical interest-checking account customer at your bank maintains a monthly balance of £1,150 net of float, writes 34 checks or withdrawals (21 electronic), deposits four transit checks, cashes two transit checks, makes two deposits (one electronic), and cashes one on-us check per month.  Assume there is one account maintenance for an account in which checks are not returned and that net indirect expenses apply. Interest is paid on the account at an annual 1.5 percent rate. Use the unit cost information to determine whether this account is profitable. Assume the bank collects no service charges and can again earn 4.5 percent on investable balances net of 10 percent required reserves.

PART 2 (worth 30% of the total assignment marks)

The senior bank manager has also asked you to calculate forecasted weighted marginal cost of funds Table 2 provides information that can be used to estimate Bangor Local Bank’s weighted marginal cost of funds.  The estimates represent a best-guess forecast of the funding sources and associated costs for the year.  Calculate the bank’s forecasted weighted marginal cost of funds.

Discuss how a bank’s core deposits differ from its wholesale liabilities in terms of interest elasticity. What factors are relatively more important for attracting and retaining core deposits as compared with purchased funds?

PART 3 (worth 50% of the total assignment marks)

Explain the objectives of a bank’s contingency funding plan and describe what it includes.