What numbers to look for investment returns
"(Value of shares+Dividends received)/(Initial investment) would be the typical formula though this is more of a percentage where 1 would indicate that you broke even, assuming no inflation to be factored. No, you don't have to estimate the share price based on revenues as I would question how well did anyone estimate what kind of revenues Facebook, Apple, or Google have had and will have. To estimate the value of shares, I'd likely consider what does my investment strategy use as metrics: Is it discounted cash flow, is it based on earnings, is it something else? There are many ways to determine what a stock ""should be worth"" that depending on what you want to believe there are more than a few ways one could go."
Set your xirr formula to a very tall column, leaving lots of empty rows for future additions. In column C, instead of hardcoding the value, use a formula that tests if it's the current bottom entry, like this: =IF(ISBLANK(A7),-C6, C6) If the next row has no date entered (yet), then this is the latest value, and make it negative. Now, to digress a bit, there are several ways to measure returns. I feel XIRR is good for individual positions, like holding a stock, maybe buying more via DRIP, etc. For the whole portfolio it stinks. XIRR is greatly affected by timing of cash flows. Steady deposits and no withdrawals dramatically skew the return lower. And the opposite is true for steady withdrawals. I prefer to use TWRR (aka TWIRR). Time Weighted Rate of Return. The word 'time' is confusing, because it's the opposite. TWRR is agnostic to timing of cashflows. I have a sample Excel spreadsheet that you're welcome to steal from: http://moosiefinance.com/static/models/spreadsheets.html (it's the top entry in the list). Some people prefer XIRR. TWRR allows an apples-to-apples comparison with indexes and funds. Imagine twin brothers. They both invest in the exact same ideas, but the amount of cash deployed into these ideas is different, solely because one brother gets his salary bonus annually, in January, and the other brother gets no bonus, but has a higher bi-weekly salary to compensate. With TWRR, their percent returns will be identical. With XIRR they will be very different. TWRR separates out investing acumen from the happenstance timing of when you get your money to deposit, and when you retire, when you choose to take withdrawals. Something to think about, if you like. You might find this website interesting, too: http://www.dailyvest.com/ A couple ideas: Use excel - it has an IRR (internal rate of return) that can handle a table of inputs as you describe, along with dates deposited to give you a precise number.  Go simple - track total deposits over the year, assume half of that was present in January. So, for example, your account started the year with $10k, ended with $15k, but you deposited $4k over the year. It should be clear the return (gain) is $1k, right? But it's not 10%, as you added during the year. I'd divide $1k/$12k for an 8.3% return. Not knowing how your deposits were structured, the true number lies between the 10% and 6.7% as extremes. You'll find as you get older and have a higher balance, this fast method gaining accuracy, as your deposits are a tinier fraction of your account and likely spread out pretty smoothly over the year anyway. "There are some assumptions which can be made in terms of the flexibility you have - I will start with the least flexible assumption and then move to more flexible assumptions. If you must put down a number 1, your go-to for this(""Change the start period to 1""), is pretty good, and it's used frequently for other divide-by-zero calculations like kda in a video game. The problem I have with '1' is that it doesn't allow you to handle various scales.  Some problems are dealt with in thousands, some in fractions, and some in hundreds of millions. Therefore, you should change the start period to the smallest significantly measurable number you could reasonably have. Here, that would take your example 0 and 896 and give you an increase of 89,500%. It's not a great result, but it's the best you can hope for if you have to put down a number,  and it allows you to keep some of the ""meaning in the change."" If you absolutely must put something This is the assumption that most answers have taken - you can put down a symbol, a number with a notation, empty space, etc, but there is going to be a label somewhere called 'Growth' that will exist. I generally agree with what I've seen, particularly the answers from Benjamin Cuninghma and Nath. For the sake of preservation - those answers can be summarized as putting 'N/A' or '-', possibly with a footnote and asterisk. If you can avoid the measurement entirely The root of your question is ""What do my manager and investors expect to see?"" I think it's valuable to dig even further to ""What do my manager and investors really want to know?"". They want to know the state of their investment. Growth is often a good measurement of that state, but in cases where you are starting from zero or negative, it just doesn't tell you the right information. In these situations, you should avoid % growth, and instead talk in absolute terms which mention the time frame or starting state. For example:" Fund performance at NAV (%) for latest quarter, YTD, and average annual total returns for 1, 3, 5, 10 years. P/E ratio (1 yr. forecast), P/B ratio, Beta, Sharpe ratio, Wtd. avg. market cap, fund assets.  I guess I would want to calculate all these things based off of the data that I would be working with. I will assume I am working with daily fund values per share over 10+ years. "I find it interesting that you didn't include something like [Total Bond Market](http://stockcharts.com/freecharts/perf.html?VBMFX), or [Intermediate-Term Treasuries](http://stockcharts.com/freecharts/perf.html?VBIIX), in your graphic.   If someone were to have just invested in the DJI or SP500, then they would have ignored the tenants of the Modern Portfolio Theory and not diversified adequately.  I wouldn't have been able to stomach a portfolio of 100% stocks, commodities, or metals.  My vote goes for: 1.) picking an asset allocation that reflects your tolerance for risk (a good starting point is ""age in bonds,"" i.e. if you're 30, then hold 30% in bonds); 2.) save as if you're not expecting annualized returns of %10 (for example) and save more; 3.) don't try to pick the next winner, instead broadly invest in the market and hold it.  Maybe gold and silver are bubbles soon to burst -- I for one don't know.  I don't give the ""notion in the investment community"" much weight -- as it always is, someday someone will be right, I just don't know who that someone is." There is no typical return for an IRA. Understand that an IRA is not an investment type, it is just an account that gets special tax treatment by the Federal Government. The money in the IRA could be invested in almost anything including Gold, Stocks, Bonds, Cash, CDs, etc. So the question as phrased isn't exactly meaningful. It is kind of like asking what is the typical price of things if I use $10 bills. As for a 10.6% annualized return on your portfolio. That's not a bad return. At that rate you will double your investment (with compounding) every 7.2 years. Again, however, some context is needed. You can really only evaluate investment returns with your risk profile in mind. If you are invested in super safe investments like CDs, that is an absolutely incredible return. You compare it to several indexes, which is a good way to do it if you are investing in the types of investments tracked by those indexes. If annualized rate of return is what you are looking for, using a tool would make it a lot easier.   In the post I've also explained how to use the spreadsheet.   Hope this helps. "First, to mention one thing - better analysis calls for analyzing a range of outcomes, not just one; assigning a probability on each, and comparing the expected values. Then moderating the choice based on risk tolerance. But now, just look at the outcome or scenario of 3% and time frame of 2 days. Let's assume your investable capital is exactly $1000 (multiply everything by 5 for $5,000, etc.). A. Buy stock: the value goes to 103; your investment goes to $1030; net return is $30, minus let's say $20 commission (you should compare these between brokers; I use one that charges 9.99 plus a trivial government fee). B. Buy an call option at 100 for $0.40 per share, with an expiration 30 days away (December 23). This is a more complicated. To evaluate this, you need to estimate the movement of the value of a 100 call, $0 in and out of the money, 30 days remaining, to the value of a 100 call, $3 in the money, 28 days remaining. That movement will vary based on the volatility of the underlying stock, an advanced topic; but there are techniques to estimate that, which become simple to use after you get the hang of it. At any rate, let's say that the expected movement of the option price in this scenario is from $0.40 to $3.20. Since you bought 2500 share options for $1000, the gain would be 2500 times 2.8 = 7000. C. Buy an call option at 102 for $0.125 per share, with an expiration 30 days away (December 23). To evaluate this, you need to estimate the movement of the value of a 102 call, $2 out of the money, 30 days remaining, to the value of a 102 call, $1 in the money, 28 days remaining. That movement will vary based on the volatility of the underlying stock, an advanced topic; but there are techniques to estimate that, which become simple to use after you get the hang of it. At any rate, let's say that the expected movement of the option price in this scenario is from $0.125 to $ 1.50. Since you bought 8000 share options for $1000, the gain would be 8000 times 1.375 = 11000. D. Same thing but starting with a 98 call. E. Same thing but starting with a 101 call expiring 60 days out. F., ... Etc. - other option choices. Again, getting the numbers right for the above is an advanced topic, one reason why brokerages warn you that options are risky (if you do your math wrong, you can lose. Even doing that math right, with a bad outcome, loses). Anyway you need to ""score"" as many options as needed to find the optimal point. But back to the first paragraph, you should then run the whole analysis on a 2% gain. Or 5%. Or 5% in 4 days instead of 2 days. Do as many as are fruitful. Assess likelihoods. Then pull the trigger and buy it. Try these techniques in simulation before diving in! Please! One last point, you don't HAVE to understand how to evaluate projected option price movements if you have software that  does that for you. I'll punt on that process, except to mention it. Get the general idea? Edit P.S. I forgot to mention that brokers need love for handling Options too. Check those commission rates in your analysis as well." Factors to consider: For the taxable investments: The sum of the dividend yield plus capital growth is called total return. In your examples, you get to a total return of 7% through several different (and theoretically equivalent) paths. That is the right way of thinking. There are many ways to calculate the return, and every way will give you a different results in terms of a percentage-value. One way to always get something meaningful - count the cash. You had 977 (+ 31) and in the end you have 1.370, which means you have earned 363 dollars. But what is your return in terms of percentage? One way to look at it, is by pretending that it is a fund in which you invest 1 dollar. What is the fund worth in the beginning and in the end? The tricky part in your example is, you injected new capital into the equation. Initially you invested 977 dollars which later, in the second period became worth 1.473. You then sold off 200 shares for 950 dollars. Remember your portfolio is still worth 1.473, split between 950 in cash and 523 in Shares. So far so good - still easy to calculate return (1.473 / 977 -1 = 50.8% return). Now you buy share for 981 dollars, but you only had 950 in cash? We now need to consider 2 scenarios. Either you (or someone else) injected 31 dollars into the fund - or you actually had the 31 dollars in the fund to begin with. If you already had the cash in the fund to begin with, your initial investment is 1.008 and not 977 (977 in shares and 31 in cash). In the end the value of the fund is 1.370, which means your return is 1.370 / 1.007 = 36%. Consider if the 31 dollars was paid in to the fund by someone other than you. You will then need to recalculate how much you each own of the fund. Just before the injection, the fund was worth 950 in cash and 387 in stock (310 - 200 = 110 x 3.54) = 1.339 dollars - then 31 dollars are injected, bringing the value of the fund up to 1.370. The ownership of the fund is split with 1.339 / 1.370 = 97.8% of the value for the old capital and 2.2% for the new capital. If the value of the fund was to change from here, you could calculate the return for each investor individually by applying their share of the funds value respective to their investment. Because the value of the fund has not changed since the last period (bullet 3), the return on the original investment is (977 / 1.339 - 1 = 37.2%) and the return on the new capital is (31 / 31 = 0%). If you (and not someone else) injected the 31 dollar into the fund, you will need to calculate the weight of each share of capital in each period and get the average return for each period to get to a total return. In this specific case you will still get 37.2% return - but it gets even more comlex for each time you inject new capital. There isn't really enough information here to go on.  Without knowing when you invested that money we can't find your rate of return at all, and it's important to measure your rate against risk.  If you take on significantly more risk than the overall market but only just barely outperform it, you probably got a lousy rate of return. If you underperform the market but your risk is significantly lower then you might have gotten a very good rate of return.  A savings account earning a guaranteed 4% might be a better return than gambling on the roulette wheel and making 15%. "For 3X, it's about 114, and for 4X, 144, which naturally, is twice 72.  These are close, back of napkin, results. With smart phone apps offering scientific calculators, you should get comfortable just taking the nth root of a number for a more precise answer.  Update in response to Brick's comment. The rule of 72 says that (n)(y)=72 to double your money. It answers both questions, how much time do I need, given a rate, and how much return do I need, given a time?  Logic tells me that if 72 is the number to double, 144 is the 4X. But I'm a math guy, and my logic might not be logical to OP. So -  Let's take the 20th root of 4.   This is the key to use. 4, (hit key) 20, equals. The result is 1.07177 or 7.177%. And this is the precise rate you'd need to quadruple your money in 20 years) Now (n)(y)= 20* 7.177 = 143.55 which rounds to 144. ""Rule of 144"" to quadruple your money.  This now answers OP's question, ""How to derive a Rule of X"" for a return other than doubling.  One more example? I want 10X my money. Of course I need the initial guess to enter one calculation. People like 8%, in general. It's a bit below the 10% long term S&P return, and a good round number. The Rule of 72 says 9 years to double, so, 18 years is 4X, and 36 years is 8X. For my initial calculation, I'll use 40 years. The 40th root of 10. I get 5.925% (Again the precise rate that gives 10 fold over 40 years) and multiplying this by 40, I get a ""Rule of 237"" which I'm tempted to round to 240.  At 6%, 237/6= 39.5 yrs,  1.06^39.5 = 9.99 At 6%, 240/6= 40.0 yrs,  1.06^40.0 = 10.29 You can see that you lose some accuracy for the sake of a number that's easier to remember, and manipulate. 72 to double is pretty darn accurate, so I'll stick with ""Rule of 237"" to get 10X my money.   To close, the purpose of these rules is to create the tool that lets you perform some otherwise tough calculations away from any electronic device. Of course I know how to use logs, and in real life I'm paid to explain them to students who are typically glad when that chapter is over. I've shown above how the ""Rule of X"" can be formulated with a power/root key, which, for most people, is simpler. Ironically, log calculations as @jkuz offered, force a continuous compounding which may not be desired at all. It would give a result of 230 for my 10X return example, and the following (using the first equation he offered) - At 6%, 230/6= 38.3 yrs,  1.06^38.3 = 9.31 which is further away from the desired 10X than my 237 or rounded 240." Here are a few things I've already done, and others reading this for their own use may want to try.  It is very easy to find a pattern in any set of data. It is difficult to find a pattern that holds true in different data pulled from the same population.  Using similar logic, don't look for a pattern in the data from the entire population. If you do, you won't have anything to test it against. If you don't have anything to test it against, it is difficult to tell the difference between a pattern that has a cause (and will likely continue) and a pattern that comes from random noise (which has no reason to continue). If you lose money in bad years, that's okay. Just make sure that the gains in good years are collectively greater than the losses in bad years. If you put $10 in and lose 50%, you then need a 100% gain just to get back up to $10.  A Black Swan event (popularized by Nassim Taleb, if memory serves) is something that is unpredictable but will almost certainly happen at some point. For example, a significant natural disaster will almost certainly impact the United States (or any other large country) in the next year or two. However, at the moment we have very little idea what that disaster will be or where it will hit.  By the same token, there will be Black Swan events in the financial market. I do not know what they will be or when they will happen, but I do know that they will happen. When building a system, make sure that it can survive those Black Swan events (stay above the death line, for any fellow Jim Collins fans). Recreate your work from scratch. Going through your work again will make you reevaluate your initial assumptions in the context of the final system. If you can recreate it with a different medium (i.e. paper and pen instead of a computer), this will also help you catch mistakes. If you just want to know total return, either as dollars or a percentage, just add up the total amount spent on buys and compare this to current value plus money received on sales. In this case, you spent (310 x $3.15 + $19.95) + (277 x $3.54 + $19.95). So your total investment is ... calculator please ... $1996.98. You received 200 x $4.75 on the sale minus the $19.95 = $930.05. The present value of your remaining shares is 387 x $6.06 = $2345.22. So you have realized plus unrealized value of $2345.22 + $930.05 = $3275.27. Assuming I didn't mix up numbers or make an arithmetic mistake, your dollar gain is $3275.27 - $1996.98 = $1278.29, which comes to 1278.29 / 1996.98 = 64%. If you want to know percentage gain as an annual rate, we'd have to know buy and sell dates, and with multiple buys and sells the calculation gets messier.