• 0

STEEL ROLLING MILL

PROJECT DESCRIPTION

The chief departments of a metallurgical plant operating on a complete ore-to-finished product cycle are the blast furnace, steel making and rolling departments. Almost all the steel that is produced in the steel making department passes through the rolling department; only a small portion is used for making casting and forgings. The rolling process, in which the finished product is produced, is the concluding stage of metallurgical production. The finished product of such a plant is rolled stock of various types, designed for various purposes, such as: rails; beams; channels; angles; round, square or strip steel; special-purpose shapes, plate and sheet; tubes, etc. The initial material supplied to the rolling mill is the ingot which may be either square or rectangular in cross-section. In certain cases round ingots are employed (in the production of tubes, wheels and types). The rolling process in a modern metallurgical plant comprises two stages: 1) Rolling the ingot into the semifinished product and 2) Rolling the semifinished into the finished product. Under the dispensations of the governments Industrial Policy of the post-liberalisation era, four steps changed the direction of the steel industry in India. These were (i) freedom to set up integrated steel plants in the private sector; (ii) placing imports of steel under OGL (open general licence); (iii) reduction of import duties on both steel and scrap; and (iv) decontrol of domestic prices. The comparative advantage of cheap and high quality iron ore and manganese, has been somewhat set off by the limited accessibility of the steel industry to the supply of coking coal. The adoption of the sponge iron route by the private sector integrated plants helped in circumventing the constraint, and at the same time, ushered in a technological revolution in the industry. As a result, India has come to enjoy a cost advantage compared to most countries. India produced over 50 mn tonnes of steel in 2006-07. In the year 2007-08, the production had gone up to nearly 55 mn tonnes. Of this, 5.7 mn tonnes were exported. The industry in India witnessed a boom period aided by higher price realizations. Total market of steel was estimated at Rs. 1867.77 billion in 2007-08 which meant an increase of around 17% over that of the preceding year. The domestic supplies constituted some 81% of the total. The domestic demand is based on the per capita consumption in the urban sector increasing from 77 kg to 165 kg in 2019-20 at an annual growth of 5%. Likewise the per capita consumption in rural areas was expected to rise from 2 kg per annum to 4 kg by the terminal year (a CAGR of 4.4%). India has one of the lowest consumption rate in the world - around 33 kg per person to Chinas 200 kg, and South Koreas 900 kg. The thrust to an increased growth of over 7% is expected to be realised by a 13% annual increase in exports. To achieve the planned target on the basis of proposed investments, the Indian steel sector would require an estimated additional workforce of 136,000 to achieve the anticipated steel production of 68 mn tonnes by 2011-12. It was anticipated by the government. That India would reach a capacity of 124 mn tonne by 2012. Extending the horizon further, India is slated to achieve a capacity of over 240 mn tonnes per year by 2020. Chinas present capacity stands at 349 million tonnes. In this context, the steel industrys target of 110 mn tonnes by 2019-20 may be considered modest. There is a very good scope in this sector and new entrepreneurs should venture into this field. Few Indian Major Players are as under: A H W Steels Ltd. A K C Steel Inds. Ltd. A P Steel Re-Rolling Mill Ltd. Aarti Steels Ltd. Abhishek Steels Ltd. Adhunik Metaliks Ltd. Aditya Ispat Ltd. Agarwal Steel Complex Ltd. Albright Steel Inds. Ltd. Allied Steels Ltd. Allied Strips Ltd. Andhra Pradesh Steels Ltd. Anil Special Steel Inds. Ltd. Ankit Metal & Power Ltd. Apollo Metalex Pvt. Ltd. Apollo Vikas Steels Pvt. Ltd. Arun Vyapar Udyog Pvt. Ltd. Ashiana Ispat Ltd. Asian Alloys Ltd. Associated Transrail Structures Ltd. Atma Steels Ltd. Avon Ispat & Power Ltd. B S L Scaffolding Ltd. Balmukund Concast Ltd. Beekay Steel Inds. Ltd. Bellary Steels & Alloys Ltd. Benaka Sponge Iron Pvt. Ltd. Bharat Berg Ltd. Bharat Forge & Press Inds. Ltd. Bhartia Commercial Co. Ltd. Bhoruka Steel & Services Ltd. Bhushan Power & Steel Ltd. Bhushan Steel Ltd. Bhuwalka Steel Inds. Ltd. Bloom Industries Ltd. Bohmis Industries Ltd. Brindavan Alloys Ltd. Calcutta Steel Co. Ltd. Chamundi Inds. Ltd. Charminar Steels Ltd. Chase Bright Steel Ltd. Comet Steels Ltd. Concast Ispat Ltd. Coromandel Steels Ltd. Deccan Alloys Pvt. Ltd. Delta Mechcons (India) Ltd. Dewas Metal Sections Ltd. Dhar Industries Ltd. Dhiraj Iron & Steel Ltd. Divy Rollform Ltd. Dolphin Udyog Ltd. E B G India Pvt. Ltd. Eastcoast Steel Ltd. Eastern Steel & Power Ltd. Ellora Steels Ltd. Energylink (India) Pvt. Ltd. Essar Steel Ltd. Facor Steels Ltd. Ferro Concrete Co India Ltd. G K Steel & Allied Inds. Ltd. Gangotri Iron & Steel Co. Ltd. Ganpati Sponge Iron Ltd. Girish Rolled Products & Alloys Ltd. Glade Steel Pvt. Ltd. Goa Ispat Ltd. Gontermann-Peipers (India) Ltd. Goradia Steel Inds. Pvt. Ltd. Goyal Ispat Ltd. Graham Firth Steel Products (India) Ltd. Grand Bright Bars Ltd. Gujarat Natural Resources Ltd. Gwalior Strips Ltd. Hamco Steels & Alloys Ltd. Handum Industries Ltd. Handum Iron & Steel Enterprises Ltd. Hans Metals Ltd. Hariyana Metals Ltd. Haryana Concast Ltd. Haryana Foils Ltd. Hi-Tech Pipes Ltd. Him Ispat Ltd. Hisar Metal Inds. Ltd. Hitek Industries Ltd. Howrah Gases Ltd. I U P Jindal Metals & Alloys Ltd. India Steel Works Ltd. Indian Bright Steel Co. Ltd. Indian Iron & Steel Co. Ltd. Indian Steel Corpn. Ltd. Indian Steel Rolling Mills Ltd. Indore Steel & Iron Mills Ltd. Indus Smelters Ltd. Ipisteel Ltd. Ispat Industries Ltd. Ispat Jharkhand Steels Ltd. Ispat Profiles India Ltd. J S L Stainless Ltd. J S W Steel Ltd. J S W Steel Processing Centres Ltd. J V G Steels India Ltd. J V Strips Ltd. Jai Corp Ltd. Jai Raj Ispat Ltd. Jalan Ispat Castings Ltd. Jalgaon Re-Rolling Inds. Ltd. Jindal Iron & Steel Co. Ltd. Jindal Steel & Alloys Ltd. Jindal Steel & Power Ltd. Juhi Alloys Ltd. K A P Steel Ltd. K B Rolling Mills Ltd. K L Concast Pvt. Ltd. K L Rathi Steels Ltd. K L Steels Pvt. Ltd. K R Steelunion Ltd. Kalyani Gerdau Steels Ltd. Kamdhenu Ispat Ltd. Kamini Ispat Ltd. Kanishk Steel Inds. Ltd. Kaveri Steels Pvt. Ltd. Khemka Ispat Ltd. Kundil Ispat Ltd. Kusum Iron & Steel Ltd. Lloyds Steel Inds. Ltd. Loha Ispat Ltd. M S L Industries Ltd. M S P Steel & Power Ltd. Madhusudan Special Sections Ltd. Magnum Steels Ltd. Mahalakshmi Profile Ltd. Mahamaya Steel Inds. Ltd. Mahavir Rolling Mill Ltd. Mahavir Steel Inds. Ltd. Mahindra Steel Service Centre Ltd. Maitri Steels Ltd. Man Structurals Ltd. Mangal Steel Enterprises Ltd. Mardia Ispat Ltd. Marmagoa Steel Ltd. Meenakshi Steel Inds. Ltd. Meghalaya Ispat Ltd. Met-Rolla Steels Ltd. Metalman Industries Ltd. Modern Steels Ltd. Modinagar Rolls Ltd. Mohan Steels Ltd. Mohta Electro Steel Ltd. Monga Brothers Ltd. Mukand Ltd. Mukand Vijaynagar Steels Ltd. Munak Galva Sheets Ltd. N S L Ltd. [Merged] National General Inds. Ltd. National Steel & Agro Inds. Ltd. Nava Karnataka Steels Pvt. Ltd. Nicco Steels Ltd. Nipha Steels Ltd. O P Steels Ltd. Orient Steel & Inds. Ltd. P M P Steel Rolling Mills (Madras) Ltd. P M Telelinnks Ltd. Panchmahal Steel Ltd. Parshuram Steels Ltd. Partap Rajasthan Special Steels Ltd. Partap Steel Rolling Mills (1935) Ltd. Partap Steels Ltd. Pasondia Steel Profiles Ltd. Peekay Re-Rolling Mills Pvt. Ltd. Pennar Engineered Building Systems Ltd. Pennar Industries Ltd. Pithampur Steels Ltd. Pondy Metal & Rolling Mills Pvt. Ltd. Posco India Pvt. Ltd. Prabhu Steel Inds. Ltd. Prakash Industries Ltd. Premier Ispat Ltd. Prestige Stocks & Bonds Ltd. Progressive Steels (India) Ltd. Punjab Iron & Steel Co. Ltd. Purvi Bharat Steels Ltd. R H L Profiles Ltd. R K K R Steels Ltd. R M I Steels Ltd. R P G Transmission Ltd. R R Ispat Ltd. R S Corporation Ltd. R S Infra-Transmission Ltd. R S L Industries Ltd. (Duplicate Name, Uttar Pradesh) Rajasthan Ambuja Inds. Ltd. Rajinder Alloys Ltd. Ramanasekhar Steels Ltd. Ramsunar Rolsteel Ltd. Rashtriya Ispat Nigam Ltd. Rathi Alloys & Steel Ltd. Rathi Bars Ltd. Rathi Industries Ltd. Rathi Steel & Power Ltd. Reliance Ispat Inds. Ltd. Richardson & Cruddas (1972) Ltd. Richardson & Cruddas Ltd. Rishab Concast Ltd. Rohini Strips Ltd. Ruchi Strips & Alloys Ltd. S A B Industries Ltd. S K Foils Ltd. Sail Bansal Service Centre Ltd. Sandeep Industries Ltd. Sandeep Steels Ltd. Sanvijay Rolling & Engg. Ltd. Saroj Alloys & Steels Ltd. Seam Industries Pvt. Ltd. Shakti Alloy Steels Ltd. Shilpa Rerollers Ltd. Shimoga Steels Ltd. Shivalik Bimetal Controls Ltd. Shobhagya Steels Ltd. Shree Kamrup Roofings Ltd. Shree Krishna Rolling Mills (Jaipur) Ltd. Shree Mahavir Ispat Ltd. Shree Sanyeeji Ispat Ltd. Shree Sidhbali Steels Ltd. Shree Vaishnav Ispat Pvt. Ltd. Shri Bajrang Alloys Ltd. Shri Bhagavati Bright Bars Ltd. Shri Ramrupai Balaji Steels Ltd. Shri Rathi Steels Ltd. Singhal Strips Ltd. Singhal Swaroop Ispat Ltd. Sipta Coated Steels Ltd. [Erstwhile] Sirhind Steel Ltd. Siyaram India Ltd. Somani Swiss Inds. Ltd. Sonal Vyapar Ltd. Southern Iron & Steel Co. Ltd. Sree Aravindh Steel Ltd. Sri Vasavi Inds. Ltd. Steel Authority Of India Ltd. Steel Complex Ltd. Steel Strips Ltd. Steelco Gujarat Ltd. Stelco Ltd. Stelco Strips Ltd. Strong Steel Ltd. Sujana Metal Products Ltd. Sujana Towers Ltd. Sulekhram Steels Pvt. Ltd. Supra Exports Ltd. Swapna Sakar Steel Ltd. Swetal Steel Inds. Pvt. Ltd. Tamil Nadu Steels Ltd. Tata Steel Ltd. Tayo Rolls Ltd. Testeels Ltd. Tiger Steel Engg. (India) Pvt. Ltd. Tirumala Re-Rolling Pvt. Ltd. Torus India Ltd. Transpower Engineering Ltd. Trichy Steel Rolling Mills Ltd. Trident Steels Ltd. Tulsyan N E C Ltd. Tungabhadra Steel Products Ltd. U B L Industries & Investments Ltd. Unique Intercontinental Ltd. Unique Structures & Towers Ltd. Unison Metals Ltd. Upper India Steel Mfg. & Engg. Co. Ltd. Usha Alloys & Steels Ltd. Utkal Steels Ltd. Uttam Galva Steels Ltd. V S L Steels Ltd. V V S Alloys Ltd. Vallabh Steels Ltd. Vardhman Industries Ltd. Venkateshwar Ispat Ltd. Vermani Steel Strips Ltd. Vijaya Steels Ltd. Viki Industries Pvt. Ltd. Vinar Ispat Ltd. Viraj Profiles Ltd. Wheelabrator Alloy Castings Ltd. Zodiac Metal Strips Ltd. Capacity : Hot Rolled Rods 30000 MT/Annum Tor Steel 15000 MT/Annum Cold Rolled Steel 15000 MT/Annum

PROJECT AT A GLANCE
COST OF PROJECT MEANS OF FINANCE
Particulars Existing Proposed Total Particulars Existing Proposed Total
Land & Site Development Exp. ********** ********** ********** Capital ********** ********** **********
Buildings ********** ********** ********** Share Premium ********** ********** **********
Plant & Machineries ********** ********** ********** Other Type Share Capital ********** ********** **********
Motor Vehicles ********** ********** ********** Reserves & Surplus ********** ********** **********
Office Automation Equipments ********** ********** ********** Cash Subsidy ********** ********** **********
Technical Knowhow Fees & Exp. ********** ********** ********** Internal Cash Accruals ********** ********** **********
Franchise & Other Deposits ********** ********** ********** Long/Medium Term Borrowings ********** ********** **********
Preliminary& Pre-operative Exp ********** ********** ********** Debentures / Bonds ********** ********** **********
Provision for Contingencies ********** ********** ********** Unsecured Loans/Deposits ********** ********** **********
Margin Money - Working Capital ********** ********** ********** ********** ********** **********
TOTAL ********** ********** ********** TOTAL ********** ********** **********
COST OF PROJECT
Particulars Existing Proposed Total
C O S T O F P R O J E C T
Land & Site Development Exp.
Land Area Required ********** ********** **********
Land Development Cost, Boundary Wall, Gate & Road etc. ********** ********** **********
********** ********** **********
Buildings ********** ********** **********
Factory Building - ********** ********** **********
Office Buildings ********** ********** **********
********** ********** **********
Plant & Machineries ********** ********** **********
Indigenous Machineries ********** ********** **********
Erection & Installation ********** ********** **********
Laboratory Equipments ********** ********** **********
Miscellaneous Equipments like pumps, valves, pipeline & fittings ********** ********** **********
Imported Machineries ********** ********** **********
Technical know how ********** ********** **********
********** ********** **********
Office Vehicles ********** ********** **********
Office Automation Equipments (Telephone/ Fax/ Computer) ********** ********** **********
Office Equipment, Furniture plus Other Equipment & Accessories ********** ********** **********
Other Misc. Assets ********** ********** **********
Pre-operative & Preliminary Expenses ********** ********** **********
Provision for Contingencies ********** ********** **********
********** ********** **********
Total Capital Cost of Project ********** ********** **********
Margin Money for Working Capital ********** ********** **********
Total Cost of Project ********** ********** **********
PROFITABILITY AND NET CASH ACCRUALS
Particulars Operating Years
1-2 2-3 3-4 4-5 5-6
********** ********** ********** ********** **********
Revenue/Income/Realisation ********** ********** ********** ********** **********
Gross Sales Realisation ********** ********** ********** ********** **********
Less : Excise Duties/Levies ********** ********** ********** ********** **********
Net Sales Realisation ********** ********** ********** ********** **********
Total Revenue/Income/Realisation ********** ********** ********** ********** **********
********** ********** ********** ********** **********
Expenses/Cost of Products/Services/Items ********** ********** ********** ********** **********
Raw Material Cost ********** ********** ********** ********** **********
Indigenous ********** ********** ********** ********** **********
Total Nett Consumption ********** ********** ********** ********** **********
Lab & ETP Chemical Cost ********** ********** ********** ********** **********
Packing Material Cost ********** ********** ********** ********** **********
Sub Total of Net Consumption ********** ********** ********** ********** **********
Miscellaneous Cost ********** ********** ********** ********** **********
Employees Expenses ********** ********** ********** ********** **********
Fuel Expenses ********** ********** ********** ********** **********
Power/Electricity Expenses ********** ********** ********** ********** **********
Depreciation ********** ********** ********** ********** **********
Royalty & Other Charges ********** ********** ********** ********** **********
Repairs & Maintenance Exp. ********** ********** ********** ********** **********
Other Mfg. Expenses ********** ********** ********** ********** **********
Cost of Output of Goods Sold ********** ********** ********** ********** **********
********** ********** ********** ********** **********
Gross Profit ********** ********** ********** ********** **********
Administration Expenses ********** ********** ********** ********** **********
Technical Knowhow Fees & Exp. ********** ********** ********** ********** **********
Financial Charges ********** ********** ********** ********** **********
Long/Medium Term Borrowing ********** ********** ********** ********** **********
On Wkg. Capital Borrowings ********** ********** ********** ********** **********
Total Financial Charges ********** ********** ********** ********** **********
Selling Expenses ********** ********** ********** ********** **********
Total Cost of Sales ********** ********** ********** ********** **********
********** ********** ********** ********** **********
Net Profit Before Taxes ********** ********** ********** ********** **********
Tax on Profit ********** ********** ********** ********** **********
Net Profit After Taxes ********** ********** ********** ********** **********
Depreciation Added Back ********** ********** ********** ********** **********
Technical Knowhow Fees & Exp. ********** ********** ********** ********** **********
Net Cash Accruals ********** ********** ********** ********** **********
ASSSESSEMENT OF WORKING CAPITAL REQUIREMENTS
Particulars Stk.Prd. Stk.Prd. Operating Years
1st Year 2nd Yr&+ 1-2 2-3 3-4 4-5 5-6
Capacity Months Months % ********** ********** ********** ********** **********
CURRENT ASSETS ********** ********** ********** ********** **********
Stocks on Hand ********** ********** ********** ********** **********
Raw Material Cost ********** ********** ********** ********** **********
Indigenous ********** ********** M ********** ********** ********** ********** **********
Lab & ETP Chemical ********** ********** M ********** ********** ********** ********** **********
Packing Material ********** ********** M ********** ********** ********** ********** **********
Consumable Store ********** ********** M ********** ********** ********** ********** **********
Work-in-Process ********** ********** D ********** ********** ********** ********** **********
Finished Goods ********** ********** M ********** ********** ********** ********** **********
Current Expenses ********** ********** M ********** ********** ********** ********** **********
Receivables ********** ********** M ********** ********** ********** ********** **********
********** ********** ********** ********** ********** ********** **********
Total ********** ********** ********** ********** **********
Cash/Bank Balances ********** ********** ********** ********** **********
Gross Wkg. Capital ********** ********** ********** ********** **********
********** ********** ********** ********** **********
PROFITABILITY RATIOS, DSCR, DEBT EQUITY
Particulars Operating Years
1-2 2-3 3-4 4-5 5-6
Profit Percentages to Net Sales
Gross Profit ********** ********** ********** ********** **********
% Of G.P. to Net Sales ********** ********** ********** ********** **********
Net Profit Before Taxes ********** ********** ********** ********** **********
% of N.P.B.T. To Net Sales ********** ********** ********** ********** **********
Net Profit After Taxes ********** ********** ********** ********** **********
% of N.P.A.T. To Net Sales ********** ********** ********** ********** **********
Debt Service Coverage Ratio
Funds Available to Service Debts
Net Profit After Taxes ********** ********** ********** ********** **********
Depreciation Charges ********** ********** ********** ********** **********
Technical Knowhow Fees & Exp ********** ********** ********** ********** **********
Interest on Long/Medium Term ********** ********** ********** ********** **********
T o t a l ********** ********** ********** ********** **********
Debt Service Obligations
Repayment of Long/Medium Ter ********** ********** ********** ********** **********
Interest on Long/Medium Term ********** ********** ********** ********** **********
T o t a l ********** ********** ********** ********** **********
********** ********** ********** ********** **********
D. S. C. R. (Individual) ********** ********** ********** ********** **********
D. S. C. R. (Cumulative) ..... ********** ********** ********** ********** **********
D. S. C. R. (Overall) ........ ********** ********** ********** ********** **********
Parameters
Initial Equity Capital ********** ********** ********** ********** ********** **********
Credit Balance in P & L ********** ********** ********** ********** ********** **********
Total Capital excl Unsec Deposits ********** ********** ********** ********** ********** **********
Unsecured Dep. ********** ********** ********** ********** ********** **********
Total Equity incl Unsecured Deposits ********** ********** ********** ********** ********** **********
Long/Medium Term Borrowings from Bank ********** ********** ********** ********** ********** **********
Term lia. Incl Unsecured Deposit ********** ********** ********** ********** ********** **********
Total Liabilities ********** ********** ********** ********** ********** **********
Total Liabilities incl Unsecured Deposits ********** ********** ********** ********** ********** **********
DEBT EQUITY RATIO considering
i.e.Total Term Lia./NW
Unsecured Dep. as Equity ********** ********** ********** ********** ********** **********
Unsecured Dep. as Debt ********** ********** ********** ********** ********** **********
Total Outside Lia./NW ********** ********** ********** ********** **********
Assets Turnover Ratio (x) ********** ********** ********** ********** **********
No. of Shares of 10.00 each ********** ********** ********** ********** **********
Earnings Per Share (EPS) (in `) ********** ********** ********** ********** **********
Proposed divident ********** ********** ********** ********** **********
Cash EPS (in `) ********** ********** ********** ********** **********
Dividend Per Share(DPS) (in `) ********** ********** ********** ********** **********
Payout Ratio (%Age) ********** ********** ********** ********** **********
Retained Earnings/Share (in `) ********** ********** ********** ********** **********
Retained Earnings (%Age) ********** ********** ********** ********** **********
Book Value Per Share (in `) ********** ********** ********** ********** **********
Debt Per Share (in `) ********** ********** ********** ********** **********
Probable Mkt.Price/Share(in `) ********** ********** ********** ********** **********
Price / Book Value (x) ********** ********** ********** ********** **********
Price Earnings Ratio (x) ********** ********** ********** ********** **********
Yield (%Age) ********** ********** ********** ********** **********
BREAK EVEN ANALYSIS
Particulars Operating Years
Ratio 1-2 2-3 3-4 4-5 5-6
BREAK EVEN ANALYSIS
Total Value of Output ********** ********** ********** ********** **********
Variable Cost & Expenses
Raw Material Cost ********** ********** ********** ********** ********** **********
Lab & ETP Chemical Cost ********** ********** ********** ********** ********** **********
Packing Material Cost ********** ********** ********** ********** ********** **********
Sales Commission/Exp. ********** ********** ********** ********** ********** **********
Sub-total ********** ********** ********** ********** **********
Less:W.I.P. Adjustments ********** ********** ********** ********** **********
Total Variable Cost ********** ********** ********** ********** **********
Net Contribution ********** ********** ********** ********** **********
Profit Volume Ratio (%) ********** ********** ********** ********** **********
Semi-Var./Semi-Fixed Exp.
Miscellaneous Cost ********** ********** ********** ********** ********** **********
Employees Expenses ********** ********** ********** ********** ********** **********
Power/Electricity Expen ********** ********** ********** ********** ********** **********
Fuel Expenses ********** ********** ********** ********** ********** **********
Royalty & Other Charges ********** ********** ********** ********** ********** **********
Repairs & Maintenance E ********** ********** ********** ********** ********** **********
Other Mfg. Expenses ********** ********** ********** ********** ********** **********
Administration Expenses ********** ********** ********** ********** ********** **********
Selling Expenses ********** ********** ********** ********** ********** **********
Interest on Wkg.Capital ********** ********** ********** ********** ********** **********
Tot.Semi-Var./Fixed Exp. ********** ********** ********** ********** **********
**********
Fixed Expenses / Cost **********
Miscellaneous Cost ********** ********** ********** ********** ********** **********
Employees Expenses ********** ********** ********** ********** ********** **********
Power/Electricity Expen ********** ********** ********** ********** ********** **********
Fuel Expenses ********** ********** ********** ********** ********** **********
Royalty & Other Charges ********** ********** ********** ********** ********** **********
Repairs & Maintenance E ********** ********** ********** ********** ********** **********
Other Mfg. Expenses ********** ********** ********** ********** ********** **********
Administration Expenses ********** ********** ********** ********** ********** **********
Selling Expenses ********** ********** ********** ********** ********** **********
Intrest-Fixed Borrowing ********** ********** ********** ********** ********** **********
Intrest-Working Capital ********** ********** ********** ********** ********** **********
Depreciation Charges ********** ********** ********** ********** ********** **********
Deferred Expenses W/Off ********** ********** ********** ********** ********** **********
Total Fixed Expenses ********** ********** ********** ********** **********
Tot.Fixed/Semi-Fixed Exp ********** ********** ********** ********** **********
Tot.Cash Fixed/SemiFixed ********** ********** ********** ********** **********
Cash Break Even Sales ********** ********** ********** ********** **********
Cash Margin of Safety ********** ********** ********** ********** **********
Break Even Sales ********** ********** ********** ********** **********
Margin of safety ********** ********** ********** ********** **********
At Maximum Utilisation : Year ********** ********** ********** ********** **********
(as % of Installed Capacity)
Cash B.E.P. : % xx% xx% xx% xx% xx%
B.E.P. : % xx% xx% xx% xx% xx%
M E A N S O F F I N A N C E

Equity Share Capital

********** ********** **********

Others - Preference Share Capital

********** ********** **********
Total Equity Share Capital ********** ********** **********
********** ********** **********

Long/Medium Term Borrowings

********** ********** **********
FROM BANK ********** ********** **********
From Other Financial Institutions ********** ********** **********
Total Long/Medium Term Borrowings ********** ********** **********
********** ********** **********

Total Means of Finance

********** ********** **********
INTEREST AND REPAYMENT ON TERM LOANS
A Name of Institution-Bank ABC BANK
B Term Borrowing Amount ********** xx
C Repayment Term (Years) ********** Years
D Repayment Instalments ********** Instalments
E Repayment Commencement Year - 0; 3rd Qtr.
F Rate of Interest(General) xxxx% p.a.
F Rate of Interest(Initial) 0.00% p.a.
G Apply Gen. Int. Rate from Year x Quarter :: x
H Interest Calculation Quarterly
Debt Service Coverage Ratio
Funds Available to Service Debts
Net Profit After Taxes ********** ********** ********** ********** **********
Depreciation Charges ********** ********** ********** ********** **********
Technical Knowhow Fees & Expenses ********** ********** ********** ********** **********
Interest on Long/Medium Term ********** ********** ********** ********** **********
T o t a l ********** ********** ********** ********** **********
Debt Service Obligations ********** ********** ********** ********** **********
Repayment of Long/Medium Term ********** ********** ********** ********** **********
Interest on Long/Medium Term ********** ********** ********** ********** **********
T o t a l ********** ********** ********** ********** **********
********** ********** ********** ********** **********
D. S. C. R. (Individual) ********** ********** ********** ********** **********
D. S. C. R. (Cumulative) ..... ********** ********** ********** ********** **********
D. S. C. R. (Overall) ........ ********** ********** ********** ********** **********
DEPRECIATION CHARGES AS PER BOOKS (TOTAL)
Operating Year F.Assets Type A-1 F.Assets Type A-2 F.Assets Type B F.Assets Type C F.Assets Type D-1 F.Assets Type D-2 Total
Particulars Factory Building - Office Buildings PLANT & MACHINERY Office Vehicles Office Automation Equipments (Telephone/ Fax/ Computer) Furniture & Fixtures
1-2 ********** ********** ********** ********** ********** ********** **********
2-3 ********** ********** ********** ********** ********** ********** **********
3-4 ********** ********** ********** ********** ********** ********** **********
4-5 ********** ********** ********** ********** ********** ********** **********
5-6 ********** ********** ********** ********** ********** ********** **********
Particulars Method Deprn.Rate Part Consideration (for Asset put to use less than xx months)
Type A :: Buildings
Factory Building - WDV ********** **********
Office Buildings WDV ********** **********
Type C
Office Vehicles WDV ********** **********
Type D :: Misc. Fixed Assets
Office Automation Equipments (Telephone/ Fax/ Computer) WDV ********** **********
Furniture & Fixtures WDV ********** **********
Projected Pay Back Period
Particulars Operating Years
1-2 2-3 3-4 4-5 5-6
Year 1 2 3 4 5
Initial Investment *********
Total Initial Investment *********
Yearly Cash Flow ********* ********* ********* ********* *********
Accumulated Cash Flow ********* ********* ********* ********* *********
Pay Back Period xx Years xx Months xx Years xx months
Projected IRR
Year CFAT PV factor @**% *********
Initial Investment ********* ********* *********
1-2 ********* ********* *********
2-3 ********* ********* *********
3-4 ********* ********* *********
4-5 ********* ********* *********
5-6 ********* ********* *********
Total PV ********* *********
IRR ********* *********
PROJECTED BALANCE SHEET
Particulars Operating Years
1-2 2-3 3-4 4-5 5-6
Equity Share Capital ********** ********** ********** ********** **********
Surplus of Previous Year ********** ********** ********** ********** **********
Add : Net Profit After Taxes ********** ********** ********** ********** **********
Surplus at the End of Year ********** ********** ********** ********** **********
Unsecured Deposits ********** ********** ********** ********** **********
Long/Medium Term Borrowings Proposed-FROM BANK ********** ********** ********** ********** **********
Bank Borrowing for Wkg. Capital ********** ********** ********** ********** **********
Current Liabilities ********** ********** ********** ********** **********
Sundry Creditors ********** ********** ********** ********** **********
Other Current Liabilities ********** ********** ********** ********** **********
Total Current Liabilities ********** ********** ********** ********** **********
********** ********** ********** ********** **********
Total of Liabilities ********** ********** ********** ********** **********
********** ********** ********** ********** **********
A S S E T S ********** ********** ********** ********** **********
Fixed Assets ********** ********** ********** ********** **********
Gross Block ********** ********** ********** ********** **********
Less : Depreciation to Date ********** ********** ********** ********** **********
Net Block ********** ********** ********** ********** **********
Current Assets ********** ********** ********** ********** **********
Stocks on Hand ********** ********** ********** ********** **********
Receivables ********** ********** ********** ********** **********
Other Current Assets ********** ********** ********** ********** **********
Cash and Bank Balances ********** ********** ********** ********** **********
Total Current Assets ********** ********** ********** ********** **********
P & P Exp. and/or Other Dvp.Exp. ********** ********** ********** ********** **********
(To The Extent Not W/Off) ********** ********** ********** ********** **********
Other Non Current Assets ********** ********** ********** ********** **********
********** ********** ********** ********** **********
Total of Assets ********** ********** ********** ********** **********
********** ********** ********** ********** **********
ROI (Average of Fixed Assets) ********** ********** ********** ********** **********
RONW (Average of Share Capital) ********** ********** ********** ********** **********
ROI (Average of Total Assets) ********** ********** ********** ********** **********
COMPANY SUMMARY

NIIR PROJECT CONSULTANCY SERVICES (NPCS)is a reliable name in the industrial world for offering integrated technical consultancy services. NPCS is manned by engineers, planners, specialists, financial experts, economic analysts and design specialists with extensive experience in the related industries.

Our various services are: Detailed Project Report, Business Plan for Manufacturing Plant, Start-up Ideas, Business Ideas for Entrepreneurs, Start up Business Opportunities, entrepreneurship projects, Successful Business Plan, Industry Trends, Market Research, Manufacturing Process, Machinery, Raw Materials, project report, Cost and Revenue, Pre-feasibility study for Profitable Manufacturing Business, Project Identification, Project Feasibility and Market Study, Identification of Profitable Industrial Project Opportunities, Business Opportunities, Investment Opportunities for Most Profitable Business in India, Manufacturing Business Ideas, Preparation of Project Profile, Pre-Investment and Pre-Feasibility Study, Market Research Study, Preparation of Techno-Economic Feasibility Report, Identification and Selection of Plant, Process, Equipment, General Guidance, Startup Help, Technical and Commercial Counseling for setting up new industrial project and Most Profitable Small Scale Business.

NPCS also publishes varies process technology, technical, reference, self employment and startup books, directory, business and industry database, bankable detailed project report, market research report on various industries, small scale industry and profit making business. Besides being used by manufacturers, industrialists and entrepreneurs, our publications are also used by professionals including project engineers, information services bureau, consultants and project consultancy firms as one of the input in their research.

REASONS FOR BUYING THE REPORT
  1. This report helps you to identify a profitable project for investing or diversifying into by throwing light to crucial areas like industry size, demand of the product and reasons for investing in the product.
  2. This report provides vital information on the product like its definition, characteristics and segmentation.
  3. This report helps you market and place the product correctly by identifying the target customer group of the product.
  4. This report helps you understand the viability of the project by disclosing details like raw materials required, manufacturing process, project costs and snapshot of other project financials.
  5. The report provides forecasts of key parameters which helps to anticipate the industry performance and make sound business decision.
OUR APPROACH
  1. Our research reports broadly cover Indian markets, present analysis, outlook and forecast.
  2. The market forecasts are developed on the basis of secondary research and are cross-validated through interactions with the industry players.
  3. We use reliable sources of information and databases. And information from such sources is processed by us and included in the report.
TABLE OF CONTENT
Introduction
Project Introduction
Project Objective and Strategy
Concise History of the Product
Properties
BIS (Bureau of Indian Standards) Provision & Specification
Uses & Applications

Market Study and Assessment
Current Indian Market Scenario
Present Market Demand and Supply
Estimated Future Market Demand and Forecast
Statistics of Import & Export
Names & Addresses of Existing Units (Present Players)
Market Opportunity

Raw Material
List of Raw Materials
Properties of Raw Materials
Prescribed Quality of Raw Materials
List of Suppliers and Manufacturers

Personnel (Manpower) Requirements
Requirement of Staff & Labor (Skilled and Unskilled) Managerial, Technical, Office Staff and Marketing Personnel

Plant and Machinery
List of Plant & Machinery
Miscellaneous Items
Appliances & Equipments
Laboratory Equipments & Accessories
Electrification
Electric Load & Water
Maintenance Cost
Sources of Plant & Machinery (Suppliers and Manufacturers)

Manufacturing Process and Formulations
Detailed Process of Manufacture with Formulation
Packaging Required
Process Flow Sheet Diagram

Infrastructure and Utilities
Project Location
Requirement of Land Area
Rates of the Land
Built Up Area
Construction Schedule
Plant Layout and Requirement of Utilities

FINANCIAL PLAN
Assumptions for Profitability workings
Plant Economics
Production Schedule
Land & Building
  • Factory Land & Building
  • Site Development Expenses
Plant & Machinery
  • Indigenous Machineries
  • Other Machineries (Miscellaneous, Laboratory etc.)
Other Fixed Assets
  • Furniture & Fixtures
  • Pre-operative and Preliminary Expenses
  • Technical Knowhow
  • Provision of Contingencies
Working Capital Requirement Per Month
  • Raw Material
  • Packing Material
  • Lab & ETP Chemical Cost
  • Consumable Store
Overheads Required Per Month And Per Annum
  • Utilities & Overheads (Power, Water and Fuel Expenses etc.)
  • Royalty and Other Charges
  • Selling and Distribution Expenses
Salary and Wages
Turnover Per Annum
Share Capital
  • Equity Capital
  • Preference Share Capital
Annexure 1:: Cost of Project and Means of Finance
Annexure 2:: Profitability and Net Cash Accruals
  • Revenue/Income/Realisation
  • Expenses/Cost of Products/Services/Items
  • Gross Profit
  • Financial Charges
  • Total Cost of Sales
  • Net Profit After Taxes
  • Net Cash Accruals
Annexure 3 :: Assessment of Working Capital requirements
  • Current Assets
  • Gross Working. Capital
  • Current Liabilities
  • Net Working Capital
  • Working Note for Calculation of Work-in-process
Annexure 4 :: Sources and Disposition of Funds
Annexure 5 :: Projected Balance Sheets
  • ROI (Average of Fixed Assets)
  • RONW (Average of Share Capital)
  • ROI (Average of Total Assets)
Annexure 6 :: Profitability ratios
  • D.S.C.R
  • Earnings Per Share (EPS)
  • Debt Equity Ratio
Annexure 7 :: Break-Even Analysis
  • Variable Cost & Expenses
  • Semi-Var./Semi-Fixed Exp.
  • Profit Volume Ratio (PVR)
  • Fixed Expenses / Cost
  • B.E.P
Annexure 8 to 11:: Sensitivity Analysis-Price/Volume
  • Resultant N.P.B.T
  • Resultant D.S.C.R
  • Resultant PV Ratio
  • Resultant DER
  • Resultant ROI
  • Resultant BEP
Annexure 12 :: Shareholding Pattern and Stake Status
  • Equity Capital
  • Preference Share Capital
Annexure 13 :: Quantitative Details-Output/Sales/Stocks
  • Determined Capacity P.A of Products/Services
  • Achievable Efficiency/Yield % of Products/Services/Items
  • Net Usable Load/Capacity of Products/Services/Items
  • Expected Sales/ Revenue/ Income of Products/ Services/ Items
Annexure 14 :: Product wise domestic Sales Realisation
Annexure 15 :: Total Raw Material Cost
Annexure 16 :: Raw Material Cost per unit
Annexure 17 :: Total Lab & ETP Chemical Cost
Annexure 18 :: Consumables, Store etc.,
Annexure 19 :: Packing Material Cost
Annexure 20 :: Packing Material Cost Per Unit
Annexure 21 :: Employees Expenses
Annexure 22 :: Fuel Expenses
Annexure 23 :: Power/Electricity Expenses
Annexure 24 :: Royalty & Other Charges
Annexure 25 :: Repairs & Maintenance Exp.
Annexure 26 :: Other Mfg. Expenses
Annexure 27 :: Administration Expenses
Annexure 28 :: Selling Expenses
Annexure 29 :: Depreciation Charges – as per Books (Total)
Annexure 30 :: Depreciation Charges – as per Books (P & M)
Annexure 31 :: Depreciation Charges - As per IT Act WDV (Total)
Annexure 32 :: Depreciation Charges - As per IT Act WDV (P & M)
Annexure 33 :: Interest and Repayment - Term Loans
Annexure 34 :: Tax on Profits
Annexure 35 ::Projected Pay-Back Period And IRR
INFORMATION/ DISCLAIMER
  • One Lac / Lakh / Lakhs is equivalent to one hundred thousand (100,000)
  • One Crore is equivalent to ten million (10,000,000)
  • T.C.I is Total Capital Investment
  • We can modify the project capacity and project cost as per your requirement.
  • We can also prepare project report on any subject as per your requirement.
  • Caution: The project's cost, capacity and return are subject to change without any notice. Future projects may have different values of project cost, capacity or return.
Steel Rolling Mill
Capacity 200.00 MT/Day Plant and Machinery cost 275.00 Lakhs
Working Capital 0.00 Rate of Return (ROR) 61.00 %
Break Even Point (BEP) 26.00 % TCI 3897.00 Lakhs
Cost of Project 3897.00Lakhs
Add to Inquiry Basket Download Page as PDF.

STEEL ROLLING MILL
Capacity Plant and Machinery cost 429.00 Lakhs
Working Capital 0.00 Rate of Return (ROR) 45.00 %
Break Even Point (BEP) 61.00 % TCI 1145.00 Lakhs
Cost of Project 1145.00Lakhs
Add to Inquiry Basket Download Page as PDF.

NIIR PROJECT CONSULTANCY SERVICES (NPCS) is a reliable name in the industrial world for offering integrated technical consultancy services. NPCS is manned by engineers, planners, specialists, financial experts, economic analysts and design specialists with extensive experience in the related industries.

Our various services are: Detailed Project Report, Business Plan for Manufacturing Plant, Start-up Ideas, Business Ideas for Entrepreneurs, Start up Business Opportunities, entrepreneurship projects, Successful Business Plan, Industry Trends, Market Research, Manufacturing Process, Machinery, Raw Materials, project report, Cost and Revenue, Pre-feasibility study for Profitable Manufacturing Business, Project Identification, Project Feasibility and Market Study, Identification of Profitable Industrial Project Opportunities, Business Opportunities, Investment Opportunities for Most Profitable Business in India, Manufacturing Business Ideas, Preparation of Project Profile, Pre-Investment and Pre-Feasibility Study, Market Research Study, Preparation of Techno-Economic Feasibility Report, Identification and Section of Plant, Process, Equipment, General Guidance, Startup Help, Technical and Commercial Counseling for setting up new industrial project and Most Profitable Small Scale Business.

NPCS also publishes varies process technology, technical, reference, self employment and startup books, directory, business and industry database, bankable detailed project report, market research report on various industries, small scale industry and profit making business. Besides being used by manufacturers, industrialists and entrepreneurs, our publications are also used by professionals including project engineers, information services bureau, consultants and project consultancy firms as one of the input in their research.

Our Detailed Project report aims at providing all the critical data required by any entrepreneur vying to venture into Project. While expanding a current business or while venturing into new business, entrepreneurs are often faced with the dilemma of zeroing in on a suitable product/line.

And before diversifying/venturing into any product, wish to study the following aspects of the identified product:
  • Good Present/Future Demand
  • Export-Import Market Potential
  • Raw Material & Manpower Availability
  • Project Costs and Payback Period

We at NPCS, through our reliable expertise in the project consultancy and market research field, Provides exhaustive information about the project, which satisfies all the above mentioned requirements and has high growth potential in the markets. And through our report we aim to help you make sound and informed business decision.

Reasons for buying the report:
  • This report helps you to identify a profitable project for investing or diversifying into by throwing light to crucial areas like industry size, demand of the product and reasons for investing in the product.
  • This report provides vital information on the product like its definition, characteristics and segmentation.
  • This report helps you market and place the product correctly by identifying the target customer group of the product.
  • This report helps you understand the viability of the project by disclosing details like raw materials required, manufacturing process, project costs and snapshot of other project financials.
  • The report provides forecasts of key parameters which helps to anticipate the industry performance and make sound business decision.
The report contains all the data which will help an entrepreneur find answers to questions like:
  • Why I should invest in this project?
  • What will drive the growth of the product?
  • What are the costs involved?
  • What will be the market potential?

The report first focuses on enhancing the basic knowledge of the entrepreneur about the main product, by elucidating details like product definition, its uses and applications, industry segmentation as well as an overall overview of the industry sector in India. The report then helps an entrepreneur identify the target customer group of its product. It further helps in making sound investment decision by listing and then elaborating on factors that will contribute to the growth of product consumption in India and also talks about the foreign trade of the product along with the list of top importing and top exporting countries. Report includes graphical representation and forecasts of key data discussed in the above mentioned segment. It further explicates the growth potential of the product. The report includes other market data like key players in the Industry segment along with their contact information and recent developments. It includes crucial information like raw material requirements, list of machinery and manufacturing process for the plant. Core project financials like plant capacity, costs involved in setting up of project, working capital requirements, projected revenue and profit are further listed in the report.

  • Our research reports broadly cover Indian markets, present analysis, outlook and forecast.
  • The market forecasts are developed on the basis of secondary research and are cross-validated through interactions with the industry players.
  • We use reliable sources of information and databases. And information from such sources is processed by us and included in the report.

Our Market Survey cum Detailed Techno Economic Feasibility Report Contains following information:

Introduction
  • Project Introduction
  • Project Objective and Strategy
  • Concise History of the Product
  • Properties
  • BIS (Bureau of Indian Standards) Provision & Specification
  • Uses & Applications
Market Study and Assessment
  • Current Indian Market Scenario
  • Present Market Demand and Supply
  • Estimated Future Market Demand and Forecast
  • Statistics of Import & Export
  • Names & Addresses of Existing Units (Present Players)
  • Market Opportunity
Raw Material
  • List of Raw Materials
  • Properties of Raw Materials
  • Prescribed Quality of Raw Materials
  • List of Suppliers and Manufacturers
Personnel (Manpower) Requirements
  • Requirement of Staff & Labor (Skilled and Unskilled) Managerial, Technical, Office Staff and Marketing Personnel
Plant and Machinery
  • List of Plant & Machinery
  • Miscellaneous Items
  • Appliances & Equipments
  • Laboratory Equipments & Accessories
  • Electrification
  • Electric Load & Water
  • Maintenance Cost
  • Sources of Plant & Machinery (Suppliers and Manufacturers)
Manufacturing Process and Formulations
  • Detailed Process of Manufacture with Formulation
  • Packaging Required
  • Process Flow Sheet Diagram
Infrastructure and Utilities
  • Project Location
  • Requirement of Land Area
  • Rates of the Land
  • Built Up Area
  • Construction Schedule
  • Plant Layout and Requirement of Utilities
Assumptions for Profitability workings
Plant Economics
Production Schedule
Land & Building
  • Factory Land & Building
  • Site Development Expenses
Plant & Machinery
  • Indigenous Machineries
  • Other Machineries (Miscellaneous, Laboratory etc.)
Other Fixed Assets
  • Furniture & Fixtures
  • Pre-operative and Preliminary Expenses
  • Technical Knowhow
  • Provision of Contingencies
Working Capital Requirement Per Month
  • Raw Material
  • Packing Material
  • Lab & ETP Chemical Cost
  • Consumable Store
Overheads Required Per Month And Per Annum
  • Utilities & Overheads (Power, Water and Fuel Expenses etc.)
  • Royalty and Other Charges
  • Selling and Distribution Expenses
Salary and Wages
Turnover Per Annum
Share Capital
  • Equity Capital
  • Preference Share Capital
Annexure 1:: Cost of Project and Means of Finance
Annexure 2:: Profitability and Net Cash Accruals
  • Revenue/Income/Realisation
  • Expenses/Cost of Products/Services/Items
  • Gross Profit
  • Financial Charges
  • Total Cost of Sales
  • Net Profit After Taxes
  • Net Cash Accruals
Annexure 3 :: Assessment of Working Capital requirements
  • Current Assets
  • Gross Working. Capital
  • Current Liabilities
  • Net Working Capital
  • Working Note for Calculation of Work-in-process
Annexure 4 :: Sources and Disposition of Funds
Annexure 5 :: Projected Balance Sheets
  • ROI (Average of Fixed Assets)
  • RONW (Average of Share Capital)
  • ROI (Average of Total Assets)
Annexure 6 :: Profitability ratios
  • D.S.C.R
  • Earnings Per Share (EPS)
  • Debt Equity Ratio
Annexure 7 :: Break-Even Analysis
  • Variable Cost & Expenses
  • Semi-Var./Semi-Fixed Exp.
  • Profit Volume Ratio (PVR)
  • Fixed Expenses / Cost
  • B.E.P
Annexure 8 to 11:: Sensitivity Analysis-Price/Volume
  • Resultant N.P.B.T
  • Resultant D.S.C.R
  • Resultant PV Ratio
  • Resultant DER
  • Resultant ROI
  • Resultant BEP
Annexure 12 :: Shareholding Pattern and Stake Status
  • Equity Capital
  • Preference Share Capital
Annexure 13 :: Quantitative Details-Output/Sales/Stocks
  • Determined Capacity P.A of Products/Services
  • Achievable Efficiency/Yield % of Products/Services/Items
  • Net Usable Load/Capacity of Products/Services/Items
  • Expected Sales/ Revenue/ Income of Products/ Services/ Items
Annexure 14 :: Product wise domestic Sales Realisation
Annexure 15 :: Total Raw Material Cost
Annexure 16 :: Raw Material Cost per unit
Annexure 17 :: Total Lab & ETP Chemical Cost
Annexure 18 :: Consumables, Store etc.,
Annexure 19 :: Packing Material Cost
Annexure 20 :: Packing Material Cost Per Unit
Annexure 21 :: Employees Expenses
Annexure 22 :: Fuel Expenses
Annexure 23 :: Power/Electricity Expenses
Annexure 24 :: Royalty & Other Charges
Annexure 25 :: Repairs & Maintenance Exp.
Annexure 26 :: Other Mfg. Expenses
Annexure 27 :: Administration Expenses
Annexure 28 :: Selling Expenses
Annexure 29 :: Depreciation Charges – as per Books (Total)
Annexure 30 :: Depreciation Charges – as per Books (P & M)
Annexure 31 :: Depreciation Charges - As per IT Act WDV (Total)
Annexure 32 :: Depreciation Charges - As per IT Act WDV (P & M)
Annexure 33 :: Interest and Repayment - Term Loans
Annexure 34 :: Tax on Profits
Annexure 35 ::Projected Pay-Back Period And IRR