How do production, biological, capacity, and sales assumptions shape the operating plan?
Model profile
Coffee Agri-business
Greenfield Arabica or Robusta estate with a 25-year tree life, single or double harvests, stumping or replanting of old trees, banana and bean intercrops, smallholder coffee purchases, wet or dry processing, green export, roast and ground and soluble coffee, financing, and returns, with Kenya as the default country.
Decision scope
Questions this model helps you examine
What working capital, asset, debt, and equity funding does the project require?
How do changes in yields, prices, costs, or timing affect returns and resilience?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- 1,000 ha greenfield estate planted in two phases, bearing from year three
- Arabica or Robusta, single or double harvest calendars
- Banana and bean intercrops sized as shares of the coffee area
- Green export, roast and ground, and soluble coffee recipes
- Selectable country and a planning horizon up to 25 years
- Base case and eight stress scenarios
- Risk analytics
- XLSX and PDF exports
Build the case
Inputs and workspaces
- AssumptionsCore model inputs
- FarmingLand, crops, water
- StorageCapacity and losses
- ManufacturingProducts and throughput
- CommercialSales and collections
- FundingDebt, equity, covenants
- Advanced schedulesSpecialist operations, staff, asset, and master-data tables
- Risk & analyticsScenarios and predictive models
Review the result
Outputs and analysis
- Project NPVUSD
- Project IRRPre-tax
- Minimum DSCRLowest period
- Output hashSHA-256
- FarmingDetailed schedules
- StorageDetailed schedules
- ManufacturingDetailed schedules
- CommercialDetailed schedules
- FinancialDetailed schedules
- Supporting schedulesDetailed schedules
- Risk & predictiveDetailed schedules
Designed for review
Who this model is for
- Farm and project owners
- Operating teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?