Sagar Manish Patel 10L 5Y TL

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 73

PROJECT REPORT

Under Mudra Yojna

M/s SAGAR MANISHKUMAR PATEL


Prop- Sagar Manishkumar Patel
Project Location -Tulsi Party plot,Borsad, Dist-Anand,(Gujrat)
PROJECT REPORT
RICE MILLING
1 PRODUCT AND ITS USES

India is one of the largest producer of rice in the world next to china.It accounts for about 31% of the
area and 41% of the total production of foodgrains in the country.it is a staple food of the people of
the southern and north eastern states,coastrl areas and hilly areas.

The crop is grown in almost all the states of the country,but it's cultivation is mostly concentrated in in
the states of Andhra Pradesh,West Bangal, Tamil Nadu,uttar Pradesh ,Bihar, Orissa,Madhya
Pradesh,Punjab ,karnataka and Assam which account for more than 86% of the total peddy produced
in the country.

Paddy milling is one of the largest agro based industries in the country.There are reported to be
91,154 rice milling units spread through out the country.These units process 80% of the total peddy
produced in the country.The other 20% is processed by traditional mathod or cunsumed in in various
forms.With the introduction of high yielding varieties that improove agronomic practices ,the
production of peddy is expected to be in creased in the years to come.There are stills a large number
of units in the countryusing the outdated technology like old hullers.The Central food Technological
Research Institute,Mysore has develop a technology for processing of rice to secure an improoved
out turn ratio from paddy to rice, a superior quality of milled products,cleaner by product of greater
value lower cost of processing,reduction of wastage,with better economic returns to producer and
processors.

2 MARKET POTENTIAL

Rice milling is an age old activity,which has gone through many phases of development from hand
pounding ,foodpoundinghulling and dehusking by emery disk sheller etc. to the latest mathod
involving dehusking by rubber roller sheller and polishing by modern mechanical technique.

one of the significant factors of paddy milling industry in India is that it consist of large number of
units having obsolete technology ,which result in low out turn of rice and by products,which have low
economic value.With the adoption of new agriculture strategy ,popularly kown as High Yield Varieties
programme ,introduced in the different parts of the country ,the production of paddy has increased
from 45.66 M.T. IN 1966-67 TO 79.84m.T. IN 1980-81 which envisages a need to modernise not only
the exsisting rice mill units ,but to develop new modern mills based on the technology developed by
CFTRI,Mysore.
3 PRODUCTION DETAILS AND PROCESS OF MANUFACTURE

Rice Milling: The paddy is cleaned in a paddy cleaner to get rid of rid of the foreign matter such as
mud,stones,chaff etc.The cleaned paddy is fed into Dehusker (Modern Mini Mill) where it is dehusked
with the help of rubber roller and its sepreted from the husk.the brown rice with a small quantity of
paddy of paddy is next fed into a huller where polishing of rice is done by mild friction created within
the polishing chamber of the huller.the resulting polished rice and bran are got seprated and are
collected separately.

During paddy milling, rice is generally obtained about 60 to 70 per cent,husk is obtained about 20 to
25 per cent ,beside 5 per cent bran .The bran contain about 14 to 16 per cent oil which can be
obtained through solvent extraction process.

Parboiled rice: Apart from improving milling techniques there is also a need to improve the parboiling
system.It has been obseved that the states which are surplus in rice ,do not at present have enough
parboiling facility , whereas states which are deficit in rice require parboiled rice in larger
quantities.Thus there ia an incresing need to instal parboiling units in the rice surplus states in
particular and in other states in general.To encourage the parboiling, government is giving incentives
to the rice miller who produce parboiled rice.

The mill may also be equipped with modern parboiling units in which paddy is soaked in hot water and
subsequently steammed for a short duration in order to eliminate bad odours,normally associated
with conventionally parboiled rice.this improved process hardens the grain which in turn helps to
reduce breakage in milling.Besides,vitamins,protiens and minerals of nutritional importence are
conserved in parboiled rice.Machanical driers using hot air blown across a coloumn of grains, helps to
bring down the moisture content of paddy to desirable levels.Proper drying and storing are known to
have a salutory effect in grain processing.Losses due to bird picking during sun drying can be
eliminated and also the uniformity of drying achived in a machanical device will result in better milling
out-turn.
The additional equipment requireed for pardoiling unit is a machanical drier, and soaking tanks for
paddy.

4 QUALITY CONTROL & STANDARDS


There is no ISI specification of rice milling as such.
INDEX
S. No. PARTICULARS Para no.

1 Bio data of the proprietor 1

2 Details of the project 2

3 Basis of assumptions 3

4 Cost of the project & means of finance 4

5 Details of finance of the project 5

6 Details of Capacity Installed & Product Mix 6

7 Details of sales & purchases 7

8 Direct labour/Staff Salary expenses 8

9 Other variable expenses 9

10 Fixed expenses 10

11 Projected Profit & loss account 11

12 Projected balance sheet 12

13 Details Of Working Capital Requirement 13

14 Details Of Stock Requirement 14

15 Cash Flow Statement 15

16 Calculation of D.S.C.R. 16

17 Break Even Analysis 17

18 Term loan repayment schedule & Interest charged 18

19 Details of Fixed Assets & Depreciation 19

20 Recommendations 20
BIO - DATA OF THE PROPRIETOR
FIRM NAME : M/s SAGAR MANISHKUMAR PATEL
PROPRIETOR : Sagar Manishkumar Patel
Father Name : Manishkumar Ratilal Patel

QUALIFICATION : Graduate
Age 26 Years

Project Location -Tulsi Party plot,Borsad, Dist-


Project Location : Anand,(Gujrat)
RESIDENCE ADDRESS : Gandhi Gunj Society,Barsod,Dist- Anand,Gujrat
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
DETAILS OF THE PROJECT
S. No. NAME OF THE ITEM PARTICULARS
1 Name of the Firm : M/s SAGAR MANISHKUMAR PATEL
2 Name of the Proprietor : Sagar Manishkumar Patel
2 Project Location : Project Location -Tulsi Party plot,Borsad, Dist-
Anand,(Gujrat)
3 Constitution : Proprietary
4 Location of unit : Project Location -Tulsi Party plot,Borsad, Dist-
Anand,(Gujrat)
5 Number of shifts : Single Shift
6 Estimated working days : 300 days
7 Capacity (At 100%) :
8 Cost of project (Rs. In Lakhs) : 13.52
9 Funds Arrangements (Rs. In Lakhs) Margin
Term Loan 74% 10.00
Promotors Contribution 26% 3.52
Total 13.52
12 D.S.C.R. (average)
For first two years - : 2.57
For seven years - : 2.74
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
COST OF PROJECT & MEANS OF FINANCE
S. No. DESCRIPTION AMOUNT (in Lacs)

A PROJECT COST
1 Investment
Fixture & Furniture 12.00
Stocks 0.00
TOTAL 12.00
B MEANS OF FINANCES Total
TERM LOAN 10.00
Promotors Contribution 3.52
13.52
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
73.96

26.04
DETAILS OF REVENUE at 100% capacity
(Rs. In Lakhs)
DESCRIPTION OF RECEIPTS / SALES Amount
(annually)
Rentel Inocome
Rs 450 Per Ton per Day for 300 Days
Capacity 8 Ton
Total Revenue Per day 8 Ton * 450 Per Day 3600.00
TOTAL Revenue Per Year 365 Working Days 1314000.00 13.14
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
DETAILS OF CAPACITY UTILISATION
(Rs in Lakhs)
YEAR 1 2 3 4 5 6 7
Capacity 70% 75% 80% 85% 90% 95% 100%

Gross Receipets 9.20 9.86 10.51 11.17 11.83 12.48 13.14

Purchase 0.00 0.00 0.00 0.00 0.00 0.00 0.00

ON THE BASIS OF INFORMATION GIVEN COMPILED BY US


Calculation of Working Capital Requirement
For Ist Year
DIRECT LABOUR/STAFF No of Person Cost per month Annual Cost

LABOUR EXPENSES
1.00 Self
Manager
2.00 7,500.00 180,000.00
Skilled
Total 3.00 7500.00 180000.00
OTHER VARIABLES EXPENSES Per Month Annual Cost
1,500.00
REPAIR AND MAINTENANCE 18000.00 REPAIR AND
ELECTRICITY EXP 2,000.00 24000.00 ELECTRICITY
SHOP EXP 1,250.00 15000.00 SHOP EXP
TELEPHONE EXP 250.00 3000.00 TELEPHONE
TOTAL 5000.00 60000.00 240000.00

Total Working Capital Required Yearly 240,000.00


Annual Cost
OTHER FIXED EXPENSES
Accountant Expenses 20000.00
Rent 12000.00
TOTAL 32000.00 272000.00
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
PROJECTED PROFIT & LOSS ACCOUNT FOR THE COMING YEARS
(Figures in lakhs)
PARTICULARS Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year
Receipts
Sales & Service 52.00 54.60 57.33 60.20 63.21 12.48 13.14
Closing Stocks 3.80 4.75 5.70 6.84 8.21
Total A 55.80 59.35 63.03 67.04 71.41 12.48 13.14

Cost of Sales
Opening Stocks 4.60 3.80 4.75 5.70 6.84 8.21 0.00
Cost of Purchase 41.60 45.86 48.16 50.57 53.09 0.00 0.00
Staff Salary expenses 1.80 1.89 1.98 2.08 2.19 2.30 2.41
Fixed Expenses 0.32 0.34 0.35 0.37 0.39 0.41 0.43
Other Variables Expenses 0.60 0.63 0.66 0.69 0.73 0.77 0.80
Total B 48.92 52.52 55.91 59.41 63.24 11.68 3.65

Profit (before dep. & interest) 6.88 6.83 7.12 7.62 8.17 0.80 9.49
Depreciation 1.20 1.08 0.97 0.87 0.79 0.71 0.64
Profit (after dep. but before interest) 5.68 5.75 6.15 6.75 7.39 0.09 8.86
Interest charged on term loan 1.12 0.92 0.70 0.45 0.17 -0.15 -0.51
Interest charged on CC Limit 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net profit (after interest & dep.) 4.56 4.83 5.45 6.30 7.22 0.25 9.37
N.P. (after tax) 4.56 4.83 5.45 6.30 7.22 0.25 8.19
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
PROJECTED BALANCE SHEET FOR THE COMING YEARS (AT THE END OF THE YEAR)
(Figures in lakhs)
PARTICULARS Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year
(A) LIABILITIES:
Capital
Promoter's capital
Promoter's Capital op balance 3.52 5.58 7.71 10.25 13.40 17.22 13.77
Subsidy under PMEGP 0.00
Net profit 4.56 4.83 5.45 6.30 7.22 0.25 8.19
Withdrawls -2.50 -2.70 -2.92 -3.15 -3.40 -3.70 -4.00
Closing Capital 5.58 7.71 10.25 13.40 17.22 13.77 17.96

Loans
Term Loan 8.45 6.70 4.73 2.50 0.00 -2.82 -6.00
C.C.LIMIT 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Current liabilities
Sundry Creditors 1.40 1.71 2.08 2.54 3.10 0.00 0.00
Provisions 0.45 0.00 0.00 0.00 0.00 2.63 0.49
Total liabilities 15.88 16.12 17.06 18.45 20.33 13.58 12.45

(B) ASSETS
Fixed assets
Gross Block 12.00 10.80 9.72 8.75 7.87 7.09 6.38
Less: Depreciation 1.20 1.08 0.97 0.87 0.79 0.71 0.64
Net block 10.80 9.72 8.75 7.87 7.09 6.38 5.74

Deposits & Advances


Investment 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Advance & Other Deposit 0.00 0.00 0.00 0.00 0.00
Current assets
Sundry Debtors 1.20 1.46 1.79 2.18 2.66 2.92 3.22
Closing stock 3.80 4.75 5.70 6.84 8.21 0.00 0.00
Cash & Bank balances 0.08 0.19 0.83 1.56 2.37 4.28 3.49
Total assets 15.88 16.12 17.06 18.45 20.33 13.58 12.45
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
details of working capital requirement

(Rs in Lakhs)
PARTICULARS Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year
(A) LIABILITIES:

Current liabilities
Sundry creditors 1.40 1.71 2.08 2.54 3.10 0.00 0.00
Provisions 0.45 0.00 0.00 0.00 0.00 2.63 0.49
1.85 1.71 2.08 2.54 3.10 2.63 0.49

(B) ASSETS
Current assets
Sundry Debtors 1.20 1.46 1.79 2.18 2.66 2.92 3.22
Closing stock 3.80 4.75 5.70 6.84 8.21 0.00 0.00
Cash & bank balances 0.08 0.19 0.83 1.56 2.37 4.28 3.49
Total assets 5.08 6.40 8.31 10.58 13.24 7.21 6.71
WORKING CAPITAL(B-A) 3.23 4.69 6.23 8.03 10.14 4.57 6.22
details of stock requirement

(Rs in Lakhs)
PARTICULARS Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year

OPENING/Purchased STOCK
IN HAND 0.00 0.00 0.00 0.00 0.00 0.00 0.00
CLOSING STOCK IN HAND 0.00 0.00 0.00 0.00 0.00 0.00 0.00

INCREASE IN STOCK 0.00 0.00 0.00 0.00 0.00 0.00 0.00


ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
Para No. 15
CASH FLOW STATEMENTS FOR COMING YEARS
(Figures in lakhs)
DESCRIPTION Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year

(A) SOURCES OF FUND

Promoters Capital #REF! -- -- -- -- -- --


Term loan from bank 0.00 -- -- -- -- -- --
CC limit from bank #REF! -- -- -- -- -- --
Profit after dep.
(before interest & tax) 5.68 5.75 6.15 6.75 7.39 0.09 8.86
Depreciation 1.20 1.08 0.97 0.87 0.79 0.71 0.64
Total #REF! 6.83 7.12 7.62 8.17 0.80 9.49

(B) APPLICATION OF FUNDS

Purchase of fixed assets #REF! -- -- -- -- -- --


Increase in Working Capital 3.23 1.46 1.54 1.80 2.10 -5.57 1.65
Decrease in term loan 1.55 1.75 1.97 2.22 2.50 2.82 3.18
Interest to bank 1.12 0.92 0.70 0.45 0.17 -0.15 -0.51
Income tax 0.26 0.28 0.39 0.56 0.74 0.00 1.17
Withdrawals #REF! #REF! #REF! #REF! #REF! #REF! #REF!
Total #REF! #REF! #REF! #REF! #REF! #REF! #REF!
CALCULATION OF D.S.C.R.
(Figures in lakhs)

Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year
PARTICULARS

Net profit 4.56 4.83 5.45 6.30 7.22 0.25 8.19


Interest on Term loan 1.12 0.92 0.70 0.45 0.17 -0.15 -0.51
Depreciation 1.20 1.08 0.97 0.87 0.79 0.71 0.64
Total 6.88 6.83 7.12 7.62 8.17 0.80 8.32

Repayment to Term loan 1.55 1.75 1.97 2.22 2.50 2.82 3.18
Interest on Term loan 1.12 0.92 0.70 0.45 0.17 -0.15 -0.51
2.67 2.67 2.67 2.67 2.67 2.67 2.67

D.S.C.R. 2.58 2.56 2.67 2.86 3.06 0.30 3.12

Total D.S.C.R. for seven


years 13.72
Average D.S.C.R. for seven
years 2.74
ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
BREAK EVEN ANALYSIS
(Rs. In lacs)
Year
S.No. Description 1 2 3 4 5 6 7
Capacity ( %) 50% 55% 60% 65% 70% 75% 80%

1 Sales 52.00 54.60 57.33 60.20 63.21 12.48 13.14

2 Variable Cost 7.00 6.32 7.40 8.48 9.76 11.27 3.22

3 Contribution (1-2) 45.00 48.28 49.93 51.72 53.45 1.21 9.92


4 Fixed Cost

Interest on T.L. 1.12 0.92 0.70 0.45 0.17 -0.15 -0.51

Depreciation 1.20 1.08 0.97 0.87 0.79 0.71 0.64

Other Fixed Cost 0.32 0.34 0.35 0.37 0.39 0.41 0.43
2.64 2.34 2.02 1.69 1.34 0.97 0.56

5 PBT (3-4) 42.36 45.94 47.91 50.03 52.11 0.25 9.37

6 P/V Ratio (3/1)( % ) 86.54% 88.42% 87.10% 85.92% 84.56% 9.71% 75.52%

7 B.E.P. ( % ) 5.86% 4.84% 4.05% 3.27% 2.51% 79.64% 5.61%

8 Margin of Safety 94.14% 95.16% 95.95% 96.73% 97.49% 20.36% 94.39%


M/s SAGAR MANISHKUMAR PATEL
Prop- Sagar Manishkumar Patel

Project Location -Tulsi Party plot,Borsad, Dist-Anand,(Gujrat)

TERM LOAN INSTALLMENT REPORT


E.M.I. QUERY
Bank Finaance
Rate of Interest 12.00%
Term loan 1000000.00 1000000.00
Repayment period (Years) 5
Installment 22,244.00

Year Ist Amount


Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding
total intt.

1 1000000.00 12244.00 10000.00 22244.00 987756.00

2 987756.00 12366.44 9877.56 22244.00 975389.56

3 975389.56 12490.10 9753.90 22244.00 962899.46

4 962899.46 12615.01 9628.99 22244.00 950284.45

5 950284.45 12741.16 9502.84 22244.00 937543.29

6 937543.29 12868.57 9375.43 22244.00 924674.73

7 924674.73 12997.25 9246.75 22244.00 911677.47

8 911677.47 13127.23 9116.77 22244.00 898550.25

9 898550.25 13258.50 8985.50 22244.00 885291.75

10 885291.75 13391.08 8852.92 22244.00 871900.67

11 871900.67 13524.99 8719.01 22244.00 858375.68

12 858375.68 13660.24 8583.76 22244.00 844715.43

Total 155284.57 111643.43 266928.00


Year IInd
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 844715.43 13796.85 8447.15 22244.00 830918.59

2 830918.59 13934.81 8309.19 22244.00 816983.77

3 816983.77 14074.16 8169.84 22244.00 802909.61

4 802909.61 14214.90 8029.10 22244.00 788694.71

5 788694.71 14357.05 7886.95 22244.00 774337.65

6 774337.65 14500.62 7743.38 22244.00 759837.03


7 759837.03 14645.63 7598.37 22244.00 745191.40
8 745191.40 14792.09 7451.91 22244.00 730399.32

9 730399.32 14940.01 7303.99 22244.00 715459.31

10 715459.31 15089.41 7154.59 22244.00 700369.90

11 700369.90 15240.30 7003.70 22244.00 685129.60

12 685129.60 15392.70 6851.30 22244.00 669736.90

Total 174978.54 91949.46 266928.00

Year IIIrd
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 669736.90 15546.63 6697.37 22244.00 654190.27

2 654190.27 15702.10 6541.90 22244.00 638488.17

3 638488.17 15859.12 6384.88 22244.00 622629.05

4 622629.05 16017.71 6226.29 22244.00 606611.34

5 606611.34 16177.89 6066.11 22244.00 590433.45

6 590433.45 16339.67 5904.33 22244.00 574093.79


7 574093.79 16503.06 5740.94 22244.00 557590.73 173134.22
8 557590.73 16668.09 5575.91 22244.00 540922.63 360721.78
9 540922.63 16834.77 5409.23 22244.00 524087.86

10 524087.86 17003.12 5240.88 22244.00 507084.74

11 507084.74 17173.15 5070.85 22244.00 489911.59

12 489911.59 17344.88 4899.12 22244.00 472566.70

Total 197170.19 69757.81 266928.00


Year Ivth
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 472566.70 17518.33 4725.67 22244.00 455048.37

2 455048.37 17693.52 4550.48 22244.00 437354.85

3 437354.85 17870.45 4373.55 22244.00 419484.40

4 419484.40 18049.16 4194.84 22244.00 401435.24

5 401435.24 18229.65 4014.35 22244.00 383205.60

6 383205.60 18411.94 3832.06 22244.00 364793.65


7 364793.65 18596.06 3647.94 22244.00 346197.59 127385.67
8 346197.59 18782.02 3461.98 22244.00 327415.57 406470.33
9 327415.57 18969.84 3274.16 22244.00 308445.72

10 308445.72 19159.54 3084.46 22244.00 289286.18

11 289286.18 19351.14 2892.86 22244.00 269935.04

12 269935.04 19544.65 2699.35 22244.00 250390.39

Total 222176.31 44751.69 266928.00

Year Vth
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 250390.39 19740.10 2503.90 22244.00 230650.29

2 230650.29 19937.50 2306.50 22244.00 210712.80

3 210712.80 20136.87 2107.13 22244.00 190575.93

4 190575.93 20338.24 1905.76 22244.00 170237.68

5 170237.68 20541.62 1702.38 22244.00 149696.06

6 149696.06 20747.04 1496.96 22244.00 128949.02


7 128949.02 20954.51 1289.49 22244.00 107994.51 75835.06
8 107994.51 21164.05 1079.95 22244.00 86830.46 458020.94

9 86830.46 21375.70 868.30 22244.00 65454.76

10 65454.76 21589.45 654.55 22244.00 43865.31

11 43865.31 21805.35 438.65 22244.00 22059.96

12 22059.96 22023.40 220.60 22244.00 36.56

Total 250353.83 16574.17 266928.00


Year VIth
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 36.56 22243.63 0.37 22244.00 -22207.07

2 -22207.07 22466.07 -222.07 22244.00 -44673.14

3 -44673.14 22690.73 -446.73 22244.00 -67363.87

4 -67363.87 22917.64 -673.64 22244.00 -90281.51

5 -90281.51 23146.82 -902.82 22244.00 -113428.33

6 -113428.33 23378.28 -1134.28 22244.00 -136806.61


7 -136806.61 23612.07 -1368.07 22244.00 -160418.68 17746.54
8 -160418.68 23848.19 -1604.19 22244.00 -184266.86 516109.46
9 -184266.86 24086.67 -1842.67 22244.00 -208353.53

10 -208353.53 24327.54 -2083.54 22244.00 -232681.07

11 -232681.07 24570.81 -2326.81 22244.00 -257251.88

12 -257251.88 24816.52 -2572.52 22244.00 -282068.40

Total 282104.96 -15176.96 266928.00

Year VIIth
Ins. No. Loan Amount Principal Amt. Intt.Charged Repayment Bal.Outstanding

1 -282068.40 25064.68 -2820.68 22244.00 -307133.08

2 -307133.08 25315.33 -3071.33 22244.00 -332448.41

3 -332448.41 25568.48 -3324.48 22244.00 -358016.90

4 -358016.90 25824.17 -3580.17 22244.00 -383841.07

5 -383841.07 26082.41 -3838.41 22244.00 -409923.48

6 -409923.48 26343.23 -4099.23 22244.00 -436266.71


7 -436266.71 26606.67 -4362.67 22244.00 -462873.38 -47709.06
8 -462873.38 26872.73 -4628.73 22244.00 -489746.11 581565.06

9 -489746.11 27141.46 -4897.46 22244.00 -516887.57

10 -516887.57 27412.88 -5168.88 22244.00 -544300.45

11 -544300.45 27687.00 -5443.00 22244.00 -571987.45

12 -571987.45 27963.87 -5719.87 22244.00 -599951.33

Total 317882.93 -50954.93 266928.00


ON THE BASIS OF INFORMATION GIVEN COMPILED BY US
1599951.33 268544.67 481567.55
#REF!

#REF! #REF! #REF! 885.48


DETAILS OF FIXED ASSETS & DEPRECIATION CHARGED
user:
S No. Particulars Opening Add - Less - Sold change in leap year
Net balance Rate of Depreciatio Closing
Balance Addition during the depreciation n charged balance
during the year
year

TANGIBLE ASSETS
A Block 15% 0.00 0.00 0.00 0.00 15.00% 0.00 0.00
B Block 60% 0.00 0.00 0.00 0.00 60.00% 0.00 0.00
1 YEAR C Block 10% 0.00 12.00 0.00 12.00 10.00% 1.20 10.80
D Block 0% 0.00 0.00 0.00 0.00 0.00% 0.00 0.00
Subtotal 0.00 12.00 0.00 12.00 1.20 10.80

A Block 15% 0.00 0.00 0.00 0.00 15.00% 0.00 0.00


B Block 60% 0.00 0.00 0.00 0.00 60.00% 0.00 0.00
2 YEAR
C Block 10% 10.80 0.00 0.00 10.80 10.00% 1.08 9.72
D Block 0% 0.00 0.00 0.00 0.00 0.00% 0.00 0.00
Subtotal 10.80 0.00 0.00 10.80 1.08 9.72

A Block 15% 0.00 0.00 0.00 0.00 15.00% 0.00 0.00


B Block 60% 0.00 0.00 0.00 0.00 60.00% 0.00 0.00
3 YEAR
C Block 10% 9.72 0.00 0.00 9.72 10.00% 0.97 8.75
D Block 0% 0.00 0.00 0.00 0.00 0.00% 0.00 0.00
Subtotal 9.72 0.00 0.00 9.72 0.97 8.75

A Block 15% 0.00 0.00 0.00 0.00 15.00% 0.00 0.00


B Block 60% 0.00 0.00 0.00 0.00 60.00% 0.00 0.00
4 YEAR
C Block 10% 8.75 0.00 0.00 8.75 10.00% 0.87 7.87
D Block 0% 0.00 0.00 0.00 0.00 0.00% 0.00 0.00
Subtotal 8.75 0.00 0.00 8.75 0.87 7.87

A Block 15% 0.00 0.00 0.00 0.00 15.00% 0.00 0.00


B Block 60% 0.00 0.00 0.00 0.00 60.00% 0.00 0.00
5 YEAR
C Block 10% 7.87 0.00 0.00 7.87 10.00% 0.79 7.09
D Block 0% 0.00 0.00 0.00 0.00 0.00% 0.00 0.00
Subtotal 7.87 0.00 0.00 7.87 0.79 7.09
M/s SAGAR MANISHKUMAR PATEL

RATIO ANYLISIS
Ist Year IInd Year IIIrd Year IVth Year Vth Year VIth Year VIIth Year Average
CURRENT ASSETS
Sundry Debtors 1.20 1.46 1.79 2.18 2.66 2.92 3.22 -
Closing Stock 3.80 4.75 5.70 6.84 8.21 - - -
Cash & Bank Balances 0.08 0.19 0.83 1.56 2.37 4.28 3.49
Total 5.08 6.40 8.31 10.58 13.24 7.21 6.71
CURRENT LIABILTIES
Sundry Creditors 1.40 1.71 2.08 2.54 3.10 - -
Provisions 0.45 - - - - 2.63 0.49
Other Loan - - - - - - -
Applicant Bank -Cash Credit - - - - - - -

SUBTOTAL 1.85 1.71 2.08 2.54 3.10 2.63 0.49

CURRENT RATIO 2.75 3.75 3.99 4.16 4.27 2.73 13.79 5.06

Gross Working Capital 3.23 4.69 6.23 8.03 10.14 4.57 6.22

Net Working Capital 3.23 4.69 6.23 8.03 10.14 4.57 6.22

Gross Turnover 52.00 54.60 57.33 60.20 63.21 12.48 13.14

Term Loan 8.45 6.70 4.73 2.50 0.00 (2.82) (6.00)


CC Limit - - - - - - -
Total Debt 8.45 6.70 4.73 2.50 0.00 (2.82) (6.00)

Total Outside Liabilities 10.30 8.41 6.81 5.05 3.10 (0.19) (5.51)

Total net-worht 5.58 7.71 10.25 13.40 17.22 13.77 17.96

TOL/TNW Ratio 1.84 1.09 0.66 0.38 0.18 (0.01) (0.31) 0.55

Debt /Equity ratio 1.51 0.87 0.46 0.19 0.00 (0.20) (0.33) 0.36

Note:- AS PER INFORMATION GIVEN COMPILED BY US


Sundry Debtors

You might also like