A software development for investment analysis of LED lighting production project using fuzzy logic technique
Résumé
In this work, an application software for investment decision-making has been developed to analyze the feasibility level of an LED lighting production project. Particularly, the initial, manufacturing, administration, and financial expenses of the project, along with sales income and corporate tax, are applied as financial data. These inputs are then calculated into the net present value (NPV), internal rate of return (IRR), benefit-cost ratio (BCR), and discounted payback period (DPB) values, and further synthesized into the investment feasibility level using fuzzy logic. Additionally, the software allows flexible discount rate variation throughout project duration. The analysis results of 5 years duration project show that the NPV, IRR, BCR, and DPB were 6,307,759.46 Thai Baht, 24.04%, 1.08, and 3.38 years, respectively. Moreover, with 20% of expected profit margin, the feasibility level of project applying the floating discount rate of 7.12%-8.00% was “medium” at 77.89%, while project with fixed 8.00% rate suggested the level of “medium” at 67.34%. The discount rate variation, further, implied that using the floating discount rate was more attractive for the investment. Sensitivity analysis also revealed that the project was attractive until its income was 3.1% lower and expense was 2.4% higher than original. Therefore, the developed software could be suitable tool for more realistic project feasibility assessment and investment decision-making.