Refreshing the Cash-Data sheet

Click the Refresh icon

Demonstrating how amounts are spread within the time frame

Test the different options of Spreading of Amounts. Cash Data

Adding expenses from the overhead using formulas

The descriptions and amounts may derive from the Sheet of Sales thru formulas

Entering Cash-In

Income is derived from Invoicing.

Dynamically calculate interests and financial expenses

A rate that differs whether the total is positive or negative is applied to the Overall Cash Flow.

Taking interests and financial expenses into account using iterations

The rate (in percent) can further depend on the final amount thru a formula, hence iterations.

Taking options into account in cash

Check the Include the Optional Area box atop.