Notes To Fs
Notes To Fs
Notes To Fs
YEAR 1 YEAR 2
MONTHS 25kg 50kg 25kg 50kg
AUG - - 56,052.00 62,072.40
Php
SEPT - - 56,052.00 62,072.40
OCT - - 70,065.00 77,590.50
NOV - - 56,052.00 62,072.40
DEC - - 56,052.00 62,072.40
JAN - - 70,065.00 77,590.50
FEB 40,500.00 44,850.00 56,052.00 62,072.40
MARCH 54,000.00 59,800.00 56,052.00 62,072.40
APRIL 54,000.00 44,850.00 56,052.00 62,072.40
MAY Php
Php 54,000.00 59,800.00 70,065.00 77,590.50
JUNE 54,000.00 59,800.00 56,052.00 62,072.40
JULY 54,000.00 44,850.00 70,065.00 77,590.50
TOTAL 310,500.00 313,950.00 728,676.00 806,941.20
TOTAL SALES PER YEAR 624,450.00 1,535,617.20
Php
Php
YEAR 4 YEAR 5
Php Php Php
419.40 435.33
419.40 Php 435.33 Php
419.40 435.33
419.40 435.33
419.40 435.33
419.40 435.33
419.40 435.33
419.40 435.33
Php
419.40 435.33 Php Php Php
419.40 435.33
419.40 435.33
419.40 435.33
YEAR 4 YEAR 5
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
726.95 754.58
YEAR 5
144
180
144
144
180
144
144
180
144
144
180
144
1,872
25
46,800
YEAR 5
92
115
92
92
115
92
92
115
92
92
115
92
1,196
50
59,800
NOTE 2: COST OF GOODS SOLD YEAR 1
Beginning Inventory Php - Php
Direct Materials 13,488.00
Direct Labor 114,450.00
Variable Overhead 120,240.00
Fixed Overhead 139,941.80
Total Cost Of Goods Available for Sale 388,119.80
Less: Ending Inventory 4,564.17
Total Cost Of Goods Sold Php 383,555.63 Php
NOTE 3.2: SA
SACKS YEAR 1
# of sacks 1,311
Cost per sack Php 8.00
Total Cost of Sacks Php 10,488.00
YEAR 1
Fertilizing Php 25,200.00 Php
Insecticide 12,600.00
Watering 15,750.00
Drying 8,400.00
Harvesting 52,500.00
TOTAL Php 114,450.00 Php
CROP 1
FERTILIZERS # OF UNITS
Complete 14-14-14 (sacks) 8 Php
UREA (sacks) 12
AMO 5-IN-1 8
MURIATE OF POTASH (sacks) 8
TOTAL
Php
YEAR 5
3,068
Php 9.29
Php 28,492.78
E OVERHEAD
YEAR 1 Inflation Rate YEAR 2 YEAR 3
8,706.64
28,492.78
37,199.42
29,254.32
13,078.80
18,283.95
9,751.44
60,946.49
131,315.00
139,584.88
139,584.88
120,000.00
10,800.00
4,400.00
2,400.00
2,341.80
139,941.80
448,041.09
113,459.25
3.95
NOTE 7: INVENTORY YEAR 1
Beginning -
Production 45,384
Quantity Sold 44,850
Ending 534
x Cost per unit Php 8.55 Php
ENDING INVENTORY @ COST Php 4,564.17 Php
NOTE 8.1
Storage Area
App. Of Water System Php 2,000.00
App of Electric Connection 5,500.00
Cements 4,125.00
Door 7,900.00
Door Hinges 1,200.00
Door Knob 360.00
Hollow Blocks 16,000.00
Lumber 7,104.00
Construction Sand 18,000.00
Toilet Bowls 8,000.00
Door (for CR) 1,050.00
Door Hinges (for CR) 600.00
Door Knob (for CR) 180.00
Total Php 72,019.00
NOTE 8.2
Land Improvement
Barbed Wire Php 34,000
Iron Pole 40,000
TOTAL Php 74,000
YEAR 1
No. of Hours No. of Working Total
Quantity Cost per kWh Used Days
2 Php 10.91 12 26 Php 272.31
1 10.91 8 26 181.54
1 10.91 8 26 136.16
1 10.91 8 26 567.32
Php 1,157.33
ELLECTRIC BILL
Florescent lamp
Stand Fan
Laptop
Printer
TOTAL
1,500.00
164,908.78
30,120.00
13,742.40
1,008.81
14,800.00
7,201.90
1,884.00
6,100.00
824.00
446.80
365.80
336.00
3,699.80
1,009.80
18,500.00
51,522.42
317,970.51
23,600.00
13,744.32
36,498.24
2,300.00
76,142.56
4,035.24
398,148.31
YEAR 5
-
-
-
Php 500.00
-
-
1,000.00
Php
Php 1,500.00
YEAR 4 YEAR 5
7,828.71 8,126.20
Php 2 Php 2
12 12
187,888.99 195,028.78
30,120.00 30,120.00
Php 157,768.99Php 164,908.78
YEAR 5
Php 164,908.78
12
Php 13,742.40
YEAR 5
Php 120,000.00
YEAR 5
Php 3,000.00
10,500.00
3,000.00
3,500.00
3,600.00
Php 23,600.00
YEAR 5
Php 11,301.47
2,442.85
Php 13,744.32
YEAR 1 YEAR 2
No. of Hours No. of Working Total Inflation Total
Used Days Rate
12 286 Php 1,996.97 0.038 Php 2,072.85 Php
8 286 1,497.72 0.038 1,554.64
8 286 6,240.52 0.038 6,477.66
8 286 - 0.038 -
Php 9,735.21 Php 10,105.15Php
YEAR 4 YEAR 5
Php 2,353.42 Php 2,442.85
YEAR 5
Php 27,861.25
8,636.99
Php 36,498.24
YEAR 4 YEAR 5
Php 2,236.77 Php 2,321.77
12 12
Php 26,841.28 Php 27,861.25
YEAR 4 YEAR 5
2 2
Php 346.70 Php 359.87
12 12
Php 8,320.80 Php 8,636.99
YEAR 5
Php 1,800.00
500.00
Php 2,300.00
YEAR 4 YEAR 5
Php 2,326.24 Php 2,414.64
152.10 157.88
22.37 23.22
223.68 232.18
1,163.12 1,207.32
135.32 140.47
Php 3,887.51 Php 4,035.24
YEAR 3 YEAR 4 YEAR 5
Total Total Total
Ave. NI ROI
656,082.46 1.03
EVERGRAIN SORGHUM
Statement of Partner's Equi
For The Fiscal Year Ended July 31,
YEAR 1
Partners' Capital, Beginning Php - Php
Add: Investments 640,000.00
Net Income - 75,471.74
Less: Withdrawals -
Partners' Capital, Ending Php 564,528.26 Php
YEAR 1
Anselmo, Capital Callanta, Capital Distor, Capital Gabica, Capital
Php - Php - Php - Php - Php
80,000.00 80,000.00 80,000.00 80,000.00
- 78,433.97 11,566.03 11,566.03 - 78,433.97
- - - -
Php 1,566.03 Php 91,566.03 Php 91,566.03 Php 1,566.03 Php
YEAR 2
Anselmo, Capital Callanta, Capital Distor, Capital Gabica, Capital
Php 1,566.03 Php 91,566.03 Php 91,566.03 Php 1,566.03 Php
- - - -
19,240.46 121,240.46 121,240.46 19,240.46
9,724.05 9,724.05 9,724.05 9,724.05
Php 11,082.45 Php 203,082.45 Php 203,082.45 Php 11,082.45 Php
YEAR 3
Anselmo, Capital Callanta, Capital Distor, Capital Gabica, Capital
Php 11,082.45 Php 203,082.45 Php 203,082.45 Php 11,082.45 Php
- - - -
14,863.22 128,863.22 128,863.22 14,863.22
10,186.32 10,186.32 10,186.32 10,186.32
Php 15,759.34 Php 321,759.34 Php 321,759.34 Php 15,759.34 Php
YEAR 4
Anselmo, Capital Callanta, Capital Distor, Capital Gabica, Capital
Php 15,759.34 Php 321,759.34 Php 321,759.34 Php 15,759.34 Php
- - - -
11,756.02 137,756.02 137,756.02 11,756.02
10,775.60 10,775.60 10,775.60 10,775.60
Php 16,739.76 Php 448,739.76 Php 448,739.76 Php 16,739.76 Php
YEAR 5
Anselmo, Capital Callanta, Capital Distor, Capital Gabica, Capital
Php 16,739.76 Php 448,739.76 Php 448,739.76 Php 16,739.76 Php
- - - -
7,625.81 145,625.81 145,625.81 7,625.81
11,262.58 11,262.58 11,262.58 11,262.58
Php 13,102.99 Php 583,102.99 Php 583,102.99 Php 13,102.99 Php
102,000.00
90,000.00
90,000.00
YEAR 2
Abril, Capital Anselmo, Capital Callanta, Capital Distor, Capital
114,000.00
102,000.00
102,000.00
YEAR 3
Abril, Capital Anselmo, Capital Callanta, Capital Distor, Capital
126,000.00
114,000.00
114,000.00
YEAR 4
Abril, Capital Anselmo, Capital Callanta, Capital Distor, Capital
138,000.00
126,000.00
126,000.00
11,756.02 11,756.02 11,756.02 11,756.02
Php 149,756.02 Php 11,756.02 Php 137,756.02 Php 137,756.02 Php
YEAR 5
Abril, Capital Anselmo, Capital Callanta, Capital Distor, Capital
150,000.00
138,000.00
138,000.00
500.00
Php Php
1
Gabica, Capital Parlan, Capital Soriano, Capital Toralba, Capital
90,000.00
90,000.00
90,000.00
2
Gabica, Capital Parlan, Capital Soriano, Capital Toralba, Capital
102,000.00
102,000.00
102,000.00
3
Gabica, Capital Parlan, Capital Soriano, Capital Toralba, Capital
114,000.00
114,000.00
114,000.00
4
Gabica, Capital Parlan, Capital Soriano, Capital Toralba, Capital
126,000.00
126,000.00
126,000.00
11,756.02 11,756.02 11,756.02 11,756.02
Php 11,756.02 Php 137,756.02 Php 137,756.02 Php 137,756.02
5
Gabica, Capital Parlan, Capital Soriano, Capital Toralba, Capital
138,000.00
138,000.00
138,000.00
- - - -
77,792.37 81,490.57 86,204.81 90,100.65
- 77,792.37 - 81,490.57 - 86,204.81 - 90,100.65
44,788.46 - 31,863.34 - 28,988.18 - 37,071.72
54,407.12 99,195.59 67,332.25 38,344.07
Php 99,195.59 Php 67,332.25 Php 38,344.07 Php 1,272.34
YEAR 1
Current Assets
Cash
Inventory
Total Current Assets
Non-current Assets
Plant Expansion Fund
Water Pump Php 12,000.00
Accumulated Depreciation-WP 2,400.00
Agricultural Hose Pipe 11,709.00
Accumulated Depreciation-AHP 2,341.80
Land Improvement 74,000.00
Accumulated Depreciation-LI 14,800.00
Storage Area 72,019.00
Accumulated Depreciation-SA 7,201.90
Office Cabinet 9,420.00
Accumulated Depreciation-OC 1,884.00
Weighing Scale 30,500.00
Accumulated Depreciation-WS 6,100.00
Fire Extinguisher 4,120.00
Accumulated Depreciation-FE 824.00
Stand Fan 2,234.00
Accumulated Depreciation-SF 446.80
Table 1,829.00
Accumulated Depreciation-Table 365.80
Chairs 1,680.00
Accumulated Depreciation-Chairs 336.00
Laptop 18,499.00
Accumulated Depreciation-Laptop 3,699.80
Printer 5,049.00
Accumulated Depreciation-Printer 1,009.80
L300 Truck 185,000.00
Accumulated Depreciation-L300 18,500.00
Total Non-current assets
TOTAL ASSETS
SSS payables
PAGIBIG payables
PhilHealth payables
Utilities payable
Other percentage taxes
Total Liabilities
Abril, Capital
Anselmo, Capital
Callanta, Capital
Distor, Capital
Gabica, Capital
Parlan, Capital
Soriano, Capital
Toralba, Capital
Total Partners' Equity
TOTAL LIABILITIES AND PARTNERS' EQUITY
EVERGRAIN SORGHUM
Statement of Financial Position
For The Fiscal Year Ended July 31, Year 1
YEAR 1 YEAR 2
ASSETS
160,000.00 880,000.00
Php 12,000.00
9,600.00 4,800.00 7,200.00
11,709.00
9,367.20 4,683.60 7,025.40
74,000.00
59,200.00 29,600.00 44,400.00
72,019.00
64,817.10 14,403.80 57,615.20
9,420.00
7,536.00 3,768.00 5,652.00
30,500.00
24,400.00 12,200.00 18,300.00
4,120.00
3,296.00 1,648.00 2,472.00
2,234.00
1,787.20 893.60 1,340.40
1,829.00
1,463.20 731.60 1,097.40
1,680.00
1,344.00 672.00 1,008.00
18,499.00
14,799.20 7,399.60 11,099.40
5,049.00
4,039.20 2,019.60 3,029.40
185,000.00
166,500.00 37,000.00 148,000.00
528,149.10 1,188,239.20
587,120.40 1,314,594.02
LIABILITIES
1,560.00 1,560.00
400.00 400.00
550.00 550.00
1,348.63 1,355.90
18,733.50 46,068.52
22,592.13 49,934.42
PARTNERS' EQUITY
103,566.03 227,082.45
1,566.03 11,082.45
91,566.03 203,082.45
91,566.03 203,082.45
1,566.03 11,082.45
91,566.03 203,082.45
91,566.03 203,082.45
91,566.03 203,082.45
564,528.26 1,264,659.60
Php 587,120.40 Php 1,314,594.02
- -
RGRAIN SORGHUM
nt of Financial Position
Year Ended July 31, Year 1-5
YEAR 3 YEAR 4
ASSETS
Php 67,332.25
54,105.77
121,438.02
1,680,000.00
Php 12,000.00 Php 12,000.00
7,200.00 4,800.00 9,600.00
11,709.00 11,709.00
7,025.40 4,683.60 9,367.20
74,000.00 74,000.00
44,400.00 29,600.00 59,200.00
72,019.00 72,019.00
21,605.70 50,413.30 28,807.60
9,420.00 9,420.00
5,652.00 3,768.00 7,536.00
30,500.00 30,500.00
18,300.00 12,200.00 24,400.00
4,120.00 4,120.00
2,472.00 1,648.00 3,296.00
2,234.00 2,234.00
1,340.40 893.60 1,787.20
1,829.00 1,829.00
1,097.40 731.60 1,463.20
1,680.00 1,680.00
1,008.00 672.00 1,344.00
18,499.00 18,499.00
11,099.40 7,399.60 14,799.20
5,049.00 5,049.00
3,029.40 2,019.60 4,039.20
185,000.00 185,000.00
55,500.00 129,500.00 74,000.00
1,928,329.30
2,049,767.32
LIABILITIES
1,560.00
400.00
550.00
1,363.45
47,819.12
51,692.57
ARTNERS' EQUITY
357,759.34
15,759.34
321,759.34
321,759.34
15,759.34
321,759.34
321,759.34
321,759.34
1,998,074.75
Php 2,049,767.32
-
-
YEAR 4 YEAR 5
2,520,000.00 3,400,000.00
Php 12,000.00
2,400.00 12,000.00 -
11,709.00
2,341.80 11,709.00 -
74,000.00
14,800.00 74,000.00 -
72,019.00
43,211.40 36,009.50 36,009.50
9,420.00
1,884.00 9,420.00 -
30,500.00
6,100.00 30,500.00 -
4,120.00
824.00 4,120.00 -
2,234.00
446.80 2,234.00 -
1,829.00
365.80 1,829.00 -
1,680.00
336.00 1,680.00 -
18,499.00
3,699.80 18,499.00 -
5,049.00
1,009.80 5,049.00 -
185,000.00
111,000.00 92,500.00 92,500.00
2,708,419.40 3,528,509.50
2,827,435.60 3,640,235.75
1,560.00 1560
400.00 400
550.00 550
1,371.28 1,379.41
49,636.25 51,522.42
53,517.53 55,411.83
496,739.76 643,102.99
16,739.76 13,102.99
448,739.76 583,102.99
448,739.76 583,102.99
16,739.76 13,102.99
448,739.76 583,102.99
448,739.76 583,102.99
448,739.76 583,102.99
2,773,918.07 3,584,823.92
Php 2,827,435.60 Php 3,640,235.75
- -
RETURN ON EQUITY Year 1 Year 2 Year 3
Net Income - 75,471.74 777,923.71 814,905.72
Average equity 564,528.26 1,264,659.60 1,998,074.75
Return on Equity -13% 62% 41%
Payback Period
Investment Cash Inflow/ Outflow
Year 1 Year 2 Year 3
- 640,000.00 - 20,303.64 833,091.81 870,073.82
Remaining Recoverable - 660,303.64 172,788.17 -
Payback Period 1.80
INTERNAL RATE OF RETURN
Cash Inflow
Investment Year 1 Year 2 Year 3
- 640,000.00 - 20,303.64 833,091.81 870,073.82
IRR 69.154%
Year 4 Year 5
862,048.14 901,006.49
2,827,435.60 3,640,235.75
30% 25%
Year 4 Year 5
862,048.14 901,006.49
1,654,541.54 1,717,414.12
52% 52%
Year 4 Year 5
1,654,541.54 1,717,414.12
2,827,435.60 3,640,235.75
59% 47%
Year 4 Year 5
119,016.20 111,726.25
53,517.53 55,411.83
222% 202%
Year 4 Year 5
53,517.53 55,411.83
2,773,918.07 3,584,823.92
1.93% 1.55%
ow/ Outflow
Year 4 Year 5
917,216.24 956,174.59
- -
1.80
h Inflow
Year 4 Year 5
917,216.24 956,174.59
.154%
862,048.14 901,006.49
55,168.10 55,168.10
917,216.24 956,174.59
4,178.54
Year 4 Year 5
419.40 435.33
51.38 53.33
368.01 382.00
726.95 754.58
102.76 106.67
624.19 647.91
430,728.87 440,836.73
0.44 0.44
0.56 0.56
161.57 167.71
350.15 363.46
511.72 531.17
369.54 364.36
472.19 465.58
154,982.55 158,619.50
343,257.65 351,312.83
Year 4 Year 5
35,837.59 37,199.42
134,474.84 139,584.88
13,241.15 13,744.32
49,636.25 51,522.42
3,887.51 4,035.24
233,189.83 242,051.04
Year 4 Year 5
120,000.00 120,000.00
10,800.00 10,800.00
4,400.00 4,400.00
500.00 1,500.00
157,768.99 164,908.78
30,120.00 30,120.00
13,147.42 13,742.40
971.88 1,008.81
14,800.00 14,800.00
7,201.90 7,201.90
1,884.00 1,884.00
6,100.00 6,100.00
824.00 824.00
446.80 446.80
365.80 365.80
336.00 336.00
23,600.00 23,600.00
35,162.08 36,498.24
2,300.00 2,300.00
430,728.87 440,836.73
COST AND RETURN ANALYSIS
Per Hectare Cost
Direct Materials YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
Seeds 1,500.00 3,892.50 4,040.42 4,193.95 4,353.32
Sacks 5,244.00 12,738.34 13,222.39 13,724.84 14,246.39
Total Direct Materials 6,744.00 16,630.84 17,262.81 17,918.79 18,599.71
Direct Labor
Fertilizing 12,600.00 13,078.80 13,575.79 14,091.67 14,627.16
Insecticide 6,300.00 6,539.40 8,484.87 4,697.22 6,539.40
Watering 9,450.00 9,809.10 10,181.97 10,568.88 10,970.37
Drying 4,200.00 4,359.60 4,525.26 4,697.22 4,875.72
Harvesting 26,250.00 27,247.50 28,282.91 29,357.66 30,473.25
Total Direct Labor 58,800.00 61,034.40 65,050.81 63,412.66 67,485.89
Variable Overhead
Fertilizers 60,120.00 62,404.56 64,775.93 67,237.42 69,792.44
Total Variable Overhead 60,120.00 62,404.56 64,775.93 67,237.42 69,792.44
Fixed Overhead
Land Rent 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00
Land Preparation 10,800.00 10,800.00 10,800.00 10,800.00 10,800.00
Furrowing 4,400.00 4,400.00 4,400.00 4,400.00 4,400.00
Water Pump 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00
Agricultural Hose Pipe 2,341.80 2,341.80 2,341.80 2,341.80 2,341.80
Total Fixed Overhead 139,941.80 139,941.80 139,941.80 139,941.80 139,941.80
Total Costs 265,605.80 280,011.60 287,031.35 288,510.67 295,819.84
Weekly Demand
AL QUANTITY DEMANDED PER YEAR
1 1 WEEKLY Cash 52 52
1 1 WEEKLY Cash 52 52
2 1 WEEKLY Cash 104 52
4 3 208 156
1 1 WEEKLY Cash 52 52
2 1 WEEKLY Cash 104 52
3 1 WEEKLY Cash 156 52
6 3 312 156
ASSETS
Php
120,000.00 120000
2000
Php
2,000.00 5500
Php
5,500.00 34000
Php
34,000.00 40000
Php
40,000.00 4125
Php
4,125.00 7900
Php
7,900.00 1200
Php
1,200.00 360
Php 360.00 16000
Php
16,000.00 7104
Php
7104.00 18000
Php
18,000.00 8000
Php
8,000.00 1050
Php
1,050.00 600
Php 600.00 180
Php 180.00 1829
Php
1,829.00 1680
Php
1,680.00 2234
Php
2,234.00 185000
Php
185,000.00 9420
Php
9,420.000 30500
Php 30,500 4120
Php 4,120
496,682.00 500802 4120
COST
Php 3,699.80
Php 1,009.80
Php 9,250.00
Php 400.00
Php 3,000.00
Php 500.00
Php 1,300.00
Php 10,500.00
Php 220.00
Php 3,000.00
Php 32,879.60