Calendar Year Changes

We had a support request through looking at putting a Calendar Year set of financial statements into a monthly model, where the financial year end is a non-December month.

There are a couple of approaches to this, depending on what exactly is required.

1. Annual Summary Dashboard

The simplest approach is to insert an Annual Summary Dashboard module and amend the Dashboard Source Data logic. Replace any formula references from DD_Ts_Fin_Yr_End_Mth to Ts_Mths_In_Yr, which essentially hard-wires this data sourcing to 12, i.e. the month of December.

The attached file has this example included. NB: when putting the changes through your own model, you can use HOME / FIND functionality to identify which formulae to change.

This is the simpler option, as it does not involve any new period title set changes.

2. Period Title Set Changes

Where more integrated calendar year analysis is required, such as calendar year assumption entry, a new period title set would need to be created, ideally leveraging the existing Annual period title set, by creating a Duplicate:

Labelling this up accordingly:

This new time series period title set can again be updated with the same formula replacement process as mentioned at the top, essentially swapping the DD_Ts_Fin_Yr_End_Mth for the Ts_Mths_In_Yr reference.

There are some subtleties around column count for this new period title set, also shown in the attached, with a new range TS_Cal_Yrs essentially adding an additional year to the TS_Yrs count - a simplistic but reasonable assumption to make.

Changes are marked up as WIP Yellow in the attached example.

Cheers. J.