That $100 grows to $110 after the first year: $100 x .10 = $10 $100 + $10 = $110 new ... Another option is to calculate the whole equation in one cell to arrive at just the final value figure.

We'll calculate the historical monthly variance of the S&P 500 Total Return index over a five-year period from August 2010 through July 2015 -- that's 60 observations (5 years x 12 months).

Next, calculate the interest charge for one year by multiplying the principal by the interest rate. In our example, that math would yield $5,000 x 0.07 = $350. This is the annual interest charge ...

Many investors seek companies that can improve their sales at above-average rates, which is why it's useful to know how to calculate revenue ... 1.145 – 1 = .145 X 100 = 14.5%.

Thus, the slope of the CML is the Sharpe ratio of the market portfolio. The intercept point of CML and the efficient frontier would result in the most efficient portfolio called the tangency ...