F
Felicia Pickett
I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?
total spend based on this information?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How do I estimate the year spend if spend is $26000 as of May?
T
tim m
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) )
you want to know how much you can spend per month? (Maybe I just don't know
the meaning of the word annualize. :O) )
G
Gord Dibben
Assuming end of May you have spent 26000
=12/5*26000 returns 62400
Gord Dibben MS Excel MVP
=12/5*26000 returns 62400
Gord Dibben MS Excel MVP
C
CLR
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
=(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
J
joeu2004
Felicia said: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.