Project Leaf — FCV Tobacco 5-Year Financial Model (FAST Standard · IFRS · 71 Audit Checks)

Description
A decision-grade 5-year financial model for FCV tobacco cultivation and Green Leaf Threshing (GLT) processing. Built to institutional modelling standards with full 3-statement integration, automated audit controls, and a UFCF-based valuation engine. Drop in your project assumptions and the entire model flows — P&L, Cash Flow, Balance Sheet, IRR, NPV, Payback, and Sensitivity Matrix — without breaking a single formula.

This is the same architecture used in feasibility engagements for greenfield estates in Sub-Saharan Africa, generalised into a reusable template.

What you can do in 60 seconds after download Open the model. Press Ctrl + Alt + F9. The Audit Checks dashboard reports 71/71 PASS. Switch the GLT Strategy toggle from 0 (Third-Party) to 1 (Own Plant). The capex, opex, revenue, IRR, NPV, MOIC, and Payback all update across 20 sheets — and the 71 audit checks confirm the model stayed coherent.

What's inside — 20 sheets
Output Layer (what management reads) HOME · Executive Summary · Financial Statements (P&L + Cash Flow + Balance Sheet) · Analysis · Brand Costing
Control Layer (what you edit) Control & Assumptions — every input in one place · Audit Checks — 71-test integrity dashboard

Engine Layer (calculation sheets, hidden by default) Revenue Model · Operating Costs · Opex Detail · Capex Register · Capex Detail · Depreciation · GLT Processing · Area & Production · P&L Engine · Cash Flow Engine · Balance Sheet Engine · Scenario & Sensitivity · KPIs & Decision Metrics

Headline features

• Dual-Stream Revenue Model — raw leaf sales and processed GLT sales, each with its own price curve
• GLT Strategy Toggle — single-cell switch compares Third-Party GLT vs Own GLT Plant across the entire model
• Dual-Irrigation Architecture — centre-pivot + flood production modelled with separate yield, cost, and capex curves
• UFCF-Based Valuation — Unlevered Free Cash Flow IRR (Y0 = −Equity, Y1+ = OCF), NPV at user-set WACC, payback on cumulative OCF
• Scenario Matrix — stress yields, prices, and cost inflation at ±5% / 10% / 15% steps
• 71 Automated Audit Checks — Balance Sheet integrity, Cash Flow reconciliation, Production parity, Capex-vs-Depreciation, Opex roll-forward — all controlled from one dashboard
• FAST Modelling Convention — Blue inputs · Black formulas · Green cross-sheet links
• Zero Volatile Functions — no INDIRECT, OFFSET, TODAY, NOW; full audit transparency
• IFRS-Aligned — accrual recognition, IAS 16 depreciation, structured for IFRS reporting
  
  

Who this is for
Feasibility analysts evaluating greenfield FCV tobacco ventures · CFOs and investment committees scoping crop diversification into tobacco · Agribusiness consultants building scale and GLT-strategy comparisons · Bank and DFI credit teams underwriting agricultural project finance · MBA and CA candidates studying institutional-grade financial modelling.

Technical specificationsWhat you get on download (Pro tier)

1. Project_Leaf_FCV_Tobacco_Model_v1.0.xlsx — the model
2. Project_Leaf_User_Guide.pdf — 14-page sheet-by-sheet walkthrough, GLT toggle guide, sensitivity workflow, audit dashboard reading guide, adaptation patterns
3. Project_Leaf_Licence_and_Terms.pdf — single-user commercial licence
   
   

Licence
Single-user commercial licence. Use the model for internal analysis and for client-engagement work. Adapt freely. Resale, sublicensing, and public republication of the underlying template are prohibited. Full terms included in the bundle.

Notes
Template figures are illustrative and do not represent any specific operation or jurisdiction. Replace all blue input cells with project-specific data before commercial use. The 30% corporate tax placeholder is jurisdiction-agnostic — adjust per your tax regime.