How do I estimate the year spend if spend is $26000 as of May?

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
<FeliciaPickett@discussions.microsoft.com> 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" <FeliciaPickett@discussions.microsoft.com> wrote in
message news:C9EF8F1C-FA3F-4F13-90A9-AF67D5051139@microsoft.com...
> 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.