Our Excel skills book is available on AmazonSee the book

Financial modelling Assessment

Q1 of 50

A model is being restructured: Currently it works with yearly intervals. The intervals should change to quarterly. However, intervals might need to change again to monthly. To accommodate any size of interval it is decided to name a range PPY (periods per year) and have that range control the time stepping in the model.

What would be a suitable formula to advance dates in the model:

  • A) =EOMONTH(..., PPY)
  • B) =EOMONTH(.., PPY/12)
  • C) =EOMONTH(..., 12/PPY)

 A     B     C