RPGrow$: A Red Pine Analysis Spreadsheet for the Lake States

Abstract

Abstract RPGrow$ is a spreadsheet that interactively projects standlevel growth and yield with financial analysis of red pine plantations in the Lake States. Three types of commonly found conditions related to red pine management can be analyzed: (1) an entire rotation from initial planting to final harvest; (2) an existing stand from any point in time until final harvest; and (3) conversion of an existing stand to red pine (marginal analysis). Stand growth projections are for 70 yr. User input includes site index, stand age, initial basal area, trees per acre, thinning regime, costs associated with establishment and culture, tax rates, inflation rate, and discount rate. RPGrow$ calculates and values pulpwood and sawtimber volumes from user-defined stumpage prices. The financial analysis uses discounted cash flow methods to calculate results both with and without tax effects. Different stand management scenarios and economic factors can be compared easily through sensitivity analysis. North. J. Appl. For. 11(4):141-145.