Introduction
A coffee investment appraisal is based on assumptions about future production, prices, costs, inflation and farm performance. These assumptions will rarely occur exactly as projected.
Sensitivity analysis tests what happens to project results when one or more important assumptions change.
Why Sensitivity Analysis Is Essential
Agriculture operates under uncertainty. Even a well-designed farm plan may be affected by weather, pests, diseases, labour shortages, input-price increases or weak coffee markets.
A project that is profitable only under perfect conditions may be too fragile for investment.
Sensitivity analysis helps investors distinguish between:
- A project that remains viable under reasonable adverse conditions.
- A project that becomes unviable after a small change in one assumption.
Key Variables to Test
Coffee Selling Price
Coffee prices can change because of international supply, weather in major producing countries, exchange rates, stock levels, speculative activity and local market conditions.
Useful tests may include:
- A 10% price reduction.
- A 20% price reduction.
- A 10% price increase.
- A 25% price increase.
Yield
Yield assumptions may fail because of poor tree establishment, drought, inadequate nutrition, pests, disease, poor pruning, ageing trees or weak management.
Testing lower yields is particularly important where the base forecast assumes excellent management.
Operating Costs
Labour, fertiliser, pesticides, fuel, transport and equipment maintenance may increase faster than expected.
A cost sensitivity may test increases of 10%, 20% or more depending on the volatility of the input.
Establishment Cost
Land preparation, seedlings, irrigation infrastructure and construction may exceed budget. Cost overruns in the early years can materially reduce NPV and extend the payback period.
Discount Rate
The required return may rise because of higher interest rates, increased risk or more attractive alternative investments.
Time to Production
A one-year delay in commercial production can significantly reduce the value of a coffee project because revenues are postponed while maintenance costs continue.
One-Way Sensitivity Analysis
One-way sensitivity analysis changes one variable while keeping all other assumptions constant.
Examples include:
- Reduce coffee price by 20% while leaving yield and costs unchanged.
- Reduce yield by 15% while leaving price and costs unchanged.
- Increase operating costs by 25% while keeping price and yield unchanged.
This approach helps identify which variable has the greatest individual impact on project viability.
Scenario Analysis
Scenario analysis changes several related assumptions at the same time.
| Scenario | Possible Assumptions |
|---|---|
| Optimistic | Higher yields, strong prices and controlled costs |
| Base case | Expected yields, prices and costs |
| Pessimistic | Lower yields, weaker prices and higher costs |
| Severe stress | Drought, production delay and major cost increases |
Scenario analysis often provides a more realistic risk picture because adverse events may affect several variables simultaneously.
Interpreting Sensitivity Results
Sensitivity results should be reviewed using measures such as:
- Net Present Value.
- Internal Rate of Return.
- Break-even year.
- Discounted payback period.
- Maximum cumulative funding deficit.
- Total project profit.
A resilient project may remain positive under moderate adverse changes. A fragile project may show a negative NPV after only a small price or yield reduction.
Identifying Critical Assumptions
The variable that causes the largest change in NPV or IRR is a major project risk driver.
For example:
- If a small yield reduction makes NPV negative, productivity is the critical risk.
- If a small price reduction destroys viability, the project is highly market-sensitive.
- If labour-cost increases have a major effect, operational efficiency requires attention.
- If the project remains profitable under most changes, it has stronger financial resilience.
Break-even Sensitivity
Sensitivity analysis can also determine the threshold at which the project breaks even.
Useful questions include:
- What is the minimum coffee price required for a zero NPV?
- What minimum yield per tree or acre is required?
- How high can operating costs rise before the project becomes unviable?
- How long can production be delayed before the required return is no longer achieved?
Sensitivity Analysis and Risk Management
The objective is not only to measure risk but to respond to it.
| Identified Risk | Possible Management Response |
|---|---|
| Yield sensitivity | Improve agronomy, irrigation, nutrition and crop monitoring |
| Price sensitivity | Improve quality, market timing, storage and buyer diversification |
| Labour-cost sensitivity | Improve work planning, productivity measurement and contracting |
| Input-cost sensitivity | Use procurement planning and evaluate alternative application strategies |
| Drought sensitivity | Evaluate irrigation, mulching, water storage and drought management |
Common Sensitivity-Analysis Mistakes
- Testing only favourable changes.
- Changing assumptions by unrealistic percentages.
- Testing variables that have little influence while ignoring major drivers.
- Failing to test combinations of adverse events.
- Using an unrealistic base case.
- Failing to link risk findings to management action.
- Reporting only the final NPV without explaining the changed assumption.
How Coffee Business Planning & Analytics Can Help
Coffee Business Planning & Analytics allows users to define sensitivity scenarios and apply changes to key investment variables.
The platform can support testing of:
- Coffee-price changes.
- Yield changes.
- Operating and establishment cost changes.
- Discount-rate changes.
- Alternative spacing options.
- Different project durations.
Results can be compared using annual cash flows, cumulative cash flow, discounted cash flow, NPV and break-even year.
Conclusion
Coffee investment decisions involve uncertainty that cannot be eliminated. However, uncertainty can be measured, compared and managed.
Sensitivity analysis identifies the assumptions that have the greatest influence on profitability and shows how project results change under different conditions. This enables investors to design stronger projects, prepare risk responses and avoid relying on a single optimistic forecast.