DE

ETAILED PROJEC
CT REPOR
RT

SOYA MILK UN
NIT

U
UNDER PM
MFME SC
CHEME

National Institute of Food Technnology Entreppreneurship and Manageement

Minnistry of Foood Processinng Industries

Pllot No.97, Seector-56, HS

SIIDC, Indusstrial Estate, Kundli, Sonnipat, Haryaana-131028

W
Website: http://www.nifteem.ac.in

E
Email: pmfm
[email protected]

C
Call: 0130-22281089
 PM FME‐ Detailed Project Report of Soya Milk Unit

TABLE OF CONTENTS

S No. Topic Page

Number
1. Project Summary 3
2. About the Product 4-5
3. Process Flow Chart 6-7
4. Economics of the Project 8-26
4.1. Basis & Presumptions 8
4.2. Capacity , Utilisation, Production & Output 9-10
4.3. Premises/Infrastructure 10
4.4. Machinery & Equipments 11-14
4.5. Misc. Fixed Assets 15
4.6. Total Cost of Project 15
4.7. Means of Finance 15
4.8 Term Loan 16
4.9. Term Loan repayment & interest schedule 16-19
4.10. Working Capital Calculations 19
4.11. Salaries/Wages 20
4.12. Power Requirement 21
4.13. Depreciation Calculation 21
4.14. Repairs & Maintenance 22
4.15. Projections of Profitability Analysis 22
4.16. Break Even Point Analysis 23
4.17. Projected Balance Sheet 24
4.18. Cash- Flow Statement 25
4.19. Debt-Service Coverage Ratio 26

2
 PM FME‐ Detailed Project Report of Soya Milk Unit

1. PROJECT SUMMARY
1. Name of the proposed project : Soya Milk Unit
2. Nature of proposed project : Proprietorship/Company/Partnership
3. Proposed project capacity : 108000 Ltr/annum(50,55,60,65&70% capacity
utilization in 1st to 5th Year respectively)

4. Raw material : Soyabean, sugar and other chemicals and

flavours.
5. Major product outputs : Soya Milk
6. Total project cost : Rs. 26.11 Lakh
 Land development, building & Civil : Nil
Construction
 Machinery and equipment’s : Rs. 17.90 Lakh
 Miscellaneous Fixed Assets : Rs. 2.10 Lakh
 Working capital : Rs. 6.11 Lakh
8. Means of Finance
 Subsidy (max 10lakhs) : Rs. 7.00 Lakh

 Promoter’s contribution (min10%) : Rs. 2.60 Lakh

 Term loan : Rs.11.00 Lakh

 Working Capital Requirement : Rs. 5.50 Lakh
9. Profit after Depreciation, Interest & Tax

 1styear : Rs. 1.49 Lakh

 2ndyear : Rs. 3.22 Lakh
rd
 3 year : Rs. 5.04 Lakh
 4th year : Rs. 7.40Lakh
 5th year : Rs. 9.66Lakh
11. Average DSCR : Rs. 2.92
12. Term loan repayment : 5 Years with 6 months grace period

3
 PM FME‐ Detailed Project Report of Soya Milk Unit

2. ABOUT THE PRODUCT

2.1. PRODUCT INTRODUCTION:

Soya Milk is an inexpensive and remarkably versatile high protein food made from soya beans. It
is a white liquid made from the seed. Unlike most other protein foods, milk is entirely free from
cholesterol and low in fat (specially saturated fats).

The quality of protein is as high as that found in chicken. It is also good for dieters as this
contain low calories. It is an excellent food for babies, children, elderly people, pregnant and
lactating women since it contains vegetable protein which is very nutritious and easy to digest.

Soya milk and its derivatives are the cheapest source of protein, its derivatives tofu (soya paneer)
makes tasty dishes like matar paneer, Palak paneer etc. and snacks like soya burger, patties,
sandwiches, pakoras etc. and also used in desserts.

It’s a good source of potassium and can be fortified with Vitamins A, B-12 and D as well as
Calcium. It contains as much protein as Cow’s Milk, yet is lower in calories than the whole milk
and about equal to the calories in 1 percent or 2 percent milk. It contains very little saturated fats.

4
 PM FME‐ Detailed Project Report of Soya Milk Unit

2.2. MARKET POTENTIAL:

With the increasing health consciousness among the general people, the use of soyabean is
getting acceptance in the form of textured vegetable protein (popularly known as Soya baadi or
Soya nuggets), Soya fortified wheat flour, Soya milk, Tofu and Soya curd etc. Being mainly the
country of vegetarians, India has indeed a very great potential for Soya milk, paneer and curd.
Experts predict that the Soya food industry will grow 20% annually over the next few years.

2.3. RAW MATERIAL DESCRIPTION:

Raw material that are required for Soya Milk making unit are:

1. Soybean
2. Chemicals, flavors, color and other material etc.
3. Sugar

S.N. Particulars Rate

1 Soybean 35-40/Kg

2 Sugar 30-35/kg

Average raw material cost per 1 Ltr Packet of Soya Milk: Rs. 70-90

5
 PM FME‐ Detailed Project Report of Soya Milk Unit

3. PROCESS FLOW CHART

Soya milk is made from whole soya beans or full-fat soya flour. The dry beans are soaked in
water for a minimum of three hours up to overnight depending on the temperature of the water.
The rehydrated beans then undergo wet grinding with enough added water to give the desired
solids content to the final product which has a protein content of 1–4%, depending on the method
of production. The ratio of water to beans on a weight basis is 10:1 for traditional soya milk. The
resulting slurry or purée is brought to a boil in order to improve its taste properties by heat
inactivating soybean trypsin inhibitor, improve its flavor, and to sterilize the product.

Heating at or near the boiling point is continued for a period of time, 15–20 minutes, followed by
the removal of insoluble residues (soya pulp fiber) by filtration.

Processing requires the use of an anti-foaming agent or natural defoamer during the boiling step.
Bringing filtered soya milk to a boil avoids the problem of foaming. It is generally opaque, white
or off-white in color, and approximately the same consistency as cow's milk. Raw soya milk may
be sweetened, flavored, and fortified with micronutrients. Once fully processed, soya milk
products are typically sold in plastic bottles or plastic-coated cartons, such as tetra packs.

6
 PM FME‐ Detailed Project Report of Soya Milk Unit

Soyabeans

Washing

Soaking

Grinding

Centrifugal Filtration

Formulation

Sterilization

Cooling

Filling

7
 PM FME‐ Detailed Project Report of Soya Milk Unit

4. ECONOMICS OF THE PROJECT

4.1. BASIS & PRESUMPTIONS

1. Production Capacity of Soya Milk is 50 Ltr. per hr. First year, Capacity has been taken @
50%.

2. Working shift of 8 hours per day has been considered.

3. Raw Material stock is for 7 days and Finished goods Closing Stock has been taken for 7 days.

4. Credit period to Sundry Debtors has been given for 20 days.

5. Credit period by the Sundry Creditors has been provided for 7 days.

6. Depreciation and Income tax has been taken as per the Income tax Act, 1961.

7. Interest on working Capital Loan and Term loan has been taken at 11%.

8. Salary and wages rates are taken as per the Current Market Scenario.

9. Power Consumption has been taken at 12 KW.

10. Increase in sales and raw material costing has been taken @ 5% on a yearly basis.

8
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.2. CAPACITY, UTILIZATION, PRODUCTION & OUTPUT

COMPUTATION OF PRODUCTION OF SOYA MILK

Items to be Manufactured
Soya Milk

Machine capacity Per hour 50 Ltr

Total working Hours 8
Machine capacity Per Day 400 Ltr
Working days in a month 25 Days
Working days per annum 300
Wastage Considered 10%
Raw material requirement 120000 Ltr
Final Output per annum after wastage 108000 Ltr
Final Product to be packed in 1 Ltr Packet
Number of Packets per annum 108000 1 Ltr Packet

Production of Soya Milk

Production Capacity Ltr.
1st year 50% 54,000
2nd year 55% 59,400
3rd year 60% 64,800
4th year 65% 70,200
5th year 70% 75,600

9
 PM FME‐ Detailed Project Report of Soya Milk Unit

Raw Material Cost

Year Capacity Rate Amount
Utilisation (per Ltr.) (Rs. in lacs)
1st year 50% 70.00 42.00

2nd year 55% 74.00 48.84

3rd year 60% 78.00 56.16
4th year 65% 82.00 63.96
5th year 70% 86.00 72.24

COMPUTATION OF SALE

Particulars 1st year 2nd year 3rd year 4th year 5th year
Op Stock - 1,260 1,386 1,512 1,638

Production 54,000 59,400 64,800 70,200 75,600

Less : Closing Stock 1,260 1,386 1,512 1,638 1,764
Net Sale 52,740 59,274 64,674 70,074 75,474
Sale price per packet 140.00 147.00 154.00 162.00 170.00
Sales (in Lacs) 73.84 87.13 99.60 113.52 128.31

4.3. PREMISES/INFRASTRUCTURE

The approximate total area required for complete factory setup is 2000-2500 Sq. ft. for
smooth production including storage area. It is expected that the premises will be on rental.

10
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.4. MACHINERY & EQUIPMENTS

Machine Name Description Machine Image.

Dry Bean Tank These equipment’s are class of
storage equipment’s which are
specifically designed for dry raw
material of small granule
composition.

Soya bean This machine is basically used to

Transferring transfer soya bean to Soaking and
Machine washing machine for further process.

Soya bean Soybean Soaking & Washing

Soaking & Machine use compressed air
Washing injection in water to roll the beans,
Machine separate bad Soybean and other
impurities which float on the water
and then are simply discharged with
overflow to get the pure soybean.
Grinding and Grinding & Separating Machine are
Separating usedfor grinding rice, soybeans and
Machine all sorts of beans into soy milk, rice
milk and carrot cakes. Many small
stores choose the
versatile machine for a priority to

11
 PM FME‐ Detailed Project Report of Soya Milk Unit

lower the cost

Soymilk In this machine time and temperature
Cooking for cooking are operated on the panel
Machine and thus facilitate cooking of
condensed food. They can be used
for cooking not only soy milk but
also Rice Milk, soup and
concentrated sauce like spaghetti
sauce.
Soymilk Storage After the soy milk is prepared this
Tank equipment is used to store the soy
milk. Therefore, they serve as
machines for temporary storage and
transports the right amount of soy
milk to the next device in operation
on the basis of device capacity.
Sugar Dissolving This machine is used to dissolve
Machine sugar in the soy milk in the right
quantity and provides taste to the
product.

Soy milk Twin Soy milk Twin Filter

Filter machine Machine removes the main residues
from expansion of boiled pulp and
whey sugar particles that are too
large.

Homogenizer This equipment is used in the

production of liquid mixtures in

12
 PM FME‐ Detailed Project Report of Soya Milk Unit

which the said mixture, is forced

through a small passage at high
velocity. This machine reduces
solute globule size to a very small
size in order to prevent aggregate
formation.
Soymilk Plate Soy milk Plate Heat
Heat Exchanger Exchanger Equipment is a
Machine pasteurization process to
improve soy milk's shelf life.
Using Soy milk Plate Heat
Exchanger Equipment destroys
bacteria and improves soy
milk's quality. Soy milk Plate Heat
Exchanger Equipment is suitable for
the production of soy milk (Long
Life soy milk) or juice.
Soymilk Filling This machine is used to fill the
and Sealing finished product in pouches or cans
Equipment of different sizes and the product is
ready for sale in the market.

Material These Equipments are used for

handling and material handling. Other
other equipments like water pumps,
Equipments conveyors, weighing machine, etc
are also used.

13
 PM FME‐ Detailed Project Report of Soya Milk Unit

Machine Unit Rate Price

Dry Bean Tank 21 40000 80000
Soya bean Transferring Machine 1 175000 175000
Soya bean Soaking & Washing Machine 1 200000 200000
Grinding and Separating Machine 1 100000 100000
Soymilk Cooking Machine 1 170000 170000
Soymilk Storage Tank (Capacity 100-1000 1 80000 80000
ltr)
Sugar Dissolving Machine 1 150000 150000
Soy milk Twin Filter machine 1 20000 20000

Homogenizer (Capacity 300 Ltr/hr.) 1 195000 195000

Soymilk Plate Heat Exchanger Machine 1 120000 120000
Soymilk Filling and Sealing 1 150000 150000
Equipment(Capacity 150-200 pouch/hour)
Material handling and other equipments - 350000 350000
(Bins, trolley, conveyor, silos, weighing
machine, etc.)

Note: Total Machinery cost shall be Rs17.90 lakh including equipment’s but excluding
GST and Transportation Cost.

14
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.5. MISCELLANEOUS FIXED ASSETS

 Water Supply Arrangements
 Furniture & Fixtures
 Computers & Printers

4.6. TOTAL COST OF PROJECT

COST OF PROJECT
(in Lacs)

PARTICULARS Amount

Land & Building Owned/Rented

Plant & Machinery 17.90
Miscellaneous Assets 2.10
Working capital 6.11
Total 26.11

4.7. MEANS OF FINANCE

MEANS OF FINANCE

PARTICULARS AMOUNT
Own Contribution (min 10%) 2.60
Subsidy @35%(Max. Rs 10 Lac) 7.00
Term Loan @ 55% 11.00
Working Capital (Bank Finance) 5.50
Total 26.11

15
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.8. TERM LOAN: Term loan of Rs. 11.00 Lakh is required for project cost of
Rs. 26.11 Lakh

4.9. TERM LOAN REPAYMENT& INTEREST SCHEDULE

REPAYMENT SCHEDULE OF TERM LOAN

Interest 11.00%
Closing
Year Particulars Amount Addition Total Interest Repayment Balance
1st Opening Balance

1st month - 11.00 11.00 - - 11.00

2nd month 11.00 - 11.00 0.10 - 11.00

3rd month 11.00 - 11.00 0.10 - 11.00

4th month 11.00 - 11.00 0.10 11.00

5th month 11.00 - 11.00 0.10 11.00

6th month 11.00 - 11.00 0.10 11.00

7th month 11.00 - 11.00 0.10 0.20 10.80

8th month 10.80 - 10.80 0.10 0.20 10.59

9th month 10.59 - 10.59 0.10 0.20 10.39

10th month 10.39 - 10.39 0.10 0.20 10.19

11th month 10.19 - 10.19 0.09 0.20 9.98

12th month 9.98 - 9.98 0.09 0.20 9.78

1.08 1.22
2nd Opening Balance

1st month 9.78 - 9.78 0.09 0.20 9.57

2nd month 9.57 - 9.57 0.09 0.20 9.37

3rd month 9.37 - 9.37 0.09 0.20 9.17

16
 PM FME‐ Detailed Project Report of Soya Milk Unit

4th month 9.17 - 9.17 0.08 0.20 8.96

5th month 8.96 - 8.96 0.08 0.20 8.76

6th month 8.76 - 8.76 0.08 0.20 8.56

7th month 8.56 - 8.56 0.08 0.20 8.35

8th month 8.35 - 8.35 0.08 0.20 8.15

9th month 8.15 - 8.15 0.07 0.20 7.94

10th month 7.94 - 7.94 0.07 0.20 7.74

11th month 7.74 - 7.74 0.07 0.20 7.54

12th month 7.54 - 7.54 0.07 0.20 7.33

0.95 2.44
3rd Opening Balance

1st month 7.33 - 7.33 0.07 0.20 7.13

2nd month 7.13 - 7.13 0.07 0.20 6.93

3rd month 6.93 - 6.93 0.06 0.20 6.72

4th month 6.72 - 6.72 0.06 0.20 6.52

5th month 6.52 - 6.52 0.06 0.20 6.31

6th month 6.31 - 6.31 0.06 0.20 6.11

7th month 6.11 - 6.11 0.06 0.20 5.91

8th month 5.91 - 5.91 0.05 0.20 5.70

9th month 5.70 - 5.70 0.05 0.20 5.50

10th month 5.50 - 5.50 0.05 0.20 5.30

11th month 5.30 - 5.30 0.05 0.20 5.09

12th month 5.09 - 5.09 0.05 0.20 4.89

0.68 2.44

17
 PM FME‐ Detailed Project Report of Soya Milk Unit

4th Opening Balance

1st month 4.89 - 4.89 0.04 0.20 4.69

2nd month 4.69 - 4.69 0.04 0.20 4.48

3rd month 4.48 - 4.48 0.04 0.20 4.28

4th month 4.28 - 4.28 0.04 0.20 4.07

5th month 4.07 - 4.07 0.04 0.20 3.87

6th month 3.87 - 3.87 0.04 0.20 3.67

7th month 3.67 - 3.67 0.03 0.20 3.46

8th month 3.46 - 3.46 0.03 0.20 3.26

9th month 3.26 - 3.26 0.03 0.20 3.06

10th month 3.06 - 3.06 0.03 0.20 2.85

11th month 2.85 - 2.85 0.03 0.20 2.65

12th month 2.65 - 2.65 0.02 0.20 2.44

0.41 2.44
5th Opening Balance

1st month 2.44 - 2.44 0.02 0.20 2.24

2nd month 2.24 - 2.24 0.02 0.20 2.04

3rd month 2.04 - 2.04 0.02 0.20 1.83

4th month 1.83 - 1.83 0.02 0.20 1.63

5th month 1.63 - 1.63 0.01 0.20 1.43

6th month 1.43 - 1.43 0.01 0.20 1.22

7th month 1.22 - 1.22 0.01 0.20 1.02

8th month 1.02 - 1.02 0.01 0.20 0.81

9th month 0.81 - 0.81 0.01 0.20 0.61

10th month 0.61 - 0.01 0.20 0.41

18
 PM FME‐ Detailed Project Report of Soya Milk Unit

0.61

11th month 0.41 - 0.41 0.00 0.20 0.20

12th month 0.20 - 0.20 0.00 0.20 -

0.15 2.44
DOOR TO DOOR 60 MONTHS
MORATORIUM
PERIOD 6 MONTHS
REPAYMENT PERIOD 54 MONTHS

4.10. WORKING CAPITAL CALCULATIONS

COMPUTATION OF CLOSING STOCK & WORKING CAPITAL (in Lacs)

PARTICULARS 1st year 2nd year 3rd year 4th year 5th year
Finished Goods
1.45 1.65 1.86 2.09 2.33

Raw Material
0.98 1.14 1.31 1.49 1.69
Closing Stock 2.43 2.79 3.17 3.58 4.02

COMPUTATION OF WORKING CAPITAL REQUIREMENT

TRADITIONAL METHOD (in Lacs)
Particulars Amount Own Margin Bank Finance
Finished Goods & Raw Material 2.43
Less : Creditors 0.98
Paid stock 1.45 10% 0.15 90% 1.31
Sundry Debtors 4.92 10% 0.49 90% 4.43
6.38 0.64 5.74
MPBF 5.74
WORKING CAPITAL LIMIT DEMAND ( from Bank) 5.50
Working Capital Margin 0.61

19
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.11. SALARY & WAGES

BREAK UP OF LABOUR CHARGES

Particulars Wages No of Total

Rs. per Month Employees Salary

Plant Operator 15,000 2 30,000

Supervisor 18,000 1 18,000
Skilled (in thousand rupees) 12,000 2 24,000
Unskilled (in thousand rupees) 8,500 2 17,000
Total salary per month 89,000
Total annual labour charges (in lacs) 10.68

BREAK UP OF STAFF SALARY CHARGES

Particulars Salary No of Total

Rs. per Month Employees Salary
Administrative Staff 6,500 1 6,500
Manager 18,000 1 18,000
Accountant 15,000 1 15,000
Total salary per month 39,500
Total annual Staff charges (in lacs) 4.74

20
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.12 POWER REQUIREMENT

Utility Charges (per month)

Particulars value Description
Power connection required 12 KWH
consumption per day 96 units

Consumption per month 2,400 units

Rate per Unit 10 Rs.
power Bill per month 24,000 Rs.

4.13. DEPRECIATION CALCULATION

COMPUTATION OF DEPRECIATION (in Lacs)

Description Plant & Machinery Miss. Assets TOTAL
Rate of Depreciation 15.00% 10.00%
Opening Balance - - -

Addition 17.90 2.10 20.00

Total 17.90 2.10 20.00
Less : Depreciation 2.69 0.21 2.90
WDV at end of Year 15.22 1.89 17.11
Additions During The Year - - -
Total 15.22 1.89 17.11
Less : Depreciation 2.28 0.19 2.47
WDV at end of Year 12.93 1.70 14.63
Additions During The Year - - -
Total 12.93 1.70 14.63
Less : Depreciation 1.94 0.17 2.11
WDV at end of Year 10.99 1.53 12.52
Additions During The Year - - -
Total 10.99 1.53 12.52
Less : Depreciation 1.65 0.15 1.80
WDV at end of Year 9.34 1.38 10.72
Additions During The Year - - -
Total 9.34 1.38 10.72
Less : Depreciation 1.40 0.14 1.54
WDV at end of Year 7.94 1.24 9.18

21
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.14. REPAIR & MAINTENANCE: Repair & Maintenance is 3.0% of Gross Sale.

4.15. PROJECTIONS OF PROFITABILITY ANALYSIS

PROJECTED PROFITABILITY STATEMENT (in Lacs)

PARTICULARS 1st year 2nd year 3rd year 4th year 5th year
Capacity Utilisation % 50% 55% 60% 65% 70%

SALES
Gross Sale
Soya Milk 73.84 87.13 99.60 113.52 128.31

Total 73.84 87.13 99.60 113.52 128.31

COST OF SALES
Raw Material Consumed 42.00 48.84 56.16 63.96 72.24
Electricity Expenses 2.88 3.31 3.81 4.38 4.82
Depreciation 2.90 2.47 2.11 1.80 1.54
Wages & labour 10.68 11.75 12.81 13.83 14.94
Repair & maintenance 2.22 2.61 2.99 3.41 3.85
Packaging 1.62 1.74 1.99 2.27 2.57
Cost of Production 62.29 70.73 79.86 89.65 99.95
Add: Opening Stock /WIP - 1.45 1.65 1.86 2.09
Less: Closing Stock /WIP 1.45 1.65 1.86 2.09 2.33
Cost of Sales 60.84 70.53 79.65 89.42 99.71
GROSS PROFIT 13.00 16.60 19.95 24.10 28.60
17.60% 19.05% 20.03% 21.23% 22.29%
Salary to Staff 4.74 5.69 7.11 7.82 8.76
Interest on Term Loan 1.08 0.95 0.68 0.41 0.15
Interest on working Capital 0.61 0.61 0.61 0.61 0.61
Rent 3.60 3.96 4.36 4.79 5.27
selling & adm exp 1.48 2.18 1.99 2.32 2.69
TOTAL 11.50 13.38 14.75 15.95 17.48
NET PROFIT 1.49 3.22 5.20 8.15 11.12
2.02% 3.69% 5.22% 7.18% 8.67%
Taxation - - 0.17 0.76 1.46
PROFIT (After Tax) 1.49 3.22 5.04 7.40 9.66

22
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.16. BREAK EVEN POINT ANALYSIS

BREAK EVEN POINT ANALYSIS

Year I II III IV V

Net Sales & Other Income 73.84 87.13 99.60 113.52 128.31
Less : Op. WIP Goods - 1.45 1.65 1.86 2.09
Add : Cl. WIP Goods 1.45 1.65 1.86 2.09 2.33

Total Sales 75.29 87.33 99.81 113.75 128.55

Variable & Semi Variable Exp.

Raw Material Consumed 42.00 48.84 56.16 63.96 72.24
Electricity Exp/Coal Consumption at 85% 2.45 2.82 3.24 3.72 4.10
Wages & Salary at 60% 9.25 10.46 11.95 12.99 14.22
Selling & adminstrative Expenses 80% 1.18 1.74 1.59 1.85 2.16
Interest on working Capital 0.605 0.605 0.605 0.605 0.605
Repair & maintenance 2.22 2.61 2.99 3.41 3.85
Packaging 1.62 1.74 1.99 2.27 2.57
Total Variable & Semi Variable Exp 59.33 68.82 78.53 88.81 99.73
Contribution 15.96 18.51 21.29 24.94 28.82

Fixed & Semi Fixed Expenses

Electricity Exp/Coal Consumption at 15% 0.43 0.50 0.57 0.66 0.72
Wages & Salary at 40% 6.17 6.97 7.97 8.66 9.48
Interest on Term Loan 1.08 0.95 0.68 0.41 0.15
Depreciation 2.90 2.47 2.11 1.80 1.54
Selling & adminstrative Expenses 20% 0.30 0.44 0.40 0.46 0.54
Rent 3.60 3.96 4.36 4.79 5.27
Total Fixed Expenses 14.47 15.29 16.09 16.79 17.70

Capacity Utilization 50% 55% 60% 65% 70%

OPERATING PROFIT 1.49 3.22 5.20 8.15 11.12
BREAK EVEN POINT 45% 45% 45% 44% 43%
BREAK EVEN SALES 68.25 72.15 75.42 76.57 78.93

23
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.17. PROJECTED BALANCE SHEET

PROJECTED BALANCE SHEET (in Lacs)

PARTICULARS 1st year 2nd year 3rd year 4th year 5th year
Liabilities

Capital
opening balance 9.59 10.81 12.35 14.24
Add:- Own Capital 2.60
Add:- Retained Profit 1.49 3.22 5.04 7.40 9.66
Less:- Drawings 1.50 2.00 3.50 5.50 7.00
Subsidy/grant 7.00
Closing Balance 9.59 10.81 12.35 14.24 16.90
Term Loan 9.78 7.33 4.89 2.44 -
Working Capital Limit 5.50 5.50 5.50 5.50 5.50
Sundry Creditors 0.98 1.14 1.31 1.49 1.69
Provisions & Other Liab 0.40 0.50 0.60 0.72 0.86
TOTAL : 26.25 25.28 24.65 24.40 24.95
Assets
Fixed Assets ( Gross) 20.00 20.00 20.00 20.00 20.00
Gross Dep. 2.90 5.37 7.48 9.28 10.82
Net Fixed Assets 17.11 14.63 12.52 10.72 9.18

Current Assets
Sundry Debtors 4.92 5.81 6.64 7.57 8.55
Stock in Hand 2.43 2.79 3.17 3.58 4.02
Cash and Bank 1.79 2.05 2.31 2.53 3.20
TOTAL : 26.25 25.28 24.65 24.40 24.95

24
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.18. CASH FLOW STATEMENT

PROJECTED CASH FLOW STATEMENT (in Lacs)

PARTICULARS 1st year 2nd year 3rd year 4th year 5th year
SOURCES OF FUND

Own Margin 2.60

Net Profit 1.49 3.22 5.20 8.15 11.12
Depriciation & Exp. W/off 2.90 2.47 2.11 1.80 1.54
Increase in Cash Credit 5.50 - - - -
Increase In Term Loan 11.00 - - - -
Increase in Creditors 0.98 0.16 0.17 0.18 0.19
Increase in Provisions & Oth lib 0.40 0.10 0.10 0.12 0.14
Sunsidy/grant 7.00
TOTAL : 31.87 5.95 7.58 10.26 13.00
APPLICATION OF FUND
Increase in Fixed Assets 20.00
Increase in Stock 2.43 0.36 0.38 0.41 0.43
Increase in Debtors 4.92 0.89 0.83 0.93 0.99
Repayment of Term Loan 1.22 2.44 2.44 2.44 2.44

Drawings 1.50 2.00 3.50 5.50 7.00

Taxation - - 0.17 0.76 1.46
TOTAL : 30.08 5.69 7.32 10.04 12.33

Opening Cash & Bank Balance - 1.79 2.05 2.31 2.53

Add : Surplus 1.79 0.26 0.26 0.22 0.67
Closing Cash & Bank Balance 1.79 2.05 2.31 2.53 3.20

25
 PM FME‐ Detailed Project Report of Soya Milk Unit

4.19. DEBT SERVICE COVERAGE RATIO

CALCULATION OF D.S.C.R

PARTICULARS 1st year 2nd year 3rd year 4th year 5th year

CASH ACCRUALS 4.39 5.69 7.15 9.20 11.20

Interest on Term Loan 1.08 0.95 0.68 0.41 0.15
Total 5.47 6.64 7.83 9.61 11.35

REPAYMENT
Instalment of Term Loan 1.22 2.44 2.44 2.44 2.44
Interest on Term Loan 1.08 0.95 0.68 0.41 0.15

Total 2.30 3.40 3.13 2.86 2.59

DEBT SERVICE COVERAGE RATIO 2.37 1.96 2.50 3.36 4.38

AVERAGE D.S.C.R. 2.92

26