Tree Farm Rotation & NPV Calculator

Calculate net present value of a timber rotation at different cutting ages and discount rates

Ad placeholder (leaderboard)

The hardest economic question in forestry is when to cut. This calculator applies Faustmann land-expectation-value logic to discount stumpage revenue against establishment and management cost, giving both single-rotation NPV and the perpetual-series value, and it scans rotation ages to find the optimum.

How it works

For a rotation of length T years, discount rate i, harvest stumpage R, establishment cost C0 at planting, and annual management cost a:

PV of one rotation (at year 0) =
   R / (1 + i)^T  -  C0  -  a x [ 1 - (1 + i)^-T ] / i

Land Expectation Value (perpetual series) =
   PV_one_rotation / ( 1 - (1 + i)^-T )

The single-rotation present value discounts the harvest back to planting, subtracts the up-front establishment cost, and subtracts the present value of the annual management cost (an annuity over the rotation). The Faustmann land expectation value then scales that to an infinite series of identical rotations, which is the correct valuation for productive forest land.

Optimal age

The economically optimal rotation maximizes land expectation value, not timber volume. Because the model uses constant per-rotation revenue, the tool lets you make R grow with age via a simple growth input and scans ages to report the one with the highest LEV at your discount rate. Raising the discount rate shortens the optimum; lowering it lengthens it.

Notes

This is a screening tool with constant or simply-growing revenue. A bankable appraisal models full growth-and-yield curves, thinnings, price trends, and risk.

Ad placeholder (rectangle)