PROJECT DESCRIPTION
Mild steel is the least expensive of all steel and the most common steel used. Used in nearly every type of product created from steel, it is weldable, very hard and, although it easily rusts, very durable. Containing a maximum of 0.29% carbon, this type of steel is able to be magnetized and used in almost any project that requires a vast amount of metal. Its structural strength prevents it from being used to create load-bearing girders and structural beams. Most of the TMT bars in the world is created using mild steel. This allows the bars to not only be easily welded into place, but also lets the bar flex and avoid cracking and breaking under pressure. Mild Steel Flats are basically thin strips of mild steel with the thickness of the strip varying commonly from 12mm to 100mm though thicker flats are also available. Flat bars may be considered the most basic of steel structures. Its applications range from construction to machine fabrication. TMT means Thermo mechanically treated steel its a new-generation-high-strength steel having superior properties such as weldability, strength, ductility and bendability meeting highest quality standards at international level.
Uses and Applications
TMT Bars have excellent ductility and higher fatigue strength, which make them suitable for structures and foundations that are subject to dynamic and seismic loading. Mild Steel Products are used in following industrial segments: • Boilers & Furnaces, Power Transmission Line Towers and distribution, Communication Towers, Material Handling Equipment, Automobile parts, Bus Bodies & Trailors Manufacturers, Fabrication for general purpose, EOT cranes, Elevators and Escalators, Multistory car parking systems, Industrial floor gratings, Scaffolding, Agriculture equipments and implements, Railway components, Electrification projects, Poles, Earthing, Genset frames, Crash guards and railings for highway, Windmills & it's accessories, Profile cutting, Electrical panels and capacitors, Ship building, Factory and Warehousing sheds,Gratings etc.
Market Survey
The growth in construction activity and infrastructure projects in India has buoyed the demand for steel industry. There is a demand for steel products such has Thermo Mechanically Treated (TMT) Bars, Structural steel viz., angles, plates, channels, rounds etc. Some steel experts are of the opinion that, flat products play a vital role in the economic development of a country. As economy matures, the purchasing power of the people increases, resulting in enhanced demand for automobiles and consumer goods as well as an increased use in infrastructural projects. These experts also maintain that the use of flat products in India should go over 60 percent of total finished steel consumption in the country. Steel is one of the most common materials in the world and is a major component in buildings, infrastructure, tools, ships, automobiles, machines, and appliances. It is environment friendly, can be recycled and requires considerably less energy to produce than some other metals. Leading investors have their eyes set on the huge mineral deposits.
Present Manufacturers
A H W Steels Ltd.
A S R Multimetals Pvt. Ltd.
Aarti Steels Ltd.
Adhunik Industries Ltd.
Adhunik Power Transmission Ltd.
Aditya Ispat Ltd.
Arun Smelters Ltd.
Ashiana Ispat Ltd.
B S L Scaffolding Ltd.
Balmukund Concast Ltd.
Beekay Steel Inds. Ltd.
Bhartia Commercial Co. Ltd.
Chamundi Steel Castings (India) Ltd.
Charminar Steels Ltd.
Chase Bright Steel Ltd.
Concast Ispat Ltd.
Coromandel Steels Ltd.
Deccan Alloys Pvt. Ltd.
Delta Mechcons (India) Ltd.
Dewas Metal Sections Ltd.
Dhiraj Iron & Steel Ltd.
Dina Iron & Steel Ltd.
Divy Rollform Ltd.
Dolphin Udyog Ltd.
F A G Bearings India Ltd.
G E I Power Ltd.
G K Steel & Allied Inds. Ltd.
Galaxy Bearings Ltd.
Gangotri Iron & Steel Co. Ltd.
Goa Ispat Ltd.
Golden Rathi Star Inds. Ltd.
Goyal Ispat Ltd.
Grand Bright Bars Ltd.
Handum Industries Ltd.
Handum Iron & Steel Enterprises Ltd.
Hans Metals Ltd.
I S M T Ltd.
India Steel Works Ltd.
Indian Bright Steel Co. Ltd.
Indian Steel Rolling Mills Ltd.
Indo-Germa Products Ltd.
Indore Steel & Iron Mills Ltd.
Indus Smelters Ltd.
Ispat Profiles India Ltd.
Jai Balaji Inds. Ltd.
Jai Raj Ispat Ltd.
Juhi Alloys Ltd.
K R Steelunion Ltd.
Kamal Sponge Steel & Power Ltd.
Kanishk Steel Inds. Ltd.
Kishan Chand Ferro Steels Pvt. Ltd.
Kundil Ispat Ltd.
M S P Steel & Power Ltd.
Madhusudan Special Sections Ltd.
Magnum Steels Ltd.
Mahamaya Steel Inds. Ltd.
Mahavir Rolling Mill Ltd.
Mahavir Steel Inds. Ltd.
Mahindra Sona Ltd.
Man Structurals Ltd.
Met-Rolla Steels Ltd.
Modern Steels Ltd.
National General Inds. Ltd.
O P Steels Ltd.
P M P Steel Rolling Mills (Madras) Ltd.
Peekay Re-Rolling Mills Pvt. Ltd.
Pondy Metal & Rolling Mills Pvt. Ltd.
Premier Ispat Ltd.
Prestige Stocks & Bonds Ltd.
Punj Brothers Ltd.
Purvi Bharat Steels Ltd.
R H L Profiles Ltd.
R K K R Steels Ltd.
R P G Transmission Ltd.
R R Ispat Ltd.
R S Corporation Ltd.
R S L Industries Ltd. (Duplicate Name, Uttar Pradesh)
Rathi Bars Ltd.
Rathi Rajasthan Steel Mills Ltd.
Rathi Steel & Power Ltd.
Rathi Super Steel Ltd.
Richardson & Cruddas Ltd.
Rukma Industries Ltd.
S K M Alloys Pvt. 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 Bajrang Alloys Ltd.
Shri Bhagavati Bright Bars Ltd.
Shri Ramrupai Balaji Steels Ltd.
Shri Rathi Steels Ltd.
Sirhind Steel Ltd.
Somani Swiss Inds. Ltd.
Sonal Vyapar Ltd.
Southern Iron & Steel Co. Ltd.
Sree Aravindh Steel Ltd.
Supra Global Ltd.
Suzlon Structures Ltd.
Swetal Steel Inds. Pvt. Ltd.
Tamil Nadu Small Inds. Corpn. Ltd.
Testeels Ltd.
Torus India Ltd.
Trichy Steel Rolling Mills Ltd.
Tungabhadra Steel Products Ltd.
Unique Intercontinental Ltd.
Upper India Steel Mfg. & Engg. Co. Ltd.
Utkal Steels Ltd.
V V S Alloys Ltd.
Vaibhav Mercantile Ltd.
Vijayaa Steels Ltd.
Vinayak Steels Limited
Vishwas 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.