How can I tweak Cashflow Plan to handle cashflows which are exceptional or out-of-synch with expenses?
With Cashflow Plan, you can defer payment of 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 DirCost and Ohead worksheets. This means, for example, that you can show an item as an expense in January but defer payment until May. If you need to handle exceptional cashflows relating to capital or operating expense items, use the variables Changes (+/-) in Prepayments or Changes (+/-) in Accruals in the Fund worksheet 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 Fund and then trace its impact in the Monthly Cashflows and Balance Sheets. Instead of entering simple numeric values in Fund, you could write complex formulae to link the changes in prepayments or accruals to variations in other variables.
