EOMETRIC ANALYSIS OF NET PRESENT VALUE AND INTERNAL RATE OF RETURN†

Journal of Applied Mathematics & Informatics.
2016.
Jan,
34(1_2):
75-84

- Received : February 23, 2015
- Accepted : August 26, 2015
- Published : January 30, 2016

Download

PDF

e-PUB

PubReader

PPT

Export by style

Share

Article

Metrics

Cited by

The objective of this work is to perform a geometric analysis of the net present value (NPV) and Internal Rate of Return (IRR), defining analytics and in verifying the relationship between geometric properties of such functions. For this simulation, was used the values of the cash flows for each period identical and equal to US$ 200.00 cash, the initial investment US$ 1,000.00 and investments of each identical and equal to US$ 50.00 period. In addition, the discount rate and time were considered a maximum of 2 years (24 months) at a rate between 0 and 100%. The geometric analysis of the characteristics obtained from the expressions of the Net Present Value and Internal Rate of Return possible to observe that besides the analytical dependence between these quantities , the geometric relationships are relevant when studied in relation to the zero NPV and expressed a great contribution the sense of a broad vision for the administrator in the analysis of analytical variables that in uences the balance sheet of the company.
AMS Mathematics Subject Classification : 65H05, 65F10.
NPV
may be defined as the sum of values of the annual net assets accounted for during the period in which the project is being accomplished.
The best method for the assessment of investment, according
[13]
, is the deterministic method, or rather, consolidated coefficients, also called Internal Return Rate (IRR) and Net Present Value (NPV), will give financial and economic support to the investment. The preciseness of calculations require exact information and data, otherwise the project may be altered due to data oscillation
[7]
.
In
[14]
, is calculate current values of future cash flows by employing costs of capital or the return rate as discount rate. If the result is different than zero, the project is accepted since net present values are higher than the cost of the project’s initial investment.
According to
[16]
,
NPV
is the most adequate method to compare several economic proposals. However, many types of inefficiencies may be extant in the
NPV
method, with conflicts in the results during its use as a criterion for selection.
According to
[1]
, the sum of all future cash flows is determined by present value, a.k.a. Net Present Value in which are included the influxes of both and of the exit, which are discounted at a rate. In other words, NPV of an investment is the sum of total cash flow of the present value in entries and exits discounted at a rate according to the investment risk.
According to
[5]
, NPV carries, in an explicit way, the value of money over time. NPV, a highly developed technique for capital evaluation, is based on the relationship to calculate the present value of future payments discounted at an appropriate interest rate, minus the cost of the initial investment.
NPV may be obtained by the difference between the present value of the net assets foreseen for each period during the project’s duration, and the present value of the investment
[18]
,
[6]
.
According to
[9]
, NPV may be obtained by subtracting the initial investment of a project from the present value of cash entries, with a discount at a rate equal to the firm’s cost of capital.
Calculation of NPV for an investment project may be obtained by the algebra sum of values discounting cash flow associated to it. In other words, it is the difference in value in assets minus cost value
[15]
.
The calculation of NPV identifies the net value of the project at its end in which investment value, cash flow in the project’s horizon and the risk associated with the project by the application of a discount rate should be taken into consideration to calculate net value.
According to
[5]
and
[2]
, NPV is a tool for decision-taking for the acceptance or rejection, with the following criteria:
So that NPV may be over $0, the firm will obtain a return over the cost of its investment capital. The market value of the firm will increase and thus the owners’ richness.
A positive NPV shows a gain higher than the acceptable minimum, whereas a negative NPV indicates a return lower than the minimum rate required for investments. Therefore, the value represents updated economical value of the investment project.
Internal Rate of Return (IRR) is an indicator that evaluates the project’s return as a function of costs of capital. IRR is obtained when the cost of capital eliminates NPV.
According to
[11]
, the Internal Return Rate (IRR) is a return rate applied to cash flow during one year so that all initial investment is reduced to zero during the period in which the project is being accomplished.
Analysis of IRR shows, according to
[4]
, the financial return of investment and the discount rate by which the value of the project becomes zero. Investment becomes attractive when the rate is higher than the cost of the initial investment.
When the value is zero, the tax associated to investment is called Internal Rate of Return (IRR) which represents an important help in deciding on the best investment. According to
[2]
, the rate represents the relative gain of an investment project expressed in terms of an equivalent periodic interest rate
As the discount rate increases, NPV decreases. IRR is the point where NPV is positive and the project is accepted. The opposite occurs when capital costs are higher than IRR, or rather, NPV is less than zero and thus the project is refused. When capital costs are equal to IRR, the indicator is neutral to judge the project and is open to complementary indicators.
In the meantime, no well-established methods are extant to analyze the investment by using as tools the estimate of coupling of yield between the two deterministic methodologies, the Internal Return Rate (IRR) and the Net Present Rate (NPR). An imprecise analysis of data would ensue according to
[12]
.
In the case of NPR rates close to zero, internal rates of return, also close to IRR, may be detected. Relationships between the two amounts may be observed geometrically to produce other forms of basis for decision taking by the administrator.
Current research aims at a geometrical analysis of NPV and IRR by defining analytic functions in ℝ
^{3}
and verifying the relationship of the geometrical properties between these functions.
Where:
IRR is implicitly obtained by
A system of Cartesian coordinates in ℝ
^{3}
with functions type
f
(
u, v
) = (
f
_{1}
(
u, v
)
f
_{2}
(
u, v
),
f
_{3}
(
u, v
)) of two variables
n
and
k
that vary within a subset of ℝ
^{3}
, in which R is the set of true numbers was taken into account for the establishment of a function associated with NPV. For each, determines a point in ℝ
^{3}
.
A contour map representing sets for several values of
f
was designed to determine the contour levels of the function represented by all
n
and
k
values.
Software Mathematica 5.2 (Wolfram Research Inc) was used to prepare surfaces and analytic calculations, following
[3]
.
k
and on project duration time
n
, the function of two variables is defined,
NPV
=
V
(
n, k
). For (3) was have:
In which, in the case of simulations,
I
_{0}
is constant and also
FC_{t}
and
I_{t}
are constant for all
t
, with 1 ⩽
t
⩽
n
. The function may be analyzed when there is a fixed cash flow and investments and variations in time and discount rate of the project are simulated.
In current simulation, rates of cash flow of each identical period and equal to
FC_{t}
= US$ 200.00, initial investment
I
_{0}
= US$ 1,000.00 and investments for each identical period and equal to
I_{t}
= US$ 50.00 are employed. Further, time and discount rate (
n, k
) go through the set [0, 24] × [0, 1] ⊂ ℝ
^{2}
, representing maximum time of 2 years (24 months) at a rate between 0 and 100%. (
Figure 1
).
Diagram of cash flow.
The situation is commonly seen when an entrepreneur buys an equipment at
I
_{0}
= US$ 1,000.00 and invests
I_{F}
= US$ 50.00 for its maintenance and guarantee of continuous running. Investment will give a monthly profit return of US$ 200.00.
The entrepreneur tries all possible financial means to pay off the equipment with the above profits in a 24-month period. As previously informed, the rate is linked to the profit of the equipment by its use. If profit is low, the rate is low.
As previously explained, the rate is linked to the profit the equipment will return during its use. If profit is very low, the rate will be low too.
It is thus possible to give the graph of
V
(
n, k
) comprising all the possible Net Present Values, with variations in the discount rate (
k
) and time (
n
), as below:
The sum of
V
(
n, k
) may be rewritten as a geometric progression, as bellow:
The sum is thus represented by the following expression:
The expression is thus expressed by the software Mathematica:
Figure 2
illustrates all combinations of all financial situations up to 24 months at discount rate of [0,100%]. There are regions in which
NPV
is positive (
NPV
> 0).
Simulation of NPV for 0 ≤ n ≤ 24 and 0 ≤ k ≤ 1.
Graph contour map of the function
V
(
n, k
), illustrated in
Figure 3
, reveals the behavior of
NPV
according to
n
and
k
. Thus, a bi-dimensional curve may be observed (which defines a curve in ℝ
^{2}
) for each fixed rate of
NPV
, in which
k
varies due to
n
.
Contour map of net present value for 0 ≤ n ≤ 24 and 0 ≤ k ≤ 1.
Graph contour curves of the function
V
(
n, k
) forms the contour map 2 of the same shape by curves so that each point in the curve has the same
NPV
obtained by software Mathematica:
According to the contour map 3 from the graph
V
(
n, k
), the behavior of
NPV
characteristics marked in eleven region may be perceived. Values range between US$ -1,000 and US$ 600, directly affected by return time for investment and the attractiveness rate of the project. The darker the region in which NPV lies, the lower will be the yield of the investment project, on the other hand, the brighter the region, the higher will be the return.
It should be underscored that the project becomes attractive when the time required for its return is over 7 months and the rate lower than 14%, shown in the bright section of the graph.
Let us take as examples the points A, B and C within the regions R2 and R11, in which A and B lie in the same region (R2) with similar rates but at different periods, point C has a predicted investment return equal to B (15 months), but different rates.
Note that the point A, was obtained from the function
V
(
n, k
) =
V
(5, 0.8) that has value
NPV
= US$ -822.42, the value B of the function
V
(15, 0.8) has a value of NPV in US$ -812.53 and the point value C contained in the R11 region has its NPV value determined
V
(15, 0.05) = US$ 556.95.
In the wake of the analysis of all combinations between the investment rate and return time, the administrator will make the best decision on the return rate of the highest profit according to the time determined by him for the project.
For level
V
(
k, n
) = 0, or rather, the level in which
NPV
is nil, then
The expression characterizes the curve
NPV
= 0 which returns several values of
k
due to
n
. Values of
k
define
IRR
and thus, in this case,
k
=
IRR
Since in this case,
k
depends on
n
, implicitly the curve
IRR
=
T
(
k
) by
where
T
=
T
(
k
).
Expression (12) may be written:
The expression characterizes a polynomial equation grade
n
, representing in the context of current assay an implicit function with independent variable
n
and dependent variable
T
. The function may be represented by
T
= [1,
n
] →
R
,
T
=
T
(
n
). Finally, for simplification and making
T
= [1,
n
] →
R
,
T
=
T
(
n
) and
C
_{0}
=
I
_{0}
and
C
_{0}
=
I
_{0}
and writing
, was have (9) the function
T
(
n
) or
T
(
n
) = 1 +
T_{n}
also given by the polynomial equation of grade
n
:
NPV
and
IRR
showed that, besides the analytic dependence between these quantities, geometric relations are relevant in studies related to zero level
NPV
.
Geometric dependence between the contour level and level zero of
NPV
surface highly contributes for a wider idea in light of the administrator in the analysis of analytic variables that affect the firm’s financial equilibrium.
Contour map established in current assay makes possible the analysis of events close to
IRR
exact value which only occur when
NPV
= 0.
L.A. Gabriel Filho received LuÍs Roberto Gabriel Almeida Filho. Degree in Mathematics, Post-PhD in agronomy / Energy in Agriculture, Assistant Professor, UNESP, Tupã - SP, and College of Agricultural Sciences, UNESP, Botucatu - SP.
College of Science and Engineering, UNESP - Univ Estadual Paulista, Campus of Tupã, Mathematics Laboratory Applied and Computational.
e-mail: gabrielfilho@tupa.unesp.br
C.P. Cremasco received Camila Pires Cremasco Gabriel. Degree in Mathematics, Post-PhD in Biostatistics, Assistant Professor, UNESP, Tupã - SP, and College of Agricultural Sciences, UNESP, Botucatu - SP.
College of Science and Engineering, UNESP - Univ Estadual Paulista, Campus of Tupã, Department of Biosystems Engineering.
e-mail: camila@tupa.unesp.br
F.F. Putti received Fernando Ferrari Putti. Bachelor of Business Administration, Master and PhD in Agronomy, UNIFENAS - Alfenas, MG.
University of Rosario Jose Vellano - UNIFENAS, Alfenas - MG, Department of Agricultural Sciences.
e-mail: fernandoputti@gmail.com
B.C. Góes received Bruno César Góes. Graduating in Administration. UNESP, Tupã - SP.
e-mail: brunocgoes@tupa.unesp.br
M.M. Magalhães received Marcelo Marques Magalhães. PhD in Agronomy / Energy in Agriculture, Assistant Professor, UNESP, Tupã - SP.
e-mail: marcelo@tupa.unesp.br

1. Introduction

One of the most relevant concerns for any administrator is the selection of new investments for the firm. The Net Present Value (NPV), according to
[10]
, is a highly employed method for the assessment of projects.
- If NPV is over $0, the project will be viable.
- If NPV is less than $0, the project will not be viable.

2. Materials and Methods

Definitions involving the analytic expressions of NPV and IRR are required for the development of current assay. The mathematical expression of NPV is given by:
PPT Slide

Lager Image

- FCtis the cash flow (benefit) for each period;
- kis the project’s discount rate;
- I0is the initial investment;
- Itis the value of the investment foreseen in each subsequent period.

PPT Slide

Lager Image

3. Results and Discussion

When the Net Present Value (NPV) is dependent only on the discount rate
PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

PPT Slide

Lager Image

4. Conclusions

The geometrical analysis of the characteristics from
BIO

Arshad A.
(2012)
Net Present Value is better than Internal Rate of Return
Interdisciplinary Journal of Contemporany Research In Business
4
211 -
219

Assaf Neto A.
2005
FinanÃ§as corporativas e valor.
2 ed.
Atlas
Sao Paulo

Cremasco C.P.
,
Gabriel filho L.R.A.
,
Gabriel L.R.A.
2009
Métodos computacionais aplicados á energia na agricultura
Editora Espaço Cultural do Brasil
Adamantina

Dallemolo D.
,
Lins P.
,
Santana A.C.
Avaliação de Risco como análise de investimento de coqueiral híbrido Pb-121 para produção de coco seco
Disponível

Gitman J.L.
2004
PrincÃpios de AdministraÃ§Ã£o Financeira
10 ed.
Pearson
Sao Paulo

Gollier Gollier
(2010)
Expected net present value, expected net future value, and the Ramsey rule
Journal of Environmental and Management
59
142 -
148

Hanafizadeh P.
,
Latif V.
(2011)
Robust net present value
Mathematical and Computer Modelling
54
223 -
242
** DOI : 10.1016/j.mcm.2011.02.005**

Maurer M.
(2009)
Specific net present value: An improved method for assessing modularization cost in water services with growing demand
Water Research
43
2121 -
2130
** DOI : 10.1016/j.watres.2009.02.008**

Pasqual J.
,
Padilla E.
,
Jadotte E.
(2013)
Technical note: Equivalence of different profitability criteria with the net present value
International Journal Production Economics
142
205 -
210
** DOI : 10.1016/j.ijpe.2012.11.007**

Percoco M.
,
Borgonovo E.
(2011)
A note on the sensitivity analisys of the internal rate of return
International Journal of Production Economics
135
526 -
529
** DOI : 10.1016/j.ijpe.2011.09.002**

Peters M.S.
,
Timmerhaus K.D.
,
West R.E.
2006
Plant design and economics for chemical engineers
McGraw-Hill
New York

Pohjola V.J.
,
Turunen I.
(1990)
Estimating the internal rate of return from fuzzy data
Engineering Costs and Production Economics
18
215 -
221
** DOI : 10.1016/0167-188X(90)90123-Y**

da A.
,
Ramos C.
Utilização das técnicas de avaliação de risco como auxílio nas decisões de investimento de capital
Disponível em:

Shim J.K.
,
Siegel J.G.
2008
Financial Management
Barron's Business Library
New York

Silva M.L.
,
Fontes A.A.
(2005)
Discussao sobre os criterios de avaliacao economica: Valor Presente Liquido (VPL), Valor Anual Equivalente (VAE) e Valor Esperado da Terra (VET)
Revista Arvore
29
931 -
936

Sobel M.J.
,
Szmerekovsky J.G.
,
Tilson V.
(2009)
Scheduling projects with stochastic activity duration to maximize expected net present value
European Journal of Operational Research
198
697 -
705
** DOI : 10.1016/j.ejor.2008.10.004**

Talavera D.L.
(2007)
Tables for the estimation of the internal rate of return of photovoltaic grid-connected systems
Renewable and Sustainable Energy Reviews
11
447 -
466
** DOI : 10.1016/j.rser.2005.02.002**

Wiesemann W.
,
Kuhn D.
,
Rustem B.
(2010)
Maximizing the net present value of a project under uncertainty
European Journal of Operation Research
202
356 -
367
** DOI : 10.1016/j.ejor.2009.05.045**

Citing 'EOMETRIC ANALYSIS OF NET PRESENT VALUE AND INTERNAL RATE OF RETURN†
'

@article{ E1MCA9_2016_v34n1_2_75}
,title={EOMETRIC ANALYSIS OF NET PRESENT VALUE AND INTERNAL RATE OF RETURN†}
,volume={1_2}
, url={http://dx.doi.org/10.14317/jami.2016.075}, DOI={10.14317/jami.2016.075}
, number= {1_2}
, journal={Journal of Applied Mathematics & Informatics}
, publisher={Korean Society of Computational and Applied Mathematics}
, author={GABRIEL FILHO, L.A.
and
CREMASCO, C.P.
and
PUTTI, F.F.
and
GÓES, B.C.
and
MAGALHÃES, M.M.}
, year={2016}
, month={Jan}