Advanced
EOMETRIC ANALYSIS OF NET PRESENT VALUE AND INTERNAL RATE OF RETURN†
EOMETRIC ANALYSIS OF NET PRESENT VALUE AND INTERNAL RATE OF RETURN†
Journal of Applied Mathematics & Informatics. 2016. Jan, 34(1_2): 75-84
Copyright © 2016, Korean Society of Computational and Applied Mathematics
• Received : February 23, 2015
• Accepted : August 26, 2015
• Published : January 30, 2016
Download
PDF
e-PUB
PubReader
PPT
Export by style
Share
Article
Author
Metrics
Cited by
About the Authors
L.A. GABRIEL FILHO
C.P. CREMASCO
F.F. PUTTI
B.C. GÓES
M.M. MAGALHÃES

Abstract
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. Keywords 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. 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: • If NPV is over$0, the project will be viable.
• If NPV is less than $0, the project will not be viable. 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.
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
Where:
• 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.
IRR is implicitly obtained by
PPT Slide
Lager Image
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] .
3. Results and Discussion
When the Net Present Value (NPV) is dependent only on the discount rate k and on project duration time n , the function of two variables is defined, NPV = V ( n, k ). For (3) was have:
PPT Slide
Lager Image
PPT Slide
Lager Image
In which, in the case of simulations, I 0 is constant and also FCt and It 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 FCt = US$200.00, initial investment I 0 = US$ 1,000.00 and investments for each identical period and equal to It = 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 ). PPT Slide Lager Image Diagram of cash flow. The situation is commonly seen when an entrepreneur buys an equipment at I 0 = US$ 1,000.00 and invests IF = 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:
PPT Slide
Lager Image
PPT Slide
Lager Image
The sum of V ( n, k ) may be rewritten as a geometric progression, as bellow:
PPT Slide
Lager Image
The sum is thus represented by the following expression:
PPT Slide
Lager Image
The expression is thus expressed by the software Mathematica:
PPT Slide
Lager Image
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).
PPT Slide
Lager Image
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 .
PPT Slide
Lager Image
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:
PPT Slide
Lager Image
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
PPT Slide
Lager Image
PPT Slide
Lager Image
PPT Slide
Lager Image
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
PPT Slide
Lager Image
where T = T ( k ).
Expression (12) may be written:
PPT Slide
Lager Image
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
PPT Slide
Lager Image
, was have (9) the function T ( n ) or T ( n ) = 1 + Tn also given by the polynomial equation of grade n :
PPT Slide
Lager Image
4. Conclusions
The geometrical analysis of the characteristics from 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.
BIO
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
References
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