In Microsoft Excel a median is calculated by using the MEDIAN function. The syntax of the function is. The investment value after 5 years will be 13567 million as calculated below.
Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.
Geometric Mean Return Formula r rate of return n number of periods. The second method is based on the same principle of finding the arithmetic mean. The arithmetic mean would be 30000 330002 31500. As a financial analyst the function is useful in finding out the average of numbers.