Ots 24 > 24029 > Cashflow
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Ots 24 > 24029 > Cashflow as PDF for free.
More details
- Words: 2,681
- Pages: 10
Annexure 1: Particulars Initial Investment
Yr 1
Yr 2
Yr 3
Yr 4
Yr 5
3,217,140.00
3,217,140.00
3,464,021.38
4,457,880.00
4,262,042.28
15,600.00
12,480.00
9,360.00
6,240.00
3,120.00
451,440.00
451,440.00
451,440.00
451,440.00
451,440.00
2,054,808.00 64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
2,054,808.00 64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
2,525,848.92 64,800.00 36,000.00 3,000.00 3,600.00 86,600.53 12,000.00
3,250,588.32 64,800.00 36,000.00 3,000.00 3,600.00 111,448.74 12,000.00
3,107,760.68 64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
40,214.88
40,214.88
43,300.27
55,724.37
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
68,171.40 1,200.00 600.00 7,200.00
68,171.40 1,200.00 600.00 7,200.00
70,640.21 1,200.00 600.00 7,200.00
80,578.80 1,200.00 600.00 7,200.00
78,620.42 1,200.00 600.00 7,200.00
482,571.00 64,342.80
482,571.00 64,342.80
519,603.21 69,280.43
668,682.00 89,157.60
639,306.34 85,240.85
3,375,998.64 -158,858.64 32,500.00 -191,358.64 26,000.00 -217,358.64
3,372,878.64 -155,738.64 24,375.00 -180,113.64 26,000.00 -206,113.64
3,904,473.57 -440,452.19 18,281.25 -458,733.44 26,000.00 -484,733.44
4,842,259.83 -384,379.83 13,710.94 -398,090.77 26,000.00 -424,090.77
4,653,715.98 -391,673.71 10,283.20 -401,956.91 26,000.00 -427,956.91
Revenue Interest @ 12% Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
Total Cost Profit/loss Less: Depreciation @ 25% wdv Profit after depreciation Loan Repayment Cash Inflow
Yr 0 130,000.00
Annexure 2(a) Year 1
Apr
May
Jun
Jul
Aug
Sep
Oct
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 3,217,140.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 2,054,808.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 1,762.56 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 70,450.56 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
881.28
881.28
881.28
881.28
881.28
881.28
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
40,214.88
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
68,171.40 1,200.00 600.00 7,200.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
482,571.00 64,342.80
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
50,160.00
2,520 1,386.00 194.04 15,523.00
TOTAL
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Mar
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Feb
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Jan
1,440 244.80 29.38 2,350.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
2,520 1,386.00 194.04 15,523.00
Dec
1,440 244.80 29.38 2,350.00
Cost of Production Raw Material(price given to the producer Rs 7/ ltr) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,440 244.80 29.38 2,350.00
Nov
No of milking goats per day Litre of Milk per day Paneer Yield per day @12% Expected Income per day @ Rs 80
50,160.00
2,520 1,386.00 194.04 15,523.00
50,160.00
451,440.00
105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 3,360,398.64 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 -143,258.64
Annexure 2 (b) Year 2
Apr
May
Jun
Jul
Aug
Sep
Oct
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 3,217,140.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 2,054,808.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 1,762.56 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 70,450.56 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
881.28
881.28
881.28
881.28
881.28
881.28
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
40,214.88
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
68,171.40 1,200.00 600.00 7,200.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
482,571.00 64,342.80
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
50,160.00
2,520 1,386.00 194.04 15,523.00
TOTAL
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Mar
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Feb
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Jan
1,440 244.80 29.38 2,350.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
2,520 1,386.00 194.04 15,523.00
Dec
1,440 244.80 29.38 2,350.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,440 244.80 29.38 2,350.00
Nov
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
2,520 1,386.00 194.04 15,523.00
50,160.00
451,440.00
105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 3,360,398.64 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 -143,258.64
Annexure 2 (.c) Year 3
Apr
May
Jun
Jul
Aug
Sep 1,642 279.07 33.49 2,679.09
Oct
Nov
3,137 1,725.57 207.07 16,565.47
Dec
1,642 279.07 33.49 2,679.09
1,642 279.07 33.49 2,679.09
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
80,372.74
80,372.74
80,372.74
80,372.74
80,372.74
80,372.74 496,964.16 496,964.16 496,964.16 496,964.16 496,964.16 496,964.16 3,464,021.38
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
Cost of Production Raw Material(includes price given to the producer) 58,605.12 Labour(for 3 persons) @ Rs 60/day 5,400.00 Factory rent 3,000.00 Water 250.00 Electricity 300.00 Fuel @ Rs 360 per 1500 ltr 2,009.32 Ice 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 362,369.70 362,369.70 362,369.70 362,369.70 362,369.70 362,369.70 2,525,848.92 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 2,009.32 12,424.10 12,424.10 12,424.10 12,424.10 12,424.10 12,424.10 86,600.53 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
50,160.00
3,137 1,725.57 207.07 16,565.47
TOTAL
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Mar
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Feb
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Jan
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
3,137 1,725.57 207.07 16,565.47
50,160.00
451,440.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
6,212.05
6,212.05
6,212.05
6,212.05
6,212.05
6,212.05
43,300.27
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
70,640.21 1,200.00 600.00 7,200.00
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
519,603.21 69,280.43
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
114,866.19 114,866.19 114,866.19 114,866.19 114,866.19 114,866.19 534,319.40 534,319.40 534,319.40 534,319.40 534,319.40 534,319.40 3,895,113.57 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -431,092.19
Annexure 2 (d) Year 4
Apr
May
Jun
Jul
Aug
Sep
Nov
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
80,370.00
80,370.00
80,370.00
80,370.00
80,370.00
80,370.00 662,610.00 662,610.00 662,610.00 662,610.00 662,610.00 662,610.00 4,457,880.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 483,159.60 483,159.60 483,159.60 483,159.60 483,159.60 483,159.60 3,250,588.32 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 2,009.32 16,565.47 16,565.47 16,565.47 16,565.47 16,565.47 16,565.47 111,448.74 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
8,282.74
8,282.74
8,282.74
8,282.74
8,282.74
8,282.74
55,724.37
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
80,578.80 1,200.00 600.00 7,200.00
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
668,682.00 89,157.60
Total Cost Profit/loss
50,160.00
4,183 2,300.76 276.09 22,087.00
TOTAL
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Mar
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Feb
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Jan
1,642 279.07 33.49 2,679.00
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
4,183 2,300.76 276.09 22,087.00
Dec
1,642 279.07 33.49 2,679.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,642 279.07 33.49 2,679.00
Oct
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
4,183 2,300.76 276.09 22,087.00
50,160.00
451,440.00
114,865.70 114,865.70 114,865.70 114,865.70 114,865.70 114,865.70 691,137.61 691,137.61 691,137.61 691,137.61 691,137.61 691,137.61 4,836,019.83 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -378,139.83
Annexure 2 (e) Year 5
Apr
May
Jun
Jul
Aug
Sep
Nov
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
91,620.00
91,620.00
91,620.00
91,620.00
91,620.00
91,620.00 618,720.38 618,720.38 618,720.38 618,720.38 618,720.38 618,720.38
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
50,160.00
451,440.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 451,150.28 451,150.28 451,150.28 451,150.28 451,150.28 451,150.28 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 2,290.62 15,468.01 15,468.01 15,468.01 15,468.01 15,468.01 15,468.01 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
3,107,760.68 64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,145.31
1,145.31
1,145.31
1,145.31
1,145.31
1,145.31
7,734.00
7,734.00
7,734.00
7,734.00
7,734.00
7,734.00
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
78,620.42 1,200.00 600.00 7,200.00
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
639,306.34 85,240.85
125,517.37 125,517.37 125,517.37 125,517.37 125,517.37 125,517.37 649,581.96 649,581.96 649,581.96 649,581.96 649,581.96 649,581.96 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -30,861.58 -30,861.58 -30,861.58 -30,861.58 -30,861.58 -30,861.58
4,650,595.98 -388,553.71
Total Cost Profit/loss
50,160.00
3,906 2,148.33 257.80 20,624.01
TOTAL
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Mar
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Feb
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Jan
1,871 318.14 38.18 3,054.00
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
3,906 2,148.33 257.80 20,624.01
Dec
1,871 318.14 38.18 3,054.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,871 318.14 38.18 3,054.00
Oct
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
3,906 2,148.33 257.80 20,624.01 4,262,042.28
Particulars Utensils Cans(5 cans @ 1700) Furniture Packing Machine Refrigerator Construction works Fat Testing Machine(3 unit @Rs 3500) Total
Rs 6000 8500 1000 91000 11000 2000 10500 130000
Annexure : March-Aug
Sept-Feb
Total no. of Does No. of milking goats per day Litre of milk produced per day Paneer yield per day (in Kg) Expected revenue per day(@ Rs 80 per Kg)
1 0.4 0.07 0.01 0.65
1 0.7 0.39 0.05 3.7
Expected Revenue for 6 months(180 days)
117.5
665.28
782.78
150480
300960
451440
85.68 32400 18000 1500 1800 2.94 6000
485.1 32400 18000 1500 1800 16.63 6000
570.78 64800 36000 3000 3600 19.57 12000
1.47
8.32
9.78
Administrative Exps Salary Exps(Fixed Part) Salary Exps(Variable part-1 % of sales) Office Exps(Repairs etc) Stationery Misc Exps
18000 1.18 600 300 3600
18000 6.65 600 300 3600
36000 7.83 1200 600 7200
Sales Exps Commission @ 15 % For Market Development( 2% of Sales Value)
17.63 2.35
99.79 13.31
117.42 15.66
232791.24 383789.8 -232673.73 -383124.52
616581.04 -615798.25
Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
Packing Exps Cost of Packing @ Rs 0.25 per pack
Total Cost Profit/loss
Annexure 4: Value to Producer Particulars Initial Investment Revenue
Yr 0 130,000.00
Yr 1
Yr 2
Yr 3
3,217,140.00 3,217,140.00 3,464,021.38
Yr 4
Yr 5
4,457,880.00 4,262,042.28
Interest @ 12% Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
15,600.00
12,480.00
9,360.00
6,240.00
3,120.00
451,440.00
451,440.00
451,440.00
451,440.00
451,440.00
Cost of Production Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 86,600.53 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 111,448.74 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
40,214.88
40,214.88
43,300.27
55,724.37
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
68,171.40 1,200.00 600.00 7,200.00
68,171.40 1,200.00 600.00 7,200.00
70,640.21 1,200.00 600.00 7,200.00
80,578.80 1,200.00 600.00 7,200.00
78,620.42 1,200.00 600.00 7,200.00
482,571.00 64,342.80
482,571.00 64,342.80
519,603.21 69,280.43
668,682.00 89,157.60
639,306.34 85,240.85
1,321,190.64 1,895,949.36 32,500.00 1,863,449.36 26,000.00 1,837,449.36 6.26
1,318,070.64 1,899,069.36 24,375.00 1,874,694.36 26,000.00 1,848,694.36 6.30
1,378,624.65 2,085,396.73 18,281.25 2,067,115.48 26,000.00 2,041,115.48 5.66
1,591,671.51 2,866,208.49 13,710.94 2,852,497.55 26,000.00 2,826,497.55 6.09
1,545,955.30 2,716,086.97 10,283.20 2,705,803.77 26,000.00 2,679,803.77 6.04
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss Less: Depreciation @ 25% wdv Profit after depreciation Loan Repayment Value given to producer Value given to producer per litre of milk
6.07
Yr 1
Yr 2
Yr 3
Yr 4
Yr 5
3,217,140.00
3,217,140.00
3,464,021.38
4,457,880.00
4,262,042.28
15,600.00
12,480.00
9,360.00
6,240.00
3,120.00
451,440.00
451,440.00
451,440.00
451,440.00
451,440.00
2,054,808.00 64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
2,054,808.00 64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
2,525,848.92 64,800.00 36,000.00 3,000.00 3,600.00 86,600.53 12,000.00
3,250,588.32 64,800.00 36,000.00 3,000.00 3,600.00 111,448.74 12,000.00
3,107,760.68 64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
40,214.88
40,214.88
43,300.27
55,724.37
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
68,171.40 1,200.00 600.00 7,200.00
68,171.40 1,200.00 600.00 7,200.00
70,640.21 1,200.00 600.00 7,200.00
80,578.80 1,200.00 600.00 7,200.00
78,620.42 1,200.00 600.00 7,200.00
482,571.00 64,342.80
482,571.00 64,342.80
519,603.21 69,280.43
668,682.00 89,157.60
639,306.34 85,240.85
3,375,998.64 -158,858.64 32,500.00 -191,358.64 26,000.00 -217,358.64
3,372,878.64 -155,738.64 24,375.00 -180,113.64 26,000.00 -206,113.64
3,904,473.57 -440,452.19 18,281.25 -458,733.44 26,000.00 -484,733.44
4,842,259.83 -384,379.83 13,710.94 -398,090.77 26,000.00 -424,090.77
4,653,715.98 -391,673.71 10,283.20 -401,956.91 26,000.00 -427,956.91
Revenue Interest @ 12% Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
Total Cost Profit/loss Less: Depreciation @ 25% wdv Profit after depreciation Loan Repayment Cash Inflow
Yr 0 130,000.00
Annexure 2(a) Year 1
Apr
May
Jun
Jul
Aug
Sep
Oct
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 3,217,140.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 2,054,808.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 1,762.56 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 70,450.56 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
881.28
881.28
881.28
881.28
881.28
881.28
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
40,214.88
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
68,171.40 1,200.00 600.00 7,200.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
482,571.00 64,342.80
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
50,160.00
2,520 1,386.00 194.04 15,523.00
TOTAL
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Mar
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Feb
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Jan
1,440 244.80 29.38 2,350.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
2,520 1,386.00 194.04 15,523.00
Dec
1,440 244.80 29.38 2,350.00
Cost of Production Raw Material(price given to the producer Rs 7/ ltr) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,440 244.80 29.38 2,350.00
Nov
No of milking goats per day Litre of Milk per day Paneer Yield per day @12% Expected Income per day @ Rs 80
50,160.00
2,520 1,386.00 194.04 15,523.00
50,160.00
451,440.00
105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 3,360,398.64 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 -143,258.64
Annexure 2 (b) Year 2
Apr
May
Jun
Jul
Aug
Sep
Oct
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00
70,500.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 465,690.00 3,217,140.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 5,400.00 3,000.00 250.00 300.00 1,762.56 1,000.00
51,408.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 291,060.00 2,054,808.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 1,762.56 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 9,979.20 70,450.56 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
881.28
881.28
881.28
881.28
881.28
881.28
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
5,821.20
40,214.88
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
3,705.00 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
7,656.90 100.00 50.00 600.00
68,171.40 1,200.00 600.00 7,200.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
10,575.00 1,410.00
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
69,853.50 9,313.80
482,571.00 64,342.80
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
50,160.00
2,520 1,386.00 194.04 15,523.00
TOTAL
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Mar
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Feb
1,440 244.80 29.38 2,350.00
50,160.00
2,520 1,386.00 194.04 15,523.00
Jan
1,440 244.80 29.38 2,350.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
2,520 1,386.00 194.04 15,523.00
Dec
1,440 244.80 29.38 2,350.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,440 244.80 29.38 2,350.00
Nov
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
2,520 1,386.00 194.04 15,523.00
50,160.00
451,440.00
105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 105,521.84 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 454,544.60 3,360,398.64 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 -35,021.84 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 11,145.40 -143,258.64
Annexure 2 (.c) Year 3
Apr
May
Jun
Jul
Aug
Sep 1,642 279.07 33.49 2,679.09
Oct
Nov
3,137 1,725.57 207.07 16,565.47
Dec
1,642 279.07 33.49 2,679.09
1,642 279.07 33.49 2,679.09
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
80,372.74
80,372.74
80,372.74
80,372.74
80,372.74
80,372.74 496,964.16 496,964.16 496,964.16 496,964.16 496,964.16 496,964.16 3,464,021.38
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
Cost of Production Raw Material(includes price given to the producer) 58,605.12 Labour(for 3 persons) @ Rs 60/day 5,400.00 Factory rent 3,000.00 Water 250.00 Electricity 300.00 Fuel @ Rs 360 per 1500 ltr 2,009.32 Ice 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 362,369.70 362,369.70 362,369.70 362,369.70 362,369.70 362,369.70 2,525,848.92 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 2,009.32 12,424.10 12,424.10 12,424.10 12,424.10 12,424.10 12,424.10 86,600.53 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
50,160.00
3,137 1,725.57 207.07 16,565.47
TOTAL
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Mar
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Feb
1,642 279.07 33.49 2,679.09
50,160.00
3,137 1,725.57 207.07 16,565.47
Jan
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
3,137 1,725.57 207.07 16,565.47
50,160.00
451,440.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
6,212.05
6,212.05
6,212.05
6,212.05
6,212.05
6,212.05
43,300.27
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
3,803.73 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
7,969.64 100.00 50.00 600.00
70,640.21 1,200.00 600.00 7,200.00
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
12,055.91 1,607.45
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
74,544.62 9,939.28
519,603.21 69,280.43
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss
114,866.19 114,866.19 114,866.19 114,866.19 114,866.19 114,866.19 534,319.40 534,319.40 534,319.40 534,319.40 534,319.40 534,319.40 3,895,113.57 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -34,493.45 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -37,355.24 -431,092.19
Annexure 2 (d) Year 4
Apr
May
Jun
Jul
Aug
Sep
Nov
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
80,370.00
80,370.00
80,370.00
80,370.00
80,370.00
80,370.00 662,610.00 662,610.00 662,610.00 662,610.00 662,610.00 662,610.00 4,457,880.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 5,400.00 3,000.00 250.00 300.00 2,009.32 1,000.00
58,605.12 483,159.60 483,159.60 483,159.60 483,159.60 483,159.60 483,159.60 3,250,588.32 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 64,800.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 36,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 3,600.00 2,009.32 16,565.47 16,565.47 16,565.47 16,565.47 16,565.47 16,565.47 111,448.74 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
1,004.66
8,282.74
8,282.74
8,282.74
8,282.74
8,282.74
8,282.74
55,724.37
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
3,803.70 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
9,626.10 100.00 50.00 600.00
80,578.80 1,200.00 600.00 7,200.00
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
12,055.50 1,607.40
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
99,391.50 13,252.20
668,682.00 89,157.60
Total Cost Profit/loss
50,160.00
4,183 2,300.76 276.09 22,087.00
TOTAL
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Mar
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Feb
1,642 279.07 33.49 2,679.00
50,160.00
4,183 2,300.76 276.09 22,087.00
Jan
1,642 279.07 33.49 2,679.00
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
4,183 2,300.76 276.09 22,087.00
Dec
1,642 279.07 33.49 2,679.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,642 279.07 33.49 2,679.00
Oct
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
4,183 2,300.76 276.09 22,087.00
50,160.00
451,440.00
114,865.70 114,865.70 114,865.70 114,865.70 114,865.70 114,865.70 691,137.61 691,137.61 691,137.61 691,137.61 691,137.61 691,137.61 4,836,019.83 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -34,495.70 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -28,527.61 -378,139.83
Annexure 2 (e) Year 5
Apr
May
Jun
Jul
Aug
Sep
Nov
Revenue per month Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
91,620.00
91,620.00
91,620.00
91,620.00
91,620.00
91,620.00 618,720.38 618,720.38 618,720.38 618,720.38 618,720.38 618,720.38
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
25,080.00
50,160.00
451,440.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 5,400.00 3,000.00 250.00 300.00 2,290.62 1,000.00
66,809.84 451,150.28 451,150.28 451,150.28 451,150.28 451,150.28 451,150.28 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 5,400.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 3,000.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 300.00 300.00 300.00 300.00 300.00 300.00 300.00 2,290.62 15,468.01 15,468.01 15,468.01 15,468.01 15,468.01 15,468.01 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
3,107,760.68 64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
1,145.31
1,145.31
1,145.31
1,145.31
1,145.31
1,145.31
7,734.00
7,734.00
7,734.00
7,734.00
7,734.00
7,734.00
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
3,916.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
9,187.20 100.00 50.00 600.00
78,620.42 1,200.00 600.00 7,200.00
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
13,743.00 1,832.40
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
92,808.06 12,374.41
639,306.34 85,240.85
125,517.37 125,517.37 125,517.37 125,517.37 125,517.37 125,517.37 649,581.96 649,581.96 649,581.96 649,581.96 649,581.96 649,581.96 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -33,897.37 -30,861.58 -30,861.58 -30,861.58 -30,861.58 -30,861.58 -30,861.58
4,650,595.98 -388,553.71
Total Cost Profit/loss
50,160.00
3,906 2,148.33 257.80 20,624.01
TOTAL
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Mar
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Feb
1,871 318.14 38.18 3,054.00
50,160.00
3,906 2,148.33 257.80 20,624.01
Jan
1,871 318.14 38.18 3,054.00
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales)
3,906 2,148.33 257.80 20,624.01
Dec
1,871 318.14 38.18 3,054.00
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
1,871 318.14 38.18 3,054.00
Oct
No of milking goats per day Litre of Milk per day Paneer Yield per day Expected Income per day @ Rs 80
50,160.00
3,906 2,148.33 257.80 20,624.01 4,262,042.28
Particulars Utensils Cans(5 cans @ 1700) Furniture Packing Machine Refrigerator Construction works Fat Testing Machine(3 unit @Rs 3500) Total
Rs 6000 8500 1000 91000 11000 2000 10500 130000
Annexure : March-Aug
Sept-Feb
Total no. of Does No. of milking goats per day Litre of milk produced per day Paneer yield per day (in Kg) Expected revenue per day(@ Rs 80 per Kg)
1 0.4 0.07 0.01 0.65
1 0.7 0.39 0.05 3.7
Expected Revenue for 6 months(180 days)
117.5
665.28
782.78
150480
300960
451440
85.68 32400 18000 1500 1800 2.94 6000
485.1 32400 18000 1500 1800 16.63 6000
570.78 64800 36000 3000 3600 19.57 12000
1.47
8.32
9.78
Administrative Exps Salary Exps(Fixed Part) Salary Exps(Variable part-1 % of sales) Office Exps(Repairs etc) Stationery Misc Exps
18000 1.18 600 300 3600
18000 6.65 600 300 3600
36000 7.83 1200 600 7200
Sales Exps Commission @ 15 % For Market Development( 2% of Sales Value)
17.63 2.35
99.79 13.31
117.42 15.66
232791.24 383789.8 -232673.73 -383124.52
616581.04 -615798.25
Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
Cost of Production Raw Material(includes price given to the producer) Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
Packing Exps Cost of Packing @ Rs 0.25 per pack
Total Cost Profit/loss
Annexure 4: Value to Producer Particulars Initial Investment Revenue
Yr 0 130,000.00
Yr 1
Yr 2
Yr 3
3,217,140.00 3,217,140.00 3,464,021.38
Yr 4
Yr 5
4,457,880.00 4,262,042.28
Interest @ 12% Cost of Procurement Vehicle Fare @ Rs 5.5/km for 76 km
15,600.00
12,480.00
9,360.00
6,240.00
3,120.00
451,440.00
451,440.00
451,440.00
451,440.00
451,440.00
Cost of Production Labour(for 3 persons) @ Rs 60/day Factory rent Water Electricity Fuel @ Rs 360 per 1500 ltr Ice
64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 70,450.56 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 86,600.53 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 111,448.74 12,000.00
64,800.00 36,000.00 3,000.00 3,600.00 106,551.79 12,000.00
Packing Exps Cost of Packing @ Rs 0.25 per pack
40,214.88
40,214.88
43,300.27
55,724.37
53,275.90
Administrative Exps Salary Exps Office Exps(Repairs etc) Stationery Misc Exps
68,171.40 1,200.00 600.00 7,200.00
68,171.40 1,200.00 600.00 7,200.00
70,640.21 1,200.00 600.00 7,200.00
80,578.80 1,200.00 600.00 7,200.00
78,620.42 1,200.00 600.00 7,200.00
482,571.00 64,342.80
482,571.00 64,342.80
519,603.21 69,280.43
668,682.00 89,157.60
639,306.34 85,240.85
1,321,190.64 1,895,949.36 32,500.00 1,863,449.36 26,000.00 1,837,449.36 6.26
1,318,070.64 1,899,069.36 24,375.00 1,874,694.36 26,000.00 1,848,694.36 6.30
1,378,624.65 2,085,396.73 18,281.25 2,067,115.48 26,000.00 2,041,115.48 5.66
1,591,671.51 2,866,208.49 13,710.94 2,852,497.55 26,000.00 2,826,497.55 6.09
1,545,955.30 2,716,086.97 10,283.20 2,705,803.77 26,000.00 2,679,803.77 6.04
Sales Exps Commission @ 15 % Market Development Cost ( 2 % of sales) Total Cost Profit/loss Less: Depreciation @ 25% wdv Profit after depreciation Loan Repayment Value given to producer Value given to producer per litre of milk
6.07
Related Documents
Ots 24 > 24029 > Cashflow
November 2019 16
Ots 24 > 24029 > Annexure
November 2019 14
Ots 24 > 24029 > Acknowle
November 2019 8
Ots 24 > 24029 > Finalrep
November 2019 13
Ots 24 > 24029 > Execsum
November 2019 6