We assess the economic feasibility of a 10 MMGY biodiesel plant using a Monte Carlo Cash Flow model programmed in Excel using @Risk, a simulation and risk analysis software. The model incorporates stochastic components to capture uncertainty in the analysis. The stochastic components are mainly variables that may exhibit risk, such as input prices, output prices, and expected revenues, and these are assigned probability distributions in the model. The model is programmed with three output variables: stream of revenues, profits/loss, and the resulting net present value (NPV) over ten year forecast period. Results from the cash flow analysis show that average expected revenues from the sale of biodiesel and co-products will be $48.5 million and total... |