Previous Article

How to Calculate a Return on an Investment

Next Article

How to Create an Investment Portfolio

How to Calculate a Return on an Investment in Excel

Calculating a return on an investment in Excel may sound difficult, but it only takes a few minutes to set up. The investor will need to know the amount of the investment and the profit figure in order to create the calculation. The investor will also need to configure Excel to display the return as a percentage.


  1. Start Excel and open up a new spreadsheet page to use for calculating a return on an investment. Format the spreadsheet so the calculations are in the font size you prefer. Change the column width if the font is too large for the default setting.

  2. Create a name for the spreadsheet and save it on your computer. Make sure to save your work each time you make a change to the spreadsheet. If there is a power outage you will not need to start over if you always save the spreadsheet.

  3. Type in the name of the investment in a cell on the spreadsheet. For example, if you want to calculate the return on a stock, type the stock symbol into a cell. Enter the dollar amount of the investment you made in the stock in the cell next to the stock symbol.

  4. Determine the amount of profit on the investment and enter the figure into the cell next to the investment amount. To calculate the return you need to divide the profit amount by the original investment. For example, if you bought $10,000 of a stock and made $2,000 profit, you must divide $2,000 by $10,000 to determine the return on your investment.

  5. Use the cell next to the profit amount to calculate the return. For example, if your investment amount is in the A1 cell and your profit is in B1, type =B1/A1 in the C1 cell. Format C1 to display the figure as a percentage to see your return on investment.