Free Microsoft Excel 2013 Quick Reference

Compound Growth Rate and ^

A few months ago, I got the help of this forum to obtain the formula for compound growth rate. The formula I was given was something like this:

=sum(present earnings/starting earnings)^(1/#years)-1

That has worked in excel, but now I am attempting to move this formula from excel to a web program and I don't know what ^ does. The help section sez that ^ is *, but that doesn't work. Can anyone help me with ^? In excel the formula of
=sum(1.88/.29)^(1/9)-1 = 23.1 . How would I get the same answer in a regular math formula?

Thanks Rich Hill


Greetings:

Is it possible to calculate a compounded growth rate using a begining value, ending value, and number of intervals?

For example,

2005 Population = 24635
2010 Population = 30159

Inverals = 5

The annual rate (5 intervals) = 4.11%

Is there a function that can calucate the 4.11 % ?

Best regards,
Beau

Hi all,
I have a sample spreadsheet of exactly what I am facing, but an excerpt.
Column A aims to find the compounded annual return of historical total assets, which is from coumn C onwards.

However, some data goes back to 1991, and some to 1993 and so on.
I'm trying to come up with a command that finds the compounded growth rate and simply drag it down to apply to all cells, taking into account of the different years.

Please advise.

Sincere thanks in advance.

Hi,

Can someone give me a formula that calculates the monthly compounding growth rate for a 12 month period where an annual growth rate target is subject to change:

E.G.

If we are targeting annual growth of 100%. Ie $1,000,000 becomes $2,000,000 in a year, the monthly compounding growth rate is 5.94631%.

How do I put this in a formula???????? in case the annual growth rate changes from say 100% to 50%.

Is there a function in Excell that can be used to calculate an investment"s
compound growth rate? If so what is it and how do you use it?

For instance if someone invested $10,000 in 1985 and that investment was
worth $18,000 today is there a function in Excell that can be used to
determine that investment's compound growth rate?

I am tring to calculate a city's Compound growth rate, but I keep
getting an error. the city has 233,149 as of 2004, and 242,820 in 2000.
My formula is =(D4/J4)^(1/(2004 -2000))-1
Thanks for any help.

I have a series of all positive numbers for which I would like to calculate
the compounded growth rate per period. However the XIRR function requires at
least one positive and one negative value. Is there an alternative that will
allow me to calculate the compounded growth rate using all positive values?
Thank you in advance for your cooperation.

Hi all,

I've created a spreadsheet to keep track of my modest share holdings and as a record of the past performance of closed out investments.

At present I am able to work out the exact % gain (or loss!) on an investment by taking the monetary change in value net of any fees and dividends, and expressing as a % of purchase value. Its a useful way to help work out where things have gone well, and where they haven't....

However, what I would really like to do is to work out the equivalent annual compound growth rate for any particular share, as this will enable me to make valid comparisons between investments over different time periods. So, for example, lets say I buy a share, hold it for 3 years and sell it for a total gain of 15%. You might suggest just dividing the % figure by the number of years to give an average gain of 5% per year.

However I think a truer reflection of performance is to work out compounded rates. To illustrate this further, lets take a standard interest bearing deposit account. If you had £100 in this account and earned 5% interest each year, you would end up not with £115, but with £115.76 after 3 years. The interest accumulated in all but the final year also earning interest in the subsequent years - the joy of compounding. While its easy to work out how funds accumulate over time with the rate of interest to hand, I don't have a method of performing the reverse calculation - extrapolating the interest rate from an end total and the time.

So for my aforementioned 15% over 3 years example, I can only guess the rate through trial and error, (its something just under 4.8% equivalent annual interest) - and that's just on paper. I wouldn't know where to begin when it comes to writing an excel formula to calculate this. The formula gets more complex still when you factor in time periods that are not whole years.

So, ideally, I would like to have a formula that calculates the time (in days, I guess?) an investment has been held from bought and sold dates (which I write in a format like so: 11-May-2009), and then uses this variable together with the total % gain (or loss) to work out the equivalent % rate of gain per year.

All of which will probably point to the fact that I'd earn more holding the money in a savings deposit account! If anyone can help out with this little headache, I'd most appreciate it. Thanks,

Andrew

Hi there,

This is my first post so I am keeping my fingers crossed!

I am trying to show Y/Y growth rate and I can only manage to do M/M by doing

1. Summerize value field by "Sum"
2. Show value as "% Difference From"
3. Base Filed "Month"
4. Base Item "(Previous)"

When I change Base Field from Month to Year then I got N/A.

Please help!

Thanks!

Morning,

Has anybody ever come up with a way to discover the a compound interest growth rate based on actual numbers... for example;

Jan05 - 75
Jan06 - 150
Jan07 - 290
Jan08 - 440

I have a long list of investments that I am working on for a colleague, and want to show the growth in interest rate. In addition, I have payment schedules from loans for which I want to do the same, although I imagine the formula will be the same.

Any suggestions?

Cheers,

Paul

Hello,

Is it possible to calculate the compound annual growth rate (CAGR) for a period with only the returns by percentage instead of the actual values? For example, I have the quarterly returns for a three-year period, dates and percentages [comma-separated]:Sep-04,Dec-04,Mar-05,Jun-05,Sep-05,Dec-05,Mar-06,Jun-06,Sep-06,Dec-06,Mar-07,Jun-07,Sep-07
1.00,9.90,-1.10,1.30,5.00,2.10,6.04,-1.40,3.00,6.10,2.40,4.25,2.62The way I used to calculate the CAGR was to create arbitrary intermediate values: Say I start with a value of $100 (I think any value will work) for Jun-04, the Sep-04 value would be $101.00 ($100 + (1*0.0100)), and Dec-04 would be $111.00 ($101.00 + (1+0.0990)), and so on until Sep-07 is $149.23:101.00,111.00,109.78,111.21,116.77,119.22,126.42,124.65,128.39,136.22,139.49,145.42,149.23Then I would use the RATE function: =RATE(3, ,-101.00, 149.23), where "3" represents the three-year period, the blank is the omitted payments argument, "-101.00" is the negated present value [Aside: I don't understand the negating it, but it is necessary for it to work], and "149.23" is the future value. This formula yields a result of 13.90 %.

I have looked at the XIRR function, but that does not appear to meet my my needs. Because I only know the return by percent, is there a way to calculate this same CAGR (13.90 %) without creating the "placeholder" values?

Thank you very much!
Ryan

PS
Is there a better way to display sample data since a file can't be attached? I found if a line of "cells" from the post is copied and pasted into Excel and then, in 2007, go to
Data > Data Tools > Text to Columns > Comma delimited
then things worked OK (but tabs (if I used tabs) only worked if the line was copied from the HTML source).

I understand how to use the custom calculations in the field settings in
pivot tables to derive a simple annual growth rate, using % Difference From,
(previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates
(CAGRs) in a pivot table for each year in the series from the initial base
year?

I have tried doing a calculated field, but then the column total reflects a
sum of the CAGRs and not the CAGR for the total.

Can someone help define the formula to calculate the compound average growth
rate (CAGR) starting with an initial amount which grows or shrinks depending
upon the earnings for the year? Is the formula included in the formulae
included in Excel?

That data is in columns:
A: Year
B: Year's average interest rate growth or loss
C: Value of investment, e,g. starting at $1,000 and changing each year by
the rate in column B.
D: The CAGR effective to that year.

Thank you for your assistance.

Pat

I understand how to use the custom calculations in the field settings in pivot tables to derive a simple annual growth rate, using % Difference From, (previous), and the year field .

Does anyone know a similar way to generate compound annual growth rates (CAGRs) in a pivot table for each year in the series from the initial base year?

Hi: I am trying to find an excel formula to use compounding backwards and find monthly and daily growth rates while having an annual growth rate. Example: Year 1 sales = 100. Year 2 Sales = 200. What is the daily growth rate to get from 100 to 200? From there I can create a table with Day | daily rate | Value at day [x] and adjust each month's sales forecast by number of days in the month.

Thanks in advance

How do I cacluate the Compound Annual Growth Rate from 1 number to another
number over 5 years?

Hi all,

I have a situation where I'm trying to look for asset growth.
I know that CAGR does the compounding growth, but I'd trying to find the simple individual asset growth? That is, find the growth rates between 1990-91 and onwards, and average them.

Is there an excel command similar to CAGR(xxx,xxx,xx), but finds the simple asset growth?

Thanks.

Attached spreadsheet is a sample of my situation.
Thanks.

below are the monthly data for Jul - Mar, data & are in real values and are not in percenatge difference. Problem is this i want to figure out the growth rate, either it could be postive growth or negative. i attempted to figure out the average growth rate in percenatge from jul - mar. I have taken the monthly percentage difference of the data and then subtracted it from 1, then i applied GEOmean formula. but can not be satsified by the answer. the answer i come through is -8%. Is this the right answer?. the formula i used to come to this answer is =GEOMEAN(K2:R2+1)-1. i took the percenatge difference then subtract1 from the answer then applied thet formula. Please anybody help me to solve this as i have importnt presentationn to make in which i have to show the growth rate % .

149.11
212.35
195.6
166.47
160.8
146.63
179.18
141.4
155.62

This is my Data:

month (Multiple Items)

Values
Row Sum of Net value The Growth Rate
2007 14,378,194
2008 2,762,771 #DIV/0!
2009 3,595,793 #DIV/0!
2010 624,715 #DIV/0!
Grand Total 21361473.11

I am trying to calculate the growth rate for each year by doing the following:

Value field settings ----> summarized by (sum) ----> show value as ----> % difference from (Base field:year,Base Itemrevious)

But I keep getting the error shown in the table above DIV/0

I guess because the fist year GR equals zero.
I don't how to overcome this problem.
And I don't know if this is the right way to calculate the Growth Rate to start with.

Thanks.

hi all

trying to calculate compound growth over a period of six years. these are the values I'm using:

200121002002229020032260200422502005238020062190

If I did this calc on a calculator, for example, I would calculate the difference between 2006 and 2001 (i.e. +4.29%) and then calculate the per annum growth from this figure. What function would I use for this in Excel? Have tried XIRR and NOMINAL but doesn't seem to work, I'm probably way off the mark!!

any advice appreciated, thanks

Hi,

Not sure how relevant this is... but I need help calculating a monthly
growth rate for the following:

Start Value in Month 1: 750,000
End Value in Month 12: 1,500,000

How do I calculate the monthly growth rate so that I start with 750,000 and
end up with 1,500,000 on the twelfth month?

Thanks in advance

DATE VALUE
1959-01-01 286.6
1959-02-01 287.7
1959-03-01 289.2
1959-04-01 290.1
1959-05-01 292.2
1959-06-01 294.1
1959-07-01 295.2
1959-08-01 296.4
1959-09-01 296.7
1959-10-01 296.5
1959-11-01 297.1
1959-12-01 297.8
1960-01-01 298.2
1960-02-01 298.5
1960-03-01 299.4
1960-04-01 300.1
1960-05-01 300.9
1960-06-01 302.3
1960-07-01 304.1
1960-08-01 306.9
1960-09-01 308.4
1960-10-01 309.5
1960-11-01 310.9
1960-12-01 312.4
1961-01-01 314.1
1961-02-01 316.5

This is my monthy data and it continues up to 2006. I wanna calculate
the growth rate (% annual rate), that is the growth rate from one year
to the next (for example 1959 to 1960, then from 1960 to
1961...etc...up until 2006). NOT the average growth rate for all these
years!
So the growth rate for 1959 to 1960 would be (312.4-297.8)/297.8. My
question is: Is there a faster way to make this calculation or should I
type this formula for every year? (45 times).
Excuse my bad english and thanks in advance

--
kotlon
------------------------------------------------------------------------
kotlon's Profile: http://www.excelforum.com/member.php...o&userid=35431
View this thread: http://www.excelforum.com/showthread...hreadid=553142

Hi

Could someone advise, on finding annual growth rate equation.

Example is:-

An X items was valued at 13500 and after 24 Years it is
valued at 180000.

The equation shall forecast, Annual Growth Rate in %.
( which means, value X grown over by Y % ( which shall be static value )
and another addition of Y for next year and so on till 24th year.

And shall not forecast % to its base value ( 13500 ), which I had figured
out to be at 51.38% for 24 years.

Hope someone really understands,

Bye.

Assad

Hello, all -- I have a job that grabs the size of each SQL Server database
and log file size and saves one row per database into a table. I run this
routine on a daily basis, so I basically grab the size each day and can
monitor growth.

The table data is below.

What I would like to do is have a SQL Query setup to graph the data in Excel
to show the growth rate of each database by week, month, year.

I'm not sure the best way to do the SQL and the best way to do the graph.
Since new databases are created all the time, new rows will appear in the
output -- so creating specific graphs for each database may not be ideal...
so I'm hoping someone could help me.

Essentially, I want a graph of:

By Week -All Databases (DB274, DB332, DB344, etc) showing the start size and
the end size within a specified period.
By Month - All Databases (DB274, DB332, DB344, etc) showing the start size
and the end size within a specified period.
By Year - All Databases (DB274, DB332, DB344, etc) showing the start size
and the end size within a specified period.

I woudl then like to graph each database individually showing its individual
growt as:
By Week - DB274
By Month - DB274
By Year - DB274

Then again another by Week, Month, Year for each remaining database.

I figure I'll need a separate query for the Week, Month, Year for all
databases. Then separate queries for the Week, Month, Year for each
individual database.

How to have this in Excel for graphing is another big question for me.
Obviously, as new databases come on... I do not want to have to remember and
add/create a new graph. (If this is required, fine... I'm just trying to
find a dynamic solution here.)

Here is all my data that I've been collecting each data starting 12/17/04
thru 02/01/05.

Any help or pointers would be appreciated greatly.

ID RECORD_TYPE DBNAME
DATA_SIZE DATA_USED LOG_SIZE LOG_USED STAT_DATE
----------- ----------- -------------------------------------------------- -----------
----------- ----------- ----------- ------------------------------------------------------
2 1 DB274
15670.00 15517.00 3.49 .40 2005-01-17 13:59:10.477
36 1 DB274
15670.00 15518.00 .99 .62 2005-01-18 08:00:11.637
70 1 DB274
15670.00 15518.00 .99 .57 2005-01-19 08:00:09.123
104 1 DB274
15670.00 15518.00 .99 .70 2005-01-20 08:00:09.873
138 1 DB274
15670.00 15519.00 .99 .60 2005-01-21 08:00:10.237
172 1 DB274
15670.00 15520.00 .99 .57 2005-01-22 08:00:11.680
206 1 DB274
15670.00 15519.00 10.99 .71 2005-01-23 08:00:15.493
240 1 DB274
15670.00 15519.00 5.99 .59 2005-01-24 08:00:10.137
274 1 DB274
15670.00 15520.00 3.49 .79 2005-01-25 08:00:09.380
308 1 DB274
15670.00 15522.00 3.49 .60 2005-01-27 08:00:10.640
342 1 DB274
15670.00 15523.00 3.49 .90 2005-01-28 08:00:11.520
376 1 DB274
15670.00 15524.00 3.49 .59 2005-01-29 08:00:14.120
411 1 DB274
15670.00 15523.00 5.99 .47 2005-01-30 08:00:10.823
446 1 DB274
15670.00 15523.00 5.99 .79 2005-01-31 08:00:09.457
481 1 DB274
15720.00 15692.00 3.49 .53 2005-02-01 08:00:07.140
3 1 DB332
828.00 727.00 .99 .43 2005-01-17 13:59:10.477
37 1 DB332
828.00 728.00 .99 .55 2005-01-18 08:00:11.637
71 1 DB332
828.00 730.00 .99 .68 2005-01-19 08:00:09.123
105 1 DB332
828.00 732.00 .99 .65 2005-01-20 08:00:09.873
139 1 DB332
828.00 733.00 .99 .58 2005-01-21 08:00:10.237
173 1 DB332
828.00 734.00 .99 .59 2005-01-22 08:00:11.680
207 1 DB332
828.00 733.00 3.99 .54 2005-01-23 08:00:15.493
241 1 DB332
828.00 734.00 1.99 .41 2005-01-24 08:00:10.137
275 1 DB332
828.00 736.00 1.99 .62 2005-01-25 08:00:09.380
309 1 DB332
828.00 741.00 1.99 .42 2005-01-27 08:00:10.640
343 1 DB332
828.00 745.00 1.99 .68 2005-01-28 08:00:11.520
377 1 DB332
828.00 754.00 1.99 1.34 2005-01-29 08:00:14.120
412 1 DB332
878.00 746.00 3.99 .54 2005-01-30 08:00:10.823
447 1 DB332
878.00 747.00 2.99 1.10 2005-01-31 08:00:09.457
482 1 DB332
878.00 752.00 1.99 .59 2005-02-01 08:00:07.140
4 1 DB344
27.00 20.00 .99 .52 2005-01-17 13:59:10.477
38 1 DB344
27.00 20.00 .99 .58 2005-01-18 08:00:11.637
72 1 DB344
27.00 21.00 .99 .68 2005-01-19 08:00:09.123
106 1 DB344
27.00 21.00 .99 .65 2005-01-20 08:00:09.873
140 1 DB344
27.00 22.00 .99 .53 2005-01-21 08:00:10.237
174 1 DB344
27.00 22.00 .99 .60 2005-01-22 08:00:11.680
208 1 DB344
27.00 22.00 .99 .66 2005-01-23 08:00:15.493
242 1 DB344
27.00 22.00 .99 .56 2005-01-24 08:00:10.137
276 1 DB344
27.00 23.00 .99 .54 2005-01-25 08:00:09.380
310 1 DB344
27.00 24.00 .99 .58 2005-01-27 08:00:10.640
344 1 DB344
27.00 25.00 .99 .56 2005-01-28 08:00:11.520
378 1 DB344
27.00 26.00 .99 .63 2005-01-29 08:00:14.120
413 1 DB344
77.00 26.00 .99 .61 2005-01-30 08:00:10.823
448 1 DB344
34.00 26.00 .99 .63 2005-01-31 08:00:09.457
483 1 DB344
34.00 32.00 .99 .59 2005-02-01 08:00:07.140
5 1 DB347
1303.00 1127.00 5.99 .47 2005-01-17 13:59:10.477
39 1 DB347
1303.00 1127.00 .99 .55 2005-01-18 08:00:11.637
73 1 DB347
1303.00 1128.00 .99 .69 2005-01-19 08:00:09.123
107 1 DB347
1303.00 1129.00 .99 .63 2005-01-20 08:00:09.873
141 1 DB347
1303.00 1130.00 .99 .67 2005-01-21 08:00:10.237
175 1 DB347
1303.00 1131.00 .99 .66 2005-01-22 08:00:11.680
209 1 DB347
1303.00 1130.00 5.99 .47 2005-01-23 08:00:15.493
243 1 DB347
1303.00 1131.00 5.99 .53 2005-01-24 08:00:10.137
277 1 DB347
1303.00 1132.00 .99 .52 2005-01-25 08:00:09.380
311 1 DB347
1303.00 1134.00 .99 .56 2005-01-27 08:00:10.640
345 1 DB347
1303.00 1135.00 .99 .63 2005-01-28 08:00:11.520
379 1 DB347
1303.00 1136.00 .99 .55 2005-01-29 08:00:14.120
414 1 DB347
1303.00 1135.00 5.99 .47 2005-01-30 08:00:10.823
449 1 DB347
1303.00 1135.00 5.99 .64 2005-01-31 08:00:09.457
484 1 DB347
1303.00 1144.00 .99 .57 2005-02-01 08:00:07.140
6 1 DB358
369.00 312.00 5.99 .47 2005-01-17 13:59:10.477
40 1 DB358
369.00 312.00 .99 .51 2005-01-18 08:00:11.637
74 1 DB358
369.00 313.00 .99 .60 2005-01-19 08:00:09.123
108 1 DB358
369.00 313.00 .99 .68 2005-01-20 08:00:09.873
142 1 DB358
369.00 314.00 .99 .56 2005-01-21 08:00:10.237
176 1 DB358
369.00 314.00 .99 .54 2005-01-22 08:00:11.680
210 1 DB358
369.00 314.00 5.99 .47 2005-01-23 08:00:15.493
244 1 DB358
369.00 314.00 5.99 .66 2005-01-24 08:00:10.137
278 1 DB358
369.00 315.00 3.49 1.47 2005-01-25 08:00:09.380
312 1 DB358
369.00 316.00 3.49 .79 2005-01-27 08:00:10.640
346 1 DB358
369.00 316.00 3.49 1.64 2005-01-28 08:00:11.520
380 1 DB358
369.00 316.00 3.49 1.80 2005-01-29 08:00:14.120
415 1 DB358
369.00 316.00 3.49 1.76 2005-01-30 08:00:10.823
450 1 DB358
369.00 316.00 .99 .65 2005-01-31 08:00:09.457
485 1 DB358
369.00 317.00 .99 .54 2005-02-01 08:00:07.140
7 1 DB377
881.00 777.00 5.99 .47 2005-01-17 13:59:10.477
41 1 DB377
881.00 777.00 .99 .52 2005-01-18 08:00:11.637
75 1 DB377
881.00 778.00 .99 .67 2005-01-19 08:00:09.123
109 1 DB377
881.00 779.00 .99 .50 2005-01-20 08:00:09.873
143 1 DB377
881.00 779.00 .99 .53 2005-01-21 08:00:10.237
177 1 DB377
881.00 780.00 .99 .57 2005-01-22 08:00:11.680
211 1 DB377
881.00 779.00 5.99 .47 2005-01-23 08:00:15.493
245 1 DB377
881.00 779.00 5.99 .68 2005-01-24 08:00:10.137
279 1 DB377
881.00 780.00 3.49 2.66 2005-01-25 08:00:09.380
313 1 DB377
881.00 783.00 .99 .55 2005-01-27 08:00:10.640
347 1 DB377
881.00 784.00 .99 .70 2005-01-28 08:00:11.520
381 1 DB377
881.00 784.00 .99 .54 2005-01-29 08:00:14.120
416 1 DB377
881.00 784.00 5.99 .47 2005-01-30 08:00:10.823
451 1 DB377
881.00 784.00 5.99 .58 2005-01-31 08:00:09.457
486 1 DB377
881.00 785.00 5.99 1.60 2005-02-01 08:00:07.140
8 1 DB424
69.00 17.00 52.99 52.59 2005-01-17 13:59:10.477
42 1 DB424
69.00 17.00 52.99 52.59 2005-01-18 08:00:11.637
76 1 DB424
69.00 17.00 52.99 52.59 2005-01-19 08:00:09.123
110 1 DB424
69.00 17.00 53.99 52.97 2005-01-20 08:00:09.873
144 1 DB424
69.00 17.00 53.99 52.97 2005-01-21 08:00:10.237
178 1 DB424
69.00 17.00 53.99 52.99 2005-01-22 08:00:11.680
212 1 DB424
69.00 18.00 57.99 57.71 2005-01-23 08:00:15.493
246 1 DB424
69.00 18.00 57.99 57.71 2005-01-24 08:00:10.137
280 1 DB424
69.00 18.00 57.99 57.71 2005-01-25 08:00:09.380
314 1 DB424
69.00 18.00 57.99 57.73 2005-01-27 08:00:10.640
348 1 DB424
69.00 18.00 57.99 57.75 2005-01-28 08:00:11.520
382 1 DB424
69.00 18.00 57.99 57.73 2005-01-29 08:00:14.120
417 1 DB424
69.00 18.00 62.99 62.65 2005-01-30 08:00:10.823
452 1 DB424
69.00 18.00 62.99 62.65 2005-01-31 08:00:09.457
487 1 DB424
69.00 18.00 62.99 62.66 2005-02-01 08:00:07.140
9 1 DB489
55.00 17.00 40.99 40.76 2005-01-17 13:59:10.477
43 1 DB489
55.00 17.00 40.99 40.76 2005-01-18 08:00:11.637
77 1 DB489
55.00 17.00 40.99 40.76 2005-01-19 08:00:09.123
111 1 DB489
55.00 17.00 41.99 41.16 2005-01-20 08:00:09.873
145 1 DB489
55.00 17.00 41.99 41.16 2005-01-21 08:00:10.237
179 1 DB489
55.00 17.00 41.99 41.18 2005-01-22 08:00:11.680
213 1 DB489
55.00 17.00 45.99 45.78 2005-01-23 08:00:15.493
247 1 DB489
55.00 17.00 45.99 45.78 2005-01-24 08:00:10.137
281 1 DB489
55.00 17.00 45.99 45.78 2005-01-25 08:00:09.380
315 1 DB489
55.00 17.00 45.99 45.80 2005-01-27 08:00:10.640
349 1 DB489
55.00 18.00 49.99 49.39 2005-01-28 08:00:11.520
383 1 DB489
55.00 18.00 49.99 49.39 2005-01-29 08:00:14.120
418 1 DB489
55.00 18.00 54.99 54.72 2005-01-30 08:00:10.823
453 1 DB489
55.00 18.00 54.99 54.72 2005-01-31 08:00:09.457
488 1 DB489
55.00 18.00 54.99 54.72 2005-02-01 08:00:07.140
384 1 DB530
17.00 12.00 .99 .34 2005-01-29 08:00:14.120
419 1 DB530
17.00 13.00 .99 .61 2005-01-30 08:00:10.823
454 1 DB530
17.00 13.00 .99 .61 2005-01-31 08:00:09.457
489 1 DB530
24.00 18.00 .99 .54 2005-02-01 08:00:07.140
10 1 DB533
500.00 451.00 24.88 10.98 2005-01-17 13:59:10.477
44 1 DB533
500.00 451.00 24.88 10.98 2005-01-18 08:00:11.637
78 1 DB533
500.00 452.00 24.88 3.13 2005-01-19 08:00:09.123
112 1 DB533
500.00 453.00 24.88 6.46 2005-01-20 08:00:09.873
146 1 DB533
500.00 454.00 24.88 10.04 2005-01-21 08:00:10.237
180 1 DB533
500.00 454.00 24.88 .58 2005-01-22 08:00:11.680
214 1 DB533
500.00 454.00 24.88 4.47 2005-01-23 08:00:15.493
248 1 DB533
500.00 454.00 24.88 4.74 2005-01-24 08:00:10.137
282 1 DB533
500.00 454.00 24.88 7.99 2005-01-25 08:00:09.380
316 1 DB533
500.00 456.00 24.88 15.13 2005-01-27 08:00:10.640
350 1 DB533
500.00 457.00 24.88 5.86 2005-01-28 08:00:11.520
385 1 DB533
500.00 457.00 24.88 9.01 2005-01-29 08:00:14.120
420 1 DB533
500.00 457.00 24.88 12.74 2005-01-30 08:00:10.823
455 1 DB533
500.00 457.00 24.88 13.14 2005-01-31 08:00:09.457
490 1 DB533
500.00 462.00 24.88 7.11 2005-02-01 08:00:07.140
11 1 DB562
95.00 78.00 .99 .51 2005-01-17 13:59:10.477
45 1 DB562
95.00 78.00 .99 .51 2005-01-18 08:00:11.637
79 1 DB562
95.00 78.00 .99 .59 2005-01-19 08:00:09.123
113 1 DB562
95.00 78.00 .99 .50 2005-01-20 08:00:09.873
147 1 DB562
95.00 79.00 .99 .61 2005-01-21 08:00:10.237
181 1 DB562
95.00 79.00 .99 .55 2005-01-22 08:00:11.680
215 1 DB562
95.00 79.00 .99 .53 2005-01-23 08:00:15.493
249 1 DB562
95.00 79.00 .99 .56 2005-01-24 08:00:10.137
283 1 DB562
95.00 79.00 .99 .51 2005-01-25 08:00:09.380
317 1 DB562
95.00 80.00 .99 .62 2005-01-27 08:00:10.640
351 1 DB562
95.00 80.00 .99 .58 2005-01-28 08:00:11.520
386 1 DB562
95.00 81.00 .99 .64 2005-01-29 08:00:14.120
421 1 DB562
95.00 81.00 .99 .54 2005-01-30 08:00:10.823
456 1 DB562
95.00 81.00 .99 .64 2005-01-31 08:00:09.457
491 1 DB562
95.00 84.00 .99 .51 2005-02-01 08:00:07.140
12 1 DB586
150.00 132.00 .99 .60 2005-01-17 13:59:10.477
46 1 DB586
150.00 132.00 .99 .60 2005-01-18 08:00:11.637
80 1 DB586
150.00 132.00 .99 .67 2005-01-19 08:00:09.123
114 1 DB586
150.00 132.00 .99 .55 2005-01-20 08:00:09.873
148 1 DB586
150.00 133.00 .99 .54 2005-01-21 08:00:10.237
182 1 DB586
150.00 133.00 .99 .59 2005-01-22 08:00:11.680
216 1 DB586
154.00 133.00 .99 .65 2005-01-23 08:00:15.493
250 1 DB586
154.00 133.00 .99 .53 2005-01-24 08:00:10.137
284 1 DB586
154.00 133.00 .99 .55 2005-01-25 08:00:09.380
318 1 DB586
154.00 134.00 .99 .56 2005-01-27 08:00:10.640
352 1 DB586
154.00 134.00 .99 .55 2005-01-28 08:00:11.520
387 1 DB586
154.00 135.00 .99 .56 2005-01-29 08:00:14.120
422 1 DB586
155.00 135.00 .99 .61 2005-01-30 08:00:10.823
457 1 DB586
155.00 135.00 .99 .58 2005-01-31 08:00:09.457
492 1 DB586
155.00 135.00 .99 .66 2005-02-01 08:00:07.140
13 1 DB587
229.00 197.00 .99 .56 2005-01-17 13:59:10.477
47 1 DB587
229.00 197.00 .99 .56 2005-01-18 08:00:11.637
81 1 DB587
229.00 198.00 .99 .69 2005-01-19 08:00:09.123
115 1 DB587
229.00 199.00 .99 .70 2005-01-20 08:00:09.873
149 1 DB587
229.00 200.00 .99 .57 2005-01-21 08:00:10.237
183 1 DB587
229.00 200.00 .99 .59 2005-01-22 08:00:11.680
217 1 DB587
229.00 200.00 .99 .59 2005-01-23 08:00:15.493
251 1 DB587
229.00 200.00 .99 .70 2005-01-24 08:00:10.137
285 1 DB587
229.00 201.00 .99 .67 2005-01-25 08:00:09.380
319 1 DB587
229.00 203.00 .99 .64 2005-01-27 08:00:10.640
353 1 DB587
229.00 203.00 .99 .69 2005-01-28 08:00:11.520
388 1 DB587
229.00 203.00 .99 .66 2005-01-29 08:00:14.120
423 1 DB587
229.00 203.00 .99 .58 2005-01-30 08:00:10.823
458 1 DB587
229.00 203.00 .99 .58 2005-01-31 08:00:09.457
493 1 DB587
229.00 207.00 .99 .64 2005-02-01 08:00:07.140
14 1 DB611
841.00 724.00 5.99 .47 2005-01-17 13:59:10.477
48 1 DB611
841.00 724.00 5.99 .48 2005-01-18 08:00:11.637
82 1 DB611
841.00 725.00 .99 .56 2005-01-19 08:00:09.123
116 1 DB611
841.00 726.00 .99 .56 2005-01-20 08:00:09.873
150 1 DB611
841.00 726.00 .99 .62 2005-01-21 08:00:10.237
184 1 DB611
841.00 726.00 .99 .69 2005-01-22 08:00:11.680
218 1 DB611
841.00 726.00 10.99 1.37 2005-01-23 08:00:15.493
252 1 DB611
841.00 726.00 5.99 .68 2005-01-24 08:00:10.137
286 1 DB611
841.00 727.00 5.99 .68 2005-01-25 08:00:09.380
320 1 DB611
841.00 728.00 .99 .52 2005-01-27 08:00:10.640
354 1 DB611
841.00 729.00 .99 .64 2005-01-28 08:00:11.520
389 1 DB611
841.00 729.00 .99 .56 2005-01-29 08:00:14.120
424 1 DB611
841.00 729.00 5.99 .47 2005-01-30 08:00:10.823
459 1 DB611
841.00 729.00 5.99 .47 2005-01-31 08:00:09.457
494 1 DB611
841.00 743.00 .99 .61 2005-02-01 08:00:07.140
15 1 DB634
47000.00 46820.00 13.49 .40 2005-01-17 13:59:10.477
49 1 DB634
47000.00 46820.00 .99 .34 2005-01-18 08:00:11.637
83 1 DB634
47000.00 46820.00 .99 .51 2005-01-19 08:00:09.123
117 1 DB634
47000.00 46821.00 .99 .52 2005-01-20 08:00:09.873
151 1 DB634
47000.00 46821.00 .99 .54 2005-01-21 08:00:10.237
185 1 DB634
47000.00 46821.00 .99 .51 2005-01-22 08:00:11.680
219 1 DB634
47000.00 46821.00 50.99 6.71 2005-01-23 08:00:15.493
253 1 DB634
47000.00 46821.00 13.49 .53 2005-01-24 08:00:10.137
287 1 DB634
47000.00 46821.00 .99 .56 2005-01-25 08:00:09.380
321 1 DB634
47000.00 46823.00 .99 .58 2005-01-27 08:00:10.640
355 1 DB634
47000.00 46824.00 .99 .51 2005-01-28 08:00:11.520
390 1 DB634
47000.00 46826.00 .99 .54 2005-01-29 08:00:14.120
425 1 DB634
47000.00 46823.00 50.99 6.18 2005-01-30 08:00:10.823
460 1 DB634
47000.00 46823.00 25.99 .47 2005-01-31 08:00:09.457
495 1 DB634
47000.00 46895.00 13.49 3.34 2005-02-01 08:00:07.140
16 1 DB683
1385.00 1220.00 3.49 .59 2005-01-17 13:59:10.477
50 1 DB683
1385.00 1221.00 3.49 .66 2005-01-18 08:00:11.637
84 1 DB683
1385.00 1222.00 3.49 1.95 2005-01-19 08:00:09.123
118 1 DB683
1385.00 1224.00 3.49 2.87 2005-01-20 08:00:09.873
152 1 DB683
1385.00 1225.00 3.49 .45 2005-01-21 08:00:10.237
186 1 DB683
1385.00 1231.00 3.49 1.78 2005-01-22 08:00:11.680
220 1 DB683
1385.00 1230.00 5.99 .52 2005-01-23 08:00:15.493
254 1 DB683
1385.00 1230.00 5.99 1.57 2005-01-24 08:00:10.137
288 1 DB683
1385.00 1231.00 3.49 .62 2005-01-25 08:00:09.380
322 1 DB683
1385.00 1235.00 3.49 .58 2005-01-27 08:00:10.640
356 1 DB683
1385.00 1237.00 3.49 2.03 2005-01-28 08:00:11.520
391 1 DB683
1385.00 1239.00 3.49 1.50 2005-01-29 08:00:14.120
426 1 DB683
1435.00 1238.00 13.49 1.34 2005-01-30 08:00:10.823
461 1 DB683
1435.00 1238.00 5.99 .48 2005-01-31 08:00:09.457
496 1 DB683
1435.00 1247.00 3.49 .61 2005-02-01 08:00:07.140
17 1 DB770
13000.00 12845.00 5.99 .47 2005-01-17 13:59:10.477
51 1 DB770
13000.00 12845.00 .99 .34 2005-01-18 08:00:11.637
85 1 DB770
13000.00 12845.00 .99 .35 2005-01-19 08:00:09.123
119 1 DB770
13000.00 12845.00 .99 .35 2005-01-20 08:00:09.873
153 1 DB770
13000.00 12845.00 .99 .35 2005-01-21 08:00:10.237
187 1 DB770
13000.00 12845.00 .99 .35 2005-01-22 08:00:11.680
221 1 DB770
13000.00 12845.00 10.99 .88 2005-01-23 08:00:15.493
255 1 DB770
13000.00 12845.00 5.99 .51 2005-01-24 08:00:10.137
289 1 DB770
13000.00 12845.00 .99 .34 2005-01-25 08:00:09.380
323 1 DB770
13000.00 12845.00 .99 .34 2005-01-27 08:00:10.640
357 1 DB770
13000.00 12845.00 .99 .49 2005-01-28 08:00:11.520
392 1 DB770
13000.00 12845.00 .99 .49 2005-01-29 08:00:14.120
427 1 DB770
13000.00 12845.00 5.99 .47 2005-01-30 08:00:10.823
462 1 DB770
13000.00 12845.00 5.99 .47 2005-01-31 08:00:09.457
497 1 DB770
13000.00 12845.00 .99 .34 2005-02-01 08:00:07.140
18 1 DB776
1425.00 1274.00 .99 .41 2005-01-17 13:59:10.477
52 1 DB776
1425.00 1274.00 .99 .64 2005-01-18 08:00:11.637
86 1 DB776
1425.00 1276.00 .99 .51 2005-01-19 08:00:09.123
120 1 DB776
1425.00 1278.00 .99 .53 2005-01-20 08:00:09.873
154 1 DB776
1425.00 1279.00 .99 .53 2005-01-21 08:00:10.237
188 1 DB776
1425.00 1282.00 .99 .55 2005-01-22 08:00:11.680
222 1 DB776
1425.00 1280.00 5.99 .51 2005-01-23 08:00:15.493
256 1 DB776
1425.00 1280.00 .99 .35 2005-01-24 08:00:10.137
290 1 DB776
1425.00 1282.00 .99 .68 2005-01-25 08:00:09.380
324 1 DB776
1425.00 1292.00 .99 .55 2005-01-27 08:00:10.640
358 1 DB776
1425.00 1300.00 .99 .54 2005-01-28 08:00:11.520
393 1 DB776
1425.00 1303.00 .99 .56 2005-01-29 08:00:14.120
428 1 DB776
1475.00 1293.00 5.99 .47 2005-01-30 08:00:10.823
463 1 DB776
1475.00 1293.00 5.99 .65 2005-01-31 08:00:09.457
498 1 DB776
1475.00 1310.00 3.49 .66 2005-02-01 08:00:07.140
19 1 DB778
1051.00 926.00 1.48 .63 2005-01-17 13:59:10.477
53 1 DB778
1051.00 926.00 .99 .42 2005-01-18 08:00:11.637
87 1 DB778
1051.00 929.00 .99 .54 2005-01-19 08:00:09.123
121 1 DB778
1051.00 932.00 .99 .66 2005-01-20 08:00:09.873
155 1 DB778
1051.00 936.00 .99 .54 2005-01-21 08:00:10.237
189 1 DB778
1051.00 940.00 .99 .66 2005-01-22 08:00:11.680
223 1 DB778
1051.00 937.00 2.99 .88 2005-01-23 08:00:15.493
257 1 DB778
1051.00 938.00 1.48 .55 2005-01-24 08:00:10.137
291 1 DB778
1051.00 947.00 .99 .60 2005-01-25 08:00:09.380
325 1 DB778
1051.00 965.00 .99 .56 2005-01-27 08:00:10.640
359 1 DB778
1051.00 994.00 .99 .69 2005-01-28 08:00:11.520
394 1 DB778
1051.00 1011.00 .99 .61 2005-01-29 08:00:14.120
429 1 DB778
1101.00 974.00 2.99 1.03 2005-01-30 08:00:10.823
464 1 DB778
1101.00 982.00 1.48 .50 2005-01-31 08:00:09.457
499 1 DB778
1101.00 1053.00 1.23 .62 2005-02-01 08:00:07.140
20 1 DB779
4366.00 4111.00 .99 .38 2005-01-17 13:59:10.477
54 1 DB779
4366.00 4111.00 .99 .38 2005-01-18 08:00:11.637
88 1 DB779
4366.00 4113.00 .99 .53 2005-01-19 08:00:09.123
122 1 DB779
4366.00 4114.00 .99 .55 2005-01-20 08:00:09.873
156 1 DB779
4366.00 4117.00 .99 .60 2005-01-21 08:00:10.237
190 1 DB779
4366.00 4118.00 .99 .60 2005-01-22 08:00:11.680
224 1 DB779
4366.00 4117.00 6.99 1.99 2005-01-23 08:00:15.493
258 1 DB779
4366.00 4117.00 2.99 .87 2005-01-24 08:00:10.137
292 1 DB779
4366.00 4118.00 1.99 .76 2005-01-25 08:00:09.380
326 1 DB779
4366.00 4136.00 .99 .53 2005-01-27 08:00:10.640
360 1 DB779
4366.00 4147.00 .99 .67 2005-01-28 08:00:11.520
395 1 DB779
4366.00 4170.00 .99 .56 2005-01-29 08:00:14.120
430 1 DB779
4416.00 4140.00 7.99 2.29 2005-01-30 08:00:10.823
465 1 DB779
4416.00 4140.00 .99 .34 2005-01-31 08:00:09.457
500 1 DB779
5916.00 5883.00 .99 .58 2005-02-01 08:00:07.140
21 1 DB780
744.00 631.00 5.99 .47 2005-01-17 13:59:10.477
55 1 DB780
744.00 631.00 .99 .34 2005-01-18 08:00:11.637
89 1 DB780
744.00 632.00 .99 .59 2005-01-19 08:00:09.123
123 1 DB780
744.00 633.00 .99 .56 2005-01-20 08:00:09.873
157 1 DB780
744.00 634.00 .99 .67 2005-01-21 08:00:10.237
191 1 DB780
744.00 634.00 .99 .55 2005-01-22 08:00:11.680
225 1 DB780
744.00 635.00 5.99 .47 2005-01-23 08:00:15.493
259 1 DB780
744.00 635.00 5.99 .63 2005-01-24 08:00:10.137
293 1 DB780
744.00 635.00 5.99 .71 2005-01-25 08:00:09.380
327 1 DB780
744.00 637.00 5.99 .77 2005-01-27 08:00:10.640
361 1 DB780
744.00 637.00 5.99 2.90 2005-01-28 08:00:11.520
396 1 DB780
744.00 638.00 5.99 1.23 2005-01-29 08:00:14.120
431 1 DB780
744.00 638.00 5.99 1.90 2005-01-30 08:00:10.823
466 1 DB780
744.00 638.00 5.99 .47 2005-01-31 08:00:09.457
501 1 DB780
744.00 642.00 3.49 2.81 2005-02-01 08:00:07.140
22 1 DB781
1190.00 996.00 5.99 .53 2005-01-17 13:59:10.477
56 1 DB781
1190.00 996.00 .99 .40 2005-01-18 08:00:11.637
90 1 DB781
1190.00 997.00 .99 .57 2005-01-19 08:00:09.123
124 1 DB781
1190.00 998.00 .99 .55 2005-01-20 08:00:09.873
158 1 DB781
1190.00 999.00 .99 .64 2005-01-21 08:00:10.237
192 1 DB781
1190.00 1001.00 .99 .53 2005-01-22 08:00:11.680
226 1 DB781
1190.00 1000.00 5.99 .47 2005-01-23 08:00:15.493
260 1 DB781
1190.00 1001.00 5.99 .57 2005-01-24 08:00:10.137
294 1 DB781
1190.00 1002.00 5.99 1.15 2005-01-25 08:00:09.380
328 1 DB781
1190.00 1004.00 5.99 1.82 2005-01-27 08:00:10.640
362 1 DB781
1190.00 1006.00 5.99 .70 2005-01-28 08:00:11.520
397 1 DB781
1190.00 1008.00 5.99 2.00 2005-01-29 08:00:14.120
432 1 DB781
1190.00 1007.00 5.99 .48 2005-01-30 08:00:10.823
467 1 DB781
1190.00 1007.00 .99 .35 2005-01-31 08:00:09.457
502 1 DB781
1190.00 1011.00 .99 .61 2005-02-01 08:00:07.140
23 1 DB784
851.00 724.00 5.99 .47 2005-01-17 13:59:10.477
57 1 DB784
851.00 724.00 .99 .34 2005-01-18 08:00:11.637
91 1 DB784
851.00 725.00 .99 .56 2005-01-19 08:00:09.123
125 1 DB784
851.00 726.00 .99 .52 2005-01-20 08:00:09.873
159 1 DB784
851.00 726.00 .99 .59 2005-01-21 08:00:10.237
193 1 DB784
851.00 727.00 .99 .52 2005-01-22 08:00:11.680
227 1 DB784
851.00 727.00 5.99 .47 2005-01-23 08:00:15.493
261 1 DB784
851.00 727.00 5.99 .63 2005-01-24 08:00:10.137
295 1 DB784
851.00 727.00 5.99 .82 2005-01-25 08:00:09.380
329 1 DB784
851.00 729.00 5.99 .55 2005-01-27 08:00:10.640
363 1 DB784
851.00 729.00 5.99 2.63 2005-01-28 08:00:11.520
398 1 DB784
851.00 730.00 5.99 2.81 2005-01-29 08:00:14.120
433 1 DB784
851.00 730.00 5.99 1.98 2005-01-30 08:00:10.823
468 1 DB784
851.00 730.00 5.99 .47 2005-01-31 08:00:09.457
503 1 DB784
851.00 738.00 3.49 2.08 2005-02-01 08:00:07.140
24 1 DB785
591.00 495.00 .99 .34 2005-01-17 13:59:10.477
58 1 DB785
591.00 495.00 .99 .34 2005-01-18 08:00:11.637
92 1 DB785
591.00 495.00 .99 .52 2005-01-19 08:00:09.123
126 1 DB785
591.00 496.00 .99 .56 2005-01-20 08:00:09.873
160 1 DB785
591.00 497.00 .99 .66 2005-01-21 08:00:10.237
194 1 DB785
591.00 497.00 .99 .55 2005-01-22 08:00:11.680
228 1 DB785
591.00 497.00 5.99 .47 2005-01-23 08:00:15.493
262 1 DB785
591.00 497.00 5.99 .65 2005-01-24 08:00:10.137
296 1 DB785
591.00 498.00 5.99 .60 2005-01-25 08:00:09.380
330 1 DB785
591.00 500.00 5.99 .78 2005-01-27 08:00:10.640
364 1 DB785
591.00 500.00 5.99 2.87 2005-01-28 08:00:11.520
399 1 DB785
591.00 501.00 5.99 .78 2005-01-29 08:00:14.120
434 1 DB785
591.00 501.00 5.99 1.45 2005-01-30 08:00:10.823
469 1 DB785
591.00 501.00 5.99 .47 2005-01-31 08:00:09.457
504 1 DB785
591.00 502.00 3.49 .60 2005-02-01 08:00:07.140
25 1 DB820
133.00 118.00 .99 .55 2005-01-17 13:59:10.477
59 1 DB820
133.00 118.00 .99 .67 2005-01-18 08:00:11.637
93 1 DB820
133.00 119.00 .99 .57 2005-01-19 08:00:09.123
127 1 DB820
133.00 119.00 .99 .56 2005-01-20 08:00:09.873
161 1 DB820
133.00 121.00 .99 .66 2005-01-21 08:00:10.237
195 1 DB820
133.00 121.00 .99 .54 2005-01-22 08:00:11.680
229 1 DB820
136.00 121.00 .99 .67 2005-01-23 08:00:15.493
263 1 DB820
136.00 121.00 .99 .59 2005-01-24 08:00:10.137
297 1 DB820
136.00 122.00 .99 .59 2005-01-25 08:00:09.380
331 1 DB820
136.00 124.00 .99 .52 2005-01-27 08:00:10.640
365 1 DB820
136.00 125.00 .99 .54 2005-01-28 08:00:11.520
400 1 DB820
136.00 126.00 .99 .60 2005-01-29 08:00:14.120
435 1 DB820
142.00 125.00 .99 .63 2005-01-30 08:00:10.823
470 1 DB820
142.00 125.00 .99 .68 2005-01-31 08:00:09.457
505 1 DB820
142.00 127.00 .99 .51 2005-02-01 08:00:07.140
26 1 DB859
92288.00 92048.00 13.49 .51 2005-01-17 13:59:10.477
60 1 DB859
92288.00 92048.00 .99 .51 2005-01-18 08:00:11.637
94 1 DB859
92288.00 92048.00 .99 .57 2005-01-19 08:00:09.123
128 1 DB859
92288.00 92050.00 .99 .52 2005-01-20 08:00:09.873
162 1 DB859
92288.00 92052.00 .99 .58 2005-01-21 08:00:10.237
196 1 DB859
92288.00 92054.00 .99 .70 2005-01-22 08:00:11.680
230 1 DB859
92288.00 92053.00 50.99 8.85 2005-01-23 08:00:15.493
264 1 DB859
92288.00 92054.00 13.49 .52 2005-01-24 08:00:10.137
298 1 DB859
92288.00 92055.00 13.49 5.08 2005-01-25 08:00:09.380
332 1 DB859
92288.00 92104.00 13.49 5.50 2005-01-27 08:00:10.640
366 1 DB859
92388.00 92362.00 13.49 1.32 2005-01-28 08:00:11.520
401 1 DB859
93288.00 93241.00 13.49 .93 2005-01-29 08:00:14.120
436 1 DB859
93488.00 93231.00 13.49 9.25 2005-01-30 08:00:10.823
471 1 DB859
93488.00 93242.00 13.49 .54 2005-01-31 08:00:09.457
506 1 DB859
95788.00 95757.00 13.49 8.86 2005-02-01 08:00:07.140
27 1 DB872
63891.00 63624.00 5.99 .63 2005-01-17 13:59:10.477
61 1 DB872
63891.00 63624.00 .99 .50 2005-01-18 08:00:11.637
95 1 DB872
63891.00 63624.00 .99 .55 2005-01-19 08:00:09.123
129 1 DB872
63891.00 63626.00 .99 .61 2005-01-20 08:00:09.873
163 1 DB872
63891.00 63626.00 .99 .56 2005-01-21 08:00:10.237
197 1 DB872
63891.00 63627.00 .99 .68 2005-01-22 08:00:11.680
231 1 DB872
63891.00 63627.00 10.99 1.65 2005-01-23 08:00:15.493
265 1 DB872
63891.00 63627.00 5.99 .66 2005-01-24 08:00:10.137
299 1 DB872
63891.00 63627.00 .99 .60 2005-01-25 08:00:09.380
333 1 DB872
63891.00 63677.00 .99 .62 2005-01-27 08:00:10.640
367 1 DB872
63941.00 63925.00 .99 .63 2005-01-28 08:00:11.520
402 1 DB872
64391.00 64369.00 .99 .53 2005-01-29 08:00:14.120
437 1 DB872
64641.00 64364.00 10.99 1.76 2005-01-30 08:00:10.823
472 1 DB872
64641.00 64364.00 8.49 .55 2005-01-31 08:00:09.457
507 1 DB872
64641.00 64500.00 .99 .53 2005-02-01 08:00:07.140

Hi,

I have a series of sales annual sales figures and I would like to determine the average growth rate, be it positive or negative. I've tried the XIRR function but can't seem to make it work. Does anyone else have any suggestions? A sample is included below:

3,549,233 30-Jun-08
2,200,158 30-Jun-07
2,091,082 30-Jun-06
1,197,515 30-Jun-05
1,119,110 30-Jun-04

Thanks in advance,

droddis