How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.

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.

An annual return, or annualized return, is a percentage value that tells you how much an investment as increased in value on average per year over a period of time.

The annual rate of return on the $400k turns out to be 14% and the total multiple is 1.3x. That's not a bad outcome for a personal investment in a local business you want to support.

In order to make educated decisions when investing, you need to determine how much you could make on that investment. To do this, you need to calculate return on investment, or ROI.

Calculating annualized returns First, determine the investment's overall total return over the holding period you're examining. You can find this by subtracting the investment's current value from ...

You can think of it as an average annual return for your investment. To calculate the return for this Microsoft investment, we simply need to go to an empty cell and type in the formula.

In order to make educated decisions when investing, you need to determine how much you could make on that investment. To do this, you need to calculate return on investment, or ROI.

How to Calculate Return on Investment for Your Business You want a good ROI on your business, but telling what it is can be harder than you think.