In Excel, how do you annualize data?

  • Thread starter Thread starter JanSanM
  • Start date Start date
J

JanSanM

I am keeping a log of cases done per month, and need to annualize each month
to forecase yearly volume. I am looking for the way to build the formula to
Annualize.
 
One simple way
Assume monthly figs are progressively entered in B2 across
In C2: =AVERAGE($B2:B2)*12
Copy C2 across to return desired yearly forecast

High-five? Click YES below

P/s: Rather than here, post such questions in excel.worksheet.functions
which is a more appropriate and better attended newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
 
Back
Top