Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.

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.

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

Enter "=PMT (A1/12,A2*12,A3)-A4-A5/12" in cell A6 to calculate your monthly payment. The result appears parenthesized and red, which indicates a negative value, or cost.

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.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

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