José Contreras S
José Contreras S
, MSC
FORMULATION AND
EVALUATION OF
PROJECTS
AGRICULTURAL
PROLOGUE
This definition in conceptual terms encompasses the decision that will analyze the
advantages and disadvantages of investing existing resources, within the economy
it has multiple destinations.
If the projects are not carefully prepared in all their essential parts
an ineffective investment will almost inevitably occur, a waste, which is
tragic for those countries or companies with scarce capital.
INDEX
2
INTRODUCTION 5
Agricultural Projects 6
General concepts 6
Formulate a project 6
Evaluate a project 7
Types of projects 8
Classification of the projects 8
Origin of the projects 9
Characteristics of the agricultural project 10
Differentiating characteristics of the study levels of a project 13
Component elements of an agricultural project 14
AGRONOMIC DIAGNOSIS 19
MARKET STUDY 29
The demand in the project study 30
Stages of a market study 31
Demand Analysis 31
Demand projection 32
Analysis of the offer 38
Analysis of prices 39
Marketing Study 40
Concepts and generalities of Economic Engineering 42
AGROECONOMIC PLANNING 52
FARM PROJECTION AND PHYSICAL RESOURCES PLAN 54
INVESTMENT PLAN AND SCHEDULE 57
DEBT SERVICE 60
FINANCIAL PROTECTION OR CASH FLOW 63
FINANCIAL EVALUATION 65
Net Present Value (N.P.V) method 65
The Internal Rate of Return (IRR) 67
ECONOMIC EVALUATION 72
Cost-benefit relationship 74
SOURCES AND USES OF FUNDS 75
DEPRECIATION 78
3
STATEMENT OF PROFITS AND LOSSES 80
STATIC PROFITABILITY 82
CALCULATION OF BREAK-EVEN POINT 82
SENSITIVITY ANALYSIS 83
CONCLUSIONS 84
BIBLIOGRAPHY 85
INTRODUCTION
4
Investments in the rural sector have shown an increase in recent times.
years, as a consequence of the credit policies implemented by the
democratic governments, this has resulted in the necessity to create techniques of
development, selection, and monitoring of economic feasibility projects.
Financial, to prevent that the financial resources dedicated to agriculture are
incorrectly inverted. Hence, it is necessary to advance in the
technical perfection, having an organic instrument that rationalizes these
resources that are currently limited due to the economic situation of
country, this implies a collection and organization of the existing material, to
unify valid criteria throughout the country.
Filling this function is the objective of this book. Consequently, it does not intend
be original, although the simple task of sorting, compiling, of material
being scattered always involves effort and meticulous work that has its
value.
As a compilation, contributions from many authors and publications are collected from the
financial entities of the State, the author's experience in the different courses
dictated throughout the country.
This work has been made possible thanks to the support they have received in the
participants of extension courses.
AGRICULTURAL PROJECTS
General concepts
5
The development of projects has a technical-administrative instrument and
of economic-social evaluation, both from the private point of view and from
public point of view. It then represents a logical and rational method that
replace the intuitive or empirical procedure that is generally used in the
investment decisions or others.
Agricultural Project:
economic implications that arise from allocating financial resources for production of
agricultural goods and aims to minimize the risks involved in investing resources
scarce.
Formulate a project
To establish a plan for all future activities that will be carried out
in the production unit in order to optimize the use of the factors of the
production (Land, labor, capital). The formulation can plan the
the most suitable combination of means of production through better
work methods, rational use of inputs, optimal use of machinery
and teams.
Optimize
6
The formulation of an agricultural project is the most important phase because
What is the poorly formulated project or necessarily when it reaches the
evaluation, the analyst will realize that this does not fit the parameters
used and (IRR, Static Profitability, NPV) and has to reformulate the
project.
Evaluate a project
Types of projects
Macro projects are those that encompass an area, a region, a state or the
country as a whole, is developed by a multidisciplinary team of
university professionals. In Venezuela, these are prepared by
7
CORDIPLAN, FUDEPO, CORPOZULIA, CORPOLLANOS, etc., for example the
next macro projects: URIBANTE-CAPARO, ZULIA COAL.
MILK OF THE WESTERN PLAINS, PIAR OF THE QUIBOR VALLEY,
etc.
Farms in foundation
Term: up to 15 years
8
Grace Years: up to 5 years
Coverage: up to 60%
Farms in consolidation:
Term: up to 15 years
Coverage: up to 60%
Financing items
Agricultural projects do not differ at all from the basic concepts described in
The previous paragraphs. They have, however, certain characteristics that
they derive from the complexity of the agricultural sector and its organization.
10
The primary force of production in agriculture is biological.
agriculture works with living beings (plants and animals) on the
which can have serious consequences the changes in the
climatic conditions. Agriculture is also subject to damage from
unforeseen reasons, such as pests, diseases. On the other hand, the
previous conditions determine that agriculture has periods
seasonal production, which has repercussions on the
increase in prices and risks.
11
Agriculture is integrated by other subsectors of crops, livestock, and
forestry, each of which is quite complex.
Agrarian policies that have been formulated must also be considered.
legal and administrative dispersions of the sector as a whole. Everything
previously, it leads to a certain tendency in the agricultural sector to
to form a large number of institutions.
7. Complexity of administration:
The large number of institutions that are created to address the various
subsectors and services of the agricultural sector complicate management
and inter-institutional coordination.
12
also costs, infrastructure services, such as roads, hospitals,
schools, storage warehouses, etc. In general, it seems reasonable
consider these investment items as part of the project, always
that contribute to the achievement of its main objective. It is
it is likely then, that a project has a broader content than
he defined earlier and that can encompass the rural development of an area
on aspects such as: agrarian reform, technical assistance training,
marketing, agriculture, livestock, infrastructure works such as
schools, hospitals, roads, community services, and rural housing.
Depending on the degree of precision and detail, a project includes the following
levels:
Preliminary study:
Simple study of statistical analysis and surface recognition
generalized, which allows providing the elements of judgment for a
reasoned decision on the suitability and unsuitability of assigning
resources to continue with more advanced studies. It emphasizes the
economic aspect.
2. Pre-feasibility study:
It includes broader and more systematic studies, in which are examined the
main and possible alternatives, the location and the size of the economy,
the organization and financing. Due to the lower degree of details that
this study contains, does not allow decision-making about the
investments.
3. Feasibility study:
In fact, we can define it as a preliminary project and it is the stage of
study that covered all aspects in detail, legal,
technological, financial y administrative matters related to the
elaboration, execution, and operation. This study must formulate judgments that are
13
consistent and well-founded on the possibilities of executing and
operate the project and the advantages of allocating the required resources. No
It has the required details to execute or carry out the project.
The process of developing and selecting possible projects must go through the
next steps: definition and justification of the objective; market study,
size and location; technical aspects of the project; calculation of investments,
costos e ingresos
benefits; socio-economic effects of the project (evaluation), execution and
operation.
14
the elements of judgment to continue with more advanced studies in
the following stages.
2. Diagnosis:
This stage consists of:
a) Specify the nature and magnitude of the problems affecting the
activity that is examined, in relation to a normative model that
it can be expressed in terms of defined objectives or criteria
previously, sometimes in a preliminary form.
b) Analyze the resources available to address the problems
studied.
determine the most advisable alternative, which will be the basis for development
of the project.
4. Market study:
Specifically, it allows to establish the amount of goods and services
that the population would be willing to purchase at determined prices, of
the operational unit that generates the project.
15
5.Size
The size of a project is generally defined as the capacity of
production of the same over a certain period, which is considered
normal, depending on the type of project.
6. Location
It is related to the project's location. In general, it is accepted that the
the proper location of a project should be oriented towards them
objectives that are set for the optimal size. This is, towards the
maximum profit attention, if it involves private investments and
toward the minimum unit cost if the social perspective is taken into account.
In the case of agriculture, determining the location requires
various basic studies on: transportation, hydrology, ecology, topography,
soils, sociology, economics, and agronomy, which together
allow, according to the pre-established objectives and criteria,
determine the regions and agricultural sectors where it is most suitable
the location of a given project.
16
Size and location have a close relationship due among others
factors, to the influence that the distribution of goods or services has
that will be produced in the project.
8. Calculation of investments.
It refers to the determination of both partial and total investments.
in national and foreign currency that is required.
It contains both those needed in the installation phase and those
what is required for its operation. It also includes a calendar of
investments.
11.Evaluation:
The evaluation aims to qualify and compare the project with others,
according to a certain scale of values, in order to establish their
order of precedence.
17
In other words, the evaluation determines the priority of a project.
through a comparative analysis of the alternative uses that can
to have the resources that will be invested.
12. Administration:
It consists of preparing a detailed description of the Basque structure of
the project organization, the technical procedures,
administrative, financial, and legal aspects necessary to make it operate.
Include the use of PERT and CPM methods to plan and control the
execution that also refers to the preparation and presentation of
project to the corresponding financial institutions. It covers all the
bureaucratic steps required in the respective country before the
financial organism.
13.Execution:
It refers to the installation of the plant, the construction of the works of
infrastructure, such as roads, irrigation works, etc.
14.Operation:
It relates to the implementation and normal operation of everything
project.
AGRONOMIC DIAGNOSTIC
18
forage aspects, agrological, legal, socio-economic, agro-economic,
etc.
The diagnosis allows for the analysis of the optimal use of resources and also
correct the possible faults, this will allow for the best combinations to be made
crops that best adapt to the soils and that guarantee a
greater productivity. This includes an inventory of the available resources.
classified by their availability and suitability, which informs us about the
main problems affecting the production unit in such a way that
measures can be taken to solve the existing problems.
1. Land inventory:
1.3. Unproductive surface (U.S.): it is the one that is superior to which the
19
1.4. Natural aspects: refer to the climate, soil, topography of the
land of the estate.
20
Erosion.
Natural vegetation: refers to the vegetation that the farm has.
It is necessary to name the type of vegetation, trees, bushes, etc.
1.4.7. Topography: refers to the shape of the land which can be:
plan. They have fertile conditions and climate, it is mechanizing,
They reach great value for seasonal crops, it is necessary
to assess the slope.
Accidented; it is less mechanized and adapts more to crops
permanents and grasses.
markets.
21
1.6. Water aspects; it refers to the availability of water.
farm during the year. It is necessary to consider if the water sources
The farm's soils are either superficial or deep.
1. DIAGNOSIS
22
1.1. Identification of the property and the owner:
The Hato is known as 'HATO LAS TRINCHERAS' whose
the owner is the Agricultural Company 'LAS TRINCHERAS'
whose address is the city of San Cristóbal, State of Táchira.
1.1.1. Boundaries
In light of the property documents, the general boundaries
the referenced lands are as follows.
NORTH: National Road Guasdualito via Elorza.
SUR: Orichuna Creek, Sabanas de San Pedro
ESTE: Eladio Hurtado Fund, Hato Campo Alegre.
WEST: Pedro Dugarte Plain, Los Camoruchos Plain,
Savannah The Revenge.
1.1.2. Tenure:
The land occupied by the herd is owned as it is
it is derived from the documentation submitted.
23
Surface
According to the existing topographic survey, the herd has
an area of eleven thousand two hundred hectares (11,200), of
91% of which are occupied by savannas.
4% is occupied by light vegetation, 5% is
occupied by thorn, roads, and facilities. 95% of the
hectares are entirely designated for livestock farming,
distributed over five (5) estates; three of which have
their respective work facilities, more than four (4)
four (4) pipes.
1.2.5. Topography:
The topography of the ranch is flat at 100% with slopes of
1 percent.
1.2.7. Hydrology
The surface waters are represented first of all
for five (5) estuaries in the dry season, located in:
Two (2) in the water tank pasture
One (1) in the pasture breathed
One (1) in the Santa Inés pasture
One (1) in the Boca Caños pasture
24
Other sources are: the Buria canal, which borders the El pasture.
I breathe, The Deer that borders the Venaito pasture and Lamedero.
Regarding groundwater, the water table level in the area
It is at 50 m in summer
There are eleven (11) wells drilled of different diameters and
depth, that provides water for all the drinkers of
the pastures and potentially for irrigation.
1.2.8. Soils
In the soils of the area, from a physiographic point of view,
the bank, bajío, and estuary units predominate.
In the banks, sandy textures dominate.
low natural fertility and with a pH of 5.00 to 5.20.
In the shallows and estuaries, the texture is variable, with predominance
1.2.9. Climatology
Regarding precipitation in the area, the annual average is
20-year records is 1,705 mm, with a differentiation
stationary of the well-defined periods; the wet period
the winter that goes from May to November and the dry period or
summer that runs from December to April.
The average temperature is 27.55°C, with a maximum of 34.8.
°C, and a minimum of 20.3°C, the average evaporation is
182.6 mm per year.
The altitude above sea level is 128 and 130 meters.
25
The breeding herd consists of Cebu cows and a small lot of
creole animals. The females resulting from these crosses are
delicate to replacement and the males of 200 kg. They are taken to
market.
26
Consequently, the effective grazing area is reduced to 10.10.
Ha. The herd is the exception of the area for having extensions.
considerable banks. However, the shallows and streams are
predominant. In addition to the chemical characteristics of the soil
they are considerable acidic soils with an average pH of 5.1 with levels
with low phosphorus and organic matter and moderate potassium. Plow
achieve an increase in the grazing surface capacity
it is necessary to undertake a weed control program, and in the
infested area, achieve establishing pasture seedbeds for
to eradicate any trace of a resurgence of harmful weeds is
it is essential to deforest the 00 ha of bushes as they are
spines that have little benefit due to their anatomical morphology.
In this way, the current area can be increased.
grazing on 11,710 hectares.
Due to the savanna climatic conditions, summer is usually
severe due to its high temperatures, high wind speed, which
it extends from December to April, so it is essential a
henification program to prevent nutritional stress during
this season and avoid the fluctuations that affect the
exploitation. For the purposes, currently in Venezuela,
specifically in the states of Cojedes, Guárico, Anzoátegui,
Monagas and Barinas, FONAIA has presented good results
with the savanna grass Andropogon gayanus 'CIAT' 621 with
dry matter yields of 24 tons per hectare per year.
It is also resistant to drought, responding to the conditions of
infertile acidic soils are not very demanding in terms of fertilization
nitrogen, phosphorus, and potassium more than any introduced grass
for the ability to tolerate acidity, deepen its system
radicular which allows for the extraction of moisture and nutrients from
the lower strata of the soil. In addition, it is a great producer of
seeds, which makes it easier to reseed for the next period of
growth.
27
Erosion.
Natural vegetation: refers to the vegetation that the farm has.
It is necessary to name the type of vegetation, trees, bushes, etc.
1.4.7. Topography: refers to the shape of the land which can be:
plan. They have fertile conditions and climate, it is mechanizing,
They reach great value for seasonal crops, it is necessary
to assess the slope.
Accidented; it is less mechanized and adapts more to crops
permanents and grasses.
markets.
21
the entrepreneur can cover production costs with a reasonable margin
of use.
The market has been defined as 'the area in which they converge the
forces of demand and supply to establish a single price. To the
purposes of this book that definition must be interpreted in a broad sense
the existence of a group of individuals whose requests highlight
manifested the situation of supply and demand that leads to establishing the price and
From there, the need to specify which group of individuals it will encompass arises.
what the study is about.
29
producer that could absorb the market. If the total existing demand does not
is duly satisfied, the production corresponding to the project is
it will add to the offer of other providers and only the volume will increase
current market transactions, focusing then on the study of
quantify this unmet demand. The possibility that there is a demand
Dissatisfied individuals hate to acknowledge it through two general types of indicators.
It may also happen that the new production does not increase the volume of the.
existing market, but displace other suppliers from that market,
achieving a demand for substitution. Such would be the case, for example, of a
production of goods or services of better quality than those offered in the
market, with which it would be possible to displace the current suppliers could
to deal with a project that, by introducing techniques, would reduce costs and evacuate
similar to other market products at the lowest price; in this case there could be
not only redistribution of the market among suppliers, but also a
possible additional demand, due to those lower prices. If the
displaced suppliers were the importers, it would be a project of
import substitution.
30
here is one of the basic relationships between market study, size, and
the project location.
Demand analysis:
The estimation of current and future demand allows for the formation of some
of the main variables that must be precise through the study of
market.
31
CA = P + M - X
Apparent Consumption
National production
M = Importation
Export
Demand forecast:
32
of income per capita to quantify the demand for the provocation
we are interested. The formula used for its calculation is as follows.
Future demand:
DF = DB (1 + ACT)n
Where from:
Future demand
Δ CT = (CeID x Δ IH) + Δ PO
Where:
Δ PO = Increase in population
Problem:
Calculate the demand for paprika for the year 2000 considering that the
current demand (year 1992) is 60.70 metric tons, and that the population
will evolve at 3.8% as an average annual rate and that the income of the
consumers (per capita) will grow at an average annual rate of 3.5%.
The income elasticity coefficient of demand for paprika is 0.39.
33
Solution:
Data:
CeID= 0.39
DA = 60.70 Tm
Δ PO = 3.8%
Δ IH = 3.5%
DF =?
Δ CT = 0.0517
135.97 Tm
DF = Future demand
Current demand
n = Number of years (difference between the base year and projected year)
34
i = Demand growth rate
i= √ - 1,where:
i= Growth rate
Greater amount
Cm = lesser amount
n = Number of samples
Problem
Calculate the banana demand for the year 2000 knowing the demand of the
following years:
4 458,984 4
i= √ - 1 =√ 105- 1 = (1.05)1/4-1
439,064
35
Trend analysis using the Least Squares method:
This method is used when the amounts from one year to another may decrease.
to increase, that is, a sustained growth or decrease is not observed,
thus we have the following example:
in such a way that to be able to calculate any future amount we have to use
the following formula:
( )− Ῡ
Y -Ῡ=( ( −
) X–X
( − )2
Y = Tm
For the calculation of the Least Squares line, we substitute the previous formula with
their respective values and we have the following:
434.10
− 95= ( ) ( −5 )
110.00
36
= 3.95 - 19.73+ 95
= 3.95 = 75.27
To calculate the corresponding amount for the year 1994, which corresponds to
to a X=14, substituting X=14 in the equation we have:
( )75.27
= 3.9514+
= 55.30+ 75.27
130.57 T
For the demand year 1994, the demand for the product will be 130.57 tons.
Current and future market: list the states, regions or areas where it is located.
arriving the product, as well as the potential markets.
Regional demand for the product: calculate the quantity of the product that
consume the state where the project will be located.
The quantification of the supply, the spatial distribution of the suppliers and the
seasonality of production are the fundamental elements of
analysis of the offer.
Current offer:
Supply projection:
Analysis of prices:
38
It is important to know if the product of the project is subject to
minimum prices or if there are agro-industrial agreements that set the price with
anticipation.
The study of prices can be divided into three parts: analysis of the evolution
historical price data, analysis of the main factors that determine
prices and their projection for the project's lifespan.
Marketing study:
The study must define what functions need to be fulfilled and how and why they will be.
carried out. The first step will be to analyze the process of
39
marketing from the perspective of its physical functions, these are
necessary for the product to be available to the consumer on time
desired place and form
DIAGRAM NO. 1
WHOLESELLER
INDUSTRY
SUPERMARKET
40
SOURCE: Own design. Guanare 1992
DIAGRAM No. 2
WHOLESALE
SUPERMARKET
TABLE N°1
41
Retailer 15 13 2 15
The following explains the general concepts that should be understood about
Economic Engineering.
Value of money over time. It can be said that he who has money, it
search for the money. This is true in a democratic capitalist system. If a
A person who invests their money logically has the option to accumulate more money.
example: Mr. Juan Mancilla decides to deposit in the Bank of Venezuela Bs.
50000.00 on the day 02-09-91, one year later 02-09-92 decides to withdraw his money and the
Bank informs you that as of that date you have Bs. 66,000.00, that is, Bs. 1,600,000
but this accumulation of money over time is called interest, which is the
interest amount of money for having deposited it in the bank for a year.
it can also be defined as the difference between the final capital and the
initial capital (F-P=I), in the previous example we have Bs. 66000.00 - Bs.
50000.00 = Bs. 16000.00 what is the interest that Mr. Mancilla earned for depositing
or lend your money to the banking institution.
42
When interest is expressed as a percentage of the original amount
(initial capital) per unit of time, the result is called Interest Rate.
é
Interest rate = x 100 = x 100
.16,000.00
i= x 100 = 0.32 = 32%
Bs 50,000.00
16.000
I = Bs. 16,000 if we solve for p = = Bs. 50,000
0.32
a) Interest earned
b) Interest rate
c) Final capital (F)
Initial Capital (P)
I= Bs. 34,000.00
Bs.34,000.00
Interest Rate = 0.34 x 100 = 34%
.10.00
Simple Interest:
Interest is the payment received for the capital interest, that is, it is
the fruit generated by the invested capital. Capital is understood as value
Monetary value of the amount of goods invested in financial operations.
43
Simple interest is discussed when the capital invested or deposited in a
Financial Institution, earns interest for a certain period, but the
Interest does not continue to generate interest if the money remains deposited.
Problem: Calculate the simple interest of Bs. 60,000.00 at 33% per year for 10 years.
months.
Solution:
P= Bs. 60,000.0
n = 10 months
I = Bs. 16,500.00
F = P (1 + 1)n
Final Capital
Interest Rate
n = Time
Let’s assume that Mr. Juan Mancilla decides to deposit today (P) capital in the
Union Bank, this capital according to the time value theory must earn.
an interest, meaning it will be deposited at an interest rate i then the
interest on (P) in the first year will be P x i and the total amount of money at the end of the
The first year will be equal to the original amount (P) plus the earned interest (P x i)
44
that is: P + P x i, taking out common factor (P) it remains P (1 + i). If Mr.
Mancilla decides to leave the money in the bank for another year, the interest earned
it will be F (1 + i) x i and the total amount at the end of the second year will be P (1 + i) + P (1
Problem: The El Alacrán farm deposits into a savings account at the Bank of
Venezuela Bs. 6000.00 pays the bank an annual interest rate of 36%-
The estate wants to know how much money it will have in 6 years.
Solution:
P= Bs. 600,000.00
i = 36% = 0.36
n= 6 years
F=?
1
F=F With this formula, you can calculate how much money there is.
(1 + )
45
of Financial Mathematics as (P/F, i, n) which means to find the value of (P)
known the values of i and n.
Problem: Calculate the present value of Bs. 3,796,511.33 that will be earned
through the El Alacrán estate in 6 years, at the Bank of Venezuela that grants
a 36% annual interest rate.
Solution:
F= Bs. 3,796,511.33
36% = 0.36
n= 6 years
P=?
1 1
P=F 3,796,511.33 Bs. 6 3,796,511.33 (0.1580)
(1 + ) (1 +0.36
P= 60,000.00 Bs.
Annuities: They are equal payments at equal intervals of time for their calculation.
the following formula is used:
1
A= F(
1 + -) 1
Where A = Annuity
Future Value
n = Number of years
i= Interest rate
I = A constant
1
The expression is known as the compound amortization factor
( 1 + -) 1
multiple and appears in the Financial Mathematics tables with A/F, i, n that
it means calculate the value of 'A' knowing (F) knowing i and n. this formula
46
It allows to calculate the following: what is the amount A, that deposited for 'n!!
Adding an interest rate "i" gives a future value "F".
Problems: how much money does the estate 'PaloQuemado' have to deposit.
every year at Banco Unión, in order to save within 7 years
1,500,000.00 bolívares, if the bank offers an annual passive interest rate of 36%
Solution:
A=?
F= 1,500,000.00 Bs.
i = 36% = 0.36
n = 7 years
A = 71,001.94
If you want to calculate what the annual amount "A" that can be taken from a
Deposit present 'p' during 'n' years at a compound interest rate can be
calculate from the previous formula substituting the value of 'F', for example A = F
1
the value of F = P (1–i) is replaced, we have A = P (1 + i) nwe have
( 1 + -1
)
1
A = P (1 + i)( the expression (1 + i) is introduced inside the bracket and it remains
1 + -) 1
(1+ )
A=P is known as Capital Recovery factor and appears
( 1 + -) 1
In the tables of Financial Mathematics like A/P, i, n, what does calculate the mean?
Value of 'A', knowing P, i, n. It is called capital recovery factor.
because with him you can know the following: how much money he has to
cancel the customer every year so that the financial institution can
recover the capital lent at an interest rate "i" in "n" time.
Problem: the farm 'El Alacrán' acquired an International tractor for Bs. 1,200.00,
00 in ACO and CIA. The terms of the contract are as follows: 20% down payment.
30 installments payable monthly at an annual interest rate of 43%.
Solution:
47
A=?
n = 30 months
(1+ )
A= P( = 960.00 Bs. 0.549 = 52,720.95 Bs.
1 + -) 1
A= 52,720.95 Bs monthly
From the formula A=F( the following formula can be obtained by isolating a
1 + -) 1
(1 + ) -1 (1 + ) -1
F=A the expression is known as the capitalization factor
multiple compound and appears in the tables as F/A, i, n, which is read, calculate the
value 'F', knowing A, i, n.
Problem: How much money does a person save if they deposit Bs.
3,000.00 every month for 5 years at Banco Unión that pays a rate
interest of 36% per year.
Solution:
F=?
A= 3.00, 00 Bs.
i = 36% 12 = 3
n = 5 years x 12 = 60 months
( 1 +i ) n - 1
F= = 3.000 Bs. 163.05 = 489,160.31 Bs.
i
489,160.31 Bs.
(
i1+i )n
From the formula A = P n
the following formula can be obtained by isolating
( 1 +I- 1)
a "P"
( 1 +I ) n - 1 ( 1 +i ) n - 1
F=A , the expression is known as the updating factor
i ( 1 +i ) i ( 1 +I ) n
48
Problem:
What amount of money does one have to deposit today in Banco Mercantil, a
a professor who goes to study in Caractes and has to self-finance their
studies. He will remain for two years, and must withdraw monthly from the account
Bs. 8,000.00
Solution:
P=?
A= 8,000.00 Bs
i= 32% 12 = 2.67%
n = 2 years = 48 months
( 1 +i ) - 1
P=A 8.000 Bs.
i ( 1 +I ) n
P= 215,041.56 Bs.
The following are some problems that will help to better understand the
theoretical elements explained.
monthly?
Data:
49
In the table, it is found that for i = 1% and n = 24 months.
The factor is equal to A: 0.04707 therefore the monthly payment will be A=?
Data:
F= Bs. 20,000.00
i = 10% annual = 2.50% quarterly
n = 6 years x 4 quarters = 24 quarters
A=?
P = F (A/F, 250% 24) = 20,000 x 0.03091 = Bs. 618.26
How much will a person save if they deposit Bs. 1,000 annually?
for 10 years at an 8% annual interest rate, compounded annually?
Data:
A= Bs. 1,000.00
i= 8%
n = 10 years
F =?
P = A (F/A, i.n) = 1.000 x 14,486 = 14,486 Bs.
Problem No. 4: How much should he deposit this year in the Bank of Venezuela?
family father so that his son can withdraw Bs. 2,500.00 every month
during 5 years of residence in Mérida. The bank gives interest of 7% per year (not
there is money left in the Bank at the end of the fifth year)
Data:
A= Bs. 2,500.00
i = 0.58%
n = 60 months
P=?
P= A x (P/A 0.58, 60) = 2,500 x 50.55 = 126,375.39 Bs.
50
Bs. 126,375.39
AGROECONOMIC PLANNING
51
In agro-economic planning, an estimation is made of the
required work (land preparation, cultural practices, planting, harvesting,
etc.).
TABLE NO. 2
SHE KILLED
AGROECONOMIC PLANNING
YEARS
WORKS
1 2 3
52
1. Land preparation:
- A plow pass for Bs. 1,000 1,000.00
- Two harrow passes at Bs. 750 each 1,500.00
- Pre-emergent herbicides (Prowl) 4 liters
for ha. Bs. 360 each 1,440.00
- Application with sprayer coupled to the
tractor. 500.00
2. Sowing:
- 40,000 plants per ha. At Bs. 1.00 each 40.000,00
- Transport Bs. 0.25 each 10,000.00
- 80 days at Bs. 150 per day (one man)
sows 500 offspring per day 12,000.00
- Resowing of 500 plants at Bs. 1.25 plus 1
newspaper at Bs. 150.00 775.00
- Fertilizer: 200 kg at Bs. 4.05 each.
- Application. 1,008.00 1,008.00 1,008.00
260.00 260.00 260.00
3. Weed control:
- Clean by hand and I propose 8 days of work at Bs.
200.00
1,600.00
4. Harvest:
- 180 day laborers at Bs. 150.00 each.
This table indicates to the project what the expected production is during its
useful life, the expected and projected selling prices and how also the
total costs, the area to be planted and the yields per hectare.
53
This table serves as a basis for preparing the cash flow, uses, sources of
funds and the income statement.
This chart determines the benefits that are expected to be obtained from
54
TABLE NO. 3
FARM PROJECTION
Render.
No. Of Price
No. Of yield/plant Yield. / ha. Of Value of the
YEARS CULTIVATION plants/ international
ha. milliliters/plant Liters/ha. paste/h production Bs.
ha. l. Bs./Kg.
a. Kg.x
55
TABLE No.4
PLAN OF THE FLOW OF PHYSICAL RESOURCES
(100 ha.)
LINES UNITS YEARS
1 2 3X 4 5 5-10
PLOW PASSES 100
NATION PASSES 200
HERBICIDE LITERS 400
PLANTS 4,000,000 UNITS
CARRIAGE 4,000,000 UNITS
SOWING JOURNALS 8,000
RESEEDING UNITS 5,000
FERTILIZER Kg 20,000
CLEAN BY HAND JOURNALS 800 800 800 800 800
HARVEST JOURNALS 18,000 18,000 18,000 18,000 18,000
PRODUCT LITERS 240,000 240,000 240,000 240,000
(ACIBAR)
Years of consolidation
56
INVESTMENT PLAN AND SCHEDULE
Based on these items, the investment plan and schedule are developed. These
tables show financial institutions the exact amounts of
money that the project needs to execute it.
57
TABLE No. 5
INVESTMENT PLAN
58
TABLE No. 6
INVESTMENT SCHEDULE
59
DEBT SERVICE
its modalities.
- Term 20 years
- 5 years of grace.
- 5 years of deferred interest.
- 3.90% annual interest.
For Consolidation:
- Term: 15 years.
- 4 years of grace.
- 4 years of deferred interest
- 31.90% annual interest.
- Term: 15 years
- 5 years of grace.
- 5 years of deferred interest.
- 31.90% annual interest.
Consolidation:
60
- Term: 15 years.
- 3 years of grace.
- Without deferred interest
- 31.90% annual interest.
For zábila, which is the crop we are going to evaluate, the conditions are
following:
- Term: 15 years
- 2 years of grace.
- 2 years of deferred interest.
- 16% annual interest.
The Debt Service table is prepared based on the amount required in the
Investment plan and schedule, along with the characteristics or conditions established
by the Financial Institution.
61
TABLE No. 7
DEBT SERVICE
0 - - - - 10,820,348.00 10,820,348.00
1 1,731,255.68 - - - 11,880,348.00 1,060,000.00
2 1,900,855.68 - - - 11,880,348.00
3 1,900,855.68 834,288.64 454,013.92 3,189,158.24 11,046,059.36
4 1,767,369.50 967,774.82 454,013.92 3,189,158.24 10,078,284.54
5 1,612,525.23 1,122,618.79 454,013.92 3,189,158.24 8,955,665.75
6 1,432,906.52 1,302,237.80 454,013.92 3,189,158.24 7,653,427.95
7 1,224,548.47 1,510,595.85 454,013.92 3,189,158.24 6,142,832.10
8 982,853.14 1,752,291.18 454,013.92 3,189,158.24 4,390,540.92
9 702.486,55 2,032,657.77 454,013.92 3,189,158.24 2,357,883.15
10 377,261.30 2.357.883,15 454,013.92 3,189,158.24 0
CONDITIONS:
INTEREST RATE: 16% annual
DEADLINE: Ten (10) years
YEARS OF GRACE: Two (2)
DEFERRED INTEREST: Two (2)
62
FINANCIAL PROJECTION OR CASH FLOW
This table is prepared with the data of: total income and monetary expenses
totals, whose difference shows the years when the project has liquidity or
liquidity of money; if it has liquidity, it indicates that dividends can be distributed,
but if it has illiquidity, it indicates that it needs to seek its own resources to avoid
that the project does not have the ability to pay in the years in which it has to
cancel interest and loan amortization. This results in being rejected
by the Bank due to lack of payment capacity. With the net balances of this
In the table, the internal rate of return is calculated.
63
TABLE No. 8
FINANCIAL PROJECTION OR CASH FLOW
(NOT ACCUMULATED)
YEARS
DESCRIPTION
1 2 3 4 5 6 7 8 9 10
ENTRIES
Sale of aloe vera paste 12,288,000 18,432,000 18,432,000 18,432,000 18,432,000 18,432,000 18,432,000 18,432,000 18,432,000
F. C. A Loan 10,820,348 - - - - - - - -
10,820,348 13,348,000 18,432,000
EXITS
Investment loan
F. C. A. 10.820.348 1.060.000 - - - - - - - -
Production costs - - 6,736,900 6,736,900 6,736,900 6.736.900 6,736,900 6,736,900 6.736.900 6,736,900
Ordinary interests - - 1,900,855 1,612,525 1,612,525 1,432,906 1,224,548 1,224,548 982.853 377.261
Deferred interests - - 454.013 454.013 454.013 454.013 454.013 454.013 454.013 454.013
Loan amortization - - 834.288 1,122,618 1,122,618 1,302,237 1,302,237 1,510,595 1,752,291 2,357,883
9,926,056
TOTAL OUTPUTS (II) 10,820,348 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056
NET FLOW (I-II) 0 12.288.000 8,505,944 8,505,944 8,505,944 8,505,944 8,505,944 8,505,944 8,505,944 8,505,944
64
FINANCIAL EVALUATION
Once the net flows have been obtained in the financial projection;
the existing criteria for evaluating projects are applied, the most commonly used are:
The Net Present Value of a project is defined as the value obtained from the
difference between cash inflows and cash outflows updated
separately for each of the years at a predetermined interest rate,
during the project's useful life, minus the investment.
The interest rate used is the one that prevails in the capital markets,
currently in Venezuela, the rate is between 30 and 37% annually.
interest is also referred to as Cost of Capital.
This difference is updated from year one (1) until the end of its useful life.
from the project. The N.P.V. obtained for each of the years of life of
projects are added to obtain the value of the project. It is the total net present value,
the result is positive, the project must be accepted, if it is negative it must
to reject oneself. Mathematically, we express it this way:
1 2 3 4
V. A. N. =( + + + + )
(1+ ) 1 (1+ )2 (1+ )3 (1+ )
Here Bn2Bn3they represent the net cash flows, that is, the differences
between cash inflows and cash outflows:
It is the predetermined interest rate (Cost of capital)
C: is the cost of the project, that is, the investment
n: is the number of years of the project's lifespan.
65
If the N. P. V. is positive, the return on investment is greater than the rate of
predetermined interest, if the N.P.V. is equal to zero, the project's profitability
is equal to the predetermined interest rate. Therefore, a project with
N.P.V. zero can be considered acceptable. If the N.P.V. is negative the
profitability is below the predetermined interest rate or cost of
capital and the project must be discarded.
If you have to choose between two projects, you should opt for the project with the V.
A. N. mayor.
The project has a N.P.V of Bs. 5726.765, which indicates that it is positive and the
the company increases its value by this amount also indicates that at a rate of
36% interest, the project is feasible because it is above the cost of
capital, that is to say, the maximum interest rate that this capital would earn in a
financial entity currently. If the N.P.V had turned out negative the
66
TABLE N° 9
(V. A. N)
FLOWS RATE OF
INVESTMENT V. A. N.
YEARS NIECES UPDATE
Bs Bs
Bs N AL 36%
0 - - 10,820,348.00
1 - 0.7353 ( 779,441.00
2 12,288.00 0.5407 6,643,598.00
3 8,505,944.00 0.3975 3,381,471.00
4 8,505,944.00 0.2923 2,486,376.00
10,820,348.00
5 8,505,944.00 0.2149 1,828,217.00
1,060,000.00
6 8,505,944.00 0.1580 1,344,277.00
7 8,505,944.00 0.1162 988,439.00
8 8,505,944.00 0.0854 726,793.00
9 8,505,944.00 0.0628 534,407.00
10 8,505,944.00 0.0462 392,946.00
VAN + 6,726,765.00
Another way to use the updated cash flow to measure the value of a
The project is to determine the Internal Rate of Return, which is defined as the rate
of interest that equates the Net Present Value of the Project with the investment. Also
is defined as the interest rate or discount rate that makes the Net Value
Net income equals zero.
67
The Internal Rate of Return is a very useful measure of the value of projects.
It is the one that the World Bank uses for all its economic financial analyses.
Venezuelans. The equation to calculate the Internal Rate of Return is:
n
Bn
∑ − C =0
(1 +i)n
1
In this equation, it is specified that the NPV is equal to zero and the value is found.
of what makes the NPV equal to zero.
68
TABLE N° 10
INTERNAL RATE OF RETURN
T.I.R.
RATE OF RATE OF
NET FLOWS INVESTMENT V.A.N V.A.N
YEARS UPDATE UPDATE
Bs. Bs. at 53% at 55% Bs.
Bs.
0 -- ---- (10,820,348) ----- (10,820,348)
1 -- 0.6536 ( 692.810 0.6452 ( 683.870
2 12,288,000 0.4272 5,249,263 0.4162 5,114,672
3 8,505,944 0.2792 2,374,915 0.2685 2,284,164
4 8,505,944 0.1825 1,552,232 0.1732 473.654
10,870,348.00
5 8,505,944 0.1193 1,014,531 0.1118 950.744
1,060,000.00
6 8,505,944 0.0780 663.092 0.0721 613.383
7 8,505,944 0.0510 433.393 0.0465 395.731
8 8,505,944 0.0333 283.263 0.0300 255.310
9 8,505,944 0.0218 185.139 0.0194 164.716
10 8,505,944 0.0142 121.006 0.0125 106.268
363.676 (145.576)
69
Second, an interest rate is arbitrarily chosen, in real life
It is not possible, except by chance, to directly choose the upgrade house.
that makes the net flows minus the investment equal to zero, unfortunately there isn't
there is no formula to determine the Internal Rate of Return and it is necessary to resort
to trial and error methods.
VP (I 2- 1I )
T.I.R. = I1+
VP+VN
Where:
VP = Positive VAN
Bn = Negative VAN
54.43%
NOTE: to use this formula, it is necessary that the sum of the positive N.P.V.s
and negatives be in absolute value, that is to say without taking into account the negative sign
from V.A.N.
This rate of 54.43% in a certain sense represents the average profitability of the
investment made in the project throughout its life and at this rate the project
70
it reaches its break-even point, that is, it is obtained from all capital costs
and an operation of 54.43% due to the use of money over its 15 years,
that is to say that the Internal Rate of Return is the profitability of the project and that by
for every 100 bolívares invested, the project earns Bs. 54.43 throughout its lifetime
project.
71
ECONOMIC EVALUATION
Benefit-Cost Ratio:
This coefficient can be defined as the quotient between the updated value of
benefit flow and the present value of the cost flow, mathematically it is
express it this way:
n Bn
B ∑1(1 +i) BI amfIiosactualijados
= =
C Costosactualiwanteds
N
C
∑
(1 +i)n
1
For the calculation of the benefit-cost ratio, both revenues are updated.
as the expenses and you have to decide beforehand the discount rate that is
it will use. In general, there are two refresh rates to choose from
and a third one that is sometimes proposed, the most used is that of cost of
opportunity cost of capital, that is, the maximum rate that capital would earn in a
financial institution. In Venezuela, that rate is currently comprised of
between 30 and 37% annually.
When the benefit-cost ratio is less than one (1), from the point of view
the project is justified economically (although there are other non-economic factors)
that they justify them).
72
If the ratio is equal to one (1). The project could be considered marginal.
from an economic point of view, that is, the project does not generate profits but
of losses.
If the ratio is greater than one (1), the project is justified from the point of view
economic, because it generates profits.
We observe that the benefit-cost ratio is greater than one (1) at the rate
36% passive, which indicates that the project is feasible from the standpoint of
economic, because the profitability is above the maximum passive rate of
the banks and recovers 1.82 bolivars for each bolivar spent, that is
it earns a profit of 0.82 bolivars for every bolivar invested and 82 bolivars
for every one hundred (100) bolívares invested.
73
TABLE N° 11
COST-BENEFIT RELATIONSHIP
74
SOURCES AND USES OF FUNDS
This statement of origin and application of funds indicates where it comes from
money that entered the project, and how it was used in detail,
resulting in the available cash for each year. This instrument
it allows determining the financial capacity of the project and verifies if it is capable
to generate the required funds to carry out the necessary investment.
The purpose of this statement is to inform, in detail, what has been done.
It will be done with the cash provided by financial institutions. It
own income from the project and that of the producer. This is integrated solely and
exclusively for cash inflows and outflows, that is, it does not
includes depreciation expenses as they are non-monetary expenses.
As this reflects both the origin and the use that will be given to the funds in
relationship with the project, is manifested in this way at what moment of
additional contributions may be required at times or, on the contrary, when they may
Withdraw funds as dividends from the project. It is necessary to accumulate the balances.
from each year because this allows for analyzing the financial feasibility of the project,
since a positive balance for all years indicates that the sources of funds
projected are sufficient to cover the intended uses.
The procedure indicated for the preparation of the table is to calculate all the
income or sources and all expenses or uses.
Income:
The term income refers to cash inflows (Cash flow) that, therefore
constitute sources of funds for the project. Among the concepts generally
included as income or sources, the following can be mentioned:
75
Expenses:
Loan investments.
2. Direct operating expenses.
3. Loan interests.
4. Amortization of the loan.
It is observed that the less used sources are positive, this allows the project
cancel the interest and the repayment of the loan and be able to distribute dividends
to make new investments.
76
TABLE No. 12
SOURCES AND USES OF FUNDS
YEARS
DESCRIPTION
1 2 3 4 5 6 7 8 9 10
ENTRANCES
Sale of aloe vera gel 12.288.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000
Loan F. C. A 10,820,348 - - - - - - - -
Balance Previous Year - - 12,280.00 21.093.942 29.599.884 38.105.826 46.611.768 55.117.710 63.623.652 72.129.594
TOTAL USES 10.820.348 13.348.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000
USES
Loan investment F.C.A. 10,820,348 1,060,000 - - - - - - - -
Production costs - - 6.736.9000 6.736.900 6,736,900 6,736,900 6,736,900 6,736,900 6,736,900 6,736,900
Debt service - - 3,189,158 3,189,158 3,189,158 3.189.158 3,189,158 3,189,158 3,189,158 3,189,158
TOTAL SOURCES 10,820,348 1,060,000 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056 9,926,056
NET FLOW (I-II) 0 12.288.000 21.093.942 29.599.884 38.105.826 46.611.768 55.117.710 63.623.652 72.129.594 80.635.536
77
DEPRECIATION
It is the loss of the value of assets due to their use, obsolescence, or by action.
of time. This is accounted for as a non-monetary expense, that is to say the project
does not disburse money to cancel or pay it, but rather considers it as an asset
X bolívares lose value over time and this is a loss of value.
it is what is called depreciation.
Types of depreciation:
straight line
-Number digits
The method used in projects is the straight line method, which consists of
use the following table.
78
TABLE No. 13
COST-BENEFIT RELATIONSHIP
VALUE QUOTA
VALUE LIFE
DEPRECIATION OF ASSETS Residual Depreciation
Initial Bs. USEFUL
The Bs. ANNUAL Bs
Bs 85,457.00
−
*D= ANNUAL DEPRECIATION ALLOWANCE
VR
79
STATEMENT OF INCOME AND EXPENSES
Its aim is to show the utilized (or lost) obtained, and detail the way
how it happened.
Just like the 'Balance sheet' and any accounting report, the 'Statement of
Profits and Losses" should be defined with a heading containing:
a) Name of the farm
b) Name of the state or Report
c) Dates of the Period covered
Classification of the Statement of Earnings and Losses
Main Revenues:
They are constituted by the sales of the estate and represented by the
nominal accounts that record the compensations received by the property,
for the agricultural or livestock products produced within it or by the
sale of services provided to other estates, excluding those incomes
eventual gains from the sale of discarded assets.
2. Production costs
They are made up of the cost of agricultural products sold by the
farm. They are divided into:
a) Variable costs
b) Fixed costs
3. Operating costs
They consist of sales expenses and also administrative expenses.
4. Other expenses and other income:
Other expenses:
They are made up of all those occasional expenses different from the
normal expenses of the farm
Other income
They are formed by income from interest, sales of assets.
discarded, etc.
80
TABLE No. 14
STATEMENT OF PROFITS AND LOSSES
YEARS
DESCRIPTION
1 2 3 4 5 6 7 8 9 10
INCOME
Sale of aloe vera gel - 12.288.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18,432,000 18,432,000 18,432,000
TOTAL INCOME - 12.288.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18.432.000 18,432,000 18,432,000
EXPENSES
Production costs - - 6,736,9000 6,736,900 6,736,900 6.736.900 6,736,900 6,736,900 6.736.900 6,736,900
Ordinary interests 1,900,855 1,767,369 1,612,525 1,432,906 1,224,548 982.853 702.486 377.261
Deferred interests - - 454.013 454.013 454.013 454.013 454.013 454.013 454.013 454.013
Depreciation Charge - 85.457 85.457 85.457 85.457 85.457 85.457 85.457 85.457 85.457
TOTAL EXPENSES - 85.457 9,177,225 9,043,739 8,888,895 8,709,276 8,500,918 8,259,226 7,978,856 7,653,631
NET FLOW (I-II) - 12.202.543 9,254,775 9,388,261 9,543,105 9,722,724 9,931,082 10.172.774 10,453,144 10,788,369
81
STATIC PROFITABILITY
It is the relationship between the net profits of a year and the capital employed to
get them
This profitability represents the profit obtained in a year for every hundred.
(100 bolívares) of the invested capital.
Net profit
------------------------------------------------------- * 100
EQUITY + loan
8.709276
RE2= -------------------------------------------------------- = 51.59%
16,880,348
The break-even point is the control mechanism that indicates at what volume the
revenues exactly cover expenses. At any lower volume, the unit
Production will incur a loss and a greater volume would have a profit, for
its calculation is necessary to prepare a classified chart of fixed expenses and expenditures
variables (table No. 15) and use the following formulas:
CF 8632.104 Bs 8,632,104
a) PE (Bs.) = ------------- = -------------------- = ------------------
CV 63,742,057 0.60
1 - ------------- 1 - --------------------
Income 159,744,000
PE (Bs) 14,386,840 Bs 9.01
b) PE (%) = ------------------------ = --------------------- = ----------
Income 159,744,000
c) Safety margin:
Income–pf 159,744.00–14,386,840
MS= --------------------- = -------------------------------------- = 90.99 %
Income 159,744,000
82
The break-even point indicates the level of intensity in the operations of the
production unit, in which neither losses nor gains are recorded. The
the previous example indicates that the project must have minimum income
annual of Bs 14,386,840.00 to not be able to even gain, that is, it has a margin
of security of 9.05% to neither lose nor gain, that is, it has a margin of
90.99% security is considered good.
VARIABLE COSTS
ITEMS FIXED COSTS Bs
Bs
Production costs 53,895,200.00
Ordinary interests 9,846,857.00
Deferred interests 8,632,104.00
Total 8,632,104.00 63,742,057.00
SENSITIVITY ANALYSIS
It is said that a project is sensitive when, for example, the prices are varied.
The inputs produce a significant variation in the rate.
internal rate of return or in the cost-benefit relationship. The sensitivity analysis
it allows determining the variation limits of some factor of the project with
regarding some of the chosen evaluation criteria.
83
CONCLUSIONS
FORMULATION:
1. INTRODUCTION
2. INFORMATION ABOUT THE APPLICANT
3. DIAGNOSIS ON THE PRODUCTION UNIT
4. VALUATION
5. MARKET STUDY
6. MARKETING STUDY
7. AGROECONOMIC PLANNING
8. FARM PROJECTION
9. PHYSICAL RESOURCES PLAN
10. INVESTMENT PLAN
11. INVESTMENT SCHEDULE
12.DEBT SERVICE
EVALUATION
84
BIBLIOGRAPHY
MIRAGEM, Samuel, NADAL, Francisco and others. Guide for the preparation of
Economic Development Projects. Mexico, 1958
85
PLASSE, Dieter, SALMON, Rafael. Cattle Ranching in Venezuela. Caracas.
1958
86