From the above analysis, explanation and projection annexed, it could be assured that the unit can function profitably .
Annexure I
Statement of estimated production and sales at full capacity.
Estimated daily production -----200 . Kg
No. of estimated working days---- 300 days
Total estimated production ----60000 Kg
Sale rate per kg @ --Rs. 80/-
Estimated annual gross receipt -------Rs. 4800000/-
Statement of Depreciation
| Particulars | Years (Rs. In lakhs) |
| I | II | III | IV | V | |
| Machinery | |||||
| opening balance | 0 | 5.95 | 5.06 | 4.30 | 3.65 |
| Add. addition | 7.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total | 7.00 | 5.95 | 5.06 | 4.30 | 3.65 |
less depreciation 15 % |
1.05 | .89 | .76 | .65 | .55 |
| Closing Balance | 5.95 | 5.06 | 4.30 | 3.65 | 3.15 |
| Other Assets | |||||
| opening balance | 0.00 | 0.90 | 0.81 | .73 | .66 |
| Add. addition | 1.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Total | 1.00 | 0.90 | .81 | .73 | .66 |
less depreciation 10 % |
0.10 | 0.09 | .08 | .07 | .06 |
| Closing Balance | 0.90 | 0.81 | 0.73 | 0.76 | 0.60 |
| W.D.V | 6.85 | 5.87 | 5.03 | 4.31 | 3.70 |
| Depreciation | 1.15 | .98 | .84 | .72 | .61 |
Statement of loan repayment and interest on loan
Term loan Rs. 5 lakhs @ 13 % interest
Repayment in 5 years
| Particulars | Years (Rs. In Lakhs) |
| I | II | III | IV | V | |
Opening Balance |
0.00 | 4.00 | 3.00 | 2.00 | 1.00 |
| Add Addition | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Add interest | .65 | 0.52 | 0.39 | 0.26 | 0.13 |
| Total | 5.65 | 4.52 | 3.39 | 2.26 | 1.13 |
Less paid during the year |
|||||
| Principal | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| Interest | 0.65 | 0.52 | 0.39 | 0.26 | 0.13 |
| Total | 1.65 | 1.52 | 1.39 | 1.26 | 1.13 |
| Closing Balance | 4.00 | 3.00 | 2.00 | 1.00 | 0.00 |
Statement of Working Capital requirement
| Particulars | Years (Rs. In Lakhs0 |
| I | II | III | IV | V | |
| I. Current Assets | |||||
| a. Raw materials 2 week | 1.20 | 1.26 | 1.32 | 1.38 | 1.44 |
| b. finished goods 5 days | 0.60 | 0.63 | 0.66 | 0.69 | 0.72 |
| c. sundry debtors 2 week | 1.20 | 1.26 | 1.32 | 1.38 | 1.44 |
| D. Total | 3.00 | 3.15 | 3.30 | 3.45 | 3.60 |
| II Current liabilities | |||||
| a. Sundry creditors 1 week | 0.50 | 0.55 | 0.60 | 0.65 | 0.70 |
| Total | 0.50 | 0.55 | 0.66 | 0.65 | 0.70 |
| Net working capital | 2.50 | 2.60 | 2.70 | 2.80 | 2.90 |
| Particulars | Years (Rs. In lakhs) |
| I | II | III | IV | V | |
| A .Estimated gross receipt at full capacity | 48.00 | ||||
| B. Capacity utilization | 70% | 75% | 80% | 85% | 90% |
| C. Income gross sale | 33.60 | 36.00 | 38.40 | 40.80 | 43.20 |
| D. Direct expenses | |||||
| 1.Raw materials. | 18.63 | 19.96 | 21.29 | 22.62 | 23.95 |
| 2. Wages. | 6.90 | 7.40 | 7.90 | 8.40 | 8.90 |
| 3. Other direct cost | 0 .60 | 0 .64 | 0 .68 | 0 .72 | 0 .76 |
| TOTAL | 26.13 | 28.00 | 29.87 | 31.74 | 33.61 |
| E. Gross profit (C-D) | 7.47 | 8.00 | 8.53 | 9.06 | 9.59 |
| F . Indirect cost | |||||
| 1. Interest on loan | 0.91 | 0.78 | 0.65 | 0.52 | 0.39 |
| 2. Depreciation | 1.15 | 0 .98 | 0 .84 | 0.72 | 0.61 |
| 3. Other administrative expenses | 1.61 | 1.73 | 1.85 | 1.97 | 2.09 |
| TOTAL | 3.67 | 3.49 | 3.34 | 3.21 | 3.09 |
| G. Profit before tax | 3.80 | 4.51 | 5.19 | 5.38 | 6.50 |
| H. Less income tax @10% | 0.38 | 0.45 | 0.50 | 0.51 | 0.65 |
| I. Profit after Tax(G-H) | 3.42 | 4.06 | 4.69 | 5.34 | 5.85 |
| J. Depreciation | 1.15 | 0.98 | 0.84 | 0.72 | 0.61 |
| NET CASH ACCRUED (I+J) | 4.57 | 5.04 | 5.53 | 6.06 | 6.46 |
Statement of Projected Cash Flow
| Particulars | Years (Rs. In lakhs) |
| I | II | III | IV | V | |
| A. Source of fund | |||||
| 1. Promoters contribution | 3.50 | 0.00 | 0.00 | 0.00 | 0.00 |
| 2. Bank loan | 7.00 | 0.00 | 0.00 | 0.00 | 0.00 |
3. Net cash accrued from operation |
4.57 | 5.04 | 5.53 | 6.06 | 6.46 |
| Total | 15.07 | 5.04 | 5.53 | 6.06 | 6.46 |
| B. Application of fund | |||||
| 1. Capital expenditure | 8.00 | ||||
| 2. Change in working capital | 2.50 | 1.33 | 1.33 | 1.33 | 1.33 |
| 3. Loan repayment | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| 4. Drawing by the proprietor | 1.00 | 1.00 | 1.00 | 1.50 | 1.50 |
| Total | 12.50 | 3.33 | 3.33 | 3.83 | 3.83 |
| C. Opening Cash Bank balance | 0.00 | 2.57 | 4.28 | 6.48 | 8.71 |
| D. Add net Surplus(A-B) | 2.57 | 1.71 | 2.20 | 2.23 | 2.63 |
| E. Closing balance | 2.57 | 4.28 | 6.48 | 8.71 | 11.34 |
Statement of financial viability indices
D.S.C.R
| Particulars | Years(Rs. In lakhs) |
| I | II | III | IV | V | |
A. Net Cash accrued from operation |
4.57 | 5.04 | 5.53 | 6.06 | 6.46 |
| B. Add interest on loan | .91 | .78 | .65 | .52 | .39 |
| Total fund available (A+B) | 5.48 | 5.82 | 6.18 | 6.58 | 6.85 |
| C. .Repayment of loan | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| D. Add interest | 0.91 | 0.78 | 0.65 | 0.52 | 0.39 |
E. Debt service requirement(C+D) |
1.91 | 1.78 | 1.65 | 1.52 | 1.39 |
| D. D.S.C.R. | 2.86 | 3.26 | 3.74 | 4.32 | 4.92 |
| Average D.S.C.R | 3.82 |
Break Even Analysis
| Particulars | Years (Rs. In lakhs) |
| I | II | III | IV | V | |
| a. Sales | 33.60 | 36.00 | 38.40 | 40.80 | 43.10 |
| b. Variable cost | 26.13 | 28.00 | 29.87 | 31.74 | 33.61 |
| c. Contribution | 7.47 | 8.00 | 8.53 | 9.06 | 9.61 |
| d. Fixed cost | 3.67 | 3.49 | 3.34 | 3.21 | 3.09 |
| e. Breakeven point | 49.12 | 43.62 | 39.15 | 35.43 | 32.15 |
Statement of projected balance sheet
| Particulars | Years(Rs. In lakhs) |
| I | II | III | IV | V | |
| A. Capital and liabilities | |||||
| 1.Promotors Capital | 3.50 | 3.50 | 3.50 | 3.50 | 3.50 |
| 2. Reserve and Surplus | 2.42 | 4.25 | 6.71 | 9.32 | 12.44 |
| 3. Loan Fund | 6.00 | 5.00 | 4.00 | 3.00 | 2.00 |
| 4. Current liabilities | 0.50 | 0.55 | 0.60 | 0.65 | 0.70 |
| Total | 12.42 | 13.30 | 14.81 | 16.41 | 18.64 |
| B. Assets | |||||
| 1. Fixed Asset | 6.85 | 5.87 | 5.03 | 4.31 | 3.70 |
| 2. Current Asset | |||||
| Inventory | 1.80 | 1.89 | 1.98 | 2.07 | 2.16 |
| Debtors | 1.20 | 1.26 | 1.32 | 1.38 | 1.44 |
| Cash Bank Balance | 2.57 | 4.28 | 6.48 | 8.71 | 11.34 |
| Total | 12.42 | 13.30 | 14.81 | 16.47 | 18.64 |