Coursework Project: Preparing a Bank Risk Assessment and Recommendations
All work is to be submitted via email.
Project submission is in the form of two (2) files, one text document called “Report” (a Word *.doc file), plus one supporting file called “Modelling” that documents your modelling work (a spreadsheet *.xls file i.e. MS Excel).
** Please note: The writer has to provide a Microsoft Excel file with the modelling work, and also a Microsoft word file with the analytical report. 2 Files
All MS Office docs need to be submitted in “2003” compatibility format.
Topic: You are a risk analyst in a large bank and must write a 3-5 page report on a real bank whose numbers you were given. The report consists of:
An introductory paragraph assessing the bank’s overall financial and risk profile, along with your recommendations for improvement (10%).
Beneath that you should include a table of headline numbers and ratios (10%),
Followed by greater amplification on the assessment of:
Asset quality and adequacy of loan loss reserves (10%),
Cost position and dividend recommendation (10%),
Pricing of loans and deposits (10%),
Quality of earnings (10%),
Capital adequacy (10%),
Liquidity and funding (10%),
Market risk and sensitivity thereto (10%), and lastly,
Operational risk (10%).
Each section, consisting of a paragraph, should also include recommendations where appropriate.
Report: Your report should have 1000 to 2000 words, excluding tables and graphs. You should give a reasoned and persuasive rationale for your recommendations, using financial measures to back up your analysis. As outlined above, there should be a table of summary financial ratios.
There could also be a table comparing your bank’s performance indicators with comparable banks, to help justify your recommendations.
Modelling: You also need to supply a file that documents your calculation work, for the major ratios. This should be a representative spreadsheet file.
The project Imagine you are the Chief Risk officer of a newly-formed bank, with a focus on corporate lending in Slovakia. The bank is largely funded by local deposits. The CEO (and so does the regulator) wants to know if sufficient capital has been allocated against assets, and what provisioning policy should be. He would also like your views on pricing of loans and deposits, so that the bank can make a decent profit while making competitive headway without excessive risk. The bank takes small positions in trading local government bonds. The CEO would also like you to assess the bank’s
VAR, as well as liquidity; to be sure no undue risks are being taken.
Following is the financial position of the bank after the first year of operations:
Assets (Euro millions)
Due from banks 93
Gross loans 460
Loan Loss reserves (LLRs) -9
Fixed Assets 35
Other Assets 47
Total Assets 860
Liabilities & Equity
Due to banks 58
Market funds 42
Other liabilities 48
Total Liabilities & Equity 860
Int income 44
Int exp -14
= Net int income 30
Trading income 2
Net fee & comm. Income 11
= Operating Income 43
Personal exp -9
Other operating income -14
= Pre-prov Income) 17
Loan Loss provisions (LLPs) -4
= P-t income 13
= Net Income 10
In addition to the above requests from the CEO, he would also like your input on measures to reduce the operational risk, and what dividend policy
The bank’s 460 million Euros gross loan book is rated as follows:
200 million Euros of BBB rated loans,
200 million Euros of BB rated loans,
50 million Euros of B rated loans
10 million of CCC rated loans. There are no collateralised loans or off-b/s items.
Securities of 200 million Euros are all invested in A-rated government bonds.
VAR = 2168 million
Loans are evenly divided between 1, 2 and 3 years maturity.
Deposits are 50% demand (due at any time), 25% in 9 months, and 25% in over 1 year.
Market debt is of 2 years maturity.
Please formulate your recommendations to the CEO. Thank you.
Place an order of a custom essay for this assignment with us now. You are guaranteed; a custom premium paper being delivered within its deadline, personalized customer support and communication with your writer through out the order preparation period.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more