Timber REIT Model
Agriculture Financial Model (Free Excel Download)
Value timberland using acreage, species mix, growth, harvest timing, log prices, management costs, replanting capex, taxes, and discounted cash flow.
professionals from Deloitte
Used by professionals from
About this model
Model a timberland investment over a 25-year rotation with thinning harvests (years 5–24), clearfell at rotation end (year 25), and revenue from carbon credits and hunting leases. The estate of 8,500 hectares planted at Mean Annual Increment (MAI) of 15 t/ha/yr generates thinning volume of ~32,000 tons annually (10% sawlog, 90% pulpwood) for $666k/year in year 5 base prices, and clearfell volume of 3.2M tons in year 25 generating $94M+ revenue at escalated prices. Stumpage prices escalate at 2% annually; carbon credits at 5%.
Costs are entirely expensed (silviculture/replanting at $120/ha effective, management fees at $15/ha, property taxes at $10/ha, insurance and road maintenance at $8/ha and $5/ha respectively). The J-curve profile shows negative cash in years 1–4, positive but thin cash in years 5–24 (after interest), and a spike in year 25 (clearfell proceeds less debt repayment). Senior debt is an interest-only bullet loan at 6.5%, amortized fully in year 25.
Returns analysis includes project IRR (unlevered), equity IRR (levered), and LEV (Long-term Earning Value) which annualizes the NPV over the infinite rotation cycle. NCREIF benchmarks show 5–8% total return (2–4% cash yield + 3–5% biological growth). Leverage is conservative (30–45% LTV); institutional investors (pension funds, sovereign wealth) target 6–7% real returns.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Timber REIT Model
- Timber inventory by forest type and growth rate assumptions
- Annual harvest schedules with volume projections by product (softwood, hardwood, pulp)
- Stumpage prices and log prices with inflation and commodity cycle assumptions
- Operating costs including land management, harvesting, and transportation
- EBITDA and terminal value based on sustainable yield and cap rate
- Reforestation and replanting investments
How the Timber REIT Model Structures Harvest, Valuation, and Returns
Evaluate this timber reit model by understanding its multi-stand harvest logic, growth-adjusted inventory, and scenario-driven valuation. The specification covers softwood, hardwood, and pulp through a 25-year project-finance lens, linking physical yield to financial outputs.
This explanation outlines operating drivers, calculation flow, and practical use without live formulas.
Operating drivers: stands, yield curve, and product mix
The model begins with four stands on the Assumptions sheet, each defined by area, species, current age, MAI multiplier, and rotation length. A yield curve maps age to volume per hectare using six buckets, and Harvest_Schedule reads standing volume by stand-weighted age with linear interpolation.
- A scenario toggle selects Base, Bull, or Bear, adjusting stumpage, price escalation, discount rate, land appreciation, and harvest pace. Mortality and optional storm loss reduce net inventory.
- Carbon strategy, buffer pool, registry fees, and verification costs further shape net carbon revenue.
Calculation flow: from stand age to harvest volumes
The calculation flow starts with stand-weighted age, computed as the area-weighted minimum of rotation length and current age plus year index. Standing volume per hectare is interpolated from the yield curve.
- Annual growth is the change in total standing volume, floored at zero. Thinning volume applies a removal percentage when age conditions are met, while clearfell volume occurs at rotation length.
- Inventory rolls forward: closing equals opening plus growth minus thinning, clearfell, mortality, and storm loss. This ensures mass balance, with closing inventory near zero at Year 25.
Outputs: revenue, costs, and valuation metrics
Revenue lines cover sawlog, chip-n-saw, and pulpwood from thinning and clearfell, each with product splits and escalating prices. Carbon credits, hunting leases, HBU dispositions, and non-timber easements add income.
- Costs include annual maintenance silviculture, replant at Year 25, management fees, taxes, insurance, roads, and FSC certification. The Income Statement and Cash Flow produce net income, dividends, and debt service.
- Valuation outputs include Project IRR, Project NPV, Equity IRR, and Faustmann LEV per hectare, with an IRR-by-source decomposition and a sensitivity grid for NPV across stumpage and WACC.
Practical use: scenario analysis and validation
Practically, the scenario toggle lets users compare Base, Bull, and Bear outcomes for IRR, NPV, and LEV without rebuilding the workbook.
- Fifteen checks validate harvest non-negativity, cash balances, debt repayment, inventory clearance, and product mix sums.
- The model is a finite 25-year project-finance structure, not a perpetual rotation, and it excludes a full FMV/NAV roll and delivered log sales.
- The public download is a values-only preview, so users should treat it as a reference for relationships rather than a live calculating tool.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What growth rates are typical for timber?+
Softwood grows 2-4% annually depending on climate and management intensity; hardwood grows slower at 1-2%. Growth rates vary by forest type, latitude, and silviculture investment.
What is stumpage price?+
Stumpage price is the value of standing timber; it is the difference between delivered log price and the cost of harvest and transport. Stumpage prices track commodity cycles closely.
How should I model timber prices?+
Use long-term average prices adjusted for inflation and the current commodity cycle. Softwood has traded $300-600 per MBF historically; hardwood and pulp follow different price trajectories.
What are the main operating costs in a timber portfolio?+
Land management, harvesting, transportation, and replanting are the primary cost lines. Replanting is a capital investment that sustains long-term yield and is modeled separately in the capex schedule.
Who uses timber REIT models?+
Forest investors underwriting timberland acquisitions, timber REIT analysts comparing NAV across companies, timberland funds, and environmental investors assessing carbon sequestration value.
Have more financial modelling questions? Contact us
Related templates
Farm Operations Model
Agricultural business model with crop yields, commodity pricing, operating costs, and profitability.
Renewable Energy Project Economics Model
Solar, wind, or hydro project generation, power purchase agreements, operating costs, and project IRR.
Real Estate Development Pro Forma Model
Land cost, construction budget, lease assumptions, and project IRR for commercial and residential development.
Livestock Operation Model
Financial model for animal agriculture operations including breeding cycles, feed costs, and commodity pricing.
