PROJECT DESCRIPTION
The history of distilled spirit goes back into antiquity. Science have unearthed pottery in Mesopotamia depicting fermentation scenes dating back to 4200 B.C. a small wooden model of a brewery from about 2000 B.C. is on display at the Metropolitan Museum of Art in Newyork city & Aristotle mentions a wine which produces a spirit. The first real distiller was probably a green Egyptian alchemist who in the first second century AD, in an attempt to transmute base metal into gold, boiled some wine in a crude still. The discovery of ardent spirits which remelted from this effort was looked upon with awe. It was kept a secret for centuries. The technique of distillation probably came from the Egyptians who had been interested in alchemy since the Precbristian ere. At a later time the Arabians gained this knowledge from the Egyptians. Distillation was introduced into Western Europe either through spain about 1150 AD, or by the crusaders who learned about it from the Moolems in the 12th & 13th centuries. Distilled spirits were probably known in Ireland & scotland before 12th Century, but actually it was not until then that there is a recorded history of distilled history in Europe. In India production of alcohol apart from molasses & sugarcane route the non molasses route like maize, starch, corn grain, sweet sorghum, tapioca, sugar beet are also equally getting importance as the climatic conditions for such type of agricultural crops suits in India. It is a right time for the central government through ministry of agriculture to encourage and assist state governments to introduce a policy of using only grain based alcohol for potable purpose. Molasses based alcohol may be used for industrial use as well as fuel blending. Uses & Applications Extra neutral alcohol is mainly used to make a very high quality potable alcohol used by liquor industries for the production of branded alcoholic drinks. (eg. canes, vodkas, gins, rums, liqueurs and aperitifs). Ethanol (Ethyl Alcohol or Grain Alcohol) is commonly used in alcohol. Market Survey The IMFL and beer sector is the most visible part of the alcohol industry, boasting a few large companies with multiple production units and nationwide marketing networks. These companies control much of the market, have been present in India for several decades, and have established several brand names regionally or nationally. These companies aggressively advertise and promote their brands and their corporate identities, and constantly monitor and protect their products market shares. They are also cash rich, since profit margins are high in this industry. India ranks as one of largest alcoholic beverage markets across the globe, considering that almost 70 per cent of alcohol in South East Asia is produced in India. Indias share of total alcohol beverage imports in the region is nearly 10 per cent. India's alcoholic beverages market, comprising beer, wine and spirits, will cross the Rs 1.4 lakh crore mark in 2015, compared to the current size of about Rs 50,700 crore, says an industry specific analysis of the Associated Chambers of Commerce and Industry of India (Assocham). China is the largest global spirits market.China and India are the two fastest growing markets for spirits. India is expected to overtake Russia as the second largest spirits market by 2013. The United States is predicted to be the third fastest growing spirits market through 2015. The US market has shown a gradual recovery in 2010 and 2011, with spirits volume up 2% in 2010 and a steady return to premium spirits. Vodka showed a strong and production methods dictated by the country of origin. Strong vodka growth in the US and emerging countries such as India are expected to keep vodka in the number one position in the coming years. Few Indian Major Players are as Under: Allied Blenders & Distillers Pvt. Ltd. Amber Distilleries Ltd. Amrut Distilleries Ltd. Arlem Breweries Ltd. [Merged] Arthos Breweries Ltd. Associated Breweries & Distilleries Ltd. [Merged] Aurangabad Breweries Ltd. B D A Breweries & Distilleries Ltd. B D A Pvt. Ltd. Bacardi India Pvt. Ltd. Balaji Distilleries Ltd. [Merged] Balbir Distilleries Ltd. [Merged] Baramati Grape Inds. Ltd. [Merged] Beam Global Spirits & Wine (India) Pvt. Ltd. Blossom Industries Ltd. Buckingham Distilleries & Breweries Ltd. [Merged] Castle Breweries Ltd. Central Distillery & Breweries Ltd. [Merged] Charminar Breweries Ltd. [Merged] Charosa Wineries Ltd. Cobra Indian Beer Pvt. Ltd. Devans Modern Breweries Ltd. Doburg Lager Breweries Ltd. [Erstwhile] East Coast Breweries & Distilleries Ltd. [Merged] Empee Distilleries Ltd. Foster'S India Ltd. Four Seasons Wines Ltd. Glasgow Distilleries Ltd. Grover Vineyards Ltd. Haryana Breweries Ltd. [Merged] High Range Breweries Ltd. [Merged] Hindustan Breweries & Bottling Ltd. Hyderabad Distilleries & Wineries Ltd. Impala Distillery & Brewery Ltd. Indage Vintners Ltd. Indo Lowenbrau Breweries Ltd. [Merged] Interlink Exports Ltd. Jagatjit Industries Ltd. John Distilleries Ltd. Jubilee Beverages Ltd. Kalyani Breweries Ltd. [Merged] Kedia Distilleries Ltd. Kerala Alcoholic Products Ltd. Kerala Distilleries & Allied Products Ltd. [Merged] Kesarval Beverages Ltd. [Merged] Khemani Distilleries Pvt. Ltd. Kool Breweries Ltd. Lilasons Breweries Ltd. Lilasons Industries Ltd. Malabar Breweries Ltd. [Merged] Mangalore Breweries & Distilleries Ltd. [Merged] Mcdowell & Co. Ltd. [Merged] Mehra Beverages Ltd. [Merged] Millennium Beer Inds. Ltd. [Merged] Mohan Breweries & Distilleries Ltd. Mohan Meakin Ltd. Mohan Rocky Springwater Breweries Ltd. Mount Shivalik Breweries Ltd. Mount Shivalik Inds. Ltd. Mysore Breweries Ltd. [Merged] Mysore Wine Products Ltd. [Merged] Pals Distilleries Ltd. Pernod Ricard India Pvt. Ltd. Piccadily Sugar & Allied Inds. Ltd. Pincon Spirit Ltd. Prag Distillery Pvt. Ltd. Premier Breweries Ltd. [Merged] Punjab Breweries Ltd. [Merged] Radico Khaitan Ltd. Rainbow Breweries Ltd. Rairu Distilleries Ltd. Raj Breweries Ltd. [Merged] Rajasthan Breweries Ltd. Ravikumar Distilleries Ltd. Rochees Breweries Ltd. [Merged] Salamander Distillers Ltd. [Merged] Seagram Distilleries Pvt. Ltd. Shaw Wallace & Co. Ltd. [Merged] Shaw Wallace Distilleries Limited [Merged] Shaw Wallace Distilleries Ltd. [Merged] Shiva Distilleries Ltd. Sica Breweries Ltd. [Merged] Silver Oak (India) Ltd. Skol Breweries Ltd. Skol Breweries Ltd. [Merged] Som Distilleries & Breweries Ltd. Southern Agrifurane Inds. Ltd. Southern Agrifurane Inds. Ltd. [Merged] Tilaknagar Distilleries & Inds. Ltd. [Merged] Tilaknagar Industries Ltd. Travancore Sugars & Chemicals Ltd. Tripti Alcobrew Ltd. United Breweries Ltd. Utkal Distilleries Ltd. V R V Breweries & Bottling Inds. Ltd. [Merged] Vinayak Distilleries Ltd. Vinedale Distilleries Ltd. Vitari Distilleries Ltd. [Merged] Winsome Breweries Ltd. Xylon Loquitur Distillers & Vintners 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.