Economic Feasibility Analysis for Cerrado Fruit Oil Extraction

Spreadsheet data supports a technical-economic feasibility study for extracting and commercializing oils from native Cerrado fruits like Pequi, Buriti, and Baru. The analysis includes deterministic and stochastic modeling via 100,000-iteration Monte Carlo simulations for two financing scenarios. Author Raphael Luiz Fernandes Marques de Souza published this work on figshare in April 2026.

Use Cases

• Compare Net Present Value (VPL) and Internal Rate of Return (TIR) results between FCO Verde and FCO Integral financing scenarios.
• Analyze sensitivity of project outcomes using tornado diagram results identifying market demand and production volume as key variables.
• Model project risk using the provided Monte Carlo simulation outputs and PERT distributions for eight critical input variables.
• Calculate financial indicators like Discounted Payback period and Profitability Index (IL) over a ten-year analysis horizon.
• Assess capital structure impact using Weighted Average Cost of Capital (WACC) calculated via the CAPM and Hamada equation.

Strengths

• Stochastic analysis based on 100,000 Monte Carlo iterations for robust risk assessment.
• Financial model evaluates two distinct financing scenarios (FCO Verde and FCO Integral) with detailed WACC calculations.
• Analysis covers a ten-year project horizon with a total investment value of R$ 451,674.34.

Limitations

• Dataset scale is limited to a single 3.3 MB spreadsheet, representing one case study.
• Underlying raw data for the eight critical PERT variables is not provided, only simulation results.
• Geographic focus is exclusively on the Brazilian Cerrado biome, limiting direct generalizability.

Provenance

Source

figshare, authored by Raphael Luiz Fernandes Marques de Souza.

Collection Method

Spreadsheet calculations for a modeled economic feasibility study, not direct empirical measurements.

Time Range

Analysis based on a ten-year project horizon; specific base year not stated.

Freshness

Last updated April 2026.

Geography

Brazilian Cerrado biome.