Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

How to use the LOG function in Excel Launch Microsoft Excel. Enter your data or use existing data. Type into the cell where you want to place the result =LOG (A4, B4). Press Enter to see the result.

Discover what a log-normal distribution is, its financial applications, and how to calculate it, including using Excel for ...

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

Calculating Total Expected Return in Excel First, enter the following data labels into cells A1 through F1: Portfolio Value, Investment Name, Investment Value, Investment Return Rate, Investment ...

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier.

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.