PROJECT DESCRIPTION
Steel is the most widely used material in a large variety of applications both simple and sophisticated. Steel is produced through two process routes; the ore based blast furnace – LD converter route, scrap, or DRI based electric arc flame route. Sponge iron is a substitute for scrap in the electric arc furnace, which can be easily manufactured from indigenously available raw materials at very competitive price. Billet refers to a cast semi finished products. It is also referred to as ingot, particularly for smaller sizes. A billet is typically cast to a rectangular, hexagonal or round cross, section compatible with secondary processing e.g. forming or milling. It can be produced either as coil or cut lengths. Billets are collectively known as bar stock. The liberalization of industrial policy and other initiatives taken by the government have given a definite impetus for entry, participation and growth of the private sector in the steel industry. While the existing units are being expanded, a large number of new steel plants have also come up in different parts of the country based on modern, cost effective, state of-the-art technologies. At present, total steel making capacity is over 34 million tonnes in India, the 8th largest producer of steel in the world, has to its credit, the capability to produce a variety of grades and that too, of international quality standards. As per the ratings of the prestigious “world steel Dynamics; Indian HR products are classified in the Tier II category quality products a major reason behind their acceptance in the world market. Although the Indian steel industry enjoyed the advantage of cheap and high quality iron ore and manganese, its limited accessibility to the supply of coking coal was a constraint. The adoption of the sponge iron route by the emerging private sector integrated plants helped not only in circumventing the constraint, but also witnessed a technological revolution of sorts by the industry. As a result, India enjoys a cost advantage compared to some countries. India produced 34 mn tonnes of steel in 2003-04. Of this, 5 mn tonnes were exported. China had a world record production of 220 mn tonnes of steel in 2003-04. Global demand for steel in 2004-05, is expected to be up 6.2% to approximately 920 mn tonnes from over 860 mn tonnes in the previous year. There has been a spurt in the world demand of steel since the 2003. The industry in India has also witnessed a boom period with price realisation getting higher and higher. Exports have reinforced the trend. Exports of Iron and Steel during (April-January) 2003-04 rose by 31.5% to $ 1.85 bn, against $ 1.4 bn in the corresponding period of the preceding year. The Ninth Five Year Plan (1997-2002) had projected a demand for steel at 39 mn tonnes at the end of the plan period. This was to involve an investment in the sector of around Rs 250 bn in the last five years. The production of finished steel increased from 13.5 mn tonnes in 1990-91 to nearly 27 mn tonnes in 1999-00. The year 2000-01 witnessed an estimated production of nearly 29.5 mn tonnes. The production realised at the end of the Ninth Plan was 31.63 mn tonnes. In view of the recessionary conditions experienced prior to 2003-04, the Tenth Plan did not foresee setting up of additional capacities in the public sector. This, however, does not foreclose the options of further investments at the enterprise level. In fact, the scenario has changed and SAIL has prepared an ambitious plan of expansion. So there is very good domestic as well as export market for steel project. New entrepreneurs can well venture into this field. Few Indian Major Players are as under: A H W Steels Ltd. A S R Multimetals Pvt. Ltd. Aarti Steels Ltd. Aditya Ispat Ltd. Ankit Metal & Power Ltd. Arun Smelters Ltd. Ashiana Ispat Ltd. Assam Roofing Ltd. Balmukund Concast Ltd. Beekay Steel Inds. Ltd. Bellary Steels & Alloys Ltd. Bhartia Commercial Co. Ltd. Bhushan Steel Ltd. Brand Alloys Ltd. Charminar Steels Ltd. Chase Bright Steel Ltd. Deccan Alloys Pvt. Ltd. Dina Iron & Steel Ltd. G K Steel & Allied Inds. Ltd. G K W Ltd. Gallantt Metal Ltd. Gangotri Iron & Steel Co. Ltd. Girnar Impex Ltd. Goa Ispat Ltd. Golden Rathi Star Inds. Ltd. Goldstar Metals Ltd. Govind Mills Ltd. Govind Steel & Power Ltd. Goyal Ispat Ltd. Handum Industries Ltd. India Steel Works Ltd. India Tube Mills & Metal Inds. Ltd. Indian Bright Steel Co. Ltd. Indian Steel Rolling Mills Ltd. Indore Steel & Iron Mills Ltd. Ipisteel Ltd. Jai Balaji Inds. Ltd. Jai Bhawani Steel Enterprises Ltd. Jai Raj Ispat Ltd. Juhi Alloys Ltd. K L Concast Pvt. Ltd. K R Steelunion Ltd. Kalindi Steels & Engg. Works Ltd. Kalyani Carpenter Special Steels Ltd. Kamachi Steels Ltd. Kamani Tubes Ltd. Kamdhenu Ispat Ltd. Kanishk Steel Inds. Ltd. Kundil Ispat Ltd. M S P Steel & Power Ltd. Magnum Steels Ltd. Mangal Steel Enterprises Ltd. Met-Rolla Steels Ltd. Modern Steels Ltd. Mohan Ferro Alloys Ltd. Mukand Ltd. N H K Spring India Ltd. N R International Ltd. Nalwa Steel & Power Ltd. National General Inds. Ltd. Partap Steel Rolling Mills (1935) Ltd. Peekay Re-Rolling Mills Pvt. Ltd. Pondy Metal & Rolling Mills Pvt. Ltd. Premier Ispat Ltd. Prestige Stocks & Bonds Ltd. Progressive Steels (India) Ltd. Purvi Bharat Steels Ltd. R H L Profiles Ltd. R R Ispat Ltd. R S L Industries Ltd. (Duplicate Name, Uttar Pradesh) Radice Ispat (India) Ltd. Ramsarup Industries Ltd. Ramsarup Vyapaar Ltd. Rashtriya Ispat Nigam Ltd. Rathi Bars Ltd. Rathi Steel & Power Ltd. Raymond Ltd. Rukma Industries Ltd. S K M Steels Ltd. S M C Power Generation Ltd. S P S Steels Rolling Mills Ltd. Shimoga Steels Ltd. Shobhagya Steels Ltd. Shree Sanyeeji Ispat Ltd. Shree Sidhbali Steels Ltd. Shree Vaishnav Ispat Pvt. Ltd. Shri Bhagavati Bright Bars Ltd. Shri Rathi Steels Ltd. Sirhind Steel Ltd. Somani Swiss Inds. Ltd. Sonal Vyapar Ltd. Sree Metaliks Ltd. Sri Vasavi Inds. Ltd. Stainless India Ltd. Steel Exchange India Ltd. Sumangala Steel Pvt. Ltd. Super Inducto Steels Ltd. Surana Industries Ltd. Tata Steel Ltd. Thapar Concast Ltd. Torus India Ltd. Trichy Steel Rolling Mills Ltd. Unique Intercontinental Ltd. Upper India Steel Mfg. & Engg. Co. Ltd. Usha Iron & Ferro Metals Corpn. Ltd. V V S Alloys Ltd. Vaibhav Mercantile Ltd. Vijaya Steels Ltd. Vikash Metal & Power Ltd. Vinayaga Vyapar Ltd. Viraj Profiles Ltd. Vishwas Infocom Inds. Ltd. Volvo Steels Ltd.
|
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
- 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.
OUR APPROACH
- 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.
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.