“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

How to model partial period factors

Events in the real world have an annoying habit of not occurring on your financial model period end dates. This modelling guide gives you reusable code to calculate partial period factors. This will allow you to easily deal with events that occur in between period end dates.


  1. My question is on your recommendation in this chapter on avoiding EOMONTH function. You are mentioning that it is causing problems with the Analysis ToolPack. Could you please elaborate on that? Does this mean that we should put EOMONTH function in the category of Excel functions to avoid? Thanks.

Help make the handbook better