Project Financial Plan

  • November 2019
  • PDF

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 Project Financial Plan as PDF for free.

More details

  • Words: 5,211
  • Pages: 34
FINANCIAL PROJECTIONS EXPENSES YEAR

YEARLY

10%

EXPENSES

EXPENSES

BALANCE FOR

SHARING

WAGES/

IN-PUT EXP &

TOTAL

PRODUCTION

FOUNDATION

CHARGE TO

CHARGE TO

PRO-RATA

EACH

OF

ALLOWANCES

CAPITAL EXP

EXPENSES

INCOME

SHARE

INCOME

FOUNDATION

SHARING

MEM-FAMLY

MEM-FAMLY

1

P2,904,000.00

P6,082,000.00

P8,986,000.00

P2,316,140.00

P231,614.00

P2,084,526.00

P6,901,474.00

P0.00

P0.00

2

P2,904,000.00

P832,500.00

P3,736,500.00

P3,827,420.00

P382,742.00

P3,444,678.00

P291,822.00

P0.00

P0.00

NUMBER

50 50

NOTE: NO MORE FUNDING SUPPORT FOR WAGES AFTER THE SECOND YEAR OF OPERATION AS THE PROJECT BECOMING SUSTAINABLE. 3

P1,104,000.00

P1,342,500.00

P2,446,500.00

P4,464,146.40

P446,414.64

P2,446,500.00

P0.00

P1,571,231.76

P31,424.64

4

P1,214,400.00

P1,110,000.00

P2,324,400.00

P5,028,146.40

P502,814.64

P2,324,400.00

P0.00

P2,200,931.76

P44,018.64

5

P1,214,400.00

P445,000.00

P1,659,400.00

P5,585,071.10

P558,507.11

P1,659,400.00

P0.00

P3,367,163.99

P56,119.40

6

P1,214,400.00

P1,225,000.00

P2,439,400.00

P5,984,071.10

P598,407.11

P2,439,400.00

P0.00

P2,946,263.99

P49,104.40

7

P1,335,840.00

P1,355,000.00

P2,690,840.00

P6,282,834.60

P628,283.46

P2,690,840.00

P0.00

P2,963,711.14

P42,338.73

8

P1,335,840.00

P1,282,500.00

P2,618,340.00

P6,371,071.10

P637,107.11

P2,618,340.00

P0.00

P3,115,623.99

P44,508.91

9

P1,335,840.00

P1,412,500.00

P2,748,340.00

P6,458,034.60

P645,803.46

P2,748,340.00

P0.00

P3,063,891.14

P40,851.88

10

P1,469,424.00

P1,340,000.00

P2,809,424.00

P6,503,634.60

P650,363.46

P2,809,424.00

P0.00

P3,043,847.14

P40,584.63

11

P1,469,424.00

P2,570,000.00

P4,039,424.00

P13,744,954.60

P1,374,495.46

P4,039,424.00

P0.00

P8,331,035.14

P83,310.35

AMOUNT IN PESOS: RATE 1 DOLLAR = 49 PESOS AMOUNT NEEDED FOR THE PILOT PROJECT: =

NOTE:

P7,193,296.00 AT P49 PER DOLLAR RATIO =

1. I MMEDIATE FUNDING REQUIREMENT FROM FIRST TO 2ND YEAR IS

P7,193,296.00

$146,801.96 WHEN THE COOPERATIVE NEEDS SUPPORT

FOR IN-PUTS AND WAGES OF MEMBERS TO SUSTAIN THEIR DAILY NEEDS, AS PRODUCTION IS STILL NOT ENOUGH TO SUSTAIN THEIR NEEDS. 3. BEGINNING ON THE 3RD YEAR, EACH MEMBER RECEIVES PRO-RATA SHARING, AFTER DEDUCTING ALL EXPENSES AND ALLOWANCES OF THE . MANAGEMENT TEAM. SEE COLUMN "K" ON THE FINANCIAL PROJECTION ABOVE. 4. FROM 1ST TO 2ND YEAR, THERE WOULD BE 50 MEMBERS; 5TH YEAR = 60 MEMBERS; 7TH YEAR = 70 MEMBERS; 9TH YEAR = 75 MEMBERS AND ON THE 11TH YEAR = 100 MEMBERS. MEMBERSHIP TO THE COOPERATIVE GROWS AS THE PROJECT BECOMES SUSTAINABLE. 4. TEN PER CENT OF THE INCOME GOES TO CAPITAL FUNDS OF THE FOUNDATION FOR EXPANSION PROJECTS IN OTHER COMMUNITIES. 5. ON THE 11TH YEAR - SHARING FOR EACH MEMBER IS

P83,310.35

OR

P6,942.53

A MONTH - A SIGNIFICANT AMOUNT TO MEET

THE NEEDS OF A FAMILY IN A RURAL AREA. THE BENEFITS ARE TWOFOLDS: SUSTAINABLE LIVELIHOOD AND ENVIRONMENTAL PROTECTIOIN. 6. NOTE: EXEMPT ON TAXES BEING A COOPERATIVE. CLICK SHEET 2, 3 AND 4 FOR PRODUCTION SCHEDULE, EXPENSES AND CULTIVATION SCHEDULE.

50 50 60 60 70 70 75 75 100

PRODUCTION PROJECTION 1. FIRST YEAR

NOTE: Expenses for production in sheet 3; expenses for cultivation included in wages of members. 1.1. Cash crops DESCRIPTION NOTE: All cash crop production are deducted 20% casualty, based on estimates. Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 20,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas ( 6 mx 3 m = 555 hills per hec Jackfruit (9 m x 12m ) = 92 trees/hec Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/; 1 kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL

AREA PLANTED

PRODUCTION IN KILOS

1 hectare 1 hectare 1 hectare 2 hectares 2 hectaes 1 hectare 1 hectare 2 hectares 1 hectare

36,000 24,000 13,300 0 0 21,120 12,000 41,600 24,000

DAILY CATCH IN KILOS

YEARLY PRODUCTION IN KILOS

20 20 20

4,000 4,000 4,000

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

AMOUNT

P360,000.00 P240,000.00 P199,500.00 P0.00 P0.00 P253,440.00 P180,000.00 P291,200.00 P192,000.00 P1,716,140.00

NOTE: TREE FARMING - 2 m x 2 m = 2,500 trees/hec; 20% casualty = 2,000 trees/hec; then thinning 50% on the 3rd, 5th and 7th years; last remaining trees = 250/hec on the 11th year; 4 m x 8 m apart.

1.2. Fishing (estimated 200 days/year) DESCRIPTION Nets Hook and line Other means SUB-TOTAL TOTAL ESTIMATED EARNINGS FIRST YEAR

UNIT PRICE KILO

P50.00 P50.00 P50.00

AMOUNT

P200,000.00 P200,000.00 P200,000.00 P600,000.00 P2,316,140.00

2. SECOND YEAR 2.1. Cash crops DESCRIPTION NOTE: All cash crop production are deducted 20% casualty, based on estimates. Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas ( 6 mx 3 m = 555 hills; 1 tree/hill) 12 kls/tree = (2 hecs bearing) Jackfruit (9 m x 12m ) = 92 trees/hec Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL

AREA PLANTED

PRODUCTION IN KILOS

2 hectares 2 hectare 1 hectares 3 hectares 3 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

72,000 48,000 14,500 13,320 0 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

30 30 30

6,000 6,000 6,000

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

AMOUNT

P720,000.00 P480,000.00 P217,500.00 P159,840.00 P0.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P2,927,420.00

2.2. Fishing (estimated 200 days/year) DESCRIPTION Nets Hook and line Other means SUB-TOTAL TOTAL ESTIMATED EARNINGS SECOND YEAR

NOTE: TREE FARMING - 2 m x 2 m = 2,500 trees/hec; 20% casualty = 2,000 trees/hec; then thinning 50% on the 3rd, 5th and 7th years; last remaining trees = 250/hec on the 11th year; 4 m x 8 m apart.

UNIT PRICE

P50.00 P50.00 P50.00

AMOUNT

P300,000.00 P300,000.00 P300,000.00 P900,000.00 P3,827,420.00

THIRD YEAR 3.1. Cash crops DESCRIPTION NOTE: All cash crop production are deducted 20% casualty, based on estimates. Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 2 tree/hill, 2 hecs; 1 tree/hill, 1 hec) 12 kls/tree = (3 hecs bearing) Jackfruit (9 m x 12m ) = 92 trees/hec Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 4 hectares 4 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 27,000 0 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

40 30 30

8,000 6,000 6,000

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P324,000.00 P0.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P3,451,580.00

3.2. Fishing (estimated 200 days/year) DESCRIPTION Nets Hook and line Other means TOTAL EARNINGS FISHING

UNIT PRICE

P50.00 P50.00 P50.00

AMOUNT

P400,000.00 P300,000.00 P300,000.00 P1,000,000.00

3.3. Tree Farming - thinning DESCRIPTION First area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 = NOTE: FOR FIREWOOD ONLY

TOTAL ESTIMATED EARNINGS THIRD YEAR

YEARLY PRODUCTION IN CU.M.

125.66

PRINCE PER CU.M.

P100.00

AMOUNT

P12,566.40

P4,464,146.40

4. FOURTH YEAR YEAR 4.1. Cash crops DESCRIPTION NOTE: All cash crop production are deducted 20% casualty, based on estimates. Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill, 2 hecs; 2 tree/hill, 1 hec; 1 tree/hill, 1 hec) 12 kls/tree = (4 hecs bearing) Jackfruit (9 m x 12m ) = 92 trees/hec Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL NOTE: ASSUME bananas bearing 10 kgs for each tree; 1 tree on the 2nd year; 2 trees on the 3rd year and 3 trees on the 4th year and onward per "hill".

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 49,000 0 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

50 40 40

10,000 8,000 8,000

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P588,000.00 P0.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P3,715,580.00

4.2. Fishing (estimated 200 days/year) DESCRIPTION Nets Hook and line Other means TOTAL EARNINGS FISHING

UNIT PRICE

P50.00 P50.00 P50.00

AMOUNT

P500,000.00 P400,000.00 P400,000.00 P1,300,000.00

4.3. Tree Farming - cuttings DESCRIPTION Second area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 = NOTE: FOR FIREWOOD ONLY SUB-TOTAL

TOTAL ESTIMATED EARNINGS FOURTH YEAR

YEARLY PRODUCTION IN CU.M.

125.66

PRINCE PER CU.M.

P100.00

AMOUNT

P12,566.40 P12,566.40 P5,028,146.40

5. FIFTH YEAR DESCRIPTION

AREA PRODUCTION PLANTED IN KILOS

UNIT PRICE

AMOUNT

5.1. Cash crops NOTE: All cash crop production are deducted 20% casualty, based on estimates. Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill, 3 hecs; 2 tree/hill, 2 hec ( 5 hecs bearing) Jackfruit (9 m x 12m ) = 92 trees/hec Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL

DESCRIPTION

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 70,000 0 42,240 24,000 41,600 24,000

DAILY YEARLY PRODCTN PRODUCTION

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

5.2. Fishing (estimated 200 days/year) Same as 4th year earnings with 20% increase

P1,080,000.00 P480,000.00 P217,500.00 P840,000.00 P0.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P3,967,580.00

AMOUNT P1,560,000.00

5.3. Tree Farming - cuttings DESCRIPTION First area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees - paper mill then: 8 cm x 2 m = 0.00502 x 5,000 -firewood Third area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 - firewood ESTIMATED EARNINGS TREE FARMING

TOTAL ESTIMATED EARNINGS FIFTH YEAR

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

AMOUNT

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P57,491.10 P5,585,071.10

6. SIXTH YEAR DESCRIPTION 6.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill, 3 hecs; 2 tree/hill, 2 hec ( 5 hecs bearing) Jackfruit = 92 trees/hec; 5 fruits/tree; 8 kls/fruit (2 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 70,000 5,800 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

6.2. Fishing (estimated 200 days/year) Same as 5th year earnings with 20% increase

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P840,000.00 P87,000.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,054,580.00 AMOUNT

P1,872,000.00

6.3. Tree Farming - cuttings

DESCRIPTION Second area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees - for paper mills then: 8 cm x 2 m = 0.00502 x 5,000 - firewood Fourth area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 - firewood ESTIMATED EARNINGS TREE FARMING

TOTAL ESTIMATED EARNINGS SIXTH YEAR

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

AMOUNT

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P57,491.10 P5,984,071.10

7. SEVENTH YEAR DESCRIPTION 7.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 15,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill ( 5 hecs bearing) Jackfruit = 92 trees/hec; 2 hecs, 10 fruits/tree; 1 hec, 5 fruit/tree; 8 kls/fruit (3 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PRODUCTION PLANTED IN KILOS 3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 79,000 14,720 42,240 24,000 41,600 24,000

DAILY YEARLY PRODCTN PRODUCTION

UNIT PRICE P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

7.2. Fishing (estimated 200 days/year) Same as 6th year earnings

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P948,000.00 P220,800.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,296,380.00 AMOUNT P1,872,000.00

7.3. Tree Farming - cuttings

DESCRIPTION First area: cut 50% of the remaining 5,000 trees = 2,500 trees with 15 cm dia by 2.5 m = 0.0176 x 5 m x 2,500 trees - paper mill then: 10 cm by 2 m = 0.0078 x 2,500 trees - firewood Third area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees - paper mill then: 8 cm x 2 m = 0.00502 x 5,000 - firewood Fifth area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 - firewood ESTIMATED EARNINGS TREE FARMING

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

220

P250.00 P100.00

20

AMOUNT

P55,000.00 P1,963.50

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P114,454.60

TOTAL ESTIMATED EARNINGS SEVENTH YEAR

P6,282,834.60

8. EIGHTH YEAR DESCRIPTION 8.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 30,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill ( 5 hecs bearing) Jackfruit = 92 trees/hec; 3 hecs, 10 fruits/tree; 1 hec, 5 fruit/tree; 8 kls/fruit (4 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 79,000 20,600 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

8.2. Fishing (estimated 200 days/year) Same as 7th year

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P948,000.00 P309,000.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,384,580.00 AMOUNT

P1,872,000.00

8.3. Tree Farming - cuttings

DESCRIPTION Second area: cut 50% of the remaining 5,000 trees = 2,500 trees with 15 cm dia by 2.5 m = 0.0176 x 5 m x 2,500 trees - paper mill then: 10 cm by 2 m = 0.0078 x 2,500 trees -firewood Fourth area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees - paper mill then: 8 cm x 2 m = 0.00502 x 5,000 - firewood Sixth area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 = ESTIMATED EARNINGS TREE FARMING

TOTAL ESTIMATED EARNINGS EIGHTH YEAR

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

220

P250.00 P100.00

20

AMOUNT

P55,000.00 P2,000.00

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P114,491.10 P6,371,071.10

9. NINTH YEAR DESCRIPTION 9.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 30,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill ( 5 hecs bearing) Jackfruit = 92 trees/hec; 4 hecs, 10 fruits/tree; 1 hec, 5 fruit/tree; 8 kls/fruit (5 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 79,000 26,400 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

9.2. Fishing (estimated 200 days/year) Same as 7th year

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P948,000.00 P396,000.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,471,580.00 AMOUNT

P1,872,000.00

9.3. Tree Farming - cuttings

DESCRIPTION Third area: cut 50% of the remaining 5,000 trees = 2,500 trees with 15 cm dia by 2.5 m = 0.0176 x 5 m x 2,500 trees = then: 10 cm by 2 m = 0.0078 x 2,500 trees Fifth area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees = then: 8 cm x 2 m = 0.00502 x 5,000 = Seventh area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 = ESTIMATED EARNINGS TREE FARMING

TOTAL ESTIMATED EARNINGS NINTH YEAR

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

220

P250.00 P100.00

20

AMOUNT

P55,000.00 P1,963.50

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P114,454.60 P6,458,034.60

10. TENTH YEAR DESCRIPTION 10.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 30,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill ( 5 hecs bearing) Jackfruit = 92 trees/hec; 5 hecs, 10 fruits/tree; 8 kls/fruit (5 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 79,000 29,440 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

10.2. Fishing (estimated 200 days/year) Same as 8th year

10.3. Tree Farming - cuttings Fourth area: cut 50% of the remaining 5,000 trees = 2,500 trees with 15 cm dia by 2.5 m = 0.0176 x 5 m x 2,500 trees -for paper mill then: 10 cm by 2 m = 0.0078 x 2,500 trees -firewood

TOTAL ESTIMATED EARNINGS TENTH YEAR

P1,080,000.00 P480,000.00 P217,500.00 P948,000.00 P441,600.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,517,180.00 AMOUNT

P1,872,000.00

DESCRIPTION

Sixth area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees = then: 8 cm x 2 m = 0.00502 x 5,000 = Eighth area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 = ESTIMATED EARNINGS TREE FARMING

AMOUNT

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

220

P250.00 P100.00

20

AMOUNT

P55,000.00 P1,963.50

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P114,454.60 P6,503,634.60

11. ELEVENTH YEAR DESCRIPTION 11.1. Cash crops Water Melon = staggered planting (1.5 fruit per sq m = 30,000; estimated 3 kls per fruit) Kalabasa = 2 fruits per sq. m., = 40,000; estimated 1.5 kls/fruit Pipino = 5 fruit per sq m., 3 pcs/kl Bananas = 555 hills; 3 tree/hill ( 5 hecs bearing) Jackfruit = 92 trees/hec; 5 hecs, 10 fruits/tree; 8 kls/fruit (5 hecs bearing) Papaya (3m x 3 m) = 1,100 trees/hec; 8 fruits/tree/year; 3 kls/fruit Egg plant = staggered planting - 15,000 trees/hec/ 1kl/tree/year Casava = (3/4 x 1 m = 13,000 hills/hec; 2 kls/hill camote (30,000 hills/hec) 1 kl/hill SUB-TOTAL DESCRIPTION

AREA PLANTED

PRODUCTION IN KILOS

3 hectares 2 hectare 1 hectares 5 hectares 5 hectaes 2 hectares 1 hectares 2 hectares 1 hectare

108,000 48,000 14,500 79,000 29,440 42,240 24,000 41,600 24,000

DAILY PRODCTN

YEARLY PRODUCTION

UNIT PRICE

P10.00 P10.00 P15.00 P12.00 P15.00 P12.00 P15.00 P7.00 P8.00

UNIT PRICE

11.2. Fishing (estimated 200 days/year) Same as 7th year

AMOUNT

P1,080,000.00 P480,000.00 P217,500.00 P948,000.00 P441,600.00 P506,880.00 P360,000.00 P291,200.00 P192,000.00 P4,517,180.00 AMOUNT

P1,872,000.00

11.3. Tree Farming

DESCRIPTION

YEARLY PRODUCTION IN CU.M.

PRINCE PER CU.M.

AMOUNT

TOTAL BRD FT

PRICE/BRD FT

AMOUNT

66,666 106,650 40,000

P20.00 P20.00 P20.00

40,000 30,000 20,000

P20.00 P20.00 P20.00

P1,333,320.00 P2,133,000.00 P800,000.00 P0.00 P800,000.00 P600,000.00 P400,000.00

25,000 16,500 16,500 150 cu. m.

P20.00 P20.00 P20.00 P100.00

P500,000.00 P330,000.00 P330,000.00 P15,000.00

Main cropping: First area: remaining 2,500 trees with 30 cm dia ASSUME: 30 cm by 16 ft will produce each 1 pc 2 x 10 x 16 = 26.66 brd ft 2 pcs 2 x 8 x 16 = 42.66 brd ft 2 pcs 1x 6 x 16= 16 brd ft then: next cut will be 26 cm by 12 ft 1 pc 2 x 8 x 12 = 16 bf 2 pcs 1 x 6 x 12 = 12 bf 2 pcs 1 x 4 x 12 = 8 bf then: 20 cm by 10 ft 1 pc 2 x 6 x 10 = 10 bf 2 pcs 1 x 4 x 10 = 6.6 bf 2 pcs 2 x 2 x 10 = 6.6 bf then: cuttings for firewood 16 cm x 3 m - firewood

Fifth area: cut 50% of the remaining 5,000 trees = 2,500 trees with 15 cm dia by 2.5 m = 0.0176 x 5 m x 2,500 trees - for paper mills then: 10 cm by 2 m = 0.0078 x 2,500 trees -firewood Seventh area: cut 50% of the remaining = 10,000 trees = 5,000 trees with 12 cm diameter by 2.5 mtrs height = 0.0113 x 3 mtrs = 0.0339 x 5,000 trees = then: 8 cm x 2 m = 0.00502 x 5,000 for firewood Ninth area: 10 hectares planted at 2 m by 2 m = 25,000 trees, less 20% casualty = 20,000 trees, cut 50% for thinning = 10,000 at 8 cm dia by 2.5 mtrs length = 0.00502 x 10,000 - firewood ESTIMATED EARNINGS TREE FARMING

TOTAL ESTIMATED EARNINGS ELEVENTH YEAR 12. TWELVETH YEAR ONWARDS THE SAME AS ELEVENTH YEAR INCOME

220

20

P250.00 P100.00

P55,000.00 P1,963.50

169.646 25.132

P250.00 P100.00

P42,411.50 P2,513.20

125.66

P100.00

P12,566.40 P7,355,774.60 P13,744,954.60 P13,744,954.60

FINANCIAL PLAN (FUNDING REQUIREMENTS) As could be gleaned from the Financial Projection in sheet 1 hereof, the total needed funding is from first to second year. P7,193,296.00 On the first year, total expenses = P6,082,000.00 while income is only P2,316,140.00 hence a deficit of P3,765,860.00 Funding support is only up to the second year , as it is projected that by the 3rd year, the project becomes sustainable. Initial members are 50 families; by the 5th year, membership grows to 60; 7th year = 70; 9th year = 75; and 11th year = 100. Profit sharing for each member-family starts on the 3rd year onwards. By the 11th year, when the main crop (tree farming) will be harvested, income of each member-family increases to P83,310.35 annually.

DETAILED ESTIMATES - EXPENSES FIRST YEAR 1. CAPITAL OUTLAYS 1.1. Water System (Dam and pipings and fittings) Source about 1.7 km from project area. This is necessary for the cash crops. 1.2. 6 units 1.5-inch electric pumps 1.3. Multi-purpose Building To serve as office, bodega, meeting place, training center, worship place, etc. 1.4. Service vehicle ( 4 x 4 pick-up) 2. INPUTS 2.1. Farm implements (tools and equipment) 2.2. Seeds, seedlings, fertilizers, pesticides, etc. 2.3. Fishing implements (motorized pump boat & other fishing paraphernalia

P4,800,000.00 P2,000,000.00

P300,000.00 P1,500,000.00

P1,000,000.00 P1,000,000.00 P200,000.00 P500,000.00 P300,000.00

3. ADMINISTRATIVE EXPENSES 3.1. Fuel, oil and lubricant P150,000.00 3.2. Electricity (for pumps and Multi-purpose center) P72,000.00 3.3. Office Supplies P60,000.00 TOTAL CAPITAL OUTLAYS, MAINT AND OPERATING EXPENSES

P282,000.00

P6,082,000.00

4. WAGES OF LABORERS P1,800,000.00 daily wage of P150/person/5 working days/week or P3,000/person per month x 50 families NOTE: WAGES are intended for expenses for planting, cultivation and maintenance of tree farm and other livelihood activities. THE MANAGEMENT TEAM (ALSO MEMBERS OF THE COOP BOARD OF DIRECTORS) 1. Project Manager 2. Three Project Operations Officers - (two for farming and one for fishing) 3. Literacy Project Director - incharge of literacy program 4. Spiritual Project Director - incharge of Christian Life program 5. Administrative Officer - incharge of Social Security program and Admin work 6. Tresurer 7. Driver 5. ALLOWANCE OF MANAGEMENT TEAM (Board of Directors) 5.1. Project Manager = P15,000/month 5.2. Three Operations Officers = P10,000/month 5.3. Literacy Project Director = P10,000/month 5.4. Spiritual Project Director = P10,000/molnth 5.5. Admin Officer = P10,000.month 5.6. Treasurer = P10,000.00/month - salary 5.7. Driver = P7,000.00 - salary TOTAL PERSONAL EXPENSES TOTAL EXPENSES 1ST YEAR

P1,104,000.00 P180,000.00 P360,000.00 P120,000.00 P120,000.00 P120,000.00 P120,000.00 P84,000.00 P2,904,000.00 P8,986,000.00

SECOND YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 2. ADMINISTRATIVE EXPENSES 3.1. Fuel, oil and lubricant 3.2. Electricity 3.3. Office supplies TOTAL MOOE

P600,000.00 P550,000.00 P50,000.00 P232,500.00 P150,000.00 P52,500.00 P30,000.00 P832,500.00

3. WAGES OF LABORERS daily wage of P150/person/5 working days/week or P3,000/person per month x 50 families

P1,800,000.00

3. ALLOWANCE OF MANAGEMENT TEAM (see item 5 above) TOTAL PERSONAL EXPENSES

P1,104,000.00 P2,904,000.00

TOTAL EXPENSES 2ND YEAR

P3,736,500.00

NOTE: NO MORE SALARIES FOR MEMBERS ON THE THIRD YEAR; ONLY PRO-RATA SHARING FROM PRODUCTION INCOME. THIRD YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements

P600,000.00 P52,500.00

P652,500.00

2. ADMINISTRATIVE EXPENSES 2.1. Office supplies 2.2. Fuel, oil and lubricant (including chain saws) 2.3. Electricity

P35,000.00 P300,000.00 P55,000.00

3. CAPITAL OUTLAYS 3.1. 10 chain saws

P300,000.00

P390,000.00

P300,000.00

TOTAL MOOE

P1,342,500.00

4. ALLOWANCE OF MANAGEMENT TEAM (see item above)

P1,104,000.00

TOTAL EXPENSES FOR THE THIRD YEAR

P2,446,500.00

FOURTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE

P700,000.00 P650,000.00 P50,000.00 P410,000.00 P320,000.00 P57,500.00 P32,500.00 P1,110,000.00

3. ALLOWANCE OF MANAGEMENT TEAM (see above with 10% increase ) TOTAL EXPENSES FOURTH YEAR

P1,214,400.00 P2,324,400.00

FIFTH YEAR 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 1.3. Materials and equipment for tree harvesting 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3 Office supplies TOTAL MOOE

P700,000.00 P50,000.00 P100,000.00 P445,000.00 P350,000.00 P60,000.00 P35,000.00 P445,000.00

3. ALLOWANCE OF MANAGEMENT TEAM (see item 3 above)

P1,214,400.00

TOTAL EXPENSES FIFTH YEAR

P1,659,400.00

SIXTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE

P750,000.00 P700,000.00 P50,000.00 P475,000.00 P375,000.00 P62,500.00 P37,500.00 P1,225,000.00

3. ALLOWANCE OF MANAGEMENT TEAM

P1,214,400.00

TOTAL EXPENSES SIXTH YEAR

P2,439,400.00

SEVENTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 1.3. Materials and equipment for tree harvesting

2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE

P850,000.00 P700,000.00 P50,000.00 P100,000.00

P505,000.00 P400,000.00 P65,000.00 P40,000.00 P1,355,000.00

3. ALLOWANCE OF MANAGEMENT TEAM (with 10% increase)

P1,335,840.00

TOTAL EXPENSES SEVENTH YEAR

P2,690,840.00

EIGHTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE

P750,000.00 P700,000.00 P50,000.00 P532,500.00 P425,000.00 P65,000.00 P42,500.00 P1,282,500.00

3. ALLOWANCE OF MANAGEMENT TEAM

P1,335,840.00

TOTAL EXPENSES EIGTH YEAR

P2,618,340.00

NINTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 1.3. Materials and equipment for tree harvesting 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE 3. ALLOWANCE OF MANAGEMENT TEAM

P850,000.00 P700,000.00 P50,000.00 P100,000.00 P562,500.00 P450,000.00 P67,500.00 P45,000.00 P1,412,500.00 P1,335,840.00

TOTAL EXPENSES NINTH YEAR

P2,748,340.00

TENTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Office supplies TOTAL MOOE

P750,000.00 P700,000.00 P50,000.00 P590,000.00 P475,000.00 P67,500.00 P47,500.00 P1,340,000.00

3. ALLOWANCE OF MANAGEMENT TEAM (with 10% increase)

P1,469,424.00

TOTAL EXPENSES TENTH YEAR

P2,809,424.00

ELEVENTH YEAR 1. INPUTS 1.1. Seeds, seedlings, fertilizers, pesticides, etc. 1.2. Fishing implements 1.3. Materials and equipment for tree harvesting 2. ADMINISTRATIVE EXPENSES 2.1. Fuel, oil and lubricant 2.2. Electricity 2.3. Officd supplies 3. CAPITAL OUTLAYS 3.1. 10 chain saws TOTAL MOOE AND CAPITAL OUTLAYS 4. ALLOWANCE OF MANAGEMENT TEAM TOTAL EXPENSES 11TH YEAR

P1,050,000.00 P700,000.00 P50,000.00 P300,000.00 P1,120,000.00 P1,000,000.00 P70,000.00 P50,000.00 P400,000.00 P400,000.00 P2,570,000.00 P1,469,424.00 P4,039,424.00

SCHEDULE OF PLANTING, THINNING, PRUNNING AND HARVESTING YEAR PLANTING HECTARES TREES CASUALTY REMAINING

1ST 10 2500 500 2000

2ND 10 2500 500 2000

THINNING HECTARES TREES PRUNNING HECTARES TREES HARVESTING HECTARES TREES

10 2000

3RD

4TH

5TH

6TH

7TH

8TH

9TH

10TH

11TH

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

10 2500 500 2000

12TH ONWARDS 10 SAME 2500 AS 500 11TH YEAR 2000

10 1000

10 1000

20 2000

20 2000

30 3000

30 3000

30 3000

30 3000

30 3000

20 3000

30 4000

40 5000

50 6000

60 7000

60 7000

60 7000

60 7000

60 7000

10 5000 THINNING SCHEDULE IS 3RD, 5TH AND 7TH YEAR OF A PARTICULAR AREA PRUNNING SCHEDULE - YEARLY UP TO 7TH YEAR FOR A PARTICULAR AREA AND CONTINUES IN OTHER AREAS HARVESTING STARTS ON THE 11TH YEAR ONWARDS

Related Documents

Project Financial Plan
November 2019 12
Financial Project
June 2020 10
Financial Plan
November 2019 17
Project Plan
June 2020 27
Project Plan
November 2019 36