SEASONALITY STOCK REPORTS

[lostcowboy]

Hi ken have a good day at work. For regular numbers the sum button would give you the correct number, but percentage's are a different breed of numbers. About the 1 in front of the 34%. Lets say you have $100 dollars and you want to find out what the final amount is after a gain of 34%. As we know 34% is really .34 . So we take $100 times .34 and get $34 which we add to $100 to get $134. But a better way to do it is $100 times 1.34 to get $134. Also to add the percentages you have to multiply them. I can't remember why but it is true, also if you were to multiply by a negative percentage the final percentage is negative, which would be wrong.If you take .34*.30*.34*.03*(-.2 which is the same as .8) you would get a very small number (8.3232 times 10 to the power of -4) which is wrong. Besides it is in the book (Don & Bradstreet's Guide to Your Investments 1983 edition by C. Colburn Hardy) on page 20 and 21. It is called the Time-Weighted Rate of Return. Also under Calculating Rate of return they have this formula.
(Rate of return) R = EV (ending value)/ BV (beginning value) -1 * 100 . It is a very good book, if you can find a used copy. It is full of formula's.