Broiler Fs
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 Broiler Fs as PDF for free.
More details
- Words: 2,359
- Pages: 27
PROJECT NAME:
BROILER PRODUCTION (80,000 Birds - Capacity)
LOCATION:
Sitio Marag-ing, Brgy. Belen, Leyte - Leyte
PROJECT INVESTMENT CAPITAL: FIXED INVESTMENT: QTY. Unit PARTICULARS UNIT COST 2 has. Land Acquisition/Development ### 1 LS Perimeter Fencing 222,500.00 2 units Broiler House (12 x 42 sq.m.) ### 1.5HP Motor Centrifugal 1 unit 33,585.00 Pump Deepwell with Elevated 1 unit StainlessWater Tank (2000 154,790.00 lit. cap) 1 unit Refrigerator (4 cu.ft. cap.) 7,500.00 714 pcs. Feeders 158.00 250 units Waterers (Bell drinkers) 853.00 2000 units Galloners 78.90 50 units Infrared Lamps w/ pipes & Accessories 4,950.00 16 units LPG Tank (50 kgs. Cap.) 4,500.00 10 units Shovel 497.00 2 units Wheel Borrow 1,450.00 2 units Push cart 1,680.00 16 pcs. Plastic Drum (200 liters cap.) 1,195.00
OPERATIONAL/WORKING CAPITAL: PARTICULARS Salaries & Wages: 1 Person Farm Supervisor 16 Person Animal Caretakers 2 Person Security Personnel 12 monhtly Electricity 12 monhtly Water Utilities 288 tanks LPG (50 kgs.) 1800 m. Laminated plastic sheet
ACEF
PROPONENT AMOUNT (PhP) ### ### 222,500.00 222,500.00 ### ### 33,585.00 33,585.00 154,790.00 7,500.00 112,812.00 213,250.00 157,800.00 247,500.00 72,000.00 4,970.00 2,900.00 3,360.00 19,120.00 SUB-TOTAL ###
154,790.00 7,500.00 112,812.00 213,250.00 157,800.00 247,500.00 72,000.00 4,970.00 2,900.00 3,360.00 19,120.00 ### ###
AMOUNT (PhP) ### ### 10,000.00 4,500.00 10,000.00 5,850.00 2,750.00 2,120.00 57.50
### ### ### 70,200.00 33,000.00 610,560.00 103,500.00
70,200.00 33,000.00 610,560.00 103,500.00
Building Maintenance Cost Licenses and Permit Fees Miscellaneous Expenses
(10% of Building cost)
838,092.57 55,000.00 (13% of the above items) 381,465.83 SUB-TOTAL ### ###
TOTAL PROJECT COST:
NPV BCR IRR ROI PAYBACK
16%
5,692,254.39 1.17 26.05% #REF! 3.05
###
IF: NPV > 1: FEASIBLE NA BAY!!! IF: BCR > 1: FEASIBLE NA BAY !!!
Years
###
838,092.57 55,000.00 381,465.83 ### ###
AMOUNT (PhP)
Schedule 1
PROJECTED PRODUCTION/SALES
Year
No. of Birds
1 2 3 4 5 6 7 8 9 10
80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00
Mortality (%) 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
Grower's Fee (PhP) 13.00 13.65 14.33 15.05 15.80 16.59 17.42 18.29 19.21 20.17
No. of Cycle Income per Year per year (PhP) 8.00 7,904,000.00 8.00 8,299,200.00 8.00 8,714,160.00 8.00 9,149,868.00 8.00 9,607,361.40 8.00 10,087,729.47 8.00 10,592,115.94 8.00 11,121,721.74 8.00 11,677,807.83 8.00 12,261,698.22
AMORTIZATION SCHEDULE: YEAR
PRINCIPAL
1 2 3 4 5 6 7 8 9 10
10,303,605.27 9,273,244.74 8,242,884.22 7,212,523.69 6,182,163.16 5,151,802.64 4,121,442.11 3,091,081.58 2,060,721.05 1,030,360.53
AMORTIZATION PAYMENT 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53
ENDING BALANCE 9,273,244.74 8,242,884.22 7,212,523.69 6,182,163.16 5,151,802.64 4,121,442.11 3,091,081.58 2,060,721.05 1,030,360.53 -
Schedule 2
DIRECT LABOR Position Farm Supervisor Animal Caretakers Security Personnel Total Year 1 2 3 4 5 6 7 8 9 10
No. of Laborer 1 16 2 17
Monthly Rate 10,000.00 4,500.00 10,000.00
Total Amount 120,000.00 864,000.00 240,000.00 1,224,000.00
No. of Laborer 17 17 17 17 17 17 17 17 17 17
Rate per Day
Total Amount 1,224,000.00 1,285,200.00 1,349,460.00 1,416,933.00 1,487,779.65 1,562,168.63 1,640,277.06 1,722,290.92 1,808,405.46 1,898,825.74
Schedule 3
DEPRECIATION EXPENSE
Item Acquisition Cost Estimated Life Perimeter Fencing 222,500.00 10 Broiler House (12 x 42 sq.m.) 8,158,425.70 10 1.5HP Motor Centrifugal Pump 5 33,585.00 Deepwell with Elevated StainlessWater Tank (2000 lit. cap) 154,790.00 5 Refrigerator (4 cu.ft. cap.) 7,500.00 5 Feeders 112,812.00 2 Waterers (Bell drinkers) 213,250.00 2 Galloners 157,800.00 2 Infrared Lamps w/ pipes & Accessories247,500.00 3 LPG Tank (50 kgs. Cap.) 72,000.00 5 Shovel 4,970.00 2 Wheel Borrow 2,900.00 2 Push cart 3,360.00 2 Plastic Drum (200 liters cap.) 19,120.00 5 Total 9,410,512.70
Annual Depreciation 22,250.00 815,842.57 6,717.00 30,958.00 1,500.00 56,406.00 106,625.00 78,900.00 82,500.00 14,400.00 2,485.00 1,450.00 1,680.00 3,824.00 1,225,537.57
Monhtly 10,000.00 72,000.00 20,000.00
Year 1 2 3 4 5 6 7 8 9 10
Dep'n. Cost 1,225,537.57 1,225,537.57 977,991.57 895,491.57 895,491.57 838,092.57 838,092.57 838,092.57 838,092.57 838,092.57
Accum. Dep'n. 1,225,537.57 2,451,075.14 3,429,066.71 4,324,558.28 5,220,049.85 6,058,142.42 6,896,234.99 7,734,327.56 8,572,420.13 9,410,512.70
Operating Assumptions: 1 Broiler Building Area
504.00
sq.m.
2 Building Capacity
###
birds
3 No. of Broiler Houses
4.00
units
4 No. of Days per Production cycle
35.00
5 No. of Cycles per year operation 6 Mortality Rate
7.00 5.00
days cycles %
PROJECTED INCOME STATEMENT
PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
INCOME Grower's Fee
### 8,299,200.00
###
###
###
###
###
###
###
GROSS INCOME
### 8,299,200.00
###
###
###
###
###
###
###
Less: EXPENSES Salaries & Wages:
### 1,285,200.00
###
###
### 1,562,168.63
### 1,722,290.92 1,808,405.46
Electricity
70,200.00
73,710.00
77,395.50
81,265.28
85,328.54
89,594.97
94,074.71
98,778.45
103,717.37
Water Utilities
33,000.00
34,650.00
36,382.50
38,201.63
40,111.71
42,117.29
44,223.16
46,434.31
48,756.03
LPG
610,560.00
641,088.00
673,142.40
706,799.52
742,139.50
779,246.47
818,208.79
859,119.23
902,075.20
Laminated plastic sheet
103,500.00
108,675.00
114,108.75
119,814.19
125,804.90
132,095.14
138,699.90
145,634.89
152,916.64
Building Maintenance Cost
838,092.57
879,997.20
923,997.06
970,196.91
Licenses and Permit Fees
### 1,069,642.09
### 1,179,280.41 1,238,244.43
55,000.00
57,750.00
60,637.50
63,669.38
66,852.84
70,195.49
73,705.26
77,390.52
81,260.05
381,465.83
400,539.13
420,566.08
441,594.39
463,674.11
486,857.81
511,200.70
536,760.74
563,598.77
Depreciation
### 1,225,537.57
977,991.57
895,491.57
895,491.57
838,092.57
838,092.57
838,092.57
838,092.57
Total Expenses
### 4,707,146.89
###
###
### 5,070,010.46
### 5,503,782.05 5,737,066.52
NET INCOME ( Before Tax )
### 3,592,053.11
###
###
### 5,017,719.01
### 5,617,939.69 5,940,741.31
Miscellaneous Expenses
PROJECTED CASH FLOW STATEMENT PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
CASH INFLOW Investment Capital
###
Grower's Fee Total Cash Inflow
###
### 8,299,200.00
###
###
###
###
###
###
###
### 8,299,200.00
###
###
###
###
###
###
###
### 1,285,200.00
###
###
### 1,562,168.63
CASH OUTFLOW FIXED INVESTMENT:
###
Salaries & Wages:
### 1,722,290.92 1,808,405.46
Electricity
70,200.00
73,710.00
77,395.50
81,265.28
85,328.54
89,594.97
94,074.71
98,778.45
Water Utilities
33,000.00
34,650.00
36,382.50
38,201.63
40,111.71
42,117.29
44,223.16
46,434.31
48,756.03
LPG (50 kgs.)
610,560.00
641,088.00
673,142.40
706,799.52
742,139.50
779,246.47
818,208.79
859,119.23
902,075.20
Laminated plastic sheet
103,500.00
108,675.00
114,108.75
119,814.19
125,804.90
132,095.14
138,699.90
145,634.89
152,916.64
Building Maintenance Cost
838,092.57
879,997.20
923,997.06
970,196.91
55,000.00
57,750.00
60,637.50
63,669.38
66,852.84
70,195.49
73,705.26
77,390.52
81,260.05
381,465.83
400,539.13
420,566.08
441,594.39
463,674.11
486,857.81
511,200.70
536,760.74
563,598.77
Licenses and Permit Fees Miscellaneous Expenses Amortization Payment
### 1,069,642.09
103,717.37
### 1,179,280.41 1,238,244.43
### 1,030,360.53
###
###
### 1,030,360.53
### 1,030,360.53 1,030,360.53
Total Cash Outflow
###
### 4,511,969.85
###
###
### 5,262,278.42
### 5,696,050.00 5,929,334.48
Cash Balance, Ending
###
### 3,787,230.15
###
###
### 4,825,451.05
### 5,425,671.74 5,748,473.35
### 6,873,639.47
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
Add: Cash Balance, Beginning NET CASH FLOW
###
###
PROJECTED BALANCE SHEET
PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
ASSETS Current Asset: Loan Proceed
###
Cash on Hand
###
###
###
###
###
###
###
###
###
Fixed Asset: Land Acquisition/Dev't.
### 2,000,000.00
###
###
### 2,000,000.00
### 2,000,000.00 2,000,000.00
Equipment/Building
### 9,410,512.70
###
###
### 9,410,512.70
### 9,410,512.70 9,410,512.70
Less: Accom. Depreciation
### 2,451,075.14
###
###
### 6,058,142.42
### 7,734,327.56 8,572,420.13
###
###
###
###
###
###
###
TOTAL ASSETS
###
###
###
###
LIABILITIES & EQUITY Loans Payable
### 8,242,884.22
###
###
### 4,121,442.11
### 2,060,721.05 1,030,360.53
Owner's Equity
### 4,422,725.83
###
###
### 4,422,725.83
### 4,422,725.83 4,422,725.83
Retained Earnings
### 6,954,697.13
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
TOTAL LIABILITIES & EQUITY
###
###
Year 10
### ###
1,898,825.74 108,903.24 51,193.83 947,178.96 160,562.47 1,300,156.65 85,323.05 591,778.71 838,092.57 5,982,015.22 6,279,683.00
Year 10
### ###
1,898,825.74 108,903.24 51,193.83 947,178.96 160,562.47 1,300,156.65 85,323.05 591,778.71 1,030,360.53 6,174,283.18 6,087,415.04 ### ###
Year 10
### 2,000,000.00 9,410,512.70 9,410,512.70 ###
4,422,725.83 ### ###
FINANCIAL ANALYSIS Name of Project: BROILER PRODUCTION (100,000 birds - Capacity) Location : Brgy. Cabalawan, Tacloban City, LEYTE Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost Project Cost 14,726,331.10
14,726,331.10
Benefit Operating Cost
TOTAL COST
14,726,331.10 4,346,178.93 4,346,178.93 7,904,000.00 4,511,969.85 4,511,969.85 8,299,200.00 4,686,050.32 4,686,050.32 8,714,160.00 4,868,834.81 4,868,834.81 9,149,868.00 5,060,758.52 5,060,758.52 9,607,361.40 5,262,278.42 5,262,278.42 10,087,729.47 5,473,874.32 5,473,874.32 10,592,115.94 5,696,050.00 5,696,050.00 11,121,721.74 5,929,334.48 5,929,334.48 11,677,807.83 6,174,283.18 6,174,283.18 12,261,698.22 52,009,612.82 66,735,943.93 99,415,662.60 NPV IRR BCR ROI Payback Period
Sensitivity Analysis Summary Condition Base Situation 5% increase in cost 10% increase in cost 5% decrease in benefit 10% decrease in benefit
NPV 5,692,254.39 4,658,057.80 3,623,861.22 3,738,689.43 1,785,124.48
BCR 1.17 1.14 1.10 1.11 1.05
IRR 26.05% 24.30% 22.53% 22.74% 19.30%
Net Return
Discounted Discounted Cost Benefit 16% 16% -14,726,331.10 14,726,331.10 0.00 3,557,821.07 3,746,705.98 6,813,793.10 3,787,230.15 3,353,128.61 6,167,657.55 4,028,109.68 3,002,154.09 5,582,793.47 4,281,033.19 2,689,014.12 5,053,390.64 4,546,602.88 2,409,493.00 4,574,189.81 4,825,451.05 2,159,861.42 4,140,430.43 5,118,241.63 1,936,818.38 3,747,803.40 5,425,671.74 1,737,440.25 3,392,408.25 5,748,473.35 1,559,136.17 3,070,714.37 6,087,415.04 1,399,608.76 2,779,525.94 32,679,718.67 38,719,691.88 45,322,706.97 5,692,254.39 26.05% 1.17 32.80 3.05
SENSITIVITY ANALYSIS
5% increase in cost Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,563,487.88 4,737,568.34 4,920,352.83 5,112,276.55 5,313,796.45 5,525,392.34 5,747,568.03 5,980,852.51 6,225,801.20 6,482,997.34 69,336,424.57
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
Discounted Discounted Cost Benefit 16.00% 16.00% (14,726,331.10) 14,726,331.10 3,340,512.12 3,934,041.27 6,813,793.10 3,561,631.66 3,520,785.04 6,167,657.55 3,793,807.17 3,152,261.80 5,582,793.47 4,037,591.45 2,823,464.83 5,053,390.64 4,293,564.95 2,529,967.65 4,574,189.81 4,562,337.13 2,267,854.49 4,140,430.43 4,844,547.91 2,033,659.29 3,747,803.40 5,140,869.24 1,824,312.27 3,392,408.25 5,452,006.63 1,637,092.98 3,070,714.37 5,778,700.88 1,469,589.20 2,779,525.94 30,079,238.03 39,919,359.92 45,322,706.97 4,658,057.80 24.30% 1.14
5% decrease in benefit Year 0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81 5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,508,800.00 7,884,240.00 8,278,452.00 8,692,374.60 9,126,993.33 9,583,343.00 10,062,510.15 10,565,635.65 11,093,917.44 11,648,613.31 94,444,879.47 NPV IRR BCR
Net Revenue -14,726,331.10 3,162,621.07 3,372,270.15 3,592,401.68 3,823,539.79 4,066,234.81 4,321,064.58 4,588,635.83 4,869,585.65 5,164,582.96 5,474,330.13 27,708,935.54 3,738,689.43 22.74% 1.11
Discounted Discounted Cost Benefit 16.00% 16.00% 14,726,331.10 3,746,705.98 6,473,103.45 3,353,128.61 5,859,274.67 3,002,154.09 5,303,653.80 2,689,014.12 4,800,721.11 2,409,493.00 4,345,480.32 2,159,861.42 3,933,408.91 1,936,818.38 3,560,413.23 1,737,440.25 3,222,787.84 1,559,136.17 2,917,178.65 1,399,608.76 2,640,549.64 38,719,691.88 43,056,571.62
10% increase in cost Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,780,796.82 4,963,166.84 5,154,655.35 5,355,718.29 5,566,834.37 5,788,506.26 6,021,261.75 6,265,655.01 6,522,267.93 6,791,711.49 71,936,905.21
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
Discounted Cost 16.00% (14,726,331.10) 14,726,331.10 3,123,203.18 4,121,376.57 3,336,033.16 3,688,441.47 3,559,504.65 3,302,369.50 3,794,149.71 2,957,915.53 4,040,527.03 2,650,442.30 4,299,223.21 2,375,847.56 4,570,854.20 2,130,500.21 4,856,066.74 1,911,184.28 5,155,539.90 1,715,049.79 5,469,986.73 1,539,569.64 27,478,757.39 41,119,027.96 3,623,861.22 22.53% 1.10
Discounted Benefit 16.00% 6,813,793.10 6,167,657.55 5,582,793.47 5,053,390.64 4,574,189.81 4,140,430.43 3,747,803.40 3,392,408.25 3,070,714.37 2,779,525.94 45,322,706.97
10% decrease in benefit Year 0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81 5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,113,600.00 7,469,280.00 7,842,744.00 8,234,881.20 8,646,625.26 9,078,956.52 9,532,904.35 10,009,549.57 10,510,027.04 11,035,528.40 89,474,096.34 NPV IRR BCR
Net Revenue -14,726,331.10 2,767,421.07 2,957,310.15 3,156,693.68 3,366,046.39 3,585,866.74 3,816,678.10 4,059,030.03 4,313,499.56 4,580,692.57 4,861,245.22 22,738,152.41 1,785,124.48 19.30% 1.05
Discounted Cost 0.16 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12 2,409,493.00 2,159,861.42 1,936,818.38 1,737,440.25 1,559,136.17 1,399,608.76 ###
Discounted Benefit 0.16 6,132,413.79 5,550,891.80 5,024,514.13 4,548,051.58 4,116,770.83 3,726,387.39 3,373,023.06 3,053,167.43 2,763,642.93 2,501,573.34 40,790,436.27
FINANCIAL ANALYSIS Name of Project: BROILER PRODUCTION (100,000 birds - Capacity) Location : Brgy. Cabalawan, Tacloban City, LEYTE Year Project Cost 0 1 2 3 4 5 6 7 8 9 10 TOTAL
14,726,331.10
14,726,331.10
Cost Operating Cost
Benefit TOTAL COST
14,726,331.10 -14,726,331.10 4,346,178.93 4,346,178.93 7,904,000.00 3,557,821.07 4,511,969.85 4,511,969.85 8,299,200.00 3,787,230.15 4,686,050.32 4,686,050.32 8,714,160.00 4,028,109.68 4,868,834.81 4,868,834.81 9,149,868.00 4,281,033.19 5,060,758.52 5,060,758.52 9,607,361.40 4,546,602.88 5,262,278.42 5,262,278.42 10,087,729.47 4,825,451.05 5,473,874.32 5,473,874.32 10,592,115.94 5,118,241.63 5,696,050.00 5,696,050.00 11,121,721.74 5,425,671.74 5,929,334.48 5,929,334.48 11,677,807.83 5,748,473.35 6,174,283.18 6,174,283.18 12,261,698.22 6,087,415.04 52,009,612.82 66,735,943.93 99,415,662.60 32,679,718.67 NPV 5,692,254.39 IRR 26.05% BCR 1.17 ROI 0.33 Payback Period 3.05
Sensitivity Analysis Summary Condition Base Situation 5% increase in cost
Net Return
NPV 5,692,254.39 4,658,057.80
BCR 1.17 1.14
IRR 26.05% 24.30%
10% increase in cost 5% decrease in benefit 10% decrease in benefit
3,623,861.22 3,738,689.43 1,785,124.48
1.10 1.11 1.05
22.53% 22.74% 19.30%
Break-Even Point (BEP) Analysis
BEP/kgs.
Fixed Cost = -------------------- + Kgs.
Variable Cost/kgs.
11,410,512.70 = --------------------- + 76,000.00
43.63
= 193.77 Fixed Cost BE Volume (kgs.) = '-------------------Variable Cost/kgs. = 261,533.91
Fixed Cost Variable Cost/kgs. Target Prodn.(kgs.)
BEP/kgs. BE Volume (kgs.)
NALYSIS
SENSITIVITY ANALYSIS
5% increase in cost Discounted Discounted Cost Benefit 16% 16% 14,726,331.10 0.00 3,746,705.98 6,813,793.10 3,353,128.61 6,167,657.55 3,002,154.09 5,582,793.47 2,689,014.12 5,053,390.64 2,409,493.00 4,574,189.81 2,159,861.42 4,140,430.43 1,936,818.38 3,747,803.40 1,737,440.25 3,392,408.25 1,559,136.17 3,070,714.37 1,399,608.76 2,779,525.94 38,719,691.88 45,322,706.97
Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,563,487.88 4,737,568.34 4,920,352.83 5,112,276.55 5,313,796.45 5,525,392.34 5,747,568.03 5,980,852.51 6,225,801.20 6,482,997.34 69,336,424.57
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
(14,726,331.10) 3,340,512.12 3,561,631.66 3,793,807.17 4,037,591.45 4,293,564.95 4,562,337.13 4,844,547.91 5,140,869.24 5,452,006.63 5,778,700.88 30,079,238.03 4,658,057.80 24.30% 1.14
5% decrease in benefit Year 0 1 2 3 4
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81
Benefit
7,508,800.00 7,884,240.00 8,278,452.00 8,692,374.60
Net Revenue -14,726,331.10 3,162,621.07 3,372,270.15 3,592,401.68 3,823,539.79
5 6 7 8 9 10 TOTAL 11,410,512.70 43.63 76,000.0
193.77 261,533.91
5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
9,126,993.33 9,583,343.00 10,062,510.15 10,565,635.65 11,093,917.44 11,648,613.31 94,444,879.47 NPV IRR BCR
4,066,234.81 4,321,064.58 4,588,635.83 4,869,585.65 5,164,582.96 5,474,330.13 27,708,935.54 3,738,689.43 22.74% 1.11
10% increase in cost Discounted Discounted Cost Benefit 16.00% 16.00% 14,726,331.10 3,934,041.27 6,813,793.10 3,520,785.04 6,167,657.55 3,152,261.80 5,582,793.47 2,823,464.83 5,053,390.64 2,529,967.65 4,574,189.81 2,267,854.49 4,140,430.43 2,033,659.29 3,747,803.40 1,824,312.27 3,392,408.25 1,637,092.98 3,070,714.37 1,469,589.20 2,779,525.94 39,919,359.92 45,322,706.97
Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,780,796.82 4,963,166.84 5,154,655.35 5,355,718.29 5,566,834.37 5,788,506.26 6,021,261.75 6,265,655.01 6,522,267.93 6,791,711.49 71,936,905.21
10% decrease in benefit Discounted Cost 16.00% 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12
Discounted Benefit 16.00% 6,473,103.45 5,859,274.67 5,303,653.80 4,800,721.11
Year 0 1 2 3 4
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81
2,409,493.00 4,345,480.32 2,159,861.42 3,933,408.91 1,936,818.38 3,560,413.23 1,737,440.25 3,222,787.84 1,559,136.17 2,917,178.65 1,399,608.76 2,640,549.64 38,719,691.88 43,056,571.62
5 6 7 8 9 10 TOTAL
5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Benefit
7,113,600.00 7,469,280.00 7,842,744.00 8,234,881.20
Net Revenue
Discounted Cost 16.00% (14,726,331.10) 14,726,331.10 3,123,203.18 4,121,376.57 3,336,033.16 3,688,441.47 3,559,504.65 3,302,369.50 3,794,149.71 2,957,915.53 4,040,527.03 2,650,442.30 4,299,223.21 2,375,847.56 4,570,854.20 2,130,500.21 4,856,066.74 1,911,184.28 5,155,539.90 1,715,049.79 5,469,986.73 1,539,569.64 27,478,757.39 41,119,027.96 3,623,861.22 22.53% 1.10
Net Revenue -14,726,331.10 2,767,421.07 2,957,310.15 3,156,693.68 3,366,046.39
Discounted Cost 0.16 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12
Discounted Benefit 16.00% 6,813,793.10 6,167,657.55 5,582,793.47 5,053,390.64 4,574,189.81 4,140,430.43 3,747,803.40 3,392,408.25 3,070,714.37 2,779,525.94 45,322,706.97
Discounted Benefit 0.16 6,132,413.79 5,550,891.80 5,024,514.13 4,548,051.58
8,646,625.26 3,585,866.74 9,078,956.52 3,816,678.10 9,532,904.35 4,059,030.03 10,009,549.57 4,313,499.56 10,510,027.04 4,580,692.57 11,035,528.40 4,861,245.22 89,474,096.34 22,738,152.41 NPV 1,785,124.48 IRR 19.30% BCR 1.05
2,409,493.00 2,159,861.42 1,936,818.38 1,737,440.25 1,559,136.17 1,399,608.76 ###
4,116,770.83 3,726,387.39 3,373,023.06 3,053,167.43 2,763,642.93 2,501,573.34 40,790,436.27
BROILER PRODUCTION (80,000 Birds - Capacity)
LOCATION:
Sitio Marag-ing, Brgy. Belen, Leyte - Leyte
PROJECT INVESTMENT CAPITAL: FIXED INVESTMENT: QTY. Unit PARTICULARS UNIT COST 2 has. Land Acquisition/Development ### 1 LS Perimeter Fencing 222,500.00 2 units Broiler House (12 x 42 sq.m.) ### 1.5HP Motor Centrifugal 1 unit 33,585.00 Pump Deepwell with Elevated 1 unit StainlessWater Tank (2000 154,790.00 lit. cap) 1 unit Refrigerator (4 cu.ft. cap.) 7,500.00 714 pcs. Feeders 158.00 250 units Waterers (Bell drinkers) 853.00 2000 units Galloners 78.90 50 units Infrared Lamps w/ pipes & Accessories 4,950.00 16 units LPG Tank (50 kgs. Cap.) 4,500.00 10 units Shovel 497.00 2 units Wheel Borrow 1,450.00 2 units Push cart 1,680.00 16 pcs. Plastic Drum (200 liters cap.) 1,195.00
OPERATIONAL/WORKING CAPITAL: PARTICULARS Salaries & Wages: 1 Person Farm Supervisor 16 Person Animal Caretakers 2 Person Security Personnel 12 monhtly Electricity 12 monhtly Water Utilities 288 tanks LPG (50 kgs.) 1800 m. Laminated plastic sheet
ACEF
PROPONENT AMOUNT (PhP) ### ### 222,500.00 222,500.00 ### ### 33,585.00 33,585.00 154,790.00 7,500.00 112,812.00 213,250.00 157,800.00 247,500.00 72,000.00 4,970.00 2,900.00 3,360.00 19,120.00 SUB-TOTAL ###
154,790.00 7,500.00 112,812.00 213,250.00 157,800.00 247,500.00 72,000.00 4,970.00 2,900.00 3,360.00 19,120.00 ### ###
AMOUNT (PhP) ### ### 10,000.00 4,500.00 10,000.00 5,850.00 2,750.00 2,120.00 57.50
### ### ### 70,200.00 33,000.00 610,560.00 103,500.00
70,200.00 33,000.00 610,560.00 103,500.00
Building Maintenance Cost Licenses and Permit Fees Miscellaneous Expenses
(10% of Building cost)
838,092.57 55,000.00 (13% of the above items) 381,465.83 SUB-TOTAL ### ###
TOTAL PROJECT COST:
NPV BCR IRR ROI PAYBACK
16%
5,692,254.39 1.17 26.05% #REF! 3.05
###
IF: NPV > 1: FEASIBLE NA BAY!!! IF: BCR > 1: FEASIBLE NA BAY !!!
Years
###
838,092.57 55,000.00 381,465.83 ### ###
AMOUNT (PhP)
Schedule 1
PROJECTED PRODUCTION/SALES
Year
No. of Birds
1 2 3 4 5 6 7 8 9 10
80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00
Mortality (%) 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0
Grower's Fee (PhP) 13.00 13.65 14.33 15.05 15.80 16.59 17.42 18.29 19.21 20.17
No. of Cycle Income per Year per year (PhP) 8.00 7,904,000.00 8.00 8,299,200.00 8.00 8,714,160.00 8.00 9,149,868.00 8.00 9,607,361.40 8.00 10,087,729.47 8.00 10,592,115.94 8.00 11,121,721.74 8.00 11,677,807.83 8.00 12,261,698.22
AMORTIZATION SCHEDULE: YEAR
PRINCIPAL
1 2 3 4 5 6 7 8 9 10
10,303,605.27 9,273,244.74 8,242,884.22 7,212,523.69 6,182,163.16 5,151,802.64 4,121,442.11 3,091,081.58 2,060,721.05 1,030,360.53
AMORTIZATION PAYMENT 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53 1,030,360.53
ENDING BALANCE 9,273,244.74 8,242,884.22 7,212,523.69 6,182,163.16 5,151,802.64 4,121,442.11 3,091,081.58 2,060,721.05 1,030,360.53 -
Schedule 2
DIRECT LABOR Position Farm Supervisor Animal Caretakers Security Personnel Total Year 1 2 3 4 5 6 7 8 9 10
No. of Laborer 1 16 2 17
Monthly Rate 10,000.00 4,500.00 10,000.00
Total Amount 120,000.00 864,000.00 240,000.00 1,224,000.00
No. of Laborer 17 17 17 17 17 17 17 17 17 17
Rate per Day
Total Amount 1,224,000.00 1,285,200.00 1,349,460.00 1,416,933.00 1,487,779.65 1,562,168.63 1,640,277.06 1,722,290.92 1,808,405.46 1,898,825.74
Schedule 3
DEPRECIATION EXPENSE
Item Acquisition Cost Estimated Life Perimeter Fencing 222,500.00 10 Broiler House (12 x 42 sq.m.) 8,158,425.70 10 1.5HP Motor Centrifugal Pump 5 33,585.00 Deepwell with Elevated StainlessWater Tank (2000 lit. cap) 154,790.00 5 Refrigerator (4 cu.ft. cap.) 7,500.00 5 Feeders 112,812.00 2 Waterers (Bell drinkers) 213,250.00 2 Galloners 157,800.00 2 Infrared Lamps w/ pipes & Accessories247,500.00 3 LPG Tank (50 kgs. Cap.) 72,000.00 5 Shovel 4,970.00 2 Wheel Borrow 2,900.00 2 Push cart 3,360.00 2 Plastic Drum (200 liters cap.) 19,120.00 5 Total 9,410,512.70
Annual Depreciation 22,250.00 815,842.57 6,717.00 30,958.00 1,500.00 56,406.00 106,625.00 78,900.00 82,500.00 14,400.00 2,485.00 1,450.00 1,680.00 3,824.00 1,225,537.57
Monhtly 10,000.00 72,000.00 20,000.00
Year 1 2 3 4 5 6 7 8 9 10
Dep'n. Cost 1,225,537.57 1,225,537.57 977,991.57 895,491.57 895,491.57 838,092.57 838,092.57 838,092.57 838,092.57 838,092.57
Accum. Dep'n. 1,225,537.57 2,451,075.14 3,429,066.71 4,324,558.28 5,220,049.85 6,058,142.42 6,896,234.99 7,734,327.56 8,572,420.13 9,410,512.70
Operating Assumptions: 1 Broiler Building Area
504.00
sq.m.
2 Building Capacity
###
birds
3 No. of Broiler Houses
4.00
units
4 No. of Days per Production cycle
35.00
5 No. of Cycles per year operation 6 Mortality Rate
7.00 5.00
days cycles %
PROJECTED INCOME STATEMENT
PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
INCOME Grower's Fee
### 8,299,200.00
###
###
###
###
###
###
###
GROSS INCOME
### 8,299,200.00
###
###
###
###
###
###
###
Less: EXPENSES Salaries & Wages:
### 1,285,200.00
###
###
### 1,562,168.63
### 1,722,290.92 1,808,405.46
Electricity
70,200.00
73,710.00
77,395.50
81,265.28
85,328.54
89,594.97
94,074.71
98,778.45
103,717.37
Water Utilities
33,000.00
34,650.00
36,382.50
38,201.63
40,111.71
42,117.29
44,223.16
46,434.31
48,756.03
LPG
610,560.00
641,088.00
673,142.40
706,799.52
742,139.50
779,246.47
818,208.79
859,119.23
902,075.20
Laminated plastic sheet
103,500.00
108,675.00
114,108.75
119,814.19
125,804.90
132,095.14
138,699.90
145,634.89
152,916.64
Building Maintenance Cost
838,092.57
879,997.20
923,997.06
970,196.91
Licenses and Permit Fees
### 1,069,642.09
### 1,179,280.41 1,238,244.43
55,000.00
57,750.00
60,637.50
63,669.38
66,852.84
70,195.49
73,705.26
77,390.52
81,260.05
381,465.83
400,539.13
420,566.08
441,594.39
463,674.11
486,857.81
511,200.70
536,760.74
563,598.77
Depreciation
### 1,225,537.57
977,991.57
895,491.57
895,491.57
838,092.57
838,092.57
838,092.57
838,092.57
Total Expenses
### 4,707,146.89
###
###
### 5,070,010.46
### 5,503,782.05 5,737,066.52
NET INCOME ( Before Tax )
### 3,592,053.11
###
###
### 5,017,719.01
### 5,617,939.69 5,940,741.31
Miscellaneous Expenses
PROJECTED CASH FLOW STATEMENT PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
CASH INFLOW Investment Capital
###
Grower's Fee Total Cash Inflow
###
### 8,299,200.00
###
###
###
###
###
###
###
### 8,299,200.00
###
###
###
###
###
###
###
### 1,285,200.00
###
###
### 1,562,168.63
CASH OUTFLOW FIXED INVESTMENT:
###
Salaries & Wages:
### 1,722,290.92 1,808,405.46
Electricity
70,200.00
73,710.00
77,395.50
81,265.28
85,328.54
89,594.97
94,074.71
98,778.45
Water Utilities
33,000.00
34,650.00
36,382.50
38,201.63
40,111.71
42,117.29
44,223.16
46,434.31
48,756.03
LPG (50 kgs.)
610,560.00
641,088.00
673,142.40
706,799.52
742,139.50
779,246.47
818,208.79
859,119.23
902,075.20
Laminated plastic sheet
103,500.00
108,675.00
114,108.75
119,814.19
125,804.90
132,095.14
138,699.90
145,634.89
152,916.64
Building Maintenance Cost
838,092.57
879,997.20
923,997.06
970,196.91
55,000.00
57,750.00
60,637.50
63,669.38
66,852.84
70,195.49
73,705.26
77,390.52
81,260.05
381,465.83
400,539.13
420,566.08
441,594.39
463,674.11
486,857.81
511,200.70
536,760.74
563,598.77
Licenses and Permit Fees Miscellaneous Expenses Amortization Payment
### 1,069,642.09
103,717.37
### 1,179,280.41 1,238,244.43
### 1,030,360.53
###
###
### 1,030,360.53
### 1,030,360.53 1,030,360.53
Total Cash Outflow
###
### 4,511,969.85
###
###
### 5,262,278.42
### 5,696,050.00 5,929,334.48
Cash Balance, Ending
###
### 3,787,230.15
###
###
### 4,825,451.05
### 5,425,671.74 5,748,473.35
### 6,873,639.47
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
Add: Cash Balance, Beginning NET CASH FLOW
###
###
PROJECTED BALANCE SHEET
PARTICULARS
Year 0
Year 1
Year 2
Year 3
Year 4
Year 5
Year 6
Year 7
Year 8
Year 9
ASSETS Current Asset: Loan Proceed
###
Cash on Hand
###
###
###
###
###
###
###
###
###
Fixed Asset: Land Acquisition/Dev't.
### 2,000,000.00
###
###
### 2,000,000.00
### 2,000,000.00 2,000,000.00
Equipment/Building
### 9,410,512.70
###
###
### 9,410,512.70
### 9,410,512.70 9,410,512.70
Less: Accom. Depreciation
### 2,451,075.14
###
###
### 6,058,142.42
### 7,734,327.56 8,572,420.13
###
###
###
###
###
###
###
TOTAL ASSETS
###
###
###
###
LIABILITIES & EQUITY Loans Payable
### 8,242,884.22
###
###
### 4,121,442.11
### 2,060,721.05 1,030,360.53
Owner's Equity
### 4,422,725.83
###
###
### 4,422,725.83
### 4,422,725.83 4,422,725.83
Retained Earnings
### 6,954,697.13
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
TOTAL LIABILITIES & EQUITY
###
###
Year 10
### ###
1,898,825.74 108,903.24 51,193.83 947,178.96 160,562.47 1,300,156.65 85,323.05 591,778.71 838,092.57 5,982,015.22 6,279,683.00
Year 10
### ###
1,898,825.74 108,903.24 51,193.83 947,178.96 160,562.47 1,300,156.65 85,323.05 591,778.71 1,030,360.53 6,174,283.18 6,087,415.04 ### ###
Year 10
### 2,000,000.00 9,410,512.70 9,410,512.70 ###
4,422,725.83 ### ###
FINANCIAL ANALYSIS Name of Project: BROILER PRODUCTION (100,000 birds - Capacity) Location : Brgy. Cabalawan, Tacloban City, LEYTE Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost Project Cost 14,726,331.10
14,726,331.10
Benefit Operating Cost
TOTAL COST
14,726,331.10 4,346,178.93 4,346,178.93 7,904,000.00 4,511,969.85 4,511,969.85 8,299,200.00 4,686,050.32 4,686,050.32 8,714,160.00 4,868,834.81 4,868,834.81 9,149,868.00 5,060,758.52 5,060,758.52 9,607,361.40 5,262,278.42 5,262,278.42 10,087,729.47 5,473,874.32 5,473,874.32 10,592,115.94 5,696,050.00 5,696,050.00 11,121,721.74 5,929,334.48 5,929,334.48 11,677,807.83 6,174,283.18 6,174,283.18 12,261,698.22 52,009,612.82 66,735,943.93 99,415,662.60 NPV IRR BCR ROI Payback Period
Sensitivity Analysis Summary Condition Base Situation 5% increase in cost 10% increase in cost 5% decrease in benefit 10% decrease in benefit
NPV 5,692,254.39 4,658,057.80 3,623,861.22 3,738,689.43 1,785,124.48
BCR 1.17 1.14 1.10 1.11 1.05
IRR 26.05% 24.30% 22.53% 22.74% 19.30%
Net Return
Discounted Discounted Cost Benefit 16% 16% -14,726,331.10 14,726,331.10 0.00 3,557,821.07 3,746,705.98 6,813,793.10 3,787,230.15 3,353,128.61 6,167,657.55 4,028,109.68 3,002,154.09 5,582,793.47 4,281,033.19 2,689,014.12 5,053,390.64 4,546,602.88 2,409,493.00 4,574,189.81 4,825,451.05 2,159,861.42 4,140,430.43 5,118,241.63 1,936,818.38 3,747,803.40 5,425,671.74 1,737,440.25 3,392,408.25 5,748,473.35 1,559,136.17 3,070,714.37 6,087,415.04 1,399,608.76 2,779,525.94 32,679,718.67 38,719,691.88 45,322,706.97 5,692,254.39 26.05% 1.17 32.80 3.05
SENSITIVITY ANALYSIS
5% increase in cost Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,563,487.88 4,737,568.34 4,920,352.83 5,112,276.55 5,313,796.45 5,525,392.34 5,747,568.03 5,980,852.51 6,225,801.20 6,482,997.34 69,336,424.57
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
Discounted Discounted Cost Benefit 16.00% 16.00% (14,726,331.10) 14,726,331.10 3,340,512.12 3,934,041.27 6,813,793.10 3,561,631.66 3,520,785.04 6,167,657.55 3,793,807.17 3,152,261.80 5,582,793.47 4,037,591.45 2,823,464.83 5,053,390.64 4,293,564.95 2,529,967.65 4,574,189.81 4,562,337.13 2,267,854.49 4,140,430.43 4,844,547.91 2,033,659.29 3,747,803.40 5,140,869.24 1,824,312.27 3,392,408.25 5,452,006.63 1,637,092.98 3,070,714.37 5,778,700.88 1,469,589.20 2,779,525.94 30,079,238.03 39,919,359.92 45,322,706.97 4,658,057.80 24.30% 1.14
5% decrease in benefit Year 0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81 5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,508,800.00 7,884,240.00 8,278,452.00 8,692,374.60 9,126,993.33 9,583,343.00 10,062,510.15 10,565,635.65 11,093,917.44 11,648,613.31 94,444,879.47 NPV IRR BCR
Net Revenue -14,726,331.10 3,162,621.07 3,372,270.15 3,592,401.68 3,823,539.79 4,066,234.81 4,321,064.58 4,588,635.83 4,869,585.65 5,164,582.96 5,474,330.13 27,708,935.54 3,738,689.43 22.74% 1.11
Discounted Discounted Cost Benefit 16.00% 16.00% 14,726,331.10 3,746,705.98 6,473,103.45 3,353,128.61 5,859,274.67 3,002,154.09 5,303,653.80 2,689,014.12 4,800,721.11 2,409,493.00 4,345,480.32 2,159,861.42 3,933,408.91 1,936,818.38 3,560,413.23 1,737,440.25 3,222,787.84 1,559,136.17 2,917,178.65 1,399,608.76 2,640,549.64 38,719,691.88 43,056,571.62
10% increase in cost Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,780,796.82 4,963,166.84 5,154,655.35 5,355,718.29 5,566,834.37 5,788,506.26 6,021,261.75 6,265,655.01 6,522,267.93 6,791,711.49 71,936,905.21
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
Discounted Cost 16.00% (14,726,331.10) 14,726,331.10 3,123,203.18 4,121,376.57 3,336,033.16 3,688,441.47 3,559,504.65 3,302,369.50 3,794,149.71 2,957,915.53 4,040,527.03 2,650,442.30 4,299,223.21 2,375,847.56 4,570,854.20 2,130,500.21 4,856,066.74 1,911,184.28 5,155,539.90 1,715,049.79 5,469,986.73 1,539,569.64 27,478,757.39 41,119,027.96 3,623,861.22 22.53% 1.10
Discounted Benefit 16.00% 6,813,793.10 6,167,657.55 5,582,793.47 5,053,390.64 4,574,189.81 4,140,430.43 3,747,803.40 3,392,408.25 3,070,714.37 2,779,525.94 45,322,706.97
10% decrease in benefit Year 0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81 5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,113,600.00 7,469,280.00 7,842,744.00 8,234,881.20 8,646,625.26 9,078,956.52 9,532,904.35 10,009,549.57 10,510,027.04 11,035,528.40 89,474,096.34 NPV IRR BCR
Net Revenue -14,726,331.10 2,767,421.07 2,957,310.15 3,156,693.68 3,366,046.39 3,585,866.74 3,816,678.10 4,059,030.03 4,313,499.56 4,580,692.57 4,861,245.22 22,738,152.41 1,785,124.48 19.30% 1.05
Discounted Cost 0.16 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12 2,409,493.00 2,159,861.42 1,936,818.38 1,737,440.25 1,559,136.17 1,399,608.76 ###
Discounted Benefit 0.16 6,132,413.79 5,550,891.80 5,024,514.13 4,548,051.58 4,116,770.83 3,726,387.39 3,373,023.06 3,053,167.43 2,763,642.93 2,501,573.34 40,790,436.27
FINANCIAL ANALYSIS Name of Project: BROILER PRODUCTION (100,000 birds - Capacity) Location : Brgy. Cabalawan, Tacloban City, LEYTE Year Project Cost 0 1 2 3 4 5 6 7 8 9 10 TOTAL
14,726,331.10
14,726,331.10
Cost Operating Cost
Benefit TOTAL COST
14,726,331.10 -14,726,331.10 4,346,178.93 4,346,178.93 7,904,000.00 3,557,821.07 4,511,969.85 4,511,969.85 8,299,200.00 3,787,230.15 4,686,050.32 4,686,050.32 8,714,160.00 4,028,109.68 4,868,834.81 4,868,834.81 9,149,868.00 4,281,033.19 5,060,758.52 5,060,758.52 9,607,361.40 4,546,602.88 5,262,278.42 5,262,278.42 10,087,729.47 4,825,451.05 5,473,874.32 5,473,874.32 10,592,115.94 5,118,241.63 5,696,050.00 5,696,050.00 11,121,721.74 5,425,671.74 5,929,334.48 5,929,334.48 11,677,807.83 5,748,473.35 6,174,283.18 6,174,283.18 12,261,698.22 6,087,415.04 52,009,612.82 66,735,943.93 99,415,662.60 32,679,718.67 NPV 5,692,254.39 IRR 26.05% BCR 1.17 ROI 0.33 Payback Period 3.05
Sensitivity Analysis Summary Condition Base Situation 5% increase in cost
Net Return
NPV 5,692,254.39 4,658,057.80
BCR 1.17 1.14
IRR 26.05% 24.30%
10% increase in cost 5% decrease in benefit 10% decrease in benefit
3,623,861.22 3,738,689.43 1,785,124.48
1.10 1.11 1.05
22.53% 22.74% 19.30%
Break-Even Point (BEP) Analysis
BEP/kgs.
Fixed Cost = -------------------- + Kgs.
Variable Cost/kgs.
11,410,512.70 = --------------------- + 76,000.00
43.63
= 193.77 Fixed Cost BE Volume (kgs.) = '-------------------Variable Cost/kgs. = 261,533.91
Fixed Cost Variable Cost/kgs. Target Prodn.(kgs.)
BEP/kgs. BE Volume (kgs.)
NALYSIS
SENSITIVITY ANALYSIS
5% increase in cost Discounted Discounted Cost Benefit 16% 16% 14,726,331.10 0.00 3,746,705.98 6,813,793.10 3,353,128.61 6,167,657.55 3,002,154.09 5,582,793.47 2,689,014.12 5,053,390.64 2,409,493.00 4,574,189.81 2,159,861.42 4,140,430.43 1,936,818.38 3,747,803.40 1,737,440.25 3,392,408.25 1,559,136.17 3,070,714.37 1,399,608.76 2,779,525.94 38,719,691.88 45,322,706.97
Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,563,487.88 4,737,568.34 4,920,352.83 5,112,276.55 5,313,796.45 5,525,392.34 5,747,568.03 5,980,852.51 6,225,801.20 6,482,997.34 69,336,424.57
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Net Revenue
(14,726,331.10) 3,340,512.12 3,561,631.66 3,793,807.17 4,037,591.45 4,293,564.95 4,562,337.13 4,844,547.91 5,140,869.24 5,452,006.63 5,778,700.88 30,079,238.03 4,658,057.80 24.30% 1.14
5% decrease in benefit Year 0 1 2 3 4
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81
Benefit
7,508,800.00 7,884,240.00 8,278,452.00 8,692,374.60
Net Revenue -14,726,331.10 3,162,621.07 3,372,270.15 3,592,401.68 3,823,539.79
5 6 7 8 9 10 TOTAL 11,410,512.70 43.63 76,000.0
193.77 261,533.91
5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
9,126,993.33 9,583,343.00 10,062,510.15 10,565,635.65 11,093,917.44 11,648,613.31 94,444,879.47 NPV IRR BCR
4,066,234.81 4,321,064.58 4,588,635.83 4,869,585.65 5,164,582.96 5,474,330.13 27,708,935.54 3,738,689.43 22.74% 1.11
10% increase in cost Discounted Discounted Cost Benefit 16.00% 16.00% 14,726,331.10 3,934,041.27 6,813,793.10 3,520,785.04 6,167,657.55 3,152,261.80 5,582,793.47 2,823,464.83 5,053,390.64 2,529,967.65 4,574,189.81 2,267,854.49 4,140,430.43 2,033,659.29 3,747,803.40 1,824,312.27 3,392,408.25 1,637,092.98 3,070,714.37 1,469,589.20 2,779,525.94 39,919,359.92 45,322,706.97
Year
0 1 2 3 4 5 6 7 8 9 10 TOTAL
Cost
14,726,331.10 4,780,796.82 4,963,166.84 5,154,655.35 5,355,718.29 5,566,834.37 5,788,506.26 6,021,261.75 6,265,655.01 6,522,267.93 6,791,711.49 71,936,905.21
10% decrease in benefit Discounted Cost 16.00% 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12
Discounted Benefit 16.00% 6,473,103.45 5,859,274.67 5,303,653.80 4,800,721.11
Year 0 1 2 3 4
Cost 14,726,331.10 4,346,178.93 4,511,969.85 4,686,050.32 4,868,834.81
2,409,493.00 4,345,480.32 2,159,861.42 3,933,408.91 1,936,818.38 3,560,413.23 1,737,440.25 3,222,787.84 1,559,136.17 2,917,178.65 1,399,608.76 2,640,549.64 38,719,691.88 43,056,571.62
5 6 7 8 9 10 TOTAL
5,060,758.52 5,262,278.42 5,473,874.32 5,696,050.00 5,929,334.48 6,174,283.18 66,735,943.93
Benefit
7,904,000.00 8,299,200.00 8,714,160.00 9,149,868.00 9,607,361.40 10,087,729.47 10,592,115.94 11,121,721.74 11,677,807.83 12,261,698.22 99,415,662.60 NPV IRR BCR
Benefit
7,113,600.00 7,469,280.00 7,842,744.00 8,234,881.20
Net Revenue
Discounted Cost 16.00% (14,726,331.10) 14,726,331.10 3,123,203.18 4,121,376.57 3,336,033.16 3,688,441.47 3,559,504.65 3,302,369.50 3,794,149.71 2,957,915.53 4,040,527.03 2,650,442.30 4,299,223.21 2,375,847.56 4,570,854.20 2,130,500.21 4,856,066.74 1,911,184.28 5,155,539.90 1,715,049.79 5,469,986.73 1,539,569.64 27,478,757.39 41,119,027.96 3,623,861.22 22.53% 1.10
Net Revenue -14,726,331.10 2,767,421.07 2,957,310.15 3,156,693.68 3,366,046.39
Discounted Cost 0.16 14,726,331.10 3,746,705.98 3,353,128.61 3,002,154.09 2,689,014.12
Discounted Benefit 16.00% 6,813,793.10 6,167,657.55 5,582,793.47 5,053,390.64 4,574,189.81 4,140,430.43 3,747,803.40 3,392,408.25 3,070,714.37 2,779,525.94 45,322,706.97
Discounted Benefit 0.16 6,132,413.79 5,550,891.80 5,024,514.13 4,548,051.58
8,646,625.26 3,585,866.74 9,078,956.52 3,816,678.10 9,532,904.35 4,059,030.03 10,009,549.57 4,313,499.56 10,510,027.04 4,580,692.57 11,035,528.40 4,861,245.22 89,474,096.34 22,738,152.41 NPV 1,785,124.48 IRR 19.30% BCR 1.05
2,409,493.00 2,159,861.42 1,936,818.38 1,737,440.25 1,559,136.17 1,399,608.76 ###
4,116,770.83 3,726,387.39 3,373,023.06 3,053,167.43 2,763,642.93 2,501,573.34 40,790,436.27
Related Documents
Broiler Fs
June 2020 4
Ayam Broiler
December 2019 16
Fs
June 2020 17
Fs
May 2020 16
Fs
June 2020 23