| Plant capacity | Plant & machinery | Working capital | Cost of Project | T.C.I | Return | Break even |
|---|---|---|---|---|---|---|
| 300 Kgs / Day | 6 Lakhs | - | 0 | 64 Lakhs | 51.00 | 45.00 |
| 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 | ********** | ********** | ********** |
| Particulars | Existing | Proposed | Total |
| COST OF PROJECT | |||
| 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 | ********** | ********** | ********** |
| 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 | ********** | ********** | ********** | ********** | ********** |
| 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 | ********** | ********** | ********** | ********** | ********** | |||
| ********** | ********** | ********** | ********** | ********** | ||||
| 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) | ********** | ********** | ********** | ********** | ********** | |
| 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% |
| 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 | ********** | ********** | ********** |
| 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 |
| 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) ........ | ********** | ********** | ********** | ********** | ********** |
| 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 |