Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Hazelnut planting financial analysis

VIEWS: 148 PAGES: 21

									Hazelnut planting financial analysis - Mark Shephard - New Forest F

Discounted net income
3,000

2,000

1,000

0

Dollars

-1,000

1

3

5

7

9

11 13 15 17 19 21 23

-2,000

-3,000

-4,000

-5,000

Year

phard - New Forest Farm
Discount rate Net Present Value Internal Rate of Return Change in costs (%) Change in income (%) Price of hired labor/hour Price of family labor/hour Price of plants 0 1,622 2.3 0 0 7.00 25 3.50

Discounted Net Income (Annual) Discounted Net Income (cumulative)

Price per lb. of nuts

0.44

Production - lbs/bush

2.00

Hazelnut planting financial analysis - Mark Shephard - New Fore - Based on a 12 acre planting
Price of Labor - Hired Price of Labor - Family
7.00 25.00 % change Equipment/Machinery

Price of plants Plants/Acre
Standard Amounts

Site Preparation (Site layout, custom plowing and disking) Hired Labor (hours) Family Labor (hours) Custon Plowing Sub total

2.63 1.92

0 0 0

18.38 47.92 25.00 91.29

Planting Costs Hired Labor (hours) Family Labor (hours) - Planting - Travel to pickup plants Fertilizer Plants (number) 19.96 8.83 7.58 873 0 0 0 139.71 220.83 189.58 5.00 3,055.50

SubTotal

3,610.63

Maintenance Hired Labor (hours) - Cultivation and mowing Family Labor (hours) - Winter observation

4.00 3.33

0 0

28.00 83.33

SubTotal

111.33

Harvest and processing costs 0

100.00

TOTAL COSTS

0.00

INCOME 20.00 44.00 Production/plant (lbs./plant) Price/lb of nuts 2.00 0.44

100.00

Sale of Hazelnuts

0.00

NET INCOME

Net income - Annual Net income - Cumulative

Discounted Net income [A] Discounted Net income [C]

3,000 2,000

2,000 1,000
Quetzales

0 -1,000 -2,000 -3,000 -4,000 -5,000
1 3

Tasa de descuento VAN (5%) TIR

Shephard - New Forest Farm

3.50 873.00

0

1

2

3

4

5

6

18.38 47.92 25.00

139.71 220.83 189.58 5.00 3055.50

28.00 83.33

28.00 83.33

28.00 83.33

28.00 83.33

28.00 83.33

0.00

0.00

0.00

0.00

155.79 155.79

225.63 225.63

260.55 260.55

3,813.25 3,813.25

111.33 111.33

111.33 111.33

111.33 111.33

267.12 267.12

225.63 225.63

260.55 260.55

0.00 0.44 0.00 0.00

0.00 0.44 0.00 0.00

0.00 0.44 0.00 0.00

0.00 0.44 0.00 0.00

0.40 0.44 153.65 153.65

1.00 0.44 384.12 384.12

1.40 0.44 537.77 537.77

-3813.25 -3813.25

-111 -3,925

-111 -4,036

-111 -4,147

-113 -4,261

158 -4,102

277 -3,825

-3813.25 -3813.25

-111 -3,925

-111 -4,036

-111 -4,147

-113 -4,261

158 -4,102

277 -3,825

Ingreso Neto Descontado

5

7

9

11

13

15

17

19

21

23

Ingreso Neto Anual Descontado Ingreso Neto Desontado Acumulado

Año

Cambio en costos

0

0
1,622 2 Cambio en ingresos 0

Sueldo (Q/dia)

25

7

8

9

10

11

12

13

28.00 83.33

28.00 83.33

278.01 278.01

312.93 312.93

312.93 312.93

312.93 312.93

0.00

0.00

225.63 225.63

278.01 278.01

312.93 312.93

312.93 312.93

312.93 312.93

111.33 111.33

111.33 111.33

225.63 225.63

1.60 0.44 614.59 614.59

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

0.00 0.44 0.00 0.00

0.00 0.44 0.00 0.00

1.00 0.44 384.12 384.12

337 -3,488

455 -3,033

455 -2,578

455 -2,123

-111 -2,234

-111 -2,345

158 -2,187

337 -3,488

455 -3,033

455 -2,578

455 -2,123

-111 -2,234

-111 -2,345

158 -2,187

14

15

16

17

18

19

20

260.55 260.55

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

260.55 260.55

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

312.93 312.93

1.40 0.44 537.77 537.77

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

277 -1,909

455 -1,454

455 -999

455 -544

455 -88

455 367

455 822

277 -1,909

455 -1,454

455 -999

455 -544

455 -88

455 367

455 822

21

22

23

28.00 83.33

312.93 312.93

312.93 312.93

0.00

312.93 312.93

312.93 312.93

111.33 111.33

2.00 0.44 768.24 768.24

2.00 0.44 768.24 768.24

0.00 0.44 0.00 0.00

455 1,278

455 1,733

-111 1,622

455 1,278

455 1,733

-111 1,622

70


								
To top