Humus significantly influences the bulk density of soil and contributes to moisture and nutrient retention. Soil formation begins with the weathering of humus. In agriculture, humus is sometimes also used to describe mature, or natural compost extracted from a forest or other spontaneous source for use to amend soil.
The CAGR Formula. From Investopedia, Compound Annual Growth Rate ( CAGR ) is calculated as: =(Ending Value/Begining Value)^(1/# of years) -1. Restated: =(FV/PV)^(1/n) -1. where FV = Future Value, PV = Present Value, and n = number of periods. Calculate CAGR in Excel.
Calculating CAGR in Excel Using Operators. Suppose we have the Beginning value in cell C2 and Ending Value in cell C3 (as shown below): Here is the formula that will calculate the CAGR: =(C3/C2)^(1/10)-1. Here 10 is the number of years between the beginning of the investment period and the end of it.