How can I tweak Exl-Plan to handle cashflows which are exceptional or out-of-synch with expenses?
If using the Pro, Super, Super Plus, Ultra or Ultra Plus versions, you can defer payment of most expense items for up to four months by inserting integers (1, 2, 3 or 4) in the boxed single cells adjacent to the variable descriptions in the M_C and M_O sheets. This means, for example, that you can show an item as an expense in January but defer payment until May. If you are using Micro or Lite (or need to handle exceptional cashflows relating to capital or operating expense items in Pro, Super, Super Plus, Ultra or Ultra Plus), use the variables Changes (+/-) in Prepayments or Changes (+/-) in Accruals in the M_F sheet to either accelerate or defer the related cash payments. To see how this works, enter a single easily recognizable value as a change in prepayments or accruals in M_F and then trace its impact in the Monthly Cashflows and Balance Sheets. Instead of entering simple numeric values in M_F, you could write complex formulae to link the changes in prepayments or accruals to va
