Cash Flow

This page enables users to download a Cash Flow Worksheet. When downloaded, the worksheet is pre-filled with specific information from the FEAT scenario such as revenues and expenses.

To download the Worksheet, users need to click on the ‘Download Worksheet’ button and save the file to a familiar folder on their computer.

To complete the Cash Flow Worksheet, users need to open the file and:

Farm Income

1. Enter the Delivery Advances of sugar ($/t) for the corresponding month (e.g. $285 in July, $0 in August and September, $10 in October, etc.);
2. Enter the percent of cane crop delivered (and paid) in each month over the harvest season;
3. Allocate percentages of ‘Other Crops’ and ‘Other Income’ (if applicable) to the corresponding months over the financial year. For example, if 100% of ‘Other Crop’ income is received in March then enter 100 in March and leave zero in the other months. This will allocate all of the Other Crop income to March;

1. Allocate percentages of ‘Variable Costs’ and ‘Fixed Costs’ to the corresponding months over the financial year. For example, if approximately 25% of fertiliser costs are paid in August, September, October and November then enter 25 into each of these months and leave the other months zero;
2. Enter total Investment Sales and Purchases into the total column (B) and allocate percentages of Sales and Purchases to the corresponding months over the financial year;
3. Enter money coming into the business, via ‘New Borrowings’, ‘Contribution from Owners’ and ‘Interest Earned’ (under Finance heading), in each month over the financial year.
4. Enter money going out of the business, via ‘Loan Repayments’ and ‘Drawings’ (under Finance heading), in each month over the financial year.
5. The next section will show all outgoing (expenses) and incoming (income) for the corresponding month over the financial year.
6. Add in last year’s final balance if applicable.
7. Navigate to the sheets ‘Cash Flow (Yr 2)’ and ‘Cash Flow (Yr 3)’ if you wish to fill out those years.
8. Navigate to ‘Cash Flow Summary’ to see a summary for each year.

Cane Sensitivity ⇐ OR Other Crop Sensitivity ⇐|⇒ Optimum Ratoons