I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

Not quite sure what you mean? You have $26,000 to spend as of May 1st 2006,
you want to know how much you can spend per month? (Maybe I just don't know
the meaning of the word annualize. :O) )

"Felicia Pickett" wrote:

I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

Assuming end of May you have spent 26000

=12/5*26000 returns 62400


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 16:27:02 -0700, Felicia Pickett
wrote:

I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

Maybe.........

=(26000/5)*12

If you have spent 26000 in five months, at that same rate, you will spend
62400 by the end of the year.

Vaya con Dios,
Chuck, CABGx3


"Felicia Pickett" wrote in
message ...
I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

Felicia Pickett wrote:
I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?

Beware of simply extrapolating that amount linearly by multiplying by
12/5. Take a close look at your expense patterns. For example, we
choose to pay property tax just once in the second half of the year.