Financial Feasibility Model for Cerrado Fruit Oil Extraction

A 3.3 MB Excel spreadsheet contains the primary financial calculations for a technical and economic feasibility study of bioprospecting native Brazilian Cerrado fruits. The model, created by Raphael Luiz Fernandes Marques de Souza and last updated in April 2026, evaluates two financing scenarios for a ten-year project horizon using deterministic and stochastic Monte Carlo analysis. It assesses the economic viability of cold-pressing oils from fruits like Pequi, Buriti, and Baru for the materials industry.

Use Cases

• Compare Net Present Value (VPL) and Internal Rate of Return (TIR) outputs between the FCO Verde and FCO Integral financing scenarios.
• Analyze the influence of market demand and production volume variables on project viability using the tornado diagram results.
• Replicate the Monte Carlo simulation with 100,000 iterations and PERT distributions for eight critical input variables to assess risk.
• Calculate financial indicators like Discounted Payback and Profitability Index (IL) based on the provided Weighted Average Cost of Capital (WACC) and Hamada equation.
• Use the project's Demonstrativo do Resultado de Exercício (DRE) structure as a template for evaluating analogous biodiversity product ventures.

Strengths

• Model includes a detailed stochastic analysis with 100,000 Monte Carlo iterations for risk assessment.
• Financial evaluation spans a ten-year horizon with a total investment value of R$ 451,674.34 specified.
• Analysis compares two distinct financing scenarios with defined WACC rates of 6.96% and 8.25% per annum.

Limitations

• Dataset scale is limited to a single 3.3 MB spreadsheet, containing one primary financial model rather than extensive raw data.
• The model's inputs and assumptions are specific to a laboratory/artisanal scale operation, limiting direct applicability to industrial contexts.
• Geographic focus is exclusively on the Brazilian Cerrado biome, which may reduce generalizability to other regions.

Provenance

Source

Raphael Luiz Fernandes Marques de Souza via figshare.

Collection Method

Constructed for a feasibility study, combining financial modeling (DRE, CAPM, Hamada equation) with stochastic Monte Carlo simulation.

Time Range

Project analysis covers a ten-year horizon.

Freshness

Last updated in April 2026, indicating a very recent and current model.

Geography

Focuses on the Brazilian Cerrado biome and native fruits like Pequi, Buriti, and Baru.