To build reporting system and obtain data for decisions, you need to know this:
YTD (Year-To-Date) - the most used. Describes a period, from the first day of current year, and up to the present day. Progressive one: upgrades every day you creating report.
Example: today is 7th of February. YTD counts January and 7 days of February = 38 days of current year.
YTD-1 the same as YTD but year before current one.
YTD vs YTD-1: very representative comparison. Useful when targets are annual. Shows performance this vs last year (like-for-like). "Like-for-like" means: we comparing apples vs apples, seasonality rate is excluded.
Example: (38 days from 1st Jan this year / 38 days from 1st Jan) -1= % of growth/change.
MAT (Moving Annual Total) - finance and marketing guys adore this one. MAT is moved back and sum 12 period from current month. Very useful and tricky: you need to know all facts driving it month-by-month.
Example: today is 02/07/15. We take only full months. Jan'15 + Dec'14 + Nov'14 + Oct'14 + Sep'14 + Aug'14 + Jul'14 + Jun'14 + May'14 + Apr'14 + Mar'14 + Feb'14 = MAT.
MAT -1. By analogy with YTD-1. Not this year but year before current. Do not exclude seasonality but gives right spot to comparison vs MAT.
Example: Jan'14 + Dec'13 + Nov'13 + Oct'13 + Sep'13 + Aug'13 + Jul'13 + Jun'13 + May'13 + Apr'13 + Mar'13 + Feb'13.
MAT vs MAT-1. When you have data for it - its brilliant! Update is every month and you will have strong picture of performance.
Example: by analogy to YTD vs YTD-1
Rarely used:
QTD vs QTD-1/2/3 (quarter-to-day) - for targets based on quarter results
MQT vs MQT-1/2/3 (moving quarter total) - quick glance on your quarter performance
Very handy:
TM vs TM -1 : this month versus last month. Full month to full month. Be careful with seasonality and fluctuations
Example: Jan'15 vs Dec'14
RR 3M vs RR 6M (running rate 3 months vs running rate 3 months ) - my favourite one. Was stolen from finance manager ;-) shows health of you performance by comparing different periods. One include another.
Example: (Jan'15 + Dec'14 + Nov'14) / (Jan'15 + Dec'14 + Nov'14 + Oct'14 + Sep'14 + Aug'14)
Interesting fact:
Nasdaq YTD and Dow Jones YTD periods calculation comes from basis analysis and reporting.
Read more on this topic:
Example: today is 7th of February. YTD counts January and 7 days of February = 38 days of current year.
YTD-1 the same as YTD but year before current one.
YTD vs YTD-1: very representative comparison. Useful when targets are annual. Shows performance this vs last year (like-for-like). "Like-for-like" means: we comparing apples vs apples, seasonality rate is excluded.
Example: (38 days from 1st Jan this year / 38 days from 1st Jan) -1= % of growth/change.
MAT (Moving Annual Total) - finance and marketing guys adore this one. MAT is moved back and sum 12 period from current month. Very useful and tricky: you need to know all facts driving it month-by-month.
Example: today is 02/07/15. We take only full months. Jan'15 + Dec'14 + Nov'14 + Oct'14 + Sep'14 + Aug'14 + Jul'14 + Jun'14 + May'14 + Apr'14 + Mar'14 + Feb'14 = MAT.
MAT -1. By analogy with YTD-1. Not this year but year before current. Do not exclude seasonality but gives right spot to comparison vs MAT.
Example: Jan'14 + Dec'13 + Nov'13 + Oct'13 + Sep'13 + Aug'13 + Jul'13 + Jun'13 + May'13 + Apr'13 + Mar'13 + Feb'13.
MAT vs MAT-1. When you have data for it - its brilliant! Update is every month and you will have strong picture of performance.
Example: by analogy to YTD vs YTD-1
Rarely used:
QTD vs QTD-1/2/3 (quarter-to-day) - for targets based on quarter results
MQT vs MQT-1/2/3 (moving quarter total) - quick glance on your quarter performance
Very handy:
TM vs TM -1 : this month versus last month. Full month to full month. Be careful with seasonality and fluctuations
Example: Jan'15 vs Dec'14
RR 3M vs RR 6M (running rate 3 months vs running rate 3 months ) - my favourite one. Was stolen from finance manager ;-) shows health of you performance by comparing different periods. One include another.
Example: (Jan'15 + Dec'14 + Nov'14) / (Jan'15 + Dec'14 + Nov'14 + Oct'14 + Sep'14 + Aug'14)
Interesting fact:
Nasdaq YTD and Dow Jones YTD periods calculation comes from basis analysis and reporting.
Read more on this topic:
that is a brilliant article. thanks
ReplyDelete