 # How to calculate your return on investment

Determining your return on investment is a very important part of any investment review. Whether you’re investing in savings accounts, stocks, real estate, capital upgrades, or new business ventures, estimating a return on investment will aid you in choosing among investment options from MacroAxis.com.

I don’t simply calculate a straight return on investment. I prefer determining an annualized rate of return that takes into consideration the timing of investments and return, as well as compounding. Most of you are probably familiar with this concept through the term Annual Percentage Yield (APY), compound annual growth rate (CAGR), or internal rate of return (IRR). Let me walk you through the steps on how you can calculate your return on investment in terms of APY:

Step 1.  Calculate all the costs associated with an investment.

• What are the initial upfront costs associated with the investment?
• What are the maintenance costs?
• Are there any fees or taxes associated with the investment?
• What kind of research costs will you incur to properly evaluate (i.e., due diligence) the investment?
• How much of your time will this investment consume? Your time is valuable, so a complicated project could have real opportunity costs.

Basically, don’t forget the hidden costs often associated with investments.  Be sure to list out all costs you can think of.

Step 2. Estimate or calculate your returns.

• How much do you expect to gain from the investment?
• When do you expect returns to happen?

Determine how much you expect to gain from the investment.  Detail specifically all the individual returns you expect to receive from the investment.

Since returns from investments are often uncertain, you might also will want to get assistance from Gainesville Coins to jot down what you think the probability of each return occurring when you thought they would. Be sure to also specify when these returns will occur and for how long. This will be important for the next step.

Step 3. Establish a timeline for costs and returns.

Draw a simple timeline or just list in chronological order all the costs and returns you discovered in steps 1 and 2. Costs should be listed as negative dollars and returns as positive dollars.

For example:

• 1/1/2006 Initial investment cost: – \$100,000
• 9/21/2006 Sell investment: \$120,000

Step 4. Calculate annualized return of investment or APY.

This is the meat of the process and the most challenging step of calculating the return on an investment. Let me explain it using a simple example that we started above.

Let’s assume you made an investment on January 1, 2006.  That investment cost you \$100,000 including fees. Today, September 21, 2006, you decide to sell that investment and you receive \$120,000 after all expenses.

Now we want to find the APY of this investment so we can compare it to other investments or even your savings account rate.  In finance, this is often called calculating your internal rate of return.  Technically this process involves determining a discount rate at which the present value of a series of investments is equal to the present value of the returns on those investments. (Ah, this brings back memories of economics in graduate school.) Thankfully, you don’t have to fully understand the process of how this is calculated in order to use it.

For a simple situation like the example above:

APY or IRR = (Final return/Initial investment)^(365/days) – 1

In English, this means that APY equals the final dollar amount divided by the initial investment (positive number for this equation) raised to 365 divided by the number of days the investment took to complete. Then you subtract one from the number you just calculated and multiple by 100 to get your percent APY.

Too bad most investments are not this simple. You often have to pay additional capital in throughout the investment project (e.g., quarterly taxes) and your returns often come in periodically (e.g., monthly) and often with a final lump sum payout (e.g., you sell your investment to someone and get paid).

Modern spreadsheet software includes a great function to automagically find the internal rate of return (IRR), which is the same as APY.  Microsoft Excel (MSFT), Open Office (SUN), and Google Spreadsheets (GOOG) include the flexible XIRR function that can take a list of investments and returns and the corresponding dates of those events and calculate the APY for that investment.  This is a powerful and very useful function that I recommend everyone learn how to use and understand. The XIRR function is very flexible. You can you it for very simple investments like the example above or much more complex situations that include payments that occur regularly or even irregularly.

Let me show you a two examples:

Example #1 – Monthly returns Example #2 – Yearly returns View the examples using Excel spreadsheet: Annualized rate of return.xls. This spreadsheet includes the simple example from earlier in the post as well.

Notice how the return in Example #1 is much higher than that of Example #2 even though the payment amounts and total profit are the same.  The key difference is the timing of the payments.  Because the returns in Example #1 come monthly, the annualized rate of return or APY is much higher.  In Example #2, profit dividends only come in annually. That dramatically reduces the APY. I like using annualized rates of return because they account for the time value of money.

That’s it! Now you know how to properly measure your return on investments. Compare the different annualized rates of returns for your various investment options and then you can select those with the highest rates of return (assuming risk is equal among the alternatives). You can also determine your “real” return by subtracting out the average rate of inflation from the annualized rate of return. This way you can determine if you are actually building wealth with your investments.

### 70 thoughts on “How to calculate your return on investment”

• Pingback:How To Project - Final Submissions

• September 22, 2006 at 2:01 pm

This is excellent. I like to give myself the ability to do constant pro forma analysis. Cell references in Excel facilitate this, allowing me to compute based on the contents of a cell, which I can change, rather than formulize a given percentage.

• Pingback:Working at Home on the Internet

• September 22, 2006 at 9:33 pm

Ah, very useful indeed, thanks! Our how-to is up as well if you’d like to check it out!!

• January 15, 2007 at 1:44 pm

How do you take account of lucky picks from distorting your return? In my situation, I made a big purchase on September 2006 that went pretty lucky. The stock has gone up 5%. This skewed the annualized return. According to Excel’s XIRR, asof December 31, 2006, I’ve made 18% return on it. Anyone have any insight?

• March 26, 2007 at 3:32 am

IRR is 28% and 3.59% respectively in your examples above!

• March 26, 2007 at 9:06 am

ML,
I do not see the error with my calculations. Could you share with us how you came up with an IRR of 28% and 3.59% respectively?

• April 2, 2007 at 10:14 am

Thanks for the very good post about how to calculate rate of return! I wrote my own post about the XIRR spreadsheet function on my own blog, referring my readers to this post. I found the Excel spreadsheet especially useful. I hope that this is OK with you.

• April 11, 2007 at 4:22 pm

pfstock I’m glad you found this post useful. Thanks for the feedback and the linkback.

• May 13, 2007 at 3:02 pm

sir i have done my m.b.a. in marketing and presently i am associated withan fmcg company but i am interested to do some course in finance if u guide me in this relation then it will be great moreover if u could send me some literature in context to finance then i would be verythankful to u my email id is tgupta83@yahoo.co.in

• July 17, 2007 at 6:58 pm

I can’t seem to adapt this to work for me. I buy and sell stocks frequently. I also deposit and withdraw money from the account frequently. What would be the best way to calculate how my entire portfolio is doing?

• September 8, 2007 at 4:53 am

Hi George, the XIRR function is not recognized in Google spreadsheets – is there something I’m missing?
Great article – thanks!

• September 11, 2007 at 10:23 am

Jonah, the XIRR function is working in my example Google Spreadsheet. Be sure the dates column for the XIRR function are properly formatted dates in Google Spreadsheets. Sometime they can get converted to standard text. I hope that helps.

• September 18, 2007 at 7:04 pm

Hi George,
What method would you use to compare the \$100,000 initial investment in your example to investing that money in a high yield savings account with 5% compounded interest? I’m trying to find the correlation between the final answer APY/XIRR in your example and the 5% compounded interest number – basically to answer the question – how does this investment compare to a simple bank account at x% compounded interest?

• October 11, 2007 at 2:09 am

a humble request to all the Financial wizards……can somebody tell me the difference between Return ON investment and Return OF investment ???

Thnx & regards,

Rajesh Pawar

• October 11, 2007 at 10:49 am

Thanks for the info about to calculate your return on investment – Fat Pitch Financials!

• October 15, 2007 at 11:25 am

In calculating the IRR% using MONTHLY cash streams does one multiply the formula by 12 irrespective of whether the cashflow is say 12 months or 48 months ie. you’re using the figure 12 as a common factor to convert years to months?

• November 29, 2007 at 6:51 pm

I invest \$1000 per month in a mutual fund. After 12 months, it is worth (with growth & dividends) \$15000. What was my rate of return, assuming \$1000 per month meant that my total investment is \$12000? I could figure it easily as 25% if I invested \$12K one time, and one year later it was worth \$15K, but I do not know how to figure it since I invested \$1K twelve different times – monthly.

Thank you.

• January 1, 2008 at 3:24 pm

How do you take into account the fact that you make withdrawals during the year. Example: Balance Jan 1 is \$100,000; take out \$1000/month each month and withdraw \$20,000 on Aug 15; balance Dec 31 is \$103,000. What is that real return on you investment for that year.
Thanks Bob

• January 14, 2008 at 11:57 am

Nice and Simple article. Examples are excellent.

• April 3, 2008 at 6:52 am

Hi,
I would like to know , how to calculate monthly gai/loss of NAV in percentage.

Thanks,
Sanjay

• May 25, 2008 at 9:49 am

How do I find your calculator for annualized rate of return?

• Pingback:Fat Pitch Financials Turns 4

• August 18, 2008 at 10:27 am

Pls can someone tell me how to calculate Return On Investment for a Sector. For instance if i want to calculate ROI for the agricultural sector. Thanks

• September 14, 2008 at 3:52 pm

For all those asking about how to calculate return when there are cash flows in or out of the account during the period, you need to use TWIRR: Time Weighted IRR. This makes your calculations comparable to other published returns, for instance from mutual funds.

http://www.dailyvest.com/Products/prod_calcmethods.aspx#twrr

• December 15, 2008 at 7:04 pm

How do I calculate the avg yearly gain of an investment portfolio over 5 years when there are periodic deposits & withdrawals to the portfolio?

Current value =22000
start value=10000 (5 yrs ago)
several deposits during the 5 yrs total 5000
several withdrawals during the 5yrs total 2000.
thank you.
Rob.

• December 15, 2008 at 9:49 pm

@Rob:
My comment (just above yours) answers your question. Only caveat is you need to know the market value of the account on the days of the deposits and withdrawals.

Regards.

• January 17, 2009 at 6:13 pm

Outstanding stuff! Anyone know if any brokerage firm provides the annualized rate of return without having to use a spreadsheet? Thanks, Aaron

• March 23, 2009 at 10:16 am

I have data from nseindia.com which contain index value suppose for year 2005 starting from 1/1/2005 to 31/12/2005 and i want to calculate log retuns. how will i calculate it?

• September 15, 2009 at 2:34 pm

Hi

I am facing some problem on how to get the required rate of return of a project. Below are the information provided.

TJW estimates the covariance between the S&P500 and TJW to be .09. The standard deviation of S&P500 returns is 30% and the standard deviation of TJW returns is 35%. The expected return on the S&P500 is 14% and the risk free rate is 7%. The project is 25% riskier than the firm’s average operations and the firm is 100% equity financed.

I have already found the Beta but I am not sure how to adjust this beta according to the additional amount of risk faced by the project. Can anyone help me with this ? Thanks

• November 8, 2009 at 1:59 am

thank you for sharing, this made it really easy to understand.

• November 16, 2009 at 10:32 pm

Looking for feedback on this spreadsheet I created comparing real estate vs. any interest bearing account.
http://www.editgrid.com/user/jonahu/RealEstate_vs_HighYield

I was looking for a way to compare the two investment methods strictly from a ROI stand point.

I suppose this comparison could also be used to compare real estate vs. stocks by inputting your expected interest rate of return for High Yield Interest Rate.

Is this comparison valid/fair or flawed?

Thanks.

• June 14, 2010 at 9:15 am

sir,i work for an FMCG organisation food stuff, with a wide distribution network , the operational costs for distributors would be thier fuel costs,manpower costs,depreciation on vehicle,etc.,on a daily or monthly basis,i would like to know if i have to calsulate thier ROI would i be taking into account thier fixed costs like ,investment on vehicles and Godown deposists,etc,or just calculate thier monthly rentals , kindly advise , how thier ROI is calculated,Thanks,Regards,Sandeep.

• July 8, 2010 at 7:26 pm

Im in real estate and need to figure out the annual ROI on a property.

• July 22, 2010 at 9:08 am

Hello sir, im an Bachelor in Accounting student. Currently im doing a project on share market investment. I want to find how to calculate log return for the investment. Can u tell me how to calculate? This is the question. Thank you.

Date High Low Last Volume
2010-06-10 0.670 0.660 0.670 350

Stock Summary
Average Price: RM0.68
Average Volume: 800.17
Total Volume: 24,005

**Volume: No of Lots
**1 Lot = 100 shares

• July 24, 2010 at 12:35 pm

i need details for costing that are using in FMCG companies

i mena how they are doing costing if u have and exmaple kinldy please send to my email address

• September 30, 2010 at 3:51 pm

How can i calculate about the expected return of mutual fund.

• May 31, 2011 at 5:21 am

face value of share rs.50 no. of shares 20, discount rate 5%, dividend received 13.5% p.a. calculate roi

• August 8, 2011 at 6:50 am

xyz corporation sells on terms of 2/10, n/30 70% of custumers normally avail of the discounts annual sales are P900,000 80% of w/c is made on credit. cost approximately 75% of sales. what is the average balance of accounts receivable? and the average investment?

• September 19, 2011 at 5:32 am

sir can u pls tell me which is the best course as of now if you want to pursue your career in the finance field?

• Pingback:ROI vs. GPH - Page 2

• October 29, 2011 at 7:57 am

4. S Limited is considering for purchase of a machine. There are two
possible machines which will produce the additional output. Details of these machines are
as follows:

Machine x Machine Y
Rs. Rs.
Capital Cost
Sales at standard Price
Costs:
Labour
Materials
Selling Costs
Expected life in years 60,000
1,00,000

10,000
8,000
12,000
4,000
2,000
2 60,000
80,000

6,000
10,000
10,000
2,000
2,000
3

Other Information:
(a) The costs shown above relate to annual expenditure resulting from each machine. Sales
are expected to continue at the rates shown for each year for the full life of each machine;
(b) Tax to be paid may be assumed at 50% of net earnings;
(c) Interest on capital is to be ignored;
(d) The appropriate rate of interest for converting to present value may be taken at 10%.
On the basis of the facts given above, show the most profitable investment by the following methods.
(i) Pay-back Period,
(ii) Return on Investment; and
(iii) Net Present Value on Investment.

• January 17, 2012 at 1:24 pm

I come up with the same numbers as Simon, 28% & 3.6%. I’m interested in my Personal Rate of Return. So I don’t include the dividend/profits in the calcuation. They are not funds I’m pulling out of the account at the times they’re added. On the other hand I am having to pay taxes. (Not sure why those dates aren’t more like April 15 however.)

So the string of cash flows becomes simply: \$100k in, \$1k in, and \$129k out.

• February 1, 2012 at 8:00 pm

We plan to invest Rack for LCD TV that :

Cost \$129 200
expected life time 5 years
Qty 152 unit

How to get Return of investment of our invest?

• March 4, 2012 at 7:38 pm

Hello.
My Investment property is purchased for\$9 000 000. One year later it has earned a net rent of \$810 000 and now valued at at \$9 239 521.
What is the investment return of the property as a percent.
Do you 810 000/9 000 000 /365days -1 x 100 to get the percentage.

• April 26, 2012 at 8:43 pm

This is an excellent article. Simple and easy to understand
Thank you

• May 5, 2012 at 3:54 am

please change your template or back ground co lour because it is difficult to see.

• February 5, 2014 at 5:54 am

There is nice info about how to calculate your return on investment…thanks to share it ..

• May 31, 2015 at 8:25 am

Wonderful explanations… Thank you! I have an interesting situation. I created a swing trading system that trades the SPY. When I use XIRR to calculate the APY, Excel calculates a value of 8.65% for my system and 4.86% for buy and hold. These calculations are made for the period 1/1/2007 to 5/31/2015. And now for the interesting part. These calculations were made using a starting balance of \$25,000. With buy and hold, the full \$25,000 is invested continually for the entire period. My system, on average, only requires an investment of 16.3% of the portfolio balance. It scales in up to 10 times with increasingly larger buy orders; and when a sell signal triggers, they are all sold with one sell order. How do I calculate the true APY when there is so much unused cash in the portfolio that can be used for alternative purposes?

• May 18, 2016 at 12:22 am

Really helpful piece of content you shared here! Calculating an ROI is never easy and I have to say you made it easy to understand and nailed it the right way.
Cheers

• November 17, 2016 at 7:36 am