RISKS AND ECONOMIC ANALYSIS OF ORANGE
CULTURE: CASE STUDY OF A PRODUCER FROM THE INTERIOR OF SÃO PAULO STATE, BRAZIL
Fernando Rodrigues de Amorim
Universidade Estadual de Campinas, Brazil
E-mail: fernando.amorim@feagri.unicamp.br
José Claudenir Nanetti
Junior
Faculdade de Tecnologia
de Taquaritinga,
Brazil
E-mail: juninhounespcta@hotmail.com
Pedro Henrique Camargo
de Abreu
Faculdade de Tecnologia
de Taquaritinga,
Brazil
E-mail: pedro.abreu7@fatec.sp.gov.br
Submission: 09/12/2017
Accept: 06/03/2018
ABSTRACT
The Brazilian citriculture is one of the activities that
generate the most income within the agribusiness, being responsible for
providing opportunities for thousands of direct and indirect workers, besides
being a sector that moves a great amount of financial resources. The orange
crop has been going through great price swings in the recent years, and with
this, many farmers are failing to invest in potential, as a result of the risks
involved in the activity. A large part of these risks is related to the buyer
market, which is controlled by the large juice industries and by the high
capital required for the implementation of the new orchards. The objective of
this work is to identify the risk factors for attractiveness and to analyze the
economic viability of the orange crop in a farm in the municipality of Bauru,
in the state of São Paulo. For this, the Monte Carlo method be used to simulate
the probabilities of success in the scenarios analyzed and the NPV, IRR and
Payback to determine the feasibility of the project. The research is
characterized as a case study. The results obtained showed that the investment
is feasible, only in the real and optimistic scenario and will provide a return
between the 6th and the 7th year of the project, providing a balance of
approximately R$ 4,190,252.94 after 10 years of investment which represents an
attractive compared to the initial investment value of R$ 937,500.00.
Keywords: Risk analysis; profitability; citriculture; Monte Carlo method;
simulation
1. INTRODUCTION
Among the fruit grown in Brazil, orange
occupies the largest area planted (415,232 hectares) and exerts great
importance in the trade balance (FUNDECITRUS, 2017). In Brazil, the fruit was
introduced early in the colonization, finding in the country better conditions
for its development than in its own place of origin and thus expanding
throughout the territory (NEVES et al., 2010).
Oranges can have three basic
destinations: processing industry, domestic market and external market. In the
states of Bahia and Sergipe, 77% of production is absorbed by the fresh fruit
market. In the Brazilian citrus belt (including the state of São Paulo,
Triângulo Mineiro and northwest of Paraná), 86% of the production is destined
for the processing industry (NEVES et al., 2014). According to the latest
estimate by FUNDECITRUS (2017), the citrus belt has 191,694,410 plants. The
2017/18 orange crop of Brazil's main citrus park - which includes 349
municipalities in São Paulo and Minas Gerais - is expected to be 364.47 million
boxes of 40.8 kg. Production is 14% higher than the historical average of the
last ten years.
The 2016/17 crop, considered one of the
smallest in history, closed with a production of 245.31 million boxes of 40.8
kg. With this reduction in production, the price paid for the fruit reached
high levels during the harvest, where the industry paid on average, R$ 21.24
per box (CEPEA, 2017).
According to Kalaki (2014), despite the
Brazilian superiority in the production of orange juice, the country is highly
dependent on the foreign market, and this dependence has become the chain's
major concern in recent years, ranging from producers to industry. Of the total
drinks consumed in the world in 2010, the orange flavor represented only 0.91%,
but among fruit drinks, orange juice is the most taken, with a 37% share of
juices in 2012.
As observed by Silva (2016), the greater
the surplus of orange in the market, the verticalization of the industry, and
the concentrated juice store, the greater the purchasing power of the orange
processing industry. Because it is an oligopsony market, the producer usually
has no control over the price paid for the fruit, so it is up to him to manage
production costs so that the business is viable over time.
For Adami (2010), Brazilian citriculture
is seen as a profitable activity in the long term, but characterized by the
high level of risk. In addition to the common risks as a market for inputs and
products and climatic risks, citriculture is influenced by factors such as
soil, age, pests, diseases and cultural management. All of these factors affect
the profitability of citrus, as they impact on the costs of production,
reducing the income expected by the producer.
The dynamics of these variations make
the planning of property extremely complex, where the producer must monitor his
production costs, manage the activities of the property and at the same time
follow the changes of the buyer market. But often the producer cannot quantify
his production costs as well as the profit or loss obtained during the harvest.
The Brazilian citrus agroindustrial
system is a consolidated and important system for the economic and social
development of the country. There is a clear perception that the sector is
devoid of definitive organization, a plan and a policy elaborated by all links
and for all links (KALAKI; NEVES, 2017). According to Silva and Marques (2015)
the agricultural producer, in this case the citrus grower, is faced with
uncertainty both in terms of quantity produced, productivity fluctuations per
hectare and prices received for the sale of the orange.
The objective of this work is to analyze
the impact of production on costs, as well as to evaluate the viability of the
implantation of new orchards.
2. THEORETICAL FOUNDATION
Even with the great national production
of the fruit, its products and by-products, there are still points in the chain
that lack information. For Silva (2016), information on production costs and
the economic viability of these investments are not clear and objective. Therefore,
it is necessary to prepare economic studies that guarantee the continuation of
the expansion of the citrus chain in a sustainable way.
The cost of production is defined by
Matsunaga et al. (1976), as the sum of the values of the productive services
of the factors applied in the production, being this value equivalent to the
total monetary sacrifice of the firm that produces. For Silva (2016),
production costs can be divided into two components: fixed costs and variable
costs. The fixed costs do not vary with the increase or decrease of production,
since the variable cost varies according to the volume produced.
The activity analysis encompasses the
entire production process, from the plant formation phase to the end of the
productive cycle. This analysis includes all costs related to production such
as: machinery, labor, taxes, diesel oil, electricity, administrative expenses,
equipment, improvements, among others (ADAMI, 2010).
The expenses that make up all items of
variable costs and fixed costs, which are directly related to the
implementation of the activity, are part of the operational cost of production
(HORNGREN, 1989). According to Silva (2016), the operational cost is equivalent
to the disbursement made for the costing of the activity in a period, that is,
the costs incurred during a harvest.
For Silva and Marques (2015), product
price fluctuations are causing uncertainty (risk) in agricultural activity. In
addition to climate risks, pests and diseases that increasingly impact the cost
of production, the citrus farmer faces more price instability than the
industry. The orange processing industry is an oligopsonic market structure,
that is, with many suppliers (citrus growers) and few demanders (processing
industries).
For companies it is very important to
measure the risks of an activity, especially the market volatility. According
to Adami (2010), investments made in agricultural activity compromise a
considerable amount of capital that although there is a probability of return,
is subject to partial or total losses. However, there are measures that
evaluate these risks as well as assess the feasibility of a project.
According to Adami (2010), the cash flow
components that present the greatest variability (risk) are those related to
inputs (fertilizers and pesticides), on the cost side; the selling price of the
fruit and the productivity of the orange, on the revenue side. These components
of the activity's cash flow can affect the profitability of the crop over time.
According to Zuin and Queiroz (2006),
the implementation of a strategic planning becomes fundamental in the search
and maintenance of competitiveness in an enterprise, having to count on the
participation and commitment of all those involved in the process and sustained
by an efficient and clear communication between the managers.
3. MATERIALS AND METHODS
The present work was accompanied by a
property located in the municipality of Bauru, in the state of São Paulo (22º
18 '53 "S and 49º 03' 38" W), this municipality has an area of
67,350 hectares, of which 56,062 hectares are belonging to the rural area.
The main farms are: Braquiária with 37,291.6 ha, Eucalyptus with 4,011.8 ha and
Laranja with 2,293.3 ha (LUPA, 2008).
The area occupied with orange is divided
among 38 properties, and even being the third most planted in the municipality
is the one that generates the highest production value of R$ 10,124,000.00
against R$ 7,130,900.00 generated by cattle and R$ 8,824. 000.00 of eucalyptus
(LUPA, 2008). This shows the importance of citriculture to producing
municipalities, generating jobs, raising taxes and moving the local economy.
The property surveyed has an area of
93 hectares and 71.4 hectares are occupied with Orange varieties of Valencia
Americana, Pêra Rio and Valencia. The orchards of his property are with an
average of 9 years, that is to say, the planting is in production phase.
However, the production estimated for the other years was analyzed from other
farms of the same owner, with very similar conditions of soil and management.
According to Gitman (2002), Net Present
Value (NPV) can be understood as an investment analysis, which discounts the
cash flows at a specific rate, referring to the minimum return to be obtained
in the project. According to Silva (2016), the investment is considered
attractive when the NPV has a value equal to or greater than zero. In
situations where this indicator is negative indicate that the return is less
than the minimum rate required for the investment, showing that the project is
not feasible in the long term.
Another measure used to analyze the
feasibility of a project is the Internal Rate of Return (IRR), defined as the
discount rate that equals the present value of the cash inflows to the project
investment (GITMAN, 2002). That is, IRR seeks to synthesize the merits of a
project (ROSS et al., 2007). The acceptance or rejection of a given project is
defined by comparing the internal rate of return obtained with the minimum
profitability required by the company for its investors (SILVA, 2016).
Even if a project proves feasible, the
time required to recover the invested capital is undoubtedly a pertinent
question for those who wish to make an investment. Payback consists of the time
necessary for the capital expenditure to be recovered through the cash benefits
(cash flows) promoted by the investment project. Payback is often interpreted
as the indicator of the risk level of an investment project. The longer the
term, the greater the risk involved in the project (SILVA, 2016).
3.1.
Exploratory
research
The exploratory research aims to provide
greater familiarity with the problem thus making it more explicit. According to
Gil (1999), exploratory research has as main purpose to develop, clarify and
modify concepts and ideas, in order to formulate more precise problems or
searchable hypotheses for later studies.
Exploratory research aims to deepen the
knowledge of the researcher on the subject studied. It can be used to
facilitate the elaboration of a questionnaire or to serve as a basis for future
research, helping to formulate hypotheses, or the more precise formulation of
research problems (MATTAR, 2001). According to Cervo and Silva (2006), this
form of research establishes criteria, methods and techniques for the
elaboration of a research and aims to offer information about its object and
guide the formulation of hypotheses.
3.2.
Case study
According to Yin (2001), the case study
represents an empirical investigation and comprises a comprehensive method,
with the logic of planning, collecting and analyzing data. It can include both
single and multiple case studies as well as quantitative and qualitative
research approaches.
The case study may be understood as
exploring a limited system or a case, involving in-depth data collection and
multiple sources of information, in a given context. The case can be an event,
an activity or even individuals; thus, the notion of a limited system is
related to the definition of time and space (CRESWELL, 1998). According to
Fonseca (2002), for a deeper analysis the case study may follow according to an
interpretative perspective, or a pragmatic perspective, that simply aims at
presenting a global, as much as possible complete and coherent perspective of
the object of study from the researcher's point of view.
3.3.
Quantitative analysis
Quantitative research seeks the
validation of hypotheses through the use of structured, statistical data, with
analysis of a large number of representative cases. It quantifies the data and
generalizes the sample results to those interested (MATTAR, 2001). For
Richardson (1999), the quantitative research is characterized by the use of
quantification, both in the information collection modalities and in the
treatment of them by means of statistical techniques.
The quantitative approach is
characterized by the formulation of hypotheses, operational definitions of
variables, quantification in data collection and information modalities, and
use of statistical treatments. The quantitative model establishes hypotheses
that demand a relation between cause and effect and supports its conclusions in
statistical data, tests and tests. The criteria of scientificity are
verification, demonstration, tests and mathematical logic (GRESSLER, 2003).
3.4.
Monte Carlo method
According to Nascimento and Zucchi
(1997), the probabilistic simulation models had their origin in the Monte Carlo
method and are focused on random phenomena, introducing risk analysis,
incorporating the environmental variables and, consequently, the elements of
inherent uncertainty.
Monte Carlo simulation (MCS), although
widely used in project management, gets some exposure in cost management, and
is used to promote the quantification of risk and uncertainty levels related to
project costs (KWAK; INGALL, 2009). According to Williams (2003), MCS has some
advantages over other methods of project analysis that try to incorporate
uncertainty, because although there are many analytical approaches to project
planning, the problem with these approaches lies in the assumptions required,
rendering them unusable in any practical situation.
According to Samanez (2007), the essence
of MCS is to simulate ways for the evolution of a phenomenon until an
approximation is found that explains it satisfactorily, that is, uncertain
situations are simulated to find expected values for the unknown variables.
According to Yoriyaz (2009), the Monte Carlo technique involves some primary
components necessary for any kind of simulation: probability density functions;
random number generator; and sampling techniques.
In cost management, the project manager
can use MCS to better understand the project budget and estimate the final
budget at completion. These estimates are directed toward consolidating a
probability distribution of the final cost of the project, with project
managers often using this distribution to reserve a project budget reserve to
be used when contingency plans are required to respond to events of risk (KWAK;
INGALL, 2009).
Thus, a projective financial model using
MCS would be converted from a deterministic model, which does not incorporate
any probabilistic element, to a stochastic, which incorporates probabilistic
components essential for decision making in uncertain environments (OLIVEIRA;
MEDEIROS NETO, 2012).
According to Yoriyaz (2009), all Monte
Carlo simulation is performed by means of samplings of the probability density
functions and the use of cumulative probability functions. These samplings are
performed using random numbers, so any computer program that uses the Monte
Carlo method requires a random number generator.
It should be emphasized that the
analyzed populations should have certain parameters, such as mean and standard
deviation, and may present several behaviors such as Normal, Exponential and
Uniform, and it is important to note that the samples obtained should be
random. For this, a sequence of random numbers must be obtained (GARCIA et al.,
2007).
Random number generators are based on
mathematical algorithms that generate numbers, whose occurrences follow a
randomness, and which simulate the true randomness found in nature. In this
sense, the numbers generated by these algorithms are formally called
pseudorandom numbers (YORIYAZ, 2009).
In the case of the property studied the
project was done considering a period of useful life of the orchards of 15
years. The culture begins its production relatively early, however this
production begins to be expressive from the 4 years of age, period known as
formation. The implantation of the culture, demand of great volume of
investment, needing a long period for the recovery of the same.
4. RESULTS AND DISCUSSIONS
In a market highly dependent on the
juice-producing industries, the producer usually cannot impose the price to be
paid for his production, and it is his function to reduce his production cost
to the maximum, as well as to seek the increase of productivity by area. As
observed by Adami (2010) the producer is a price taker, that is, not influence
by the prices that he pays of the inputs, nor, on the prices of his production.
The analyzed property divides its
expenditures by cost center, which is the logical and segmented organization of
different sectors and activities within the property. The division of sectors
and activities by cost center helps to understand in a simplified way where the
biggest expenses are located.
Table
1: Production cost referring of the 2015/2016 harvest
Cost center |
Value |
Labor force |
R$ 132.145,20 |
Machining |
R$ 63.715,00 |
Inputs |
R$ 135.160,20 |
Irrigation |
R$ 42.617,60 |
Outsourced services |
R$ 8.863,40 |
Administration |
R$ 41.457,80 |
Harvest |
R$ 312.724,80 |
TOTAL |
R$ 736.684,00 |
Cost control in a segmented way shows in a simplified way where the most
significant production costs are, and is an important source of information for
decision making. This type of control allows us to focus on the expenses that
have an impact on production, having a larger share of the operational cost of
production, which is shown in Graph 1.
As can be seen in the graph above,
harvesting is the largest expense in fruit production, accounting for 42% of
expenditures, followed by inputs with 18% and labor with 18%. The sum of these
three accounts corresponds to 78% of the total cost of production, thus
requiring more attention from the producer on the actual expenses with each
cost center.
Graph 1: Cost production analysis by
cost center
Even with less participation, the costs
of mechanization, irrigation, administration and third-party services must also
follow a control criterion, in order to ensure that they do not influence
negatively the cost of ownership. Especially irrigation, where inadequate
management of the system can generate unnecessary expenses with electricity.
The productivity of the property in the
2015/2016 harvest closed with an average of 1231 boxes of 40.8 kg per hectare,
far above the average of the citrus belt that closed in 745 boxes of 40.8 kg
per hectare (FUNDECITRUS, 2017). This high productivity is due to the use of
irrigation as well as management techniques that allows more efficient control
of pests and diseases.
With a total cost of R$ 736,684.00, the
farm has a cost of R$ 10,317.00 per hectare. The commercialization of orange
occurs through boxes of 40.8 kg, where the industry considers this weight as a
fruit box. The cost per box is diluted according to the increase in production,
and the higher the productivity per area, the higher the revenue per box.
Kalaki (2014) shows that the cost of
production per hectare in the year of 2012 was around R$ 9,355.00, of which R$
3,241.00 of this amount refers to the harvesting and transportation of the
fruit, and the rest corresponds to the operating cost. In the case of the
property analyzed, the cost with the harvest is the one that has the greatest
impact within the production, being responsible for 34.64% of the expenses with
the crop.
According to Adami (2010), there is
great concern in the citrus production sector, because it is believed that it
can be a decisive factor for the producer's permanence in the activity. With an
average productivity of 1237 boxes per hectare at a cost of R$ 10,315.00, the
property has a cost per box of R$ 8.34. The average selling price of the carton
in the last two years (2015 and 2016) in the industries of the region of
Araraquara was R$ 16.45, obtaining a profit of R$ 8.11 per box.
The Table 2 presents the comparison
between productivity and selling price.
Table
2: Selling price vs. Productivity per hectare (revenue per hectare)
Value
per box (R$) |
Productivity
box/ha |
|||||||||
700 |
800 |
900 |
1000 |
1100 |
1200 |
|||||
13 |
9100 |
10400 |
11700 |
13000 |
14300 |
15600 |
Damage |
|||
13,5 |
9450 |
10800 |
12150 |
13500 |
14850 |
16200 |
||||
14 |
9800 |
11200 |
12600 |
14000 |
15400 |
16800 |
Point
of Equilibrium |
|||
14,5 |
10150 |
11600 |
13050 |
14500 |
15950 |
17400 |
||||
15 |
10500 |
12000 |
13500 |
15000 |
16500 |
18000 |
Gain |
|||
15,5 |
10850 |
12400 |
13950 |
15500 |
17050 |
18600 |
||||
16 |
11200 |
12800 |
14400 |
16000 |
17600 |
19200 |
||||
16,5 |
11550 |
13200 |
14850 |
16500 |
18150 |
19800 |
||||
17 |
11900 |
13600 |
15300 |
17000 |
18700 |
20400 |
As can be seen in Table 2, productivity and sales price directly
influence revenue. However, if the productivity of the property is in the citrus
belt average (745 boxes per hectare), the producer will only cover his
production costs, with the orange box price at R$ 15.00 remaining at break
even.
For the implementation of orchards, it
is necessary to acquire machines suitable for the conduction of the plantation
throughout the productive cycle. In this initial investment, drip irrigation
was also recorded, which was installed immediately after planting the
seedlings.
The Table 3 describes the initial
investment with equipment.
Table
3: Investment with machines and irrigation
Item |
Quantity |
Unit Value (R$) |
Total Value(R$) |
Tractor 85 HP |
2 |
90.000,00 |
180.000,00 |
Bilateral atomiser 4.000 liters |
1 |
47.000,00 |
47.000,00 |
Feeding machine |
1 |
40.000,00 |
40.000,00 |
Double Splitter 3,2 m |
1 |
29.000,00 |
29.000,00 |
Unilateral herbicide bar |
1 |
5.000,00 |
5.000,00 |
Sprayer 2000 liters |
1 |
14.500,00 |
14.500,00 |
Agricultural trailer 4.000 kg |
1 |
5.800,00 |
5.800,00 |
Light utility |
1 |
45.000,00 |
45.000,00 |
Irrigation (/ha) |
71,4 |
8.000,00 |
571.200,00 |
The producer invested R$ 937,500.00 at the beginning of the project with
acquisition of machines and irrigation system, this investment increases what
is necessary for the return of the applied capital (Payback). The return on
capital is undoubtedly one of the factors that makes investments in culture
more difficult, in the current scenario where the great increase of pests and
diseases that diminish the useful life of the orchard, besides the instability
in the prices received by the fruit box discourages the entrance of new citrus
producers.
Because it is a perennial crop, the
orange needs time to develop and go into production during this period known in
the citriculture as formation, at this stage the plant for not producing in a
way means the constant investment in the planting is necessary.
Table 4 below presents the IRR, NPV and
Payback indicators in each of the three investment assessment scenarios
(Pessimistic, Real and Optimistic).
Table
4: Feasibility indicators in each of the scenarios
Optimistic |
Real |
Pessimistic |
|
TIR |
18% |
16% |
14% |
VPL |
R$
310.513,63 |
R$
98.531,95 |
-R$
113.449,59 |
PAYBACK |
6 years |
7 years |
7 years |
The period for the recovery (Payback) of the investment in the Real
scenario is 7 years, that is, it takes practically half the useful life of an
orchard, so that it acts the return of the invested capital. With the delay in
return on investment, and an increasing rate of pests and diseases, citrus
farming has become a risky business.
The internal rate of return (IRR)
obtained in the Real scenario was 16%, which is only 1% above the minimum
calculated rate of 15%. In this case, the investment may not be attractive,
leaving the producer waiting for better scenarios to sell his production, or
the move to the fresh fruit market, which may be more profitable in some cases.
In addition, a NPV of R$ 98,531.95 was obtained in the Real scenario, where the
project can be considered acceptable, however, the risks present in the
cultivation activities should be considered, as they may result in the project
not being viable.
In the Optimistic scenario, a revenue
increase of 10% was established, which directly interferes with IRR and NPV,
making the project more attractive. With the increase in revenue, the period
for the recovery of the investment reduces to 6 years, and the internal rate of
return rises from 16% to 18%, as well as the NPV that more than triples in
relation to the Real scenario, making the investment more attractive for future
investors. The 6-year repayment obtained in this scenario significantly reduces
the risk in relation to production, in addition to requiring a smaller
investment in the training period, where revenue from the sale of production
helps to cover expenses with the culture.
In the Pessimistic scenario, with a
decrease of 10% of revenue in relation to the Real scenario, the investment
with the orange crop proves impracticable, with a IRR of 14%, which is lower
than the minimum rate imposed on the project, and with a NPV negative in the
amount of R$ 113,449.59. In this case, the project would not be accepted, and the
investment should not be made.
It is possible to compare the work of
Bruni et al. (1998), where the authors carried out the analysis of three
investment projects and obtained NPV of R$ 40,359.49, R$ 49,074.06 and R$
53,107.61 for projects that presented IRR equivalent to 100.8%, 37.7% and
23.34%, respectively. Thus, it is evident that the cases presented by the
authors present a large variation in the IRR, which does not occur in the
present work, in which the IRR presented a small amplitude of variation among
the three scenarios (of only 4%).
The investment treated in the present
work presents an IRR to those provided in the Pagliuca study (2014), where the
author obtained IRR indicators of 4.1% and 6.6%, respectively, for small and
large-scale production. In the same study, Pagliuca (2014) obtained an NPV of
R$ 1,066,164.74 and an IRR of 13.36% for medium-scale production, with an
analysis period of 49 months.
Bendlin et al. (2016) analyzed two forms
of investment, reaching a NPV of R$ 3,400.00 and a 40% IRR for the first
planting scenario, together with a NPV of R$ 20,193.00 and a 30% IRR for the
according to the investment model.
In the study by Alcantara (2017), the
author analyzed the orange cultivation carried out by medium producers, where
she obtained 0% IRR in scenarios where NPV was negative and, with NPV positive,
IRR ranged from 10% to 11%. In addition, Alcantara (2017) also analyzed the
case of large producers, where it was verified that the investment proves
feasible, because the crop provides a positive NPV and IRR values between 21%
and 22%.
In order to analyze in a stochastic way,
the feasibility of the investment in question, the Monte Carlo simulation was
applied using the values established in each of the scenarios, where they
were structured in tabular form for the definition of the input variables of
the simulation. According to Rodrigues et al. (2010), the essence of MCS is: to
establish a probability distribution (model) that responds to the random
variables for the risk analyzed; to simulate events from these variables, with
a number of iterations large enough to provide the desired confidence; and to
analyze the results obtained statistically.
The software used to run the simulations
was Oracle Crystal Ball, which acts
as an extension of Microsoft Excel.
According to Damasceno and Couto (2008), a determinant factor for the
application of MCS is its number of iterations, which, the larger, favors the
convergence of the result to a probability distribution closer to the real.
Therefore, it was established that they would be performed 50,000 iterations
for the generation of estimates about the investment. According to Souza
(2004), this number of iterations is already more than sufficient to allow the
results (mean and standard deviation of the output variables) to stabilize and
that graphs are provided with a high density of points to be analyzed.
In order to promote the generation of
estimates for the analysis of cultivation scenarios in the property analyzed,
triangular distributions were defined for each of the project years, starting
from the initial investment value and the previously established cash flow
projections. The assumptions adopted for the deterministic model were
replicated for the stochastic model.
According to Machado and Ferreira
(2012), to consolidate the use of triangular distributions, it is necessary to
define three distinct points of distribution for each input variable, that is,
to estimate the individual or partial costs or deadlines of the project: the
lowest possible value, the most probable value, and the estimated maximum
possible value. These three values represent the opinion of the experts and the
possible scenarios will be randomly generated based on these estimates.
Table 5 presents the cash flow analysis
according to each of the scenarios previously raised. In addition, the table
presents the assumptions and forecast cell for MCS application. It is worth
mentioning that the forecast cell is characterized by the sum of the investment
value and the stipulated cash flows for each of the scenarios, and Crystal Ball will generate the random
numbers through the defined distributions for the simulation.
Table
5: Disposition of cash flow scenarios for simulation application
According to the Table 5, in the first three years since the investment,
the producer continues to invest in the orchard, although the investment
decreases in the second year due to the start of production. However, in each
scenario, this production starts to be profitable from the fourth year where
productivity reaches about 650 boxes per hectare.
Through the application of the
simulation and the execution of the interactions with the values raised, the
cumulative frequency graph of the total investment project balance, which is
presented in Figure 1.
Figure 1: Cumulative frequency graph of
the total investment balance
When carrying out the simulation and
analyzing the estimates provided, it is necessary to point out that the minimum
balance was R$ 3,877,963.15, which is R$ 384,874.78 higher than the sum of the
Pessimistic scenario. The maximum balance obtained in the simulation was R$
4,506,761.17, which is R$ 380,650.20 lower than the sum of the Optimistic
scenario. The average balance provided by the simulation was R$ 4,190,252.94,
which is only R$ 3.15 higher than the sum of the Real scenario, evidencing a
high equivalence in the sample distribution between the input variables and the
output variables provided by the stochastic model. In addition, the simulation
obtained a standard deviation of R$ 78,525.27 and a median of R$ 4,190,588.75.
Through interval analysis, it was found
that the probability of the project being finalized with a total balance above
R$ 4,300,000.00 is only 8.1%. In order to analyze another interval for the
total balance of the project, the amounts R$ 4,150,000.00 and R$ 4,300,000.00
were defined as being the minimum and the maximum to be portrayed in the
cumulative frequency graph represented in Figure 2.
Figure 2: Cumulative frequency graph of
the total investment balance
As shown in Figure 2, the range of R$
4,150,000.00 and R$ 4,300,000.00 is responsible for 61.4% of the simulation
figures, which is an important range to be considered for decision making,
considering the high probability of materializing. In this way, it is possible
to state that the sum of the 15 triangular distributions exerts a tendency for
the total value to be located in a centrally standardized range according to
the limits established in the distributions, and the larger the number of iterations,
the higher the percentage of output variables located in the central sampling
interval.
Table 6 shows the percentiles provided
by the simulation, according to the forecast values for the total investment
balance.
Table
6: Percentiles of the simulation of the total investment balance
Percentiles |
Forecast values |
0% |
R$ 3.877.963,15 |
10% |
R$ 4.089.526,70 |
20% |
R$ 4.123.661,02 |
30% |
R$ 4.149.004,73 |
40% |
R$ 4.170.395,91 |
50% |
R$ 4.190.588.50 |
60% |
R$ 4.210.382,55 |
70% |
R$ 4.231.559,58 |
80% |
R$ 4.256.263,91 |
90% |
R$ 4.290.832,72 |
100% |
R$ 4.506.761,17 |
By analyzing the percentiles of the total investment balance, it is
possible to investigate the forecast intervals, which complement the estimates
provided by the simulation and help in defining parameters about the success
and viability of the project. It is clear that the balances defined in the
Pessimistic and Optimistic scenarios were not reached in the simulation and
consequently are not included in the percentiles intervals, however, they
should be regarded as important specifications about the success of the
project, since they originate from variables which have individually manageable
distributions.
In this way, it is possible to affirm
that the probability of the total investment balance reaching the most pessimistic
or optimistic indexes within the MCS is 0%. On the other hand, it is worth
mentioning that each simulation in Crystal
Ball will present different output variables and estimates among them, even
if they are performed with the same input values.
5. FINAL CONSIDERATIONS
Orange can be a profitable crop in the
long run, especially when high productivity is achieved, and the producer
manages to keep his costs low. However, the investment in the crop presents a
series of risks to be considered for the decision making in the face of the
instability of the price of the orange box in the last years, since the
commercialization of the orange occurs in an extremely centralized market.
The orange juice market signals a new
phase in which the production chain must pass, as world juice stocks are
currently low, and production expectations for the next harvest (2018/2019) are
relatively low, which should keep the price of the fruit at levels higher than
those found in recent years.
After analyzing the cash flows and the
NPV, IRR and Payback indicators in each of the scenarios, it was possible to
determine that the investment is attractive only in the real and optimistic
scenario, as it would provide a value above the stipulated financial return,
besides providing a final balance of nearly R$ 700,000.00 provided in the
optimistic scenario, when compared to the Real scenario.
Through the Monte Carlo simulation, it
was possible to obtain estimates of the probabilities of viability of
investment success, being that the project presents a 61.4% chance of providing
a total balance between R$ 4,150,000.00 and R$ 4,300,000.00, being this a
decisive indicator for the decision making, considering that it would be the
most probable to materialize.
As a suggestion for future works, it is
possible to indicate the performance of studies aimed at the economic analysis
of the systems of application of fixed rate and variable rate of fertilizers
and agrochemicals in the orange crop, comparing multicasts that relate
different productive scenarios to the crop comparing their respective operating
costs.
REFERENCES
ADAMI, A. C. O. (2010) Risco e retorno em citros no Brasil. Thesis (Doctorate in Applied
Economics). ESALQ/USP – Escola Superior de Agricultura “Luiz de Queiroz”,
Universidade de São Paulo, Piracicaba. Available:
http://www.teses.usp.br/teses/disponiveis/11/11132/tde-24052010-110330/pt-br.php.
Access: 15th November, 2017.
ALCANTARA, M. R. (2017) A competitividade na
produção de laranja: uma análise comparativa de custos no Brasil e estados
unidos com ênfase na gestão e controle do Huanglongbing (HLB/Greening). Thesis
(Doctorate in Agricultural Engineering). FEAGRI/UNICAMP – Faculdade de
Engenharia Agrícola da Universidade Estadual de Campinas, Universidade Estadual
de Campinas, Campinas. Available:
http://repositorio.unicamp.br/handle/REPOSIP/325718. Access: 11th November,
2017.
BENDLIN, L.; SOUZA, A.; SENFF, C. O.; STAFIN,
O. O.; PEDRO, J. J. (2016) Custos de produção, expectativas de retorno e riscos
associados ao plantio de eucalipto na região do Planalto Norte
Catarinense/Brasil. Custos e @gronegócio
Online, v. 12, n. 2, p. 2-33.
BRUNI, A. L.;
FAMÁ, R.; SIQUEIRA, J. O. (1998) Análise do risco na avaliação de projetos de
investimento: uma aplicação do Método de Monte Carlo. Cadernos de Pesquisa
em Administração, v. 1, n. 6, p. 62-74.
CEPEA – CENTRO DE ESTUDOS AVANÇADOS EM
ECONOMIA APLICADA. Indicadores Citros.
Available: https://www.cepea.esalq.usp.br/br/indicador/citros.aspx. Access: 13th September, 2017.
CRESWELL,
J. W. (1998) Qualitative inquiry and
research design: choosing among five traditions. Thousand Oaks, CA: Sage.
DAMASCENO, J. C.; COUTO, P. R. G. (2008) A
validação de um programa para o cálculo da estimativa de incerteza de medição
pelo método de Monte Carlo. In: CONGRESSO INTERNACIONAL DE METROLOGIA MECÂNICA,
1., Rio de Janeiro. Proceedings...
Duque de Caxias, RJ: INMETRO, 2008.
FONSECA, J. J. S. (2002) Metodologia da pesquisa científica. Fortaleza: UEC.
FUNDECITRUS – FUNDO DE DEFESA DA
CITRICULTURA. (2017) Estimativa da safra.
Available: http://www.fundecitrus.com.br/pes/estimativa. Access: 25th October, 2017.
GARCIA, S.; LUSTOSA, P. R. B.; BARROS, N. R. (2010) Aplicabilidade do método de simulação de Monte Carlo
na previsão dos custos de produção de companhias industriais: o caso da
Companhia Vale do Rio Doce. Revista
de Contabilidade e Organizações, v. 4, n. 10, p. 152-173.
GIL, A. C. (1999) Métodos e técnicas em pesquisa social. São Paulo: Atlas.
GITMAN, L. J. (2002) Princípios de administração financeira. 7. ed. São Paulo: Harbra.
GRESSLER, L. A. (2003) Introdução à pesquisa: projetos e relatórios. São Paulo: Loyola.
HORNGREN, C. T. (1989) Contabilidade de custos: um enfoque administrativo. São Paulo: Atlas.
KALAKI, R. B.; NEVES, M. F. (2017) Plano
estratégico para o sistema agroindustrial citrícola brasileiro. Gestão & Produção, v. 24, n. 2, p.
338-354.
KALAKI, R. B. (2014) Uma proposta de plano estratégico para o setor citrícola brasileiro.
Dissertation (Master in Administration of Organizations). FEARP/USP – Faculdade
de Economia, Administração e Contabilidade de Ribeirão Preto, Universidade de
São Paulo, Ribeirão Preto. Available:
http://www.teses.usp.br/teses/disponiveis/96/96132/tde-23072014-150722/pt-br.php.
Access: 24th November, 2017.
KWAK,
Y. H.; INGALL, L. (2009) Exploring Monte Carlo simulation applications for
project management. IEEE Engineering
Management Review, v. 37, n. 2, p. 83-91.
LUPA - LEVANTAMENTO CENSITÁRIO DAS UNIDADES
DE PRODUÇÃO AGROPECUÁRIA DO ESTADO DE SÃO PAULO. Mapas das Principais Atividades Agrícolas do Estado de São Paulo.
Available: http://www.cati.sp.gov.br/projetolupa/mapaculturas.php. Access: 28th
September, 2017.
MACHADO, N. R. S.; FERREIRA, A. O. (2012)
Método de simulação de Monte Carlo em planilha Excel. Revista de Ciências Gerenciais, v. 16, n. 23, p. 223-244.
MALHOTRA, N. (2001) Pesquisa de marketing. 3. ed. Porto Alegre: Bookman.
MATSUNAGA, M.; BEMELMANS, P. F.; TOLEDO, P.
E. N.; DULLEY, R. D.; OKAWA, H.; PERDROSO, I. A. (1976) Metodologia de custo de
produção utilizado pelo IEA. Agricultura
em São Paulo, v. 23, n. 1, p. 123-139.
MATTAR, F. N. (2001) Pesquisa de marketing. 3. ed. São Paulo:
Atlas.
NEVES,
M. F.; TROMBIN, V. G.; KALAKI, R. B. (2014) Peeling back the citrus in Brazil:
mapping and quantification of the Brazilian citrus Chain. Citrus Research & Technology, v. 35, n. 2, p. 45-60.
NEVES,
M. F.;
TROMBIN, V. G.; MILAN, P.; LOPES, F. F.; PEREIRA, F. C.; KALAKI, R. B. (2010) O retrato da citricultura brasileira.
Ribeirão Preto: Markestrat.
OLIVEIRA, M. R. G.; MEDEIROS NETO, L. B.
(2012) Simulação de Monte Carlo e Valuation: uma abordagem estocástica. REGE - Revista de Gestão, v. 19, n. 3,
p. 493-512.
PAGLIUCA, L. G. (2014) Análise do risco financeiro da produção de tomate de mesa em Caçador
(SC) e Mogi Guaçu (SP). Dissertation (Master in Applied Economics).
ESALQ/USP – Escola Superior de Agricultura “Luiz de Queiroz”, Universidade de
São Paulo, Piracicaba. Available: http://www.teses.usp.br/teses/disponiveis/11/11132/tde-07052014-141840/pt-br.php.
Access: 29th November, 2017.
RICHARDSON, R. J. (1999) Pesquisa social: métodos e técnicas. 3. ed. São Paulo: Atlas.
RODRIGUES, E. M.; NUNES, R. V.; ADRIANO, N.
A. (2010) A simulação de Monte Carlo como instrumento para a análise
econômico-financeira em investimentos de risco: o caso de uma decisão de
investimento na abertura de uma filial para revenda de equipamentos pesados no
Estado do Ceará. In: CONGRESSO BRASILEIRO DE CUSTOS, 17., Belo Horizonte. Proceedings... Belo Horizonte: CBC, 2010.
ROSS, S. A.; WESTERFIELD, R. W.; JAFFE, J. F.
(2007) Administração financeira:
corporate finance. São Paulo: Atlas.
SAMANEZ, C. P. (2007) Gestão de investimentos e geração de valor. São Paulo: Prentice
Hall.
SILVA, H. J. T. (2016) Estudo da viabilidade econômico-financeira da indústria de citros:
impactos da criação de um conselho setorial. Dissertation (Master in
Applied Economics). ESALQ/USP – Escola Superior de Agricultura “Luiz de
Queiroz”, Universidade de São Paulo, Piracicaba. Available:
http://www.teses.usp.br/teses/disponiveis/11/11132/tde-16032016-150358/pt-br.php.
Access: 28th November, 2017.
SILVA, H. J. T.; MARQUES, P. V. (2015) Preços
e margens de comercialização da indústria de citros no Brasil. Revista de Política Agrícola, v. 24, n.
4, p. 114-133.
SOUZA, M. C. M. (2004) Quantificação das incertezas na avaliação de projetos: o modelo
utilizado na Agência de Fomento do Estado da Bahia. Dissertation (Master in
Production Engineering). UFSC – Universidade Federal de Santa Catarina,
Florianópolis. Available:
https://repositorio.ufsc.br/handle/123456789/87817?locale-attribute=en. Access:
15th November, 2017.
WILLIAMS,
T. (2003) The contribution of mathematical modeling to the practice of project
management. IMA Journal of Management
Mathematics, v. 14, n. 1, p. 3-30.
YIN, R. K. (2001) Estudo de caso: planejamento e métodos. 2. ed. Porto Alegre:
Bookman.
YORIYAZ, H. (2009) Método de Monte Carlo:
princípios e aplicações em Física Médica. Revista
Brasileira de Física Médica, v. 3, n. 1, p. 141-149.
ZUIN, L. F. S.; QUEIROZ, T. R. (2006) Agronegócio: gestão e inovação. São
Paulo: Saraiva.