Comparative Analysis of Investments for Biodiesel Production with Help of Excel Spreadsheet


(*) Corresponding author


Authors' affiliations


DOI's assignment:
the author of the article can submit here a request for assignment of a DOI number to this resource!
Cost of the service: euros 10,00 (for a DOI)

Abstract


Was developed a computational method in Excel® spreadsheet to compare investments with application in the production of biodiesel. Biodiesel can replace all or part of the diesel oil in automotive diesel engines. Its use on a large scale will allow the economy to foreign exchange to import diesel oil, and expected reduction of environmental pollution. The methodology applied to assess the economic viability of a production process used the simultaneous employment of technical calculations of Net Present Value (NPV) and Internal Rate of Return (IRR). A value of IRR in the NPV calculation expression replacing the Minimum Rate of Attractiveness (MRA) and leads to an iterative calculation whose result cancels the NPV value. For a quick and efficient choice of investment more attractive the spreadsheet was developed using the Excel 2007® Solver function. This tool is available and easily accessible to investors. It is established that presented method for calculating those economic parameters requires minimal efforts from the users
Copyright © 2014 Praise Worthy Prize - All rights reserved.

Keywords


Biodiesel Fuel Production; Waste Cooking Oils; NPV; IRR; MRA

Full Text:

PDF


References


L. J. Gitman. Principles of financial management. 10th. Edition. New York: Addison Wealwy, 2004.

J.L.P. de Rezende and A.D. de Oliveira. Economic and social analysis of forestry projects. 2.ed. Viçosa: UFV, 2001.

R. G. Ferreira. Applied Financial Mathematics. 5th. Edition. Recife: University Press UFPE, 2000.

J. C. Lapponi. Investment projects in the company. ed. Rio de Janeiro: Campus / Elsevier, 2008. 488 p.

C. Ragsdale. Spreadsheet Modeling and Decision Analysis (Book Only). CengageBrain.com, 2010.

S. Benninga and B. Czaczkes. Financial modelling. MIT press, 2000.

A. Lester. Project management, planning and control: managing engineering, construction and manufacturing projects to PMI, APM and BSI standards. Butterworth-Heinemann, 2006.

R. M. Kysar. The Sun Also Rises: The Political Economy of Sunset Previsions in the Tax Code. Georgia Law Review, Vol. 40, No. 2, March 2006. Available at SSRN: http://ssrn.com/abstract=887388

F. Bueno. Managerial Optimization with Excel. São Paulo: Visual Books, 2007.

E. del Vecchio. Dedini: introducing biodiesel plants: investment needs. BNDES seminar. Available at: http://www.bndes.gov.br/knowledge/publications /catalog/s_biodiesel.asp. Access, v. 5, 2013.

H. E. Portela. Technical and economic evaluation of a productive enterprise biodiesel. 2007. Thesis (Master) - Federal University of Bahia. Polytechnic School.

Y. Haimes. Risk modeling, assessment, and management. John Wiley & Sons, 2011.

S. C. Bloch. Excel for Engineers and Scientists. 2. Ed, Rio de Janeiro: LTC, 2012.

L.A. Gomes. Excel for Engineers. 2. Ed Rio de Janeiro: LTC, 2012.

G. F. Mulligan. Some implications of behavior in agricultural markets. In: M. M. Fischer and A. Getis. Recent developments in spatial analysis: spatial statistics, behavioral modeling and computational intelligence. Berlin. Springer, 1997. 433 p.


Refbacks

  • There are currently no refbacks.


Please send any question about this web site to info@praiseworthyprize.com
Copyright © 2005-2024 Praise Worthy Prize