View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Annualize/ Estimate year-to-date from monthly expense

With the information you gave, you would simply multiply by 12.

You wouldn't have to estimate year-to-date expenses, you should have them. You
can estimate rest-of-the-year expenses by: TotalToDate / NumberOfMonths * (13 -
NumberOfMonths)
--
Regards,
Fred


"Positive" wrote in message
ups.com...
For example I have $500 for June operating expense. How do i annulaize
it? Or how do I estimate year to date expense.
Thanks