Pre-Feasibility Study
FAN GUARDS MANUFACTURING UNIT
Small and Medium Enterprise Development Authority Government of Pakistan www.smeda.org.pk HEAD OFFICE Waheed Trade Complex, 1st Floor , 36-Commercial Zone, Phase III, Sector XX, Khayaban-e-Iqbal, DHA Lahore Tel: (042) 111-111-456, Fax: (042) 5896619, 5899756
[email protected] REGIONAL OFFICE PUNJAB Waheed Trade Complex, 1st Floor, 36-Commercial Zone, Phase III, Sector XX, Khayaban-e-Iqbal, DHA Lahore. Tel: (042) 111-111-456 Fax: (042) 5896619, 5899756
[email protected]
REGIONAL OFFICE SINDH
REGIONAL OFFICE NWFP
REGIONAL OFFICE BALOCHISTAN
5TH Floor, Bahria Complex II, M.T. Khan Road, Karachi. Tel: (021) 111-111-456 Fax: (021) 5610572
[email protected]
Ground Floor State Life Building The Mall, Peshawar. Tel: (091) 9213046-47 Fax: (091) 286908
[email protected]
Bungalow No. 15-A Chaman Housing Scheme Airport Road, Quetta. Tel: (081) 831623, 831702 Fax: (081) 831922
[email protected]
June, 2006
Pre-Feasibility Study
Fan Guards Manufacturing Unit
DISCLAIMER The purpose and scope of this information memorandum is to introduce the subject matter and provide a general idea and information on the said area. All the material included in this document is based on data/information gathered from various sources and is based on certain assumptions. Although, due care and diligence has been taken to compile this document, the contained information may vary due to any change in any of the concerned factors, and the actual results may differ substantially from the presented information. SMEDA does not assume any liability for any financial or other loss resulting from this memorandum in consequence of undertaking this activity. Therefore, the content of this memorandum should not be relied upon for making any decision, investment or otherwise. The prospective user of this memorandum is encouraged to carry out his/her own due diligence and gather any information he/she considers necessary for making an informed decision. The contents of the information memorandum do not bind SMEDA in any legal or other form.
DOCUMENT CONTROL Document No.
PREF-29
Revision
2
Prepared by
SMEDA-Punjab
Approved by
PC Punjab
Revision Date
June 2006
2 PREF-29/June 2006/REV 2
Pre-Feasibility Study
1
Fan Guards Manufacturing Unit
INTRODUCTION........................................................................................................................... 4 1.1 1.2
PROJECT BRIEF .......................................................................................................................... 4 PROJECT RATIONALE ................................................................................................................. 4
2
PROCESS FLOW SHEET ............................................................................................................. 5
3
PRODUCTION PROCESS FLOW ................................................................................................ 5
4
VIABLE ECONOMIC SIZE .......................................................................................................... 6
5
CURRENT INDUSTRY STRUCTURE ......................................................................................... 7
6
SALES & MARKETING ISSUES.................................................................................................. 8
7
PROJECT INPUTS ........................................................................................................................ 9 7.1 LAND & BUILDING ..................................................................................................................... 9 7.2 MACHINERY & EQUIPMENT ........................................................................................................ 9 7.3 ELECTRICITY LOAD & EXPENSES .............................................................................................. 11 7.4 RAW MATERIALS ..................................................................................................................... 11 7.4.1 WIRE .......................................................................................................................................... 11 7.4.2 OTHER REQUIRED RAW MATERIALS ............................................................................................ 12 7.5 OFFICE EQUIPMENT AND FURNITURE ........................................................................................ 12 7.6 ADMINISTRATION AND LABOR COST ......................................................................................... 13 7.7 PRE-OPERATING COSTS ............................................................................................................ 13
8
FINANCIAL ANALYSIS ............................................................................................................. 14
9
REGULATIONS........................................................................................................................... 14
10
KEY SUCCESS FACTORS...................................................................................................... 14
11
THREATS................................................................................................................................. 14
12
FINANCIAL STATEMENTS................................................................................................... 15
12.1 INCOME STATEMENT .................................................................................................................... 15 12.2 BALANCE SHEET .......................................................................................................................... 16 12.3 CASH FLOW STATEMENT .............................................................................................................. 17 13
ASSUMPTIONS........................................................................................................................ 18 13.1 REVENUE ASSUMPTIONS .............................................................................................................. 18 13.2 EXPENSE ASSUMPTION ................................................................................................................. 18 13.3 ECONOMY RELATED ASSUMPTIONS .............................................................................................. 19 13.4 DEPRECIATION ASSUMPTIONS ...................................................................................................... 19
3 PREF-29/June 2006/REV 2
Pre-Feasibility Study
1 1.1
Fan Guards Manufacturing Unit
Introduction Project Brief
Fan is a necessity item of summer season. The hot local climate during summer season makes it mandatory to use. Their main usage is to get rid of extensive heat through air displacement at a fast rate. Three major types of fans have the maximum demand, which are Ceiling Fans, Pedestal Fans, and Bracket Fans. All Pedestal and bracket fans have fan guards as an integral part of the product. The reason is to protect the users from any harm that could be caused by fast rotating, sharp edged fan blades. The demand for fans has shown increasing trend over the past few years. Additional demand was generated locally as well as through exports. Another interesting fact is the increase in demand for better quality. People are becoming more quality conscious. In this scenario, the suppliers of spare parts to fan manufacturing units are also under compulsion to improve their quality. This pre-feasibility is being prepared by SMEDA and is intended to provide general information on the opportunity for an investor to set up modern and proper fan guards manufacturing unit in Gujrat, the home of fan manufacturing industry. 1.2
Project Rationale
Fan guard manufacturing is a feasible and profitable project if handled in a proper manner. Incorporating new manufacturing technology gives an advantage that translates into more business and consequently more profits. Demand for fan guards is ample. The only requirement is high and consistent technology and regular supply ability. An approximate 5 to 6 million fans are manufactured in Pakistan every year. According to industry sources about 30% of total production is Pedestal Fans and about 7% is bracket fans. So the approximate market for fan guards is roughly 1.8 million to 2 million units. Although there are certain existing players in the market, only one or two has the capacity to supply high quality product on consistent basis, leaving a big gap for new players to enter this sector. This project requires a considerable amount of investment, considering that it is an SME, but the demand-supply gap and expected profits attract attention towards it. Besides, all the machinery is available locally at very reasonable rates.
4 PREF-29/June 2006/REV 2
Pre-Feasibility Study
2
Fan Guards Manufacturing Unit
Process flow Sheet
Strip cutting
Flower Making
Spot welding of rings
Outer ring welding to the guard
Roller machine to make rings
Welding jigsaw
Bending press
Fan guard ready for finishing
Pickling
Ring welding Water rinsing
Hard chrome plating tank
Nickel Plating
Electroplating tank with temperature control
FINISHED PRODUCT
3
Production Process Flow
The basic raw material required in the manufacturing of fan guards is ‘Rolled Wires’ of different gauge, ranging between 8 and 14 gauge. In addition to rolled wire, certain chemicals are used for polishing and pickling activities to give the product its final finish. The complete process of fan guard manufacturing would be as follows: To start the process, first of all the wire, which is purchased from the market is polished in the polishing section. Washing Soda (Sodium Carbonate) is used for this process. The polishing cleans the wires of any rust and smoothes its surface. The importance of this process is manifested when a complete fan guard is taken for powder coating or electroplating process. Rust free wire helps give a longer life and smoothed out surface is essential for proper pickling or powder coating process. 5 PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
After polishing, the wire would be taken to an automatic cutter to cut the wire into pieces of required length (which is equal to the radius of the fan guard). The cut pieces of wire would automatically be fed to the circular jigsaw-welding machine. This machine would weld the cut pieces of wire onto the inner most ring of the fan guard. Once the wire pieces are welded onto the main inner ring the guard would be taken manually to the bending press and given the required shape using different bending dies. Keeping the guard in the die and applying the required pressure bends the guard at a certain distance from the edge, thereby, giving it a certain basic shape. Even at this stage one end of the wire is welded to the inner ring while the other end is still loose. It is after taking shape in bending press, the guard would be taken for spot welding of rings of different sizes on the guard. This would put a ring at the loose ends of the wires and at different places where wires are bending. In spot welding two pieces of metal that are to be joined together are placed under the welding machine and then a high amperage electric current is passed through these wires, increasing the temperature to the level where they melt for a fraction of a second and then join together. More than one ring is required on one fan guard because the length of the wire from the center right to the outer ring is between 12 to 18 inches and different rings are required to strengthen the guard. Once in a while wires, cut in different shapes, are welded onto the guard in place of a ring but this is rare and mostly circular rings are used. While the fan guards is taking its initial shape and then going through the bending press, circular rings are being made separately on a ring-making machine. This is a separate process and runs parallel to the main process. The ring-making machine rolls the wire and makes circular rings according to required sizes, which are fed in its program. These are the rings, which are then welded onto the fan guard to complete the product. The last function is trimming of any residual pieces of wire, which are longer than the required length and go out of the outer most rings. After this process fan guard would be checked for any defects in the wire or the spot welds before sending it for finishing. Electroplating would give the fan guards its final finish. General market demand determines what finish be given to the product. At present more than 85% of the demand is for electroplated fan guards. Electroplating gives a cosmetic effect to the final product. Besides beautifying the product, it also helps increase its life.
4
Viable Economic Size
To arrive at a viable economic size for this project, certain aspects have to be considered. These aspects include demand-supply gap of high quality fan guards, seasonal demand pattern, and total cost of plant and machinery. Taking into account all these factors, viable economic size of the project is production capacity of 175,000 fan guards/year, based on 275 days/year. The actual production capacity utilization comes out to be 78% (136,500 fan guards), taking into account the seasonal demand pattern and production schedule. Production mix is 90% 3 kg fan guards (used mostly for pedestal fans) and 10% 1.5 kg fan guards (used mostly for bracket fans). 100% of the units would be electroplated for giving them the final finish. 6 PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
The project would be set up in Gujrat City, where more than 90% of the fan industry is concentrated. There would be three sections of the project 1) Fan Guard Manufacturing Section 2) Polishing Section, and 3) Pickling Section
5
Current Industry Structure
Fan guard manufacturing sector is not an organized sector. This sector is mostly made up of small units that are established in small premises. The involvement of technology in manufacturing process or for that matter in any process is minimal. Variation in quality is a consistent feature. There are no exact figures available as to what is the total number of units, how many are operational, what is the total installed capacity, and what the operational capacity is. According to the industry sources (including manufacturers and vendors) there is a substantial demand for quality stuff on a large scale. Also, there is room for new entrants who want to manufacture quality product, using the latest technology. The industry is concentrated in Gujranwala and Gujrat. There used to be many fan guard manufacturers in Gujranwala, but now only one major manufacturer is left. The reason is that this manufacturer has a modern and completely integrated manufacturing facility, which others did not use. The result is that it is the only major supplier catering to the demand in Gujranwala City. Gujrat is now the major center as far as fan manufacturing is concerned. In Gujrat, there are more than 50 fan-guards manufacturing units. But only 4 or 5 can qualify as proper units. All other units are mini or micro units with production capacity of about 40 pieces per day, using primitive manufacturing techniques and technology. There are two reasons why small units are closing down. First reason is the lack of use of modern manufacturing machines and techniques due to unavailability of enough capital, thereby, being unable to afford this change. Second reason is the increase in the size of credit cycle for these small units. The payments come back after two or four weeks. Only those manufacturers have survived who have enough capital. Large size fan guard’s manufacturers are filling in the gap that is being created due to closure of small units. These manufacturers have installed new machines and some are even producing 1000 to 1200 pieces per day depending on the size of fan guard. Overall demand for high quality fan guards is increasing, especially since exports have picked up for the last three years. Fan guard manufacturers, as a vending sub-sector of fan manufacturing sector, are concentrated in two main cities of Gujrat and Gujranwala. Only one major manufacturing unit is left in Gujranwala. The other one is too small to have any significance. Gujrat has the largest number of fan guard manufacturing units. It is assessed that there are more than 50 fan guards manufacturing units working in Gujrat. There used to be one unit in Shahdara, Lahore.
7 PREF-29/June 2006/REV 2
Pre-Feasibility Study
6
Fan Guards Manufacturing Unit
Sales & Marketing Issues
Fan guard is an essential and integral part for all pedestal fans, bracket fans, TCP (Table cum pedestal) fans, baby fans, and railway fans. None of these fans would be complete without a guard. From this point of view, it is a necessary product for manufacturers of above-mentioned fan categories. Some air cooler manufacturers also use fan guard in their product. Fan guard is an industrial product and, therefore, its target market cannot be defined in terms of gender, age bracket, profession, etc. The factors involved in defining the target market for fan guard would be the size of the fan manufacturing unit, the quality of fan it produces, and the price the customer is willing to pay for the product. Based on these factors, the major target market segment for the proposed project would be medium size fan manufacturers and those small size units, which produce above 15,000 fans/year. The large size fan manufacturing units have their own fan guard manufacturing units, therefore, they are not generally considered as the target market. Yet they do outsource their fan guard requirement at times. The proposed project would have the capacity and the quality to fulfill this demand as well. The proposed project would manufacture fan guards for different varieties of fans. These varieties are: •
Pedestal Fans
•
Bracket Fans
•
Circo Fans
•
TCP (Table cum pedestal) Fans
•
Baby Fans
•
Railway Fans
•
Air Coolers
There are different sizes of fan guards, measured in terms of their weights. These sizes vary with the variety of fan it would be used for. The most common fan guard used in the industry weighs 3 kg on average, with a diameter of approximately 26-inch. This would be the main product to be produced by the proposed project. As fan guard is an essential part of pedestal, bracket, TCP, and other such fans, therefore, it is sold to the fan manufacturers directly. Gujrat and Gujranwala are the main markets for fan guard manufacturers, as these two cities are producing more than 90% of total fans manufactured in Pakistan. Gujrat is the main target market for the proposed project. Another interesting fact is that about 5% to 10% of the total production is sold directly to shops that sell pedestal and bracket fans. These shops sell the fan guard as replacement spare part. They cater to the demand, which originates as a result of accidental damage to the fan guard or through rusting & old age. The main market for this segment is South Punjab, Interior Sind and Karachi. 8 PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
An extensive distribution network would not be required to sell this product. The complete actual production would usually be against pre-placed orders. Therefore, there is no need for establishing any distribution channel. Once the order is ready, it is packed and sent to the buyers either on donkey cart or pickup. The orders from fan selling shops in South Punjab, Interior Sind, and Karachi would be booked by train and sent directly to them. These orders are either direct purchase request and/or generated by sales agent of the company. Sampling is an integral part of the sale process in the vending industry. Samples are made according to customers’ requirements and given to them for testing. If the results are satisfactory, order is placed and a business relationship is built.
7
Project Inputs
Following inputs are required: 7.1
Land & Building
Total area required for the project is about 7,000 ft2. This translates into approximately 26 marlas (272 ft2/marla). The land would be purchased. Approximate rate/ ft2 in the area, which is at a reasonable distance from most of the fan manufacturing units in Gujrat City, is estimated at Rs 460/ ft2. Based on this, total cost of land would approximately come out to be Rs 3,220,000. A proper building would be constructed to house this fan guards manufacturing unit. The building would consist of a main processing hall, a management room, and a storeroom. The main processing hall would have an area of 4200 ft2 and would house fan guard manufacturing section, polishing section, and pickling (electroplating) section. The main processing hall has extra space, which can be utilized for any future expansion The management room would have an area of 10’x15’ and the storeroom would have an area of 10’x10’. The total covered area would come out to be 4450 ft2. The whole building would be a RBC structure. The average construction cost would be Rs 650/ ft2.Besides covered area of 4450 ft2, approximately 2550 ft2 area would be open space. This area would be leveled and approximate cost of leveling would be Rs 5/ ft2. Total cost of leveling would be Rs 12,750.Total cost of the construction would come out to be Rs 2,973,250. The complete premises would be encircled with a boundary wall. A 340 feet boundary wall would be constructed for this purpose. Construction rate for boundary wall is Rs 200/linear foot. Total cost of boundary wall would be Rs 68,000. 7.2
Machinery & Equipment
Local machinery would be used for this project. The total cost of machinery is estimated at Rs 3,142,000/-. Besides cost of machinery and equipment, an additional Rs 150,000
Reinforced Brick Concrete 9
PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
would be paid as installation and transportation cost. Complete list of machinery and estimated prices are as follows: Table 1:Plant and Machinery 1 Machinery Description
Number
Unit Price
Total amount
130,000 150,000
390,000 300,000
2 8
100,000 40,000
200,000 320,000
2 2 2 2 1 2
70,000 18,000 40,000 40,000 5,000 10,000
140,000 36,000 80,000 80,000 5,000 20,000 1,00,000
Fan Guards Manufacturing Section Flower Making Machine 3 Hydraulic Press, capacity 40 ton 2 Roller machine to make rings Spot welding with fixtures (for assembly of guards) Welding transformer Strip cutting machine Power Press (15 ton) Ring welding machine Grinder Cutting press Miscellaneous Sub total
1,671,000
Polishing Section Polishing machines bench type double spindle
2
22,000
44,000
Flexible lead type polishing machine
1
40,000
40,000
Sub total
1,755,000 Pickling Section
Acid tank with rubber lining 1)Electro plating tank with stirring system, temperature control and heating system (1000 Amp) 2)Nickel Plating tank temperature control and stirring system (3000 Amp rectifier)
2 100,000 Price of these machines Varies Total accumulated cost of these Machines is Rs. 800,000.
3)Chrome plating tank inside lead lining Stirring system with rectifier (1000 Amp) Sub Total Miscellaneous 1
Source: Jamil Guard Makers, Shahdola Road, Noor Pur, Gujrat 10
PREF-29/June 2006/REV 2
200,000 800000
2,775,000
Pre-Feasibility Study
Fan Guards Manufacturing Unit
Electric Control Panels, Main Switches, Cables & Distribution Board Transformer* and Connection Cost
200,000 300,000
Installation and transportation Cost
100,000
Subtotal Total
600,000 3,355,000
To give this project a cutting edge in the fan guards manufacturing sector, a conveyer system can also be used. The use of conveyer system would improve the production capacity of the unit and reduce the labor cost at the same time. The cost of putting up a conveyer system would be about Rs 250,000. There is no major machinery maintenance involved. A provision of Rs. 1,000 per month has been made for machinery oiling expense. 7.3
Electricity Load & Expenses
Total electrical load of the project, including rectifiers: 93HP (93x0.746/0.80) = 87 kW (Per Day). Overhead electricity expenses are estimated to be Rs 92,655/year. These include electricity charge for management room (2 watts/ft2), processing hall (1 watts/ft2), storeroom (1 watts/ft2), open area (0.5 watts/ft2), and fixed charges for installed kW. Table 2 Electricty Kw required Per Day Kw per month Electricity Tariff Schedule Energy Charges per Kw GST Income Tax Variable electricity expense per unit of production Total Variable Expense for the year Kw per month Energy Charges per Kw Total Electricity Expense 7.4
Variable Variable
87 12,041
6.90 15%
83,084 13,579 2,000 8.67 98,663 1077 7431 106,094
Overhead 6.90
Raw Materials
7.4.1 Wire Rolled wires of different grades are required as raw material for the manufacturing of fan guards of different sizes and shapes. Most commonly, 8-14-gauge wires would be used for manufacturing the basic body of a fan guard. Similarly, the rings that are welded onto the main body of fan guard for giving it strength and aesthetic looks are also made using 11 PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
wires ranging from 8-14 gauge. Production mix is 90% 3 kg fan guards and 10% 1.5 kg fan guards. The wire is readily available in the market at an average cost of 42 Rs./kg. Weighted average cost of wire per unit comes out to be Rs 126. 7.4.2 Other Required Raw Materials The other raw materials required include the acids, salts, soda, and solutions for electroplating, and polishing. The details are as follows: •
Sulphate (Nickel)
•
Chloride
•
Borax (Boric Acid)
•
Chrome salt
•
Caustic Soda
•
Brightener
•
Washing Soda (Sodium Carbonate)
•
Copper salt
Out of these different chemicals, Washing Soda is used for polishing and rests of the chemicals are all used in electroplating process. Weighted average cost of chemicals per unit (Both 3 Kg and 1.5 Kg) comes out to be Rs. 3. The production wastage is estimated at 5 % per fan guard. 7.5
Office Equipment and Furniture
The office equipment will consist of a computer, printer, facsimile machine and two telephone sets for extensions (these sets will be in addition to the set provided by PTCL along with telephone connection). The office furniture consists of chairs, sofa sets, tables, carpet for management room and a file rack. The total cost of office equipment and furniture is estimated as follows: Table 3: Office Equipments Equipment Computers Computer printer (s) Telephones Fax machines Total Office Equipment Table 4: Office Furniture Furniture Table For Manager Chair for Manager
Number 1 1 2 1
Number
Total Cost 25,000 12,000 1,500 12,000 50,500
Cost /unit Total Cost 1 4,000 4,000 1 2,500 9,000 12
PREF-29/June 2006/REV 2
Cost /unit 25,000 12,000 750 12,000
Pre-Feasibility Study
Fan Guards Manufacturing Unit
Table Chair File Cabinet Sofa set Carpeting (sq.ft.) Total Furniture & Fixtures 7.6
6 12 1 1 150
1,500 1,000 10,000 12,000 30
2,500 12,000 10,000 12,000 4,500 54,000
Administration and Labor Cost
The owner, a plant manager, and an accountant will handle the day to day administration of the business. A supervisor will look after purchase and sales matters with two assistants, a salesman and a purchaser. Other staff includes one gatekeeper. 20 skilled workers along with estimated 10 unskilled workers are required (as number of unskilled labor is adjusted according to the season) would also be the part of human resource but not as permanent staff because piece rate system is being practiced in the industry. Approximately Rs. 4 per unit is charged under piece rate system. This cost is included into the “Cost of Goods sold” head rather then labor cost. Same has been adopted in the feasibility. One foreman would supervise these workers. The administration cost for year 1 is as follows: Table 5:Payroll Designation Owner/Manager Plant Manager / Foreman Purchaser Accountant Office Boy Gate Keeper Sweeper Total
Salary/Month 20,000 12,000 8,500 7,500 4,000 3,500 2,500
Employees 1 1 1 1 1 1 1 7
Total 240,000 144,000 102,000 90,000 48,000 42,000 30,000 696,000
Wages are assumed to grow at a rate of 10% per annum. 7.7
Pre-Operating Costs
Pre-operating costs include the hiring of management team before the actual commencement of operations. The other component of pre-operating costs is the accrued interest for the debt used in the completion of civil works and purchase of machinery. The total pre-operating costs amount to Rs. 250,887.
13 PREF-29/June 2006/REV 2
Pre-Feasibility Study
8
Fan Guards Manufacturing Unit
Financial Analysis
Table 6: Financial Analysis Total Investment Total Capital Investment Total Working Capital Project IRR Payback Period NPV
9
11,594,803 10,188,455 1,406,348 26% 4.03 yrs 5,867,774
Regulations
There are no specific government regulations for this business. The firm would have to be properly registered as a business entity with registrar of firms. Afterwards, the firm has to be registered with tax authorities. Besides these two registrations, the firm would also be registered with labor authorities under the Labor Act. Once registered, it would have to follow the requirements of Social Security Department and EOBI.
10 Key Success Factors The proposed project would have a number of competitive advantages: •
It would fulfill the demand-supply gap for high quality fan guards.
•
It would be able to fulfil orders in time due to mechanized production facility.
•
Due to its high quality standard, the project would be able to get premium price for its products.
11 Threats Threats over longer period of time include market saturation due to excessive number of new entrants, demand shrinkage due to fall in demand for pedestal and/or bracket fans, decline in exports of fans, and any change in the design of fans that might eliminate the use of fan guard. But overall the situation is very conducive for establishing the proposed project.
For detail information please refer to attached financial statements at the end of the report. 14
PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
12 Financial Statements 12.1 Income Statement Statement Summaries
SMEDA
Income Statement Year 1 Revenue Cost of goods sold Gross Profit
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Rs. in Year 9
actuals Year 10
21,805,000 17,476,269 4,328,731
24,166,170 19,614,765 4,551,405
26,762,355 21,999,003 4,763,352
29,615,801 24,656,153 4,959,648
32,750,789 27,616,310 5,134,480
36,193,821 30,912,804 5,281,017
39,973,813 34,582,542 5,391,271
44,122,315 38,666,382 5,455,932
48,673,742 43,209,552 5,464,190
53,665,630 48,262,103 5,403,527
General administration & selling expenses Administration expense Rental expense Utilities expense Travelling & Comm. expense (phone, fax, etc.) Office vehicles running expense Office expenses (stationary, etc.) Promotional expense Insurance expense Professional fees (legal, audit, etc.) Depreciation expense Amortization expense Property tax expense Miscellaneous expense Subtotal Operating Income
568,560 92,655 82,800 27,600 21,805 65,415 519,613 57,141 1,435,589 2,893,142
623,916 101,921 90,862 30,287 24,166 72,499 519,613 57,141 1,520,403 3,031,001
684,661 112,113 99,708 33,236 26,762 80,287 519,613 57,141 1,613,521 3,149,831
751,321 123,324 109,416 36,472 29,616 88,847 519,613 57,141 1,715,749 3,243,899
824,470 135,657 120,068 40,023 32,751 98,252 519,613 57,141 1,827,975 3,306,505
904,742 149,222 131,759 43,920 36,194 108,581 519,613 1,894,030 3,386,987
992,829 164,144 144,587 48,196 39,974 119,921 519,613 2,029,263 3,362,007
1,089,492 180,559 158,664 52,888 44,122 132,367 519,613 2,177,705 3,278,228
1,195,567 198,615 174,112 58,037 48,674 146,021 519,613 2,340,638 3,123,552
1,311,969 218,476 191,063 63,688 53,666 160,997 519,613 2,519,471 2,884,056
Other income Gain / (loss) on sale of assets Earnings Before Interest & Taxes
83,801 2,976,943
88,801 3,119,803
115,500 3,265,331
127,050 3,370,949
139,755 3,446,260
153,731 3,540,717
169,104 3,531,111
186,014 3,464,242
204,615 3,328,168
225,077 3,109,132
Interest expense Earnings Before Tax
811,636 2,165,307
575,668 2,544,135
306,664 2,958,667
3,370,949
3,446,260
3,540,717
3,531,111
3,464,242
3,328,168
3,109,132
Tax NET PROFIT/(LOSS) AFTER TAX
412,061 1,753,246
487,827 2,056,308
570,733 2,387,934
653,190 2,717,759
668,252 2,778,008
687,143 2,853,574
685,222 2,845,889
671,848 2,792,393
644,634 2,683,534
600,826 2,508,306
Balance brought forward Total profit available for appropriation Dividend Balance carried forward
1,753,246 1,753,246
1,753,246 3,809,554 154,245 3,655,308
3,655,308 6,043,242 462,914 5,580,328
5,580,328 8,298,088 2,945,051 5,353,036
5,353,036 8,131,044 2,962,241 5,168,803
5,168,803 8,022,377 2,932,028 5,090,349
5,090,349 7,936,238 2,869,361 5,066,877
5,066,877 7,859,270 2,753,665 5,105,605
5,105,605 7,789,139 2,574,389 5,214,751
5,214,751 7,723,057 4,353,021 3,370,035
15 PREF-29/June 2006/REV 2
Pre-Feasibility Study
Fan Guards Manufacturing Unit
12.2 Balance sheet Statement Summaries
SMEDA
Balance Sheet Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Rs. in Year 9
Assets Current assets Cash & Bank Accounts receivable Finished goods inventory Equipment spare part inventory Raw material inventory Pre-paid annual land lease Pre-paid building rent Pre-paid lease interest Pre-paid insurance Total Current Assets
1,000,000 406,348 1,406,348
676,026 896,096 478,738 2,050,860
1,100,000 944,613 563,608 2,608,221
1,210,000 1,046,477 663,059 2,919,535
1,331,000 1,158,455 779,541 3,268,997
1,464,100 1,281,505 915,912 3,661,517
1,610,510 1,416,670 1,075,495 4,102,675
1,771,561 1,565,088 1,262,167 4,598,816
1,948,717 1,728,003 1,480,437 5,157,156
2,143,589 1,906,768 1,735,557 5,785,914
2,357,948 2,102,864 4,460,811
Fixed assets Land Building/Infrastructure Machinery & equipment Furniture & fixtures Office vehicles Office equipment Total Fixed Assets
3,220,000 2,973,250 3,605,000 54,000 50,500 9,902,750
3,220,000 2,824,588 3,244,500 48,600 45,450 9,383,138
3,220,000 2,675,925 2,884,000 43,200 40,400 8,863,525
3,220,000 2,527,263 2,523,500 37,800 35,350 8,343,913
3,220,000 2,378,600 2,163,000 32,400 30,300 7,824,300
3,220,000 2,229,938 1,802,500 27,000 25,250 7,304,688
3,220,000 2,081,275 1,442,000 21,600 20,200 6,785,075
3,220,000 1,932,613 1,081,500 16,200 15,150 6,265,463
3,220,000 1,783,950 721,000 10,800 10,100 5,745,850
3,220,000 1,635,288 360,500 5,400 5,050 5,226,238
3,220,000 1,486,625 4,706,625
285,705 285,705 11,594,803
228,564 228,564 11,662,561
171,423 171,423 11,643,168
114,282 114,282 11,377,729
57,141 57,141 11,150,438
10,966,204
10,887,750
10,864,278
10,903,006
11,012,152
9,167,436
Intangible assets Pre-operation costs Legal, licensing, & training costs Total Intangible Assets TOTAL ASSETS Liabilities & Shareholders' Equity Current liabilities Accounts payable Export re-finance facility Short term debt Other liabilities Total Current Liabilities Other liabilities Lease payable Deferred tax Long term debt Total Long Term Liabilities
-
-
-
5,797,401 5,797,401
4,111,914 4,111,914
2,190,459 2,190,459
Shareholders' equity Paid-up capital 5,797,401 Retained earnings Total Equity 5,797,401 TOTAL CAPITAL AND LIABILITIES 11,594,803
5,797,401 1,753,246 7,550,647 11,662,561
5,797,401 3,655,308 9,452,709 11,643,168
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
5,797,401 5,580,328 11,377,729 11,377,729
5,797,401 5,353,036 11,150,438 11,150,438
16 PREF-29/June 2006/REV 2
actuals Year 10
5,797,401 5,168,803 10,966,204 10,966,204
5,797,401 5,090,349 10,887,750 10,887,750
5,797,401 5,066,877 10,864,278 10,864,278
5,797,401 5,105,605 10,903,006 10,903,006
5,797,401 5,214,751 11,012,152 11,012,152
5,797,401 3,370,035 9,167,436 9,167,436
Pre-Feasibility Study
Fan Guards Manufacturing Unit
12.3 Cash Flow Statement Statement Summaries
SMEDA
Cash Flow Statement
Operating activities Net profit Add: depreciation expense amortization expense Deferred income tax Accounts receivable Finished good inventory Equipment inventory Raw material inventory Pre-paid building rent Pre-paid lease interest Advance insurance premium Accounts payable Other liabilities Cash provided by operations
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Rs. in Year 9
(406,348) (406,348)
1,753,246 519,613 57,141 (896,096) (72,390) 1,361,513
2,056,308 519,613 57,141 (48,517) (84,870) 2,499,675
2,387,934 519,613 57,141 (101,863) (99,451) 2,763,373
2,717,759 519,613 57,141 (111,979) (116,483) 3,066,051
2,778,008 519,613 57,141 (123,050) (136,370) 3,095,341
2,853,574 519,613 (135,165) (159,584) 3,078,438
2,845,889 519,613 (148,418) (186,671) 3,030,412
2,792,393 519,613 (162,914) (218,270) 2,930,821
2,683,534 519,613 (178,766) (255,121) 2,769,260
(1,685,487) (1,685,487)
(1,921,455) (1,921,455)
(2,190,459) (2,190,459)
Financing activities Change in long term debt 5,797,401 Change in short term debt Change in export re-finance facility Add: land lease expense Land lease payment Lease principal repayment Issuance of shares 5,797,401 Purchase of (treasury) shares Cash provided by / (used for) financing activities 11,594,803 Investing activities Capital expenditure (10,188,455) Acquisitions Cash (used for) / provided by investing activities (10,188,455) NET CASH
1,000,000
Cash balance brought forward Cash available for appropriation Dividend Cash carried forward
1,000,000 1,000,000
(323,974) 1,000,000 676,026 676,026
-
-
2,508,306 519,613 (196,096) 1,735,557 4,567,380
-
-
-
-
-
-
-
-
-
-
-
-
-
-
578,219
572,914
3,066,051
3,095,341
3,078,438
3,030,412
2,930,821
2,769,260
4,567,380
676,026 1,254,245 154,245 1,100,000
1,100,000 1,672,914 462,914 1,210,000
1,210,000 4,276,051 2,945,051 1,331,000
1,331,000 4,426,341 2,962,241 1,464,100
1,464,100 4,542,538 2,932,028 1,610,510
1,610,510 4,640,922 2,869,361 1,771,561
1,771,561 4,702,382 2,753,665 1,948,717
1,948,717 4,717,978 2,574,389 2,143,589
2,143,589 6,710,969 4,353,021 2,357,948
17 PREF-29/June 2006/REV 2
actuals Year 10
Pre-Feasibility Study Fan Guards Manufacturing Unit
13 Assumptions 13.1 Revenue Assumptions Table 7: Sales Price Sale price per unit in year 1 Product Units with 3kg (Electroplated) Units with 1.5kg (Electroplated) Weighted average cost
Production Price Weighted Average 90% 182 164 10% 142.00 14 178
Table 8: Other Revenue assumption Sale price growth rate
7.75%
Production capacity utilization
70%
Production capacity utilization growth rate
2%
Maximum capacity utilization
95%
13.2 Expense assumption Table 9:Expense Assumptions Description
Cost /Rate
Per Unit Labor Charges Rate Charged by the labor in Piece rate system Wire Cost growth rate Chemical cost growth rate Machinery maintenance Operating costs 3 (direct electricity) Operating costs growth rate (% of administration expense) Administration benefits expense (% of administration expense) Traveling expense (% of administration expense) Communication expense (% of administration expense) Office vehicles running expense (% of vehicles cost) Office expenses (stationary, entertainment, janitorial services, etc.) % of administration expense Promotional expense % of revenue Office vehicles insurance rate Professional fees (legal, audit, consultants, etc.) % of revenue
PREF-29/June 2006/REV 2
18
4 9.18% 5.0% 12,000 8.67 5.0% 3.0% 5.0% 10.0% 3.0% 5.0% 0.1% 5.0% 0.3%
Pre-Feasibility Study Fan Guards Manufacturing Unit
13.3 Economy Related Assumptions Table 10: Economic Assumptions Description Inflation rate Electricity growth rate Water price growth rate Gas price growth rate Wage growth rate Office equipment price growth rate Office vehicles price growth rate
Cost / Rate 10% 10% 10% 10% 10% 5% 10%
13.4 Depreciation Assumptions Table 11: Depriciation Description Land Building Machinery
PREF-29/June 2006/REV 2
Cost / Rate 0% 5% 10%
19