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.
The CAGR formula can be recreated in Excel. The formula to use is: = ((FV/PV)^(1/n)) â 1. Where FV is the investmentâs ending value, PV is its ending value, and n is the # of years. The XIRR function in Excel also calculates an internal rate of return (IRR) that can also be used to calculate the CAGR.