To calculate the return for this Microsoft investment, we simply need to go to an empty cell and type in the formula. In cell A24 I typed in "XIRR," to remind me later what I've calculated.

Marginal returns may be calculated using Excel to help determine if additional production would result in prohibitive expense.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments ...

Find out more about return on equity, the formula to calculate ROE, and how to calculate this measure of corporate profitability in Microsoft Excel.

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).

If your expected return on the individual investments in your portfolio is known or can be anticipated, you can calculate the portfolio's overall rate of return using Microsoft Excel.

Gain insights on portfolio management through short-term returns. Learn to calculate and interpret monthly returns for informed long-term investing decisions.

Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252. Remember, standard ...