Credit Analysis and Lending Management
Exercise 1:
Sharjah Book shop Company sells books. The average selling price for a book is 280 AED. The company Fixed costs of 100,000 AED per year and a variable cost of 120 AED per book. Sharjah Book shop Company submitted last week a loan application to Sharjah Islamic Bank. Loan amount is equal to 200,000 Aed payable over 5 years. Each year the company would pay back 56,000 Aed as annual instalment (including principal and interest). Moreover, the depreciation of the company assets per year is equal to 10,000 Aed.
Question 1- Calculate the cash breakeven point of Sharjah Book shop Company.
Question 2- As a lending officer in Sharjah Islamic Bank, would you accept the loan if the minimum acceptable cash breakeven point in the bookshop industry is 20,000 Aed?
Exercise 2:
Salem is willing to invest in van worth $9,000 to do transportation. If the cash inflows of a van are expected to be $3,000 annually for four years (Horizon of investment). Its annual depreciation expense will be $9,000/4 = $2,250 and its annual cash expenses = $500.
Question 1- Calculate the ARR for the Van business.
Question 2- As a lending officer in Sharjah Islamic Bank, would you accept the loan application if the minimum acceptable ARR of the Van business is 7%?
Exercise 3:
Read the comparative balance sheets and the income statements of the firm ‘Imaginary Computers Limited'. Use the techniques of financial statements analysis as explained in the chapter to do the following:
Question 1- Complete the missing values (titles, formulas) in the table below. Note that some ratios could not be calculated as relevant data are not available.
Question 2- Comment on each financial ratio (trends and comparison with industry average)
Question 3- Write a paragraph summarizing the financial strengths and weaknesses of the firm.
Imaginary Computers Ltd.
Balance sheet
as at 31 December ($ ‘000)
|
|
2019
|
2020
|
2021
|
|
Share capital
|
5.3
|
7.5
|
8.5
|
|
Reserves and surplus
|
6.7
|
5.7
|
7.4
|
|
Long-term debt
|
4.1
|
3.2
|
4.2
|
|
Notes payable - Short term
|
5.6
|
5.2
|
7.2
|
|
Accounts payable
|
3.4
|
6.5
|
5.6
|
|
Total Liabilities and Equity
|
25.1
|
28.1
|
32.9
|
|
Net fixed assets
|
17.4
|
21.8
|
26.1
|
|
Cash at bank
|
2.6
|
0.8
|
1.2
|
|
Receivables
|
3.5
|
2.8
|
2.9
|
|
Inventory
|
1.6
|
2.7
|
2.7
|
|
Total Assets
|
25.1
|
28.1
|
32.9
|
Income statement
for the year ending 31 December ($ ‘000)
|
|
2019
|
2020
|
2021
|
|
Net Sales
|
29.8
|
34.9
|
57.4
|
|
Cost of goods sold
|
24.5
|
26.2
|
45.8
|
|
Gross Profit
|
5.3
|
8.7
|
11.6
|
|
|
2019
|
2020
|
2021
|
|
Operating Expenses
|
3.7
|
4.2
|
7.0
|
|
Operating profit
|
1.6
|
4.5
|
4.6
|
|
Non-operating surplus/deficit
|
0.2
|
0.1
|
0.4
|
|
EBIT
|
1.8
|
4.6
|
5.0
|
|
Interest
|
1.0
|
0.9
|
2.0
|
|
Profit before tax
|
0.8
|
3.5
|
3.0
|
|
Tax
|
|
0.6
|
-
|
|
Net Profit
|
0.8
|
2.9
|
3.0
|
|
Dividends
|
0.6
|
0.6
|
1.1
|
|
Retained earnings
|
0.2
|
2.3
|
1.9
|