Report on Budget & Financial Statement Analysis of the City Bank Limited (Part-2)

4.1 Budget analysis on financial statement

A Budget is a plan that outlines an organization’s financial and operational goals. So a budget may be thought of as an action plan; planning a budget helps a business allocate resources, evaluate performance, and formulate plans. While planning a budget can occur at any time, for many businesses, planning a budget is an annual task, where the past year’s budget is reviewed and budget projections are made for the next three or even five years. The basic process of planning a budget involves listing the business’s fixed and variable costs on a monthly basis and then deciding on an allocation of funds to reflect the business’s goals. Every financial organization has financial projection or business plan for the fiscal year. The City Bank also formulated a business plan for the year 2008.

Table: 02 Interest Incomes

The City Bank Ltd. Projected 4% interest earnings on their loans & advances over the actual earnings on 2007. But due to some good management of credit department they achieved 11.62% in the year 2008.

We see here in profit & loss a/c. interest income achieved well over what is projected/expected due to less income growth in Interest received from foreign banks, Loans against Imported/Murabha, Packing credit, House building loan, Lease finance/Izara, Payment against documents, cash credit/Bai-Muajjal, Consumer credit Scheme, Interest on SME, Documentary bills purchased Interest on cash incentive, Interest on call loans, Loans (General)/ Musharaka.

Though the city bank ltd. Have earned more interest on loans & advances than that of their projection, but if they want to increase their growth they have to focus on earnings from, Interest received from foreign banks, Loans against Imported/Murabha, Packing credit, House building loan, Lease finance/Izara, Payment against documents, cash credit/Bai-Muajjal, Consumer credit Scheme, Interest on SME, Documentary bills purchased Interest on cash incentive, Interest on call loans, Loans (General)/ Musharaka.

Table: 03 Interest/profit paid on deposits

On the other hand the expected interest expenses to reduce by 3.16%, but they afford to less by 2.24%. It may cause of heavy inflation during the year 2008. But as we know inflation is a systematic risk for any financial institution. So, to avoid these they have to more professionalism in making their decisions.

As we see the city bank ltd. wanted to reduce their cost on interest/profit paid on deposits by 3.16%. But they are enabled to make it at 2.24%, because of more cost on Savings bank deposits, Short term deposits, Interest Paid to local Bank, Mudaraba monthly benefit scheme, Repurchase agreement, Mudaraba Term Deposits, Deposits under scheme

In fact the city bank ltd. Had more deposit & scheme comparing to the year of 2007. In 2007 total deposit was 40539.63 but in 2008 it increases largely and it was 45034.33.  This is the main reason for not achieving the projected rate.

Table: 04 Deposits for the year of 2007 & 2008

Graphs/Charts: 01 various deposits

Table: 05 Net Interest Incomes

Here the actual net interest of the bank and budgeted growth have compared,

So, the net interest earnings of the city bank ltd. settled by increasing 58.93% what was projected at 28.43%, it happened due to large earnings on loans & advances in the year of 2008.

The city bank ltd. achieved above double of net interest income what is projected for the year 2008.This is because they had more income on loans & advances in the year of 2008 comparing to the year 2007. So they are well over what is expected in their budget planning. As they earned a large amount from interest earning their net interest earning also increases. So this position should retain in future.

Table: 06 Investment Incomes

Here the actual Investment of the bank and budgeted growth have compared,

In the projection for the year of 2008 the city bank ltd. Assumed 26.10% growth over 2007, but they achieved 36.18% on Investment Income.

The city bank ltd. Achieved higher income on their investment. Increased income of Interest on treasury bills, Dividend on share, Gain on Government securities contributed much to achieve this success.

There income from investment is well over their expectation and they have to retain this position.

Table: 07 Commission & Exch. Earning

Here the actual Commission & Exch. Earning of the bank and budgeted growth have compared,

In the projection for the year of 2008 the city bank ltd. Assumed 29.13% growth over 2007, but they couldn’t achieve what they expected rather they earn 7.37% less comparing to 2007.Total commission & exchange earning is below their expectation. There assumed that they will be able to earn 29.13% more than the year 2007.

But they earned 7.37% less than the year 2007.They earned 16.96% less on Commission on export bills, 43.55% less on Commission on bills purchased, 11.58% less on Commission on accepted bills, 8.60% less on Commission on OBC, IBC, 13% less on Commission on PO, DD, TT, TC and 17.86% less on Exchange Gain which ultimately largely contributed to this.

They have to focus on to income from Exchange Gain, Commission on export bills, Commission on bills purchased, and Commission on accepted bills, Commission on OBC, IBC, and Commission on PO, DD, TT, and TC.

Table: 08 Other Operating Incomes

Here the actual Other Operating Income of the bank and budgeted growth have compared,

Again, in the projection for the year of 2008 the city bank ltd. Assumed 93.30% growth on other Operating Income over 2007, but they achieved only 46.30% which is about half of their expectation.

Total operating income growth was estimated at 93.30% but actually they achieved only 46.30%. Here 2 things are mentionable that in 2007 Gain from sale of Treasury was 129163 but in 2008 it was nil & it was expected that other operating income with Postage/ Telex/Fax/ SWIFT will rise but it even lower than 2007. So these things contributed much on that type of situation.

So they have to focus more on Gain from sale of Treasury and earning from Postage/ Telex/Fax/ SWIFT etc.

Table: 09 Totals Income from Investment Exchange & Commissions

Here the actual revenue, Operating expenses, and total operating income of the bank and budgeted growth have compared,

Here we see in the projection for the year of 2008 the city bank ltd. Assumed 36.69% growth on Total Inc from Investment, Exchange & Commission earning over 2007, but they achieved only 23.35% which is not up to their expectation.

But they achieved 36.46% growth revenue over 2007, which was expecting to grow by 33.64%. So overall they have success over revenue earning.

On the other hand they expected that their operating expenses will not go over 30.98%, but actually they had to cost 33.35%. Which ultimately effect on the total operating income. Though they have achieved well over their expectation on total operating income. Here the total operating income expected to have 36.43% growth over 2007, but they achieved 39.72%.

They have to focus more on other operating income & Commission & Exch. Earning.

Though they have achieved tk. 379358107 more on Total Inc from Investment Exchange & Commissions comparing to 2007, but they have to focus more on Total Income from Investment Exchange & Commission as they expected more than that growth rate.

In this regard they have to choose right investment decisions and at the same time they should accept those projects to invest which are quite profitable.

Here, we see total budgeted interest income was estimated at 4%, but they achieved 11.60%. That means they achieved more growth than their projected interest income. But they haven’t achieved actually what they expected; because of in 2008 they successfully collected more deposit than the year 2007.

That is why they can’t able to achieve their projection. But it is a good sign in the sense of deposit collection. On the other hand their net interest income and total investment income achieved quite successfully.

But they have negative growth on commission and exchange earning.

Here, we see their other operating income growth was 46.30%, in fact they couldn’t achieve the expected growth to a large extent.

The bank also far behind from their budgeted growth, though they achieved 23.35% growth over 2007. On the other hand they achieved their expected growth over revenue as well as from total operating income.

But they were expecting during the year their operating expenses will no more than 31%, but actually they have to pay 33.35%. The reason behind that they were focusing more on expansion of their banking service. Moreover high inflation rate during the year 2008 may another reason behind that.

4.2 Operating Performance of the city bank ltd.

Table: 10 Operating Performance Ratio

Return on equity for the year 2007 was 12.71%, on the other hand in 2008 it was 11.23%. This means Return on Equity (ROE) fall less by 1.48%, because of higher closing balance for the year 2008.

Return on Assets:                      PAT/Avg. Assets {(Opening + Closing b/s)/2}

(2008)                       =398110184/ {(48755403018+57114576058)/2}

=0.75%

Return on Assets:                      PAT/Avg. Assets {(Opening + Closing b/s)/2}

(2007)                       = 343463026/ {(47445751884+ 48755403018)/2}

=0.71%

Return on Assets (ROA) in 2007 was 0.71% & in 2008 it was0.75%. This means Return on Assets (ROA) increased by 0.04%, Profit after tax in 2007 is lower than 2008.

Yield on Loan & Advances      Interest Income from loans/Avg.loans & Adv.

(2008)                      =4263284463/ {(26788466138+34420944980)/2}

=13.93%

Table: 11 Provision for loans

5.1 Learning Point:

In the internship period at the city bank Ltd. Head office-Finance division, I have learned lots of things. These are listed below:

Finding revenue expenditure for each division

Writing cash debit voucher.

Writing credit Voucher.

Writing pay-slip

Using the Finacale bank Software

Checking balance in Finacale bank Software.

Showing Statement in a Finacale bank Software.

Writing advice.

Analytical ability improves as did this report

Learn more about the cost center and business center.

Learnt more how to  response on a corporate environment.

Banking activities needs more accuracy and professionalism.

Routine work/ Punctuality is must for being successful in this banking industry.

Learnt more about the financial projection and financial analysis of a financial institution like bank.

The organization hierarchy.

Duties and responsibilities of employees of finance division.

Working hour of the organization.

Use of IBC and OBD.

The use of software.

Communication and coordination between different division.

5.2 Findings:

01. We see in the profit & loss a/c. growth on interest income achieved what was projected/expected. But there are less income growth in Interest received from foreign banks, Loans against Imported/Murabha, Packing credit, House building loan, Lease finance/Izara, Payment against documents, cash credit/Bai-Muajjal, Consumer credit Scheme, Interest on SME, Documentary bills purchased Interest on cash incentive, Interest on call loans, Loans (General)/ Musharaka which reduced the more growth.

02. As we see the city bank ltd. wanted to reduce their cost on interest/profit paid on deposits by 3.16%. But they are enabled to make it at 2.24%, because of more cost on Savings bank deposits, Short term deposits, Interest Paid to local Bank, Mudaraba monthly benefit scheme, Repurchase agreement, Mudaraba Term Deposits, Deposits under scheme.

In fact the city bank ltd. collected more deposit & scheme comparing to the year of 2007. In 2007 total deposit was 40539.63 but in 2008 it increases largely and it was 45034.33.  This is a reason  not for achieving the projected/expected rate.

03. The city bank ltd. achieved above double of net interest income what is projected for the year 2008.This is because, they had more income on loans & advances in the year of 2008 comparing to the year 2007. So they are well over what is expected in their budget planning.

04. In the projection for the year of 2008 the city bank ltd. Assumed 26.10% growth over 2007, but they achieved 36.18% on Investment Income. The city bank ltd. Achieved higher income on their investment. Increased income of Interest on treasury bills, Dividend on share, Gain on Government securities contributed much to achieve this success.

05. In the projection for the year of 2008 the city bank ltd. Assumed 29.13% growth on Total commission & exchange earning over 2007, but they couldn’t achieve what they expected, rather they earn 7.37% less comparing to 2007.Total commission & exchange earning is below their expectation..They earned 16.96% less on Commission on export bills, 43.55% less on Commission on bills purchased, 11.58% less on Commission on accepted bills, 8.60% less on Commission on OBC, IBC, 13% less on Commission on PO, DD, TT, TC and 17.86% less on Exchange Gain which ultimately largely contributed to this.

06. Again, in the projection for the year of 2008 the city bank ltd. Assumed 93.30% growth on other Operating Income over 2007, but they achieved only 46.30% which is  about half below of their expectation. Total operating income growth was estimated at 93.30% but actually they achieved only 46.30%. Here 2 things are mentionable that in 2007 Gain from sale of Treasury was 129163 but in 2008 it was nil & it was expected that other operating income with Postage/ Telex/Fax/ SWIFT will rise but it even lower than 2007. So these things contributed much on that type of situation.

07. We see in the projection for the year of 2008 the city bank ltd. Assumed 36.69% growth on Total Inc from Investment, Exchange & Commission earning over 2007, but they achieved only 23.35% which is not up to their expectation.

But they achieved 36.46% growth revenue over 2007, which was expecting to grow by 33.64%. So overall they have success over the expected growth on revenue earning.

On the other hand they expected that their operating expenses will not go over 30.98%, but actually they had to cost 33.35%. Which ultimately effect on the total operating income. Though they achieved well over their expectation on total operating income. Here the total operating income expected to have 36.43% growth over 2007, but they achieved 39.72%.

6.1 Conclusion:

 In Bangladesh banking sector has a significant role to our economy. As the city bank is one of the largest participants in this industry, it is contributing to our national economy.

The services encompass wide diversified areas of trade, commerce & industry which tailored to the specific needs of the customers and are distinguished by an exceptional level of prompt and personal attention. Over the years the Bank has expanded the spectrums of Its Services. The extensive and ever growing domestic network provides and carries various products and services to the doorsteps of millions.

Almost all the divisions are working to hold this position an to go ahead, especially finance division is providing more efforts. Some highly qualified and professional are members of the organization who have a vast experience in this industry are performing their duties.

But they have to dedicate more in their working area. During the time of analyzing this report on Budget & Financial Statement Analysis of the city bank ltd. I faced various problems as they didn’t make a proper budget during the year 2007.

Apart from that the city bank ltd. Performance was better than many other banks. But during the year 2008 they earned large amount revenue.  The financial performance of CBL is better any other banks in the in this industry. So this position should be retained.

6.2 Recommendations:

01. Though the city bank ltd. Have earned more interest on loans & advances than that of their projection, but if they want to increase their growth they have to focus on earnings Interest received from foreign banks, Loans against Imported/Murabha, Packing credit, House building loan, Lease finance/Izara, Payment against documents, cash credit/Bai-Muajjal, Consumer credit Scheme, Interest on SME, Documentary bills purchased Interest on cash incentive, Interest on call loans, Loans (General)/ Musharaka.

02. They should focus on income from Exchange Gain, Commission on export bills, Commission on bills purchased, and Commission on accepted bills, Commission on OBC, IBC, and Commission on PO, DD, TT, and TC.

03. They should focus more on Gain from sale of Treasury and earning from Postage/ Telex/Fax/ SWIFT etc.

04. They have to focus more on other operating income & Commission & Exch. Earning.

Though they have achieved tk. 379358107 more on Total Inc from Investment Exchange & Commissions comparing to 2007.

05. But they have to focus more on Total Income from Investment Exchange & Commission as they expected more than that growth rate. In this regard they have to choose right investment decisions and at the same time they should accept those projects to invest which are quite profitable.

Some More Parts-

Report on Budget & Financial Statement Analysis of the City Bank Limited (Part-1)

Report on Budget & Financial Statement Analysis of the City Bank Limited (Part-2)