Financial Strength Analysis of Rangpur Foundry Ltd

view with charts and images

Financial Strength Analysis of Rangpur Foundry Ltd

Executive Summary

This project will cover the complete knowledge about the main working of Rangpur Foundry

Ltd. The Rangpur Foundry Ltd. is the largest domestic Cast Iron & Plastic goods-producing unit in Bangladesh. Its excellent quality-control standards have helped the Company acquire the ISO-9001:2000 certification. The Company was started commercial production in January 1983.

This project will discuss about the financial strength & weakness and also discuss the Current Financial situations of RFL. Now a day Manufacture company play an important role in economic development the main function of Manufacture is to promote tile movement of Region. The code of conduct approved by the board of director, expresses fundamental principles that guide all the employees and shape the organization business activities. It’s started journey as a privet Ltd company 1981 & converted as public Ltd Company in 1996.

It also describes the various financial ratios and try to find out its past, present and future financial position. This report we find out the liquidity, Asset management, Debit Management, Market Value, Profitability Ratio. We analysis the fixed assets turnover, total assets turnover, profit margin, ROA & ROE. And lastly analysis the DuPont.

RAGPUR FOUNDRY LTD.

1.1 Introduction

Finance is the blood of any business organization. Any public or private limited company needs to conduct a financial statement every year to know its current performance, strengths as well as weaknesses.

Ratio Analysis enables the business owner/manager to spot trends in a business and to compare its performance and condition with the average performance of similar businesses in the same industry. To do this compare the ratios with the average of businesses similar to the company and compare own ratios for several successive years, watching especially for any unfavorable trends that may be starting. Ratio analysis may provide the all-important early warning indications that allow you to solve your business problems before your business is destroyed by them.

The Rangpur Foundry Ltd. is the largest domestic Cast Iron & Plastics production unit in Bangladesh. In this report we are going to analyze its financial strength by analyzing it various financial ratios.

1.2 Objectives

1.2.1 Primary Objective

The primary objective of this report is to determine the Financial Strength and Weakness of Rangpur Foundry Ltd. by analyzing the last six years Financial Statement starting 2003 to 2008.

1.2.2 Secondary Objectives

To fulfill the primary objective the secondary objectives of this report includes the following key aspects of Rangpur Foundry Ltd:

1.  Determine the Liquidity position
2.  Find out the profile of the assets management
3.  Verify the level of Debt management practices
4.  Know the Profitability
5.  And finally, figure out the Market Value

1.3 Origin of the Report

This report has been prepared for as a partial requirement of BBA program. I hope this report will give my instructor a clear idea about the histories, activities and operations, structure, management of asset, liability, liquidity, function and overall financial performance of RFL.

1.4 Background:

I am the student of Business Administrative as a fulfillment BBA degree I have to a complete an internship report. My honorable supervisor Mr. Siddique Hayat khan assigned me to prepare this report on “Performance of the RFL.” This had the formal approval of my supervisor of Business Faculty. This report is prepared based on the qualitative research.

1.5 Rationale of the Report:

Internship program is the practical aspect of our theoretical learning. It makes a bridge between the gap of classroom learning and practical learning. In this view, Internship plays a pivotal role for each professional degree like BBA. The study will help formulate suitable policies taking into consideration different ideas. Further more, it may note that RFL executives who are really executing the policies undertaken by the top management will have a chance to communicate their interaction and provide necessary feedback.

1.6 Scope of the study:

This report has been prepared through extensive discussion with finance employees and with the marketing employee and covers all the trade related products handled by the “RFL.” such as finance department, costing department, etc. While preparing this report, I had a great opportunity to have an in-depth knowledge of all the finance activities perspective of a leading company RFL in Bangladesh.

This report gives “Financial performance analysis of the RFL”. The scope of the report is limited to the overall financing description of the company, its service and its position in the industry and its financing strategies. The scope of the study is limited to organizational setup, functions, and financial performance.

1.7 Methodology of the Study

1.7.1 Type of the report

The ultimate objective of this report is to determine the Financial Strength and Weakness of Rangpur Foundry Ltd. by analyzing the data of last six years Financial Statement. For this reason this report has been prepared by incorporating the characteristics of the exploratory research, through which Rangpur Foundry Ltd.’s financial market positioning has been pointed

1.7.2 Data Collection Method:

To make the Report more meaningful and presentable, two sources of data and information have been used widely.

Source of Data

PRIMARY DATA

SECONDARY DATA

Primary sources

•  Practical desk work
•  Face to face conversation with the officer
•  Financial paper observations.

Secondary sources

•  Annual report of RFL
•  Files & Folders
•  Websites

To complete the report according to the plan designed the required data has been collected from mainly from the Secondary sources. And all the secondary data has been collected from the Annual Reports of Rangpur Foundry Ltd. available in the Dhaka stock exchange.

1.7.3 Research Design:

After the data collection, all the necessary data has been analyzed thoroughly according to the specified formula provided in the textbook of Managerial Finance. To analyze the data the following computer packages were used:

Microsoft Word: MS Word was used for word processing and to write report.

Microsoft Excel: MSExcel was used for analyzing the data, creating charts, and computation purpose.

1.7.4 Type of analysis

In this report, we are basically analyze the trend of various financial ratios and try to find out its past, present and future financial position.

In trend analysis, ratios are compared over time, typically years. Year-to-year comparisons can highlight trends and point up the need for action. Trend analysis works best with three to five years of ratios.

1.8 Conceptual Framework

Financial ratios quantify many aspects of a business and are an integral part of financial statement analysis. Financial ratios are categorized according to the financial aspect of the business which the ratio measures. In this report following ratios are used to analyze the company’s financial strength and weakness.

1.8.1 Liquidity Ratios:

Liquidity ratios help to analyze a company’s ability to meet short-term financial obligations.

Example Ratios	Formula	Measures
Current Ratio	Current Asset Current Liabilities	Ability to pay current debts
Quick ratio/Acid-test ratio	Current assets – Inventory Current liabilities	Ability to convert current assets to cash for the purpose of meeting current liabilities. Called the acid-test — is a crucial test of the firm’s liquidity

1.8.2 Asset management (efficiency) Ratios:

Asset Management ratios help to analyze how quickly a company’s resources can be converted to cash or sales.

Example Ratios	Formula	Measures
Inventory turnover	Sales Inventory	The speed with which inventory moves through the company and is turned into sales.
Fixed asset turnover	Sales Fixed assets	Extent to which company is utilizing existing property, plant, and equipment to generate sales.
Total asset turnover	Sales Total assets	How effectively company uses its total resources to generate sales.
Average collection period (DSO)	Accounts receivable Average daily credit sales	Serves as a basis for determining how rapidly a company’s credit accounts are being collected.

1.8.3 Debt Management (leverage) Ratios:

Debt Management ratios help to analyze the degree and effect of a company’s use of borrowed funds (debt) to finance its operations.

Example Ratios	Formula	Measures
Debt ratio	Total debt Total assets	The extent to which the total assets of the firm have been financed using borrowed funds.
Times interest earned (TIE)	EBIT Interest charges	The ability to the companies to meet is interest obligations should profits decline.

1.8.4 Market Value Ratios:

Market value ratios help to analyze the degree of investor’s responseness to owning a company’s stock.

Example Ratios	Formula	Measures
Price/Earning ratio	Market price per share Earning per share	The extent investors are willing to pay per taka of reported profit.
Market/book value ratio	Market price per share Book value per share	The extent investors are regards the company.

1.8.5 Profitability:

Profitability ratios help to analyze management’s ability to control expenses and earn profits through the use of company’s resources.

Example Ratios	Formula	Measures
Profit margin	Net profit Sales	Measures percentage of each sales taka remaining after all expenses
Return of equity (ROE)	Earnings Shareholders equity	Rate of return that owners receive on their investment.
Return on investment (ROI)	Net profits Total assets	Overall effectiveness to generate profits from total investment in assets.

1.9 Limitations

To review the financial standing of any company it requires several types of data, different types of analysis. In this report to full fill the course requirement we have just covered the analysis of the financial statement of Rangpur Foundry Ltd. While analyzing of the financial statement of Rangpur Foundry Ltd only the technique of Ratio analysis has been incorporated.

A reference point is needed. To be meaningful, most ratios must be compared to historical values of the same firm, the firm’s forecasts, or ratios of similar firms. But unfortunately we haven’t collect ant reference.

Some ratios may not highly meaningful. They should be viewed as indicators, with several of them combined to paint a picture of the firm’s situation.

Year-end values may not be representative. Certain account balances that are used to calculate ratios may increase or decrease at the end of the accounting period because of seasonal factors. Such changes may distort the value of the ratio. Average values should be used when they are available. Ratios are subject to the limitations of accounting methods. Different accounting choices may result in significantly different ratio values.

Organizational Profile

2.1 Introduction of the RFL

The Rangpur Foundry Ltd. is the largest domestic Cast Iron & Plastic goods-producing unit in Bangladesh. Its excellent quality-control standards have helped the Company acquire the ISO-9001:2000 certification. The product of the company is being marketed under the trademark of ‘RFL’. This brand now has a steady market share. The company was set up in 1981 on 5 acres of land and went into commercial production in January 1983.

The Rangpur Foundry Limited (RFL) was the first undertaking of PRAN-RFL Group. This enterprise produces world-class Plastic goods and, as a testimony to this, stands the fact that the concern has been awarded the ISO-9001:2000 certification for sustained quality control effort.

The factory of this Company is located in the Northern part of Bangladesh at BSCIC Industrial Estate, Kellabond, Rangpur, under the Rajshahi Division. Northern part of Bangladesh is poor & labour intensive area. The product of this company is also labour intensive. So, they are enjoying the facility labour availability & also lower labour cost.

Board of Director

Managing Director

Mr. Ahsan Khan Chowdhury

Directors

Maj Gen Amjad Khan Chowdhury

Mrs. Sabiha Amjad

Lt Col Mahtabuddin Ahmed

Mr. Shiban Kumar Na

2.2 RFL Information at a Glance:

Name of the Company	Rangpur Foundry Ltd.
Date of Company Journey	1981.
Date of Commercially Production	January, 1983
Logo
Organizational Structure	Tall
Head Office	12, R.K. Mission Road, Dhaka-1203 Bangladesh.
Principal Factory	BSCIC Industrial Estate, Kellabond, Rangpur
Chairman	Lt Col Mahtabuddin Ahmed (Retd)
Managing Director	Mr. Ahsan Khan Chowdhury
Net Profit After Tax (2008)	17493000
Board of Directors	4
Number of Production Units	3
Operating Profit (2007)	3,257 million
Raw Materials Used	Cast Iron Products from Ship Scrap, Plastics Products from PP Resin and marketing thereof.
Initial Public Offering	Number of Shareholder
Share percentage	Sponsor/ Director-50, Govt.-0, Institute- 0.95, Foreign-0, Public- 49.05

2.3 Products of RFL

CI (Cast Iron)

1. Tube well

2. Tube well spares

3. Centrifugal pump

4. Centrifugal pump spares

5. Water pump ( imported from China)

6. Gas stove (S/C & imported from China)

7. Belcha/ shovel (S/C)

8. Kodal/ Hoe head (imported from China)

9. Bearing ( imported from China)

10. Teflon Tape , Electric Motor, Capacitor etc( imported from China)

PVC (Polyvinyl Chloride)

1. PVC Pipe (1/2” ~ 20”)

2. PVC Filter (1.5”~ 14”)

3. PVC Fitting (Molded & Fabricated)

4. HDPE Pipe (1/2”~ 8”)

5. Threaded Pipe ( ½”~ 8”)

6. Braided Hose

7. Corrugated Hose

8. Garden Hose

Plastics product group containing the following two types

1. Furniture group

2. Household group

Furniture group contains the following product

1. Chair

2. Table

3. Baby chair

4. Tool

5. Rack

6. Basket

Household group contains the following product

1. Kitchen wares

2. Sanitary wares

3. Table top wares

Building materials group contains the following product

1. PVC door

2. PVC sheet

3. Garments Accessories group contains the following product

4. Hangers

5. Gum tape

6. Mitsubishi products are containing the following

7. Poly shopping bag

8. Wind break net

9. Cutleries

How to sell

Sales are performed by three ways

Market sales- performed through 26 zones under 10 regions & divided the products group as below:

1. CL & PVC group

2. HW & M group

3. Doors & Sheets group

4. Furniture group

5. Household-1 group

6. Household-2 group

Field sales forces are containing 92 numbers of zonal & regional managers and 760 numbers of sales representatives. RFL has integrated distribution channel through out the country. In this respect it has fifteen distributor depots and around 5000 distributors all over the country.

Institutional sales: – performed through tender participation and personal persuasion of different government and non government institutional, real estates companies etc.

Export sales- perform through local L/C for domestic & overseas.

2.4 Objective of the RFL:

To achieve the desired goal, it has the intention to pursuit of excellence at all stages with a climate of continuous improvement. Eventually the Company emphasizes on the following objectives

1.  To contribute for economic development of the country
2.  To provide the low cost product with high quality for the mess population of the country
3.  To help farmers by supplying agriculture equipment
4.  To provide the best after sales service to the customers
5.  Reach the products to every possible customers destination
6.  To expend the business through overseas market

2.5 Vision:

To be one of the best Privet manufacturing companies in Bangladesh in terms of efficiency of the employee, well use working capital management. Proper inventory & low cost product with high quality.

2.6 Mission:

RFL has been successful in trading business & established RFL Brand as a reliable quality product and service provider, the company well keep on increasing volume in trading business and secure greater market share.

2.7 Corporate Governance Guidelines and Code of Ethics

Rangpur Foundry Ltd. is an industrial concern engaged in production and marketing of Cast Iron & Plastics under rigid ethical standard. Our code of conduct approved by the board of directors, expresses fundamental principles that guide all the employees and shape the organizations business activities. It is corporate guiding principles, upholding the law, honoring trust, fairness objectivity, confidentiality, integrity and corporate and individual responsibility

2.8 Human Resource Management

Rangpur Foundry Ltd continued to implement appropriate human resource management policies and practical to motivate and develop its employees and also to ensure there optimum contribution towards the achievement of corporate goals. The company continues its policy of hiring the best people and implementing programs to develop and retain high quality human resources.

As a part of company human resources development program, a good number of employees were sent to different training programs both inside and outside the country which included both managerial development and technical modules.

2.9 Domicile, legal form and country of incorporation

Rangpur Foundry Ltd was incorporated in Bangladesh on third of March, 1981. As a private limited company Ltd by shares under the companies act, 1913. It is converted as public limited company in 1996 and it shares are listed in the Dhaka and Chittagong stock exchanges.

2.10 Principal activities and nature of operations

The nature and principal business activities of the company are manufacturing of Cast Iron Products from Ship Scrap, Plastics Products from PP Resin and marketing thereof.

2.11 Units

The company operates three units. The second & third unit has been operating commercially since 2007 & 2008.

2.12 Depreciation

Depreciation is charged on fixed assets on the straight line method at varying rates considering the useful lives of the assets. No depreciation is charged on land & land development. No depreciation has been charged on additions and disposals of the fixed assets during the year under review.

The rates of depreciation on each class are as follows:

Particulars of assets	Annual rate of depreciation
Building and other construction	10%
Plant & Machinery	20%
Furniture & Fixtures	10%
Office Equipment	25%
Telephone Installation	20%
Motor Vehicle	20%
Sundry Assets	33%

2.13 Inventories

Inventories comprise of raw materials, packing materials finished goods and store & spares. They are stated at the lower of cost and realizable value in accordance with BAS- 2 “Inventories” after making due allowances for any obsolete or slow moving items. The costs of inventories are assigned by using weighted average cost formula. Net realizable value is determined after deducting the estimated cost of completion and/or cost to be incurred for effecting the sale from sales price.

2.14 Taxation

The company enjoyed Tax holiday for 7 (seven) years with effect from first July, 2001. The company is a “Publicly Traded Company” as per Income Tax Ordinance and the company provided tax holiday reserve as per section 46A(2)(C) of the Income Tax Ordinance 1984 for Unit-11.

2.15 Financial Results and Appropriations

(Taka in `000)

Year	31.12.2008	31.12.2007
Net profit After Tax	20,710	20,537
Tax Holiday Reserve	3,216	6,990
Net Profit After Tax Holiday Reserve	17,493	14,064
Prior Year Adjustment	–	517
Profit Available For Appropriation	17,493	13,547
Proposed Dividend	18,000	16,000

2.16 Address of registered office and principles place of business

The registered office is at Property Heights, 12, R.K. Mission Road, Dhaka-1203. The factory is situated at BSCIC Industrial Estate, Kellabond, Rangpur

Financial Strength Analysis

3.1 Financial Data

Table 1- Simplified balance sheet of Rangpur Foundry Ltd.

Table 2- Simplified Income Statement of Rangpur Foundry Ltd.

Table 3- Common Size Balance Sheet of Rangpur Foundry Ltd.

Table 4- Common Size Income Statement of Rangpur Foundry Ltd.

3.2 Liquidity Ratios

From the above chart we can see that current ratio is slightly decreasing over the last six years but quick ratio shows opposite trend. That indicates that company is gaining more control over the inventory management, but in both cases company’s current assets does not meet current obligations.

3.3 Asset Management Ratios

Up to the year 2005 inventory turnover is decreasing but after word sharp increasing trend is observed in above chart. Now its inventory turnover is much better that start of the observed period because of increasing sales as well as the decreasing inventory.

3.4 DSO Analysis

There is an ups and downs trend is observed in average collection period. So we can see that when ever there is an increase in DSO, company gave more concentration to improve credit or collection policies. Presently collection period decreasing, but it is even now above the earlier year 2003.

3.5 Fixed & Total Assets Turnover